Creation of an application using Excel for calculating the cost savings in the case of staff reductions at Deutsche Bank. Not only are wage costs taken into account when calculating the savings, severance payments, additional payments and all other additional costs are also taken into account. The data calculated in this way are made available in various reports for higher 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 important to comply with all legal requirements.

• Creation of the application for monitoring the Opex initiative of Deutsche Bank in Frankfurt.
• The goal is to save 4.5 billion euros by the end of 2015 through staff reductions / optimization.
• The Leaver Tracker application monitors all necessary processes.
• Monitoring of Deutsche Bank's OPEX program.
• Development of the application (VBA, Excel, T-SQL) with SQL Server.
• Data sources (ETL, SSIS, T-SQL), DWH (SQL Server, Cognos).
• Creating and extending the data model (DeZign).
• Documentation of the data flow and the application.
• Creation of specifications for new requirements and their implementation in
• Integration Services (SSIS).
• Integration Services (ETL).
• Data processing T-SQL
• Data mapping T-SQL.
• VBA application development including client / server solutions with MS Excel.