Rosalind Mbeki
Actuarial analyst, personal lines pricing, 3 exams passed
Hartford, CTrosalind.mbeki@example.com(555) 860-2419
Summary
Actuarial analyst with a BS in Actuarial Science and two years in personal auto and homeowners pricing at a regional insurer. Passed Exams P, FM and MAS-I, built rate indications for 4 states, and moved the quarterly loss-trend workbook from Excel to Python.
Experience
Actuarial analyst
Jun 2024 – Present
Farmington River Mutual · Farmington, CT
- Built personal auto rate indications for 4 states, supporting filings worth $46M in written premium.
- Developed loss development triangles and trend selections for 9 coverages in SQL, cutting quarterly close from 6 days to 2 days.
- Automated the quarterly loss-trend workbook in Python and pandas, saving 22 hours of manual updates per quarter.
- Resolved 35 state insurance department objections on rate filings within 10 days each, with 0 refilings.
Actuarial intern, then part-time analyst
Jun 2023 – May 2024
Farmington River Mutual · Farmington, CT
- Delivered a reconciliation of 3 years of homeowners claims to the general ledger in Excel and VBA, finding $1.2M in miscoded losses.
Education
Bachelor of Science in Actuarial Science
Aug 2020 – May 2024
Connecticut Valley University · Hartford, CT
Skills
- Actuarial
- Ratemaking, Rate filings, Loss reserving, Loss trend analysis
- Domain
- Personal lines insurance, Insurance regulation, Account reconciliation
- Tools
- SQL, Python, pandas, Excel, VBA
Certifications
Exam MAS-I: Modern Actuarial Statistics I
Oct 2025
Casualty Actuarial Society
Exam FM: Financial Mathematics
Feb 2024
Society of Actuaries
Exam P: Probability
Mar 2023
Society of Actuaries





