Hamza IDER

bioMérieux

SAP BW / Cognos Consultant

February 2013 — December 2014 · Lyon

BI solutions for Finance, Production, Procurement and Sales.

• Contributed to gathering and formalising business requirements (Finance, Procurement, Sales, Production); wrote functional and technical specifications.
• Analysed source data in SAP ECC (FI-CO, SD, MM, PP).
• Modelled and designed SAP BW objects: InfoCubes, MultiProviders, DSOs and transformations.
• Developed Bex queries and Cognos reports (v10.5).
• Data quality checks, fixes to integration anomalies, and participation in business acceptance testing.

TechnologiesSAP BWSAP ECCBexIBM Cognos

Arkema

SAP BW / Business Objects Consultant

January 2015 — January 2017 · Lyon

Enhancements to the SAP BI platform for the Finance and Procurement departments.

• Gathered requirements from the Finance and Procurement teams; wrote functional and technical specifications.
• Studied source structures and data in SAP ECC (FI-CO, MM).
• Maintained and optimised BW flows (InfoCubes, DSOs, transformations).
• Developed Bex queries and SAP BO Web Intelligence reports (v4.1).
• Data quality checks and anomaly fixes; took part in testing before go-live.

TechnologiesSAP BWSAP BOSAP ECCBex

GSF

Techno-Functional BI Consultant

February 2017 — December 2018 · Sophia Antipolis

Designed the Finance department's BI platform with IBM DataStage, Oracle and Cognos.

• Designed and implemented the central data warehouse.
• Structured the decision-support model for the finance domain.
• Worked with business teams to define business rules and validate KPIs.
• Developed data loading flows in DataStage (v8.5 / v11).
• Built and industrialised around forty financial and operational reports.
• Wrote functional specifications and followed user acceptance testing.

TechnologiesIBM DataStageOracleCognosSQL

CPRO

BI Consultant

January 2019 — March 2020 · Valence

Developed the BI platform: data warehouse modelling, ETL flows and Power BI dashboards.

• Contributed to defining the company's data strategy.
• Defined KPIs and requirements with business teams.
• Modelled the data warehouse for performance and scalability.
• Set up the Pentaho framework (ETL orchestration) and a Power BI template.
• Knowledge transfer to users and team members.

TechnologiesPower BIPentahoPostgreSQLGit

GSF

Data Lead | Data Modernisation

April 2020 — September 2024 · Sophia Antipolis

Took part in modernising the company's BI landscape towards a Cloud architecture.

• Defined and rolled out the data strategy for this modernisation.
• Migrated from Oracle to Snowflake, with Snowpipe ingestion and dbt transformations.
• Evolved the architecture from an ODS / DWH to a Data Lake and data marts.
• Redesigned reporting and migrated from Cognos to Power BI.
• Techno-functional lead of the BI team: coordination, upskilling, development standards.
• Supported business teams from requirements and KPIs through to adoption of data solutions.

TechnologiesSnowflakeSnowpipedbtAzure Data FactoryPower BISQLGitScrum

Pellenc

Data Migration Consultant

September 2024 — June 2026 · Pertuis

Led a data migration programme as part of an IT transformation, reporting directly to management (executive committee / CIO).

• Led and monitored the data migration development teams; prioritised workstreams by business impact.
• Analysed, structured and cleansed data from multiple information systems.
• Contributed to data governance: reference data, quality rules and controls.
• Tracked migration project progress in Microsoft Fabric.
• Organised and led the acceptance testing phases.
• Coordinated business, IT and data teams.

TechnologiesInfor M3IFSSemarchyOdooTalendMicrosoft FabricSQLJiraConfluence

Sanofi Accelerator

Senior Data Consultant | Data & AI Products

June 2026 — Present · Lyon

Contributing to a Batch Readiness companion for Sanofi's industrial sites, designed to reduce batch destructions and deviations.

• Analyse business processes and translate needs into Data solutions.
• Develop data models and transformations with Snowflake and dbt.
• Set up the artificial intelligence components the product needs.
• Work closely with Product, Data Engineering, Front-end, Back-end and UX/UI teams in an Agile environment.
• Use generative AI tools (Cursor, Claude Code) to speed up development and improve deliverable quality.

TechnologiesSnowflakedbtSQLGitCursorClaude CodeJiraConfluenceScrum