SUMMARY:

• More than seventeen years in information system’s development with Oracle technologies.
• Very good development skills in Oracle forms/reports, pl/sql development.
• Relational data modeling and Functional analysis.
• SQL Optimization and Oracle database Tuning.

TECHNICAL SKILLS:

Programming Languages And Tools: Oracle E - Business Suite (module HRMS), Oracle workflow Builder, Oracle Enterprise Manager, SQL*Plus, PL/SQL developer. Oracle Forms & Reports, Oracle Designer

Methods And Techniques: Merise, UML, Rational Rose, DMR Macroscope and Oracle Aim Methodology.

PROFESSIONAL EXPERIENCE:

Oracle Software Developer/Architect

Confidential

Environment: Centre Productivité, Oracle Database 12c, Oracle Application Server 11g/12c, Oracle Developer Suite 11g (Forms 11G, Reports 11G), SQL, PL/SQL, Oracle Application Express, Oracle Warehouse Builder, Oracle Portal, «CA Software Change Manager workbench» (Harvest), Toad. Linux server. Windows 10.

Methods: Macroscope, AIM d’Oracle, Centre Productivité

Responsibilities:

• Support the Department's projects in the use of the Oracle Forms/Report 11gR2 tools, the use of the Oracle Designer tool and the PL/SQL coding;
• Identify and correct runtime issues of the Oracle Forms, Report and PL/SQL components following the update to OFM 12c.
• Maintain common modules using Oracle Forms, Reports and PL/SQL components.
• Keep documents related to common objects up to date.
• Maintain all operating documentation, installation and automation scripts;
• Support the DBAs and functional analysts in the organic design of applications using the Oracle DB.
• Managing and upgrading the source code using the migration tool: «CA Software Change Manager workbench» (Harvest).

Oracle Software Developer/Architect

Confidential

Environment: Centre Productivité, Oracle Database 12c, Oracle Application Server 11g, Oracle Developer Suite 11g (Forms, Reports 11G), SQL, PL/SQL, Oracle Application Express, Oracle Warehouse Builder, Oracle Portal, «CA Software Change Manager workbench» (Harvest), Toad, Linux server. Windows XP.

Methods: Macroscope, AIM d’Oracle, Centre Productivité

Responsibilities:

• Ensure the responsibility of Oracle applications.
• Support the development team in solving problems.
• Install and configure Oracle Application Server (weblogic and OFM 11G and 12c later) for the different applications of the MTQ.
• Certify the deliverables produced by the development teams (documentary deliverables and code) according to the programming standards the ministry (MTQ) (quality insurance)
• Develop templates and common modules (MCO) used by different systems.
• Observe PL/SQL queries’ performance and propose corrections if necessary.
• Automate code revision: Develop rules on good practice according to the standards and rules of the MTQ, with XPath for the tool «Toad Code Analysis »

Oracle Developer Analyst EBS (HRMS)

Confidential

Environment: Oracle Designer et Developer Suite 10g, Toad for Oracle version 9.1.3, DBMS Oracle 10g R2, SQL, PL/SQL+, SAS, UNIX, Oracle BI Publisher, Unix server, Windows XP.

Methods: Macroscope, Guide vert, UML.

Responsibilities:

• Produce reports from data model using Oracle BI Publisher.
• Produce unit test scenarios;
• List the components of the modified EBS components;
• List of error messages added;
• Set parameters (updated)
• Implement and test data-fixe scripts.
• Carry out the SAGIR improvement works related to regulatory changes and changing business needs and business customers;
• Support the operations and achieve steady evolution of SAGAR.
• Provide the needed expertise to maintain SAGIR system;
• Ensure the new recurrence arising from business projects;
• Support larger projects that are or will be in progress at the DGSAGIR the coming years such as: SGR2 deliveries, SGR3deliveries, upgrade the application SAGIR to version 12, setting up and maintaining SAGIR-RQ, possibility to integrate other phases from SGR4 to SGR7.
• Program of the presented works, write documentation, produce and execute the unit test cases.
• Make the technical design of application extensions - technical part;
• List the EBS modified components.
• List of added error messages.
• Updating settings.
• Implement and test scripts for data-fixes.
• I have realized the following tasks:
• Perform programming of the presented works, writing documentation and run unit tests.
• Make the technical design of application extensions - technical part;

