Open To Work
Sarvesh Kumar
New Delhi
Summary
Retail Planner with proven expertise in inventory control and data analytics, previously at Jaypore.com. Achieved a 15% increase in turnover through effective stock level optimization and sales trend forecasting. Demonstrates strong multitasking abilities and excels in supply chain coordination for seamless operations.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Retail Planner & Analytics
Jaypore.com (ABFRL Group)
Gurgaon
12.2019 - 01.2026
- Managed inventory performance across 38 stores and different e-commerce channels by executing a range of analytical and operational tasks to optimize stock levels and reduce imbalances.
- Allocation and managing inventory across various categories, such as stitched apparel, unstitched apparel, home, jewelry, footwear, etc. to multiple stores (38 stores) with values of approximately. 70 crore and a volume of 700,000 units.
- Analysis based on season, EOSS, assortment group, and bestsellers based on Pareto, category online vs. offline on L2L, MRP, size, and product sold.
- Analysis based on sales KPIs, such as revenue, sell-through, conversion, and average order value, to monitor performance and support better sales decisions.
- Led Open-to-Buy (OTB) planning for upcoming seasons for eight categories (Women's Apparel, Unstitched Apparel, Men's Apparel, Bags & Wallets, Footwear, Jewelry, Home, and Sarees), aligning purchasing strategies with forecasted sales and inventory.
- Performing season-on-season buy analysis, suggesting the right depth and width for the products.
- Conducted size, best seller, and category mix analyses to identify product trends and enhance assortment planning.
- Performed sales and NSV mix analysis to evaluate product and store-level performance across regions.
- Monitored YTD vs. MTD metrics to assess long-term versus month-to-date performance, aiding in forecasting, buying, and replenishment.
- Analyzed season mix to ensure optimal product assortment aligned with seasonal demand and promotional cycles.
- Prepared Hit/Avg/Miss, Style ROS, and Category ROS reports to improve product allocation and stock distribution.
- Track & Prepared Alignment report to see the Base-fill %, Alignment % & Freshness % for each store at Category-Product- AG level.
- Oversaw allocation and replenishment processes across all stores to meet demand and optimize inventory turnover.
- Oversaw budget planning for the financial year and distributed the budget among different channels at the category level.
- Developed strong partnerships across various departments, including marketing, finance, and warehouse teams, to facilitate seamless coordination of retail initiatives from inception through execution stages.
- Utilized SAP for in-depth analysis of inventory, sales trends, and product performance.
- Analyzed historical sales patterns to identify opportunities for growth within existing product categories, or potential new offerings.
Data Analyst
Rivigo Logistics Private Limited
New Delhi
02.2019 - 11.2019
- The working process includes MIS preparation for Operations such as Detention reports, farming Reports, CRM reports, and Sales and Operations Reports based on multiple KPIs such as Changeover, Pitstop Wait-time, lane-wise performance, Unavailability of Pilots (Drivers), Dry Run, Fuel management.
- Before and after mileage analysis after trucks maintenance.
- Network Balancing Analysis to generate better revenues from earlier.
- Produced tables, pivot reports and charts for use in key decision-making processes.
- Generated reports each month covering Multiple datasets.
- Performed thorough data validation procedures to ensure the integrity of information used in decision-making processes.
Senior Mis Executive
Savan Retailers Private Limited
GURUGRAM
05.2018 - 01.2019
- My working processes commonly include MIS Preparation for business performance and Range Analysis on a daily, weekly, and monthly basis.
- Inventory Valuation for Flipkart Group (Flipkart, Myntra, Jabong) on a monthly basis.
- Preparation of Director's Pack on a Monthly basis showing all the financial on MTD and YTD Level.
Senior MIS Executive
Jabong.com
Gurugram
01.2012 - 11.2017
- Interpreting and cleaning data, with the help excel suite and delivering suitable facts by analysing output.
- Developing and implementing data analyses, data collection systems, and other strategies that optimize statistical efficiency and quality.
- Order Reconciliations as on orders received on a daily, weekly and monthly basis.
- Work with management to prioritize business and information needs.
- Locate and define new process improvement opportunities.
- Creating and updating of product Catalogue (Descriptions/price/images/ latest updates).
- Focuses on standards, technologies, and practices for both business-to-business and business-to-consumer e-commerce models.
- Understands relationships among marketing, promotion, customer service, user interaction, purchasing methods, and secure transactions by using payment gateways, inventory control, shipping, and order information.
IT Assistant
Varuna Integrated Logistics private Limited
New Delhi
04.2011 - 12.2011
- I have worked as an IT Assistant where I have assisted the HR Team to implement Human Resource software which includes Employees Payroll, Attendance, and ETC.
Education
MBA - Information Technology
Lovely Professional University
Jalandhar, Punjab04-2016
B.com - Commerce
Eillim University
New Delhi,Delhi04-2011
Skills
- Inventory control
- Forecasting sales trends
- Data analytics
- Open-to-buy planning
- Stock optimization
- Supply chain coordination
- Performance tracking
- Customer insights
- Microsoft Excel proficiency
- Product allocation
- Multitasking capacity
Languages
English
Upper Intermediate (B2)
B2
Hindi
Native
Native
Certification
Open to Buy: Retail Merchandising Planning.
Work Preference
Job Search Status
Open to workWork Type
Full TimeLocation Preference
On-SiteHybridSalary Range
₹50000/yr - ₹90000/yrTimeline
Retail Planner & Analytics
Jaypore.com (ABFRL Group)
12.2019 - 01.2026
Data Analyst
Rivigo Logistics Private Limited
02.2019 - 11.2019
Senior Mis Executive
Savan Retailers Private Limited
05.2018 - 01.2019
Senior MIS Executive
Jabong.com
01.2012 - 11.2017
IT Assistant
Varuna Integrated Logistics private Limited
04.2011 - 12.2011
MBA - Information Technology
Lovely Professional University
B.com - Commerce
Eillim University