Freelancer profile translated to English.

Description

PL/SQL Designer-Developer, I have 27 years of experience covering technical expertise, project monitoring, development, optimization, and database administration.

I have mastered the design and development of complex applications, particularly in the insurance and banking sectors.

Organized and rigorous, I am committed to meeting deadlines while ensuring a high level of code quality.

Passionate about IT technologies, I am constantly looking for innovative and efficient solutions.

Languages

French
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

OWLIANCE
PL/SQL Developer
BANKING AND INSURANCE
June 2024 - January 2026 (1 year and 7 months)
Toulouse, France
Project Subject: Maintenance and evolution of the OWLINK tool

Design and development of technical solutions for new features

 Modeling & Design
o Collaboration with functional architects to define technical solutions.
o Writing technical specifications.
o Development of deliverables: versioned DDL scripts, compliance with naming conventions and archiving policies.
 Documentation & Business Logic
o Centralization of error messages and management of an application log (LOG table + autonomous LOG_ERROR procedure).
o Detailed documentation of PL/SQL routines.
 Orchestration & Scheduling
o Creation of parameterized batches according to a standard model (parameter tables, incident recovery, control counters).
 Performance & Tuning
o Optimization of SQL/PLSQL processes to ensure performance and robustness.
 Deployment & DevOps
o Version management via GitLab.
o Creation and monitoring of Merge Requests with delivery validation.
o Management of CI/CD pipelines via YAML file (compilation, utPLSQL tests, packaging, deployment).
o Conflict resolution and GitLab commit management to ensure delivery quality and traceability.
Oracle PL/SQL Gitlab CI/CD ETL Processes
SWISSLIFE
TSQL Developer
BANKING AND INSURANCE
May 2023 - December 2023 (7 months)
Levallois-Perret, France
Project Subject: Maintenance and evolution of the KLIFE tool
Responsibilities held: TSQL Developer

 Incident Management
 Involvement in the life cycle of an operation (Arbitration, Redemption, Programmed Payment....)
 Functional and technical analysis of requirements
 Writing detailed application specifications
 Development of SQLSERVER Objects (Scripts, Tables, Procedures, Functions, Triggers...)
 User support during Acceptance Testing
ETL Processes SQLServer VBA
Shippeo
Senior ORACLE Consultant
TRANSPORTATION
August 2022 - April 2023 (8 months)
Lyon, France
Project Subject: Maintenance and evolution of an ORACLE database

 Management of a real-time goods transport tracking application.

 Incident Management
 Study of functional specifications for evolutions
 Technical description of business rules
 Development of ORACLE Objects (Tables, Packages, Procedures, Functions...)
 Tuning and Optimization
 Systematic writing of analysis reports, incident resolutions, significant progress updates, and technical studies
Oracle PL/SQL