Mathew Lee

Business Intelligence Manager @ Whole Foods Market/Amazon | Studying Data Science @ UT Austin

Austin, Texas, United States Contact Info
473 followers 457 connections

Join to view profile

About

I'm an experienced leader with a demonstrated history of working in analytics throughout the food & beverages and retail industries. My background spans from leading high-performing teams in E-commerce analytics at Whole Foods Market to spearheading data science initiatives at PepsiCo. Skilled in Data Driven Storytelling, Cloud Technology, Web Development, and Leading high-performing teams, I'm always learning something new! I'm currently pursuing a Master's degree focused in Data Science from The University of Texas at Austin to get a deeper understanding of the field. I'm energized most when I'm brainstorming with my team; there's nothing better than solving complex problems collaboratively!

Experience

  • Whole Foods Market Graphic

    Business Intelligence Manager, Whole Foods Market

    Whole Foods Market

    - Present 2 years 4 months

    Austin, Texas Metropolitan Area

    • Deliver Actionable Insights – Led a team of four senior analysts in developing end-to-end data analytics for a $2.8bn E-Commerce business. Guided senior leaders and program managers with data and insights to optimize E-Commerce marketing, selection, catalog, inventory, operations, new channel, and customer growth programs.
    • Customer Behavior Analytics – Analyzed customer cohorts, clickstream data, funnel performance, and conversion rates using Spark SQL and Redshift to inform…

    • Deliver Actionable Insights – Led a team of four senior analysts in developing end-to-end data analytics for a $2.8bn E-Commerce business. Guided senior leaders and program managers with data and insights to optimize E-Commerce marketing, selection, catalog, inventory, operations, new channel, and customer growth programs.
    • Customer Behavior Analytics – Analyzed customer cohorts, clickstream data, funnel performance, and conversion rates using Spark SQL and Redshift to inform site-merchandising, product, and program strategies.
    • Launch Analytics for New Digital Channels – Collaborated with cross-functional Product and Dev teams to launch operational analytics for newly developed Direct-to-Customer and online catering grocery service channels.

  • PepsiCo

    PepsiCo

    5 years 9 months

    • PepsiCo Graphic

      Data Scientist

      PepsiCo

      - 1 year 6 months

      Plano, Texas, United States

      • Applied Data Science – Identified expansion opportunities across the Asia and Australia markets using regression in Azure AutoML. Interpreted and shared model results for category managers to leverage in customer meetings.
      • Lead Geomarketing Capabilities – Managed a team of contracted analysts to optimize regional assortments using clustering algorithms (K-Means, DBSCAN, etc.) in sklearn, contributing to sales increases in the Africa regions.
      • Visualize and Apply ML Model Results –…

      • Applied Data Science – Identified expansion opportunities across the Asia and Australia markets using regression in Azure AutoML. Interpreted and shared model results for category managers to leverage in customer meetings.
      • Lead Geomarketing Capabilities – Managed a team of contracted analysts to optimize regional assortments using clustering algorithms (K-Means, DBSCAN, etc.) in sklearn, contributing to sales increases in the Africa regions.
      • Visualize and Apply ML Model Results – Designed intuitive PowerBI dashboards for 150+ users, in partnership with sales, to gain the adoption of ML generated models across Australian sales leadership.


      Co-Founder and President, Python PEP-Club May 2020 – Apr 2022
      • Inspired and led a team of 10 to establish and grow an advanced analytics community of 350+ members.
      • Sparked member engagement with trainings, data science showcases, office hours, Kaggle events and more.

      HQ Chair/Community Chair, PAN (PepsiCo Asian Network) November 2017 – January 2022
      • Led a team to develop PAN’s AOP. Presented to C-Suite Execs to secure $27k to drive member engagement.

    • PepsiCo Graphic

      Supply Chain Analyst

      PepsiCo

      - 2 years 3 months

      Plano

      • Time Critical Big Data Analysis – Utilized Python to provide time critical visit plan analytics on 4.6 million records. Rapid execution prevented $1 million impact to make, move, and sell operations in 900 stores.
      • Analyze Transportation Cost for Optimization and Load Readiness – Leveraged SQL to identify late loads across FLNA's distribution network. Recommended process improvements to the Director of Supply Chain Strategy to improve distribution center load readiness and order fill…

      • Time Critical Big Data Analysis – Utilized Python to provide time critical visit plan analytics on 4.6 million records. Rapid execution prevented $1 million impact to make, move, and sell operations in 900 stores.
      • Analyze Transportation Cost for Optimization and Load Readiness – Leveraged SQL to identify late loads across FLNA's distribution network. Recommended process improvements to the Director of Supply Chain Strategy to improve distribution center load readiness and order fill rates.
      • Key SQL/Data Analysis Resource – Improved SQL proficiency across the team, enabling the analysts to analyze and improve the product recall process for 1.25MM customers.


      HQ Chair, PAN (PepsiCo Asian Network)
      • Develop structured AOP business case with ERG plank leads and treasurer to deliver plan to Executive Leadership. Secured $29M during AOP review with the Executive Committee and CHRO.

    • PepsiCo Graphic

      Supply Chain Associate Analyst

      PepsiCo

      - 11 months

      Plano, Texas

      • Engineer and Launch Tableau Dashboards – Developed data marts in Oracle via SQL sandbox tables. Applied the tables as a source in Tableau reporting for hundreds of sites to catch product issues, improving order fill-rates.
      • Improve Audit Efficiency – Designed and deployed a full-stack web app to assess data setup accuracy using Golang, Javascript, HTML and CSS.
      • Sourcing Analysis Process Development – Engineered a process to cleanse inconsistent sourcing information for 130,000+…

      • Engineer and Launch Tableau Dashboards – Developed data marts in Oracle via SQL sandbox tables. Applied the tables as a source in Tableau reporting for hundreds of sites to catch product issues, improving order fill-rates.
      • Improve Audit Efficiency – Designed and deployed a full-stack web app to assess data setup accuracy using Golang, Javascript, HTML and CSS.
      • Sourcing Analysis Process Development – Engineered a process to cleanse inconsistent sourcing information for 130,000+ records through Python and SQL analysis.


      Community Chair, PAN (PepsiCo Asian Network)
      • Managed 3 event supervisors who coordinated 45 volunteers for race participation and promotion of 170 cases of new products to 21,000 attendees at the DFW Dragon Boat Festival. Received W2G for execution.

    • PepsiCo Graphic

      Supply Chain Associate

      PepsiCo

      - 1 year 4 months

      Tolleson, Arizona

      • Project Management – Led the adoption of an improved packaging element at the world’s largest Gatorade facility. Reduced material costs lead to a projected savings of $3.8 million across the Gatorade network.
      • Manage a Production Line – Led a team of 12 associates on two production lines, increasing adherence by 5%, resulting in a $350,000 increased throughput. Oversaw production of 40,000 cases for both lines each day.
      • Managed a $20,000 spend project to ensure the facility met AIB…

      • Project Management – Led the adoption of an improved packaging element at the world’s largest Gatorade facility. Reduced material costs lead to a projected savings of $3.8 million across the Gatorade network.
      • Manage a Production Line – Led a team of 12 associates on two production lines, increasing adherence by 5%, resulting in a $350,000 increased throughput. Oversaw production of 40,000 cases for both lines each day.
      • Managed a $20,000 spend project to ensure the facility met AIB, FSMA and other quality standards.
      • Analyzed, identified and reduced water loss by 15,000 Gallons per day on operating equipment.
      • Coordinated with the facility QC team to ensure facility FSMA, AIB, and FSSC preparedness. Participated in FSMA, AIB, and FSSC audits to gain insight and verify facility compliance.

      President, CONNECT
      • Led an ERG group of 15 associates, both hourly and salary, to deliver on PepsiCo’s 80/20 Key Priorities.
      • Implemented Interview Trainings, Associate Engagement Events, Fundraisers and Business Initiative Awareness Campaigns to support talent, culture, community and the business.

  • Henkel Graphic

    Research and Development Intern

    Henkel

    - 4 months

    Scottsdale, Arizona

    • Executed the analysis for reformulation of a consumer product to improve customer satisfaction.
    • Developed a design of experiments to improve the product’s properties in order to optimize the production process.
    • Analyzed statistical data to refine product batching parameters and to communicate design of experiment results.
    • Improved formulation predictive model to better forecast product behavior and consumer acceptance.
    • Created an enhanced database for SEM analysis of hard…

    • Executed the analysis for reformulation of a consumer product to improve customer satisfaction.
    • Developed a design of experiments to improve the product’s properties in order to optimize the production process.
    • Analyzed statistical data to refine product batching parameters and to communicate design of experiment results.
    • Improved formulation predictive model to better forecast product behavior and consumer acceptance.
    • Created an enhanced database for SEM analysis of hard surface composition and topography for global team implementation and research.

  • Arizona State University Graphic

    Undergraduate Researcher

    Arizona State University

    - 1 year 10 months

    Tempe, Arizona

    • Improved experimental design to control film thickness to increase photovoltaic efficiency.
    • Developed improvements for the spray pyrolysis method that was presented at ASU sponsored research symposiums.
    • Collaborated with the research team to resolve characterization challenges and methodology issues.
    • Developed experiments to establish a linear correlation of film thickness to deposition parameters.
    • Gained experience utilizing the profilometer and spectrophotometer to…

    • Improved experimental design to control film thickness to increase photovoltaic efficiency.
    • Developed improvements for the spray pyrolysis method that was presented at ASU sponsored research symposiums.
    • Collaborated with the research team to resolve characterization challenges and methodology issues.
    • Developed experiments to establish a linear correlation of film thickness to deposition parameters.
    • Gained experience utilizing the profilometer and spectrophotometer to characterize samples.

