Varun Kholia

IFRS 17 Implementation – Led UAT and validated model outputs to ensure alignment with IFRS 17 requirements.

IFRS 17 & Solvency II in Qlik – Led migration of Excel-based processes to Qlik using the D22 framework.

Plan A –Transfer of Unitised products from Prophet to Smart.

Project Watch – Migration of AIG product lines into Smart.

• Contributed to end-to-end IFRS 17 reporting processes for major UK Life Insurance client.
• Executed detailed run log checks, ensuring accurate processing of products and policies across P&L calculations.
• Utilized Prophet and SMART tools for data extractions supporting valuation and reporting needs.
• Conducted Analysis of Change with detailed assessments on demographic and economic impacts of releases and restatements.
• Performed bridging analysis from Solvency II to IFRS 17 to validate reserve movements and enhance financial transparency.

• End-to-End Assumption & Results Management: Managed full Prophet modeling lifecycle, updating economic/demographic bases and validating results for Roll Forward, Restate & Release, and RA/PAD calculations.
• Automation & Sensitivity Analysis: Used macro-driven tools to generate basis files and performed P&L and sensitivity analysis, improving efficiency and data accuracy.
• Impact Assessment & Client Communication: Conducted impact assessments to validate financial movements and presented key model insights to clients for decision support.

• Produced detailed monthly movement analysis reports, clarifying variances for accurate reporting.
• Executed data reconciliation and consistency checks, validating integrity of actuarial datasets.
• Resolved complex data discrepancies, determining root causes to maintain high quality in actuarial models.

• Verified documents for employee insurance applications as Junior Underwriter in Logging Team.
• Entered details such as employee count, effective date, policy type, and broker information into SFDC.
• Served as Provider Service Analyst in PCM team, creating contracts between insurance companies and hospitals.