SUMMARY:

• 9.5+ years of experience in Oracle ERP Applications with expertise in requirements gathering, design, production support, conversion, implementation, upgrades, and day - to-day support.
• Expertise in Implementation and Support for Oracle-EBS projects in the functional & technical areas of Supply Chain Management (PO, OM) Manufacturing (INV, WIP, BOM, Pricing) Financials (AP, AR, GL) modules
• Strong functional knowledge on complete life cycle of P2P and O2C Cycles.
• Expertise of backend system using PL/SQL with relational databases such as Oracle 8i/9i
• Effective in the identification of problem areas, development of alternatives and implementation of creative business solutions.
• Understanding of ETL concepts and tools like Informatica
• Extensive experience in requirements gathering, analysis and understanding of As-Is and To-be model, documentation and high-level design
• Experience in preparing functional requirement document, high level design and test cases
• Experience in end-to-end testing of Oracle ERP technology (Oracle e-Business Suite Application).
• Experience in implementing RICE (Reports, Interface, Conversions and Extensions) components of Oracle Application Business objects
• Ability to work with clients (technical and business)
• Excellent documentation and communication skills, leadership, troubleshooting and interpersonal skills. Can handle responsibilities independently as well as a proactive team member.
• Ability to manage and deliver results on multiple tasks by effectively managing time and priority constraints.

TECHNICAL SKILLS:

Oracle Applications: Oracle E-Business Suite R12/11.x; GL, AP, AR, PO, OM, WIP, BOM, Quoting, INV, Advanced Pricing, AOL

Oracle Tools: Forms 10g/9i/6i, Reports 10g/9i/6i, Oracle Workflow Builder 2.6.3.5, Developer 2000, XMLPublisher

Oracle Platforms: OA Framework (OAF)

Languages: SQL, PL/SQL, C, C++, XML

RDBMS: Oracle 10g/9i/8i, SQL Server 6.5/7.0/2000

Tools: TOAD, Developer2000

Operating Systems: UNIX, Windows XP/NT/98/95, MS-DOS

Relevant Knowledge: System Development Life Cycle (SDLC), Systems Programming

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

Techno Functional Consultant

Roles & Responsibilities:

• Extensively worked on Purchase (PO),Order Management (OM) and Inventory (INV) modules
• Developed SQL scripts to migrate/convert customer, item master, open orders, open POs, requisition data from Oracle to SAP
• Created programs to get GL transaction details for period-to-date and year-to-date of Account Payables and Account Receivables
• Coordinated with business users to understand and implement new requirements through customizations, workarounds and form personalization
• Created programs using GL interface tables and import program to post entries in specific accounts
• Developed SQL script using standard API to modify PO line details
• Developed scripts and control files to load data from flat file into PO interface tables and create Blanket Purchase Agreements
• Testing and migrating the objects to the production instance
• Prepared UNIX Shell scripts for customized concurrent programs
• Developed programs to generate customized profit & loss and balance sheet statement
• Created value sets, lookup and descriptive flexfields for OM and Distribution modules
• Coordinated with business users for month end activities for AP
• Improved program execution time by tuning existing SQL scripts and procedures
• Created concurrent program to create custom requisitions using SQL procedure
• Prepared business requirement documents and test case documents for new implementations
• Analyzed the issues on Production System and resolved them

Environment: Oracle Apps R12, GL, AP, AR, PO, INV, OM, PL/SQL, Reports 10g, Forms.

Techno Functional Consultant

Roles & Responsibilities:

• Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement.
• Developed EDI 856 Inbound process to import the ASNs from suppliers. The process does custom validations and sends an 824 outbound process back to the suppliers in case of any failed validations. An included workflow component helps in deciding which shipments to reject.
• Requisition approval process has been customized using the custom functions at activity nodes on the standard workflow processes.
• Extensively worked on General Ledger (GL), Accounts Receivables (AR) and Accounts Payables (AP),Purchase (PO), Inventory(INV), Order Management (OM), while supporting O2C and P2P cycles.
• Develop Open Purchase Orders report that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.
• Developed GL/AP Interface Programs to import Journals data into Oracle EBS System
• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location.
• Defined, Created and Tested Flexfield structure, Cross Validation rules, Accounting Calendars, Functional currencies, foreign currencies and budget for QA testing.
• Experience in designing and executing test cases and test plans based on business requirements
• Experience in System Administration such as creating users, menus, assigning responsibilities, and adding forms and functions to menus.

