Freelancer profile translated to English.

Description

Data engineer for 9 years, I am strongly interested in BI. I am capable of working on the entire data production chain: from data preparation through feeding, to reporting.

I have demonstrated my skills for large groups such as Sanofi, Engie, and Orange where I was able to apply my skills and supervise junior profiles.

I am looking for a freelance mission, either in Montpellier and its surroundings or full remote.

Industry field of expertise

Languages

French
Native or bilingual

Workplace preferences

Can work on-site

Montpellier (up to 50km)

Sanofi
Data Engineer
PHARMACEUTICALS INDUSTRY
December 2021 - Today (4 years and 8 months)
Montpellier, France
Project: ControlTower: Within an Agile framework, implementation of a Datamart for strategic and operational reporting for 4500 daily users.
Achievements:
Preparation: Specification of needs, writing JIRA tickets, participation in workshops.
DBMS & ETL: Implementation of the Datamart's technical architecture: Feeding and naming rules.
Creation/Optimization of flows under Informatica Cloud and maintenance. Scheduling.
Support: Analysis and correction of incidents, technical acceptance testing.
Deployment of solutions and maintenance of environments.
Techno-functional documentation, training, and supervision of newcomers.
Informatica Snowflake Training Run Management Atlassian JIRA
Orange
Data Engineer
TELECOMMUNICATIONS
December 2019 - December 2021 (2 years)
Montpellier, France
Project: Data BI Reporting Solutions: Management of a database + cube.
The Data Design Department is responsible for building the services of the decision-making platform (cubes, reports, distribution portal, etc.). The data comes from various Orange applications, such as information on interventions or employee tracking.
Achievements:
DBMS: Database migration: Implementation of a new model (Warehouse and Store), creation/optimization of SSIS processes, development of indicators, data acceptance testing, planning and scheduling of jobs.
Cube: Creation/evolution of SSAS cubes with integration of measures and dimensions.
Run Monitoring: Correction of daily errors on SSIS flows and cubes, quality control of data.
Cross-functional: Code review, Support and training of newcomers.
SQL Training Run Management SSIS SQL Server
Engie:
Data Engineer
ENERGY AND UTILITIES
March 2018 - December 2019 (1 year and 9 months)
Lyon, France
Project: SIDE: Database and reporting management.
SIDE is a decision-making application that aggregates data from various sources (ERP, CRM, Referential, etc.) and provides information to users.
Achievements:
DBMS: Creation of tables, addition of fields, application of new rules on stored procedures, query optimization.
Data Vision: Creation, addition of indicators, performance optimization, and maintenance of dashboards created on SSRS and Power BI.
Support: Technical assistance for newcomers (SQL, SSRS, Power BI).
Projects at the client:
- KPI Historization: Development of stored procedures, technical documentation, and assistance in creating SSRS reports.
- Customer Base: Reprocessing of stored procedures, creation of SSRS and Power BI reports.
SQL Server Stored Procedure Microsoft Power BI SSRS SQL