Business Analyst - Planning

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.
• Strong 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.