microsoft
Migration DWH from Cognos 7 to Microsoft SQL Server
The aim of the project is to migrate a Cognos data warehouse to Microsoft SQL Server. The ETL routes were implemented using stored procedures in T-SQL or SSIS packages were created.
SQL Server Developer - Microsoft SQL Server, T-SQL, SQL
Integration of various risk calculations and risk analyses in cooperation with the actuaries of the company Converium (large reinsurer, today SCOR) in the form of stored procedures in SQL Server. Implemented using T-SQL and SQL.
DB Migration – Microsoft Access, VBA, SQL, VB 6.0
Migration of 200 databases from Microsoft Access 2.0 to Microsoft Access 97. Frontend and backend were migrated in each case. Logic that was implemented using VBA or macros was checked and adapted if necessary. This applied to both the user interfaces and the reports.