Ryan A. Prescott
Data Analyst
Fresno, CA · (360) 555 0127 · name@example.com · linkedin.com/in/ryanaprescott
Key Qualifications
EXPERIENCE
Six years in retail analytics, four of them as a data analyst.
INDUSTRIES
Grocery retail, consumer packaged goods, produce distribution.
SPECIALTIES
Category reporting, pricing tests, cohort analysis, dimensional modeling.
SYSTEMS
Snowflake, dbt, Tableau, Python, Structured Query Language, Microsoft Excel.
CREDENTIALS
Tableau Desktop Certified Associate; dbt Analytics Engineering certification.
EDUCATION
Bachelor of Science in economics, California State University Fresno.
Results at a Glance
22
Buyers stopped rekeying
40
Stores that showed
$1.4m
Shrink in four
30%
Members it changed
Executive Summary
Data analyst on the merchandising team at a grocery chain with 148 stores across California and Nevada. Six years turning register and loyalty data into the weekly category review buyers actually act on. Builds the models in dbt, the reports in Tableau, and runs the pricing tests category managers ask for.
Signature Achievements
- Rebuilt the weekly category review in Tableau so 22 buyers stopped rekeying numbers into private spreadsheets.
- Ran a price test across 40 stores that showed a 6 percent margin gain on private label pasta and held for two quarters.
- Located 1.4 million dollars of shrink in four store departments by joining register data to cycle count records.
- Cut the merchandising refresh from 90 minutes to 11 by moving three heavy views onto incremental dbt models.
- Wrote the loyalty cohort analysis that narrowed the fuel discount from every basket to the 30 percent of members it changed.
Professional Experience
Data Analyst
Sierra Harvest Markets, Fresno, CA 2022 to present
Merchandising analytics for 148 grocery stores across the Central Valley and northern Nevada.
- Owns the weekly category review that 22 buyers use to set promotions and shelf space.
- Models register, loyalty and vendor funding data in dbt on Snowflake, including the slowly changing dimensions behind store and item history.
- Designs and reads out pricing and promotion tests, running the power analysis that sets how many stores and weeks each test needs.
- Coaches new category managers on reading the dashboards rather than exporting them into Microsoft Excel.
Reporting Analyst
Valley Fresh Produce Distributors, Modesto, CA 2020 to 2022
Only analyst supporting a produce distributor with 60 million dollars in annual sales.
- Built the daily fill rate and out of stock reporting the sales team ran morning calls on.
- Automated 14 recurring workbooks into scheduled queries, saving close to a day a week.
- Reconciled vendor billing against receiving records and recovered 210 thousand dollars in unbilled freight.
Licensure and Certification
Tableau Desktop Certified Associate, 2023
dbt Analytics Engineering certification, 2024
Education
Bachelor of Science in economics, California State University Fresno, 2019
Core Skills
Structured Query Language · dbt · Snowflake · Tableau · Python · Pricing tests · Cohort analysis · Dimensional modeling · Power analysis · Microsoft Excel