Kavish Chouhan

Supply Chain Analyst

Supply Chain, Retail and E-commerce
4roles
25skills
1education
2credentials

About

Supply Chain Analyst experienced in demand forecasting, inventory optimization, S&OP, and supply chain KPI reporting for retail and e-commerce operations.

Experience

Supply Chain Analyst

IGP (Indian Gifts Portal)

Apr 2024 - Sep 2025

Owned end-to-end inventory planning and demand forecasting for an e-commerce platform. Built Power BI dashboards for inventory turnover, sell-through, and aged stock; optimized safety stock and lead times; led monthly S&OP cycles; and refined ROP and ROQ calculations to improve working capital efficiency.

Inventory & Sales Analyst

Gehna Sang Jevar

Oct 2022 - Nov 2023 · Bokaro

Owned demand forecasting and inventory optimization for a retail jewelry business. Developed Excel driver-based forecasting models, monitored ERP inventory, built ABC analysis frameworks and KPI dashboards, implemented cycle counting and FIFO practices, automated CRM data extraction, and established inventory planning as a best practice across retail outlets.

Operations Analyst

Tech Mahindra

Sep 2021 - Aug 2022 · Kolkata

Managed customer support operations and data analysis to support SLA performance and resource allocation. Built Excel and Power BI KPI dashboards, identified inquiry trends for training improvements, automated data reconciliation, and standardized reporting formats for other teams.

Customer Operations Specialist

Maxicus Kochartech

Feb 2020 - Aug 2021 · Kolkata

Owned customer issue resolution and data tracking for a BPO provider. Analyzed interaction data, built Excel KPI reports, collaborated with team leads on support processes, standardized documentation practices, and supported inventory reconciliation for office supplies and equipment.

Education

Adarsh Vidya Mandir

Higher Secondary Education, Commerce

2019

75% score; Academic Excellence Award in Economics; Treasurer, Commerce Club; School Debate Team Member.

Skills

Demand ForecastingInventory OptimizationStatistical ForecastingDriver-Based ModelingABC AnalysisReorder Point (ROP) CalculationReorder Quantity (ROQ) CalculationBuffer Stock ManagementS&OP (Sales & Operations Planning)Power BIExcel (Advanced)Data VisualizationKPI TrackingForecast Accuracy AnalysisERP SystemsInventory Management SoftwareBarcode ScannersCycle CountingFIFO MethodStakeholder CommunicationProcess CoordinationRetail/D2C Supply ChainOmnichannel Inventory ManagementCRM ToolsOTIF (On-Time In-Full)

Projects

Inventory Optimization Dashboard for Retail Operations

Developed a Power BI dashboard for inventory turnover, sell-through rates, and aged stock. Incorporated ABC analysis and seasonality adjustments and automated ERP data extraction to support replenishment decisions and inventory health reporting.

Demand Forecasting Model for E-Commerce

Built an Excel-based driver-based forecasting model for key SKUs using promotional effects and market signals. Aligned inventory plans with campaign calendars and optimized ROP and ROQ calculations to reduce stockouts and improve working capital efficiency.