
Expérience professionnelle
DATA ANALYSIS EXPERIENCE
S T D up o n t , L A S T M I N U T E 200 9 C o n s u l t a n t S S I S – S A S , A M A D E A , N E O L A N E
Integration, Data Mining, CRM
➢ Analysis of existing feeding processes for Migration
➢ Package creations and modifications
➢ Unit tests of the different packages
➢ Creation of indicators, Extraction of data, Targeting of individuals, cross analysis, segmentation, scoring
➢ Programming
➢ Implementation of marketing campaigns with sponsorship and personalization of content
➢ Campaign reporting and tracking control
➢ Optimization of Macros
TEAM SIZE : 2 persons, 3 persons - TECHNICAL ENVIRONMENT : SSIS, NEOLANE, AMADEA, SQL, HTML, VB .NET, SAS
DATA ENGINEER EXPERIENCE
HR-PATH - SPAIN S inc e 0 2/20 18
C o n s u lt a n t P e o p le S o f t, I n t e g r a t i o n a n d R e p o r t in g > P r o j e c t : G E R S H U I N
INTEGRATION:
Migration PeopleSoft 8.9 to 9.2. Component and Application Engine correction and SAP BO migration from Oracle to Sap HANA
➢ PeopleCode
➢ SQL, PL/SQL
➢ SQR
➢ KSH
➢ Create and maintain Data Services Workflows
➢ Create and maintain SAP HANA calculation views
➢ Manage tables replication with SLT
REPORTING:
➢ Maintain and create DataMart on SAP BI IDT
➢ Maintain and create report with SAP BO
TEAM SIZE: 7 persons - TECHNICAL ENVIRONMENT: PEOPLESOFT, SAP BODS, SAP BO BI 4.0, SAP HANA, SLT, ORACLE
VARIOUS CLIENTS - FRANCE 03 /20 09 – 12/201 7
F A C T O R S O F T 0 9 / 2 0 1 6 – 1 0 / 2 0 1 7 ( F a c to r in g ) C o n s u l t a n t B O-O R A C L E > P r o j e c t : D A C
Reporting and Integration
➢ Collection of user needs
➢ Writing of functional and technical specifications
➢ Power and maintenance of the information centers Buyers, Sellers and Companies via PL / SQL
➢ Creation and maintenance of the associated BO universes
➢ Creation and maintenance of BO reports under Webi BI4.0
➢ Drafting of the production plan and the post-production documents
TEAM SIZE: 3 persons - TECHNICAL ENVIRONMENT: PL/SQL, SQL, BO BI4.0
O R A N G E 1 2 / 2 0 1 5 – 0 8 / 2 0 1 6 C o n s u lta n t B I > P r o j e c t: G A N D H I
Reporting and Datamart modelization
➢ Writing of Datamart's detailed technical specifications for creation and supply
➢ Modeling Datamart Finance
➢ Creation of Datamart
➢ Creation of the BO Finance universe and the first Webi reports under BO XI
TEAM SIZE: 11 persons - TECHNICAL ENVIRONMENT: Open Model sphère, Teradata 13, BO XI3.0
S F R 03/ 2 0 1 3 – 05/ 2015 C o n s u lt a n t B O – O r a c le > P r o j e c t : D O N N Y B R O O K
Reporting and Integration
➢ Collection of user needs
➢ Writing of functional and technical specifications
➢ Modeling and Creating the Infocentre Networks
➢ Power supply and maintenance of Networks, Real Estate and Fiber Eligibility
➢ Creation and maintenance of the associated BO universes
➢ Creation and maintenance of BO reports under Webi and Deski
➢ Automation of scripts
➢ Drafting of the production plan and the post-production documents
TEAM SIZE: 7 persons - TECHNICAL ENVIRONMENT: BO, ORACLE, Toad Data Modeler, SQL plus, SQL Loader
S e r v ie r L ab o r a t o r ie s 1 2 / 2 0 1 1 – 0 9 / 2 0 1 2 C o n s u l t a n t B O – B O D S > P r o j e c t : I N F O C E N T R E A R G U S S A F E T Y
Integration
➢ Collection of user needs
➢ Writing of detailed technical specifications
➢ Modeling, Design of source and target models of DWH Pharmacovigilance, Generation of scripts, Reverse-engineering
➢ Supply of the pharmacovigilance infocentre, creation of the supply chain (DataFlows, Workflows, Jobs), unit tests and
technical documentation via BODS
➢ Creation of the new universe and test reports
➢ Drafting of the production plan and the post-production documents
➢ User training
➢ Writing user manuals
TEAM SIZE: 2 persons - TECHNICAL ENVIRONMENT: BO, BODS, Power AMC, Argus Safety.
H U M A N I S In s u r a n c e 0 2 / 2 0 1 1 – 0 9 / 2 0 1 1 C o n s u l t a n t O D I – S Q L S e r v e r
Integration
➢ Datawarehouse power supply with multi-source data crossover
➢ Design of source and target models
➢ Writing scripts, Reverse-engineering
➢ Interfaces creation in the designer, Datastores feeding, Manipulation of data using the different KM (Integration,
Collection and Control)
➢ SQL development, unit tests of different interfaces and packages
➢ Writing release documents
TEAM SIZE: 5 persons - TECHNICAL ENVIRONMENT: ODI, SQL Server
I c a d e I m m o b i l ie r , V o y a g e s S N C F , L ’ O r é a l 2010 C o n s u l t a n t B O – N E O L A N E - I N F O R M A T I C A
Reporting, CRM, Integration
➢ Setting up and optimizing universes and reports
➢ Creating and extending schemas, creating and updating workflows, tracking control
➢ Datawarehouse power supply
TEAMS SIZE : 4 persons, 6 persons, 2 persons - TECHNICAL ENVIRONMENT : BO, NEOLANE, INFORMATICA, SQL
EDUCATION
Since 2009 – Data Engineer: BI and ERP
2009 – Masters in Statistics and Business Inteligence (5 Years
university degree in University of Lille 1, France)
2007 – DEUG in Mathematics and Informatics (2 years
university degree in University of Lille1, France)
2004 – DEUG in Mathematics and Physics (2 years university
degree in University of Bamako, Mali)
2002 – Baccalauréat (French high-school diploma)
SPOKEN LANGUAGES
FRENCH : Native
SPANISH : Fluent
ENGLISH : Technical
LANGUAGES
PL/SQL
SQL
SAS
PEOPLECODE
DATABASES
Oracle
SQL SERVER
TERADATA
SAP HANA
OTHERS
SSIS
INFORMATICA
ODI
BODS (sap DataServices)
POWER AMC
TOAD Data modeler
NEOLANE
SPHINX
AMADEA