Business solutions for you portfolio


Company: Deutsche Bank, Frankfurt

Technology: MS SQL Server, MS Excel, VBA.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Apr 2014 – Apr 2015

Cost: no details

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.

  • Creating the application for monitoring the Opex Initiative of Deutsche Bank in
  • The goal is to save 4.5 billion euros by the end of 2015 through staff reduction/optimisation.
  • The Leaver Tracker application monitors all necessary processes.
  • Monitoring of the OPEX programme of Deutsche Bank.
  • Application development (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.
  • Creating specifications for new requirements and implementing them in the development team.
  • Integration Services (SSIS).
  • Integration Services (ETL).
  • Data refinement T-SQL
  • Data mapping T-SQL.
  • VBA application development incl. client/server solutions with MS Excel.
Back to the portfolio
Order a similar project
Order a project

+41 (0)44 586 53 45
+41 (0)76 737 00 84
+41 (0)77 915 25 52


[email protected]

Order a project
Tell us what kind of project you want to do.
Want to order
Upload your brief
For message
Submit project request

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.