Experience Studies and Analytics- Led experience investigations for a variety of high-impact life and annuity assumptions on mature, complex blocks of business- Performed exploratory data analysis and fit generalized linear models using R- Investigated source administrative system data, managed IT resources and built solutions in SQL and Alteryx to improve data quality- Composed and presented materials to communicate findings through all corporate governance meetings and working groups, including with the Appointed Actuary, Chief Actuary and Global Chief Actuary- Supported captive reinsurance agreements with treaty-specific experience studies and coordination with independent actuarial auditorsSarbanes-Oxley Controls- Acted on behalf of senior management as audit representation during external audits- Designed and executed Sarbanes-Oxley controls around administration system data feeds and experience study inputs/outputs- Communicated with internal control teams to improve audit communication and resolve any control deficiencies Retirement Valuation- Performed quarterly asset/liability modeling for market consistent valuation, IFRS/statutory earnings projections and cashflow testing for defined contribution retirement plans- Presented modelling results and explanations of underlying drivers to senior actuaries using attribution and margin analysis- Created reserve reports for quarterly/annual financial statements - Maintained reserve process Sarbanes-Oxley controls and validations, responded to internal and external auditor inquiries- Coordinated with pricing, IT and model developers to improve the accuracy of inforce data and modeling methodology, then implemented solutions and validated the results- Reviewed and updated projection models to a consolidated projection platform and performed unit testingSoftware/languages used: SQL, Alteryx, R, Python, MoSes, Microsoft Suite

- Assisted individual life pricing actuaries in model maintenance, rate and profitability analysis, new business value reporting, and drafting actuarial memorandums- Supported the product development team by writing business specifications for new riders and repriced products, and drafted actuarial response to state inquiry on new products- Provided custom illustrations of individual and joint life policies to the customer support team, and reviewed illustrations by other actuarial assistants- Performed quarterly valuation for variable annuity products, and audited traditional and non-traditional whole life and term life reserves- Tested actuarial software and made recommendations for its implementationSoftware/languages used: APL, GGY Axis, MG Alfa, MS Access and Excel

- Maintained database and queries used for motor vehicle crash/fatality analysis and report creation for senior management- Developed first routine time series analysis of crash data for future projections