Senior Oracle Applications Technical (Fusion & EBS)
GACA (General Authority of Civil Aviation)
Total des années d'expérience :13 years, 4 Mois
• Developed new VBCS pages embedded inside SAAS
• Build SAAS to SAAS Integrations using OIC
• Develop BI & OTBI Reports & Dashboards
• Build Applications using Application Composer
• Data Migration using FBDI & ADFdi
• Build integrations (REST& SOAP)inbound & outbound with third parties using OIC.
• Very Good knowledge in Functional Skills for SCM modules.
• Developed new OAF Pages to build new customized solutions as per business needs.
• Personalized and extended Oracle OAF pages using OAF Substitutions.
• Worked on the development of interfaces, Data Conversions, Data Migration especially on Purchasing (PO), Inventory (INV), Enterprise Asset Management (EAM) and Property (PN) modules.
• Designed and developed custom User Approval Workflow based on custom AME to meet the business requirement.
• Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
• Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.
• Build the integration between the Inventory and Intermec Label printers using TCP/IP protocol to print Stock item Labels automatically when received in the inventory.
• Build dynamic reports using XML Publisher and Report Builder.
• Extend OAF Pages to apply technical Solutions in advanced Procurement Modules (Sourcing, iProcurement).
• Supporting Property Management module in Data Migration, Personalization and Customization.
• Building dynamic alerts to Send notifications or Print reports automatically during Business cycles.
• Build Complexed, Dynamic AME approval for work confirmation.
• Build dynamic approval for Move Order using custom AME.
• Build dynamic approval for Inter-organization transfer using custom AME.
• Build Custom Approval for Payables Invoices (AP) based on the Standard Workflow.
• Gathering business requirements to build new solutions as per business needs.
• Implemented new Accrual plans for HRMS module with all required setup steps, like creating elements, element links, element Formulas (etc. …).
• Implemented many Self-service requests to handle and enhance HR & Payroll processes.
• Implemented user hooks linked with HR self-services EIT’s & Absence managements.
• Worked on the development of interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports touching various modules such as HR, Payroll, Project Costing, Project Billing, Project Contracts, PO, INV, AP and GL.
• Implemented Absence Management module with self-service based on EIT’s & AME (SSHR).
• Core HR data uploading using APIs and Web ADI.
• Designed and developed custom User Approval Workflow to meet the client application’s user creation and maintenance according to the business requirement.
• Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
• Personalized Oracle standard and custom Forms using oracle forms builder as per the Client requirements.
• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from other custom modules.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Developed Custom OTL module to manage, monitor, handle, calculate and transfer the time attendance collected regular and overtime hour’s dependent on each employee work shift from all projects in the company to the Oracle payroll module after processing, calculating and validating all the transactions based on specific formulas given by the Payroll team and this module supporting the multiple closes in the same month for the same employee.
• Developed various type of financial analysis reports (for all modules) using Oracle Discoverer 10g.
• Customized forms using CUSTOM.PLL to change the functionally of the standard forms.
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications.
• Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Application.
• Developed Alerts in Inventory, Project Contracts Modules.
• Registered the Concurrent Programs, Forms, Reports and Requests Sets in AOL and System Administration.
• Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.
• Developed Master Detail OAF Pages using Oracle JDeveloper.
• Personalized and extended Oracle OAF pages using OAF Substitutions.
• Communicating with Oracle Support to resolve/troubleshoot standard issues using SR.
• Enhance Oracle functionality with new custom applications.
• Developed and maintained the internal Intranet website.
Major Responsibilities :
• Worked as a web developer with HP Company on developing new Product (HP Smart Stream software - DFE) to handle and manage printing Jobs, this Application contains huge Options for the Client to handle his own Jobs.
• Developed Web based applications using JavaScript, AJAX, CSS, JQuery, HTML and YUI library.
Computer engineering
