Summary
Data analyst with five years of experience in retail and subscription businesses. Works in SQL, Python and Tableau. Found the cause of a rise in cancellations that led to a pricing change worth $1.3 million a year, and built the dashboards 60 managers open every Monday.
Experience
Data Analyst, Peachtree Box
- Traced a rise in cancellations to a delivery-fee change using cohort analysis in SQL; the pricing fix that followed kept about $1.3 million in yearly revenue.
- Built Tableau dashboards for sales, retention and operations used by 60 managers each week.
- Designed and read out 14 A/B tests with the product team, including sample sizes and what the result did and did not show.
- Moved reporting from spreadsheets to dbt models in Snowflake, cutting the monthly close report from three days to four hours.
Junior Data Analyst, Marlow Department Stores
- Produced weekly sales and stock reports for 85 stores.
- Wrote Python scripts that automated nine recurring reports and saved about 12 hours a week.
- Flagged a pricing error in a promotion within a day of launch, before it reached most stores.
Education
BS Statistics, Georgia State University
Skills
SQL, Python (pandas), Tableau, dbt and Snowflake, A/B testing, Cohort analysis, Excel, Presenting findings