Marcus Reed
Senior data analyst
Data analyst with five years of experience in healthcare and retail. Turns messy data into forecasts and dashboards that people act on, using SQL, Python and Tableau.
Senior data analyst, Lakeshore Health Partners · Chicago, IL · A network of 14 outpatient clinics
Jan 2023 – Present
•
Built a no-show forecast that lets clinics overbook safely, filling about 1,200 more appointments a year
•
Replaced 30 weekly spreadsheet reports with four Tableau dashboards used by every clinic manager
•
Cut a monthly billing query from 40 minutes to 3 by rewriting it and adding two indexes
Data analyst, Prairie Goods Co. · Chicago, IL · A regional grocery chain with 60 stores
Jun 2020 – Dec 2022
•
Analyzed loyalty-card data to redesign weekly promotions, raising average basket size by 6%
•
Automated the weekly sales report in Python, saving the team a day each week
B.S., Statistics, Westbridge State University · GPA 3.6
2016 – 2020
Analysis: SQL, Python (pandas), R, Excel
Visualization: Tableau, Power BI
Methods: Forecasting, A/B testing, Regression
Tableau Desktop Specialist, Tableau
Sept 2021