Dennis L. Email & Phone Number

Toronto, Ontario, Canada

Toronto, Canada Area

Toronto, Canada Area

Waterloo, Canada

• Vetted GGY AXIS and Excel models from different business units• Reviewed model documentation and investigated model programming and design to verify model logic for its intended purpose• Created and operated excel calculators to replicate results to ensure model precision and effectiveness• Rapidly established rapport with relevant model owners to conduct efficient communication and discussion of model vetting findings• Prepared vetting reports and presentations on model… Show more • Vetted GGY AXIS and Excel models from different business units• Reviewed model documentation and investigated model programming and design to verify model logic for its intended purpose• Created and operated excel calculators to replicate results to ensure model precision and effectiveness• Rapidly established rapport with relevant model owners to conduct efficient communication and discussion of model vetting findings• Prepared vetting reports and presentations on model vetting findings for upper management• Worked under tremendous pressure from management as the timeline has already been extended Show less

Toronto, Canada Area

• Modeled a reinsurance treaty into GGY AXIS that was originally modeled in excel spreadsheets manually, reducing staff hours• Performed treaty transfers model refinements and model refresh using GGY AXIS to maintain and increase consistency with monthly changes• Analyzed and documented USGAAP, CGAAP, USNAIC, TAX reserve impacts of model refinements and data refresh and presented to management• Revamped standard deviation regression tool to fit new format of data and reduce runtime… Show more • Modeled a reinsurance treaty into GGY AXIS that was originally modeled in excel spreadsheets manually, reducing staff hours• Performed treaty transfers model refinements and model refresh using GGY AXIS to maintain and increase consistency with monthly changes• Analyzed and documented USGAAP, CGAAP, USNAIC, TAX reserve impacts of model refinements and data refresh and presented to management• Revamped standard deviation regression tool to fit new format of data and reduce runtime while stimulating 10000 cycles of all treaties• Exposed to US reinsurance industry regulations and reserve analysis methodology Show less

Waterloo, Canada

• Conducted lapse/surrender analysis by examining trends to increase accuracy of surrender assumptions of company's model• Designed and implemented Accumulation Annuity Earnings by Source Tool (VBA)• Reduced manual Actuary resource required by 50 hours monthly and precisely determined reserve freeing up reserve funds• Analyzed and Manipulated large GGY Axis and Oracle databases of over 1000000 records of policies through SQL Access queries and expert VBA Excel… Show more • Conducted lapse/surrender analysis by examining trends to increase accuracy of surrender assumptions of company's model• Designed and implemented Accumulation Annuity Earnings by Source Tool (VBA)• Reduced manual Actuary resource required by 50 hours monthly and precisely determined reserve freeing up reserve funds• Analyzed and Manipulated large GGY Axis and Oracle databases of over 1000000 records of policies through SQL Access queries and expert VBA Excel procedures• Investigated and collaborated with other departments to resolve policies with discrepancies further enhancing my knowledge of Accumulation Annuity products (RRIF, GIA, DIA) Show less