Oracle Developer Analyst

Confidential

Environment: Oracle Designer et Developer Suite 10g, Toad for Oracle version 9.1.3, DBMS Oracle 10g R2, SQL, PL/SQL+, SAS, UNIX, Windows xp.

Methods: Macroscope, Guide vert, UML

Responsibilities:

• Adjustment of 8 code programs to enable processing execution without errors, due to changes from the source system database (renamed tables and elements + new table joins).
• Modification of the complex logic of dynamic generation of queries that recover changes in order to meet new delivery needs and potential future needs.
• Adjustment of the very complex query building portrait of a particular in order to supply the items correctly and effectively purify duplicates.
• Unit tests and assisting in the preparation of functional tests (technical component).
• Assisting in the preparation of acceptance tests (technical component).
• Modification and implementation of SAS programs to compare two schemas and ensure data integrity.

Oracle Developer Analyst

Confidential

Environment: Oracle EBS version 11.5.10, Oracle database 10g / OEM, Orale Universal Content Management - UCM (Portail), Linux (Red Hat et SUSE), SUN M9000 / M5000 (Solaris), IBM, Windows, Perl, Oracle Forms, Oracle Report, JSP, OAF: Libre service / OFP: Form personalization / Discoverer / XML Publisher / Oracle BI Publisher

Methods: Oracle AIM

Responsibilities:

• Make OFP adjustments (Oracle Forms Personalization) on Oracle E-Business Suite Human Resources Management System (HRMS),
• Make adjustments on OTL (Oracle Time and Labor) and Oracle OTL preferences.
• Produce and create Oracle workflows processes.
• Check and update MD070 MD50 and compare to the reports code.
• Perform maintenance on reports and planning test sets.
• Business solution in Integrated Resource Management (SAGIR) aims to establish, in a scalable way, recognized practices to be effective in the management of human, financial and material resources.
• The implementation plan for the (SAGIR) is a strategy of gradual implementation of the solution.
• In this sense, it cuts into seven distinct phases the development and implementation of the various components.

Oracle Developer Analyst - Functional Analyst

Confidential

Environment: DMR-Publisher, Java, JSP, XML, J2EE, ADF Business Components (BC4J), STRUTS, canevas d’applications ministériel Java, Access, ASP, Visual Basic, Relational Tools de Princeton Softech, suite Office 2007, Internet Explorer 6,0 sp2, Oracle Designer et Developer suite 10G, JDeveloper version 10.1.3.3, TOAD version 9.1.3., SQL Design version 5.00F, Visio 2000, «CA Software Change Manager workbench» (Harvest), Test Director, DBMS Oracle 10g R2, PL/SQL

Methods: DMR Macroscope

Responsibilities:

• Designing and testing process and user interfaces with Oracle Designer.
• Functional analysis of customer needs
• Managing and upgrading the source code using the migration tool.

Oracle Functional analyst & Programmer analyst

Confidential

Environment: Windows Server 2000 et XP, Oracle database 9i, Forms 11G, Reports 11G, PL/SQL, SQL*Plus

Responsibilities:

• Develop and implement integrated and functional testing in collaboration with users,
• Maintain the physical model of the Oracle database.
• Ensure consistency of treatment and data integrity.
• I was given the following tasks:
• I realized an information technology solution to the olive oils system. I was responsible for all the life cycle of the software, namely the definition of requirements, analysis, design, development, implementation, testing, user training and maintenance, and for each regional center.
• This application was aimed, among other things, to standardize work processes and output states on the stocks of regional centers of the company and to support decision making through dashboards (history of battery, display changes oil on the battery after each input and output, automation of training of batches for export, etc.)..
• Provide the client with new features and work processes according to the business needs and new realities of the office.
• Propose and design new processes in order to standardize work processes in the regional centers of the company,
• Document the needs of new features and change requests.
• Write functional design files and work processes.
• Develop user interfaces and reports,