SUMMARY:

• Oracle Cloud/EBS Applications Sr. Technical Consultant with 16 plus years of diversified experience with focus on implementation/upgrades, re - engineering, design, development, configuration of e-Business Suite Applications and Oracle Cloud Applications SaaS and PaaS .
• Oracle Cloud Applications 20A (11.13.20.01.0 )
• Oracle Applications R12 (12.1.3), 11i (11.5.10, 11.5.9, 11.5.8, 11.5.7, 11.5.5, 11.0.3, 11.0.2, 10.x, 10.6)
• Enterprise Resource Planning (AP, PA), Human Capital Management (HR/Payroll), Supply Chain Management iExpense, Fixed Assets, EDI Gateway Oracle Projects, Oracle Inventory, Accounts Receivables
• Cash Management, Bills Presentment Architecture (BPA) Oracle Energy (JVA & Enterprise Upstream), General Ledger OTBI, BIP, Oracle BI Publisher Oracle Business Intelligence (OBIEE)
• Oracle Discoverer 10.x, 4.x, 3.x Oracle Forms, Oracle Reports
• Oracle Workflow 2.6, Oracle Alerts Oracle Applications Framework (OAF)
• Reports Exchange Designer (RX) RICE (Reports, Interfaces, Conversions, Extensions)

TECHNICAL SKILLS:

Application: OIC version 20.1.2.0.0 (200227.0200.34310 ), OTBI, BI Publisher, Developer 2000 (Forms/Reports 10g/6i), Workflow Builder 2.6Tools Discoverer 10.x/4.x/3.x, Oracle Applications Framework (OFA), Oracle Business Intelligence Enterprise Edition (OBIEE), Reports Exchange Designer, Web ADI, JDeveloper (10.1.3.3.0 ), SQL*Loader, TOAD, SQL Navigator, PVCS, Sablime, Control M, AIM, Visual Source Safe, Single Sign-On, StarTeam, iProjects, Oracle On-Demand (OOD)

RDBMS: Oracle v12.x/11.x/10.x/9.x/8.x/7.x/6.x, MS Access v7.x/2.x

O/S: HP-Unix 8/9/10/11, AIX, Linux, MS Windows ME/NT/2000, SunOS, IBM OS/2

Hardware: SUN SPARC, AIX, IBM Compatible (386/486/Pentium) PC, Macintosh, VAX

EXPERIENCE:

Oracle Cloud/EBS Technical Consultant

Confidential, Houston, TX

Responsibilities:

• Performed gap analysis, developed OTBI, OBIA and BIP reports using Data Models, Subject Areas and Analysis for Oracle Cloud ERP (AP, PA), HCM, SCM modules (R13) Version for Oracle Cloud Applications 20A.
• Involved in the design, development, unit testing of end-to-end interfaces of OIC including execution of transformations using OIC mapper, configuration of Oracle EBS/Rest Adapters and Monitoring/Administering ICS Integration with third party vendors.
• Developed Oracle BI Publisher Reports/ OTBI/ FR Studio/ Account Monitor, Account Inspector, Smartsheet View .
• Involved in R12 (v12.1.3) upgrade (11i), development, implementation of a global multi-org/currency AP, Payments, Supply Chain Management (SCM), Oracle Projects, iExpense, Approvals Management Engine, HRMS/Payroll.
• Developed custom AME rules for Payables Invoice Approval, Invoice Import processes (XML Gateway, Imaging), Purchase Order Approval, iProcurement, iExpense Approvals, Purchase Requisition Approval for dual custom approval lists, control groups, supervisor hierarchies.
• Developed custom AME rules and customized the Auto Creation/Approval process for PO Mobile Application.
• Developed custom in-house workflows with custom routing lists/processes dynamic HTML notifications, embedding documents/pages, building adhoc-roles approver lists for Projects Approval Workflow, AFE Event (Land, DO, Event) Workflow for P2ES.
• Customized AP, PO, Requisition, iExpense, Account Generator workflows using PA Auto-accounting rules & custom approval routings including processing Attachments/Images for AP/SCM/PA & displaying in workflow notifications.
• Developed custom e-Text BI Publisher template(s) for ASCII Payment file for third party Vendor Payment Checks, Positive Pay Files.
• Customized XSL templates for Standard, Blanket PO’s and Releases, PO Output for Communication, extending XML views to include additional details, custom messages.
• Developed Global Transport Management (GTM) and Oracle Transport Management (OTM) outbound interfaces from Purchasing.
• Developed custom database triggers for supporting extensions/validations/DML operations across Financials, PA, GL, iExpense, SCM.
• Developed custom AR Invoice Print BI Publisher template mapping custom supplementary views with new runtime parameters in BPA.
• Developer API's to load new parties/customer accounts to convert party types from Person to Supplier and import/extract party information.
• Customized payment process to integrate a new Org, payment profiles, localized Check templates, Separate Vendor Remittance Advices.
• Developed API’s to load BAI2 Bank Statement Files, employee Credit Card Transactions, customized Import and Reconciliation process.
• Developed custom PA Transaction Controls Auto Copy Process by Project Template, Project Class, Project Type and Expenditure Types.
• Developed custom interface to create employees as supplier, import expense reports and create payments/bank account information.
• Developed custom process for Pre/Post Item validations/processing for inbound item creation process into Oracle PIM for Oracle Inventory.
• Developed API for update/activation of all master items (Descriptions/Item Class/Catalog/template/price) extending it to the necessary Orgs.
• Performed Form Personalizations /Customizations using OAF (v10.1.3.3), extended the VO, region creation, invoking workflow from custom pages for PA/SCM/Core HR/SSHR using OAF/JDeveloper .
• Developed 6i reports and converted to BI Publisher Reports using BIConverter tool, developed new custom BI Publisher RTF, XSL templates.
• Developed custom Event based/Periodic Oracle Alerts across AP, PO, Requisition, Projects, Inventory, HRMS, GL modules.
• Worked on Production support for bug fixes/defects, enhancements, performance tuning for reports, custom processes, fast formulas, workflows, forms across Financial modules, Oracle Projects, SCM and HRMS/Payroll modules.

