Marcus Bell
Atlanta, GA · marcus.bell@example.com · (404) 555-0163 · linkedin.com/in/marcusbell-analytics
Experience
Peachtree Outfitters · Data Analyst II, E-commerce
Jan 2023 – Present
- Traced a 9% drop in repeat purchases to delivery delays in three regions; the fulfillment change that followed recovered $1.8M in annual revenue.
- Built a weekly Tableau trading dashboard for 40 merchants and executives, replacing 12 spreadsheets.
- Ran 30+ A/B tests on checkout and search; one free-shipping threshold test lifted order value 7%.
- Moved reporting tables to dbt in Snowflake, cutting dashboard refresh from 3 hours to 20 minutes.
Southline Grocers · Data Analyst
Jun 2021 – Dec 2022
- Forecast weekly demand for 2,400 perishable SKUs in 85 stores, cutting pilot-region spoilage by 14%.
- Automated the monthly loyalty report with Python and SQL, saving marketing two days a month.
Southline Grocers · Analytics Intern
Summer 2020
- Cleaned and joined three years of point-of-sale data to support a store-remodel ROI study.
Selected Analyses
Customer lifetime value segmentation · Python, k-means
2024
- Segmented 1.1M customers by predicted value; marketing shifted 20% of paid budget to the top two segments.
Store labor model · SQL, regression
2022
- Linked staffing to wait times; the new schedule saved 6,000 labor hours a year without longer waits.
Education
Georgia State University · B.B.A. in Business Analytics
2021
Technical Skills
Querying and modeling: SQL (Snowflake, BigQuery, PostgreSQL), dbt
Analysis: Python (pandas, statsmodels), Excel, A/B testing, forecasting
Visualization: Tableau, Looker, Power BI
Certifications
Tableau Certified Data Analyst (2023); dbt Analytics Engineering Certification (2024)