SUMMARY

• Around 8+ years of experience in the Information Technology industry with expertise in design, analysis, development, testing, and implementation of Oracle E - business Suite applications 11i / R12 versions.
• Good Experience in implementing Order-to-Cash(OTC) and Procure-to-Pay (P2P) Business Process flows.
• Good experience in building and testing of E-Business Suite Application Extension services such as RICE components (Reports, Interfaces - AR, Purchasing, General Ledger, Supplier, customers, Conversions, Extensions, Configuring changes, and Data Loading) using Oracle Forms, Oracle Reports, Oracle XML Publisher, Custom.pll and Workflow builder.
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, workarounds, interfaces, user training.
• Have Experience and sound knowledge on writing stored procedures, functions, packages, triggers, DDL, DML, SQL query using oracle 9i, 10g, 11g databases.
• Have Sound Knowledge and experience in oracle system administration and developer activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, providing support to apps users for any technical or functional issues.
• Have good knowledge and experience using Oracle Workflow builder.
• Worked Extensively on BI Publisher (XML Publisher),D2k and PL/SQL reports.
• Proficiency experience in customizing standard Oracle Forms with the use of custom.pll and Form Personalization.
• Expertise in bug fixing and interacting with oracle support.
• Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology.
• Experience in various development tools like SQL Developer, SQL*Loader, Oracle JDeveloper 10g/9i, Forms 10g/6i, Reports 10g/6i.
• Experience in developing UNIX Shell scripts for loading data into staging tables.
• Experience in Tuning SQL statements to improve execution performance using TKPROF, SQLTrace, etc.
• Solved high severity Production Issues raised by the users.
• Good Experience in Bug fixes and Performing unit test cases before production move.
• Knowledge of Oracle Metalink functionality/technical support area to aid in resolving application problems and solutions.
• Experience working as part of a team, ability to clearly articulate and effectively communicate ideas, problems and solutions within the team. Ability to plan work effort and manage the project schedule and priorities for self and/or small team.
• Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer.
• Excellent communication skills, adapt in client interaction and understanding business applications

TECHNICAL SKILLS

ERP: Oracle Applications R12 / 11i / 11.0.3/11.5.10.2

Oracle Applications: Oracle E-Business suite R12/11i/10.7 - General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Order Management, Inventory, Shipping, Project Accounting (PA), Purchasing, AOL, System Administrator.

Oracle Tools: SQL*Plus, TOAD, PLSQL Developer, BI Publisher,TOAD.

ERP: Oracle Applications R12/11i (Order Management, Order Entry, Accounts Receivables, Inventory, Purchasing, Accounts Payables, General Ledger, AOL, EDI, Work Flow)

Database Administration Tools: Oracle Enterprise Manager, TOAD, SQL Enterprise Manager, SQL *plus

Servers: Oracle Application Server, Web Logic Server

Databases & Tools: Oracle APEX 4.2/4.1, Developer 6i/10g, JDeveloper 11g, SQL Developer, BI Publisher

Languages: SQL, PL/SQL, Java(Basics), C.

Operating System: DOS, Unix, Windows NT/XP/2000/98.

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Customized Order Lines Workflow to add a custom function to assign Sales Credit Line for Order Line
• Developed Custom program to Consolidate Deliveries for Internal Sales Orders.
• Develop Custom Pick Slip report for consigned items.
• Developed Custom Program to create Shipments for Order Lines based on number of Deliveries created per Order.
• Performance fixes, Bug fixing and Production Support.
• Developed a custom program to assign items to a specific Sourcing Rule.
• Developed Custom Process in Order headers Workflow for Ship only Orders.
• Developed Custom functions and procedures to resolve bugs.
• Developed Custom Form to perform Account Aliases.
• Customized Workflow to pass Calculate Price Flag as Calculate for the ordered items created for Promotional Goods Modifier.
• Developed Custom Program and Form for Quote to Order Process.
• Customize the Request Scheduling for Users to run the reports /Requests in two steps using OAF.

Environment: Fusion 11g middleware, Oracle Applications (R12) Oracle Manufacturing (INV, OM, ASCP, SCM), PO, AR, AP, Workflow Administrator, Forms10g,Discoverer Reports 10g, PL/SQL, SQL*Plus, SQL Loader, TOAD 10, UNIX, XML Publisher.

