SUMMARY:

• Over 12+ years of experience in Oracle E - Business Suite (EBS) and Information Technology.
• Extensive experience in Implementation, Customization, Upgradation and Production Support of Oracle EBS.
• Extensive experience in all phases (SDLC) of Oracle EBS Implementation with major focus in SCM OM (Order Management), INV (Inventory), BOM (Bills of Material), WIP (Work in Process), WSH (Shipping), QP (Advanced Pricing), PO (Purchasing), Finance AR (Account Receivables), AP (Account Payables) and GL (General Ledger), SR (Service Requests), TM (Trade Management), Oracle Alerts and AOL modules.
• Strong knowledge and experience in Manufacturing, Distribution, Supply Chain Management and Finance modules
• Strong knowledge and experience in Order to Cash (O2C) and Procure to Pay (P2P) business flows.
• Extensive experience in Reports, Interfaces, Conversions and Extensions (RICE) and Configuration, Extensions, Modification, Localization and Integration (CEMLI).
• Extensive experience in developing Interfaces/Conversion Programs using SQL, PL/SQL, SQL*Loader, APIs, ADI/Web ADI etc.
• Extensive experience in developing custom forms using forms 6i/10G.
• Extensive experience in customizing the forms functionality using Form Personalization and Custom.pll.
• Extensive experience in developing custom reports and customizing standard reports using reports 6i./10G.
• Expertisein System Administrator functions like Registering Concurrent Programs, Forms, Form Functions, Menus, Request Groups, Value Sets, and Responsibilities etc.
• Expertisein OAF Personalization and Customization.
• Expertisein Oracle XML Publisher reports.
• Expertisein the UNIX Shell Script.
• Extensive experience in PL/SQL coding like Cursors, Ref Cursors, Dynamic SQL, Packages, Collections, file management using UTL FILE packages, Triggers, Stored Procedures and Functions.
• Strong experience on SQL queries performance turning.
• Familiar with application development tools like PL/SQL Developer, SQL*Plus and TOAD.
• Experience in customizing workflows.
• Experience in creating documentation using AIM. Familiar with all the Standard Documents like MD.50, MD.70, CV.40, CV.60and TE.20.
• Worked with Oracle Applications Releases 11.5.10 and R12.
• Experience in working with ITG Kintana/ HP PPM change management and migration tool.
• Worked in teams, involved in various responsibilities like development, Unit testing and UAT.
• Excellent analytical, problem solving and communication skills, detail oriented with ability to be an effective team player and work under severe time constraints.

TECHNOLOGY EXPERIENCE SUMMARY:

ERP Skills: Oracle Applications R12 / 11i Inventory (INV), Order Management (OM), Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Bill of Material (BOM), Work in Process (WIP), Shipping (WSH), Advanced Pricing (QP), Purchasing (PO), Trade Management(TM), SR (Service Requests), and Quality (QA)

Languages: PL/SQL, SQL, Unix Shell Scripting, C, C++, Core Java, XML, HTML

Database: Oracle 8, 9i,10g

Developer Tools: Forms 6i, Forms 10g, Reports 6i, Reports 10g; OAF, Oracle 9i Jdeveloper, XML Publisher.

Utilities/ Tools: SQL* Plus, SQL*Loader, TOAD, KINTANA, Quality Center, PVCS

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

WORK EXPERIENCE:

Oracle EBS Techno-Functional Consultant

Confidential, San Diego, CA

Responsibilities:

• Participated in 11i to R12 upgrade.
• Retrofitted 11i custom RICE/CEMLI objects to R12
• Upgraded forms from 11i to R12 (Forms 6i to 10g)
• Upgraded reports from 11i to R12 (Reports 6i to 10g)
• Reviewed the existing code and made the changes to use R12 functionality/new features as necessary
• Customized Custom.pll
• Developed Conversions:
• Customer Conversion
• AR Invoice Transaction
• Sales Order Conversion
• Purchase Order Conversion
• On-Hand Quantity
• Developed Interfaces:
• OM Shipments data to Trade Management Interface
• AR Receipt Creation through API.
• Sales Order and Shipping Custom Interfaces
• WIP Move Transaction Interface
• WMS Rules Interface
• Accrual Adjustments Interface in Trade Management
• Developed Auto Lockbox setup to process receipts automatically.
• Developed interfaces and forms to implement custom process NC (Non-Conformance) with Service Requests
• Developed automated process to create Service Requests, Charges and RMA.
• Created MD.070 and TE.020 documents.
• Worked closely with various teams/team members at the time of requirements gathering, resolving issues, development and QA testing.
• Worked closely with users at the time of development, UAT, support and .

