Global Actuarial Value Management - Mortality & Morbidity Center of Excellence (Sept. 2013 – Apr. 2015)Life & Retirement (Apr. 2015 to June 2017)* All job activities transitioned from AIG Life and Retirement into corporate position* Role expanded from life and retirement products to include property causality and all AIG insurance businesses* Redesigned database structure and security to work with new company data* Worked with teams to locate and pull data into new… Show more Global Actuarial Value Management - Mortality & Morbidity Center of Excellence (Sept. 2013 – Apr. 2015)Life & Retirement (Apr. 2015 to June 2017)* All job activities transitioned from AIG Life and Retirement into corporate position* Role expanded from life and retirement products to include property causality and all AIG insurance businesses* Redesigned database structure and security to work with new company data* Worked with teams to locate and pull data into new databases* Worked to support external teams to use common source of data* Created and programmed all code required to produce experience studies on new product lines* Created the frame work for a third party Experience Studies system* Worked with compliance and auditors to insure data integrity and SOX controls* Maintain Experience Studies system due to large policy conversions and new policy admin system integrations Show less

* Facilitated the design, development and implementation of the Experience Studies Relational Database system* Primary resource for designing and building efficient relational relationships in the database.* Transitioned current Experience Study system into the new database platform* Reverse engineered current systems to match new non mainframe system

* Responsible for competitive analysis for Universal Life and Term products* Support pricing actuaries, business line leaders, RVPs, IWs, senior management, and marketing with competitive requests and presentations.* Engineered ways for company products to stand against our competitors for large cases, overall product line competitiveness, and product launches. * Responsible for all life automation and benchmarking. Replaced existing automation system with AutoIT and Excel VBA and… Show more * Responsible for competitive analysis for Universal Life and Term products* Support pricing actuaries, business line leaders, RVPs, IWs, senior management, and marketing with competitive requests and presentations.* Engineered ways for company products to stand against our competitors for large cases, overall product line competitiveness, and product launches. * Responsible for all life automation and benchmarking. Replaced existing automation system with AutoIT and Excel VBA and expanded capabilities. Key person for System Seller testing and creation.* Created tool to dynamically rank products by premium and target displaying results on easy to read color chart.* Rewrote mainframe SAS query to pull Term policies more efficiently and moved query over to MS Access to make it more accessible to users with no SAS or SQL knowledge. * Wrote macros in MS Access to pull data from SMART SQL databases to create reports.* Created “Industry News” email with industry headlines and product marketing materials* Maintained brokerage and competitor relationships* Tracked competitors for the Interest Rate Committee* Provide accurate materials for published surveys (Full-Disclosure, National Underwriter, AnnuitySpecs.com) Show less

Life Insurance Illustration Sales and Inforce Projection System actuarial testing.* Focused on inforce testing and Survivorship policies * Wrote inforce illustration systems for 2 products* Worked on illustration testing tool (HAL) using APL, became the go to person for support.* Created automation scripts using jscript and AutoIT* Responsible for all SQL IBM DB2 queries for the group* Wrote up PMOs to fix the Joint Last Survivor products on Lifecomm86 and… Show more Life Insurance Illustration Sales and Inforce Projection System actuarial testing.* Focused on inforce testing and Survivorship policies * Wrote inforce illustration systems for 2 products* Worked on illustration testing tool (HAL) using APL, became the go to person for support.* Created automation scripts using jscript and AutoIT* Responsible for all SQL IBM DB2 queries for the group* Wrote up PMOs to fix the Joint Last Survivor products on Lifecomm86 and Vantage* Improved and automated process* Documented processes and products* Regression Testing Show less