Actuarial Intern
Current● Developed Excel tool with VBA, processing 1M+ rows of health cost data with completion andseasonality factors, to provide granular trend insights and expected trend range● Built self-service dashboard in PowerBI on authorization-claim discrepancies and presented to 50 peoplefrom various fields, eliminating need for similar analyses and addressing company-wide concerns● Investigated rising costs by analyzing effects of plan design and membership mix on paid/allowed ratio● Created Excel ribbon add-in for team with custom macros to improve work efficiency across the team