Leah Klompmaker, Asa, Acia Email & Phone Number

Toronto, Ontario, Canada

Reinsurance Financial Management

Toronto, Ontario, Canada

Reinsurance Valuation - Local Reporting

Toronto, Ontario, Canada

Reinsurance Valuation - Local Reporting

London, Ontario, Canada

• Met core model delivery targets while managing stakeholder expectations and balancing ad-hoc/case support priorities.
• Primary escalation contact for urgent case work. Addressed with urgency and efficiency, engaging necessary resources for resolution such as senior leaders for business decisions when needed
• Identified opportunities for automation to reduce manual workload and executed improvements with accuracy
• Led the par side of the team as the most senior developer during transition period for the new team manager
• Provided training to new staff and co-op student

Toronto, Ontario, Canada

• Improved SQL queries which are used to obtain model outputs for an excel summary file such that they only grab pertinent information. Managing the data and making other improvements to the summary file structure.
• Assisted with GGY AXIS model runs by making changes to IFRS4 production datasets in order to produce results for IFRS17 reporting
• Compiled high level data summaries for reporting and ad hoc requests utilizing SQL and Python; summarized results in Excel

London, Ontario, Canada

• Assisted with risk data reconciliation, identifying errors using strict attention to detail and resolving such errors, resulting in improved data credibility and accuracy for risk profile reporting
• Updated Microsoft Access database using an append query, bringing longevity data from different business units into one master table; data is used for enhanced longevity monitoring, measuring exposure, and evaluating.
• Assembled quarterly reporting file detailing the incremental risk profile changes by running a complex analysis tool in excel, allowing for the ability to provide detailed commentary for the CRO and Insurance Risk Report
• Performed industry research on current and emerging risks that may impact insurance risks, highlighting key findings and trends

Markham, Ontario, Canada

• Developed excel tool to solve for a mix of business factor given inputs such as type of coverage or region, or other identifying characteristics
• Assisted with indication by analyzing trends and selecting factors such as premium trend selection using historical data and illustrations in excel, and loss trend selection utilizing loss development triangles
• Streamlined corporate planning decision process by creating a template in excel and then consolidating data to measure combined operating ratio’s
• Ran the SAS programs to keep department data updated and dispositioned material data inclusions or exclusions by analyzing technical deviation reports by liaising with team to confirm data findings

Toronto, Canada Area

• Executed deliverables for the Appointed Actuary Report in a timely manner liaising with other departments when required
• Decreased time required to fulfill LICAT reporting requirement by converting files to an automated process
• Oversaw sensitivities analysis utilizing GGY AXIS and collaborated with team to analyze capital structure
• Produced and assisted in the analysis of quarterly actuarial projections utilizing VBA, excel formulas and Essbase

Hamilton

• Delegated work throughout the team by prioritizing tasks to achieve ministry standards and deadlines
• Maintained student fiscal records by analyzing excel reports and correcting any conflicting information
• Increased productivity by taking initiative on outstanding projects and balancing multiple tasks

Hamilton

• Participated in volunteer funding valuation project.
• Project involves evaluating a care and maintenance fund account to see if contributions now will be enough to meet future obligations in perpetuity
• Researched legislation and requirements regarding operations and requirements for contributions to the care and maintenance fund
• Analyzed data for conducting asset modelling and expense projections
• Contributed to formal report with the outcome of the assessment and potential solutions to the funding issue