We provide IT Staff Augmentation Services!

Oracle Applications Analyst Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • 9 years of extensive experience in delivering end - to-end solutions as an Oracle Application Technical Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12, 11i).
  • Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), BOM, Cash Management(CM),Fixed Assets(FA), IProcurement.
  • Expertise in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
  • Expert in Oracle Application Framework (OAF) applications, customization of OAF pages, extensions and creation of new OAF pages in JDeveloper 9i and 10g environment.
  • 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.

TECHNICAL SKILLS:

ERP: Oracle Applications 11i,R12.1.3,R12.2.4

Modules: Oracle Payables (AP),Oracle Receivables (AR),Oracle General Ledger (GL),Oracle Cash Management(CM),Order Management (OM),Oracle Purchasing (PO),iProcurement, Project Costing

Platforms: Unix (Solaris, Oracle 10g/9i/8i), Windows (All Flavors)

Languages: SQL, PL/SQL,Java,BPEL,XML,Macros

GUI Tools: Forms & Reports Builder, XML Publisher, JDeveloper 9i&10GWorkflow Builder, Winscp, Putty

Tools: SQL*plus, PL/SQL developer & Toad,Panaya

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Applications Analyst

Responsibilities:

  • Preparing Design and Unit Test documents with the AIM standards.
  • Preparing functional design documents and convert them to technical design with Minimal possible customization.
  • Writing the PLSQL code with the best possible performance tuning.
  • Worked on Isupplier OAF Workflow Notifications integration process with MyNabors Portal
  • Worked on EDI invoice import process
  • Worked on OAF customizations as per user requirements.
  • Workflow customizations to support AME approval process
  • Preparing Procure-to- pay (PTP), Order-to- cash (OTC) business flows.
  • Providing the production support on all aspects of the Oracle Financials Applications
  • Ability to diagnose and solve system problems while working under pressure to
  • Meet aggressive deadlines in a limited resources environment.
  • Delivering the end-to- end solution for support problems and development tasks including Identifying the issue, configuration, development and testing.
  • Effectively providing the Oracle Support to resolve Service Request (SR) issues.
  • Understanding the custom application environments and business
  • Processes and integration around the custom applications with Oracle Financials Applications to take ownership of solutions.

Confidential

Technical Analyst

Responsibilities:

  • Interacted with End users to understand the business requirements.
  • Prepared the required application design documents based on functionality requirements.
  • Involved in designing the dimensional model (logical and physical) data model in existing architecture
  • Experience in leading a team of people (Onsite and offshore) during the Project life cycle.
  • Developed the PL/SQL procedures, functions and cursors for the data extraction.
  • Developed the reconciliation jobs to match the record counts in source system with the target data.
  • Developed the XML Reports as per the user requirement.
  • Environment: Oracle Applications 11.5.10, Oracle 9i, Oracle Reports 6i, XML Publisher, JDeveloper, Workflow Builder

Confidential

Oracle Applications Analyst

Responsibilities:

  • Goal is to implement a fully tested and certified integration solution between OHI-Claims and Oracle EBS to manage all accounting and financial-related transactions resulting from the processing of claim information in the new architecture, including the payment of claims.This Project will handle the downstream processes associated with claim payment specific functions and will maintain the financial and audit controls associated with the processing of payment information as required to comply with data traceability, reporting and drill-back requirements.
  • Working extensively on OAF Personalization’s, VO &CO extensions.
  • Developing custom PL/SQL Packages for AP and CM Modules to achieve custom functionality.
  • Developing XML Reports as per Client requirements using the XML& publisher reports including bursting.
  • Performing application support in single and multi-org environment for Oracle Financials (Purchasing (PO), Accounts Payables (AP), iExpense and iProcurement modules).
  • Developing Interfaces and Interface program to import Supplier information to Oracle, & developing Interface program to import fitness invoices to Payables.
  • Using Oracle APIsto insert and update data in Oracle Applications.
  • Requirement analysis, design and develop custom applications.
  • Developing various custom workflow processes like sponsor creation.
  • Preparation of MD 70, MD120, BR100 and MD50.
  • Alert creation to notify business users with PO Expire details.
  • Createdform personalization in Account Payables.
  • Creating values sets, executable, concurrent programs, & form functions.
  • Environment: Oracle Applications 11.5.10, Oracle 9i, Oracle Reports 6i, XML Publisher, JDeveloper 9i, Workflow Builder
  • Prepared MD-50 documentsfor the various reports and interfaces, which include PO Expiry Notification Report, Statements and APinvoice Interface.
  • Responsible for Fit-Gap Analysis, CRP1, Requirements Gathering, CRP2 and CRP3 Sessions.
  • Configured iProcurement, Inventory Purchasing and AME in the upgraded R12.2.4 Instance
  • Charge Account Generation Workflow Customization.
  • Implemented iProcurement for various business units which are currently using Lotus Notes SAF (Spend Authorization Form) to Create Requisitions.
  • Prepared and Maintained BR100, MD050 and TE040 Documents.
  • System Integration Testing Cycles.
  • Coordinated and supported the business users during User Acceptance Testing cycles.
  • Monitored the auto reconciliation process andupdated the bank Statement manually.

