ALEX KUHFAHL
SAN ANTONIO,TX
Summary
Excel | PowerBI | PowerPivot | SQL | Oracle | JDA | WFR | Microstrategy | TeraData | Forecasting | Cross-functional Collaboration | Business Process Improvement | Inventory Planning | Replenishment & Allocation | Supply Chain Management | Supply Chain Guru | Data Guru
Overview
6
6
years of professional experience
Work History
Supply Chain Analyst
H-E-B
12.2021 - Current
- Created an analytical tool using Oracle SQL, TeraData SQL Assistant, PowerQuery, PowerPivot and Excel to find optimal incremental warehouse order to support every possible variation of 400+ stores sourced from 20+ different warehouses for 250,000+ items in order to ensure optimal store capacity beyond cadence-driven turn orders from vendor to warehouse used across all drugstore and grocery commodities.
- Built analytical tool using Oracle SQL, PowerPivot and Excel to find the optimal weekly and daily order increments based on historical and projected inbound freight cost data.
- Created a KPI dashboard that is referred to in annual Joint Business Plan meetings with top vendors using Oracle SQL, TeraData SQL and Tableau
- Evaluated and recommended strategic buys for cross functional business partners.
- Utilized data analytics to identify and resolve supply chain issues and improve overall performance.
- Reported on supply chain KPIs to verify compliance with established standards.
- Used Llamasoft, Supply Chain Guru & Data Guru to model economic scenarios in order to improve timeliness and accuracy of supply chain strategy.
- Cost increase and bracket pricing analytics.
- Commodity markets research.
Senior Inventory Planner
SPREETAIL
08.2017 - 12.2021
- Lead a team of associates and entry level supply planners to optimize buying patterns for all of our import business
- Relied on historical data and leading indicators in various categories including but not limited to raw materials, container rates & global demand
- Worked with manufacturers in an effort to blend our business-to-business processes to ensure ordering & monitoring are optimized through EDI.
- Inspected stocks to identify shortages, replenish supply and maintain consistent inventory.
- Collaborated with cross-functional teams to align production plans with customer requirements.
Inventory Planner
SPREETAIL
10.2018 - 03.2021
- Built 12 month receipt plans allocation strategies and sale forecasts for 81 suppliers that brought in $180 million in annual revenue in 2020
- Helped create a chase/cancel/delay process for both our domestic and import suppliers
- Collaborated with senior level planners and head of supply planning to develop open to buy strategies for 61 of our most highly seasonal suppliers
- Developed strategic purchasing cadence to help optimize inventory turn and inventory position for import suppliers, weekly order suppliers, quarterly order suppliers
- Improved poor performing accounts’ out of stock position on a node level from 68% to 22%, 365 turn from 2.9 to 5.1, contribution margin from 2% to 26%, lead times from 36 days to 18 days, and fill rate from 78% to 96%
- Reduced slow moving and obsolete inventory by 21%
- Led weekly category business meetings with buying team to communicate opportunities and risks to our business
- Managed 5 different categories and improved in our key metrics in every one of them: Baby, toys, pools, tools, and lawn & garden
- Created tools in excel and power pivot using SQL that helped my team develop data driven annual buy strategies, allocation strategies, and grow/maintain/decrease strategies
- Created and led 2 week training schedules for new members of the inventory team on best practices and strategies on how to action to their business.
Business Development Analyst
SPREETAIL
08.2017 - 10.2018
- Collaborated with buying team to obtain back end discounts in order to capitalize on contribution margin opportunities
- Built and managed e-commerce listings across three different marketplaces: Amazon, eBay, and VMInnovations
- Monitored marketplace conditions and seller competition in order to determine optimal pricing on a SKU level while maintaining compliance
- Helped hire and train new members of the Operations Business Analyst teams.
Education
Skills
- Materials Tracking
- Written and Verbal Communication
- Supply Chain Planning
- Customs Documents
- Data Analysis
- Process Improvements
- New Vendor Setup
- Proficient in Excel, SQL, TeraData, Supply Chain Guru & Data Guru
Timeline
Supply Chain Analyst
H-E-B
12.2021 - Current
Inventory Planner
SPREETAIL
10.2018 - 03.2021
Senior Inventory Planner
SPREETAIL
08.2017 - 12.2021
Business Development Analyst
SPREETAIL
08.2017 - 10.2018