Freelancer profile translated to English.

Description

BI Consultant with over 5 years of experience, I work on BI projects at various levels to provide the client with the most suitable solution for their technical constraints using an agile methodology. Primarily as a BI Engineer to leverage data through ELT flows and reports that meet business needs.

Languages

French
Native or bilingual
English
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

Bpi France
Data Engineer
BANKING AND INSURANCE
October 2022 - Today (3 years and 8 months)
Paris, France
Implementation of a new Big Data solution on AWS to centralize, transform, and leverage financial data for the Investment division, within a SAFe Agile framework. The objective: industrialize large-scale analytical flows around Apache Spark and managed AWS services.

Design and development of massive ETL/ELT pipelines onApache Spark (Scala and PySpark)for ingestion, transformation, and enrichment of large-volume data.
Implementation of **Spark jobs on AWS Glue**, with serverless orchestration and integration with AWS Lambda for event-driven processing.
Complete refactoring of IBM DataStage 11.7 processes to aserverless Spark architectureonAWS (Glue + S3 + Athena).
Setup of analytical queries withAmazon Athenafor data exploration stored on **S3**.
Automation and continuous integration with Jenkins, GitLab CI/CD, andApache Airflow(pipelines, multi-environment deployments).
Writing technical specifications, conducting tests, and monitoring deliveries across Dev / Testing / Prod environments via Jira.
Creation ofQlik Sensedashboards for business piloting.
Collaboration with business, functional, and technical teams to ensure the quality of deliverables.
Analysis and resolution of production incidents with follow-up on fixes.
Spark PySpark Scala Amazon Web Services Data Engineer
BNP Paribas
Data Engineer
BANKING AND INSURANCE
April 2021 - November 2022 (1 year and 7 months)
Paris, France
Design and development of ETL/ELT flows with AWS Glue and Spark (PySpark/Scala) for data ingestion and transformation.

Exploitation of data stored on Amazon S3 via Amazon Athena for ad hoc analysis and dataset preparation.

Modeling and publishing of interactive dashboards on Power BI and IBM Cognos for risk management and decision-making.

Implementation of distributed and optimized processes on AWS EMR for financial KPI calculation.

Automation and multi-environment deployments via GitLab CI/CD, Jenkins, and Airflow.

Writing technical documentation, specifications, and operational procedures.

Analysis and resolution of production incidents (N2/N3 support).

Close collaboration with business, functional, and technical teams to ensure the reliability of delivered solutions.
Spark Scala SQL Amazon Web Services Data Engineer
GENERALI FRANCE
Datastage Consultant
BANKING AND INSURANCE
March 2020 - March 2021 (1 year and 1 month)
Paris, France
Functional domain: Insurance

Tasks:
- Analyze and gather requirements from users
- Develop ETL flows on Datastage 11.5 (PX and Server)
- Write technical specifications
- Perform unit tests and assist users in their functional acceptance testing.
- Scheduling management
- Analyze and handle production incidents
- Deliveries to different environments

Tools: Datastage 11.5 (PX and Server), SQL, Service-now...
Database: Oracle 11g, SQL Server 2014
Datastage Oracle 11g SQL