Open to opportunities

Sandeep Kumar Yamsani

@sandeepkumaryamsani

Financial analyst specializing in healthcare risk pool, capitation reporting, and claims cost modeling with advanced SQL and Power BI.

United States

Message

What I'm looking for

I’m looking for a healthcare finance role where I can own risk pool/capitation reporting, automate SQL + Power BI insights, and collaborate with clinical and finance stakeholders to improve accuracy, forecasting, and executive decision-making.

I’m a results-driven Hospital Financial Analyst with 5 years of progressive experience specializing in risk pool reporting, capitation analysis, and claims cost modeling in healthcare finance. I prepare and automate financial reporting such as IBNR models, lag reports, and cash flow reconciliations—using SQL, Power BI, and Excel—to support decisions for MSOs and hospital leadership.

I’ve led capitation and paid-claims reporting, built automated risk pool summaries by health plan/LOB/aid category, and developed optimized SQL Server queries to extract, validate, and reconcile large healthcare datasets. Across roles, I’ve created executive-ready EOM board packages and dashboards, performed claims trend and variance analysis, maintained HIPAA/SOX-aligned data integrity, and streamlined workflows with automation (including reducing manual processing errors by 60%).

Experience

Work history, roles, and key accomplishments

Current

Financial Analyst

Current

MedPoint Management

Jul 2025 - Present (9 months)

Led hospital risk pool financial, clinical, and operational analysis, preparing monthly capitation, paid claims, lag reports, and IBNR models to quantify financial exposure. Built automated risk pool summaries and executive-ready Power BI dashboards, improving reporting accuracy through HIPAA-compliant data validation.

Risk Pools Capitation SQL Server Power BI Data Validation Healthcare Finance

Financial Analyst

Medtronic

Jan 2025 - Jul 2025 (6 months)

Developed and automated hospital capitation and lag reporting using SQL Server and Power BI to support accurate IBNR reserve projections. Built automated reporting pipelines for daily cash flow monitoring and monthly reconciliations, reducing manual processing errors by 60%.

Capitation SQL Server Power BI DAX Excel Macros Power Query Lag Reports Financial Reporting

Financial Analyst

Cigna Healthcare

Feb 2024 - Nov 2024 (9 months)

Produced and distributed monthly risk pool reports and provider claim trend summaries using Oracle and SQL Server for hospital clients. Automated IBNR estimations and delivered ad hoc reporting with Excel, Access, and Power BI, while training stakeholders to interpret dashboards.

Risk Pools Claims Trends Oracle SQL Server Power BI Excel IBNR Estimates Ad Hoc Reporting

Financial Analyst

EY GDS (Global Delivery Services)

Jan 2020 - Dec 2022 (2 years 11 months)

Conducted financial and claims analytics for multi-payer healthcare clients, supporting risk pool performance assessments, budgeting, and cost forecasting. Built Power BI/Tableau dashboards and automated Excel/SQL models for monthly claim costs, lag reports, and IBNR estimates, ensuring audit-ready, HIPAA/SOX-aligned reporting.

Power BI Tableau IBNR Estimates SQL Risk Pools Lag Reports