Dec 2020 – Mar 2024 · 3 yrs 3 mos · Bengaluru, Karnataka, India

Jan 2020 – Dec 2020 · 11 mos · Mumbai

• Working on the pricing of health insurance indemnity and fixed benefit products.
• Specifying data requirements for pricing to concerned teams and cleaning the data for it to be
• used in pricing.
• Building user friendly pricing model in MS Excel and presenting results to the Appointed
• Actuary for further review.
• Drafting technical notes and other pricing related documents.
• Solving regulator queries in relation to assumptions used in pricing of the product.
• Building dashboards for portfolio monitoring of existing products, competition analysis,
• etc.
• Assisting in the product performance review exercise which is conducted every year.

Jan 2018 – Dec 2019 · 1 yr 11 mos · Kolkata

• Building pricing models using MS Excel and VBA for indemnity health insurance and fixed
• benefit products (Critical Illness, Loan Linked, etc.).
• Preparing technical notes as part of the filing of products with the regulator, which aims to
• explain the pricing approach adopted under the concerned product.
• Performing profit testing and sensitivity analysis under various adverse/favorable scenarios
• using Discounted Cash Flow approach.
• Preparing filling kits for all products as per the product filing guidelines stated by the regulator
• (IRDAI).
• Resolving queries from the regulator in respect of any assumption or approach used in pricing
• of a particular product.
• Performing experience analysis of the insurance portfolio. Visualizing data using Microsoft
• Power BI.
• Involved in Enterprise Risk Management (ERM) of the organization. Preparing Risk dashboard in Power BI.
• Assisting the Actuarial Valuation team in Financial Condition Reporting to the regulator.
• Actively taking up other projects such as conjoint analysis for the benefit structure proposed in
• one of the flagship products and many more.

Feb 2016 – Dec 2017 · 1 yr 10 mos · Kolkata

• Calculated premium rates for loan insurance schemes viz. welfare loan, education loan, etc.
• running under Indian Air force, Indian Army and Indian Navy.
• Developing (for new schemes) or modifying (for existing schemes) Microsoft Excel VBA
• program for calculation of solvency margin of various insurance schemes running in the
• Indian Air force viz. PRIC-81,PRIC-99, GIS-16, FPLI-14, HBA Loan insurance, MCL Loan
• insurance, etc.
• Calculating contribution rates, using GLM, for various Post-retirement medical benefit
• schemes for PSU companies viz. Coal India Ltd, Steel Authority of India Ltd., National
• Aluminum Company, etc. and also for some of the private owned companies.
• Carrying out Actuarial Valuation of Defined Benefit schemes (such as Pension, Gratuity, etc.)
• and several other types of Employee Benefit Schemes subject to certain plan provisions and
• assumptions.
• Developed many actuarial tools using Excel VBA for automation of various day to day
• functions at the firm which successfully resulted in significant reduction of work completion
• time.