Name: Expert in Oracle PL/SQL | APEX | TALEND | POWER BI
Price: 500 EUR
Availability: InStock

Freelancer profile translated to English.

Back to original language

Description

Advanced mastery of Oracle tools: SQL, PL/SQL, Application Express (APEX), and Oracle REST Data Services (ORDS)
Expertise in optimizing SQL queries and PL/SQL stored procedures
In-depth skills in data integration with ETL-Talend Data Integration
Expertise in data analysis and creating interactive dashboards with Power BI
Significant experience in designing and modeling relational database schemas
Solid experience in data management and migration, including database synchronization and handling large volumes of data
Good knowledge of Oracle E-Business Suite (EBS)
Mastery of web technologies: JavaScript, HTML, and CSS
Knowledge of version control tools, particularly SVN and GIT
Good knowledge of the Linux operating system (Ubuntu, Debian)
Proven experience in data auditing and validation
Passionate about continuous learning and curious to explore new technologies and best practices
Strong technical writing and professional communication skills

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 30km)

Technip Energies France
Oracle APEX and PL/SQL Developer
ENERGY AND UTILITIES
November 2023 - Today (2 years and 7 months)
Nanterre, France
Mission Description:
Within the Smart-Plant Materials (SMAT) team, I designed and developed a web application using Oracle PL/SQL, SQL, and APEX, while enhancing the functionalities of another application based on Oracle Forms Builder. My responsibilities included:
Developing patches and optimizing the performance of SQL queries and PL/SQL stored procedures.
Developing and deploying a web application built with PL/SQL & SQL on the backend, and Javascript-HTML-CSS on the frontend. The application is essential for managing material procurement.
Automating processes, making the planning of quantities to be purchased faster, more reliable, and accessible, thus simplifying decision-making with optimized data.

Tasks
PL/SQL and SQL Development
o Development of highly performant and maintainable stored procedures with PL/SQL

o Development of optimized SQL queries using recent Oracle database features (12c and 19c)
o User requirements analysis and definition of technical specifications.
o Design and modeling of tables and their constraints using Oracle SQL Developer Data Modeler.
o Writing comprehensive technical documentation to facilitate maintenance and understanding.

Oracle Forms Application Maintenance
o Development of patches with PL/SQL and Forms Builder to ensure functional reliability.
o Optimization of business logic in PL/SQL to ensure accurate calculations, robust validations, and improved overall performance.

APEX Application Development
o Creation and customization of modern and user-friendly web pages and reports.
o Interactive and dynamic design through Dynamic Actions and Ajax calls.
o Preparation of the production environment and application deployment.
APEX PL/SQL SQL JavaScript HTML5 CSS3 SQL Optimization PL/SQL Optimization Requirements Analysis Specification Writing Oracle Forms
Bouygues Telecom
PL/SQL Developer
TELECOMMUNICATIONS
April 2022 - November 2023 (1 year and 7 months)
Meudon, France
Mission Description and Key Achievements:

Within the ITRES team of Bouygues Telecom's IT department, I was responsible for developing technical solutions in SQL and PL/SQL, while integrating modern Oracle features, to ensure the maintenance and evolution of two key applications:
✓ Internet Access Request Management Application,
✓ Internet Access Order Deployment Management Application.

The 5 main projects I completed during this assignment are:

1. Global optimization of data models, SQL queries, and PL/SQL code to improve the performance of both applications.

2. Evolution of the FTTE (Fiber To The Enterprise) offering on RIPs (Public Initiative Networks) to simplify interactions between the various stakeholders involved in the deployment of FTTE orders for businesses.

3. Correction of anomalies and bugs, industrialization of existing code, and automation of repetitive tasks, ensuring greater efficiency.

4. Design and implementation of a REST API dedicated to technician intervention scheduling, facilitating seamless integration with third-party applications and reducing interaction times by 30%.

5. Development of SOAP services to automate data exchange between various internal company systems.
PL/SQL SQL SQL Optimization PL/SQL Optimization Web Services RESTful Web Services SOAP Web Services Data Analysis Shell Scripting Debian
Crédit Coopératif
PL/SQL Developer and Talend Data Integration
BANKING AND INSURANCE
August 2020 - January 2022 (1 year and 5 months)
Nanterre, France
Mission Description and Key Achievements:

As part of my assignment at Crédit Coopératif's IT department (DOSI), I was responsible for TALEND and PL/SQL developments related to various proprietary IT applications. The main projects completed, combining TALEND, PL/SQL, SQL, Java, and Power BI, can be summarized as follows:

1. Data extraction from the DATAMART, with automated generation and provision of periodic business reports (TALEND, SQL, Java).

2. Synchronization of data flow updates between different applications and Oracle, MySQL, and SQL Server databases (TALEND, SQL, Java).

3. Management of data flow exchanges with a remote server: retrieval, analysis, processing, and return (TALEND, SQL, PL/SQL, Java).

4. Analysis of bank transactions to identify inconsistencies and anomalies, accompanied by real-time generation of summary reports (PL/SQL, SQL, TALEND, Java).

5. PL/SQL development: creation of functions, stored procedures, packages, tables, views, materialized views, indexes, triggers, sequences, synonyms, and custom types.

6. Use of Power BI for data analysis and creation of interactive reports, dashboards, and visualizations aimed at optimizing decision-making.

7. Design of data models with Power BI: creation of relationships between tables and writing DAX formulas for complex calculations.
Talend Open Studio SQL PL/SQL Oracle Database MySQL SQL Server Microsoft Power BI SQL Optimization