Summary
Overview
Work History
Education
Skills
Professional Qualification (Actuarial Science)
Timeline
Generic

Rahul Gupta

Ghaziabad

Summary

Insightful Analyst known for high productivity and efficient task completion. Possess specialized skills in data interpretation, analysis, and reporting which enhance problem-solving capabilities. Excel in communication, teamwork, and adaptability, ensuring seamless collaboration and innovative solutions in dynamic environments.

Overview

9
9
years of professional experience

Work History

Analyst - Team Reviewer

WTW
Gurugram
08.2024 - Current
  • As a member of the actuarial valuation team, I validate and reconcile data for clients in the United States and the Middle East.
  • I am responsible for pension valuations in compliance with the Pension Protection Act of 2006, as well as for post-retirement medical plans according to the requirements set by the plan sponsors.
  • I conduct gain and loss analysis and status movement assessments based on experience, evaluating their impact on liability figures.
  • I perform software coding in alignment with plan documents and provisions for current valuations, and I validate the software results through manual liability calculations.
  • I convert post-retirement medical plans into Mercer's valuation software, which requires extensive coding and benefit analysis.
  • I prepare disclosure reports in accordance with US GAAP and IAS 19R accounting valuation standards.

Senior Actuarial Specialist

Mercer Consulting (India) Private Ltd.
02.2021 - 08.2024
  • Actuarial valuation team members work on validating and reconciling data for United States and Middle East clients.
  • Responsible for pension valuation as per government regulation under the Pension Protection Act, 2006, and post-retirement medical plan as per the plan sponsor's requirements.
  • Gain and Loss and Status movement analysis based on experience and checking its impact on the liability numbers.
  • Software coding, as per the plan document/provisions, for the current valuation, and validating the software's results by undertaking manual liability calculation.
  • Conversion of post-retirement medical plans into Mercer's valuation software, which involves extensive coding and benefit analysis.
  • Reporting of Disclosures under US GAAP and IAS 19R Accounting Valuation.

Senior Financial Consultant

EXL services
11.2017 - 01.2021
  • Provides initial review and calculation on all financial aspects of disability claims
  • Perform vigorous calculations to calculate the benefit amount (outflow) which needs to get dispersed from an insurance company to an insured
  • Works closely with the onshore US CPA's or Financial Risk Consultants on most of the complex claims
  • Offset the benefit amount if there would be any partial return to work earnings or any state disability benefit provides by the Federal Govt
  • Of US
  • Based on the different taxability laws of US states calculations needs to be done manually

Underwriting Specialist

Metlife
08.2015 - 01.2017
  • As per the insurance guidelines of US and state mandate regulations, provide benefits such as group life insurance, group disability insurance and other group health insurance products
  • Works closely with the onshore partners/underwriters to set the margins and discounts which a new prospect can get to beat the other competitive insurance companies of US
  • Divide prospect group into different classes based on their job descriptions and salaries to evaluate possible risk and premium amount for each individual employee's class

Education

Mathematics Honors

Ambedkar, University of Delhi
01.2015

12th Science -

Sarvodya Anand Vihar senior seconday school
01.2012

10th -

Konark Public school
01.2009

Skills

  • Recognized as "Star of the Month" in March 2024 for managing tasks in a timely manner and delivering quality work
  • Strong quantitative, communication, and analytical skills
  • Well proficient in plan provisions, methods, and data coding for US DB plans in the studio
  • Microsoft Excel, Word, VBA, R programming Language and Microsoft Power-point

Professional Qualification (Actuarial Science)

  • Actuarial Common Entrance Test (ACET, IAI) - Cleared
  • CT-1 Financial Mathematics-Cleared
  • CT-5 Contingencies-Cleared
  • CM-2 (Financial engineering & Loss Reserving)-cleared
  • CS-1 (Actuarial Statistics)-Cleared
  • CB-2 (Business Economics) - Pursuing
  • CS-2 (Risk Modelling and Survival Analysis) - Pursuing

Timeline

Analyst - Team Reviewer

WTW
08.2024 - Current

Senior Actuarial Specialist

Mercer Consulting (India) Private Ltd.
02.2021 - 08.2024

Senior Financial Consultant

EXL services
11.2017 - 01.2021

Underwriting Specialist

Metlife
08.2015 - 01.2017

Mathematics Honors

Ambedkar, University of Delhi

12th Science -

Sarvodya Anand Vihar senior seconday school

10th -

Konark Public school

Similar Profiles

CREATE PROFILE
Rahul Gupta