portfolio

The project mainly involves the creation of complex dynamic queries in the area of reporting. These are implemented using a Postgre database and PostgreSQL. The main focus is on the creation of ad-hoc reports and evaluations, which are triggered automatically and time-controlled by jobs. The project implements the state requirements regarding the reporting system and the result is the data required by the state regarding the reporting system for banks.

Collaboration in the project team of a large rollout of the Postbank. The aim was to monitor the Windows migration of the entire Postbank. For this purpose, several applications were implemented using Microsoft SQL Server and Microsoft Excel and Microsoft Access. Status files were imported, status data were evaluated and a consolidated status could be published daily. This made it possible to monitor the large-scale project. The migrated computers and the software on the individual devices were of particular interest. Not only the migration of the standard software was monitored, but also the migration of special programmes, some of which were migrated manually to the new environment. Status files in Microsoft Excel or status files from Microsoft Project were used as data sources, which were imported into the Access database.

Creation of a foreign exchange software using Microsoft Access, which displayed the smallest exchange rate changes in real time and triggered corresponding actions depending on the exchange rate changes. The system was developed using Microsoft Access, VBA and SQL.