Confidential, Miami, FL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked on Account Receivables, Procure to Pay (P2P) and order to cash(OTC) cycles .
• Upgrading RICE (Reports, Interface, Customization and Extensions) from 11i to R12.
• Create documents with all information regarding with upgrading process from EBS 11i to R12.
• Trouble shooting in critical issues in AR, GL and AP Modules in R12 environment.
• Developed Order Import interface to create Drop Ship Sales Orders.
• Developed PO Requisitions Interface to create new/Pre-approved requisitions
• Developed Release Holds on Sales Order Interface
• Developed AP invoice import Interface to import invoices to Accounts Payables
• Developed custom packages to mass upload Price lists, pricing modifiers/qualifiers, Pricing Agreements.
• Developed custom packages to use in pricing attributes, pricing formulas and qualifiers.
• Strong knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Developed reports and customized standard Oracle reports using Report Builder 10g, Discoverer and BI/XML Publisher.
• Migrated data from legacy system to Oracle Apps using standard API’s and PL/SQL procedures.
• Developed several PL/SQL packages, procedures, functions, triggers from UI events or database triggers, to implement complex business logic. Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility)
• Designing and development of custom interfaces in the Oracle AR and Oracle AP.
• Trouble shooting the Reports10g and Discoverer issues in R12.

Environment: Oracle E-Business Suite R12 (AP, AR, GL, OM, QP, PO, INV), Reports 10g, Forms 10g, XML Publisher, SQL*Plus, TOAD, SQL*Developer, Discoverer 10g and UNIX

Confidential, Parsippany, NJ

Techno-functional Consultant

Responsibilities:

• Developed Sales order interface to import the standard sales order from the COPS system to Oracle Order Management
• Developed Customer conversion to create new customers in oracle and updates existing customers from the COPS/NAVISION system.
• Developed an UBRR interface to recognize the unearned revenue based on the usage amount for the usage based contracts.
• Created GL to Hyperion Outbound to extract all the accounting information code combination and generate the data file (UTL file).
• Worked AR Open balance conversion to update the customers with their respective open balances in oracle.
• Designed an invoice print report using the xml publisher which allows users to print their AR invoices.
• Customized the standard bill only line workflow to track the manual sales orders created in the order management.
• Customized the Order Management and shipping Workflow processes and notifications.
• Developed New Forms and customizations in standard forms based on user requirements using Oracle Form Builder in Manufacturing and distribution Modules.
• Developed a package to load the sales orders into oracle Order Management using Order Import process.
• Provided functional/technical production support for OM, INV and PO modules, worked with oracle support and resolved numerous production issues.
• Developed Item Import interface to create Inventory items.

Environment: Oracle Applications (R12.0.6), Forms 10g, Reports 10g, XML Publisher, Workflow builder, Oracle 11g, SQL Navigator

Confidential, San Jose, CA

Oracle Apps Developer

Responsibilities:

• Developed Shipping Interfaces to create /update Deliveries, Split delivery details and Ship confirm the sales orders.
• Developed BOM (Bill of Materials) Interface to upload Bill of Material transactions.
• Developed Order Import Interface to create new/booked Sales Orders in EBS
• Developed Items Import Interface to create new Inventory items in EBS
• Developed custom Forms using Forms 6i
• Developed Interfaces for inventory adjustments.
• Developed several customizations on OM module using Forms personalization and Custom.pll file.
• Developed number of PLSQL Procedures to the generate XML data files.
• Design & development of XML Reports using BI Publisher.
• Implementing custom reports using BOM and WIP
• Responsible for designing technical design, test case and porting instruction documents.

Environment: Oracle Applications (12.0.6/11.5.10.2 ), Forms 10g/ 6i, Reports 10g/6i, Workflow builder, Oracle 10g

Confidential

Technical Consultant

Responsibilities:

• Analyzing the functional design document, preparing technical design documents from functional design documents for various interfaces. Executing the technical design documents as packages and procedures into development instances.
• Involved in Development of Suppliers Conversion script and successfully migrated the Legacy system supplier’s data into Oracle Standard tables.
• Developed Invoice Exception Report using XML-Publisher.
• Developed Payable Inbound Interface to upload the invoices from client legacy system into Oracle applications base tables.
• Developed the Script for Receipts Conversion using API s and successfully executed for various subsidiaries.
• Developed AR Credit Memo Printing Report using XML-Publisher.
• Involved in the setup of Defining Security rules, Ledgers, Journal entry categories, Automatic posting in General Ledger module.
• Unit testing and peer reviewing the interfaces.
• Fixing of bugs and issues that occurs during the different testing phases.
• Configuring set up (Concurrent programs, Lookup tables etc.) in the quality database as per installation guide.
• Documenting all the development work done such as MD050 and MD070.
• Raised TARs & enhancement requests for Technical/functional deficiencies in Oracle Applications product.

Environment: Oracle Applications (12.0.6), Forms 10g, Reports 10g, XML Publisher, Workflow builder, TOAD, Oracle 10g