Brett Hodgson

ab0hv1@r.postjobfree.com

SUMMARY

Experienced ASA working in modeling, financial reporting, pricing and risk management. Strong analytical abilities combined with excellent leadership skills enable me to work effectively with professionals at all levels.

CERTIFICATIONS

Society of Actuaries, ASA 1992

Actuaries PD credit for FETE exam or DP exam, 2007

FAP modules, 2010

SKILLS

• Modeling

• Pricing

• Cash flow testing

• Risk management

• Experience studies

• Capital forecasting

• Project management

• Asset / liability management

• Financial reporting: GAAP, statutory, tax & embedded value

• Excel, Visual Basic VBA

• Access, Word PowerPoint

• MG-ALFA, AXIS, PTS

• SAS, Perl, APL

• Polysystems

• Automation, Streamlining & process improvement

• Focus, Fortran, Basic, DOS, OS/2, Windows

• Bilingual: English and Spanish

EXPERIENCE

GENPACT – Danbury, CT / Richmond, VA

Senior Manager (Consultant/Contractor)

02/2017-07/2018

• Resolved errors in Variable Annuities SOP03-1 model via peer review, sign-off & documentation

• Assured MG ALFA AG43 grid runs and data checks

• Valuation: Quarterly & Monthly GAAP, Stat & Tax on VAs & Pension Transfer Funding

• Solved highly fragmented APL valuation by transformation to straight-through processing VBA

• AOM assistance for Life, Annuities and Long Term Care

METLIFE – New York, NY / Bridgewater, NJ

Senior Associate Actuary

07/2013-08/2016

• Annuity Controls pricing model peer review and interdepartmental presentations

• Resolve APV factor models for VAs, rate table creation, client correspondence, annual assumptions & specifications, experience studies, §401& §72 RMDs, collaborate with tax attorneys

• Product admin system testing onshore/offshore, review specs, design scenarios, sign-off on results

• Solve DIA competitive payout rate setting, achieve target ROI with investment portfolio, achieve top sales rankings vs competition, bi-weekly

• Create FIA GLWB calculation illustration tool in Excel VBA

• Identify & resolve errors in Fixed Deferred Annuity stochastic pricing model via peer review

• GMIB & GLWB AG43 pricing model standard scenarios & NBEV reporting

AXA EQUITABLE – New York, NY / Jersey City, NJ

Senior Manager-Actuarial

10/2006-03/2013

• Capital Forecasting Project Manager

• Maintain and update MG-ALFA & AXIS IFRS EEV Corporate Models

o Replicate ALFA calculations in Excel

o Calculate EEV roll forward impact for key assumption changes

o Assist appointed actuary in responding to actuarial questions from NYDFS

• AXIS Modeling and Projections for VA products:

o Access Database link assumptions, scenarios and projection results

o DataLink Inforce ‘prn’ files for seriatim and compressed models and batch runs

o VA Policy Info Table of inputs & mappings, defaults, mappings, formulas & investment accounts

o Seriatim cell structure benefit code and cell name mappings for benefit bases and reinsurance

o Cell overrides, override set, table substitutions, projection assumptions and block runs & recalcs

o Calendar year reports, summary reports and block summary reports

o Single cell testing, distributive processing with GridLink controller

o Model Steward process for AG43 reserves, DAC & IFRS EEV model changes

• Key person for Business Continuity and Hardware Refresh

• Supervise actuarial students

o Convert APL models for SPDA and FPDA blocks to ALFA

o Design summer actuarial intern project winning proposal, manage intern & other admin matters

o Supervise actuarial student to consolidate annual CFT results for Reg 126 reporting

BERKSHIRE LIFE (GUARDIAN) – Pittsfield, MA / New York, NY

Senior Actuarial Assistant

12/1997-08/2006

• Asset/Liability Management

o Update, validate, and maintain PTS corporate models for DI, traditional life, and annuity lines

o Segment assets by lines of business to achieve durational matching

o Calibrate asset defaults and prepayments

o Produce periodic market value of mortgage portfolio calculation

o Calculate option-adjusted durations for assets and liabilities

o Produce periodic ALM reports

