• Lead designer for a new tournaments and events database system for Qatar 2022.

  • Requirements analysis with customer business experts.
  • Data Modeling (CDM, LDM, PDM) in Enterprise Architect.
  • Migration of an existing events management system to the cloud (MS Azure).
  • MS SQL permissions, backup / restore, performance tuning, data anonymization.
  • Introduction of Master Data Management (together with CDQ St. Gallen).
  • Development of DWH for business intelligence (Azure Data Factory, Power BI).
  • Management and coordination of suppliers of database services.
  • Responsible for the smooth operation of all MS SQL Server Databases.

• Data Modeling (CDM, LDM) in Power Designer and Sparx Enterprise Architect;
• Analysis and design of a canonical data model for enterprise data integration;
• Analysis and design of a domain model for the insurance industry;
• Data classification (Master, Transaction, Reference)
• Investigation of use cases for Big Data techniques in the Syrius product;
• Analysis of relevance of NoSQL Databases for Syrius;
• Investigation of alternatives to Oracle DB (PostreSQL, MariaDB and MS-SQL);
• Support for the Syrius DWH product in PL/SQL, ETL process, initial and incremental load;
• Domain Expert for Adcubum in all database questions;
• Creation and presentation of database design and SQL courses;
• Support in all aspects of Oracle DB tuning, SQL and PL/SQL.

• Improvements to physical design and SQL code resulting in an elapsed time reduction for end of year reporting jobs from a projected 150 hours to just 4.5 hours for over 800.000 client investment reports;
• Implementation and testing of database access modules in DB2 and PL/I;

Hired out to Oracle Corporation, Amsterdam as Senior Technical Expert. at the Dutch Tax Authority (Belastingdienst) Apeldoorn.
Physical DB-Design for a DB2 version of the Oracle Enterprise Tax Management system (ETM) including database sizing and capacity planning;
Design and implementation of processes for the efficient transfer of data incrementally from ETM to the Oracle Data Warehouse, OUBI (Oracle Utilities Business Intelligence), using PL/SQL;

Worked for customer UBS AG, Zürich as Senior DB2 Consultant and DBA.
Responsible for all aspects of the use of DB2 in projects CPOS/CREP (client positions and client reporting) which use a very large and complex database on a 12-way data sharing system;
DB2 performance specialist in the MIPS Reduction, Stability and Performance project.

• Physical implementation of SAP HR tables in DB2.
• SAP R/3 Backup and Recovery procedures
• IBM DB2 for z/OS conditional restart used in point of time recovery.
• SAP DB2 administration with BMC Utilities.
• First and second level production support.