Andrew Harvell
Shawnee
Summary
Senior Analytics professional with 15+ years of experience transforming complex business data into actionable insights for executives, clients, and cross-functional teams. Proven expertise in SQL, Power BI, Zoho Analytics, and Excel with transferable skills in Looker/Tableau. Skilled at measuring ROI, forecasting program performance, and delivering data-driven storytelling that influences strategic decisions. Experienced in building scalable reporting frameworks, automated data pipelines, and unified data models that improve accuracy and efficiency. Recognized for a consultative, client-focused approach, mentoring teams, and driving organizational alignment through analytics.
Overview
23
23
years of professional experience
Work History
VP of Operations
FoodLuma
01.2024 - Current
- Lead design and management of enterprise-wide analytics ecosystem, consolidating distributor, retailer, and vendor sales data into unified PostgreSQL databases for reporting and insights.
- Build and automate advanced reporting dashboards (Zoho Analytics, Power BI, Excel) to track sales, program ROI, and promotional performance across 30+ vendors and 10+ retail partners.
- Partner with vendors, clients, and internal teams to deliver data-driven insights that influence business strategy, improve forecasting accuracy, and strengthen customer relationships.
- Develop scalable solutions including mapping tables, automated data pipelines, and error-detection workflows that reduce manual effort and improve reporting accuracy.
- Translate complex sales and operational data into executive-level presentations, guiding vendor strategy and retailer negotiations.
- Mentor and support team members on SQL, reporting methodologies, and analytics best practices to increase organizational data literacy.
Owner/Operator
Harvell Trading & Vendor Services
01.2020 - Current
- Founded and lead a data-driven vendor services company supporting specialty food brands and their distribution across national retailers.
- Provide customer-facing analytics and strategic guidance to vendor partners, translating sales data into actionable insights that drive growth, improve ROI, and strengthen retailer relationships.
- Design and manage enterprise-scale reporting systems using PostgreSQL, PowerBI, and Excel to consolidate distributor and retailer data into standardized, scalable reporting solutions.
- Build and automate custom dashboards, pipelines, and data-cleaning workflows that streamline reporting and enable faster, more accurate business decisions.
- Act as a consultative partner for brands, delivering data-driven recommendations on assortment, pricing, and promotional strategy.
- Develop reusable methodologies, mapping tables, and automation tools that reduce manual reporting effort and increase efficiency across the organization.
Category Manager
Lucky's Market/The Fresh Market
08.2016 - 12.2020
- Directed category management and product selection for Specialty Cheese & Deli across multiple national and regional retailers.
- Leveraged internal and external customer data to guide assortment decisions, ensuring product selection aligned with customer demand and market trends.
- Conducted sales and margin analysis to optimize promotional strategy, pricing, and vendor negotiations.
- Identified and introduced new products and merchandising approaches, driving sales growth and customer engagement.
- Partnered with vendors, distributors, and cross-functional teams to strengthen category performance and profitability.
Multiple Roles
Whole Foods Market Inc
08.2002 - 08.2015
- Sales Analyst (2012–2015) – Lead analyst for Prepared Foods, overseeing $1B+ in annual sales across 12 regions and 10,000+ items. Delivered weekly insights and forecasts to the executive team, guiding assortment, promotional strategy, and financial planning. Directed trend analysis for product attributes and consumer behaviors. Led company’s first Data Unification project, streamlining reporting across Prepared Foods and Bakery, reducing department rollout time from 12 months to 2 months.
- Recipe Data Specialist (2011–2012) – Designed and launched new recipe management and pricing program; trained 8 regions in implementation. Standardized cost modeling and recipe data for national Prepared Foods team.
- Buyer & Department Manager (2002–2011) – Oversaw product selection, vendor management, and inventory planning for Prepared Foods, Bakery, and Specialty. Applied sales and customer analytics to optimize assortments and reduce spoilage, while driving category growth through new product discovery and merchandising strategies.
Education
High School Diploma -
Shawnee Mission Northwest High School
ShawneeSkills
- Data Analysis & Business Intelligence: SQL (PostgreSQL), Zoho Analytics, Power BI, Excel (advanced), PivotTables, data visualization; transferable expertise with Looker/Tableau
- Program & Performance Analytics: ROI measurement, forecasting, engagement/utilization analysis, trend identification, benchmarking, executive dashboards
- Data Management & Automation: Data cleaning and transformation (Zoho DataPrep, Power Query, Python), pipeline automation, scalable reporting frameworks, data quality oversight
- Strategic Insights & Storytelling: Data-driven presentations, client-facing insights, stakeholder consultation, translating analytics into business decisions
- Leadership & Collaboration: Project management, cross-functional alignment, scalable methodologies, mentoring junior analysts
Timeline
VP of Operations
FoodLuma
01.2024 - Current
Owner/Operator
Harvell Trading & Vendor Services
01.2020 - Current
Category Manager
Lucky's Market/The Fresh Market
08.2016 - 12.2020
Multiple Roles
Whole Foods Market Inc
08.2002 - 08.2015
High School Diploma -
Shawnee Mission Northwest High School