PROFESSIONAL SUMMARY:

• 7+ years of extensive experience in the implementation, upgrade and customization of Oracle e - Business Suite Applications. This includes system study, design, development, post implementation maintenance and support of Oracle EBS
• Proficient in all phases of Oracle Applications implementation with major focus in the domain of Distribution and Financial modules within Oracle Applications EBS (Inventory INV, Order Management OM, Accounts Receivable AR, Purchasing PO, Accounts Payable AP, General Ledger GL and cash management CM)
• Expertise in the entire Oracle Implementation Cycle i.e. Baseline & Requirements Analysis, Solution Design, System Configuration & Set-ups, Data Migration, Testing, Trouble Shooting, Implementation, Roll Out, User and Post Implementation support
• Strong knowledge of business flows like Order-to-Cash (OTC) and Procure-to-Pay (P2P) life cycles along with the integration between various Oracle Applications modules and with very good understanding of Software Development Life Cycle (SDLC)
• Good understanding of business process operations, organizational assessment and translating them into functional requirements
• Good experience in providing user after the acceptance of the application
• Expertise in implementing the projects and performing thorough testing during the User Acceptance phase of the project
• Technically proficient in RICE (Reports, Interfaces, Conversions, Extensions) components including Implementation, Interfacing, Data Migration and Data Conversion
• Familiar with preparing documentation viz., MD-70, CV-60 etc. as per AIM methodology
• Expertise in developing custom programs using Oracle Open Interfaces, APIs and Unix Shell Scripting
• Experience working with Multi Organization Access Control (MOAC) architecture and its impact on Custom Program Development. Good knowledge of Ledger and Sub Ledger Accounting (SLA)
• Knowledge and Experience of TCA (Trading Community Architecture) and related Interfaces and APIs
• Experienced in developing/customizing PL/SQL Packages, Procedures, Functions and Triggers
• Well versed with client server environment and tools like Oracle Reports, Oracle Forms, XML/BI Publisher and Discoverer
• Experienced in Developing/Customizing Workflows to automate business events
• Experience in Form Personalization and customization to establish custom actions to be performed by forms during run time
• Extensive experience in registering Concurrent Programs, Forms, Value Sets, Flex Fields, Messages using Application Object Library (AOL) and also working on Sys Admin activities
• Strong experience in Performance tuning of applications using built-in Oracle utilities like Explain Plan, SQL Trace, Bulk Binding, and Optimizer hints etc.
• Expertise in using migration and version control software KINTANA, VSS and Clear Case
• In addition to excellent technical abilities, possess strong communications skills, analytical and interpersonal skills

TECHNICAL SKILLS:

Oracle Apps Modules: Accounts Receivable AR, Purchasing PO, Accounts Payable AP, General Ledger GL and Cash Management CM, Inventory INV, Order Management OM (EBS 11i, R12)

Languages: SQL, PL/SQL

Database: Oracle 9i, 10g, 11i

Operating Systems: Sun Solaris, Unix, Windows XP/NT, Linux

Tools: SQL *Loader, Oracle XML Publisher, Oracle Developer Suite (Forms 6i & Reports 6i), Oracle Discoverer, TOAD, PL/SQL Developer, Data Loader, Win SCP, MS Projects, Adobe Acrobat, MS Office, MS Excel, MS Visio Enterprise, Workflow Builder

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Oracle Apps Technical Consultant

Responsibilities:

• Modified PL/SQL Packages, Procedures, and Functions for data population and updating data as per the user requirements.
• Built interface to import Closed orders from legacy system into Oracle during the conversion process
• Responsible for customizing the Oracle seeded Line Workflow to meet the requirements.
• Developed the Order Import Interface using process order API to interface orders in real time from other external systems.
• Build code to place the orders on hold while creating them if they fall into a certain criteria.
• Developed code to reprice the orders if they are more than 15 days old.
• Responsible for cancelling the orders if they are not shipped for more than 30 days.
• Built a custom 850 EDI Order Inbound process to follow the custom rules and validations while creating orders into Oracle.
• Developed and customized complex XML Publisher reports by communicating and interpreting end-user business requirements in Inventory and Order Management.
• Customized and developed various reports in AR, AP, GL, PO, OM modules using Reports 9i and Oracle BI Publisher.
• Responsible for developing custom PL/SQL wrappers for fixing the data issues for support team.
• Responsible for Migration of custom reports from Release 11i to Release 12.
• Personalized PO creation screen as per user requirements to prepopulate certain fields and do validation on some others.
• Created technical documents MD070’s and unit test documents (TE020’s) before migrating a component to QA and higher instances.

Environment: Oracle Applications Release 11i, R12 (GL, AP, AR, PO, OM), Oracle 11i, Oracle Workflows, Oracle BI Publisher, Reports 9i, PL/SQL.

Confidential

Oracle Apps Developer

Responsibilities:

