Managing director & IT Consultant at Pexon Consulting GmbH

10/2019 – 6/2020

Project responsibility:
 Responsible for Release and Test Management in the company Data Warehouse
 Development of DevOps, CI/CD pipelines, automation of release and test
management processes. Coordination of the release management process for three
company internal teams (onsite and offshore)
Technologies:
 Snowflake Datawarehouse, SQL, Microsoft Azure,
 DevOps, CI/CD, Git, PowerBI

Data Warehousing, Power Bi, SQL, DevOps (allg.), Continuous Integration, Git, Microsoft Azure

5/2019 – 9/2019

Project responsibility:
 Creating a centralized database for data harmonization and integration.
 Consolidation for +10 system. Requirements analysis, design of ETL, target data model
and solution architecture.
 Responsible for DevOps, Release and Test management & deployment of new features.
Technologies:
 Oracle Exadata, MSBI Stack, SSIS, SSAS, SSRS, Tableau, SharePoint

Microsoft SQL Server Reporting Services (SSRS), Tableau, Microsoft SQL Server Integration Services (SSIS), Oracle-Anwendungen, Microsoft SharePoint Server

10/2018 – 5/2019

Project responsibility:
 Architect for Data warehouse: Responsible for Logging and Monitoring and the job
control framework. Additionally, security specification for DB and Cube access.
 ETL specification: Worked on ETL specification for Staging, ODS and DWH master data
institution | taxonomy. ETL tool was SSIS.
 Historization of data: Bi-temporal historization allowing time travel to retrieve historic data.
 Topics: Staging partitioning, Logging framework, Bi-temporal historization, DWH design
Technologies:
 Oracle Exadata, SSIS, SSAS Tabular Cube, Tableau

Microsoft SQL Server Analysis Services (SSAS), Tableau, Microsoft SQL Server Integration Services (SSIS)