MassMutual
May 2026 - August 2026 | Boston, MA
Actuarial Intern | Product Pricing & Assumption Oversight
I enhanced the Excel/VBA tool that breaks down why each product's planned profitability (Value of New Business) changed from one plan to the next, across 17 product lines. I met with the pricing teams that submit data to it and shaped the tool around how they work, which replaced months of manual adjustment with a repeatable workflow. While testing it, I found that one product's data wasn't flowing downstream because a lookup only returned its first match, so I rebuilt the lookups and new products now flow through automatically. I presented the changes to actuaries and senior leaders and rebuilt the quarterly VNB deck for executive leadership so it populates instantly. I also won the intern case competition with a five-person team by designing an NIL annuity for student-athletes.
- Excel
- VBA
- Data Validation
- Automation
- Product Pricing










