Summary
Overview
Work History
Education
Skills
Certification
Interests
Accomplishments
EXTRACURRICULAR ACTIVITIES
Timeline
Generic
Shubham Aggarwal

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
Shubham AggarwalActuarial Science