SUMMARY:

• Over 14 Years of experience in Oracle ERP and CRM Modules (Oracle Release 12, 11i/ 11.0.3/10.7 )
• Diversified experience in all phases of software development life cycle
• Extensive experience in Oracle Application Conversions/Migrations/Interfaces
• Extensive experience in developing Oracle Packages, API’s
• Extensive experience in Unit and Integrated system testing
• Very hands on in Technical aspects of Oracle Order to Cash, Procure to Pay and CRM
• Worked in various Fortune 500 companies with various product line including Hi - Tech, Bio-Medical, Manufacturing and Service oriented companies
• Coordinated with project teams in-site as well as off-site

SKILLS & KNOWLEDGE:

Functional Areas: Oracle Applications Release 12 (Order Management, Shipping, Inventory, Bill of Materials, Receivables, Payables, General Ledger, Demand Planning, Oracle Purchasing, Oracle Fixed Assets, Oracle Projects, Purchasing

CRM: Install Base, Service Contracts, Depot repair, Tele Service, Customer Service, Field Service

RDBMS: Oracle 11g, Oracle 10i, Oracle 9i, Oracle 8i, Oracle 7x

Tools: Oracle Forms 6i, Oracle developer 2000(Forms 4.5), Oracle designer 6i, Oracle Reports (6x,4.5), Toad, SQL Navigator, Workflow, Informatica Power center 8.6.0, XML Publisher, Kintana, PVCS, SQL * Loader, SOAP UI, SOA, Oracle XML Gateway, Clear case, Clear Quest, Quality center

Languages: SQL, PL/SQL, HTML, XML

Operating Systems: Unix, Solaris, Windows

Other Tools Knowledge: C#/.Net/java, Oracle Clinical EDC

EXPERIENCE:

Confidential, MA

Modules: Oracle Applications Release 11i/12 (Oracle Projects, Service Contracts, Install base, Oracle Inventory, Oracle BOM, Oracle Work IN Process)

Responsibilities:

• Worked on data conversion requirements, strategy, conversion approach and process flows
• Developed scripts to Migrate Service Contracts, Install base, Projects, Customer Repair Orders to IFS

Confidential, CA

Modules: Oracle Applications Release 11i/12 (Oracle Inventory, Oracle BOM, Oracle Work IN Process)

Responsibilities:

• Developed WIP Job Completion, WIP Move Transaction Interfaces using Oracle API’s
• Built an Extension to pass WIP Job Information to Delmia using XML CLOBS
• Developed an Interface to Update BOMs in Oracle applications using Oracle API’s

Confidential, Baltimore, MD

Modules: Oracle Applications Release 11i/12 (Oracle Procure to Pay, Oracle Receivables, Oracle General Ledger)

Responsibilities:

• Worked on CUSTOM.pll to enforce Invoice to Purchase Matching Rules when the Purchase order has multiple distributions
• Worked on Developing PL/SQL report to list out Overpayment Collection activity for a Collection application Date Range that matches to Transaction Report on Receivables ( TROR)
• Worked on AP invoice import Interface to import invoices to Accounts Payables

Confidential, San Jose

Modules: Oracle Applications Release 12 (Oracle Receivables, General Ledger, Order Management, Inventory)

Responsibilities:

• Developed validation program to load invoices data into interface tables and run the standard program to create invoices into AR
• Developed Custom report which will list out Credit Memos with the Original Invoice References
• Reviewed Functional, Technical Specifications (Custom Credit Check Process, Invoice Creation, Revenue recognition) developed by Infosys Team
• Reviewed the code developed by Infosys offshore Team
• Developed XML Payloads for conducting Load Tests

Confidential, Sunnayvale

Modules: Oracle Applications Release 12 (Oracle TCA, Customer Master Data Management MDM)

Responsibilities:

• Developed Data Loader scripts, Validation scripts to extract and validate Customers data
• Developed customers conversion/integration programs using TCA APIs
• Executed the test plans
• Converted customers in CRP, User Acceptance Testing and Production instances

Confidential, Mountain View

Modules: Oracle Applications Release 11i (Order management, Inventory, Bill of Materials, Oracle Demand, Oracle Forecast)

Responsibilities:

• Developed an API to assign Individual Items to Commodity Managers based on Commodity code
• Developed an API to define future costs of the item up to 4 quarters
• Developed Custom APIs to generate above mentioned reports
• Developed an API to provide week and monthly volume forecast, net demand and total demand based on ASCP planning data
• Developed test plans to test business processes

Confidential, Palo Alto

Modules: Oracle Applications Release 11i (Order management, Inventory, Bill of Materials, Install base, Service Contracts, Advance Pricing)

Responsibilities:

• As part of the PDH New Bill of Materials, Categories and Items were created
• Updated Install Base Pricing Attributes and Extended Attributes
• Modified Confidential Custom pricing programs as per the new design
• Made changes to the existing Order Creation API

Confidential, Palo Alto

Modules: Oracle Applications Release 11i (Order management, Inventory, Install base, Service Contracts)

E-business suite lead

Responsibilities:

• Participate in review of functional requirements for new system
• Provided solutions for enabling SOA architecture by exposing custom APIs
• Involved in preparing MD070 document to outline the custom extensions for the new system
• Delegating work to onsite and offshore team
• Co Ordinate integration testing and issue resolution across different tracks
• For complex interfaces, involved in actual development
• Worked with cross functional teams such as portal and middleware to implement end to end integrated solution

Confidential, Sunnyvale

Modules: Oracle Applications Release 12 (Order management, Shipping, Inventory, Install base, Service Contracts, Purchasing)

Responsibilities:

• Worked on preparing CV010 document to illustrate data conversion requirements, strategy, conversion approach and process flows
• Worked on preparing CV060 design document to illustrate Item, Categories, Price Lists, Customers, Install base, Sales Order data conversion assumptions, extraction criteria, derivation rules, validation rules, processing rules and logic to populate the data in interface tables/oracle standard API
• Developed Data Loader scripts, Validation scripts to extract and validate the Items, Categories, Pricelists, Install base data
• Developed oracle programs for converting Items, Categories, Price Lists, Install Base using oracle standard API’s
• Developed validation program to load into supplier interface tables and run the standard program to create suppliers
• Created validation program to load purchase orders in interface tables
• Developed Test scripts to test Items conversion/Interface using TE010 Testing Requirements and Strategy, TE020 Unit Test Script

Confidential, San Jose

Modules: Oracle Applications 11i (Oracle Receivables)

Technical expert

Responsibilities:

• Prepared CV040 data mapping document which gives all the details of customers data mapping to create customers in oracle
• Prepared TE040 system test script document for illustrating customer conversion testing strategies like business mapping test results, data profiles for the system test
• Developed Data Loader scripts, Validation scripts to extract and validate the customers data
• Developed customers conversion/integration programs using TCA APIs
• Converted customers in CRP, User Acceptance Testing and Production instances
• Executed the test plans

Confidential, Palo Alto

Modules: Oracle Applications 11i, (Order to Cash) Order Management, Oracle Service Contracts 11.5.9, Install Base 11.5.9, TCA, Receivables)

