Freelancer profile translated to English.

Description

I have over 10 years of experience in BI projects, primarily in the banking and insurance sectors.

I started as a developer then a technical lead on Informatica and Oracle, and evolved into a Project Manager (MOE).

I have managed complex migration projects, such as upgrading Oracle 12c -> 19c EXACC and Informatica 10.2 -> 10.5 at Crédit Agricole. There, I was responsible for management, coordination of over 10 people, and securing critical environments.

My main achievements: delivering on time, ensuring service continuity, and establishing true collaboration between project teams.

Industry field of expertise

Languages

Kabyle
Native or bilingual
French
Native or bilingual
English
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

CAAS assurances
BI Project Manager
BANKING AND INSURANCE
March 2022 - Today (4 years and 3 months)
Context: CACI DATA is the data warehouse for borrower insurance contracts. Data from various distributors are consolidated and made available to users through SAS and Qlik View reporting tools.

ETL platform version upgrade project for two ETL platforms (CACI and Predica):

The project aimed to address the end of support for Informatica PowerCenter 10.2. HF2, certify connectivity with Oracle 19, and meet the Group's architecture policy (Linux to SoCloud, Oracle to Postgres, Synergie to CI/CD, and interpel to CFT).
Oracle obsolescence project on the CACI-DATA platform:
- Migration of database servers and application servers with the implementation of a new infrastructure on exacc.
- Oracle 12C to Oracle 19C version upgrade.
- Redhat 6 to Red Hat 8 version upgrade.
- Securing Oracle access via the SQL Developer utility in production.
- Integration of CACI-DATA environments into CACI schedules.

- Project scoping
- Needs qualification, project plan construction, deliverable tracking
- Organization, activity monitoring, and facilitation of project instances.
- Coordination of contributing teams.
- Facilitation of working meetings with various contributors.
- Minute writing.
- Reporting to various stakeholders from scoping to post-production monitoring.
- User assistance.
- Post-migration monitoring.
- Management of up to 10 people in France

Informatica Tech Lead:

A transverse role where I provide my expertise and advice within the Predica center of expertise.
- Quoting.
- Feasibility study / impact study.
- Design / development and acceptance testing.
- Deliverable tracking.
- Production monitoring.
- Technical support.
- Ticket management on ServiceNow.
- RACI implementation.
- Suggestions for improvements.
- Version management.
- Documentation.
BNP Paribas
BI Technical Expert / Infra Project Manager
BANKING AND INSURANCE
November 2019 - January 2022 (2 years and 2 months)

The ETL-MUTU platform at Cardif plays a crucial role in BNP's information system.
It is available to all insurance business applications.
The solution is industrialized and meets the requirements of the group and the business in terms of architecture, security, and operability.
Refactoring of Infrastructure/Architecture and improvements of the ETL-MUTU Platform (Project):
Achievements:
- Inventory and context analysis
- Architecture definition for increased modularity, performance, high availability, and security of the ETL platform
- Conducting a POC to compare file system performance (NAS NFS v3/v4 & GPFS) and verifying their compatibility.
- Recommendations for distributed and secure architecture
- Informatica PowerCenter upgrade from 10.1 to 10.4 with split and parallel RUN strategy
▪ Quoting of the two strategies for sponsor arbitration.
▪ Qualification of Informatica versions: V10.1 vs V10.4.
▪ Guaranteeing the functionality of client applications after migration.
▪ Development of installation and operation files for the new Informatica version.
▪ Definition of upgrade processes for new versions.
▪ Study and validation of new versions.
▪ Development of the deployment plan for different environments.
▪ Implementation of TNRs for migration validation.
▪ Execution of the migration of different PROD and non-PROD environments.

- Implementation of ETL platform security (HTTPS, SSL/TLS activation)
▪ Oracle 19 client SSL activation.
▪ Activation of intra-domain/repository security.
- Implementation of MongoDB Connector and upgrade to 10.4.1 on the ETL platform (Actions in progress)
▪ Feasibility study.
▪ Conducting a POC for HotFix 10.4.1 and MongoDB connector tests.
▪ Definition of the 10.4.1 migration strategy.
▪ Quoting of the 10.4.1 migration.
BNP Paribas
ETL Administrator
July 2018 - November 2019 (1 year and 4 months)
I worked as an administrator on the ETL-MUTU platform and the OSE application (Execution Flow Monitoring Tool).

Context:
Administration and support on the ETL MUTU platform (RUN).

Achievements:
- Review of the service catalog for the ETL solution.
- Administration of the Informatica platform in Grid mode (hosts 120 applications).
- Ensuring the monitoring of the ETL-MUTU platform across all environments.
- Performing morning checks.
- Definition of installation, configuration, and development standards.
- Validation of application changes.
- Incident resolution.
- Providing on-call support for platform-impacting operations.
- Reporting and statistics on platform usage.
- Performing maintenance and optimization operations.
- Verifying the conformity of the Informatica maintenance contract.
- Reviewing authorizations.
- Implementing a TOR process for Citrix authorizations.
- Development norms and best practices.
- Implementing a new RACI for incident management.
- Reviewing communication and incident resolution processes.
- Transverse support to project teams (level 1, 2, and 3 support).
- Mapping optimization and reminder of norms and standards.
- Installations / configurations.
- Responding to project requests/issues.
- Presenting the infrastructure to OPS teams.
- Incident management on ServiceNow.