Shubham Aggarwal
Actuarial Science
Rewari
Summary
Actuarial professional with expertise in life insurance valuation, financial reporting, and regulatory compliance, seeking to leverage analytical skills and domain knowledge to drive strategic decision-making and risk management. Adept at managing complex actuarial models, conducting experience studies, and implementing frameworks like IFRS, US GAAP, Solvency II, and RBC. Committed to delivering accurate, insightful, and timely actuarial outputs that support business growth and regulatory alignment.
Overview
6
6
years of professional experience
6
6
Certifications
2
2
Languages
Work History
Actuarial Lead
Metlife
12.2022 - Current
- Led valuation of new business (VNB) for participating and non-participating products, encompassing data validation, segmentation across LOBs and generation of Model Point Files for Prophet runs.
- Prepared and presented VNB reports to communicate results to senior management, effectively communicating key insights and drivers.
- US GAAP valuations for in-force business, particularly participating products, were completed punctually and included thorough explanations for notable variances.
- Maintained and updated POLY models in alignment with the latest experience study assumptions and evolving regulatory requirements.
- Successfully implemented Risk-Based Capital (RBC) framework into both VNB and in-force valuation models, enhancing regulatory compliance and capital efficiency analysis.
- Executed annual statutory valuation, performing and reviewing key actuarial variables, ensuring full compliance with regulatory and internal standards.
- Conducted experience studies for critical actuarial assumptions (e.g., mortality, lapse), supporting assumption setting and valuation processes.
Actuarial Analyst
WNS Global Services
10.2020 - 12.2022
- Working in Actuarial Valuation using ArcVal tool on the Closed block of a life insurance company based in US.
- Liability Modelling of US Block on setting the MOSES and Appmaster
- Worked on Cash Flow Testing Modelling where I set up MOSES software and run Asset liability runs.
- Prepared and maintained key financial and regulatory reporting tools, including:
- Consolidation spreadsheet for IFRS Rollforward across the entire Life and Health business.
- Quarterly Solvency II Lapses and Surrender reports, with trend analysis on annual and quarterly basis.
- Quarterly Life Risk-Based Capital (RBC) spreadsheet, supporting capital adequacy assessments.
- Monthly Policy Count Consolidation spreadsheet, ensuring accurate tracking and reporting across product lines.
Actuarial Intern
SBI General Insurance
02.2020 - 09.2020
- Worked on Data Cleaning and Analysis of government data on R Studio.
- Project research and Development on new product.
- Claim calculation under WBCIS (Weather Based Crop Insurance Scheme).
Education
B. Com (Hons) -
Sri Aurobindo College (Eve), Delhi University
01.2017
12th - undefined
Jain Public School
01.2014
10th - undefined
Jain Public School
01.2012
Skills
- Actuarial Software : Prophet Professional, DCS tool, PolySystem, SQL, ARCVAL, Moses and MS Excel
- Fundamental understanding of Python and R
Certification
CS1 Actuarial Statistics (IFOA)
Interests
Reading and watching blogs connected to insurance and financial aspects
Accomplishments
- Received Badge on independently handled and timely submission of VNB Reporting during time crunch along with Monthly and annual tasks (Appreciated by Stakeholders).
- Team Award received by manager for three consecutive quarters for best performing.
- Recognition by Senior Actuary on Automation of Life Risk Based Capital Consolidation Project.
EXTRACURRICULAR ACTIVITIES
Assistant prefect of Mahavira house (School house) in 12th Standard. Participated in inter school level competitions and exhibitions.
Timeline
Actuarial Lead
Metlife
12.2022 - Current
Actuarial Analyst
WNS Global Services
10.2020 - 12.2022
Actuarial Intern
SBI General Insurance
02.2020 - 09.2020
12th - undefined
Jain Public School
10th - undefined
Jain Public School
B. Com (Hons) -
Sri Aurobindo College (Eve), Delhi University