Publication
Supply Chain Optimization Using Python and Mathematical Modeling
https://www.toptal.com/mathematics-expert/supply-chain-optimization-product-blending
Michael is available for hire
Hire MichaelMichael Hopf
Verified Expert in Engineering
Artificial Intelligence Developer
Location
Düsseldorf, Germany
Toptal Member Since
May 3, 2022
Michael is a specialized consultant working on DS projects, especially in the logistics and manufacturing sectors. He's worked on various supply chain optimization projects improving logistics for heavy industry clients like rail, vessels, and mining. He's worked with advanced AI projects involving object detection and NLP. Michael has a PhD in mathematical optimization and was a management consultant in the analytics practice of McKinsey & Company, currently Quantum Black, for four years.
Portfolio
Freelancer
Python, Excel 365, SAP, SAP Business Warehouse (BW), TM1, SQL...
Freelancer
Python, Generative Pre-trained Transformers (GPT), GPT...
McKinsey & Company
Python, Amazon Web Services (AWS), Excel 365, GitHub, Microsoft PowerPoint...
Experience
Availability
Part-time
Preferred Environment
Windows, PyCharm, Microsoft PowerPoint, Excel VBA, Excel 365, Jupyter Notebook, Python, GitHub, Amazon Web Services (AWS), Azure
The most amazing...
...solution I've developed is a train scheduling software for a large coal mining company in Canada with complex product mixing constraints.
Work Experience
Data Science Consultant
2022 - 2022
Freelancer
- Restructured processes to estimate raw material prices and create forecasts for the third-largest printing color producer in the world.
- Developed a new analytically driven process to select a subset of raw materials for manual price forecast by experts.
- Created a method for landed cost simulation to incorporate transport cost and duty cost into business calculations.
- Improved communications between different departments of the company by redefining ways of interactions.
Technologies: Python, Excel 365, SAP, SAP Business Warehouse (BW), TM1, SQL, Microsoft Power BI, Scikit-learn, NumPy, Pandas, Forecasting, Time Series Analysis, XGBoost, Power Query, Snowflake, Linear Optimization, Algorithms, Supply Chain Management, Supply Chain Optimization, Leadership, Vehicle Routing
Lead Data Scientist
2021 - 2022
Freelancer
- Worked for a US startup that develops software for analyzing remote meeting calls like Zoom with AI methods.
- Developed an NLP algorithm to detect questions of different types in conversations and their corresponding answers.
- Built an NLP algorithm to track custom-defined topics in sales conversations.
- Developed an NLP algorithm to segment transcribed conversations into semantically connecting sections.
Technologies: Python, Generative Pre-trained Transformers (GPT), GPT, Natural Language Processing (NLP), AWS Lambda, Docker, Deep Learning, Machine Learning, Scikit-learn, NumPy, Pandas, CTO, Text Analytics, BERT, Amazon Web Services (AWS), Databases, Data Engineering, Startup Consulting, Linear Optimization, Algorithms, OpenAI GPT-4 API, OpenAI GPT-3 API
Specialist in Data Science
2018 - 2022
McKinsey & Company
- Created a network strategy for a global logistics player leading a small team to develop a strategy to combine postal and parcel networks in a novel way.
- Optimized underground rail network system for a platinum mine in South Africa and increased trammed material by 10%.
- Led a team of three data scientists in an analytics engagement to maximize the gas throughput of a gas platform in the North Sea, which led to a 2% increase in production.
- Optimized domestic US shipping for global oil and gas clients for the US Gulf barges market.
- Optimized throughput for an agriculture client at the biggest plant in Europe for oil extraction of soy and canola beans.
- Optimized a rail network for a large Canadian mining company being the lead data scientist of two teams with more than 15 data scientists and developers involved.
- Developed algorithms for the next best action recommendations for digital marketing strategies for a global pharmaceutical client.
- Developed AI image recognition solutions for automated pothole detection for a large construction company.
Technologies: Python, Amazon Web Services (AWS), Excel 365, GitHub, Microsoft PowerPoint, PyCharm, Jupyter Notebook, Azure, Computer Vision, GPT, Generative Pre-trained Transformers (GPT), Natural Language Processing (NLP), Machine Learning, Data Analysis, Data Analytics, Artificial Intelligence (AI), TensorFlow, Amazon S3 (AWS S3), Amazon EC2, Object Detection, Image Processing, Scrum, Scikit-learn, NumPy, Pandas, XGBoost, Microsoft Excel, Power Pivot, Data Visualization, Clustering, Neural Networks, Sensor Data, JSON, ETL, Time Series, Tableau, Convolutional Neural Networks, Business Analysis, Statistical Modeling, Dashboards, Predictive Modeling, Statistics, REST APIs, Technology Consulting, Advisory, R, Azure Cognitive Services, OpenCV, Computer Vision Algorithms, Linear Optimization, Algorithms, OR-Tools, Supply Chain Management, Supply Chain Optimization, Leadership, Vehicle Routing
Research Assistant
2014 - 2017
Universitay of Kaiserslautern
- Worked as a research assistant in the optimization research group.
- Gave lectures and tutored in nonlinear optimization, and supervised master's theses.
- Founded the optimization elite group to guide exceptional students towards a PhD.
Technologies: Optimization, Nonlinear Optimization, Scheduling, Packaging, Research
Intern
2014 - 2014
DZ Privatbank
- Worked in the treasury department as a foreign exchange trader.
- Performed over-the-counter (OTC) trading and validation of foreign exchange (FX) swaps.
- Developed and programmed VBA macros for the automated processing of transactions.
Technologies: Treasury, Trading, Forex Trading, Forex Trading Room, Forex Analysis
Intern
2013 - 2013
Krankenhaus der Barmherzigen Brüder
- Developed a tool for the analysis of clinical pathways in Visual Basic.
- Analyzed patient waiting times and equipment idle times.
- Contributed to staff planning and quality management.
Technologies: Visual Basic, Excel VBA, Excel 365
Experience
Optimization of Coal Supply Chain
We optimized a large Canadian mining company's supply chain.
From mine to port, supporting a $1 billion investment for a new port. I was the lead data scientist of two teams with more than 15 data scientists and developers involved in managing the development of two planning tools that used optimization algorithms to determine the best train schedules, port schedules, and coal product blending.
In particular, product blending (mixing) became apparent as a significant impact lever with considerable opportunities to optimize mixing rules on components or essay qualities.
The final solution was a dashboard where the rail planners received recommendations on which schedule achieves the greatest throughput and why.
From mine to port, supporting a $1 billion investment for a new port. I was the lead data scientist of two teams with more than 15 data scientists and developers involved in managing the development of two planning tools that used optimization algorithms to determine the best train schedules, port schedules, and coal product blending.
In particular, product blending (mixing) became apparent as a significant impact lever with considerable opportunities to optimize mixing rules on components or essay qualities.
The final solution was a dashboard where the rail planners received recommendations on which schedule achieves the greatest throughput and why.
Optimization of Underground Rail
We diagnosed and optimized an underground supply chain from blasting faces to hoists of a large South African platinum mining company.
We improved battery changing strategies and reduced loco congestion to increase the trammed material by 10%. I was the lead data scientist for the development of the planning tool and managed the implementation of change management for the loco crews underground.
We improved battery changing strategies and reduced loco congestion to increase the trammed material by 10%. I was the lead data scientist for the development of the planning tool and managed the implementation of change management for the loco crews underground.
Optimization of Postal Network
We created a new network strategy for a global logistics player to deal with the exploding eCommerce demand during the COVID-19 crisis.
I led a small team, and we developed a strategy to combine and utilize both post and parcel networks in a novel way. We tested the approach with an analytics network model and convinced the CEO to implement the new strategies.
I led a small team, and we developed a strategy to combine and utilize both post and parcel networks in a novel way. We tested the approach with an analytics network model and convinced the CEO to implement the new strategies.
Skills
Languages
Excel VBA, Python, Visual Basic, SQL, R, Snowflake
Libraries/APIs
Scikit-learn, NumPy, Pandas, XGBoost, TensorFlow, OpenCV, REST APIs, Azure Cognitive Services
Tools
Microsoft PowerPoint, GitHub, Gurobi, Microsoft Excel, PyCharm, Microsoft Power BI, TM1, MATLAB, Power Pivot, Power Query, Tableau
Paradigms
Data Science, Scrum, ETL, Linear Programming
Platforms
Jupyter Notebook, Windows, Azure, AWS Lambda, Docker, Amazon EC2, Amazon Web Services (AWS)
Other
Excel 365, Optimization, Integer Programming, Natural Language Processing (NLP), Nonlinear Optimization, Packaging, Treasury, Logistics, Last Mile Logistics, Mathematics, Applied Mathematics, Networks, Machine Learning, Deep Learning, Computer Vision, Artificial Intelligence (AI), Data Analysis, Data Analytics, Neural Networks, Text Analytics, Convolutional Neural Networks, Predictive Modeling, Technology Consulting, Advisory, Startup Consulting, Linear Optimization, Algorithms, OR-Tools, Supply Chain Management, Supply Chain Optimization, GPT, Generative Pre-trained Transformers (GPT), Vehicle Routing, Forex Trading, Graphs, Object Detection, Image Processing, Forecasting, Time Series Analysis, BERT, Time Series, Business Analysis, Statistical Modeling, Dashboards, Statistics, Computer Vision Algorithms, Leadership, OpenAI GPT-4 API, OpenAI GPT-3 API, Recommendation Systems, SAP, SAP Business Warehouse (BW), Scheduling, Research, Trading, Forex Trading Room, Forex Analysis, Philosophy, Data Visualization, Clustering, Sensor Data, CTO, Data Engineering
Storage
JSON, Amazon S3 (AWS S3), Databases
Education
2014 - 2017
PhD in Mathematics
University of Kaiserslautern - Kaiserslautern, Germany
2012 - 2013
Master's Degree in Mathematics and Computer Science
University of Kaiserslautern - Kaiserslautern, Germany
2011 - 2011
Master's Degree in Mathematics and Computer Science
University of Singapore - Singapore, Singapore