Summary
Overview
Work History
Education
Skills
Software
Certification
Timeline
Generic
Harjot Singh

Harjot Singh

Supply Chain Consultant
Mohali

Summary

  • Experienced Supply Chain Consultant with over 5 years in consulting, specializing in network design, optimization, and technology-driven improvements.
  • Proven track record of implementing solutions that drive tangible results, reduce costs, and maximize customer satisfaction.
  • Proficient in SQL, Python, Power BI, and specialized supply chain softwares, enabling effective data modelling, analysis and visualization to inform strategic decisions.

Overview

6
6
years of professional experience
2
2
years of post-secondary education
6
6
Certifications

Work History

Manager (Supply Chain Network Design)

Bosch
12.2021 - Current

As s the key IT expert in a team of logistics professionals, I have led & supported the following projects across multiple product value chains, using specialized SC software:

  • Supply Chain Optimization (Post-SOP): Created baseline digital-twin models to analyze existing supply chains and simulated various what-if scenarios to identify opportunities for optimization.
  • Supply Chain Network Design (Pre-SOP): Assisted IPN stakeholders in decision-making to design new supply chains with a focus on optimizing logistics costs.
  • Vehicle Route Planning with Supplier Delivery Time Windows: Developed solutions for vehicle route planning, improve truck utilization, ensuring adherence to supplier delivery time windows, reducing logistics costs by 3%
  • Automated Plant Volume Allocation (APVA): Balanced manufacturing and logistics parameters to recommend optimal volume allocation plans for manufacturing plants.

Supply Chain Associate Consultant

Capgemini
07.2019 - 11.2021

Key Responsibilities & Achievements:
Project 1 - E2E Manufacturing Network Optimization

  • Building E2E Manufacturing Network models and running what-if Scenarios to assess impact of changes in demand, surge, uptime (performance, taxation, machinery, network design).
  • Visualization of proposed changes vs. status quo by integration of optimizer with Power BI Dashboards - development & maintenance.


Project 2 - Warehousing & Logistics Optimization

  • Gathering client requirements and brainstorming project road maps on digital transformation of supply chain.
  • evaluated scenarios like Supplier Lead Time Variations, Changes in Transportation Routes, Expansion to New Markets.

Research Intern

ABB
02.2019 - 05.2019
  • Worked on inventory optimization in discrete manufacturing scenario - established time-series forecasting models for order forecasting and increased forecasting accuracy by 42%
  • Worked on Optimizing Supplier Delivery Performance and Buyer Spending Model for Supplier Improvement in Engineer to Order Scenario

Education

Masters of Technology - Industrial Engineering

Punjab Engineering College
Chandigarh
07.2017 - 06.2019

Skills

    SQL Server

    Python

    Microsoft Power BI

    Project Management

    Business Requirements

    Data analysis

    Excellent Interpersonal Skills

    Supply Chain

    SC Network Design

Software

Simulation: Enterprise Optimizer

Oracle – ERP, SQL

Microsoft Excel

Microsoft Powerpoint (Advanced)

Python, Pandas, Matplotlib, Numpy

Microsoft Power BI

Certification

Data Analysis with Python & Pandas -Udemy

Timeline

Manager (Supply Chain Network Design)

Bosch
12.2021 - Current

Supply Chain Associate Consultant

Capgemini
07.2019 - 11.2021

Research Intern

ABB
02.2019 - 05.2019

Masters of Technology - Industrial Engineering

Punjab Engineering College
07.2017 - 06.2019

Data Analysis with Python & Pandas -Udemy

Inventory Management Foundations - Linkedin Learning

Block Chain Basics - Linkedin Learning

Supply Chain Logistics - Coursera

The Ultimate MySQL Bootcamp - Udemy

Microsoft Power BI Desktop for Business Intelligence - Udemy

Harjot SinghSupply Chain Consultant