Responsibilities:

• Worked on preparing MD070 document to outline the custom extension strategy for downgrading a product, creating a new Licenses, tracking of license transaction history
• Designed and developed an APIs to create a new downgrade order using Order Creation API’s
• Designed and Developed APIs to create new licenses, splitting and combining the existing licenses
• Designed and Developed an API to create Installation details for the Installed Products and called this API from the Down grade Order Creation API
• Modified existing workflows to call the new API’s developed
• Developed an APIs to get all the transactions that customer has done on a particular license. This API is called from the Middleware APIs
• Worked on preparing the TE040 document to outline the testing strategies and testing plans
• Developed different end user reports using XML publisher
• Developed validation program to load invoices data into interface tables and run the standard program to create invoices into AR

Confidential, Palo Alto

Modules: Oracle Applications 11i (Order Management Inventory, TCA, Shipping, Install Base, Service Contracts, Oracle Receivables)

Responsibilities:

• Design and Development of custom programs to extract the data from current Oracle system and populated IB and SC interface tables to create Install base and Service contracts
• Developed custom reports to forecast maintenance/License renewals by Qtr/Renewal Rep /Region
• Developed reconciliation report to verify billing information was posted to receivables or not as per the billing schedules

Confidential, San Jose

Modules: Oracle Applications 11i (Order Management, Shipping, Oracle Service Contracts 11.5.9, Install Base 11.5.9, TCA, Depot Repair, Tele service, Receivables, Payables, Purchasing, Order Managements, Oracle Purchasing)

Responsibilities:

• Designed MD060 document to get the requirements for releasing the holds on oracle repair order lines
• Developed Custom Program to release the Holds created for the Repair Order Lines
• Fixing the conversion issues
• Developed a report to get the Invoice information for a particular month with customer and orders details
• Developed reconcile reports to verify the invoices were generated based on the service contract billing schedules.
• Production support for CRM Modules (Order Management, Shipping, WMS, Service contracts, Install base, Depot Repair, Tele Service)
• Fixing Enhancement issues
• Developed validation program to load into supplier interface tables and run the standard program to create suppliers
• Created validation program to load purchase orders in interface tables
• Developed validation program to load into requisition interface tables and run the standard Requisition Import program to load into Requisition Standard tables
• Developed custom form for not to send the loaner equipment to customer if the customer is due to return the loaner. This form will be opened automatically in the repair order screen if the customer is due to return the loaner. Oracle personalization is used for displaying the form for the above scenario
• Developed various Discoverer, XML Publisher reports related to CRM modules

Confidential, Cupertino

Responsibilities:

