Jun 2016 – May 2021 · 4 yrs 11 mos · Gurugram, Haryana, India · On-site

Mar 2012 – Jun 2016 · 4 yrs 3 mos · New Delhi Area, India

• 1) Carrying out valuations for UK DB Pension schemes which includes :
• Using the updated version of Valuation Suite (VBA based tool) to code scheme specific benefits or changes from the prior valuation. This also involves debugging coding to fix coding issues.
• Analyzing the data received from client. Performing data checks in excel and data testing model to make sure data is reasonable in comparison to previous year data.
• Setting Member reconciliation in excel to represent member movements between different status.
• Analyzing the surplus/deficit (G/L). This involves running the liabilities on old assumption with new data.
• Reconciliation of S/D from the last year to the current year which involves experience analysis, mortality gain or loss and data movements to understand why actuarial experience has differed from actual.
• Derivation of Financial and Demographic assumptions using the methodology given in the Statement of Funding Principles.
• Liability estimation on different bases - Last time's Ongoing basis, Current Ongoing basis, Sensitivities, Solvency basis, PPF Basis etc.
• Check the liability from the tool manually - Individual member checks, Global checks, Change of Basis Checks, Roll Forward checks - using pen and paper/excel
• Sensitivity analysis to determine impact caused by change in each assumption parameter.
• Preparing Valuation report on the basis of assumption finalized by scheme Actuary.
• Working on the accounting disclosures as per FRS-17 and IASR-19 UK standards.
• Ad-Hoc Works including calculation of Transfer values for individual members, accounting disclosure, funding update, change of basis checks etc.

Apr 2011 – Mar 2012 · 11 mos · Noida Area, India

• Research work, data analysis, data compilation & doing manual calculations based of data collated to figure out the gross benefit applicability for individuals.
• Using Citrix Systems, Mainframe, Common Front End, Defined Benefit Record Keeping tools for calculating pension benefits.