SUMMARY:

• Oracle E - Business Suite expert with strong Technical and Functional experience with around
• 9 years in System Analysis & Design, Development, Deployment, Migration, Customization, Implementations and Production support of Enterprise Applications.
• Expertise in PL/SQL programming, Oracle Forms10g, Oracle Reports10g and Discoverer Reports.
• Extensively worked in XML Publisher and BI Publisher reports.
• Expertise in Procure to pay and Order to Cash Life cycles.
• Expertise with Tools like Oracle Reports 10g, Discoverer Desktop and Discoverer Administrator, SQL Developer, Toad, SQL*Plus.
• Expertise in Modules like Order Management, HRMS, Account Payables, Account Receivables, Purchase Order, Install Base, Service Contracts, Supply Chain Management and General Ledger.
• Worked in Oracle APEX which is a web-based reporting tool where users can select the fields and filter them based on the data available in data base.
• Extensively Worked in Oracle BPEL, Mediator, OAF and OSB.
• Extensive experience in developing Interface/conversion programs to import data from legacy systems to Oracle Applications using PL/SQL, SQL Loader and UTL Files.
• Installing Oracle SOA Server 11g in Windows/Linux Environment.
• SOA Application Packaging and deployment experience using Ant Scripts and Config plans.
• Extensively worked on version control systems like Tortoise and SVN.
• Experience in developing Test plans and Test case scenarios.
• Excellent Analytical & Communication Skills

TECHNICAL SKILLS

Oracle Applications: PL/SQL, SQL, Reports 6i/10g, Forms 6i/10g, XML Publisher, Discoverer Reports.

Oracle SOA: BPEL, Mediator, Human Task, Oracle Business Rules - 11g, OSB, Enterprise Manager, Human Workflow Task

Adapters: File Adapter, DB Adapter, MQ Adapter, FTP Adapter

Database: Oracle R12/11i/10g/9i/8i

Tools: & Others SQL Developer, Oracle Reports 10g/6i, Oracle Forms 10g/6i, BI Publisher, JDeveloper

Source Control: ADE

Operating Systems: Linux, Windows

PROFESSIONAL EXPERIENCE

Oracle Apps Technical Consultant

Confidential, Sacramento, CA

Environment: Oracle E-Business Suite R12, Oracle 12.2.2, SQL, PL/SQL, BI Publisher, Oracle Forms10g, Oracle Reports10g, Discoverer Reports

Responsibilities:

• Worked on developing Oracle INBOUND and OUTBOUND Interfaces to poll data from other legacy systems to SPI.
• Worked on developing Oracle Reports, Oracle forms
• Developed MD50 and MD70 Documents
• Customized Discoverer Reports and Oracle BI Publisher Reports

Oracle Apps Technical Consultant

Confidential, Emeryville, CA

Environment: Oracle E-Business Suite R12, Oracle 12.2.2, SQL, PL/SQL, BI Publisher, Oracle Forms10g, Oracle Reports10g, Discoverer Reports, BPEL

Responsibilities:

• Worked on 11i to R12 upgrade project and developed BI Publisher Reports, Oracle Reports, Plsql procedures, SQL Reports, Conversions and Custom Alerts.
• Worked on Oracle Order Management, HRMS, Account Receivables, Account Payables, General Ledger.
• Developed complicated Plsql packages and procedures to migrate the data from 11i to R12

Oracle Apps Technical Consultant

Confidential, Orrville, OH

Environment: Oracle E-Business Suite R12, Oracle 12.1.3, SQL, PL/SQL, BI Publisher, Oracle Forms10g, Oracle Reports10g, Discoverer Reports

Responsibilities:

• Developed BI Publisher reports for Warehouse detailed statements, Detailed statements on transport using Oracle E-Business Suite R12
• Developed complicated Plsql packages and procedures to eliminate the old data in the production data base.
• Developed Oracle Forms10g for the Warehouse tables.
• Worked in Development and Modification of Discoverer Reports.
• Created new menu’s and groups for the new responsibilities.
• Have worked in Inventory, Account Payables and Account Receivables Modules.

