• Manipulated and merged large data files using pivot tables, V-lookup formulas, macros, power query and other advanced formatting methods to construct and organize routine and ad-hoc reports using Microsoft Excel.• Performed sales analysis to capitalize on trends and made recommendations to changes in reorder points using historical sales data to sustain inventory availability and avoid stock-outs, under stock, and over stock.• Forecasted sales at a SKU level to supplement proper demand planning and analyzed variance of sales forecast vs actual sales to adjust and construct a more accurate forecast.• Communicated with international vendors to ensure proper flow of the supply chain. Ensured proper planning of shipping schedule with vendors, analyzed lead times, diverted or expedited shipments and placed purchase orders on time.• Worked cross-functionally with marketing and sales teams to support the introduction and growth of new SKUS.