GG

Giovanni Gaona

Inventory Planning and Replenishment Analyst · M S International, Inc


Work Experience

Inventory Planning and Replenishment Analyst

M S International, Inc

2020 – Present

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

Inventory Data Analyst

Herbalife Nutrition

2020 – 2020

- 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

Merchandise Planner

Intelligence to Tableau

2019 – 2020

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

Education

Bachelors of Arts in Business Economics

University of California

2015 – 2019

Bachelors of Arts in Business Economics