Ayan K Mukhopadhyay
Supply Chain Planner
Dona Paula, Goa
Summary
With over seven years of experience in corporate sectors, specializing in strategic planning, design, operations and management, supply chain administration, project management, and mentoring. Known for a strategic approach to business operations as an SCM specialist. Possessing a deep understanding of market trends, workforce dynamics, and logistics, enabling streamlined processes, improved efficiency, and adaptation to shifting economic and industry demands.
Overview
13
13
years of professional experience
4048
4048
years of post-secondary education
5
5
Languages
Work History
Supply Chain Planner
Trent Hypermarket Private Ltd
04.2021 - Current
- Company Overview: A Tata & Tesco Enterprise
- Handling a portfolio (FMCG an Hardlines) that consists of 45% of the overall business.
- Oversaw a 66% growth in trade (INR 120 Crores to INR 200 Crores per month) in the span of one year, within the same operating regions.
- Re-calibrated local and centralized supplying channels of the assortment, to cater to the mentioned growth in business.
- Streamlined vendor-ordering systems to adjust to a 40% reduction in overall range, and simultaneous outbound ordering systems for a 55% increase in volume among more than 60 stores.
- Handled the ordering system migration from SAP to HANA, at the beginning of the 2022-23 FY.
- As part of the Tata Business Excellence Module, designed and document the principles and processes in supply chain, which were highlighted under the organisation's best practices.
- Formulated demand planning and generated supply chain management metrics.
Supply Chain Vendor Manager, Assistant Merchandising Manager
Reliance Retail Ltd.
02.2018 - 04.2021
- Company Overview: JioMart, Navi Mumbai
- Selected in the Supply Chain-Replenishment team for the successful launch of JioMart.
- Handled a portfolio (Home Care and General Merchandise) that contributed to 18-20% of overall business. Oversaw a 9-fold revenue increase in the category in 8 months.
- Was elected in the ad-hoc expansion project, comprising 5 other managers, to grow the business base from 1 location to 25 locations.
- Extrapolated the ordering and forecasting systems to these 25 locations, resulting in monthly business growth from INR 45 Crores to INR 320 Crores. The timeline to achieve this was 6 months. We managed to complete it in 4 months.
- Involved in the supply chain operations of Future Retail, as part of their merger with RRL.
- Prior to JioMart, worked as a merchandising manager in their online team. I was part of the Staples department that contributed to 70% of the total business.
Warehouse Inventory and Operation
Panasonic India Private Ltd
05.2017 - 07.2017
- Designed Productivity Improvement Measures in Warehouse Operations.
- Extensively used Time-and-Motion, Inventory Ageing and Stock Stacking techniques to improve the turn-around time of the depot by 21%.
Project Intern in Marine Instrumentation
CSIR-National Institute of Oceanography
09.2014 - 01.2015
- Company Overview: Goa
- Studied the working of Variable Buoyancy Systems (VBS), i.e., the application of the principal of buoyancy to the submerging and surfacing of underwater vehicles, and applying them to our own vertical profilers.
- Designed an Alternate VBS that saved more than 40% of the power consumed in earlier version.
Student Intern
CSIR-Central Mechanical Engineering Research Institute
05.2012 - 07.2012
- Company Overview: Durgapur
- Worked on Liquid Dielectric Breakdown in Micro-Electrical Discharge Machine (Micro-EDM).
- Tested the function of this sophisticated machine tools in different P-T conditions.
Education
Executive Certification - Strategic Change Management
Kellogg School of Management - Northwestern Unv
Illinois, USA 04.2001 -
MBA - Operations & Supply Chain
Balaji Institute Modern Management
Pune, India 04.2001 - 01.2018
Bachelor of Engineering - Mechanical
Visvesvaraya Technological University
Belgaum, India06-2014
Higher Secondary - Science
Kendriya Vidyalaya-CBSE
Goa, IndiaHigh School -
Kendriya Vidyalaya-CBSE
Skills
- Supply Chain Administration
- Strategic Management
- Operations
- Planning
- Design & Modification
- Process Setup and Documentation
- Project Management
- Proficiency in SAP
- Proficiency in SQL
- Learning
- Development
- Mentoring
- Interpersonal Skills
- Communication Skills
- Problem-solving Skills
- Cross-cultural Sensitivity
Accomplishments
- Certified Green Belt in Lean Six Sigma (2018)
- Entrant in the Tata Crucible Corporate Quiz Contest (2014)
- Quarter-Finalist in the Intra-University Lawn Tennis Tournament (2013)
- Represented High-School, at cluster level, in Volleyball, Essay-Writing and Quiz.
Personal Information
- Height: 174 cm
- Passport Number: U6013517
- Date of Birth: 05/01/92
- Gender: Male
Publications
- Manpower Economics, Mukhopadhyay Ayan K, 2025, Theory of India, p 125-133, ISBN 978-93-5911-162-9
- Analysis of damaged and returned goods (RMA) in the Warehouse, Mukhopadhyay Ayan K, 2018, Corporate Summer Internship. Panasonic India Pvt. Ltd, 26p
- Ways to increase the productivity of Warehouse operations, Mukhopadhyay Ayan K, 2017, Corporate Summer Internship, Panasonic India Pvt. Ltd.
- Pesticide Sprinkler Machine Using CAM Profile, Mukhopadhyay Ayan K, Lamani DM, Naik SM, Tyagi S, 2014, Project Report to Visvesvaraya Technological University, 54p
- Kookaburra Ball: The Science behind its Swing Properties, Mukhopadhyay Ayan K, 2010, CSIR- Central Glass & Ceramic Research Institute Annual Magazine, p 73-76
Hobbies and Co-Curricular Activities
- Reading books and the latest articles on nuclear and quantum physics.
- Watching and analysing the choicest of international cinema.
- Listening to podcasts and music from the 1960s - 70s.
- Lawn Tennis on weekends.
Timeline
Supply Chain Planner
Trent Hypermarket Private Ltd
04.2021 - Current
Supply Chain Vendor Manager, Assistant Merchandising Manager
Reliance Retail Ltd.
02.2018 - 04.2021
Warehouse Inventory and Operation
Panasonic India Private Ltd
05.2017 - 07.2017
Project Intern in Marine Instrumentation
CSIR-National Institute of Oceanography
09.2014 - 01.2015
Student Intern
CSIR-Central Mechanical Engineering Research Institute
05.2012 - 07.2012
Executive Certification - Strategic Change Management
Kellogg School of Management - Northwestern Unv
04.2001 -
MBA - Operations & Supply Chain
Balaji Institute Modern Management
04.2001 - 01.2018
Bachelor of Engineering - Mechanical
Visvesvaraya Technological University
Higher Secondary - Science
Kendriya Vidyalaya-CBSE
High School -
Kendriya Vidyalaya-CBSE
Similar Profiles
Chetan S. PridhankarChetan S. Pridhankar
Head - Safety at TATA Retail (Trent Hypermarket Ltd)Head - Safety at TATA Retail (Trent Hypermarket Ltd)
Sanjeev KumarSanjeev Kumar
Distribution Manager at Trent Hypermarket Pvt LtdDistribution Manager at Trent Hypermarket Pvt Ltd
Daniel AllenDaniel Allen
Ministry Support Staff at Trent Youth | Trent VineyardMinistry Support Staff at Trent Youth | Trent Vineyard
Rohan Prakash BorkerRohan Prakash Borker
Project Implementation Team Lead at Perceptron Software Labs Pvt. Ltd.Project Implementation Team Lead at Perceptron Software Labs Pvt. Ltd.
PRIYESHA PALYEKARPRIYESHA PALYEKAR
Reservation Manager at Magnum ResortsReservation Manager at Magnum Resorts