Freelancer profile translated to English.

Description

Oracle PLSQL expert for over 14 years. Autonomous, rigorous, proactive, and good communication, I enjoy working with complex queries and have strong analytical skills.

I have worked in various sectors, Transport, Human Resources...

I am immediately available to undertake a new mission.

Tech Lead for 5 years, do not hesitate to contact me for more information.

Languages

English
Conversational
French
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

VINCI AUTOROUTES
PL/SQL Development Engineer
CIVIL ENGINEERING
November 2023 - Today (2 years and 7 months)
Nanterre, France
Design and development of a communication system between toll equipment for real-time message management and broadcasting. Extensive use of XML and JSON files for data exchange.
• Analysis of client needs and definition of technical specifications.
• Development of PL/SQL procedures for manipulating and transforming XML and JSON files.
• Development of real-time message broadcasting mechanisms to toll equipment.
• Design of XML schemas for data validation.
• Implementation of data validation and transformation functions using XMLType and Oracle JSON functions.
• Optimization of PL/SQL query performance to ensure rapid message processing.
• Development of Shell scripts for launching stored procedures.
• Unit tests and continuous integration to ensure code quality.
• Testing and acceptance monitoring.
Oracle PL/SQL Shell Script Atlassian JIRA Oracle SQL Developer Putty WinSCP
KAPIA-RGI
PLSQL Development Engineer
May 2023 - September 2023 (4 months)
Paris, France
Involvement in the various phases of a project to contribute to the stability and continuous improvement of the Kelia software (Insurance software).

• Design and development of new features in PL/SQL using TOAD.
• Develop PL/SQL packages, stored procedures, functions, and triggers.
• Close collaboration with functional and technical teams to understand business requirements and ensure solutions meet user needs.
• Code review.
• Correct anomalies or perform data recovery (PDON) in conjunction with functional consultants, respecting cost and deadline commitments.
• Write technical specifications.
• Write technical maintenance documentation.
• Testing and acceptance monitoring.
Oracle PL/SQL Toad Atlassian JIRA SVN
SAINT-GOBAIN
PLSQL Development Engineer
August 2022 - March 2023 (7 months)
Paris, France

Project to rebuild the CMFR (Cadres Management Follow-up Report), which is a dynamic report for tracking executives within the Saint-Gobain group. Report developed in MicroStrategy with data from an Oracle database (PeopleSoft).
• Creation of efficient and optimized data schemas to ensure high performance during report and query execution.
• Close collaboration with functional and technical teams to understand business requirements and ensure solutions meet user needs.
• Analysis and Development in Oracle with SQL Developer.
• Data integration.
• Data validation.
• Write technical specifications.
• SQL/PLSQL development (Stored procedures) in Oracle and Snowflake.
• Write technical maintenance documentation.
• Testing and acceptance monitoring.
• Test execution.
Oracle PL/SQL Oracle SQL Developer Atlassian JIRA Snowflake