Supply Chain Analyst
- Work in a fast paced environment on a team of 3 to ensure proper delivery of promotional stock for the core assortment.- Responsible person for auditing and maintaining forecasts for the entire US, tracking and escalating delivery issues to other stakeholders, making and delivering reports to other managers, VP's, and the COO; and conducting post promotional analysis including the financial impact of availability issues.- Identify write off risk of promotional stock and audit… Show more - Work in a fast paced environment on a team of 3 to ensure proper delivery of promotional stock for the core assortment.- Responsible person for auditing and maintaining forecasts for the entire US, tracking and escalating delivery issues to other stakeholders, making and delivering reports to other managers, VP's, and the COO; and conducting post promotional analysis including the financial impact of availability issues.- Identify write off risk of promotional stock and audit underperforming items.- Tracking and communicating purchase orders and delivery issues to key stakeholders and charging suppliers penalties for late deliveries/ missed sales- Developed a PowerBI dataset and report which increased granularity, reduced margin of error, eliminated inconsistencies in data, and automated redundant tasks.- Identify and track key performance indicators (KPIs) to determine team performance- developed the KPI's/framework for 3 reports and supervised the handoff to another department to centralize promotional data and further automate the reporting process.- conducted an audit of the business RELEX system and discovered an error in the systems logic that was delivering promotional stock to the Retail Distribution Centers (RDCs) late. Created and improved the following excel tools:- Automated replenishment forecasting tool estimate write off risk of leftover promotional stock- KPI controller with a dashboard to quickly analyze team performance- Sales analysis report which consisted of various sales organization and supply chain KPI’s to evaluate financial/operational performance on an individual items level- Zero sales report which flags items that received no sales during a promotional week in a national and per store breakdown- Created simple and effective standard operating procedure checklists (SOP) for responsible tasks- Responsible for the maintenance of large datasets which included sales data, forecast data, and warehouse and store data Show less