Arjun Sahota

Senior Actuarial Analyst @Co-operators

Accountable for capital modelling (LICAT) reporting, set up and run various LICAT dataset on time for the next team during quarter end while updating relevant files and working through any issues and having enough time to rerun, and preparing insurance risk files by completing interim consolidation. • Completed FCT Scenario testing for several models, updating various assumptions and creating overrides and batches to run these tests then collected results and created income statements for various scenarios. Improved documentation while going through the process and added detailed explanations for all steps. • Set up IFRS 17 Budget Projection models operating in different modules while maintaining good version control for testing. Understood the modelling and different types of changes within each dataset, completed financial assumption updates, and consolidated and reviewed the results. • Completed iterative adjustment process for Cash flows for LICAT results to be consistent with prescribed base scenario interest rate environment by updating relevant files and performing manual calibration.• Validated ESG tool process and created documentation on how the tool works step by step while noticing any discrepancies in the process including the excel formulas and VBA Macros.