Experience Analysis – Since Feb, 2024
- Implemented SQL modifications to update the CLEAR Database and reference tables, ensuring data accuracy and integrity, resulting in a 15% improvement in query performance.
- Conducted in-depth analysis of policy lapses and surrenders, spearheaded the implementation of Lapse and Surrender Tableau dashboard to monitor trends, KPI’s and calculate lapse and surrender rates with a demonstrated 20% increase in data accessibility and visualization efficiency.
- Calculate policies inforce and associated expenses, delivering actionable financial insights to support resource allocation, resulting in a 12% reduction in policy administration costs.
- Executed the quarterly mortality analysis, evaluating policy exposure to risk and assessing actual risk against various performance metrics such as duration, age etc. resulting in actionable insights
- Actively involved in the seamless transition of SAS queries to Python scripts with the modelling team, with a recorded 30% reduction in query execution time.
ILI Life Insurance Liability Projections Since Aug, 2021
- Managed a portfolio of insurance models (Variable, Universal & Term Life) in MG ALFA & GGY Axis, resulting in a 15% reduction in liability projection errors.
- Spearheaded end-to-end ownership of inflation adjustments, delivering four automated tools that led to an increase in accuracy of results by 20%, aligning with new assumptions.
- Built Power BI Dashboards to assist the model by model comparison that enhanced data comprehension for clients and provided actionable insights, reducing data analysis time by 10%.
- Collaborated with the modelling team to execute the conversion from MG ALFA to GGY Axis, resulting in a 30% reduction in run time of production models
- Assisted in automating Cashflow process that helped in improving operational efficiency by 15%.