We provide IT Staff Augmentation Services!

Oracle Applications Technical Lead Consultant Resume

Cincinnati, OH

SUMMARY

  • Around 12 years’ experience in the analysis, design, development, testing and support of Oracle based applications.
  • Over 10 years of experience as Technical and Techno Functional Analyst in the Implementation, Upgrade and Support of Oracle ERP Applications (12.1.3, 12.1.2, 12.1.1, 12.0.6, 11.5.10 and 11.5.9).
  • Strong Application Implementation and Support experience in Financial, SCM, HRMS and CRM modules.
  • Experience with OTC (Order - to-cash) and PTP (Procure-to-pay) business process scenarios with 7 full cycle implementations, 2 Release 12 upgrade and 3 support projects.
  • Expert in Oracle Applications User Interface Customizations using Forms 6i (oracle 11i), 10g Forms (EBS Release 12), Forms Personalization’s, 9i JDeveloper (Oracle EBS 11i), 10g JDeveloper (EBS Release 12) and Oracle Applications Framework Personalization’s.
  • Extensive experience in writing SHELL Scripts for tasks Automation, Inbound and Outbound Processes.
  • Highly involved in Oracle AME/Workflow Customizations, Vertex TDM Integrations, Auto Lockbox Process, e-Commerce Gateway Process, EBS Check Printing, Creating and Customizing Oracle, Discoverer and XML Publisher reports.
  • Worked extensively using TOAD, SQL*Plus, SQL Developer, Workflow Builder and Sql*Loader.
  • Wide exposure on developing Technical design specifications and Setups for Conversions, Interfaces, User Interface Customizations and various other business requirements.
  • Well versed in Oracle AIM Methodology in creating Application extensions technical and functional documents MD070’s, MD050’s, TE020’s and Conversion Design Documents CV060’s.
  • Hands-on involvement in business requirement gathering, GAP analysis, data mapping, solution design, configuration and setups.
  • Extensive Experience in creation of TARs/SRs for Client issues, report bugs in EBS modules and working with Oracle Support to resolve issues with Oracle applications standard functionality.
  • Excellent overall project life cycle experience, Conceptual and Logical Thinking, Teamwork, Goal oriented.

TECHNICAL SKILLS

RDBMS: Oracle Database 11g, 10g, 9i, DB2.

Development Tools: Oracle Forms & Reports 10g/6i, JDeveloper 10g/9i, XML Publisher (BI Publisher) 5.6.3/5.6.2/10.1.3 , Workflow Builder 2.6/2.5, Discoverer 10g, Application Express 3.2, SQL * Plus, TOAD 9.1, SQL Developer 3.2 and SQL Loader

Programming Languages: SQL, PL/SQL, UNIX Shell, PERL and PYTHON Scripting, C, C# and JAVA

Scheduling Tools: $U

Version Control Tools: Star Team, Clearcase, SharePoint, TortoiseSVN and Visual Source Safe

Operating Systems: UNIX SUN OS 5.8, IBM AIX (64 Bit),, HPUX RISC (64 Bit), WINDOWS and MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Oracle Applications Technical Lead Consultant

Responsibilities:

  • Imported Standard Purchase Orders and Blanket Purchase Agreements using Oracle standard Interface programs.
  • Imported Contract Purchase Agreements and Blanket Releases into Oracle EBusiness using private API’s.
  • Performed Approved Supplier Lists conversion using Oracle API’s and imported Requisitions using Requisitions Import program.
  • Implemented Approvals Management Engine (AME) for Purchase Requisitions and Purchase Orders. Created required AME Attributes, Conditions, Approval Groups, Rules and Action Types.
  • Developed SQL queries to derive AME approval hierarchies for Purchase Orders and Purchase Requisitions.
  • Customized Purchase Requisition Approval Workflow as per Confidential requirements. Integrated OAF Notifications with Oracle Workflow.
  • Implemented FND File attachments functionality on iSupplier OA Framework pages.
  • Extended iProcurement OA Framework pages to default purchase order types into document builder region.
  • Extended Requisition notification pages to indicate requisition lines for approvers in an AME derived approval system.
  • Extended iProcurement OA Framework pages to show Blankets and Quotations based on User access profiles.
  • Performed OA framework personalization’s to set initial values, remove buttons, change prompt descriptions, mark attributes as required/read-only columns and display View Object Attributes.
  • Used iProcurement POR CUSTOM PKG package for defaulting of values and validating fields in requisition header/line/distribution lines.
  • Converted Account Payables Suppliers (Vendors), Supplier sites and Site Contacts using Supplier open Interfaces Import Programs.
  • Created new Parts Specification Forms using Forms 10g to capture and store Confidential information for processed products.
  • Customized BI Publisher Reports, PO output for Communication Report and Requisitions Report to include Confidential requirements.
  • Designed and developed EDI solutions to send Remittance Advice to suppliers through Oracle e-Commerce gateway.
  • Implemented Concurrent Requests multi-threading to import large volumes of data into Release 12.
  • Used 11g Database new feature, external table post processer scripts to show files in an operating system directory as ‘value set’ values.
  • Wrote Shell scripts to automate custom Application Object Library (AOL) components deployment process. Used FNDLOAD, WFLOAD, XDOLoader, Forms Compile, JPXImporter and XMLImporter as shell script components.

