Freelancer profile translated to English.

Description

Passionate BI Engineer with over 8 years of experience, primarily involved in data integration and automation projects using Oracle Data Integrator (ODI).

My background has allowed me to collaborate with several French companies (Energy, Insurance, Telecom) on various assignments: ELT flow migration, data warehousing system redesign...

Today, I offer my services as a freelancer through payroll outsourcing, remotely or in the Île-de-France region.

Industry field of expertise

Languages

French
Native or bilingual
English
Conversational
Arabic
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

EDF
Development and Studies Engineer
September 2023 - Today (2 years and 9 months)
Mission(s) and achievements
• Migration of flows developed under HADOOP to ODI
• Redesign of the Consumption Monitoring chain
• Implementation of data flows for customer contractual and housing data publication to web services.
• Generation of flat files and implementation of a deposit mechanism.
• Implementation of security measures to protect sensitive data
• Analysis of the existing system
• Writing technical and functional specifications.
• Validation of non-regression post-flow migration.
• Development and Optimization SQL/ PLSQL: Packages, Stored Procedures
• Analysis of performance issues
• Optimization of ODI processes
• Delivery of scheduling plans
• Management of evolutions.
• Optimization of processes (Tuning of SQL queries and PLSQL code)
• Post-production support and intervention for anomaly management
• Training of new joiners
• Supervision of production processes
• Realization of automated unit tests
• Realization of tests in acceptance and integration environments
France TV publicité
Development and Studies Engineer
November 2021 - August 2023 (1 year and 10 months)
• Analysis of the existing system
• Writing technical documentation.
• Validation of non-regression post OWB→ODI 12c migration.
• Development and Optimization SQL/ PLSQL: Packages, Stored Procedures
• Analysis of performance issues
• Migration of PLSQL assets to ODI
• Optimization of ODI processes
• Delivery of scheduling plans
• Maintenance of SHELL scripts
• Management of anomalies and evolutions.
• Optimization of processes (Tuning of SQL queries and PLSQL code)
• Post-production support and intervention for anomaly management
• Production deployment monitoring
MFA (Mutuelle fraternelle d'assurance)
Development and Studies Engineer
August 2020 - November 2021 (1 year and 3 months)
Mission(s) and achievements
• Analysis of the existing system
• Writing detailed technical specifications (STD)
• Development of Mappings, packages, and processes for populating the DATA WAREHOUSE
• Maintenance of specific KMs and JYTHON/JAVA Scripting
• Migration of AMADEA flows to ODI 11G.
• Validation of non-regression post ODI 11 ➔ ODI 12C migration.
• Populating DATAMART and implementing business rules
• Reading and analyzing detailed functional specifications (SFD)
• Reporting in BO: Maintenance and creation of universes and reports.
• Development and Optimization SQL/ PLSQL: Packages, Stored Procedures
• Analysis of performance issues
• Migration of PLSQL assets to ODI
• Optimization of ODI processes
• Maintenance of custom KMs post-migration.
• Delivery of scheduling plans
• Maintenance of SHELL scripts
• Management of anomalies and evolutions.
• Optimization of processes (Tuning of SQL queries and PLSQL code)
• Post-production support and intervention for anomaly management
• Production deployment monitoring