Shourya Bhardwaj
Phoenix,AZ
Summary
Results-oriented Business Analyst with experience leveraging healthcare and financial data to drive strategic decisions and cost efficiencies. Adept at transforming complex datasets into actionable insights through SQL, SAS, and Excel. Skilled in stakeholder engagement, modeling, and process automation, with a proven track record in government consulting, pharmaceuticals, and payer-provider environments.
Driven and analytical professional with keen eye for detail and problem-solving abilities. Possesses strong understanding of data analysis methodologies and skilled in utilizing statistical software and tools. Aims to leverage analytical skills to drive impactful data-driven decisions.
Overview
2
2
years of professional experience
Work History
SENIOR ANALYST
Mercer (Marsh McLennan)
07.2023 - Current
- Lead business analysis and modeling for Medicaid rate setting, reimbursement design, and policy evaluations for state health agencies.
- Developed financial models using SAS and Excel, reducing projected Medicaid expenditures by up to 7%.
- Built executive dashboards and reports synthesizing claims, GL, and MCO financial data, improving transparency for state leaders.
- Collaborated with actuaries and policy experts to document assumptions, gather requirements, and model fiscal scenarios.
- Automated key reporting workflows using SQL and VBA, slashing delivery time by 50% and boosting audit traceability.
- Performed root cause analysis and cost center evaluations that informed policy revisions and improved provider reimbursements.
SALES & OPERATIONS ANALYST INTERN
Change Healthcare
06.2022 - 08.2022
- Analyzed provider and payer data to uncover geographic expansion opportunities, influencing regional sales strategies that improved outreach efficiency.
- Developed SQL-driven forecasting models to improve territory planning and resource allocation across sales divisions.
- Created integrated dashboards consolidating KPIs from CRM, finance, and claims data, supporting C-suite reviews and performance management discussions.
INFORMATION SYSTEMS INTERN
Boehringer Ingelheim
06.2021 - 08.2021
- Automated clinical research reporting via Excel Macros and Power Automate, streamlining global project tracking.
- Created interactive dashboards to track trial performance, enhancing team collaboration and visibility.
- Identified process inefficiencies and recommended automation solutions, improving delivery timelines.
Education
B.S. - Business & Information Technology
Virginia Tech
Skills
- Advanced Excel
- SQL
- SAS
- Python
- Cost-Benefit Analysis
- Forecasting
- Budget Modeling
- Excel VBA
- Power Automate
- Requirements Gathering
- Stakeholder Engagement
- Agile Practices
- Client management
- Data analysis
- Report preparation
Technical Skills
Advanced Excel, SQL, SAS, Python, Cost-Benefit Analysis, Forecasting, Budget Modeling, Excel VBA, Power Automate, Requirements Gathering, Stakeholder Engagement, Agile Practices
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Languages
English
Native or Bilingual
Spanish
Full Professional
Hindi
Professional Working
French
Limited Working
Timeline
SENIOR ANALYST
Mercer (Marsh McLennan)
07.2023 - Current
SALES & OPERATIONS ANALYST INTERN
Change Healthcare
06.2022 - 08.2022
INFORMATION SYSTEMS INTERN
Boehringer Ingelheim
06.2021 - 08.2021
B.S. - Business & Information Technology
Virginia Tech
Similar Profiles
Joseph MahrJoseph Mahr
Senior Analyst at Mercer - Marsh & McLennan / AptiaSenior Analyst at Mercer - Marsh & McLennan / Aptia
.jpeg&q=70 "Yash Mehta")
Yash MehtaYash Mehta
Actuarial Analyst at Mercer, Marsh McLennan CompaniesActuarial Analyst at Mercer, Marsh McLennan Companies
Sushma ShekhawatSushma Shekhawat
Principal-Software Development Engineer at Mercer Consulting Ltd. (Marsh McLennan)Principal-Software Development Engineer at Mercer Consulting Ltd. (Marsh McLennan)
Alexis MescedaAlexis Mesceda
Medical Assistant/Surgery Scheduler at Far North Surgery and Surgical OncologyMedical Assistant/Surgery Scheduler at Far North Surgery and Surgical Oncology
JESSICA BOEHMERJESSICA BOEHMER
Power of Attorney at Private CaretakerPower of Attorney at Private Caretaker