Simon Jansen

Writing Python and SQL scripts to extract, transform and load data from APIs in different Type of databases (SQL & NoSQL). Using GitHub as version control and documentation of my projects (see more details and the code in GitHub profile). Working with dbt, to build data warehouses with different layers, from sources to data marts. Cloud computing by using AWS services (S3, Redshift). Gaining first experience with other tools like Airflow and Docker. Data analysis and visualization with Microsoft PowerBI.

• Business key user for developing a smart IoT-Bluetooth system to track movements of goods along the production and logistics processes. • Project coordination for the implementation in SAP. • Running tests to check the correct processing between Middleware and SAP-System. • Requirements engineering to identify the necessary business metrics and the required data to calculate the metrics. • Design of a dimensional data model for the data warehouse during my bachelor thesis in business informatics.

• Leading two teams of in total 4 direct reports. • Extraction, analyzation, visualization of SAP data to gain insights about the stock and production and to identify potentials for improvement. • Creating dashboards in Excel for the optimized scheduling of the final assembly product groups. • Process optimization and project coordination of internal logistics: Set-up and supervision of the introduction of Kanban control cycles in production on the SAP side. • Daily business responsibilities.

• Scheduling of both purchased and in-house manufactured parts, including order and deadline tracking. • Production planning of pre- and final assembly to ensure the supply of materials. • Tracking and reporting missing parts on a weekly as well as on a historic base for further analysis. • Cross-departmental coordination of production, sales and purchasing departments and their needs for the optimal realization of projects and utilization of the production.

Projektarbeiten innerhalb des Bestandsmanagements, der Materialdisposition und der Intralogistik

Studentische Aushilfe in der Abteilung IT-Infrastruktur

Technische Auftragsbearbeitung im Bereich des Supply Chain Managements: Produktionsplanung, Terminüberwachung, Schnittstellenfunktion (Akquisition, Leitstände, Vormaterialdisposition)

Ausbildung zum Industriekaufmann

Specialization: Business Intelligence Overall grade: 1,3 Bachelor thesis: Design of a data warehouse data model for an information system exemplified by „loopa“ of the Scheidt & Bachmann IoT Solutions GmbH.

Specialization: Production & Logistics Overall grade: 2,2 Bachelor Thesis: Working Capital Management - Conception of a KPI based inventory controlling for purchasing parts.