Jon Leblanc Email & Phone Number

Cedar Rapids, Iowa, United States

Converted closed blocks of UL, TermUL and fixed deferred annuities to AXIS. Many of these were bolt-on acquisitions from decades earlier and required extensive research and cross-department communication in order to obtain the product details needed to load them into AXIS.Assisted in setting up existing AXIS datasets for IFRS 17 runs.Utilized Alteryx to convert various file types into seriatim inforce files for AXIS.

Springfield, Massachusetts

Developed VM-20 reserves in a Universal Life AXIS dataset. Created assumption sets and stochastic block projection assumptions. Set up inner and outer loop runs and prepared reports and documentation.Implemented seriatim reinsurance in a Term AXIS dataset. This included the Datalink Cession Info table, reinsurance terms and treaties, setting up the Batches and selecting the appropriate reports.

Des Moines, Iowa

Loaded a pension product into AXIS and built out the product functionality. This included the inforce file and all tables and cell assumptions. Built Excel replication workbooks that matched AXIS and ALFA output and determined the exact cause of the difference in reserve between the two systems.

Houston, Texas

Implemented AXIS cluster functionality in the VA valuation and hedging model. Worked closely with GGY staff throughout the project as cluster modelling is a new feature in AXIS. Achieved a significant reduction in runtime while keeping accuracy of results within required parameters.Learned and then utilized the inhouse wiki documentation system. Prepared detailed documentation for the cluster model and successfully turned the finished product over to internal staff.

Norwalk, Ct

Upon the unexpected departure of a key employee, sifted through loosely documented procedures and successfully reproduced the prior quarter valuation results. Prepared a thorough and easy to use procedures document and introduced simple formatting styles so that new users can easily use and update files.Met regularly with managers and the CFO to gain an understanding of their needs and to present the results of my efforts.Rebuilt Excel spreadsheets and Access databases so that they have a consistent and easy to use format.

Cincinatti, Oh

Updated assumptions for deferred annuities and SPIAs in Polysystems. Built Excel workbooks to verify that generational mortality tables were being applied correctly by AnnuityMaster.Redesigned and simplified the month-end procedures document and eliminated the need for multiple versions of the .rdf and .cdf files.

Jersey City, New Jersey

Responsible for SOP03-1 reserve reporting using GGY AXIS for multiple VA products with GMxB guarantees. This included creating the equity and interest scenarios used for stochastic analysis, running the baseline model as well as sensitivities and step-throughs, preparing summaries of results and responding to questions from senior management.Successfully converted the AG38 reserve projections of three Universal Life products from MG-ALFA to GGY AXIS. Presented the results of this effort to the Model Governance Committee. Requested two custom mods from GGY to aide in the processing of Universal Life AG38 reserves.

Columbus, Ohio

Implemented the annual FAS 97 DAC unlockings for UL and Indexed UL products using the ULMaster GAAP model. Made significant improvements to the model and reduced the size and complexity of the procedures document.Analyzed ULMaster projected DAC results, and built replication spreadsheets in order to verify PolySystems coding and computations.Created MS-DOS batch files to streamline the creation of ULMaster .pmf and .vmf files and to eliminate the possibility of user error.

Richmond, Va

Built replication spreadsheets for ULMaster projected reserves. Verified that reserves were being calculated correctly according to AG38, including shadow account secondary guarantee reserves.

Lansing, Michigan

Designed and priced life insurance and annuity products. Gathered data used to create actuarial assumptions, and used actuarial modeling software to determine rates.Worked with stochastic models used to price guaranteed minimum withdrawal benefits for variable annuities.Developed the company’s first Simplified Issue Whole Life product, including competitor analysis, non-forfeiture testing, and the construction of a pricing model using MG-ALFA software.Calculated Stat and GAAP reserves for UL, VUL and Ultimate policies each month. Programmed product revisions into TAS and ULMaster and investigated any discrepancies or unexpected results.