Rahul Ambargonda

About Rahul Ambargonda

About Me | Financial Analyst | FP & A | Healthcare & Investment BankingI am a finance professional with 5+ years of experience across healthcare finance and investment banking, specializing in forecasting, financial modeling, variance analysis, and capital allocation.I partner closely with finance, actuarial, clinical, and operations teams to turn complex financial and operational data into clear, decision-ready insights that drive measurable business impact.What I do best:Build forecasting models grounded in logic, data, and real operational driversEvaluate ROI, break-even economics, and capital deployment decisionsReconcile high-volume expense and cost data to support recovery and audit readinessAutomate reporting and dashboards to improve visibility and reduce manual effortMy work has supported:$8M+ in healthcare and investment initiatives$1.55M+ in strategic cost reallocation and recovery35–60% reduction in manual reporting through SQL and Power BI automationI bring a strong foundation in core finance (DCF, LBOs, P&L, budget vs. actuals) combined with technical fluency in Excel, SQL, Power BI, and forecasting systems.I don’t just report numbers I help stakeholders understand what’s driving performance, where risk sits, and what action to take next.

Experience

1. Financial Analyst

   Humana

   Jan 2024 — Present · US

   Integrated finance, claims, and operational datasets to support expense reconciliation and validation, improving monthly reporting accuracy and cost recovery outcomes. Performed DCF, break-even, and ROI analyses for telehealth pilots and pharmacy benefit redesigns, supporting investment decisions on initiatives exceeding $8M. Developed Excel- and SQL-based forecasting models for Medicare and Medicaid portfolios, incorporating seasonality and member growth to improve forecast precision and prevent $190K in budget leakage. Partnered with actuarial and clinical finance teams to evaluate chronic care and value-based program ROI, enabling $1.4M in strategic reallocation toward high-impact population health initiatives. Led monthly variance analysis across claims, rebates, and overhead expenses, identifying $420K in deviations and enabling targeted corrective actions across multiple business units. Reconciled high-volume, multi-source cost and expense data, supporting large-scale expense recovery initiatives through advanced Excel and SQL analysis. Ensured GAAP-compliant accounting treatment for deferred costs and program accruals, strengthening audit readiness during quarter-end close cycles.

Education

• Chaitanya Deemed to be University

  Bachelor's degree, Accounting and Finance

• Indiana Wesleyan University

  Master's degree, Information Technology