microsoft

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.

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:

Adapting and extending an existing Microsoft Access solution. Originally, four files were imported, the data was refined and then evaluated. The evaluations concerned the distribution of the company NEF in Germany. The user interface already existed, realised with Microsoft Access and VBA; this was made a bit more modern and clearer and the new functionality was integrated. In the new application, only two files are now imported and the data is evaluated on the basis of the two files. Again, the import is done by VBA, the user interfaces have been adapted to the two new files and a lot of plausibility logic has been implemented. The evaluations concern the warehouse stocks and the warehouse stock values of the individual employees in distribution.