Steve Hancock Email and Phone Number

Fixed Indexed Annuity and Variable Annuity statutory valuation

Team lead in Fixed Indexed Annuity and Variable Annuity Statutory Valuation

Index Annuity and Variable Annuity Pricing:- Team lead in quarterly Value of New Business reporting for 7 quarters. This included coordinating pricing runs, managing project tasks and deadlines, distributing workflow to junior staff, attributions analysis, reviewing, justifying, and communicating results to the pricing oversight unit, and more.- Pricing database team expert. Synthesizing production data, reviewing for reasonableness and applying assumptions where data are limited.- New Business rate setting of IAs. Launching pricing runs, preparing rate memos and system files.- Product development of new riders/features such as new GLBs, withdrawal rates, rollup rates, and more.- Sensitivity analysis in stochastic model for evaluation of impact of new actuarial assumptions and pricing methodologies.- Signing actuary for over 600 state filing actuarial memoranda and SNFL compliance expert for annuities. - Communicated directly with State Insurance Department reviewing actuaries, and worked closely with the State Filing unit to respond to actuarial objections, prepare new memos, and recommend changes to State Filing forms to ensure SNFL compliance.- Improved multiple internal processes by programming spreadsheets to increase efficiency including SQL data retrieval and review tools, and VNB process controls and enhancements.- Exception valuations which included overseeing pricing runs and reviewing results for reasonableness

- Pension valuations for large and complex defined benefit plans. Duties included participant reconciliations, data review and corrections, valuation runs and reviews, and preparation and review of actuarial memos.- Led valuations and data reconciliations for risk-pools.- Drafted Board of Administration agenda items including adoption of new actuarial assumptions, and termination risk pool valuation report.- Analysis of de-risking policies using Asset-Liability Management models and framework.- Team lead on numerous valuation projects and ad-hoc requests.- VBA programming of utilities in Excel and Access including participant reconciliation tools, database sync-error fixes, and more.