Freelancer profile translated to English.

Description

Data Engineer specialized in the design and industrialization of data pipelines.

With over 15 years of experience in data integration and management, I help companies to make their data flows reliable and build robust data platforms.

Expertise

• Design and optimization of ETL pipelines

• Multi-source data integration (API, databases, files, FTP / sFTP)

• Orchestration and development of Azure Data Factory pipelines

• Optimization of complex SQL queries

• Design of datamarts and feeding of data platforms

• Industrialization of data flows

Technologies

SQL Server • T-SQL • PL/SQL • Azure Data Factory • Azure DevOps • Git

ETL • Data Pipelines • API Integration • FTP / sFTP • JSON • Azure Blob Storage

Oracle • Power BI • SSIS • SSRS

Domains

Retail • E-commerce • Luxury • Customer Relations • Energy & Utilities (water, sanitation)

Distribution • Data Platforms

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent
Arabic
Native or bilingual
German
Basic

Workplace preferences

Can work on-site

Paris (up to 50km)

Zadig & Voltaire
Azure Data Factory Consultant
LUXURY GOODS
October 2021 - Today (4 years and 8 months)
Paris, France
Context:
Within the Datahub project, my main mission was to ensure efficient and secure data transfer between different sources and destinations. This data, once transformed, was stored for later use. The orchestration of this process was carried out through incoming and outgoing data flows using the Scrum method for agile project management.

Tasks and Responsibilities:
Design and management of "IN" flows to import data from third-party systems into the Datahub database.
Design and management of "OUT" flows to export data from Datahub to target systems.
Use of APIs, direct database connections, FTP / sFTP, CSV files, etc. for data import and export.
Precise configuration of flows through .json files, structuring an ordered sequence of steps for each flow.
Creation and maintenance of various ADF pipelines to manipulate data.
Writing and optimizing T-SQL queries for various specific project needs.

Key Technologies:
Azure ADF, T-SQL, Azure DevOps, GitHub, Azure Repos.
Suez Eau France
BI Consultant
February 2014 - September 2021 (7 years and 7 months)
Context:
Odyssey Project (overhaul of the entire information system under Oracle CC&B). Project subject: development of datamarts, reporting, and data flows on the MS BI suite (SSRS / SSIS / Oracle CC&B DB). Business domains:
Energies (water and sanitation): Accounting, Management Control, Cash Collection-Recovery, Billing, Customer Relations, Meter Reading and Remittances. Actions:
Collection of functional requirements:
Scoping and instruction meetings.
Definition of business needs (accounting, billing, meter reading, customer relations, etc.).
Indicators.
Creation of reports and dashboards:
Creation of tablix and matrix reports in SSRS.
Creation of Power BI dashboards.
Complex queries to the replicated PROD database under Oracle CC&B.
Publication and scheduling of subscriptions on the SSRS portal.
Management of security on folders and data.
Design, creation, and feeding of datamarts with SQL/SSIS.
Management of data flow deliveries (tables and views) to various consumers of Odyssey data.
Acceptance testing of existing reports and control of report deliveries made by the integrator.
User support:
Incident processing (Service-Now platform).
Processing of change requests and anomaly correction.
Creation and tracking of TeamForge/Service-Now tickets for anomalies with the integrator. Processing of ad-hoc data extraction requests from users. Key Technologies:
BIDS, Visual Studio SSDT, SQL Server 2008R2 then 2016
SQL Developer, PL/SQL, T-SQL, SSIS, SSRS and Power BI.
IDIPortal
MSBI Developer
DIGITAL AND IT
October 2013 - January 2014 (3 months)
Paris, France
Context
Application used by all departments (HR, technical, etc.) of the IT services company Idigao. In charge of the BI part, from data loading to publication, using Microsoft SSIS and SSRS solutions. Actions
Design and loading of management/finance and HR datamarts
Creation and modification of the database schema
Development of stored procedures
Design and development of reports for the HR and commercial domains Creation of SSIS packages for datamart loading. Key Technologies
Visual Studio, SQL Server 2012, T-SQL, SSIS, SSRS.