Aug 2024 – Aug 2025 · 1 yr · Bengaluru, Karnataka, India · Hybrid

• Part of the Consulting team Performing actuarial valuations of employee benefit obligations supporting financial reporting under US GAAP, AS
• 15 (Revised), Ind AS 19, and IAS 19
• Built and maintained complex Excel based actuarial valuation models incorporating dynamic assumption inputs,
• macro driven automation, lookup logic, and error checking frameworks to ensure computational integrity and audit
• traceability
• Developed Excel tools for automated roll forward reconciliations, liability movement analyses, and sensitivity testing across
• multiple scenarios, significantly reducing manual effort and increasing consistency across client deliverables
• Applied the Projected Unit Credit Method using Excel to project benefit obligations, factoring in discount rates, salary
• escalation, employee turnover, and mortality assumptions
• Conducted assumption setting, data cleansing, and benefit scheme analysis with rigorous version control and
• documentation, ensuring compliance with regulatory and internal audit standards
• Collaborated with auditors, corporate controllers, and finance teams to support disclosures and internal review processes,
• with a focus on reconciling actuarial estimates with financial statements
• Strengthened understanding of actuarial risk management principles, cost volatility, and long term financial exposure related
• to employee benefits, contributing to strategic advice on funding and scheme design
• Gained working knowledge of client-specific HR and payroll data systems, enhancing the ability to translate raw inputs into valuation ready formats using advanced Excel data handling techniques