• Involved in preparing Technical design (MD70) documents and Conversion Mapping Document (CV40) during designing phase.
• Interacted with end users to gather requirements and draft specifications during development Phase.
• Designed and developed Custom Reports in AR.
• Coding, Testing of the technical components to meet the functional requirements
• Responsible for developing XML Publisher reports based on the modules like Purchasing, General Ledger and Payables.
• Developed PL/SQL Programs/ Packages for Customer Conversion.
• Developed interface programs as PL/SQL packages, procedures and functions to validate the invoice and payment data for AR, GL, OM and INV modules.
• Developed PL/SQL script to Import Customer Invoices into Invoice Interface tables and imported into base tables using Auto Invoice Import Program. Created invoices in AR using Auto Invoice Import program.
• Created technical design for item conversion. Used standard Inventory Application Program Interfaces supplied by Oracle.
• Responsible for developing Oracle Discoverer reports based on the modules like Purchasing, General Ledger and Receivables.
• Involved in requirements gathering and testing (Unit, Mock, Pre Production).
• Interacted with business users to resolve any issues during the development, mock testing, and Pre Production testing and production phase.
• Responsible for monitoring the SR’s.
• Responsible for providing resolutions for the issues encountered during the migration and post go-live.
• Responsible for direct interaction with the clients and prepared all the documents as per the Client Standards.

Environment: Oracle Applications Release12.1.2 (GL, AP, AR, CM), Oracle 11i, Oracle XML Publisher, Oracle Discoverer, Oracle workflows

Confidential, Newark, CA

Oracle Apps Technical Consultant

Responsibilities:

• Involved in conversion/interface programs to validate and to load data from staging table to interface tables related to Order to Cash Cycle.
• Imported order information from legacy system to OM base tables using SQL * Loader with API’s and Interface Programs.
• Involved in importing Customers from legacy system to Oracle base tables using SQL * Loader and Customer Conversion interface.
• By using SQL * Loader program the data from third party source was moved to base tables with the help of staging tables and also API’s.
• Expertise in using UTL FILE Package in moving data from legacy system to Oracle Base tables.
• Developed and customized forms as per business requirements in Order Management and Account Receivables using Forms 6i.
• Worked on workflows in doing customizations in sending Message notifications.
• Responsible for creating concurrent program Scheduling mechanism.
• Custom report development & modified to existing ones in different modules.
• Designed and developed Pick Slip Labels report, Packing slip Labels report according to the requirement.
• Having a good knowledge on oracle e-business suit EBS.
• Developed and customized Reports as per business requirements in Accounts Receivables, Order Management using Repots 6i and XML publisher
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM)
• Extensively worked on Discoverer Admin and Discoverer Client Machine in generating reports as per the requirement.

Environment: Oracle Applications 11i (GL, AR,OM, INV), Windows, Unix, Window NT, Oracle 10g/11i, Reports 9i, Forms 9i, Discoverer 10g, TOAD, SQL*Loader, PL/SQL, SQL* Plus and XML publisher .

Confidential

Technical Consultant

Responsibilities:

• Responsibilities include preparation of technical specifications from the functional specifications received from the functional team or user, technical design, development of program and unit testing and Interaction with the Client to resolve the Issues.
• Involved in Documentation of Archiving and Purging for different modules.
• Developed Oracle Alerts for the newly added Customers.
• Involved in Customizing and testing of Packages.
• Involved in Concurrent Program Registration and Manual creation of Lookups.
• Also responsible for system integrity testing and user acceptance testing before final migration of the programs to the PROD instance
• Prepared all the documents as per the Client defined methods for all assigned project tasks and met the timeliness of the project in all phases.

Environment: Oracle Applications 11i (GL, AR, AP, PO), Oracle Reports 6i.

Confidential, Houston, TX

Technical Consultant

Responsibilities:

• Requirements gathering from key-users and building of specification documents
• Design of overall interface strategy
• Design of interfaces, reports and custom processes
• The work also included estimating and reviewing the effort required to develop the module/Change Requests
• Responsible for writing MD70
• Design and development of reports using Oracle Reports 6i and Oracle BI Publisher
• Unit testing and System Acceptance testing of the components
• Responsible for conducting UAT sessions
• Responsible for users and the staff of University’s IT department
• Responsible for KT of the system to support handover group
• Internal Quality Checking of developed code and documents

Environment: Oracle 11i (11.5.10) Financials, PL/SQL, Oracle Forms & Reports, Oracle BI Publisher (XML Publisher), PL/SQL Developer

Confidential

PL/SQL Developer

Responsibilities:

• Requirement Analysis and Implementing Change Requests
• Interaction with onsite team for requirements gathering
• Preparing Technical Design Document and Migration Instructions
• Unit test plan and unit test results document preparation
• AOL registration of components using application developer
• Handling 2nd line support calls (Resolving Production Issues raised by Business Users)
• Setting up of Custom Profiles, Menus, Responsibilities, and Concurrent Programs
• Technical support during UAT phase and post production support for the issues encountered RICE components
• System Testing and Test Plan preparation as part of system testing for migration Oracle Apps 11.5.9 to 11.5.10

Environment: Oracle 11i (11.5.9) Financial Modules, Oracle 9i SQL & PL/SQL, Oracle Discoverer 4, Oracle Reports6i, PL/SQL Developer