Brandon Lee
Data Analyst
Summary
Data analyst with 4 years building SQL-driven reporting for retail and marketing teams. Automated a weekly ad-spend report that cut reporting time from 5 hours to 20 minutes and caught a $40K overspend within the first month.
Experience
- Built a Tableau dashboard automating weekly ad-spend reporting across 6 channels, cutting reporting time from 5 hours to 20 minutes.
- Wrote a SQL query flagging a $40K overspend in a paid-search campaign within its first month live, prompting an immediate budget freeze.
- Ran a pricing A/B test across 3 product categories, providing the data behind a 6% margin improvement rollout.
- Migrated 12 manual Excel reports to Power BI, saving the operations team an estimated 15 hours per week.
- Analyzed customer segmentation data across 200K records, informing a loyalty-program redesign that raised repeat purchases 8%.
- Cleaned and validated inventory data feeding into a demand-forecasting model, reducing stockout incidents 21%.
