Pranav Tilekar Email & Phone Number

Pune, Mh, In

Pune, Maharashtra, India

Pune, Maharashtra, India

1. Customer Order Management representative, to Support part inquiry, expedite, back Orders, logisticsoperational impacts, Inter PDC (part distribution center) allocation enquiries and allocation, from multiple stakeholders.2. Daily order Exception handling through 500 + lines through VBA Macros and Data load automated reports and 100 + lines under manual jobs. Ensuring suspension codes to be processed, as per planner’s confirmation3. Ensure daily, MTD, YTD 10 + KPI reports to gather, analyze data to guide an organization’s decision making and improve performance reports like first pass fill (OTTR), & Circulate KPI reports & trends through PPT, graphs or Power BI.4. Keep daily track of 7 power BI dashboard & 4 MIS reporting.

India

1. Analyzing & confirming Sales & Operation plan (S&OP) / (SIOP), & Sales plan, under 5 departments, as Molding, assembly, press shop, stamping & automation & for 4 segments, as Auto, Industrial, Appliances, & Aerospace.2. Analyzing & confirming Standard hours earned file (SHE), for productivity target & days in hand demand (DOH). Achieved average of 50,000+ hours average output per month.3. Analyzing & confirming Material requirement plan (MRP) for around 600+ parts, under production, achieving ITR of 8+ monthly. Analyzing data reports as SCOOP, Power BI, sales data, ABC analysis, ITR, current inventory, forecast analysis.4. Weekly planning, controlling & monitoring production according to sales orders, preparation of purchase requisition, shipments under transit and work order management.5. Majorly handled production for Mold shop, assembly, optimizing machine utilization with least downtime, heijunka analysis, Weekly production plan, in coordination with tool room, stores, maintenance & Quality.

Wagholi

1. Studying and analyzing functional requirements of material replenishment, planning demand and preparing strategic plan for purchasing, with good understanding of P2P cycle.2. Maintaining 9 vendor payments, quality control and reviewing material organization to align with logistics for better consolidation, cost optimization, goods security, full container and less container load.3. Organizing 60 parts of global sample business demand on weekly basis by supervising 3 subordinates in team of 6 project managers.4. Planning and coordinating activities of 30 suppliers related to sourcing and purchase availability of necessary materials.5. Collaborating with 10 + global and 5 regional purchase departments of suppliers under automobile, aerospace and other industries to identify best mode for freight and freight consolidation via e-mail.6. Executing new business projects & purchased required parts for effective results in team of 7 members & 2 project managers.

Ambegaon Bk, Pune

Intern as maintenance moderator and supportive production moderator. Responsible for checking, analyzing and reporting tasks to supervisor. Maintaining documentation and being supportive and moderating lean production works.

Mechanical Engineering, Mechanical Engineering, 69%

High School Diploma, Science

High School Diploma, 83.09

Activities and Societies: Squad mentor, Drama events, RSS events. High school degree institute.