Environment: 12.1.3 Purchasing, iProcurement, iSupplier Portal, Sourcing, Oracle Approvals Management, Account Payables, TOAD 9.1, Workflow 2.6, 10g JDeveloper, BI Publisher 10.1.3, 10g Forms and Reports, EDI, Oracle e-Commerce Gateway .

Confidential

Techno Functional Consultant

Responsibilities:

  • Implemented Check Printing for Confidential developed Check templates needed for Huntington Bank. Configured Internal Banks, Payment and Printer setups needed for check printing.
  • Redeveloped oracle reports based AP electronic payment formats using XML Publisher e-text templates for R12 implementation.
  • Customized R12 Payment Process Request’s (PPRs) ‘Document Selection (Invoice Auto Select)’ phase programs to select Invoices based on custom table information.
  • Assisted Confidential to use PPR’s for payments processing in R12. Created Payments module Payment Process Profiles, Payment templates, Payment Formats and XML publisher formats needed for Confidential .
  • Implemented R12 Payments Separate Remittance Advice process for Confidential . Developed remittance advice templates, created xdo delivery configuration file, setup application messages and payment process profiles.
  • Implemented Payables Invoice Import process using interface programs for project related Invoices and Purchasing Invoices. Performed setups needs for Invoice Import.
  • Implemented Cash Management Bank Statements Import process for Confidential using Oracle interface programs. Performed setups for Transaction Codes and Mapping Rules.
  • Modified PO output for Communication Report to include Confidential changes and communicated PO’s automatically to Suppliers using the Purchase Order Window.
  • Modified R12 Printed Requisitions report and Original Invoice report to include custom Confidential changes.
  • Performed UMX Role Based Access Control (RBAC) setups to provide user access based on roles.
  • Performed Multi Org Access Control (MOAC) changes on required procure to pay and grants accounting wrapper programs.
  • Assisted Confidential in General Ledger, Sub ledger Accounting and Payables reconciliation process. Worked with Data Warehousing team to modify OLAP Processes for R12 upgrade.
  • Well versed in Sub ledger Accounting SLAM, AAD, Entity, Event Class, Event type, Journal Line Definition, ADR, JLT and JED’s.
  • Modified R12 Account Analysis report to provide account and accounting segment totals across multiple periods required by Confidential .
  • Created new subscriptions on Concurrent Program Business Events to automate file transfer process with external systems.
  • Extended Supplier OA framework pages to implement Confidential business requirements. Extended View Objects and Controller Classes.
  • Upgraded 6i Oracle forms and reports using 10g Developer Suite for R12 compatibility.

Environment: 12.1.3 Receivables, Payables, Payments, Purchasing, iexpenses, Sub Ledger Accounting, Fixed Assets, TOAD 9.1, Workflow 2.6, 10g JDeveloper, BI Publisher 10.1.3, 10g Forms and Reports.

Confidential, Pittsburgh, PA

Techno functional Analyst

Responsibilities:

  • Implemented Check Printing for Confidential using oracle XML Publisher. Developed CMU Check print template for BNY Mellon Bank, setup payment formats, payment process profiles and payment templates needed for check printing.
  • Redeveloped oracle reports based AP electronic payment formats using XML Publisher for R12 implementation.
  • Implemented R12 Positive Pay Process for Negotiable and Voided Checks. Developed customizations to process R12 voided checks and external system checks.
  • Implemented R12 Payments Separate Remittance Advice process for CMU. Developed remittance advice templates, created xdo delivery configuration file, setup application messages and payment process profiles.
  • Performed UMX Role Based Access Control (RBAC) setups to provide Concurrent Requests output file access to other users.
  • Performed MOAC changes on Cash Management Bank Statement Open Interface wrapper programs and Fixed Assets, Asset Import programs.
  • Modified CMU Employee Supplier Update program to include Release 12 changes.
  • Performed OAF personalization’s and extended GL Launch Budget Wizard OAF pages to include frozen budgets and display custom data. Implemented forms personalization’s on GL Journal screens.
  • Modified Purchase requisition Workflow notification pages as per Carnegie Mellon requirements.
  • Performed OAF personalization’s and implemented Oracle Applications Framework extensions on Buyers Workbench Purchase Order pages using 10g JDeveloper.
  • Upgraded 6i Oracle forms and reports using 10g Developer Suite for R12 compatibility.
  • Assisted CMU in General Ledger, Sub ledger Accounting and Payables reconciliation process.
  • Created programs to protect organization sensitive information in non-production instances.
  • Created new subscriptions on Concurrent Program Business Events to automate file transfer process with external systems.
  • Wrote Shell scripts to automate Application Object Library (AOL) components deployment process.

