We provide IT Staff Augmentation Services!

Oracle Apps Technical Consultant Resume

Alpharetta, GA

SUMMARY:

  • Over 9 plus years of Upgrade, Implementation and Support experience in Oracle e - Business suite with technical and functional proficiency in Finance and SCM Modules.
  • Experience into Oracle Applications 11i, Release 12 (R12) as a Technical Consultant.
  • Strong Knowledge in SQL and PL/SQL (Cursors, Procedures, Functions, Packages).
  • Writing SQL*Loader Scripts (Control Files) for transferring for data from Legacy System to Oracle Apps.
  • Experienced in developing RICE (Reports, Interfaces, Customizations and Extensions) Components.
  • Expertise in SCM Modules (INV, OM, PO, AP, AR) in Oracle Applications.
  • Worked on XML Publisher Reports and having knowledge on BI Publisher.
  • Strong techno-functional expertise in Procure to Pay (P2P) and Order to Cash (O2C) business processes.
  • Configuration and Maintenance of core EBS foundation technologies and Oracle R12 Financial modules like Accounts Payable (AP), Accounts Receivables (AR), General Ledger (GL), expense, Application Object Library (AOL) and Concurrent Manager.
  • Design high level custom solutions using Forms, Reports, PL/SQL, Advanced PL/SQL, Workflow, BI Publisher reports and Oracle Applications Framework.
  • Prepare Technical Design Document (MD070), Functional Design Document (MD050), Conversion Document (CV060), Technical Test Document (MD0120) and Set up document (BR100).
  • Design and Delivery of Reports, Interfaces, Conversions and Enhancements (RICE components) using third party tools like PL/SQL Developer, TOAD, SQL Navigator, SQL Developer and SVN (Source Version Control).
  • Worked extensively on various Technical aspects including development/customization and production support activities in Oracle applications environment.
  • Hands-on involvement in business requirement, GAP analysis, process mapping, solution analysis, development, source control and deployment.
  • Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
  • Expertise on designing and implementing Oracle Alerts and Lookups.
  • Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.

TECHNICAL SKILLS:

Domain: Oracle Applications finance modules like Account Receivables (AR), Account Payables (AP), General Ledger (GL) and Sub Ledger Accounting (SLA) and SCM modules like Purchasing (PO) and Procurement Contracts (OKC)

Technical: SQL, PL/SQL, UNIX Shell Scripting, Basics of Java, Oracle Apps Techno Functional, Oracle Forms and Reports, BI Publisher Reports, Oracle Applications Framework (OAF), Oracle Workflow

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Oracle Apps Technical Consultant

Environment: Oracle Apps R12

Responsibilities:

  • Requirements gathering the from the Client with most of the details based on the RITM requests.
  • Requirement Analysis and coming up with the approach for the requirement.
  • Participating in Daily Stand Up and Weekly status meetings to keep track of the tasks (JIRA Stories).
  • Code Review / Functionality and getting the Signoff from the Business.
  • Code Backup and Migration to SVN and handling Deployments.
  • Communicating with Offshore about the requirements and progress.
  • Working with Oracle and other Vendors to resolve the issues Bug / Code fixes based on Service Requests.
  • Trouble shooting and Debugging the Production issues (Incident tickets).
  • Concur Expense Interface to transform the standard Concur file to 1185 format.
  • Automate DRS process to extract open checks on the 1st of every month
  • Designed and developed Supplier Change History Report (Address, Payment, Banking Info., Tax Info., Supplier details)
  • Generating the PO pdf from Oracle Apex to Oracle EBS
  • Created Custom FA Reports Master Chain through AM9 - Appworx.
  • Developed GL - TRECS detail Outbound Extract
  • Developed Auto-Final Close POs program using PO ACTIONS API
  • Custom Contract Details Report - XML report
  • Custom Journal Workflow Approval Report
  • Custom Cost Adjustment Report
  • Custom Asset Addition Report
  • Custom Asset Retirements Report
  • Custom Reclassification report
  • Custom Asset Register report
  • Developed Balance Transfer Transformation Process
  • Cyber Grants DRS Outbound Extract
  • Documented the Wave Migration processes of Wave 12 (Migration of CCCS), Wave 13 (Migration of GECOM, WAUSAU), Wave 14 (TRECS Application)
  • Developed Supplier Change History Report
  • Developed Payment Details Report
  • Developed Flex Values Audit Report.
  • Developed GL DAILY RATES Interface
  • Developed DRS Manual Checks report (with Card holder and account details).
  • Form personalization to auto populate the location details in FA Mass additions form.
  • Form personalization to auto populate the attachment details from invoice to the FA Mass Additions process.
  • Developed the Oracle BTP Apex Lifecycle View Application with Requisition, PO, Invoice, information.
  • Developed the DRS - Draft Reconciliation system Application in Apex.

Confidential

Software Engineer

Responsibilities:

  • Responsible for production support activities.
  • Migration of financial data from Legacy System to Oracle with the help of custom conversion and interface programs.
  • Development of custom PL/SQL reports as per the business requirement.
  • Working on code enhancements for prevention of different fallouts in the ordering system.
  • Worked as a Team Member in Analyzing / understanding the existing code and estimating the time and effort for the required changes.
  • Modifying the code to accommodate the latest requirements. Testing the modified programs for the requested functionality.
  • Preparing the documentation (High Level Design, Detail Design Document, Unit Testing, Code Migration) the deliverables.
  • Delivering the code and related documents.
  • Testing and code review the other Consultant Objects after completion of the object.
  • Requirement Analysis and coming up with the approach for the requirement.
  • Participating in Weekly status meetings to provide updates of the assigned tasks.
  • Preparing the AIM documentation based on the deliverable (MD70, MD120).
  • Code Review / Functionality and getting the Signoff from the Business.
  • Working with Oracle and other Vendors to resolve the issues Bug / Code fixes based on Service Requests.
  • Trouble shooting and Debugging the code.

Hire Now