REJO JOHN
Summary
An Expert with more than 17 years of experience in retail sector for variety of product categories. A system expert and a demand/supply planner responsible for the administration of demand and Supply planning to ensure the product availability and inventory goals. Metrics and trends analyst talented in identifying unutilized capacities and opportunities.
Overview
2014
2014
years of professional experience
Work History
Sr.Executive Supply Chain
Arvind Retail Ltd
09.2007 - 11.2013
- Assortment planning, allocation and distribution of stocks from DC to 225 pan India stores in 3 different formats.
- Maintained optimum sellable stocks at stores for both private and external brands by managing stock movement from DC, store to store, GRDC, and GRV.
- Planned, ordered, and distributed core menswear merchandise from Indian and international vendors, contributing 12% to overall brand business.
- Plan, implement, execute and optimise Plan-o-grams in Oracle Retek for all existing and new stores for ensuring smooth ARS function and optimum stocks level at stores at any point of time.
- Coordinated with operation teams regularly to understand current and future requirements to adjust ARS parameters for optimum stock availability at stores, especially during festivals like Diwali, Dasara, and Onam.
- Coordination with DC teams to finalise the store dispatch schedules based on transit time, vehicle schedules, performance of the store and seasonal demands.
- Regular monitoring of DC stocks, outbound, inbound, executions and advising them for priority inwards, dispatches.
- Compiled periodic reports for SMT on store fill rates, option availability, size set availability, and DC tracking metrics, including option-wise inbound and outbound, MTD store dispatches, and DC execution efficacy.
- (A Division of Arvind Mills Ltd)
Inventory Controller
Dias Associates
07.2005 - 09.2007
- Inventory Control (Inward, out ward, Defective & Damage control, Shrinkage control, Negative Inventory Control).
- Conducted inventory audits to maintain stock integrity and accuracy.
- Processed stock indents to optimise warehouse inventory management.
- Ensure all products and displays of merchandised effectively in order to maximize sales and profitability.
- Executed billing procedures to ensure accurate customer transactions.
- Customer Service.
Planner – Global Supply planning
Levis Strauss & Co
- Actively evaluate and address supply and resource constraints to meet need of the regional markets (Negotiate capacities and lead time with sourcing teams & vendors,Cross source PC9s from one vendor to another.
- Constrained supply plan based on lead times, MOQ, capacity, and raw materials from regional category inventory management requests, delivering optimal confirmed plans.
- Designed and established processes and policies with GSM team and cross-functional partners to reduce order lead time and enhance agility in inventory investment decisions.
- Work with regional sourcing team and vendors on raw material and capacity staging /buffer to provide flexibility in product replenishment.
- Monitored and reported on finished goods and raw material inventories at vendors to mitigate risk of excess stock.
Manager – Planning and Replenishment
Reliance Trends Ltd.
- Executed demand planning and order placement for core merchandise across 12 warehouses and 2000+ stores, contributing 12% to overall private brand sales from 95 styles in 3 brands.
- Managed stock replenishment in the correct quantities and timely manner to maximise sales by ensuring optimal stock availability at stores.
- Plan, finalise and optimise inventory schedules to stores as per sales forecast, route map and transit period.
- Performed inventory and sales analysis, balancing stock between 12 DCs to maintain optimum stock levels in line with regional sales trends.
- Ensured stock distribution of fashion and ultimate merchandise according to assortments and guidelines during season changeovers, resets, ads, and events from DCs to all four format stores.
- Collaborated with teams in planning, sourcing, merchandising, operations, and DCs to achieve targeted goals by optimising and prioritising processes.
- Directed DC teams to prioritise inwards and dispatches in alignment with current market priorities.
- Weekly communications/Reports to Business heads like PR to POS, POS to GRN, Shelf fill report, Availability reports, Weeks of cover Reports, Option tracker reports, ASN GRN reports, ABC sales reports and other exception reports.
- (A Division of Reliance Industries Ltd)
Education
PG - Supply chain Management
SCDL
Pune, MHBachelor of Commerce -
Calicut University
Skills
- Demand Planning
- Analysis and Replenishment
- Inventory management
- Excel Macros (VBA)
- SAP
- FNR
- Oracle Retek
- Tableau
- Power query
- MS Access
- Leadership
- Performance
- Target oriented
- Communication
- Analytical
- Problem solving
- Supply chain management
Languages
English
Malayalam
Hindi
Tamil
Kannada
Projects
- Excel consultant for developing process improvement macros [Allocation, option replacements, DC scanning etc.]
- Core Team member in developing Vendor managed inventory tool (VMI), 2023-2024
- Core Team member in the development of two replenishment systems (ARS) in SAP and Oracle Retek, 2009-2011
Custom Section
- Recognition certificate for training the Employees (Excel, VBA and Ms Access), 2017
- Recognition certificate for developing work load easing VBA macros for different teams like Planning, MDM and DC, 2015
- Best Performing Employee of the Year for implementing planograms at stores, 2010
Timeline
Sr.Executive Supply Chain
Arvind Retail Ltd
09.2007 - 11.2013
Inventory Controller
Dias Associates
07.2005 - 09.2007
Planner – Global Supply planning
Levis Strauss & Co
Manager – Planning and Replenishment
Reliance Trends Ltd.
PG - Supply chain Management
SCDL
Bachelor of Commerce -
Calicut University