Expert Business Intelligence - Senior Data Analyst / Engineer
Enedis
janvier 2025 - juin 2025
Lors de cette mission dans l'équipe iPilot, mon rôle a été de migrer les flux de données Informatica depuis la base de données Oracle vers Postgres ainsi que les cubes de données Tableau associés
• Migration de base de données Oracle vers Postgres
• Adaptation des flux Informatica Oracle vers Postgres
• Génération de cubes Tableau Postgres
SQL, Informatica, Tableau
Expert Business Intelligence - Senior Data Analyst / Engineer
Enedis
juin 2024 - aujourd'hui
Lors de cette mission dans l'équipe LinkyPilot, mon rôle a été de mettre en place des tableaux de bord de suivi de la chaîne logistique (déploiement et SAV)
• Animation d𠆚teliers de cadrage avec les métiers pour comprendre les règles de gestion et les données des différents partenaires
• Préconisations pour prévenir les l'obsolescence des systèmes d'information
• Modélisation et historisation des données
• Création de flux de données à partir de Kafka, collecte avec Spark, historisation en PL/SQL Oracle Data Lake
• Ordonnancement des tâches avec Control M
• Visualisation / Restitution des données avec Tableau Software et PowerBI
• Méthodolgie SCRUM et travail collaboratif avec Git / Jenkins / CI/CD / Confluence / Jira Data Mesh
SQL, Informatica, Tableau
Lead Data Engineer
The Adecco Group Lyon, FR
2021 - juin 2024
ï‚· Adecco Data Architecture 2.0 POC (on-going): Formulating a new Data
Architecture (Modern Data Stack) to swiftly address business requirements,
facilitate real-time data provision, enable seamless data sharing across the
organization, and enhance speed and scalability. Employing advanced
technologies such as Snowflake, DBT, FiveTran, Airbyte, Matillion, Datadog,
Airflow, Dagster, Terraform, Kafka, DevOps, Jira, Confluence, Jenkins, Kubernetes,
Docker, CI/CD, and Git, GitLab, GitHub. Python, Scala, GO
ï‚· Migration to Oracle Exadata: Spearheading the migration of data from our existing
infrastructure to Oracle Exadata with the dual objectives of reducing licensing
costs and optimizing performance in data loading and retrieval.
ï‚· Imagine and implement a near real time Business Intelligent workflow, from
Salesforce to Oracle to MicroStrategy Cubes. Improved data modeling to ensure
high availability and performance across the entire chain to deliver new KPIs to
business users. ETL Oracle Data Integrator (ODI12), Oracle Database 12 and
MicroStrategy self service reports, cubes, dashboards and mobile.
ï‚· Lead as an Expert: Empower and Train the BI Team in the Implementation of New
Paradigms. I consistently maintain my availability to promptly respond to
inquiries, provide assistance, and foster collaboration within the team. Whether
engaging with all my colleagues, I am dedicated to facilitating a supportive and
collaborative work environment. Additionally, I provide guidance in training and
assessment to gauge skill enhancement for the newest members of the team.
ï‚· Transversal role: Functioning in a transversal role, I am committed to
implementing best-in-class and robust streamlined processes. This ensures that
the solutions delivered not only meet but exceed industry standards, contributing
to the overall efficiency and success of the BI applications. I also focus on
educating the team to implement performance-oriented database modeling for
both data flow and presentation.
Senior Data Engineer, Platform Owner, Solution Architect
The Adecco Group Lyon, FR
2016 - 2021
ï‚· France BI Architecture Governance: Responsible for Ensuring Stability,
Improvement, Audit, Remediation, and Security for Oracle, MicroStrategy,
Essbase, ODI, and Data Science (Knime).
ï‚· Continuous Support and Updates for Churn Prediction Data Science Models Using
Machine Learning, Knime, Python, and R
Project Samples:
ï‚· Seamless Transition: Architecture Migration to a New Provider with Performance
Testing on Azure and On-Premise for Optimal Results.
Architecture Securitization: Proof of Concept for Database Migration (Snowflake,
Teradata, Exadata, Vertica) + Full Stack, Microstrategy
ï‚· ETL ODI, and Oracle Database Upgrade, along with Data Warehouse Redesign InDepth Evaluation of Cost, Complexity, Time, and Effort to Formulate a Robust
Migration Strategy.
ï‚· New usages: ChatBot with MicroStrategy API, API usage between applications like
Salesforce, BI Mobile Application
Senior Business Intelligence Consultant
Multiple clients Worldwide, on-site or remote Client Type: Insurance - Energy - Health – Mutual
2011 - 2016
During the period spanning from January 2011 to August 2016, I had the privilege of
engaging with various clients globally, catering to diverse sectors such as Insurance,
Energy, Health, and Mutual. In the role of a Senior Business Intelligence Consultant
and MicroStrategy Expert, I undertook responsibilities that significantly contributed
to the success of these ventures.
Key Responsibilities:
ï‚· Training Guide Development: I spearheaded the creation of customized training
guides for MicroStrategy developers, advanced users, and clients. These guides
were meticulously designed to address their unique functional needs, providing
targeted instructions to enhance the effective utilization of MicroStrategy tools.
ï‚· MicroStrategy Dashboard Collaboration: I collaborated closely with clients in the
meticulous crafting of MicroStrategy dashboards. My role extended to offering
expertise in optimizing database modeling for this reporting tool, ensuring not
only superior performance but also impeccable data quality. This collaborative
effort occurred on a weekly basis over several months, allowing the team ample
time to construct a robust data model under my expert guidance.
ï‚· Implementation of Best Practices: I played a pivotal role in implementing industry
best practices and development standards. This involved ensuring strict
compliance with the Group charter, fostering consistent and standardized
Business Intelligence solutions.
ï‚· Optimizing Report Performance: Tailoring my intervention to the specific context
of each client, I focused on enhancing report performance through the strategic
implementation of parallelism on the SQL Server platform.
Technical Environment:
ï‚· MicroStrategy
ï‚· Database Platforms: SQL Server, PostgreSQL, Oracle