microsoft
PostgreSQL Developer - Postgres SQL and SQL
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.
UBS Card Center, VB Developer - VB 6.0, Oracle, SQL
Expanding the existing application for the onboarding of new customers in the UBS AG Card Center. New legal templates regarding reporting (VDB16 guidelines for credit cards) are implemented. The application was written in Microsoft Visual Basic 60 and the backend is an Oracle database. Various new forms are generated and the logic is implemented using Visual Basic 60 and SQL. It must be ensured that the new implementations do not affect the existing logic. The new forms are integrated into the existing application, tested and documented.
ETL Developer - Microsoft SQL Server, T-SQL, SQL
This project is about loading the customer data from IBM Europe into the corresponding databases. This is done by means of stored functions, which are implemented in T-SQL.