Stephen Lewis
Johnstown,PA
Summary
Results-driven professional with extensive experience in the healthcare industry, specializing in SQL reporting and financial analysis. Proven track record in enhancing decision-making through Power BI dashboards and process improvements. Strong attention to detail and excellent communication skills foster collaboration across teams, driving strategic initiatives and optimizing financial performance.
Overview
9
9
years of professional experience
Work History
Manager, Decision Support
Heritage Valley Health System
03.2025 - Current
- Oversee and develop SQL-based reporting and ad hoc analytics to support executive and departmental decision-making.
- Design and maintain Power BI dashboards that visualize key metrics across revenue, cost, and operational performance.
- Conduct healthcare reimbursement analyses, including cost report reviews, payer mix studies, and rate variance evaluations.
- Partner with Finance and Operations teams to lead budgeting, forecasting, and labor productivity analysis.
- Evaluate revenue capture opportunities and recommend process improvements to maximize financial performance.
- Perform comprehensive financial analysis, including margin, cost, and variance reporting, to inform strategic planning and resource allocation.
- Collaborate cross-functionally with IT, Accounting, and Operations to ensure data integrity and enhance enterprise reporting capabilities.
- Leverage SQL, Power BI, Excel, and data visualization tools to automate reporting and streamline decision support workflows.
Senior Financial Analyst
Heritage Valley Health System
09.2022 - 03.2025
- Analyzed financial data to support budget development and forecasting initiatives.
- Developed financial models to assess operational performance and identify cost-saving opportunities.
- Collaborated with cross-functional teams to streamline reporting processes and enhance accuracy.
- Presented actionable insights to senior management for strategic decision-making and resource allocation.
Data Integrity Coordinator
LifePoint Health
09.2016 - 08.2021
- Collaborated with cross-functional teams to resolve data discrepancies and streamline reporting.
- Developed and implemented data validation processes to enhance integrity and reliability.
- Led initiatives to optimize data collection workflows, increasing efficiency in information retrieval.
- Managed complex projects involving large datasets, maintaining accurate records throughout the project lifecycle.
- Enhanced data accuracy by implementing strict validation processes and protocols.
Education
Bachelor of Arts - Accounting
University of Pittsburgh
Johnstown, PA12.2010
Skills
- SQL reporting
- Healthcare Finance
- Power BI dashboards
- Financial modeling and analysis
- Budgeting and forecasting
- Attention to detail
- Excellent communication
- Data analysis
- Process improvement
Timeline
Manager, Decision Support
Heritage Valley Health System
03.2025 - Current
Senior Financial Analyst
Heritage Valley Health System
09.2022 - 03.2025
Data Integrity Coordinator
LifePoint Health
09.2016 - 08.2021
Bachelor of Arts - Accounting
University of Pittsburgh