DESS (DSS, Decision support system) INP (Institut Nationale Polytechnique) (Toulouse, France)
Functional skills / Industries
¨ Bank and Finance ERP CRM
¨ Insurance Operational application management
¨ Telecom Customers' marketing indicators, contracts and traffic
¨ Logistics Supply chain, Transportation
Business Intelligence skills (DWH specialist)
¨ Business Intelligence Datawarehousing, Activity piloting, Reporting, Budgeting,
¨ OLAP Tools Oracle Express, Seagate Holos ,Hyperion Essbase, Cognos PowerPlay
¨ Query/Reporting Tools Business Objects, Cognos Impromptu, Brio.Enterprise
¨ ETL Cognos : DecisionStream, DTS, Informatica (PowerCenter), BusinessObjects Data Integrator 11.0.2
¨ CRM Chordiant ( ex. Prime@Vantage.com )
Other Technical skills
¨ Operating Systems MS DOS, Windows 95/98/NT/XP, UNIX
¨ Methods Merise
¨ Languages Visual Basic, PL/SQL
¨ Database Oracle 8,9i, 10G
¨ Database Designing Tools ERwin Data Modeler, Power AMC, CASE Studio 2.
u Banksys From 02/2006
DWH Architect
¨ ERP CRM Data Warehouse: Put at disposal of the end-users departments (Customer Relations, Finance, T&P, IT and CoExco) a reporting environment (Corporate Data warehouse) giving access to integrated data coming from Delphi (Oracle Applications suite), Oracle Applications and other operational systems.
¨ Complete end-users requirements (create source target excel file),
¨ Define target architecture of the ERP CRM DWH and identify its main parts,
¨ Design the target Data Model (Star schema),
¨ Lead and coaching of the ETL team:
¨ Deploy the Business Objects Rapid Mart solution for Oracle Applications,
¨ Define ETL Naming conventions,
¨ Define Data Quality controls,
¨ Define the initial Load and Delta load strategies,
¨ Create mappings using the ETL Data integrator 11.0.2,
Technical environment:
- ORACLE 9i ,Data Integrator 11.0.2, Oracle Applications 11i, BusinessObjects, SYSBASE Powercenter Designer, Business Objects Rapid Mart.
leading a development team and coaching of junior developers.
u Tibotec From 10/2005 to 12/2005
DWH Architect
¨ Assist, identify and propose solutions about performances issues that were carried out on the COGNOS end-users reports of the TIRAMISU 1.00 project at TIBOTEC.
¨ Review mappings design, tune and bring practical solutions to reduce execution time of the general ETL Workflow.
¨ Analyse the database design,
¨ Analyse and tune end-users SQL queries.
Technical environment:
- ORACLE 9i ,Cognos Reportnet Framework, INFORMATICA Powercenter 6.2
u FedEX (Federal Express) From 06/2003 to 12/05
DWH Architect
¨ Analytical CRM application, including an EMEA Data Warehouse and its interactions with the Operational CRM, Design the star schema database with PowerAMC and Define The ETL business requirement specifications.
¨ Design Technical specification and coaching the FedEx Inflow Team (Informatica PowerCenter) to deliver the FBA Project in time.
¨ DBA synchronizing data and systems for phased migration, and ensuring the quality of migrated data
¨ DBA on Oracle database.
¨ Design the inflow architecture for the Data warehouse loading.
¨ Analysis, detailed design Mappings using INFORMATICA PowerCenter 6.2
¨ Data loading and extraction, Data Quality (Data Cleanup…) using the ETL PowerCenter
¨ Tuning the oracle database to improve performances:
o Application Performance Walkthrough (Analyze Application Performance, Optimize DB.
o Tuning SQL Applications in Oracle.
Technical environment:
- ORACLE 9i (SQL, PL/SQL), Business Objects (AF, Designer), PowerAMC,PowerCenter
u Fost Plus From 11/2002 to 04/2003
DWH Architect
¨ Tuning the Oracle Data Base DWH:
o Application Performance Walkthrough (Analyze Application Performance, Optimize DB and Appl. Design,
o Data loading and extraction, Data Quality (Data Cleanup…) using the ETL DecisionStream
Technical environment :
- UNIX, ORACLE 9i (SQL, PL/SQL),Cognos(PowerPlay,Impromptu,DecisionStream), TOAD
u Dexia Bank From 10/2001 to 10/2002
DBA Oracle
¨ Project Corporate Datawarehouse: DBA ORACLE 8i
o Creation of the DB and DB-objects(Generate Database Script, Create Database in DBMS, DB Sizing Development,
o Data Integration/transformation (Determine the load sequence, Develop load procedures,)
o Application Performance Walkthrough (Analyze Application Performance, Optimize DB and Appl. Design,
o Space Management (freespace, fragment, reorg.)
o Data Quality (Data Cleanup…)
¨ Project ESSBASE CUBES: Provide Sales Managers and their staff with Business Performance Measures related to trends in volume sold, composition and evolution of the customer’s portfolio.
Technical environment :
- UNIX, ORACLE 8i (SQL, PL/SQL),ESSBASE, TOAD
u McKinsey From 09/2001 to 10/2001
IT Consultant
¨ Assistance dans l’analyse et la Conception du Reporting dans le cadre du projet : définition d’une stratégie de développement pour l’activité ME (Moyens et grands comptes de DEXIA) en Belgique.
u AXA France Assurances From 02/2000 to 07/2001
IT Consultant
¨ Projetct GCM: Design and implementation of Prime@Vantage.com at AXA France Assurances. Project for the management of marketing campaigns.
Technical environment :
- UNIX, ORACLE 8i (SQL, PL/SQL),BRIO, TOAD , Prime@Vantage.com