• Main task of this project is to identify what licensing information needs to be converted as a service contract and from which source system.
• Worked on preparing CV060 document to illustrate data conversion assumptions, extraction criteria, derivation rules, validation rules, processing rules and logic to populate the data in interface tables/oracle standard API
• Worked on preparing CV040 document which outlines the mapping between existing license information and service contract info for creating service contracts
• Developed custom programs to convert Sales Orders, Service contracts, Install base

Confidential, San Jose

Modules: Oracle Applications 11i, (Oracle Service Contracts 11.5.9, Install Base 11.5.9, TCA, OM)

Responsibilities:

• Worked in requirements gathering for developing the Item Creation form
• Developed new forms, reports and customized the existing reports
• Customized invoice report layout from landscape mode to Portrait mode

Confidential

Programmer/Analyst

Modules: Oracle Applications 11i, (Oracle Service Contracts 11.5.9, Install Base 11.5.9, TCA, AR, GL)

Responsibilities:

• Prepared Technical Specifications based on the functional requirements
• Developed interfaces for extracting Orders and Service contracts Bookings and Revenue information
• Developed new forms for Correcting the Bookings and Revenue information
• Developed analytical reports using Discoverer with drill down capabilities by region, Market, Industry

Confidential, CA

Programmer/Analyst

Responsibilities:

• Prepared Technical Specifications based on the functional requirements
• Developed Items interfaces to update Item attributes and BOM Interface to update the BOMS
• Developed post processing scripts for Install base to split the instances and Maintaining System

Confidential, Mountain View, CA

Modules: Oracle Applications 11i, (Oracle Service Contracts 11.5.9, Install Base 11.5.9, TCA)

Responsibilities:

• Worked on preparing CV060 document to illustrate data conversion assumptions, extraction criteria, derivation rules, validation rules, processing rules and logic to populate the data in interface tables/oracle standard API
• Worked on preparing CV040 data mapping documents for Sales Orders, Invoice Rules, Payment Terms, Tasks, Notes, Service Requests, Install Base and Service Contracts
• Migrated 350,000 Service contracts and 3,000,000 Install base records from 11.0.3 to 11i using Oracle Standard API’s
• Developed custom APIs to cleanse the existing data as part of data migration

Confidential, San Jose, CA

Programmer/Analyst

Modules: Oracle Applications 11i, Order to Cash (Oracle Service Contracts 11.5.7, Install Base 11.5.7)

Responsibilities:

• Worked on preparing CV010 document to illustrate data conversion requirements, strategy, conversion approach and process flows
• Worked on preparing CV060 document to illustrate data conversion assumptions, extraction criteria, derivation rules, validation rules, processing rules and logic to populate the data in interface tables/oracle standard API
• Migrated 550,000 Service contracts which consists 1.5 billion records and 2 billions of Install base records. The size of the database is approx of 1 TB
• Developed custom APIs to translate the data
• Prepared Space estimations and Migration times
• Worked on preparing the TE040 document to outline the testing strategies and testing plans and executed the test plans

Confidential, San Jose, CA

Programmer/Analyst

Modules: Oracle Applications 11.0.3, forms4.5, Reports 3 (Order Management, Oracle Sales and Marketing)

Responsibilities:

• Prepared Technical specifications from high level functional design documents
• Customized OM and OSM workbench forms to include new validations and displaying the opportunity details (order type, customer name, bill-to address) in the sales order based on the attached opportunity
• Developed new database triggers to update OSM changes in OM and Vise-versa

Confidential, San Jose, CA

Programmer/Analyst

Modules: Oracle Applications 11i, forms6i, Reports 6i (Oracle order management, Shipping, Oracle Service Contracts, Contracts Core, Install Base)

Responsibilities:

• Integrated service agreements with custom pricing engine
• Customized the standard Oracle API for doing the Contract level and Line Level re-price
• Standard Contract authoring form will restrict to terminate a single product at a time. To solve this problem developed a form for mass termination. This form will show all the details of the covered products like coverage periods, install base information, customer information
• Standard Contract authoring form will restrict to add one product at a time. To solve this problem developed a new form to add the products to the contract. This form will allow to adding a total configuration item also.
• Rewrite the standard contract status change program to increase the performance
• Added New QA check processes in addition to the standard QA check processes.
• Developed reports to prepare document preparation kits. These kits will be sent to the customers after signing the new contract and renewing the contract. Kits includes new Partner/Customer welcome Letters, mailing labels and attachments (Lists all the covered products of the contract site wise)
• Prepared TE040 document for illustrating testing strategies like business mapping test results, data profiles for the system test

Confidential, San Jose, CA

Oracle Applications Interface Consultant

Modules: Oracle Applications 10.7, forms 4.5 (Order Entry, Oracle Receivable, Oracle Inventory)

Responsibilities:

• Designed and developed Interfaces to get customers, addresses, territories, price lists and items information data from Oracle Accounts receivables and Oracle Inventory modules.
• Developed backend procedures for the front end screens