Estephan Abi Rached

SEP 2020 - PRESENT
ORACLE APPLICATION CONSULTANT(CLOUD), ITEC SAL (IT ENGINEERING & CONSULTING)
· Expertise working on project Implementation, Configuration, up - gradation, Production Support and with change management process.
· Hands on Experience in implementing workforce deployment and development modules.
· Experience in implementing Procurement, and SCM.
· Business analysis and implementation experience related Purchasing, inventory, and Order Management, Procurement, AP, AR.
· Created and managed different status in Distributed Order Orchestration (DOO), Status management.
· Established Pricing, Inventory (Product Management), and worked on data access sets.
· Integrated web services and external fulfillment system, for Project Management in Oracle Fusion using OIC and Salesforce adapter.
· Excellent Project Development and Project Scoping skills.
· Oracle Supply Chain modules, which include Procurement, Sourcing, iSupplier, Inventory, Project & Service Contracts, Payables and iProcurement modules
· Technology-Functional Fusion SaaS knowledge on Oracle Fusion Project - PPM module (Project Task & Resource Management)
· Experience with project implementation, in multiple areas such as: configuration, testing, integrations, interfaces, extensions on PaaS, application upgrades, enhancements, data migration and solution maintenance
· Knowledge of Oracle Cloud and ERP Integration tools, techniques, scripts, and programs
· Advanced knowledge of Oracle PL/SQL, OTBI, OCI(OIC), and API web-service REST and SOAP

· 5 years of experience in Oracle EBS R12 Applications technical consultant.
· Extensive experience in both financial and manufacturing modules
· In-Depth understanding of Oracle Application architecture, experience with multi-Org features of R12.
· Proficient in Oracle Applications PL/SQL, SQL*PLUS, TOAD, SQL Loader, Data Loader, Database Triggers, Procedures, Functions, Oracle Reports 10g/6i Oracle Forms 10g/6i.
· Data Conversions through Interfaces and APIs and Custom Development using Oracle Applications Coding, Concurrent manager, flex field’s setup, Integration Testing, documentation, etc.
· End of year closing for different company on multi organization (Inventory, OPM, OM, Receivables like CN, DN)
· Developed Custom Packages, enhancements to existing, proposed new ideas, flexible methodology, and best procedures and implemented the same.
· Initiated, developed and implemented automated scripts and hence decreasing manual intervention which is desired in ERP.
· Have hands on experience in Order Management OM, Advanced Pricing, Supply Chain SCM, Accounts Payable, Accounts receivable and Inventory
· Hands- on Experience on Order to Cash cycle and Setup of New organization in Supply chain Module
· Worked on creating PLSQL Interface packages using standard Oracle APIs for Order Management, Pricing, and Oracle Projects.
· Extensive experience in coding Interface Programs for importing data from Legacy Systems.
· Experience in developing client server solutions using Oracle 6i/10g Forms and Oracle 6i/10g Reports, Xml Publisher. And also, expertise in building Reports in Discoverer 4i/10g Administrator including maintenance of Business Area and Work Book.
· Aptitude to swiftly troubleshoot and resolve various Oracle Applications issues which arise during the Project and the ability to work in a dynamic, team-oriented environment.
· Well Conversant with analysis, creation of detail design, coding, Quality and Documentation.
· Worked on the providing solutions for Business requirements.
· Implemented the new requirement related to the Header level Discounts on manual orders using modifiers and Qualifier setups.
· Worked on identifying/ owning OM related setups like OM Holds, validation templates, processing constraints, Transaction types, Defining and Assigning Document sequences, Defaulting rules, Attachment categories, OM system parameters.
· Actively participate in the design, development and maintenance of interfaces to and from the Oracle E-business Applications.
· Worked on form customizations in Purchasing, Inventory. Developed custom forms in Inventory, Engineering modules. Developed reports in Oracle Purchasing, Inventory, and Order Management. Also customized a number of oracles seeded reports. Developed scripts for importing Items, Item revisions, Item categories, Default shipping/receiving sub inventories and Bills of materials into Oracle.
· Customized the AR Invoice, Sales Tax Reports in Receivables.
· Customized the Auto Accounting and Auto Invoice Programs in Receivables.
· Developed Order Import Error Report in OM, and Developed a Shell Program to send the report as an email.
· Involved in the support of complete Procure to Pay and Order to Cash cycles.
· Designed and created custom forms to maintain data required for the advanced pricing and discounting matrix.
· Worked on interfaces mentioned as, Order Import interface program, Payables Invoice Import interface program, Item Import interface program, and Receivables Invoice Import Interface program.
· Customized some of the AR reports, including invoice printing report, collector information and some aging reports. Involved in Registration of Concurrent Programs, Executables, Creation of Responsibilities, Request groups, Menus, Submenus, Values sets, Forms, Functions in System Administration.