Freelancer profile translated to English.

Description

For over 15 years, I have been supporting companies in the design, modernization, and optimization of their DATA platforms. I work in demanding environments (banking, insurance, transport, etc.).

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km)

AG2R
BI Consultant / Data Engineer
BANKING AND INSURANCE
January 2024 - Today (2 years and 5 months)
Paris, France
and for the Business Provident fund:
• Analysis, needs specification, development costing
• Participation in various Agile ceremonies (sprint planning, Daily, review… etc.)
• Participation in the migration from Stambia to Semarchy xDI.
• Performance of post-migration checks for Stambia/Semarchy xDI
• Design and Development of ELT (Semarchy xDI) and ETL (Qlik replicate, Qlik compose) processes
• Development and maintenance of data transformation pipelines with dbt
• Implementation of the dbt project structure (sources, models, macros, snapshots).
• Creation of optimized SQL models on BigQuery/GCP (partitioning, clustering).
• Documentation of datasets via schema.yml and automatic documentation generation (dbt docs generate).
• Development of reusable macros (standardization of transformations, date management, cleaning).
• Optimization of BigQuery costs (reduction of scanned volume, duplicate removal, appropriate materialization).
• CI/CD integration (Git + pipelines) with automatic execution of dbt run and dbt test.
• Collaboration with BI teams to expose models to Looker / Power BI.
• Implementation of development standards
• Corrective and evolutionary maintenance of applications
• Mentoring, training of developers, and monitoring of development phases
Semarchy BigQuery DBT ODI Google Cloud Platform (GCP)
Mutuelle Générale de l'Education Nationale
BI Consultant / Data Analyst
BANKING AND INSURANCE
October 2020 - December 2023 (3 years and 2 months)
Paris, France
• Writing Detailed Technical Specifications
• Participation in various Agile Scrum ceremonies (sprint planning, Daily, Sprint Review, Refinement…)
• Assisting with PIP (Program Increment Planning Safe) for the Data Train
• Development and Optimization of ODI interfaces and packages
• Populating and Enriching Data Warehouse (EDE and Referential Data) via ODI
• Implementing controls for data flow integration rejections with ODI
• Design and population of Business Indicators (Steering Indicators for DRD and MKO)
• Development of Processes and Mappings with Semarchy xDI
• Deployment of Semarchy xDI Processes in different working environments with Production Analytics (PA)
• Enriching steering Dashboards with Power BI
• Data modeling with Power BI desktop
• Monitoring and securing production deployment in coordination with Application Support
• Corrective and evolutionary maintenance
• Organization and execution of data validation strategies post ODI migration to Semarchy xDI
• Coordination with other Data Train Squads (Dataviz, Data Governance, System Team…)
• User support and incident ticket management (Jira)
Semarchy xDI ODI Datalake Microsoft Power BI Python
MUTEX
Key player in Provident, Savings, and Retirement
BANKING AND INSURANCE
February 2012 - August 2020 (8 years and 6 months)
Paris, France
PROJECT:
• Cross-functional involvement in several RUN and Build Projects:
◗ Migration of the AIA (Health Insurance) Infocenter from OWB to ODI 11G
◗ Design and Population of Datamarts for Technical Inventory (Provident)
◗ Creation of indicators for the Income Statement
◗ Rewriting of ODI 11G flows (from ODI 10G) for the SDA project (detailed activity tracking for Provident and Retirement Savings contracts)
◗ Design of DSN (Social Security Declaration) data integration processes with ODI 12C
◗ Maintenance of a brokerage data management application (Contributions and Benefits)
• Functional and follow-up meetings (COPROJ)
• Development of interfaces and packages under ODI
• Development of ODI processes
• Execution monitoring on Operator
• Modification of IKM (according to integration needs)
• Optimization of processes and packages
• Population of ODS and DIMENSIONS
• Design and population of DATAMARTS (Fact Tables)
• Testing of target data integrity against source data
• Development of stored procedures, PL/SQL functions
• Optimization of SQL queries and stored procedures
• Management and control of flow integration rejections
• Creation of universes under BO
• Optimization of queries under BO
• Design and generation of BO reports (Webi and Rich Client)
• Management of anomalies and evolutions
• Production deployment monitoring
• Corrective and evolutionary maintenance
ODI SAP Business Objects SQL