Oracle Apps Technical Consultant

Confidential, Livermore, CA

Environment: Oracle E-Business Suite R12, Oracle APEX, Oracle 12.1.3, SQL, PL/SQL, BI Publisher, Oracle Reports 10g

Responsibilities:

• Requirements gathering to understand intended business process flow.
• Developed BI Publisher reports for Rental Statements, Invoice Statements
• Developed reports using sql and plsql
• Have worked in Order Management, HRMS, Account Receivables, Account Payables and Inventory Modules.
• Creating Concurrent Programs, Value Sets required for the plsql reports.
• Migration of the BI Publisher and Plsql reports to other environments.

Confidential

Oracle Apps Development Lead

Environment: SQL, PL/SQL, Oracle E-Business Suite, Oracle 11g, Oracle SOA Suite 11g, Oracle Reports 10g, Oracle Forms 10g, BI Publisher

Responsibilities:

• Requirements gathering to understand intended business process flow.
• Analyzing the requirements related to order placing, dispatching, etc.
• Encoding the various medical enquiries sent by different source systems.
• Have worked in Order Management, Account Receivables and Inventory Modules.
• Have worked extensively in Oracle Reports, Oracle BI Publisher and Discoverer Reports.
• Checking whether the drugs are dispatched to the doctors.
• Working as Team-lead and responsible for allocating tasks to the team members

Oracle Apps/SOA Technical Developer

Confidential

Environment: Oracle SOA Suite 11g, BPEL, OSB, ADF, Mediator, JDeveloper, Weblogic, SQL, PL/SQL, Oracle 11g,Oracle OAF

Responsibilities:

• Requirements gathering to understand intended business process flow.
• Extensively worked in Order Management, Purchase Order, Account Payables, Inventory modules in E-Business Suite.
• Integrating Oracle Transport Management with Oracle E-Business Suite using BPEL Process.
• Designed and developed the solution by utilizing BPEL and ESB used for web service interaction and integration with application.
• Provided Unit Testing for the solution before delivery.
• Define solution approach-Identify key activities and set milestones.
• Research and proof Of Concept on domain solutions and innovative business processes.

Confidential

Oracle Apps Developer

Environment: XML Publisher, BI Publisher, Oracle Reports 10g,Discoverer Reports,PL/SQL, SQL, Oracle E-Business Suite R12i

Responsibilities:

• Designed and Developed procedures and packages for Customization of Oracle CRM Application.
• Designed Technical Design documents
• Extensively worked in Order Management, Account Receivables, Account Payables and Shipping Modules and Supply Chain Mgmt.
• Developed Critical BI Publisher and XML Publisher Reports
• Have Implemented XML Publisher report busting successfully
• Created Procedures and Invoice Reports for Financial Modules (Account Payables, Account Receivables and General Ledger).

Confidential

Oracle Apps Developer

Environment: Oracle SQL, PL/SQL, Oracle forms10g/6i, Oracle Reports 10g/6i, XML Publisher, Discoverer Reports, OAF

Responsibilities:

• Developer and Configuration Team Lead.
• Designed and Developed Reports, Forms and XML Publisher reports based on the client requirements.
• Extensively worked in Form Personalization.
• Extensively worked in Order Management, Account Payables, Account Receivables, Purchase Order and General Ledger Modules.
• Migration of Interfaces from 11.5.9 to 11.5.10 and creation of additional new faces.
• Developed Plsql Interfaces which are used to automate the Month End Activities.
• Worked in Period Close Activities in General Ledger.

Oracle Apps Developer

Confidential

Environment: Oracle SQL, PL/SQL, Oracle forms10g/6i, Oracle Reports 10g/6i, Discoverer Reports

Responsibilities:

• Registration of AOL Objects.
• Creation of Concurrent Programs and Value Sets.
• Coding involved loading of data from flat files into database and consolidation of data into single source and usage of Forms 6i to display the data to user.
• Development of Reports 6i, Forms and XML Publisher Reports based on the clients requirements.
• Extensively Worked in Purchase Order, Account Payables for understanding the business flow.