Intern In Outbound Management And Digitalization
Ingolstadt, Bavaria, Germany
• Planning, optimizing routes, and reducing delivery times for weekly vehicle shipments (rail, truck)• Issuing and analyzing weekly outbound forecasts, independently generating reports, and collaborating on daily shop floor management and with carriers.• Supporting various digitalization projects in the supply chain for process optimization and visualizationProjects:a. Transport Offer Process Automation with Power Automate and Excel VBAIndependently developed and… Show more • Planning, optimizing routes, and reducing delivery times for weekly vehicle shipments (rail, truck)• Issuing and analyzing weekly outbound forecasts, independently generating reports, and collaborating on daily shop floor management and with carriers.• Supporting various digitalization projects in the supply chain for process optimization and visualizationProjects:a. Transport Offer Process Automation with Power Automate and Excel VBAIndependently developed and implemented an Excel VBA tool in the outbound department to issue special transport requests and analyze received offers for selection. Created contracts for the selected service providers using a Power Automate workflow according to company requirements and evaluations, and stored them in SharePoint.b. Amazon Quicksight (AWS) Dashboard (KPI - Inbound Production and Shipping)Created a dashboard to present the production of cars versus shipments to various destinations.c. Power BI Dashboard (Weekly Production and Quota Volume)Executed and implemented the KPI Dashboard project for the board to visualize weekly quota volumes and the corresponding weekly production of vehicles for critical destinations. Show less