Mehul Chhangani
Mumbai
Summary
Results-driven Retail Planning & Merchandising Professional with 3.5 years of experience in inventory management, sales forecasting, and merchandise planning. Proven ability to optimize stock levels, streamline supply chain operations, and drive profitability. Skilled in using SAP, Microsoft D365, and Tableau for data-driven decision-making. Adept at collaborating with cross-functional teams to enhance operational efficiency and maximize sales performance.
Overview
11
11
years of professional experience
Work History
Assistant Manager - Planning & Merchandising
Reliance Brands Limited - Hamleys
Mumbai
07.2021 - Current
- Managed end-to-end planning and merchandising for Hamleys' E-Commerce website.
- Spearheaded the distribution business for key e-commerce partners, Swiggy and Zepto.
- Reduced warehouse costs by 14% by optimizing supply chain operations and finance operations.
- Strategically launched a new retail toy brand, Rowan, and successfully opened five new stores in one financial year.
- Analyzed sales trends and aligned stock strategically to enhance sales performance and minimize inventory wastage.
- Negotiated with suppliers to obtain optimal pricing and product quality, ensuring maximum profitability.
- Developed comprehensive business insights using Microsoft D365, SAP, and Tableau.
- Led automation processes in SAP and Tableau to improve operational efficiency and decision-making.
- Supported in planning and sourcing products for franchise partners in 14 different countries.
- Implemented data-driven assortment planning to ensure a value-segment-centric product mix for RRL Smart customers.
Sr. Associate
Jobuss Resources Pvt Ltd
Mumbai
11.2017 - 07.2021
- Created pivot reports, tables, and charts for tracking business performance and inventory trends.
- Managed data entry, analysis, and reporting using SAP and Excel, ensuring accuracy and compliance.
- Conducted internal audits and compliance checks for Reliance Brands Limited to minimize financial discrepancies.
- Assisted in transitioning Hamleys finance and operations from Sun Systems to Microsoft D365, improving operational efficiency.
- Produced daily, weekly, and monthly reports detailing key business insights for decision-making.
Accounts Executive
ABNJ & Co
Mumbai
05.2014 - 05.2017
- Conducted internal financial audits in compliance with the Companies Act of 2013, ensuring regulatory adherence.
- Reviewed accounts for delinquencies and financial irregularities, reducing risks in financial reporting.
- Assisted in financial reporting, tax compliance, and forecasting, supporting business growth strategies.
- Managed month-end and year-end closing activities, including annual financial reporting and reconciliation.
Education
Bachelors of Commerce - Commerce & Finance
Anandibai Damodar Kale College of Commerce
10.2020
Skills
- Inventory Management: Tracking stock levels, optimizing turnover, and preventing stockouts
- Sales Forecasting: Predicting demand based on market trends and historical data for effective merchandising
- Retail Planning Software: Proficient in Microsoft D365, SAP, and Tableau for data analysis and planning
- Data Analytics: Advanced Excel (Pivot Tables, VLOOKUP, Macros), Power BI for trend analysis
- Assortment Planning: Selecting and managing the right product mix based on consumer demand and market trends
- Negotiation & Vendor Management: Establishing supplier relationships to improve lead time, pricing, and quality
- Visual Merchandising & Pricing Strategy: Optimizing product display and setting competitive price points to maximize revenue
- Leadership & Collaboration: Strong ability to work with cross-functional teams, including supply chain, finance, and operations
- Process automation: Implementing automation using SAP, Tableau, and Excel to improve efficiency and reporting accuracy
Projects & Acheivements
- Rolled out an incentive plan for all Hamleys UK stores, improving sales motivation and performance.
- Reduced warehouse costs by 14% by transitioning from CPU rates to case rates, optimizing supply chain efficiency.
- Launched and managed 'Scrumpalicious' across 12 stores in India, ensuring successful product positioning and sales.
- Led strategic stock alignment initiatives, reducing inventory wastage and improving stock efficiency across multiple locations.
- Developed competitive pricing insights for Hamleys UK E-commerce website, aiding in dynamic pricing strategy formulation.
Timeline
Assistant Manager - Planning & Merchandising
Reliance Brands Limited - Hamleys
07.2021 - Current
Sr. Associate
Jobuss Resources Pvt Ltd
11.2017 - 07.2021
Accounts Executive
ABNJ & Co
05.2014 - 05.2017
Bachelors of Commerce - Commerce & Finance
Anandibai Damodar Kale College of Commerce
Similar Profiles
Mohitkumar GurudantiMohitkumar Gurudanti
Executive- Planning and Merchandising at Reliance Brands Limited- HamleysExecutive- Planning and Merchandising at Reliance Brands Limited- Hamleys
Alice ValeAlice Vale
Build A Bear - Bear Builder at HamleysBuild A Bear - Bear Builder at Hamleys
Harveer KaurHarveer Kaur
Sales Assistant at HamleysSales Assistant at Hamleys