Dev Panchal Email & Phone Number

West Lafayette, In, Us

Wyoming, Michigan, United States

• Conducted ad-hoc reporting and analysis on warehouse capacity metrics, leveraging Google Sheets, SQL, and Looker Studio and SAP to identify potential capacity constraints and provide actionable insights for improved operational planning.• Developed and maintained dynamic dashboards using SQL and Google Looker Studio to compare historical and projected data, effectively monitoring year-over-year changes in ordered and received quantities and driving strategic decision-making.• Devised and implemented a linear programming optimization model using Python's PuLP library to optimize the selection of items for outside storage, minimizing costs while considering inventory turns, safety stock, and sales factors.• Extracted, transformed, and loaded BigQuery usage data into Looker Studio using scheduled queries to analyze BigQuery usage.

United States

Computing in Industrial Engineering(Undergraduate Course ):• Led weekly lab sessions where I imparted fundamental knowledge in web development technologies such as HTML, CSS, JavaScript, PHP, and SQL.•Utilized interactive teaching methods to ensure students gained practical skills essential for their academic and professional growth.Economic decisions in Engineering(Graduate Course):•Graded assignments and exams, ensuring accuracy and fairness in assessment processes.

West Lafayette, Indiana, United States

•Collaborating with Caterpillar Inc. to develop risk prediction, simulation, and communication capabilities to enable long-term supply resiliency using PowerBI, Python , and time series forecasting algorithms and implementing agile project management methodology.•Conducted market research to determine current market trends on supply chain resiliency and risk prediction strategies using a tactical approach and communicated insights to stakeholders.•Collected raw data, Cleaned, manipulated, and transformed datasets using excel (Power Query) and python (pandas) to make the create a master database.•Leveraging Python, and PowerBI to create machine learning models, making supply chain visuals and BI reports to communicate insights regarding risk metrics and KPIs to key stakeholders and engaging with them to explore specific needs.

Mumbai, Maharashtra, India

Mumbai, Maharashtra, India

.• Played a key role in the ATV (All-Terrain Vehicle) making team, contributing to the design, fabrication, and manufacturing of various components in the suspension, steering, and braking systems.• Prepared and presented technical reports and presentations for the ATV project, effectively communicating complex engineering concepts to diverse audiences in national-level competitions.• Collaborated closely with cross-functional departments, including electronics, chassis, transmission, and marketing, to integrate various systems and streamline the ATV development process.• Leveraged effective teamwork and communication skills to foster seamless coordination among team members, leading to efficient project execution and successful completion.• Demonstrated strong project management abilities, setting clear milestones and deadlines to ensure timely deliverables and meet competition requirements.

Mumbai, Maharashtra, India

•Conducted ABC and VED analysis of inventory items using excel and established SOPs for inventory management by collaborating with the inventory management team.•Applied demand forecasting methodologies, including regression analysis, exponential smoothing, and weighted moving averages, to interpret time series data, enabling informed decision-making and optimizing inventory management strategies.•Monitored and adjusted in-process inventory and determined re-order points to maintain lead time and responded to the stock-out issues using root cause analysis.•Collaborated with cross-functional teams to optimize logistical efficiency by managing economic order quantities (EOQs) and provided data driven decisions by cleaning, maintaining, updating, and analyzing data in excel.

Master'S Degree, Industrial Engineering, 3.7/4

Bachelor'S Degree, Mechanical Engineering, 9.07/10

Activities and Societies: DJS KRONOS INDIACourses: Industrial Engineering-Project Management-Product Lifecycle management-Business.

Diploma, Mechanical Engineering, 94.62%