Confidential, Houston, TX

Responsibilities:

• Involved in the design, development of a global multi-org/multi-currency HRMS/Payroll/OAB, OTL, Projects, AP, PO, iProcurement.
• Developed custom process for payroll reconciliation reports (SOE & Wage Elements) and customized custom Leave of Absence functionality.
• Worked on custom interfaces for extracting/transmitting employee data for different Benefit plans (834) to TPAs for employee medical/dental/vision/pharmacy cards/401k benefits data.
• Worked on custom overtime explosion process for automatic creation of element entries from Batch Elements created from OTL Timekeeper.
• Designed programs to upload time from Time force to OTL data conversion including time and attributes for OTL module.
• Developed Payroll fast formulas for PTO accruals, 401k rules, Sick/Vacation rules, local taxes.
• Customized both Benefits Confirmation and Summary Statements (XML based Self Service version, Oracle 6i version) for OAB.
• Worked on custom processes for transferring Bi-Weekly/Semi-Monthly Payroll to Projects data Interfaces, Recurring elements interface, Payroll to GL/Projects Accrual Interfaces.
• Worked on custom process to upload/import marine vessel requisitions data into Oracle PO, exporting created PO’s to a third party system.
• Implemented Punchout functionality in Oracle iProcurement to Supplier hosted catalog (cXML).
• Developed XML check templates for vendor payment checks and supported Evergreen check printing process for Payroll checks.
• Developed custom programs for Confidential and Positive Pay files for Singapore/Australia banks.
• Developed Forms 6i/Self Service Form Personalizations for HRMS/iProcurement/Finance.
• Worked on modifications to Projects Commitments View, Auto-Accounting, Burden scheduling.

Developed custom Confidential payment format and file transfer program from UNIX to DOS.

• Developed custom discoverer reports, Oracle 6i reports for HR/Payroll/Benefits, Projects, GL Costing Detail Reports, AP, AR modules.

Confidential, Houston, TX

Responsibilities:

• Involved in the design, development, implementation, support of a global multi-org/multi-currency HRMS/Payroll, Payables, Receivables, General Ledger, Projects, Advanced Benefits and Enterprise Upstream (v11.5.10.2)
• Developed a custom payroll report template/process for offshore employees and a custom PL/SQL routine to mass submit/email the payroll.
• Implemented XML Bursting technology to automate the emails for Remittance Advices to the vendors, business group specific Pay cheques.
• Customized the RX: Financial Register (AR) using Reports Exchange Designer functionality.
• Customized the seeded AR Invoice template using Bills Presentment Architecture.
• Developed/Customized several reports in Discoverer 10g, Oracle 6i, XML Publisher for Financials & Enterprise Upstream JVA.

Confidential, Houston, TX

Responsibilities:

• Involved in the design, development, implementation, support of a multi-org Payables, Purchasing, Fixed Assets, Enterprise Upstream.
• Implemented Discoverer reporting tool (Administrator/Plus/Viewer) for the entire organization using Discoverer 10g. Developed several reports for each module including replacing Oracle Reports 6i wherever feasible and conducted end-user on the tool.
• Developed custom PO Template using XML Publisher to support the new OFA based functionality and customized the standard PO Template.
• Customized PO Approval Workflow for notification display options, approval action history, approval positional hierarchy and limits.

Confidential, Tulsa, OK

Responsibilities:

• Involved in the design, development, implementation, support, re-engineering of a multi-org HRMS/Payroll, Oracle Projects, Fixed Assets
• Involved in 11i upgrade/support (v11.0.3 to 11.5.10) for Oracle HRMS, Oracle Payroll, Oracle Projects, Fixed Assets and General Ledger.
• Developed custom process for employee setup/payroll upload using Oracle HRMS API’s.
• Developed custom process for Salary Increases upload, Special Information Types upload using Oracle HRMS API’s.
• Developed custom HRMS/Payroll, Project Costing and Fixed Assets reports using Discoverer/Discoverer Plus/Discoverer Desktop versions.

Confidential, Plano, TX

Team Lead

Responsibilities:

• Worked on the impact analysis, design, development of Workflows, Data Extracts/Interfaces, Forms, Reports for HR, PA, FA, Vertex.
• Worked on enhancing custom Employee Load/Interface program with HR API calls.
• Customized FA Account Generator Workflow, client extensions, bug fixes and providing technical support for UAT testing.