Education

  • The University of Texas at Austin Graphic

    The University of Texas at Austin

    Master's degree Data Science

    -

  • Arizona State University Graphic

    Arizona State University

    Bachelor's Degree Chemical Engineering

    -

    Activities and Societies: American Institute of Chemical Engineers (AICHE) Asian Business Leaders Association

    Regent High Honors Scholar (2012-Present), Active Undergraduate Researcher for 3 years. Volunteer researcher over the summer. Event Coordinator of the American Institute of Chemical Engineers ASU chapter.

Licenses & Certifications

Courses

  • Advanced Predictive Models for Complex Data

    DSC312

  • Advanced Process Control

    CHE 494

  • Analytical Chemistry

    CHM 325

  • Applied Statistics

    STP 420

  • Business/Industrial Engr

    IEE 220

  • Data Exploration and Visualization

    DSC322

  • Data Science for Health Discovery and Innovation

    DSC395T

  • Data Structures and Algorithms

    DSC302

  • Deep Learning

    DSC317

  • Foundations of Regression and Predictive Modeling

    DSC311

  • Intro Chemical Reactor Design

    CHE 442

  • Introduction to Chemical Processing

    CHE 211

  • Modern Separations

    CHE 433

  • Natural Language Processing

    DSC326

  • Numerical Methods for Engineers

    CEE 381

  • Principles Chem Engr Design

    CHE 432

  • Probability and Simulation-Based Inference

    DSC301

  • Process Design

    CHE 462

  • Process Dynamic Control

    CHE 461

  • Six Sigma Methodology/Engineering Experimentation

    CHE 494

  • Structure And Properties-Materials

    MSE 250

  • Tableau Desktop II: Intermediate 2-Day Class

    -

  • Transport Phenomena I: Fluids

    CHE 231

  • Transport Phenomena II: Heat/Mass Transfer

    CHE 334

