Freelancer profile translated to English.

Description

My name is Ernst Stubenrauch. After more than 20 years of experience as a purchasing manager in two medium-sized companies, I retired two years ago. As a graduate engineer (FH) in mechanical engineering, I acquired diverse skills during my professional career – especially in the areas of logistics, controlling, and supply chain management.

In recent years, I have continuously expanded my knowledge in Python programming and successfully implemented several smaller projects. The following activities are particularly noteworthy:

• Automation of office tasks: Development of scripts for processing Excel spreadsheets, creating PDFs, and sorting and processing emails, or automatically evaluating measurement data from production for quality assurance

• Data analysis and visualization: Analysis and graphical representation of sales figures, customer data, or production data.

• Web scraping: Automated collection of information from public websites, for example for market research or price comparisons.

• Maintenance and adaptation: Maintenance and further development of existing, smaller Python applications and scripts.

• Interface programming (API): Creation of scripts for data exchange between different programs.

I am specifically looking for the opportunity to contribute my experience and know-how in temporary, remotely executable projects. I am happy to support your company flexibly and solution-oriented in implementing specific tasks.

Industry field of expertise

Languages

German
Native or bilingual
English
Conversational

Workplace preferences

Remote only

Primarily works remotely

Nik Müller
Creation of a route plan for the delivery of vehicle tires
May 2025 - July 2025 (2 months)
Import of daily orders, geocoding of addresses with subsequent route planning with the shortest total distance, taking into account the maximum number of delivery addresses, tire quantity, and maximum possible daily travel distance in km, with final export.
Nik Müller
Python Programming
RETAIL (LARGE RETAILERS)
September 2024 - Today (1 year and 9 months)
Coburg, Germany
The daily orders are exported in Pycharm. Subsequently, the addresses are geocoded and all orders are determined by the number of vehicles required, taking into account the maximum number of tires + delivery addresses + distance kilometers + specific restrictions of individual addresses (delivery time windows). Finally, the optimal sequence (shortest distance kilometers) is determined for each vehicle and all tour plans are printed.