Role & responsibilities:

- Analyze sales, inventory, SKU performance, sell-through and seasonal trends across categories.

- Prepare weekly, monthly and seasonal demand forecasts based on historical sales and store performance.

- Monitor out-of-stock, slow-moving and non-moving inventory and provide actionable insights.

- Support assortment, range and pre-season planning, including option count, depth, ASP, margin mix and sales projections.

- Analyze store/cluster performance and provide inputs for store-wise inventory allocation.

- Support replenishment planning, minimum stock levels, reorder points and replenishment triggers.

- Track product lifecycle and identify replenishment gaps and markdown opportunities.

- Develop and maintain MIS reports, Power BI dashboards and Excel-based planning tools.

- Prepare weekly trading reports covering Revenue vs Plan, Gross Margin %, Sell-through, Category/Brand Performance and Inventory Health.

- Work closely with Buying, Merchandising, Sourcing,



Allocation and Store Operations teams to align supply and demand.

- Identify opportunities for process improvement, automation and forecasting accuracy.

Preferred candidate profile:

- Candidates with 812 years of relevant experience in Retail Planning, Merchandise Planning, Demand Planning, Inventory Planning or Sales Planning.

- Solid hands-on experience in sales, inventory, SKU/category and store-level data analysis.

- Strong understanding of retail planning KPIs such as ROS, GMROI, Stock Turn, ASP, Sell-through, Option Count and Depth.

- Proficiency in Advanced Excel/Google Sheets and Power BI/Tableau.

- Experience with SAP, Oracle, RPAS, Infor or RMS/custom planning systems will be preferred.

- MBA / PG Diploma / PG Degree in Analytics, Supply Chain, Logistics or related fields preferred.

- Strong analytical, numerical, communication and presentation skills with a commercial mindset.

📌 Business Analyst - Planning (Gurugram)
🏢 V-Mart
📍 Gurugram