sql server

Create an application using Excel to calculate the cost savings of staff reductions at Deutsche Bank. Not only wage costs are considered when calculating the savings, but also severance payments, additional payments and all other costs that are incurred. The data calculated in this way is made available in various reports for senior management. The application is implemented using SQL Server as the data source and Microsoft Excel as the reporting tool. The application was programmed using Microsoft T-SQL and SQL as well as Microsoft VBA. It was necessary to comply with all legal requirements.

Creation of a data warehouse as a management tool for old people's homes and nursing homes. For this purpose, functions stored in Microsoft SQL Server are written using T-SQL, which extract the data from various sources, the extracted data are refined or transformed and then brought into the correct structure in order to be able to fill the standing schema of the data warehouse. Subsequently, the cubes are formed using SSAS and a report set is set up on the cubes using SSRS. The ETL routes are developed as stored procedures using T-SQL and SSIS. The cube is developed and assumed using SSAS and the reporting is created using SSRS.

The company Bühler operates 2000 SQL servers worldwide. The main task in this project was to administer this SQL server in a ticket-oriented manner. This was done in a team of three employees who were responsible for the administration of this 2000 Microsoft SQL Server. Among other things, the following activities were carried out: