Freelancer profile translated to English.

Description

Senior Data / BI Consultant & Data Tech Lead with 10 years of experience, specializing in Semarchy xDI/xDM-MDM, ODI, DataStage, SQL, ETL/ELT, and Business Objects. I work on flow migration, MDM/Data Hub, data quality, reporting, UAT, deployment, production support/maintenance, SQL/batch optimization, Git, CI/CD, CloudBees, Control-M/OPCON, Shell, Python, JSON/XML.

Available for Data, BI, Semarchy, and IT modernization missions.

Industry field of expertise

Languages

French
Native or bilingual
English
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km), Lille (up to 50km), Nantes (up to 50km), Annecy (up to 50km)

MGEN
Expert Semarchy xDI / xDM - MDM & Data Integration
BANKING AND INSURANCE
October 2022 - April 2026 (3 years and 6 months)
Paris, France
Worked at MGEN as part of an IT modernization and data governance program, serving as a Semarchy xDI / xDM - MDM expert.

Participated in the migration of ODI processes to Semarchy xDI, the reliability of batch chains, and the improvement of data quality. Contributed to MDM initiatives related to repository modeling, entity management, attributes, validation rules, quality controls, rejections, master records, and golden records.

Wrote technical specifications, corrected mappings, performed unit tests, UAT, UAT reports, and delivery files. Executed a double run during the Netezza to Greenplum migration, analyzed discrepancies, and secured the cutover.

Managed the evolution and correction backlog, provided production support, optimized batches, industrialized CI/CD with Git and CloudBees, and supported business and IT teams.
Semarchy xDM Semarchy xDI ODI Business intelligence SQL
RougeGorge
ETL Referent Semarchy xDI / Data Hub & MDM Retail
RETAIL (SMALL BUSINESS)
March 2021 - September 2022 (1 year and 6 months)
Paris, France
Worked at RougeGorge in an omnichannel retail context as an ETL Referent for Semarchy xDI / Business Objects within the data, BI, and Data Hub scope.

Participated in ensuring the reliability of flows between Storeland, AIH Data Hub, Salesforce, OneStock, and SID systems. Contributed to MDM / retail repository topics: consolidation of product, store, order, and customer data; data consistency checks; rejection management; repository population; and ensuring the reliability of data used by business reports.

Developed, maintained, and monitored Semarchy xDI / ODI flows feeding BI dimensions, fact tables, and indicators. Managed production, pre-production, and UAT incidents, monitored SLAs, supervised nightly batches under OPCON, and ensured the timely delivery of business reports by 7 AM.

Supported and trained the data team on Semarchy xDI, best operational practices, incident handling, and understanding retail BI flows.
Semarchy xDI Semarchy xDM SQL Server ODI SAP Business Objects
CNP Assurances
ETL Referent DataStage / Axway / Business Objects
BANKING AND INSURANCE
December 2018 - February 2021 (2 years and 2 months)
Paris, France
Worked within the IT Service Center for CNP Assurances' accounting IT system as an ETL Referent for the AMAZON, OCEAN, and CICLADE scopes.

Handled the build and run of accounting integration flows: business needs analysis, rough estimation, specification writing, DataStage development, non-regression testing, UAT, validation reports, and production deployment monitoring.

Managed production, pre-production, and UAT incidents, supervised batch chains under Control-M, and assisted users during accounting closing periods. Contributed to the reliability of sensitive flows: lettering, bank reconciliation, inter-system reconciliation, discrepancy analysis, and accounting cut-off.

Configured and analyzed rejections under Axway InterPlay / SAI, implemented accounting schemas using Composer, developed Shell scripts, optimized SQL, and created business dashboards under Sentinel.

Onboarded new team members, capitalized on incidents under Confluence, and provided functional support to accounting departments.
Datastage SAP Business Objects Axway Control-M