Environment: Oracle EBS R12(12.1.3), Oracle11g, Forms 6i/10g, Reports 6i/10g, SQL*PLUS, PL/SQL, Toad, XML Publisher, Windows XP, Unix, Linux and PVCS

Oracle EBS Techno-Functional Consultant

Confidential, Columbus, OH

Responsibilities:

• Worked on R12 Integration with third party software ProNest.
• Data Sync from Oracle ERP to ProNest
• Developed WIP Interface programs to sync the Pronest data with the Oracle ERP
• Developed forms for the Integration data
• Analyze BPEL integration with ProNest and Oracle ERP.
• Created Technical documents for integration
• Worked closely with various teams/team members at the time of requirements gathering, resolving issues, development and QA testing
• Worked closely with users at the time of development, UAT, support and

Environment: Oracle EBS R12(12.1.3), Oracle11g, Forms 6i/10g, Reports 6i/10g, SQL*PLUS, PL/SQL, SQL*Loader, PL/SQL Developer, Toad, XML Publisher, Windows XP, Unix, Linux and PVCS

Oracle EBS Techno-Functional Consultant

Confidential, San Diego, CA

Responsibilities:

• Participated in Conversion Integration process to convert the data from source system to target system.
• Reviewed the conversion code developed by other developers
• Developed interface to integrate Order Management and Trade Management.
• Created Technical documents for conversions
• Worked closely with various teams/team members at the time of requirements gathering, resolving issues, development and QA testing
• Worked closely with users at the time of development, UAT, support and
• Developed Conversions:
• On-Hand Quantity Conversion
• Sales Order Conversion
• Customer Conversion
• AR Invoice Conversion
• PO Conversion
• Offers Conversion in Trade Management

Environment: Oracle EBS 11i, Oracle11g, Forms 6i/10g, Reports 6i/10g, SQL*PLUS, PL/SQL, SQL*Loader, PL/SQL Developer, Toad, XML Publisher, Windows XP, Unix, Linux and PVCS

Oracle EBS Technical Consultant

Confidential

Responsibilities:

• Devleoped and customized interface programs
• Developed and customized XML reports
• Developed and customized forms
• Customized Custom.pll
• Reviewed the code developed by other developers
• Created MD.070 and TE.020 documents.
• Created SRs on Metalink to resolve application issues and bugs
• Worked closely with various teams/team members at the time of requirements gathering, resolving issues, development and QA testing
• Worked closely with users at the time of development, UAT, support

Environment: Oracle EBS R12(12.1.3), Oracle11g, Forms 6i/10g, Reports 6i/10g, SQL*PLUS, PL/SQL, SQL*Loader, PL/SQL Developer, Toad, XML Publisher, Windows XP, Unix, Linux and PVCS

Oracle EBS Technical Consultant

Confidential

Responsibilities:

• Developed conversion process to import Open Sales Orders
• Developed conversion process to import Open Purchase Orders
• Developed conversion process to import customers into AR
• Developed conversion process to import Auto rnvoices into AR
• Developed outbound Interfaces to send the data to third party systems
• Developed XML Publisher Reports to enable the users to view reports in Excel and PDF format
• Developed several reports using Reports 6i and XML Publisher
• Worked closely with various teams/team members at the time of requirements gathering, resolving issues, development and QA testing
• Developed several documents like MD070 and TE020
• Performance Tuning of Long running queries
• Worked closely with various teams/team members at the time of requirements gathering, resolving issues, development and QA testing
• Worked closely with users at the time of development, UAT, support

Environment: Oracle EBS 11i, Oracle10g, Forms 6i, Reports 6i, SQL*PLUS, PL/SQL, SQL*Loader, PL/SQL Developer, Toad, XML Publisher, Windows XP, Unix, Linux and PVCS

Oracle EBS Technical Consultant

Confidential

Responsibilities:

• Developed Auto Invoice Interface in Receivables
• Developed Installment Billing interface in Receivables
• Developed Generic Receipts Creation and Apply interface
• Developed Getpaid outbound interface to extract AR information to the third party system
• Developed several reports using Reports 6i and XML Publisher
• Developed several custom forms using Forms 6i
• Developed several technical documents
• Worked closely with various teams/team members at the time of requirements gathering, resolving issues, development and QA testing
• Worked closely with users at the time of development, UAT, support and

Environment: Oracle EBS 11i, Oracle10g, Forms 6i, Reports 6i, SQL*PLUS, PL/SQL, SQL*Loader, PL/SQL Developer, Toad, XML Publisher, Windows XP, Unix, Linux and PVCS

Oracle Developer

Confidential

Responsibilities:

• Worked as a oracle PLSQL developer
• Writing procedures, functions, packages and database triggers in PL/SQL
• Involvement in testing the new programs