Jan Hendrik Heinz

Angestellt, Inventory Planer, Dyson GmbH

Köln, Deutschland

Über mich

As an Inventory Planer/Data Analyst with a comprehensive skills in Python, BigQuerySQL,BigQueryML VBA, Power BI, Power Query M code, DAX, and Power Automate. I am adept at extracting valuable insights from data to optimize inventory levels and minimize stockouts. My expertise in automating inventory reporting has resulted in significant cost savings for the company by providing ongoing valuable insights. My proficiency in Python, Excel VBA, Power Automate, and my experience in querying large datasets with BigQuery enables me to increase efficiency, streamline processes, and improve inventory management through data-driven decision making. Furthermore, I am able to uncover hidden insights that were not previously visible by utilizing the powerful capabilities of Python for data analysis and visualization. My skills and experience in data analytics are a valuable asset in driving business success, improving operational efficiency and cost savings.

Fähigkeiten und Kenntnisse

Microsoft Excel
Power Qery M Code
Microsoft Power BI
Daten-Modellierung
Logistikplanung
Reporting
SQL
Datenanalyse
Power Automate
MS Office
ETL
Business Intelligence
Visual Basic for Applications
smart Working
Python Programmierung
Pandas
Analytik
Microsoft Power Plattfrom
Pine editor Programmiersprache
Technologie
Code
Pivot
Datenbank
Management
Führerschein
Englische Sprache
BigQuery
Machine learning beginner level
Deep Learning starting
Scheduling
Data Warehouse
Softwareentwicklung
Rest api abfragen
Google Cloud
Big query
Google BigQuery
Microsoft Azure
Microsoft Fabric
Serverless computing
Data Science
Data Management
Data-Warehouse
Critical thinking

Werdegang

Berufserfahrung von Jan Hendrik Heinz

  • Bis heute 1 Jahr und 10 Monate, seit Sep. 2022

    Inventory Planer

    Dyson GmbH

    Key achievements: - Modeled and analyzed inventory and warehouse data using Power Query M code, DAX, Power BI, Power Automate, and BigQuerySQL. - Improved inventory management through data-driven decision making, resulting in significant cost savings for the company. - Automated inventory reporting and leveraged BigQueryML for machine learning to provide ongoing insights and increase efficiency.

  • 11 Monate, Nov. 2021 - Sep. 2022

    Logistik Koordinator

    Dyson GmbH

    Key achievements: - Conducted data acquisition using VBA, Power Query M and Power Automate, leading to data modeling of inventory and warehouse data in Power BI/Power Pivot Excel. - Streamlined processes and improved operational efficiency

  • 8 Monate, März 2021 - Okt. 2021

    Programmieren einer Handelstrategie

    -

    -Programmed a successful trading strategy using Tradingview and Pine Editor - Demonstrated ability in data analysis, trend identification, and strategic problem-solving - Valuable experience in data analytics acquired. -Skills highly transferable to data analysis roles.

  • 6 Monate, Nov. 2020 - Apr. 2021

    Werkstudent

    ZWILLING J.A. Henckels Deutschland GmbH

    - Contributed to the daily operations of the company by managing and optimizing processes for maximum efficiency - Conducted data analysis and created reports to support decision-making - Collaborated with cross-functional teams to improve processes and resolve issues

  • 2 Monate, Jan. 2015 - Feb. 2015

    Industriekaufmann

    TKM Group - The Knife Manufacturers

    - Assisted in various projects related to Microsoft Excel and production areas - Improved data organization and management through the creation of Excel tools and databases

  • 2 Jahre und 6 Monate, Aug. 2012 - Jan. 2015

    Ausblidung zum Industriekaufmann

    TKM Group - The Knife Manufacturers

    Gained hands-on experience in various departments such as Preparation of Work, Sales, IT, and Accounts Receivable Accounting Contributed to the overall success of the company by collaborating with multiple departments and completing projects in a timely manner Improved processes by identifying areas for improvement and proposing solutions.

Ausbildung von Jan Hendrik Heinz

  • 5 Jahre, Apr. 2016 - März 2021

    Betriebswirtschaftslehre

    Universität zu Köln

    Bachelor of Science in Business Administration, University of Cologne Major 1: Supply Chain Management with Bachelor's thesis on lot sizing and series planning Major 2: Finance

Sprachen

  • Deutsch

    -

  • Englisch

    -

Interessen

Mannschaftssport
Tischfußball
Reading Mircosoft Books
Microsoft Excel Auswertungen
Digitalisierung
Programmierung von Handelstrategien
Kryptowährungen
Lesen
Kochen

21 Mio. XING Mitglieder, von A bis Z