Junior Actuarial Analyst
Northbridge Mutual Insurance · Hartford, CT
Jul, 2024
Automated quarterly reserve triangles in R, cutting exhibit preparation time by 40% for the quarterly close.
Supported the personal auto rate filing across 4 states, compiling loss experience, trend, and elasticity exhibits for regulatory review.
Built a SQL loss-ratio dashboard that replaced 6 hours of manual monthly reporting for underwriting leadership.
Performed chain-ladder and Bornhuetter-Ferguson IBNR analysis on a $310M book, with indicated reserves landing within 2% of booked carried values.
Peer-reviewed more than 20 pricing and reserving exhibits before chief actuary sign-off, catching issues early in the review cycle.
Tightened claim-data validation rules in R and SQL, reducing claim-data exceptions by 25% quarter over quarter.
Actuarial Intern
Constellation Life & Annuity · Windsor, CT
Jun, 2023 · Aug, 2023
Contributed to a mortality experience study covering 1.2M annuity contracts, segmenting actual-to-expected ratios by age, gender, and duration.
Tested Prophet model scenarios for cash-value guarantees, documenting 30+ test cases and resolving 8 defects with the modeling team.
Built a VBA macro that consolidated monthly experience files, saving the team 5 hours per close.
Presented the summer project to the chief actuary and 12 staff actuaries; two recommendations were adopted for the fall experience review.
Data Analyst Intern
Capitol Region Health Alliance · Hartford, CT
Jun, 2022 · Aug, 2022
Cleaned and joined claims and enrollment datasets in SQL and Excel to produce utilization reports for 4 clinic regions.
Built Tableau dashboards tracking ER visit trends and 30-day readmission rates for weekly operations meetings.
Automated a recurring weekly report with Excel VBA, cutting preparation time from 3 hours to under 20 minutes.