Projects

  • Devops - Modern Data Analytics Stack In a Box (Pyspark, Apache Superset, Duckdb)

    With advances in hardware and the profileration of more advanced open source software, processing data what used to be “Big Data” no longer requires a complicated cluster of machines and a PhD. In this project, I use Docker to setup DuckDB + Apache Superset for quick no-cost analytics on datasets that can fit on local hardware and be deployed on any laptop. I also include a PySpark docker container, which I’ve used to train teams at Amazon on the internals of PySpark and Docker.

  • Deep Learning - Teaching AI to Play SuperTuxCart

    -

    CNN (Convolutional Neural Networks) are a type of feed-forward deep neural network that leverages convolution layers for visual processing. CNN’s can do amazing things when paired with clever software design! In this project, I leverage a low-level ‘auto-pilot’ controller to train an AI vision based driving system to complete a course of SuperTuxKart.

  • NLP - Analyzing and Improving ELECTRA Performance on Neutrally Labeled Premise/Hypothesis Pairs

    -

    Pre-trained models that over-rely on popular annotated datasets, like SNLI and MNLI, can learn dataset specific “Artifacts”. This hinders model generalization and leads to poor performance when deployed to production. In this paper, I build, train, analyze, and improve model performance for identifying neutrally labelled Premise/Hypothesis pairs using the ELECTRA-Small model and the HuggingFace Transformers library.

  • Kalman Filter - Applying a Kalman Filter to univariate dynamic linear model time series

    -

    Kalman Filters have many applications in aerospace, navigation, econometrics, etc. and is often applied in time series analysis for signal processing. By recursively using “predict” and “update” stages, we are able to estimate a joint probability distribution over the variables by taking the uncertainty into account. In this assignment, I apply the Kalman filter for forecasting a time series.

  • Time Forecasting - Using SARIMA to Predict Dallas Weather

    -

    SARIMA (Seasonal Auto Regressive Integrated Moving Average) is a widely used model that brings components of different Time Series forecasting methods to create a more robust way to forecast. In this assignment, I report the “one-year-in-advance” prediction of temperature for January 2018, along with the upper and lower bounds of the prediction interval.

  • Application Development - Personal To-do App (Golang)

    -

    To-do app created in Golang and hosted on Heroku

  • UI/UX Application Development - Develop Business Friendly Tools

    -

    Most business stakeholders err away from using CLIs (Command Line Interfaces) or from writing complicated SQL. Instead, I designed and built an application that accepts input, queries a MS SQL Server Database, and returns results for master data management teams to maintain tables in SAP.

  • Full Stack Web Development - Small Business Deployment

    -

    Website built, designed and deployed from the ground up using Node.js and Express technologies for a peer's small business.

    See project
  • FURI Spring 2014

    -

    Conduct several experiments to find a correlation between spray pyrolysis deposition time and film thickness. Included optimizing parameters such as temperature, volumetric flow rate, solution concentration, etc. See above for the poster presented at the Spring 2014 FURI symposium.

Honors & Awards

  • Moeur Award

    Arizona State University

    Presented to those who achieved a 4.0 GPA upon graduation.

  • Regent High Honors Scholar

    State of Arizona

Recommendations received

View Mathew’s full profile

  • See who you know in common
  • Get introduced
  • Contact Mathew directly
Join to view full profile

Other similar profiles

Explore collaborative articles

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

Explore More

Others named Mathew Lee in United States

Add new skills with these courses