portfolio
ETL Developer - Microsoft SQL Server, T-SQL, SQL
This project is about loading the customer data from IBM Europe into the corresponding databases. This is done by means of stored functions, which are implemented in T-SQL.
SSIS packages analysis for migration SQL Server 2010 to Microsoft SQL Server 2018 - MSSQL T-SQL, SSIS, ETL
Developing a concept for the cost-effective migration of 600 SSIS packages, consisting of an analysis of all existing packages, dividing the packages into three groups, underpinning the concept including calculating the time needed for migration, and developing several options for a cost-effective implementation of the entire migration. The implementation is partly done with in-house staff, with students and with migration specialists. The concept also takes into account performance optimisation of the individual SSIS packages.
Microsoft SQL Server DWH Developer / Consultant - Microsoft SQL Server T-SQL, SSIS, SCCM
The aim of the project is to generate reports based on a data warehouse to be created, which evaluates the data from Microsoft SCCM. For this purpose, a concept is created and then the relevant data from SCCM is loaded into the data warehouse using ETL routes implemented with Microsoft SQL (T-SQL) and Microsoft SSIS. After loading the data, the Enterprise DWH is created and the entire reporting is implemented using SSRS.