Shawn Stackhouse

Shawn has worked as an actuarial consultant to the insurance industry since 1997. Shawn has worked extensively with AXIS throughout his career. His experience includes managing and executing projects involving AXIS model conversions, AXIS calculator replications, finance transformations, model vetting, actuarial audits, product pricing, valuation, and financial reporting. Shawn has extensive experience and modeling proficiency using AXIS, Excel, SQL Server, Access, and VBA.

Some of his accomplishments include:

• Converting actuarial models from legacy systems to AXIS for regular life, universal life, disability, long-term care, variable annuity, and equity indexed annuity products.
• Implementing new modeling functionality and product features into existing AXIS models for the projection and valuation of insurance and annuity products.
• Creating AXIS, EnterpriseLink, spreadsheet and database processes for Canadian and USGAAP, statutory and tax reporting.
• Implementing US GAAP LDTI reserving functionality for disability and long-term care products and validating AXIS results.
• Building complex spreadsheet models to independently calculate policy projections and reserves that verify and replicate the AXIS calculation engine to facilitate audits and validation of model changes.
• Establishing recommended model design principles and best practices for the design, maintenance, and documentation of AXIS models to provide a consistent modeling approach throughout an organization.
• Performing detailed vetting of AXIS models to ensure correct set-up, product features, assumptions, and calculations.
• Designing AXIS models to set premiums and analyze profitability for life and annuity insurance products.
• Developing Excel/VBA tools to facilitate, automate and control creation, modification and documentation of AXIS tables and objects.