

Michael Hopf
Verified Expert in Engineering
Artificial Intelligence Developer
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
Experience
Availability
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
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.
Lead Data Scientist
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.
Specialist in Data Science
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.
Research Assistant
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.
Intern
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.
Intern
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.
Experience
Optimization of Coal 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.
Optimization of Underground Rail
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
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
PhD in Mathematics
University of Kaiserslautern - Kaiserslautern, Germany
Master's Degree in Mathematics and Computer Science
University of Kaiserslautern - Kaiserslautern, Germany
Master's Degree in Mathematics and Computer Science
University of Singapore - Singapore, Singapore