Varun Kholia
Deputy Manager
I-29 Sector-22 ,Noida
Summary
Detail-oriented actuarial professional with over 6 years of experience in insurance, healthcare, and IFRS 17 reporting. Proficient in Prophet Diagram Viewer, Excel, Qlik Sense, and data reconciliation. Demonstrated expertise in analyzing and interpreting financial data, conducting sensitivity analysis, and spearheading regulatory compliance initiatives. Skilled at fostering cross-functional collaboration and effectively communicating with stakeholders.
Overview
6
6
years of professional experience
3
3
years of post-secondary education
Work History
Deputy Manager
WNS Global Services Pvt. Ltd.
06.2021 - Current
- Prepared quarterly reports for Analysis of Change (AoC) in reserves, using Prophet Diagram Viewer.
- Validated assumptions and adjustments across Solvency II and IFRS 17 frameworks.
- Performed profitability group analysis, new business reporting, and coverage unit assessments.
- Conducted sensitivity analyses on interest rate changes and their impact on reserves.
- Generated monthly actuarial data and performed reconciliation from multiple source systems.
- Delivered key presentations on analysis outcomes to stakeholders.
- Reviewed Results & Basis documentation, ensuring completeness and compliance.
- Mentored new team members and contributed to training material development.
- Key Projects:
- IFRS 17 Implementation: Performed UAT and validated model outputs to ensure alignment with IFRS 17 standards.
- IFRS 17 and SII in Qlik: Migrated Excel-based processes into Qlik using the D22 framework.
- Plan A: Transferred all Unitised products from Prophet to Smart.
- Project Watch: Migrated AIG product lines into Smart.
Reporting Analyst – Healthcare Department
EXL Service Pvt. Ltd.
New Delhi
07.2019 - 06.2021
- Acted as Junior Underwriter, verifying insurance documentation and data entry into Salesforce.
- Supported contract creation using PCM, Vizzini, CPD, and MCPS tools.
Education
B.Sc (Hons) - Mathematics
Delhi University
Delhi 01.2015 - 01.2018
Skills
- Qlik Sense
- Microsoft Excel
- IFRS 17
- Solvency II
- Sensitivity Analysis
- Reserve Valuation
- Attention to Detail
- Quick Learner
- Interpersonal Communication
- Team Collaboration
Accomplishments
- Key Player Award winner (twice) with total prize money of ₹2,00,000.
- Quokka Award recipient for outstanding service at WNS.
- League of Champions Award winner (twice) for exceptional performance.
- Best Performer Award (three times) at EXL.
Actuarial Exams Passed
Institute and Faculty of Actuaries (UK), CS1, CS2, CM1, CM2, CB3
Leadership Experience
- "All-rounder" in WNS and EXL Cricket teams.
- Active in Volleyball, Football, Carrom, and Table Tennis.
- Contributed to onboarding and training programs.
Timeline
Deputy Manager
WNS Global Services Pvt. Ltd.
06.2021 - Current
Reporting Analyst – Healthcare Department
EXL Service Pvt. Ltd.
07.2019 - 06.2021
B.Sc (Hons) - Mathematics
Delhi University
01.2015 - 01.2018
Similar Profiles
Nirupma SahjetaNirupma Sahjeta
Assistant Manager at WNS Global Services Pvt. Ltd.Assistant Manager at WNS Global Services Pvt. Ltd.
AKANSHA BARUAAKANSHA BARUA
Assistant Manager – Operations at WNS Global Services Pvt. Ltd.Assistant Manager – Operations at WNS Global Services Pvt. Ltd.
Jayashree KhopkarJayashree Khopkar
Sr. Group Manager – HR at WNS Global Services Pvt LtdSr. Group Manager – HR at WNS Global Services Pvt Ltd
A. DHARUMANA. DHARUMAN
Retail Operations (Verifier) at WNS Global Services Pvt Ltd.Retail Operations (Verifier) at WNS Global Services Pvt Ltd.
Pinky AhlawatPinky Ahlawat
HR Administrative Assistant at LINTL Clothing Pvt. Ltd.HR Administrative Assistant at LINTL Clothing Pvt. Ltd.