Summary
Overview
Work History
Education
Skills
Sports
Timeline
Generic

CODY FOREMAN

Herriman,UT

Summary

Analytics Manager known for helping functions in the business translate business and financial goals into actionable data management plans. Bridges gaps between technical and non-technical personnel. Provider of holistic, beneficial analytics oversight for leadership teams.


Extended knowledge of ERP systems such as SAP and Oracle. Strong experience in reporting tools such as Microsoft SQL Server, Bigquery, Python, Excel/Google sheets, and Tableau. Planning systems include IBP, FMT (excel driven forecast model), Anaplan, and John Galt.

Overview

5
5
years of professional experience
5
5
years of post-secondary education

Work History

Sr Manager Analytics and Inventory Control

Sunrun
Lehi, Utah
05.2022 - Current
  • PMO for ERP Cloud implementation project for Supply Chain.
  • Lead data migration from BigQuery to Snowflake efforts for Supply Chain. Including DBT build out of source truth tables.
  • Built integrated Python scripts in Snowflake pulling data such as historical metal prices, carrier tracking information, and Workfront ticket data.
  • Team built Tableau dashboards for Planning, Procurement, Logistics, Service, and Warehouse Operations providing necessary metrics for leaders to track teams.
  • Worked with TMS provider on building a database with ETL connection to their system for enhanced logistics reporting.

Sr. Staff Demand Planner

Sunrun
Lehi, UT
09.2020 - 05.2022
  • Planner and Buyer responsibility for $440M in spend per year.
  • Led inventory constraint meetings with executive leadership team. Provided recommendations based on analysis of market level sales and attach rates.
  • Built source of truth queries for buying and planning team in BigQuery and integrated into supply chain reporting tools
  • Built replenishment tool designed to simplify warehouse requirements and provided recommended orders that were ready for uploaded. Reducing avg. replenishment time for planners from 4-5 hrs to 30 minutes. Increasing SLAs from 85% to 96%.
  • Provided ad-hoc analytics and operational expertise to drive fact-based inputs into forecasting.
  • Improved demand forecast for multiple distribution channels based on previous sales and consumption.

Supply Demand Planner

VIVINT
Lindon, UT
02.2019 - 09.2020
  • Developed and implemented a dedicated profile SQL query which utilized historic usage to drive service levels from 86% to 96.5% and save the company $1.5 million in truck rolls
  • Planned inventory cradle-to-grave equaling $136 million in inventory spend per year
  • Played integral role in reducing company inventory position by 33.4%
  • Reduced NPI cost by $10.6 million during strategic planning of 4 NPI products (ramp plans, inventory targets, product cutovers) by building a data-driven analysis that recommended ideal launch date and highlighted key risks associated with excess and expedited
  • Managed top two products at 98.5% service level with an 80% reduction in inventory DOS ($6.59 million inventory reduction) due to supplier constraints during COVID-19 pandemic
  • Strategized plan to decreased freight spend during Coronavirus by $496K
  • Planning Systems: IBP, FMT (excel driven forecasting model), John Galt

Team Lead Inventory Control Analyst

Vivint
Lindon, Utah
07.2017 - 01.2019
  • Pushed team to drive a 99.6% warehouse inventory accuracy by implementing new strategies that reduced manual interactions
  • Managed inventory team responsible for company reporting on over $100 million in on-hand inventory
  • Team responsible for driving $3.2 million in savings
  • Worked directly with 40 Forward Stocking Locations to help develop a training program clerks in SAP, assist in inventory transactions, occasional on-site trainings
  • Project Management experience with nationwide office expansion
  • Developed inventory reports for company leadership, providing insight into company in transits and write offs
  • Created and implemented standardized processes for inactive tech inventory clean-up, return merchandise authorization, and in-transit equipment which resulted in an inventory clean-up of $1.4 million.

Education

Bachelor of Science - Biology, Lab Science

Mars Hill University
Mars Hill, NC
08.2012 - 05.2016

Master of Science - Supply Chain Management

University of Denver
Denver, CO
01.2021 - Current

Skills

Tableau

undefined

Sports

Passionate about watching and playing sports. Activity participate in soccer league. Watch soccer, football (NFL and NCAA), and Basketball (NBA)

Timeline

Sr Manager Analytics and Inventory Control

Sunrun
05.2022 - Current

Master of Science - Supply Chain Management

University of Denver
01.2021 - Current

Sr. Staff Demand Planner

Sunrun
09.2020 - 05.2022

Supply Demand Planner

VIVINT
02.2019 - 09.2020

Team Lead Inventory Control Analyst

Vivint
07.2017 - 01.2019

Bachelor of Science - Biology, Lab Science

Mars Hill University
08.2012 - 05.2016

Similar Profiles

CREATE PROFILE
CODY FOREMAN