Ridouan - Data Engineer GCP

• 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)