Progressive Casualty Insurance –
Lead Data Analyst
2019 - 2025 | 2022 - 2025 (at Lead level)
Highlighted role achievements
- Replaced tabular estimation of core team metrics with statistical
models, reducing run-time and providing a framework to interpret
variable effects and model parsimony.
- Modeled claims adjuster productivity using zero-inflated negative
binomial GLM using R package
pscl as well as non-linear
mixed-effects modeling with R package brms, developing
theory for an alternative staffing criterion.
- Forecasted risk of when claim ID numbers might exceed limits using
Bayesian generalized linear regression with R package
rstanarm, providing a recommended date for the start of a
large-scale effort to increase claim ID size.
- Increased efficiency by approximately 80 FTE using a data pipeline
in Python to quantify auto inspector drive times using location
information and Google Maps Distance Matrix API.
- Recast central team SQL dataset using delta compression to reduce
storage size by over 5x and reduce analyst time spent writing lengthy
and repetitive queries.
Contributions additional to role
- Won 1st Prize in the 2024 Inviztational, a company-wide
visualization challenge for a prize of $2000, presenting a dynamic
visualization displaying satellite imagery of hurricanes over their
lifespan.
- Won 2nd place in SPrize 2021, a company-wide predictive modeling
challenge, involving over 15 teams.
- Developed and taught a curriculum for a dual R and Python course to
25 attendees over a 9 month period.
- Spent over 100 hours between 2021 and 2024 providing one-on-one
support to analysts all over the company supporting R, Python, and SQL
questions.