o Analyze risk based capital and return on capital

o Stochastic interest rate testing of models

o Test various asset mixes to determine optimal mix for new DI subsidiary of Guardian Life

o Examine investment strategies and effect on common stock, high-yield bonds, adjustable rate mortgages, etc.

o Prepare preliminary run of original C-3 risk calculation and illustrate impact on required capital

• Valuation

o Polysystems' valuation setup for Life, Health, and Annuities

o Supervise coding of annuity valuation system

o Use financial and policy data to determine dividend interest rate for direct and non-direct recognition policies

o Create mortality, interest, and expense experience factors for traditional life dividends

o Calculate annual dividend scale for inforce block and dividend liability

o Use SAS to match, merge, analyze and manage hundreds of millions of dividend records

o Provide dividend support solutions

o Prepare quarterly statutory, GAAP, and tax statements for disability income, annuities, term, universal life, and traditional whole life using Polysystems and SAS

o Experience studies for disability income and life insurance

• Cash Flow Testing / Asset Adequacy Testing, Annual Reporting and Embedded Value

o Prepare annual statement exhibits

o Prepare XXX memorandum, annuity questionnaire and reserve calculation audits

o Prepare NYSID filing extract for life and annuities

o Use PTS models and Polysystems' Delphi for annual cashflow testing, development of financial plan, EV determination, and to support the dividend recommendation

• GAAP Reporting

o Assist in GAAP conversion using PTS model and various Polysystems valuation systems

o Use functional cost study to produce acquisition and maintenance expenses

o Demonstrate GAAP experience is consistent with assumptions

• Create FPA/SPIA illustration system using Excel Visual Basic (VBA) and re-price SPIA

CHUBB LIFE (JEFFERSON PILOT) – Concord, NH

Actuarial Assistant

01/1990-11/1997

Marketing Actuarial Responsibilities

• PTS pricing and analysis, micro pricing and model office of UL, Survivorship UL, Term, Variable Annuities, Market Value Adjusted Annuities, and SPDA

• PTS' APL code: model ROE, ROA, impact of anti-selection premium pattern, COI's ratchet banded by face amount, fund account interest bonus structures, secondary guarantee premiums, etc.

• Reconcile PTS with other pricing systems

• Demonstrate function mechanics of proficiency compensation model and corrected as needed

• Determine profitability of special cases, old issue ages, reinsurance & agent induced anti-selection

• Certification of disciplined current scale for Illustration Actuary

• Provide DEFRA/TAMRA calculations §7702 & §101

• Overlay persistency bonus on competitors' products and tested profits

• Assist in answering actuarial questions from state insurance departments

• Analyze software and products of numerous key competitors, produce database of values and report for senior management

• Liaison for system maintenance and enhancement task force collaborating with Customer Service, Information Systems, Law, and other departments

Corporate Actuarial Responsibilities

• Pricing, valuations, and Cash Flow Testing on Structured Settlement line of business

• Investigate, analyze and correct structured settlement reserve system for Chief Actuary, proving descriptive scenarios encompassing the impact of reserve destrengthening

• Present CFT results for Actuarial memorandum

• Conduct DI reinsurance retention limit experience study and summary report to Chief Actuary

• Provide detail work to reinsure all individual amounts in excess of retention under new more profitable and uniform treaty

• Complete periodic accounting for a variety of reinsurance treaties

• Complete analysis of variance in earnings for our Reinsurance Association, including statistical significance level of the effect of the Association

• Produce monthly Credited Interest Rate reports quickly and accurately for senior management

• Perform periodic FAS 97 fund-roll accounting for UL and VUL products

• Prepare FAS 107 Present Value of Loans Calculations

• Assist with the ROE study

ADDITIONAL EXPERIENCE

RICHARD F. CAMUS & ASSOCIATES, LIBERTY LLOYDS, Etc. – New Orleans, LA

Actuary

Health and Pension Consultant

CONNECTICUT MUTUAL – Hartford, CT

Actuarial Analyst

Disability Income Product Development and Management

EDUCATION

Brigham Young University – Provo, UT

B.S. in Mathematics

Minor in Statistics and Physics

Contact this candidate