Actuarial Resume Examples

Actuarial Analyst I — Network Health, regional health insurer serving commercial and Medicare members

Aug 2025 – Present · 1 yr 3 mos

• Built a recurring loss ratio and PMPM reporting pack for monthly trend review, cutting report preparation time from 6 hours to 3 hours per cycle by linking SQL extracts to standardized Excel and Power BI outputs with documented refresh steps.
• Improved claims and enrollment reconciliation for quarterly reserve support, reducing unresolved data variances from 9 to 2 per quarter by adding validation checks across claims, membership, and finance source files before actuarial review.
• Updated utilization and membership inputs for pricing and forecasting models, delivering 12 monthly model refreshes on schedule while maintaining experience study inputs, membership projections, and assumption documentation in Excel.
• Prepare and validate data extracts from claims, enrollment, and provider files using SQL, Excel, and SAS for monthly actuarial reporting on commercial and Medicare lines under senior actuarial guidance.

Actuarial Analyst — Westfield, a regional property and casualty insurer focused on personal and commercial lines

Feb 2023 – Present · 3 yrs 9 mos

• Completed personal auto rate indications across 6 states, supporting filed changes affecting $84M in written premium by analyzing earned premium, loss trends, frequency, severity, and indicated need in SQL and Excel.
• Expanded a homeowners segmentation review using GLM outputs and profitability analysis by territory, tenure, and channel, identifying 3 segments with combined ratio more than 8 points above target.
• Built a Python-based monitoring workflow for recent rate changes, automating state and channel exhibits for loss ratio, retention, and written premium tracking and cutting monthly review time from 10 hours to 6.
• Supported a multi-state rate update by coordinating assumptions, impact summaries, and implementation details with product and compliance teams, delivering 14 filing exhibits by agreed regulatory deadlines.
• Reviewed post-implementation auto performance for direct and agency channels against pricing assumptions using SQL-based monitoring datasets, flagging 2 state-level retention issues within the first quarter after rollout.
• Perform rate indications, segmentation studies, and profitability reviews by state, product, and distribution channel, and maintain pricing and book monitoring models for personal auto and homeowners books.

Actuarial Assistant — Grange Insurance, a Midwestern property and casualty insurer

Jan 2021 – Jan 2023 · 2 yrs

• Prepared quarterly profitability exhibits for personal auto and homeowners, cutting exhibit turnaround by 2 business days by standardizing SQL pulls and Excel templates for recurring loss ratio and premium analyses.
• Supported a new business auto segmentation study, testing 11 rating variables for management review by cleaning policy and claim data and summarizing frequency and severity patterns in R and Excel.
• Assisted with homeowners rate filing support, delivering 8 exhibits for the filing package and reconciling premium and loss results to product and finance reports.
• Built datasets for pricing studies and quarterly performance reviews, and maintained documentation for assumptions, data sources, and filing support.

Senior Actuarial Analyst — Brighthouse Financial, US life insurer focused on annuities and life products

Apr 2022 – Present · 4 yrs 7 mos

• Led quarterly reserve analysis for a fixed and indexed annuity block, delivering 14 consecutive quarter-end reporting cycles on schedule by coordinating valuation inputs, reviewing Prophet outputs, and reconciling results with finance and controllership teams.
• Own quarterly and annual reporting workstreams supporting GAAP, STAT, and IFRS deliverables for annuity liabilities, reserve movements, and cash flow projections.
• Redesigned model control documentation for a key annuity reporting workflow, cutting review exceptions from 7 to 2 per quarter by adding standardized checks, assumption logs, and reconciliation points across Prophet and Excel models.
• Automated a reserve movement and attribution package used by finance leadership using SQL and VBA, reducing quarterly cycle time by 9 hours.
• Completed an experience study on lapse and annuitization behavior across 1.2 million policy records, testing assumption alternatives and summarizing reserve and profitability impacts.
• Mentored 3 junior analysts on reporting and model review procedures, improving first-pass review acceptance from 68% to 87% within 2 quarters through checklists, workpaper reviews, and documentation coaching.

Actuarial Analyst — Milliman, global actuarial and consulting firm

Jan 2018 – Mar 2022 · 4 yrs 2 mos

• Managed annual valuation work for a portfolio of pension clients, completing 22 client valuations in the 2021 cycle, coordinating census data validation, assumption updates, and reporting exhibit preparation in Excel and SQL.
• Built a standardized cash flow projection template with reusable Excel logic, assumption tabs, and validation checks for benefit payment forecasts, cutting model setup time by 30% across 6 recurring engagements.
• Supported year-end accounting and audit requests for pension clients, delivering 18 audit support packages with no reissued exhibits by reconciling valuation outputs, documenting methods, and fielding auditor follow-up questions.
• Prepared pension valuation results, funding projections, and experience study analyses, and presented findings to corporate retirement clients in annual reporting cycles.

Actuarial Associate — Lincoln Financial Group, retirement, insurance, and investment services provider

Jan 2015 – Dec 2017 · 2 yrs 11 mos

• Prepared recurring valuation and reporting exhibits for retirement products, supporting in-force business analyses for the retirement product line.
• Streamlined recurring valuation exhibit preparation by consolidating Excel workbooks and adding VBA checks for common data issues, saving 4 hours per monthly reporting cycle.
• Improved assumption documentation for an in-force reporting process by standardizing source references, methodology notes, and change logs, cutting reviewer clarification requests from 5 to 1 per cycle.