Pulkit Gupta Email & Phone Number

Gurugram, Hr, In

Gurugram, Haryana, India

Gurugram, Haryana, India

Kolkata, West Bengal, India

Handling Annual Primary Freight Cost of 120 crores approx, Vendor Management and Serviceability Management for Biscuits/Confectionery/Beverages/RTE Categories.

Kolkata, West Bengal, India

Understanding the basics of the Supply Chain deployed in the Organization by carrying out various projects in Warehousing for improving the productivity. Also, undergone 3 months Sales Stint for understanding the Sales and Marketing aspect.

Data Driven Decision Making using Tableau & R• Pre-processed raw data & carried out RFM Analysis & Market Basket Analysis using Apriori Algorithm in R• Prepared & drew insights from comprehensive report in Tableau & recommended customer mass campaigns

Mumbai, Maharashtra, India

Project Title 1: Revamping and Redesigning PO Delivery Tracker – One Click Automated Delivery Tracker• Carried out As-Is Analysis of existing process & developed process flow chart for executing PO tracker• Devised Value Stream Mapping and eliminated/modified 6 out of 10 Non-Value Adding Activities• Prepared Contact Database Manager to manage contact information in escalation way using Visual Basic• Designed dynamic templates using VBA/Macro in Excel to automate PO tracking & similar processes• Conceptualized Change Management for executives & prepared SOP as text & video instruction manual • Automated One Click Customized email & text messages to vendors with open PO, Data Management • Reduced activities by 60% and process time by 67% resulting in the Productivity improvement by 200%• Successfully Implemented the tracker Project Title 2: Assessment of Raw Material for Harmonization and Consolidation of Item Codes in SAP•Identified item codes for harmonisation & consolidation based on item description, plant & vendor•Completed harmonization of 7 item & estimated annual savings of INR 10.14 Lacs & mitigating Supply Risk•Proposed 59.13% reduction in item codes to 38 from 93 & shared the recommendations with planning team•Developed Macro-Enabled Dashboard to measure the effect of consolidation on various factorsProject Title 3: SPEED-Extension of Supplier Relationship Management Programme•Designed AHP and devised scorecard for rating suppliers based on Spend & 5C Methodology of Abbott•Enhanced quantum of data stored in dashboard for Quarterly & YoY vendor performance comparison & successfully onboarded 7 new vendors

Rajahmundry

• Spearheaded a 24-member team for testing and completion of oil and gas wells in three districts of A.P.• Orchestrated real time Operation Planning and executed by following SOP and Safety Procedures• Executed Manpower, Equipment and Material Planning for meeting the required operational demands• Coordinated with Cross-Functional units to make the well ready for final production in a controllable way • Explored two highest oil and gas wells which resulted in increased throughput from the asset by 55%• Implemented 5S methodology in the tool bunk house which reduced tool/material handling time by 25%

Jodhpur, Rajasthan, India

• Administered Operations, Maintenance and Accounting activities at the IOC aviation fuel station• Managed Inventory of ATF and maintenance spare parts using SAP MM and S&D modules• Supervised manpower allocation as Shift in Charge and handled customers like IAF, Air India, Jet Airways• Qualified as Quality Control Signatory to keep a check on quality and handling of Aviation Turbine Fuel• Devised automatic sampling machine that reduced sampling time by 50% and alleviated human efforts

• Mapped and Classified the inventory of Trim Chassis Fitment Sumo Assembly Shop based on ABC Analysis • Applied 5S’s principles and designed a Dedicated Kitting Trolley to eliminate Muda of Motion on line side• Designed Kitting Trolley and Supermarket layout for refilling of trolley that reduced congestion in line creating a Lean System• Successfully implemented the trolley and layout in the assembly line with 20% reduction in inventory

Masters In Business Administration, Operation And Supply Chain Management, 8.92

Bachelor Of Technology (B.Tech.), Mechanical Engineering, 82.01

• Vice Chancellor’s Bronze Medal Holder of the batch

Intermediate