Environment: 12.1.3 Receivables, Payables, Payments, General Ledger, Purchasing, Sub Ledger Accounting, Grants Accounting, iexpenses, Fixed Assets, TOAD 9.1, Workflow 2.6, BI Publisher 10.1.3, 10g JDeveloper, 10g Forms and Reports.

Confidential, Chicago, IL

Techno Functional Consultant

Responsibilities:

  • Implemented Order Management Internal Orders process for Confidential .
  • Used Order Management Order line API’s to update Order Line information.
  • Created Order Management holds using API’s.
  • Imported OM Sales Orders from legacy systems into Oracle.
  • Imported AR credit memos using Oracle standard API’s. Used Receipts API’s to reverse Receivables receipts.
  • Customized Account Receivables Aging report as per client requirements.
  • Created custom business event subscriptions for standard Oracle TCA business events.
  • Created custom programs to identify unbalanced journal entries and create reverse journals to balance General Ledger Accounts.
  • Implemented Purchasing Position based Approval Hierarchy.
  • Imported Inventory Items, and Item categories using Oracle standard Interface programs.
  • Imported Item Costs and Inventory On hand Quantities from Legacy Systems.
  • Customized standard Oracle Auto Accounting package to populate accounts as per Confidential requirements. Well versed in month end closing procedures.
  • Designed and developed Inbound and Outbound Interfaces for transfer of AR Payments, Adjustments and credit memos with trading partners.
  • Performed Oracle Forms and Oracle Applications Framework personalization in Receivables, Purchasing, Payables, Telesales and Field Service modules.
  • Created Oracle on Demand RFC’s for Testing and Production code migration.
  • Created Request Sets, Concurrent Programs, Value Sets and Profile Options. Resolved performance tuning issues.

Environment: 11.5.10 Receivables, TCA, General Ledger, Fixed Assets, Order Management, Inventory, Advanced Pricing, Purchasing, Field Service, TOAD 9.1, Workflow 2.6, 9i JDeveloper, Forms and Reports 6i.

Confidential, Memphis, TN

Oracle Applications Techno Functional Analyst

Responsibilities:

  • Converted AR Receipts using Oracle Seeded API’s to apply at Invoice and Invoice line level.
  • Automated Lockbox Process to load daily payments received from external systems. Defined Lockboxes, Lockbox Transmission Formats, Control Files, Data Files, Receipt Classes, Receipt Sources, Banks.
  • Customer Conversion from CHEERS to Oracle AR using Trading Community Architecture (TCA) public APIs
  • Created the Mapping Documents to map the legacy Customer record fields to Oracle TCA Registry fields for Customer Conversion.
  • Redesigned and developed the Customer Interfaces to support Party Merge, Customer Account Merge, Party Relationships and Customer Account Relationships.
  • Created Commitments (Security Deposits) using Oracle Standard API’s.
  • Imported Adjustments and Disputes using API’s.
  • Imported Receivable Invoices using Auto Invoice Open Interfaces. Performed Auto Invoice setups, created Grouping Rules, Line Ordering Rules, Transaction Batch Sources, Transaction Types, Tax Codes for Asia Pacific and Canadian Operating Units.
  • Implemented MOAC concepts in all Custom Interfaces and Conversions.
  • Created new Oracle Forms to show receipt application line level details and FedEx Custom data. Added new DFF Flexfields to Oracle Forms.
  • Customized Receivable Forms. Performed Forms Personalization’s. Created new PL/SQL libraries (pll’s) to be used in various new Oracle Forms.
  • Implemented GL Monthly rates program for FedEx.
  • Created Cash Refund Extract Report, Receivables Extract and Customer Balances Report using XML Publisher.
  • Setting up Scoring Components, Scoring Engines, Work Items and Collections Strategies in Advanced Collections.
  • Involved in High Level Design and Detailed Design documents, Test Case and Test Data Documents, Migration Scripts and Implementation Plans.
  • Generating Trace files and TKPROFs and analyzing them to tune the performance of the conversions and interfaces.

Environment: R12 12.1.2 Receivables, Trading Community Architecture, General Ledger, Sub Ledger Accounting (SLA) and Advanced Collections, TOAD 9.01, Oracle 10g, SQL, 10g Forms, AIM 3.0, SQL *Loader, XML Publisher 5.6.

Hire Now