Environment: Oracle Apps R12, CM, AR, PO, INV, OM, PL/SQL, Reports 10g, Workflow 2.6.3.

Techno Functional Consultant

Roles & Responsibilities:

• Involved in requirements gathering, analysis, development, QA and post-production support.
• Performed GAP analysis to ensure that the requirements are captured properly.
• Performed end to end testing of ATO configuration item orders.
• Understanding of the steps in Oracle Reports 6i creation, deployment and registration process through AOL and system administration.
• Planned and developed the data conversion methodology for Purchasing Order data interfaced to PO module.
• Designed and developed custom components on P2P, O2C, SCM modules
• Creating value set and assigning its values.
• Resolving Performance issues. Tuning of customized application including reports and backend customization by using different application tuning techniques like EXPLAIN PLAN, SQL*TRACE, TKPROF, HINTS
• Enabling Key Flexfield and Descriptive Flexfield.
• Worked with technical team to resolve / provide technical issues
• Experience in OM API's like order creation, order updating and pricing
• Testing various scenarios of Quote to Order cycle in Bill of Material and Order to Cash (O2C) cycle in Oracle Management.

Environment: Oracle Apps R12, AOL, AR, PO, INV, OM, PL/SQL, Reports 10g, Workflow 2.6.3.

Techno Functional Consultant

Roles & Responsibilities:

• As a Techno Functional consultant involved in creating multiple conversions to support client's migration from a legacy system to Oracle ERP suite of applications including GL and AR.
• Implemented a Custom AME rules to approve the Non-PO invoice based on RC or Supplier or Supplier site.
• Prepared Bank and Cash Reconciliation Reports and Other Financial Reconciliation and other standard reports
• Have setup Profile Options for Accounting Applications under General Ledger, iExpenses, Receivables and Cash Management for Implementation
• Setting up PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds, etc for Accounts Payable.
• Customizing & enhancements on Forms.
• Converted Oracle 6i Reports and SCM reports to BI publisher reports.
• Developed custom workflows for tracking service requests, and notifying users about the status of these service requests.
• Testing various scenarios of Procure to Pay (P2P) cycle.

Environment: Oracle Apps R12, GL, iExpenses, CM, AR, PO, PL/SQL, Reports 6i

Senior Associate Consultant

Roles & Responsibilities:

• Developed Sales order conversion using standard API.
• Developed Purchase order conversion using standard interface.
• Worked on Customer conversion to import data from Legacy System into Oracle Account Receivables by using Customer Interface.
• Developed PL/SQL Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Extracted data from AP tables and sending a flat file (checks cut in a period) using UTL FILE package at periodic intervals.
• Involved in Custom.pll and Form personalization.
• Tuned the reports to improve performance.
• Developed the reports as per the current requirement by using reports6i.
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands.
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.

Environment: Oracle Apps R11i, AR, PO, INV, OM, PL/SQL, Reports 10g/6i, XML/BI Publisher, Forms 10g/6i

Application Developer

Roles & Responsibilities:

• Created a Concurrent Program to call the Database Package and also the procedure to load the data from the staging table to the GL interface table
• Run the Journal Import process to load the data from the GL interface tables to the General Ledger base tables.
• Fixed issues with Multi-org setup while importing invoices into AR.
• Experienced in multi-currency setups.
• Involved in creating an interface to import Order Management data from the legacy system to Oracle Order Management. Used SQL Loader and PL/SQL packages to load and validate the data
• Involved in developing an Item Conversion to Import legacy inventory item data into the MTL SYSTEM ITEMS B table.

Environment: Oracle Apps R11i, BOM, AR, PO, INV, OM, PL/SQL, Reports 10g, XML/BI Publisher,