Executive

Vedant Fashions Limited; Kolkata District; On-site; INR 500,000 - 750,000; Full time

Job summary

Vedant Fashions Limited is seeking an Inventory Planning professional to monitor stock across stores and warehouses, forecast demand, and drive cost-efficient optimization. You will plan purchases, coordinate logistics, and produce actionable insights from sales data.

The role emphasizes advanced Excel, ERP familiarity, and the use of AI tools for analysis to support continuous improvement in inventory and sales functions.

Qualifications

• 2-4 years of experience in Inventory Planning, Demand Planning, Supply Chain, or Retail Operations.
• Prior experience in Retail/Fashion/Apparel/FMCG industry preferred.
• Graduate or Postgraduate in SCM or related field.
• Proficient in Advanced MS Excel and data analysis.

Responsibilities

• Monitor inventory levels across stores and warehouses, ensuring optimum stock availability.
• Plan and release purchase orders and coordinate with sourcing, warehouse, and logistics teams.
• Analyse historical sales trends and forecast category demand; support seasonal planning.
• Improve inventory turnover and reduce stock holding costs; identify gaps and excess stock.
• Analyse sales, stock, sell-through, and category performance; generate MIS reports.
• Participate in inventory planning and supply chain improvement projects using AI/Excel tools.

Skills

Advanced MS Excel

Analytical skills

Inventory planning

ERP knowledge

AI tools for analysis

Education

Graduate/PG in SCM or related field

Tools

Pivot Tables

VLOOKUP/XLOOKUP

Power Query

Dashboards

ERP systems

Power BI

Job description

Key Responsibilities

Inventory Monitoring & Control

• Monitor inventory levels across stores and warehouses.
• Ensure optimum stock availability while minimising excess inventory.
• Track inventory ageing, slow-moving, and non-moving stock.
• Maintain healthy stock cover across assigned categories.

Order Management & Stock Dispatch

• Plan and release purchase orders/replenishment orders.
• Coordinate with sourcing, warehouse, and logistics teams for timely stock dispatch.
• Monitor order fulfilment and stock transfers between locations.

Demand Management & Forecasting

• Analyse historical sales trends and forecast category demand.
• Monitor demand variations and recommend corrective actions.
• Support seasonal and promotional demand planning.

Stock Optimisation

• Improve inventory turnover and reduce stock holding costs.
• Identify stock gaps and excess inventory situations.
• Recommend actions for inventory balancing and liquidation.

Sales & Inventory Analysis

• Analyse sales, stock, sell-through, and category performance data.
• Prepare daily, weekly, and monthly MIS reports.
• Track KPIs and provide actionable business insights.

Projects & Continuous Improvement

• Participate in inventory planning and supply chain improvement projects.
• Drive automation and reporting enhancements using AI tools and advanced Excel solutions.
• Support process improvement initiatives across inventory and sales functions.

Desired Candidate Profile

Education

• Graduate/Post Graduate in Supply Chain, Operations, Commerce, Business Administration, Statistics, or In any disciplines.

Experience

• 2-4 years of experience in Inventory Planning, Demand Planning, Supply Chain, or Retail Operations.
• Prior experience in Retail/Fashion/Apparel/FMCG industry preferred.

Technical Skills

• Advanced MS Excel (Pivot Tables,VLOOKUP/XLOOKUP, Power Query, Dashboards).
• Strong analytical and data interpretation skills.
• Knowledge of inventory planning and demand forecasting concepts.
• Experience with ERP systems will be an added advantage.
• Familiarity with AI tools such as ChatGPT, Copilot, Gemini, Power BI AI, etc. for analysis and reporting.

Competencies

• Analytical thinking
• Problem solving
• Attention to detail
• Business acumen
• Stakeholder management
• Process improvement mindset