Inventory Planning and Replenishment Analyst

Logistics, Shipping & Operations

Planned the inventory replenishment for the whole tile flooring sector by utilizing Excel to create dynamic
forecasting models based on future trend and demand for over 175 SKUs across 1,975 stores.
- Collaborated with the logistics and warehouse operations team in planning and allocating inventory effectively
across 12 Distribution Centers with a supply pipeline of 6 Months.
- Conduct weekly meetings with both internal and external account managers to discuss KPIs, MOHQs,
constrained SKUs, and project readiness status.
-	Effectively increased 2021 revenue by 35% through effective communication with Home Depot IPR team in presenting excel reports and analysis that persuaded large incremental inventory adjustments

- Devised an interactive dashboard on Tableau for the North American budgeting team in aiding decisions about the number of supervisors and distributors needed per region based on sales data from Salesforce.
- Designed data models and reporting agents to build new data streams of databases and queries for automated and Ad-Hoc reports published on SharePoint.
- Identified and eliminated discrepancies and inaccurate data records being transferred from Oracle Business

Inventory Data Analyst

Utilized data mining techniques to analyze revenue and cost data from Tableau to develop new inventory floor
strategies, generating a rise in sales and a 15% decrease in weeks of supply.
- Compiled weekly inventory performance and forecasting reports on Salesforce utilizing R Script and Python data
scrubbing in Excel VBA to enhance data capture of every SKU.
- Developed performance management models on Excel to calculate KPI measures and identify the highest margin
drivers in each category

Merchandise Planner

Find out detailed information about Giovanni Gaona, Inventory Planning and Replenishment Analyst 

Giovanni Gaona: Inventory Planning and Replenishment Analyst

Giovanni Gaona

M S International, Inc

Herbalife Nutrition

Intelligence to Tableau

University of California