Simon Nicolas

Responsable d'une équipe de 3 personnes chargée de la conversion de données entre 6 systèmes source(SAP,DB Oracle,DB SQL) et un système cible (Lodestar Oracle) sur un projet chez Electrabel-Suez.

Mes tâches sont:
- définition du périmètre de migration de données
- Analyse de processus business et de besoins fonctionnels et conversion en besoins techniques.
- Supervision des dévelopments ETL(SSIS).

European Commission: D.G.Energy and Transport :
May 2007 - Present.

Management of Datastage ETL flows for the loading of European Road Safety Data Warehouse.

ETL Migration from Ascential Datastage 7.5 to Business Objects Data Intergrator XI R2



Banksys Brussels
January 2007 – May 2007

Management, Audit and optimization of data flows production for the acquiring and issuing transactions.
Technical environment : Oracle 9, ETL Data integrator 11.0.2, Business Objects 6.5.



Cofidis Lille
February 2006 – November 2006 ( 10 months)

Developments on the “Information and Decision Support System” (Data Warehouse):
- Creation and design of ETL mappings and packages for data warehousing.
- Creation and modification of Business Objects universes and reports.
- Modifications of database structure.

Impact analysis of sources modifications and data recovery :
- Anomalies detection on the whole decisional system from sources to Data Marts.
- Possibility and cost studies for data recovery.
- Implementation of data recovery processes.

Technical environment: Business Objects Enterprise 6.5, Sunopsis 3.2, Oracle 10




European Headquarter of Federal Express - Brussels
June 2005 – January 2006 ( 8 months)

Business Objects developments on the “Fedex Business Analaytics Data Mart” for the Sales and Marketing departments:

Creations and modifications of financial reports and dashboards.
Audit of the Data Mart sources and creation of anomalies reports.
Modifications of Business goals and customisation of reports in the Key Performance Indicators (KPI).
Creation and modifications of functional and technical universes.
Technical environment: Business Objects Enterprise 6.1, Application Foundation 6.1, Oracle 9.