Références

11/2013 – 4/2014 WKFS (Wolters Kluwer Financial Services, ex-FinArch Merelbeke) (120 days)

8/2013 – 10/2013 Delhaize Brussels (60 days)

▪ Performance tuning on SQL Server databases

▪ Data transfer from Oracle databases to SQL server database (SSIS) and vice versa

▪ SQL Server development

▪ Performance tuning on Oracle databases

▪ Troubleshooting of stored procedures in new and existing banking back-
office applications

▪ Setup, test and troubleshooting of ETL packages (SSIS)

▪ Performance tuning on SQL Server

▪ SQL Server development

▪ Upgrade of a SQL Server 2005 environment to SQL Server 2012

3/2012 – 7/2013 ERGO Brussels (350 days)

▪ SQL Server development

▪ Development, testing and troubleshooting of stored procedures in new and

existing applications for a highly competitive insurance company

▪ Setup of a test environment

▪ Development of ETL packages with SQL Server Integrations Services (SSIS) for

data collection of different sources (ASCII files, SQL Server, MS Access, Excel) and

consolidation in SQL Server databases

▪ Development of reporting solutions with SQL Server Reporting Services (SSRS)

▪ Upgrading of SQL Server 2005 to 2008R2 environment

6/2011 – 2/2012 Onafhankelijk Ziekenfonds Brugge (160 days)

▪ Set up a DWH (Data Warehouse) and BI (Business Intelligence) system (SQL Server2008R2) replacing the existing DB2 based reporting system.

▪ Maintenance of the existing DB2 system.

▪ Data extraction of DB2 on AS400, DB2 on Linux and DB2 on Wintel platform, SQL Server2000/2005 databases.

▪ Reporting with MS Reporting Services 2008R2, development of cubes with Analysis Services 2008R2.

▪ ETL (snapshot and incremental) system set up with Integration Services 2008R2.

▪ Import and export of XML documents.

▪ Control of imported data by means of Regular Expressions.

2005 – 2010 Beaulieu International Group (in total 420 days during different periods)

▪ Set up of databases (SQL Server and MS Access) and development of

applications (MS Access and VB.Net) for support of the production units.

▪ Data collection of different sources (DB2 on AS400, SQL Server, MS Access, Excel) and consolidation in SQL Server databases (SQL Server Integration Services).

▪ Making production reports and work preparation documents (SQL Server Reporting Services and MS Access).

2005 – 2010 Call Center (customer prefers to stay anonymous) (40 days)

▪ SQL Server configuration with 5 databases spread over Flanders

▪ Weekly consolidation in one central database

▪ Optimization of front end application for quick data input (MS Access)

2006 – 2010 Belgacom/Telindus/John Cordier Academy (in total 85 days)

ß Standard Microsoft SQL Server trainings

o SQL Server 2005 and 2008

o Subjects

ß Database Administration: setup, backup and restore, replication

ß Development: T-SQL, stored procedures, functions, triggers, .Net

integration

ß ETL: data transfer, Integration Services

ß BI: Reporting Services en Analysis Services

ß Performance Tuning

o Target public : DBA’s, developers, data analysts

2009 – 2011 Devoteam Guidance Luxembourg (in total 80 days)

ß Standard Microsoft SQL Server trainings – for description see Belgacom

2010 – 2011 Xylos (in total 40 days)

ß Standard Microsoft SQL Server trainings – for description see Belgacom

2000 – 2009 The Campus (a Cronos company) (in total 215 days)

ß Standard Microsoft SQL Server trainings – for description see Belgacom

ß VB.Net and VBA trainings

1998 – 2010 nv Colaert (in total 240 days during different periods)

ß Manufacturer of leaf springs for utilitairy vehicles (200 pers)

ß Different projects for e.g. production support, quality control, treatment of complaints and commercial support

ß Selection tool for leaf springs, also available on internet: http://www.colaert.be/tools.php?lang=NL&itemno=143#

ß Based on SQL Server databases

ß MS Access and VB.Net applications

2005 – 2010 Tanghe Printing (in total 135 days during different periods)

ß Offset printing and editor of different magazines (50 pers)

ß Several administrative automations based on SQL Server databases with VB.Net and MS Access applications:

o Automation of page lay out of a publicity newspaper in function of

o Salary calculation based on data transferred from production ERP system

o Management of subscriptions on different magazines and follow up of measures of publicity, 4-colours/1-colour/black-white, rate and position of preference (HiFlex) payments