Jonathan Smolensky
Pittsburgh
Summary
Data-driven Financial Analyst with expertise in leveraging Power BI and PowerApps to transform financial reporting and automate complex processes. Adept at creating dynamic dashboards that deliver real-time insights and improve analyst productivity. Skilled in budget analysis, data visualization, and workflow automation using Excel, Power BI, and Power Automate. Proven ability to collaborate cross-functionally and drive process improvements that enhance operational efficiency.
Overview
2
2
years of professional experience
Work History
Finance Professional
Naval Nuclear Laboratory
West Mifflin
08.2024 - Current
- Designed and implemented a comprehensive Power BI dashboard to provide real-time insights and improve data accessibility, enabling efficient data-driven decision-making.
- Compiled and prepared monthly financial reports utilizing advanced Excel techniques to enhance accuracy and streamline workflow.
- Developed and maintained PowerApps solutions to automate financial and administrative processes, reducing manual effort and errors, while increasing operational efficiency.
- Coordinate and communicate critical financial reporting deadlines and funding schedules across teams to ensure timely submission and compliance with project requirements.
Financial Analyst - Internship
Naval Nuclear Laboratory
West Mifflin
06.2023 - 08.2023
- Gained hands-on experience with financial reporting processes and developed familiarity with Oracle financial systems used in budgeting and funding operations within a government contractor environment.
- Facilitated improved workflow efficiency by automating Excel spreadsheets used in monthly reporting.
- Assisted in the development and testing of PowerApps to facilitate process automation.
- Delivered a formal presentation summarizing internship projects, process improvements, and key takeaways to peers and senior staff.
Volunteer Income Tax Assistant
Just Harvest
Pittsburgh
12.2022 - 04.2023
- Prepared federal and state tax returns for low-income individuals and families as part of the IRS VITA program, ensuring accuracy and compliance with tax regulations.
- Assisted clients by gathering financial information, answering questions, and clearly explaining filing procedures, while maintaining professionalism and confidentiality.
- Gained hands-on experience in financial documentation, tax law application, and client-focused service through direct volunteer work.
Education
BBA - Finance
University of Pittsburgh
Pittsburgh, PA04-2024
Skills
- Advanced: Excel, Power BI, Power Apps, and Power Automate
- Proficient: SQL, R, Tableau
- Familiar: Python, MongoDB, Oracle
- Data storytelling
- Financial modeling
- Data cleaning and preparation
Timeline
Finance Professional
Naval Nuclear Laboratory
08.2024 - Current
Financial Analyst - Internship
Naval Nuclear Laboratory
06.2023 - 08.2023
Volunteer Income Tax Assistant
Just Harvest
12.2022 - 04.2023
BBA - Finance
University of Pittsburgh
Similar Profiles
Maxwell LangnerMaxwell Langner
Reactor Operations Engineer at Naval Nuclear LaboratoryReactor Operations Engineer at Naval Nuclear Laboratory
Joe Centobene IIIJoe Centobene III
Mechanical Engineer at Naval Nuclear Laboratory (FMP)Mechanical Engineer at Naval Nuclear Laboratory (FMP)
James FerrickJames Ferrick
Senior Advisor Engineer at Naval Nuclear LaboratorySenior Advisor Engineer at Naval Nuclear Laboratory
Ty'aana WallaceTy'aana Wallace
Server/Server Trainer/Bartender at Olive Garden RestaurantServer/Server Trainer/Bartender at Olive Garden Restaurant
Maddie SalkeldMaddie Salkeld
PT Observer at IMPACT Sports Physical TherapyPT Observer at IMPACT Sports Physical Therapy