Pranay Garg

Financial Analyst @Bain Capital

Built driver-based LBO and DCF models and refreshed WACC with Bloomberg, improving underwriting accuracy and valuation signals by 25%.•Introduced standardized scenario playbooks in Workday Adaptive Planning and Anaplan, reducing reforecast turnaround time by 20%+.• Automated monthly investment packs with an SQL to Snowflake data pipeline and Tableau and Power BI dashboards, cutting report refresh time by 35%.• Developed liquidity, covenant, and risk-adjusted return dashboards aligned with GAAP and SOX controls, improving pre-approval risk visibility for executive reviews.• Administered the Adaptive Planning model for forecasts and the annual plan, strengthening data governance and reducing spreadsheet rework across finance stakeholders.• Led workforce planning integrated with Workday, aligning hiring ramps and compensation with budget capacity and decreasing mid cycle headcount corrections.• Ran a twelve- to eighteen-month rolling forecast anchored to pricing, conversion, productivity, and mix drivers, lowering surprise variances between closes.• Orchestrated the annual operating plan and three-year long-range plan with a defined calendar and RACI, accelerating cross-functional alignment and decision speed.