CV (Curriculum Vitae) / Résumé

Languages:

Dutch
English
German



Programming-Languages:

ABAP4
Basic (VB, VB.NET)
C++
Java, JavaScript
Pascal
Perl
PHP
PL/SQL


Databases:

MS SQL Server
Oracle
DB 2
Access
mSQL / mySQL
Sybase





Projects:

* 1983 - 1989

Industry: State authorities

Function: Organisation programmer, user training and support

Activities:

- Conceptual design and realisation of applications in the area personnel management"
- Conceptual design and realisation of statistics and evaluation programs, reporting
- Training and support of users

Operating systems: MS-DOS/PC-DOS, GEM
Databases: dBASE
Languages/Tools: Turbo-Pascal, C, Assembler, SQL



* 1990 - 1994

Industry: Design, Multimedia

Function: Application programmer / organisation programmer

Activity:

- Conceptual design, realisation and implementation in the area of merchandise management and dunning process
- Conceptual design and realisation of multimedia and demonstration programs

Operating systems: MS-DOS, Windows 95/NT, Mac-OS,
Databases: dBASE
Languages/Tools: Visual Basic, MS-Access, dBASE, SQL



* 1995 - 1997

Industry: Systems house, web development

Function: Application programmer / system programmer

Activity:

- Conceptual design and realisation of dynamic Internet applications
- Conceptual design and realisation of client/server applications

Operating systems: Windows NT, UNIX
Databases: MS-ACCESS, SQL-Server (MS)
Languages/Tools: VisualBasic, VBA / VBScript, Java, JScript, IIS/ASP, ISAPI, Perl, C, SQL)



* 1998 - 06/2001

Industry: TV / media
Function: Application programmer / system programmer
Area: Media research, media coverage analysis


Activity:

- Conceptual design and realisation of client/server applications based on DW-Database in the area of media. Data-extraction and import from a Oracle-database into a Sybase-database using Ascential Datastage (V5)


Operating systems: Windows 95/98/NT/2000, Linux
Databases: MS-ACCESS, SQL-Server (Sybase), Oracle
Languages/Tools: VisualBasic, VBA, SQL, C++, Source-Safe, Ascential Datastage Version 5


* 07/2001 - 07/2004

Industry: Formula 1 - racing
Function: Application programmer (ETL), Datawarehouse
Area: Controlling / finance


Activities:

- Data extraction (ETL) of SAP-R3 and other preparations for reporting and dwh purposes via Ascential Data Stage (Version 7.1/7.5, PX) (using the sap-extraction pack and sap-bw load-pack)

Operating system: Windows 2000 Advanced Server
Databases: MS SQL-Server 2000, Oracle 8i
Languages/Tools: DTS, Stored Procedures, Ascential Datastage (SAP-Extraction and SAP-BW Load-pack)


- Change-over and extension of the existing Intranet reporting on SAP-BW

- Change-over and/or extension of the Intranet reporting system based on SAP after implementation of SAP- R3. Data extraction via ETL-Tool Ascential Datastage (ABAP and IDOC interface) from SAP/R3. Complex data transformation, which were processed within Ascential Datastage by means of various transformer stages as well as DS basic routines. Automated data migration from various third-party systems (Siebel) in form of flat-files with DS jobs.

Operating system: Windows 2000 Advanced Server, Linux
Databases: MS SQL-Server 2000, Oracle 9i
Languages/Tools: SAP-Business Warehouse, Ascential Data Stage

- Change-over and extension of the existing SAP-BW to MS-based Datawarehouse

Automated data migration from various third-party systems (SAP, Siebel, SAP-BW) with DS jobs. Database-Design (faction and dimension-tables) for further use with MS- Analysis-Service (cube-creation)

Operating system: Windows 2000 Advanced Server, Linux
Databases: MS SQL-Server 2000, Oracle 8i
Languages/Tools: MS-Analysis Services, Ascential Data Stage





* 07/2004 - 05/2005

Industry: tobacco-industry
Function: Application programmer (ETL), Datawarehouse
Area: Datawarehousing


Activities:

- Migration of a Datastage-Project based on Oracle 8i to MS-SQL Server 2000
- Migration of a Datastage-Project from version 5 to Datastage Version 7.5/PX


Data extraction (ETL) of SAP-R3, Siebel and other preparations for loading dimensions and fact-tables of a datawarehouse-database

Operating system: Windows 2000 Advanced Server
Databases: MS SQL-Server 2000, Oracle 9i
Languages/Tools: DTS, Stored Procedures, Ascential Datastage (Versions 5,7.5,PX)



* 06/2005 - 12/2005

Industry: Bank
Function: Application programmer (ETL), Datawarehouse
Area: Datawarehousing


Activities:

- Design and Implementation of the complete ETL-Process for 4 slightly different datawarehouses


Operating system: Windows 2000 Advanced Server, Sun Solaris
Databases: IBM DB2
Languages/Tools: Ascential Datastage (Versions 7.5.1 A (EE))
* 01/2006 – 4/2006

Industry: SAP
Function: Application programmer (ETL), Datawarehouse
Area: Datawarehousing


Activities:


- Extraction, Standardization, Validation and Upload of Source-Data from over 150 Countries into a SAP CRM-System


Operating system: Windows 2003 Advanced Server, Sun Solaris
Databases: IBM DB2
Languages/Tools: Ascential Datastage (Versions 7.5.1 A (Server))





* 05/2006 – Now

Industry: Bank
Function: Application programmer (ETL), Data warehouse
Area: Data warehousing


Activities:


- ETL-Feeding for SAP BW
- Extractions from DB2 and SAS sources
- Implementation of complex conversion-rules
- Integration-test of the metadata
- Loading the data into the PSA-Area of the SAP BW-System
- Generation of test-data and test-scenarios


Operating system: HP-UX 9000
Databases: IBM DB2
Languages/Tools: Ascential Datastage (Versions 7.5.1 A (EE)), SAP Load-Pack




Miscellaneous:

Training SAP R3-Data-Extraction with Ascential Data Stage (SAP-Extract Pack and BW-Load-Pack)
Training Performance & Tuning Sybase ASE 11.5 (SQL-Server)
Training SAP BW 305 at SAP-Headquarter
Training SAP BW 310 at SAP-Headquarter
Training SAP BW 315 at SAP-Headquarter