Environment: Oracle Applications R12.2.4,Panaya, Oracle 10g, Oracle Reports 6i, XML Publisher, JDeveloper 10g, Workflow Builder.

Confidential

Oracle Applications Analyst

Responsibilities:

  • Development of reports as per client requirement using the XML Publisher Reports.
  • Development of Interfaces as per client requirement.
  • Worked on Item update interface, UOM conversion factors interface, &item on-hand balances conversion.
  • Developed the report for asset depreciation by project report.
  • Preparation of MD 70, MD120, and BR100 as required.
  • Personalized GL Import form to default values.
  • Involved in GL Functional Testing and preparing test scripts.
  • Creation of Values Sets, Executable for the objects in the Application.
  • Developed and customized various reports in different Modules using Oracle Reports10g.
  • Developed Reports as per Client requirement using the XML Publisher Reports.
  • Developed asset conversion interface per client requirements.
  • Developed supplier conversion and the Interface to import timesheets from change pointreports.
  • Developed the report for Asset depreciation by Project Report.
  • Preparation of MD 70, MD120, and BR100 as required.
  • Creation of Values Sets, Executable for the objects in the Application.
  • Development and customization of various reports in different Modules using oracle reports10g.

Environment: Oracle Applications 11.5.10, Oracle 9i, Oracle Reports 6i, XML Publisher.

Confidential

Oracle Apps Techno-Functional Consultant

Responsibilities:

  • Developed finance Modules Custom Reports Using Reports6i.
  • Worked on Customer Account Generation Report Development.
  • Worked on Developing GL Daily Rates Interface Program.
  • Involved in GL Interface import Process where GL Data coming from different External sources like AS400, Spreadsheet etc.
  • Worked on customization of Forms according to the user requirements.
  • Provided active support during month/year end, Monitor and assign Oracle cases in issue tracking system and prioritize work.
  • End user support composed of advising and counseling system users on the interpretation of their data, system processes, and business processesEncompassed by the systems within scope.
  • Supported Users in running of any custom programs.
  • Worked in close coordination with other GERS support teams (Siebel, i550, Web Apps, BI) to resolve any issues.
  • Defined and Maintain All Set Ups like Memo Lines, Lockbox, and Auto Invoice etc.
  • Interfaced monitoring like Monitoring of bank receipts on a daily basis,Invoice rejections monitoring and error resolution on a daily basis.
  • Active support of monthly & quarterly close processes like open and close period, notify users of any unposted batches, truncate redundant data from interface tables etc.
  • Monitored Oracle Standard Interface Programs and work with business to resolve any issues.
  • User creation and responsibility assignment to user, request set creation,attaching concurrent programs to request group, Scheduling the concurrentprograms etc.

Environment: Oracle Applications 11.5.10, Oracle 9i, Oracle Forms 6i, Oracle Reports 6i

Oracle Apps Techno-Functional Consultant

Confidential

Responsibilities:

  • Developed Custom Reports PO,AP,GL Modules Using Report6i.
  • Creation of Value sets in various Modules of the application.
  • Defining Menu, functions, Reports, Concurrent Programs, Executables.
  • Resolved issues in custom packages and worked on Complex requirement related to PL/SQL and all modules (OM, PO, INV & AP).
  • Worked on Order to Cash cycle and resolved many technical production issues as a part of the production support team.

Environment: Oracle Applications 11.5.10, Oracle 9i, Oracle Forms 6i, Oracle Reports 6i

We'd love your feedback!