RANJEET JAYWANT PANGERKAR
Navi Mumbai
Summary
Dynamic professional with extensive experience in supply chain management and inventory control at Reliance Retail Limited. Proven expertise in SAP ERP and data analysis, driving operational excellence and minimizing discrepancies. Strong communicator and problem-solver, adept at enhancing efficiency and achieving targets through strategic planning and collaboration.
Overview
19
19
years of professional experience
Work History
Asst. Manager
Reliance retail limited
Navi Mumbai
10.2021 - Current
- SCM Operations:
- Key Deliverables:
- Handling PAN India stock inventory specially of In-transit (SIT) goods/Articles
- Daily monitoring of In-transit inventory in SAP, also publishing summarized report to respective Distribution Centers (DC’s) & Store In-charge
- Daily doing co-ordination and follow-up of pending In-transit stock Inventory with the respective stake holders
- Closely monitor of stock movements in SAP while creating STO/STN/RTO with respective Site codes and SLOC in the system
- Timely monitor pending PGR once stock is reached to the respective Stores or return back to the DC’s
- Maintain the Dispatch/Delivery TAT as per the SLA/SOP decided by management (2 to 3 days - Local & 3 to 5 days - Up-country area)
- Expatriation and deeply focus on A class or called as serialized Inventory (LED TV, AC’s, Refrigerator, MWO, Mobile, Tab, Laptop, Apple products Etc.)
- Critical Consignment Alignment through courier partner (Blue Dart, Delhivery, Ecom Express)
- Having concrete co-ordination in between Courier partner, Supplying & receiving site for seamless stock delivery
- Expertise in real-time stock tracking, loss prevention, and logistics coordination
- In-transit loss will be charged to the respective courier partner after RCA done as per the management decided SOP
- Ensuring seamless stock transfers, vendor coordination, and adherence to process-driven inventory controls. Adept at minimizing stock discrepancies, improving supply chain efficiency, and driving operational excellence through data-driven decision-making.
- Preparing the All India In-transit (SIT) Inventory report for Including with Pendency/Lost in transit, daily, weekly and monthly basis for presenting to management team analyzing of Inventory cost, it’s helps for such as reduced inventory discrepancies or improved reporting accuracy
MIS - Sr. Executive
Mitashi Edutainment Pvt. Ltd.
Mumbai
07.2018 - 10.2021
- Key Deliverables:
- Setting up an offtake reporting system
- Preparing the Annual Sales Budget and planning Product, Zone, State, Area and employee wise along with CEO and Management.
- Circulate Product Price List categories with Distributor, Sub-Dealer, and Retailers on monthly basis.
- Preparing and handling the product wise Schemes as per the management norms circulating on monthly basis.
- Making of Stock, Outstanding (AR Report), Collection, Sales, Performance Report on Daily basis.
- Outstanding is major focus and analyses with Ageing Days category.
- The same will be share to reporting bosses (CEO, HOD’s, MD) and management team.
- On basis of those reports taking weekly con-calls with Sales team and management as per schedule decided by management.
- MIS and Reports:
- Analyze the Data and Generate Master performance report on daily basis which is highlighting below points:
- O Top 10 SKU’s - Sales in Qty & Value in lac. (In each Category)
- O Top 20 SKU’s - Highest Inventory taking as well as Ageing in stock consumption
- O Top 10 Sales Employees relating to Sales and Collections
- O Top 50 Partners relating to highest sales and monthly contribution
- O Top 50 Partners wants to Management support related to monthly budget and product pricing
- O Month wise Last Yr vs Curr. Yr and Tgt vs Curr. Yr performance Sheet.
Spare Parts Planner
PE ELECTRONICS LTD.
Mumbai
08.2014 - 03.2018
- Key Deliverables:
- System Development and Integration
- Development in Software - SAP, ERP & CRM. Serial number activation into the software
- New module formation - Transit material with dispatch details. Started different process for SPD material billing specially for A-Class material. Auto-billing generation of loan ageing material. In CRM - Started new activity as mapping serial numbers for all the A-Class material
- HO CRM Report:
- Prepares daily CRM part pending report. Checking each n every part status as per the stock availability of PAN India stores. Maintaining the database. Arranging for additional spare parts as per the requirement
- Spares Part Planning:
- EOL models - Prepare report on EOL (End of Life) spare parts, to maintain the record and availability of spare parts as per MSL/Consumption/Part Pending requirement.
- New models - Generating report based on the running/serviceable parts of new models to check the availability of the parts and provide to the customers as per the requirement
- Revenue / Consumables / OW parts
- Generate reports based on requirement of ASC (Area Service Centre). Tracking the database for billing and revenue generation and provide report on monthly basis
- Checks the billings as per the spare parts available and make provision for the future availability of the stock
- Alternate with Price Part Master
- Timely release of QCEPSL Part Master. Generate code for spare parts on weekly basis, for easily checking availability to the store in charge. Maintaining and updating weekly the code master report
- ITS (Impossible to supply) - maintaining record of the ITS parts.
- Purchase Register
- Purchase cost tracking report. Compare the current purchase register with last year register
- Generating report on the purchase database. Provide the data to the seniors for getting some solution if there is any failure compare to last year.
- RPC Central Warehouse Managing
- Finalizing Norms and SOPs for warehouse operation. Implementing Stocking Points to cater to branch requirements and efficient distribution. Storage at the warehouses as per norms and Safety hygiene requirements, maintaining 5S
- Planning of Stocks at all 24 warehouse locations to support new product releases, field requirements, failure patterns, seasonality, all these activities managing through RPC’s.
Stock Point- In charge
HAIER INDIA PVT. LTD.
Mumbai & Thane
02.2012 - 08.2014
- Key Deliverables:
- Managing 6 Service Franchisee & 2 Direct Service outlets. Resolving client issues, checking data accuracy & integrity on daily basis. Stock Coordination and Maintenance from the main factory & all Regional branches as per the availability. Coordinating and Controlling Minimum Stock Level across all branches
- Managing, maintaining and controlling loan billing of regional branches along with monthly MIS. Managing collection and distribution of defective spares from factory to branches
- Audit:
- Audit all regional branches - Physical & Electronic. Verification of customer job sheets
- Verification of spares loan to technicians. Physical & Electronic verification of A-class stock of the branches
- Verification of Intransit material - Physical & Electronic. Physical verification of spares as per BIN locations
- MIS:
- Tracking of transaction Data generation and verification on daily basis. Urgent MIS reports as required by the HODs apart from maintaining monthly, quarterly, half yearly & yearly reports
- Daily MIS reports - Part pending report, Branch Inventory, Branch Loan status, Branch Intransit, Material Consumption report (Management & Branches)
Jr. Officer-Stock Point Incharge
VIDEOCON INDUSTRIES LTD. (TekCare India Pvt.Ltd.)
Mumbai & Thane
06.2007 - 01.2012
- Key Deliverables:
- Managing 9 branches in Mumbai & Thane along with Bhiwandi godown. Resolving client issues, checking data accuracy & integrity on daily basis. Managing, maintaining and controlling loan status of regional branches along with monthly MIS. Verification of Intransit material - Physical & Electronic
- Inter Branch Transfer (IBT) - according to the software, checking the availability of the stock & making Branch to Branch spares available. Tracking and resolving branch part pending status.
- CWH (Central Ware House)
- Making available the spares & parts from CWH dispatch management team & product head and send it across the branches as per the requirement
- Managing collection of defective and distribution of fresh spares from CWH to branches as per their requirement
- SAP (System Application Product)
- SAP system usage since 2009. ERP & MM module - Working on transaction codes (T-codes)
- Preparation of various data, importing the database from the system & preparing the same in excel file as per required formats. Resolving system entry issues of the branches
- NEW INITIATIVE: Started 5S Process - The main function is to establish criteria for eliminating unwanted items. Eliminate unwanted items either by disposing them or by relocating them & maintaining the spares, stock properly with easily available and neat and tidy place
Education
B.Com -
Mumbai University
03.2007
Skills
- Certification of SAP ERP system, Material Management module
- Diploma in Hardware and Networking from Keerti Computer Institute
- Certification in Information Technology
- MS - CIT, MS Office, Advance Excel from SESCOM Computer Centre
- Tally 90, DTP Internet, Graphic Designing
Disclaimer
Declaration - I hereby acknowledge the above said information is authentic. Ranjeet Pangerkar
Timeline
Asst. Manager
Reliance retail limited
10.2021 - Current
MIS - Sr. Executive
Mitashi Edutainment Pvt. Ltd.
07.2018 - 10.2021
Spare Parts Planner
PE ELECTRONICS LTD.
08.2014 - 03.2018
Stock Point- In charge
HAIER INDIA PVT. LTD.
02.2012 - 08.2014
Jr. Officer-Stock Point Incharge
VIDEOCON INDUSTRIES LTD. (TekCare India Pvt.Ltd.)
06.2007 - 01.2012
B.Com -
Mumbai University