SaDICon – Various roles and assignments

As a self-employed Business Intelligence specialist (ZZP) I was as a contingent worker for various organisations, including large banking organisations and insurance companies.. 

The technical focus is on:

  • Business Intelligence in general
  • DataModelling (Star, 3NF, DataVault)
  • ETL (mainly PowerCenter)
  • SQL (DB2, Oracle, MS SQL Server)
  • Interfaces
  • Data Integration
  • Performance Tuning of all aspects of the whole BI system

Functional focus of the assignments

  • Decoupling of a Central Datawarehouse due to an organisation split
  • Realisation and expansion of Enterprise-level DataWarehouses
  • ETL Tool selection for global DataIntegration process
  • Functional and technical design of DataWarehouse-expansion
  • Tuning and Performance improvements of existing systems
  • Coaching of junior colleagues

In this period I also spend time on a selfstudy programming in Java. To get practical experience in this area, I help a relation building an Open Source DataWarehouse generation system, based on DataVault.

Core competences

  • Business Intelligence knowledge in general
  • IBM DB2 Relational Database / OS390
  • Microsoft SQL Server Relational Database
  • SQL DML & DDL (Oracle, DB2, MS SQL Server)
  • SQL programming:
    • SQL Server Transact-SQL
    • Oracle PL/SQL
  • PowerCenter
  • PowerCenter Tuning and Performance
  • ETL- / Interfacing expertise in general
  • Functional analysis / design
  • Technical analysis / design
  • Architecture
  • General network knowledge
  • General System knowledge AIX
  • General system knowledge OS/390
  • Coaching
  • Project management