Analyzed customer data to identify trends and patterns and develop insights for better business decisions.
Performed statistical analysis on large datasets using advanced analytics tools in SQL and Excel VBA
Created visualizations of complex data sets in Tableau to communicate findings with stakeholders
Assisted in the development of digital marketing campaigns for clients, including email, SEO and SEM, and social media.
Actuarial Analyst (Contract) - One Modelling
Swiss Reinsurance
Toronto, Ontario
03.2023 - Current
Working on the One-Modelling project, migrating RAFM Life Actuarial Models for European, Asian businesses to AXIS; process involves analysing decrements, Inforce Amounts, Cashflows, & Reserves for multiple bases
Querying SQL, using Advanced Excel/VBA to reconcile AXIS & RAFM outputs for various UK Life model-codes
Improving model and process efficiency through the automation of the analytics workflows
Exhibiting sound AXIS skills and time management by working multiple AXIS change demands simultaneously
Attended a week-long AXIS and E-Link bootcamp organized by Moody's
Actuarial Analyst (Contract) - Individual Life
Equitable Life
Toronto, Ontario
07.2022 - 01.2023
Using Excel, VBA in the development of a Par Dividend Tool for Equitable’s Whole Life products – which optimizes interest & mortality components, for various risk-classes, to better calculate and price dividend options
Running & testing various risk scenarios on the Par Dividend Tool, developed the tool according to findings
Developed an Excel VBA code to calculate weekly fund returns for several thousand fund blocks, for the past 3-year period, extracting the data from an MS Access source file - this automation expedited the task by 40%
Created an automated VBA tool to update Trading Grid data, used to populate real-time data for traders
Data Analyst Co-op, Asset Management
Scotiabank
Toronto, Ontario
08.2020 - 12.2020
Carried out process automation for funds analysis using Excel and VBA – expediting the process by 65%
Created dashboards on Tableau to present market-trends through effective data-visualization techniques
Actuarial Co-op, Seg. Funds & Capital Management
Manulife Financial
Toronto, ON
01.2020 - 06.2020
Assisted in 2018-19 Insurance Risk and Interest-Rate Risk analysis of Par & Non-Par products for US, CAD & Asian BU’s
Reported on Private Equity sensitivities pertinent to earnings and reserves, for varying Interest-rate shock levels
Education
Courses: SQL Fundamentals, Intermediate SQL For Data Analysis, Data Analysis For Business in Python -
Data Quest
Toronto, ON
Bachelor of Mathematics, With Economics Minor, Co-op (2017-2022) -
University of Waterloo
Waterloo, ON
Skills
Programming Languages - proficient in Excel VBA, SQL and Python; working experience with R and SAS
Tools: Tableau, Power BI, MS Excel & Access, Moody's AXIS, RAFM (Risk Agility Financial Modeler)
Strong leadership & interpersonal skills: exec roles for Actuarial Science National Association & Humans of UWaterloo, captained varsity soccer teams
Society of Actuaries: Passed Exam P/1, FM/2
Interests
Interests include traveling, photography, playing tennis, & soccer (devoted Manchester United fan since 2006)