Freelancer profile translated to English.

Description

🚀 In summary: Expert Data Consultant | SQL, Python & Big Data | Structured and unstructured databases

💡 With 8+ years of experience in Data Science & Big Data, I have supported companies like Caisse des Dépôts, MACIF, and MAIF in optimizing their data and digitizing their processes.

📌 Looking to fully leverage your data? Need an expert to automate your processes, create impactful dashboards, or optimize your Big Data flows?

👨‍💻 What I bring you:

✅ Data pipeline development (ETL, ingestion, transformation with Python, PySpark, SQL)

✅ Creation of interactive dashboards and automated reports with Power BI, Tableau, Spotfire

✅ Database & SQL query optimization (PostgreSQL, Hive, Oracle)

✅ Automation and integration in Big Data environment (Spark, Hadoop, Cloud)

✅ Implementation of data governance and quality control

📞 Let's discuss your project together!

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Bordeaux (up to 50km), Niort (up to 50km), La Rochelle (up to 50km), Paris (up to 50km)

Caisse des depôts
Data Engineer
PUBLIC SECTOR
October 2022 - Today (3 years and 8 months)
Bordeaux, France
Project: Massive migration project from an old system to a modern Big Data data warehouse, in the field of social and retirement data.

 ETL development in Python, Pyspark, HQL; feeding the datalake (Oracle, Hive, PostgreSQL).
 Creation of optimized datamarts
 Automation of flows via Control-M, Jenkins, Cloudbees; Git versioning.
 Incident and ticket management via Jira, writing specifications and technical specifications
 Processing of technical incidents/anomalies, and production fixes
 Facilitating business/user meetings and training new team members.
 Implementation of POCs to improve Big Data architecture.
Linux, Hadoop Cloudera, Hive, Oracle, PostgreSQL, Python, Pyspark, Jenkins, Control-M, Tableau, Hue, Sqoop, Git, Jira, Agile Scrum
MAIF
Data Consultant
BANKING AND INSURANCE
August 2021 - September 2022 (1 year and 2 months)
Niort, France
Project: HR project aimed at developing strategic dashboards for monitoring HR performance and indicators.

 Optimization of SQL/HQL queries on Hive, reducing query times by 40%
 Creation of HR dashboards (Spotfire, Power BI).
 Conducting HR statistical studies, data cleaning and processing (Alteryx, Python)
 Development of predictive models with SAS.
Spotfire, Power BI, Alteryx, Python, SAS, MySQL, Jenkins, Putty, Agile Scrum
MACIF
Data Scientist
BANKING AND INSURANCE
March 2021 - July 2021 (4 months)
79000 Niort, France
Project: Populating a data warehouse from heterogeneous sources for centralization and decision-making exploitation.
 Development of ETL flows under Informatica PowerCenter 10.
 Creation of Python and Bash scripts for automating processes.
 Automated reporting under SAP BO/SAP BI
 Technical documentation, testing, and anomaly correction.
 Handling and processing tickets on Easyvista/Jira
 Analysis of technical incidents, and fixes
 Scheduling and automation of jobs under Jenkins, deployment and versioning under Jenkins
Informatica, SAP BO BI, Oracle, Hive, Hadoop, SQL, Python, DbVisualizer, Jenkins, Putty, Jira, Easyvista, Agile Scrum