James McKenna

· Contributed to the successful conversion of our Life Product Rate Solvers from Excel to Python, enhancing the solvers’ efficiency and accuracy.

· Developed a VBA Macro that significantly improved accuracy and efficiency in Merged Market portfolio pricing. This template was pivotal in expediting the AV calculation process from days down to minutes.

· Performed a comprehensive analysis of membership, DxCG, and Quality Scores at both the group and network levels. This analysis serves as an annual template to facilitate internal and external discussions.

· Transformed the CHIA TME filing process using SAS/SQL to incorporate non-claims data, significantly enhancing accuracy and potentially yielding thousands of dollars in cost savings.

· Detected and corrected significant SOE errors, and subsequently presented them as part of the Deferred Annuities QE deliverables for the Fixed Products NAIC Valuation Team

· Boosted Fixed/Variable Annuities team performance and efficiency through VBA software process improvements.

· Analyzed and presented the tangible economic impacts of inflation and interest rates on John Hancock’s Fixed Products line performance.