About Shubham
English
Native or bilingual
Experience
- RemoteInventory Management & Systems ConsultantE-COMMERCEOctober 2018 - Today (7 years and 8 months)- Experience spanning across inventory systems, audit, advisory & cost optimization- Worked with inventory-based businesses managing 500+ SKUs across Amazon, Shopify, & Walmart- Built inventory planning & forecasting models using spreadsheets and custom tools- Implemented BOM-based costing, shelf-life-based liquidation & reorder planning tools- Designed & automated MIS reports, dashboards & tools for multi-location businesses- Supported F&B, consumer goods, and ecommerce clients in margin analysis & inventory health tracking
- Mau BrandsSupply Chain AnalystRETAIL (LARGE RETAILERS)May 2021 - December 2024 (3 years and 7 months)- Led inventory forecasting & ordering, FBA planning & overall performance reporting, developed & implemented custom ordering & shipment management tool)- Designed forecasting models using both top-down & bottom-up approaches, integrating historical sales, seasonality, ad spend trends, stock-out data & management inputs.- Implemented order planning trackers for more than 500 SKUs sold across multiple countries & marketplaces (including Amazon, Shopify, Walmart), improving order accuracy & reducing overstock.- Implemented reorder logic based on sell-through velocity, shelf life & lead times.- Ensured optimum inventory levels for new product introductions (NPIs), during seasonal peaks, and unforeseen demand shocks.- Built dynamic dashboards (Google Sheets + Amazon integration) to track inventory health metrics like excess inventory %, stranded inventory & aged inventory thresholds.- Designed & implemented Inventory, purchase order & Shipment management system using Zoho Creator.
- Soil StoreInventory Management ConsultantRESTAURANTS AND FOOD SERVICEDecember 2021 - January 2024 (2 years and 1 month)- Led inventory forecasting & ordering, developed costing models, BOM analysis, stock reports, shelf-life tracking, promotion strategies, waste analysis & performance dashboards- Built detailed BOM-level costing models, accounting for ingredient yield, wastage & per-unit cost fluctuations.- Advised on inventory liquidation strategies using internal stock transfers, bundled offers & targeted discounting campaigns to reduce holding costs.- Recommended promotion strategies (bundles, discounts, flash sales) based on shelf-life stage, sales velocity & excess inventory.- Conducted in-depth wastage analysis & recommended changes to BOMs & reorder points to improve cost efficiency & consistency.- Conducted remote inventory audits.- Built product-wise & cost center-wise performance reports with actionable insights.- Developed SKU-level P&L to analyze profitability after factoring in FBA fees, referral fees, storage, shipping costs & returns - enabling smarter SKU rationalization.- Developed tools comparing forecasted vs. actuals profits at store & company level.
Recommendations
Be the first to recommend Shubham
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Chartered Accountant (ACA)ICAI2016Chartered Accountant (ACA)
- Cost & Management Accountant (CMA)ICMAI2020Cost & Management Accountant (CMA)