j
juan_benavides_

Juan B

@juan_benavides_

Supply Chain Data Analyst

Colombia
Spanish, English
About me
I am a Supply Chain Analyst with 2+ years of experience specialized in demand planning, inventory optimization, and multichannel commercial analysis. I am an expert in developing interactive dashboards and statistical forecasting models using Power BI and Tableau to drive strategic decisions and operational efficiencies.... Read more

Skills

j
juan_benavides_
Juan B
Offline • 
Average response time: 1 hour

See my services

Logistics
I will inventory analysis to reduce dead stock and sell more

Portfolio

Work experience

Supply Chain analyst

Le creuset • Full-time

Apr 2024 - Present • 2 yrs 6 mos

Design and maintain Power BI dashboards to track multichannel sales (Retail, E-Commerce, Wholesale), integrating monthly targets and YoY comparisons with equivalent-days logic. Develop statistical forecasting models (Croston SBA/TSB) for 45,000+ SKUs with intermittent demand, generating unit projections for the 2026-2027 S&OP cycles. Perform ABC inventory analysis, stock reconciliations between CEVA warehouses and the internal system, and margin analysis by channel to optimize profitability. Create P&L reports comparing actual results against RB0/RB1 budgets, and monthly executive presentations of 15+ slides for regional management. Coordinate international purchase order planning using a 15-month demand projection methodology based on seasonality. Lead, for the third consecutive year, the logistics of the Friends & Family event, a global-scale celebration for Le Creuset: coordinating the operational flow for more than 2,000 attendees and ensuring flawless brand execution.