• Professional Experience
07/2021 – Today Data Analytics Engineer Lead Consultant at Carrefour Links
As a Data Analytics Engineer Lead, I work within the Carrefour Links team on global projects to drive and develop data projects via GCP/Bigquery/DBT/Looker :
• Supply project (BUILD) :
o Working closely to the business stakeholders to understand the business needs (KPIs about sores/warehouses, sales, service rate level, orders, receptions, shipements, number of days of stocks,detention rate..)
o Design of the Data model target with optimization concepts (partitionig, clustruring, denormalizing, aggregations, shardings) to support a large mounts of data (9 Countries ~ around 1 PB)
o Development of DBT flows (building of simple and complex SQL quieries...)
Design of the Looker Project : Configurations, Model, Views, Derived tables, Dimensions, mesures, security, users attributes, explores.
o Development of tuiles & dashbords
o Deployment UAT / Prod environement (Airflow Composer)
o Particiapating in the implementation of the CI/CD, Docker
o Scrum method (safe) : PI Planning, Sprints,backlog refeinements
o JIRA (Sprints board)
o Documentation : Confluence
o Coaching of a team of 5 Data Engineers
• Datashopper project (RUN):
o Working closely to the business stakeholders to understand the business needs and deliver reliable dashbords (Looker)
o Optimization of queries to improve performance through BigQuery and Looker.
o Development of new measures & KPIs via Looker
o Development of DBT flows
o Testing of the conformity of the results with the needs
o Release management
Technical Environment : Google Cloud Platform, Google Big Query, Looker, DBT/SQL/Python, Confluence,JIRA, CI/CD (Cloud build)
11/2020 – 07/2021 Data Analytics at L’Oreal
Working inside the demand sensing team (stocks forecasting & management), as a Data
Analytics Expert :
• Working closely to the business stakeholders to understand the business needs
• Participation in the definition of the target architecture of the Core viz Data model.
• Creating datamarts to aggregate the hundreds of billions of rows on the datasets (Bigquery)
• Development of Looker dashboards, with optimal response time for KPIs (Looker/Lookml)
• Optimization of analysis queries to improve performance of large data processing based on advanced concepts of GCP/BigQuery/SQL and Looker.
• Technical and functional expertise on the features and business rules implemented in Power BI Reports and reproduce them in the new Looker Data visualization solution chosen by the L'Oréal Group.
• Testing of the conformity of the results with the needs
• Industrialization of data flows using Google Cloud Composer (Airflow)
Technical Environment : Google Cloud Platform, Google Big Query, Looker, DBT,GCP Composer, Power BI
01/2020 – 07/2020 Data Tech Lead at beIN Media Group
Digital Project : Implementation of a new OTT Platform
As Data Architect Lead of the Digital Team, in International working environement, my role consists to manage whole process on the following projects with different teams from 3 regions MENA, FRA, CAN/US :
• Participation in the implementation of a set of KPIs via Looker based on a new Data platform (AWS/GCP/Looker)
• Leading Data migration project from a Legacy CRM to Zuora (Cloud Platform)
• Leading Historical data (Reversibility) from Legacy to beIN platform
• Implementation of a process allowing data compliance with the GDPR
• Implementation of a secure data exchange process between beIN and its partners.
Technical environment: Power BI, Looker, GCP (Big Query,Bucket, Data Studio), AWS
07/2017 – 01/2020 Tech Lead Data at Lagardère Travel Retail France
Project : Implementation of central DWH target and Power BI to manage the commercial, marketing and accounting activities of more than 1,000 points of sale across France in different transport zones (SNCF railway station, airports, duty free, etc.)
As Data Project Leader in the Architecture department, I was in charge of validation of the whole process on the project :
• Project Management (Planning, Backlogs, Sprint, Steering Comitee, follow up of progress…)
• Defining requirements with business team
• Workshops: Impact / risks, application architecture, POC
• Design: Data Model, Data integration
• Leading and participation in technical developments: Cubes SSAS Tabular, Power BI (Azure), TALEND, PL / SQL
• Security management and data accessibility via Group AD
• SLA
• Supervising deliverables in terms of quality cost and delay
• Continuous improvement: DWH /datamart model optimization and project’ evolution
Technical environment: Suite MSBI 2016 (SQL SERVER, SSIS, SSRS, SSAS, Cubes Tabulaire, Power BI), Talend6.1, Oracle 10/11g/12C, AZURE
09/2015 - 06/2017 BI Consultant Senior at ENGIE
Participation in the implementation of a new data warehouse entitled "Cristal Board" allowing the availability of Quality Delivery KPIs
• Defining requirements with business team
• Workshops: Business team, technical experts, DBA, technical exploitation
• Design: Modeling, functional and technical specifications
• Leading and participation in technical developments: MS BI 2012 (Sql Server, SSIS, SSRS), Tableau Software.
• Managing offsite consulatnts
• Testing
• Deployment
• SLA
Technical environment: MSBI 2012 (SQL SERVER, SSIS, SSRS, SSAS) Tableau Software Server, Service Now and SnowMirror
09/2014 - 08/2015 BI Consultant Senior at Sisley
Migration project following the implementation of a new ERP system (SAP) :
• Defining functional and technical specifications
• Designing new data model (ODS, DWH, DTM)
• Technical developments on MSBI 2012
• Testing
• Deployment
Technical environment: Power AMC, Suite MSBI 2012 (SSIS, SSRS, SSAS)
11/2013 -08/2014 BI Consultant Senior at PSA
Implementation of supervision solution which allows daily monitoring of data flow performance.
I was mainly in charge of :
• Validating the implementation of new solutions
• Requirements gathering
• Designing & Data modeling
• Technical developement : TALEND, PL/SQL, BO
• Deployment : Acceptance/Production enivrements
Technical environment: BO XI3.1/BI4, PLSQL/Talend5.4, Oracle 11g.
04/2013 – 07/2013 BI Consultant at SIS – France
Implementation of a geographical repositoy which allows the identification of Patients and the appropriate means of relief through decision-making mapping SISMAP
Technical environment: Talend 5.3, BOXI R3, Oracle 10g/11g
07/2012 - 03/2013 BI Consultant at Natixis Lease
Leading the migration of financial data from BO5 to BOXI3.1 (269 documents and 60 universes):
• Validating specification with finance team
• Providing feedbacks of the migration
• Identification of improvements on documents and Universe BO
• Technical assistance to the functional team on technical-functional issues (Infoview, Webi, Deski, Universe)
• Coordinate between the functional and technical teams on issues concerning the recipe environment
Technical environment: BO XI3.1, BOXI 3.1, BOXI R2, SQL, PL/SQL
12/2010 - 06/2012 BI Consultant at FranceAgrimer
Involvement in the different BUILD/RUN projects:
• Requirements gathering
• Data integration with the DecisionStream and Talend ETL (TOS / TIS):
• Reporting (BusinessObjects and Cognos Impromptu)
• Deployment
• Rights management and creation of users
• Verification and compliance with standards for reports sent to the European Commission.
Technical environment: BO Power AMC Designer, BO6.5, BOXI3.1, Talend (TIS 4.2), DecisionStream, COGNOS Imp 7, Oracle 10g,11g, Sybase 12.5, SQL, PL/SQL
09/2010 - 12/2010 BI Consultant at FranceTélevision/RFO
Transfert of local datamart / RFO to FTV BI department :
• Analysis of application architecture
• Migration of Talend environment and Business Objects
• Test and validation of deployment
• Optimization and automation of data flow
Technical environment: BOXI3.1, Talend (TOS), Oracle10g, SQL, PL/SQL
03/2010 - 08/2010 BI Marketing Analyst at Valeo Transmission
BI Marketing Analyst in the Marketing Department at the Center for the R&D (CEPN)
• Management of marketing database
• Collection of functional requirements
• Extraction and reporting of analysis results under TdB
• Synthesis of information collected from the global R&D and Sales network of the Transmission Branch
• Maintain Group Marketing Database under SAS FM
Technical environment: SAS FM, VBA (Macros), Excel (TCD)
02/2009 - 07/2009 Internship Data Engineer at Faiveley Transport
Implementation of a decisional infomration system, reporting for Customer service
• Functional and technical specifications
• Designing model
• Data integration
• Reporting
• Detailed follow-up of the sales report on the rail market.
Technical environment : Power AMC Designer, COGNOS Imp 7, Talend (TOS 3.2), SQL, Oracle 9i, Sql developer, Dashboard, VBA (Macros Excel)
• Technical skills
• Google Cloud Platform : BigQuery, Google storage - Buckets,Google, Composer, Airflow, Cloud build, Looker, LookML.
• Data Visualisation : Looker, Power BI (Desktop/Cloud), Power BI Report Server 2019, Tableau Software
• ELT : DBT/SQL/Python
• ETL : Talend, TOS/TIS, SSIS, BODI XI, DecisionStream (IBM),
• MSBI 2012/2016/2019 (SQL Server, SSIS, SSAS, SSRS, Power BI, Cubes Tabular, DAX, MDX)
• Design Models : UML, MERISE / PowerAMC Designer : MCD / MPD
• Reporting & BI: BO5/ 6.5 / BO XIR2 / BO XI3.1/ BI4
• MDM : EBX Orchestra
• CRM : Zuora (Subscribers management), Dynamics AX
• Cloud AZURE, AD
• SGBD : Oracle 9i, 10g, 11g, SqlSever 2008/2012/2016/2019, Sybase12.5,
• Environnements : Windows : 98/XP/Vista/W7/10
• eTikect Systems/DevOps : JIRA, Service Now, Mantis, SIMILI, Redmine, Confluence
• DevOps : TFS, VSTS, Github CI/CD
• Functional skills
• Project Management
o Planning,
o Technical Progress Committee
o Steering Comitee
o Agile approach (Scrum, Safe)
o Coordination between Business and Technical teams
o Budget
o Managing offsite consultants
o Responding to functional and technical topics of RFPs
• Workshops: Analyzing ompact & risks, application architecture, POC
• Functional and Technical specification
• Recipe books
• Modeling (denormalizing, shardings ,star, flake schema ...),
• Design : Staging, ODS, DWH, DM, Data structure, Data Intergation, Data Quality
• Data Dictionnary
• User support
• Knowledge transfer
• Education and training
• 2009 Engineer from University of Technology of Troyes UTT (France)
• Languages
• English : fluent