Freelancer profile translated to English.

Description

Data engineering expert with a strong background in migrating complex environments (Hadoop/Oracle Exadata) to the Cloud (Snowflake).

I help companies modernize their data architecture by implementing robust and scalable pipelines. Specialist in the Modern Data Stack, I master the entire data lifecycle:

Analytics Engineering: Implementation of Medallion architectures (Bronze, Silver, Gold) with dbt.

Advanced Development: Industrialization of complex transformations in SQL and Python (Jinja).

Orchestration & Reliability: Design of optimized Load Plans and error recovery systems to ensure high data availability.

My time at EDF allowed me to lead strategic Cloud migration projects, ensuring major performance gains and increased scalability.

Available to assist you with your migration challenges, Snowflake cost optimization, or dbt stack structuring.

Languages

French
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Paris (up to 50km)

EDF Commerce
Energy Sector Tec Lead DATA
ENERGY AND UTILITIES
January 2024 - Today (2 years and 5 months)
Paris, France
Implementation of a DATA project with the setup of a DW for EDF Commerce for the energy sector.

Study of the existing system and solution review. Design and development of ELT and ETL flows for different types of data (distributor, ODS, HDR, and Publication). Migration of Hadoop flows to Oracle. Unit testing, acceptance testing, and integration. Documentation and deliverable preparation. Correction and evolution of developed flows.

Technical Environment: OS: Windows Databases: Oracle 19c Development Tools: Shell, SQL, PL/SQL, Oracle Data Integrator 12c, Git.
Snowflake DBT AWS S3 Airflow
Retail Renault Group
Automotive Sector Technical Project Manager DATA
AUTOMOBILE
March 2019 - February 2024 (4 years and 11 months)
Implementation of a DATA project with the setup of a customer targeting DW for the automotive sector.

Modeling of a Marketing DW (Delta, Aggregate, Full). Support and enrichment of existing models. Development of specific tasks and Jobs. Planning and monitoring of developed tasks. Review and correction of developed programs and jobs. Planning and organization of acceptance testing. Reporting development. Writing documentation and technical specifications. Elaborating functional specifications into technical specifications. Production deployment and monitoring of reporting.

Technical Environment: OS: Windows Databases: Oracle 11g, 12c Development Tools: Shell, SQL, PL/SQL Job Scheduler: jobscheduler Analysis and Reporting.
ODDO-BHF
Banking Sector Architect and Technical BI Referent
October 2018 - February 2019 (4 months)
Responsible for setting up a decision-making project from scratch covering all banking activities for ODDO-BHF bank.

Implementation of the technical architecture. Study of the existing system. Study of different data sources ('the bank's various existing solutions'). Modeling and design of the decision-making model. Mentoring and assisting collaborators. Involvement in all development phases. Implementation of different layers (integration, analysis, and reporting).

Technical Environment: OS: Windows Databases: SQL Server and ORACLE11g. ETL: ODI and SSIS Development Tools: Shell (Linux) SQL, PL/SQL, T-SQL Analysis: Cognos Cube, TM1 Reporting: Cognos report studio