SUMMARY

• Having 8 years of IT Industry experience in Oracle E - Business Suite (R12/11i) as a techno-functional consultant
• Worked on end-to-end process flows including Order-To-Cash, Procure-To-Pay and Manufacturing process flows
• Worked on various Oracle ERP, CRM and Manufacturing modules like Order Management, Advanced Pricing, Shipping, Purchasing, Inventory, Bill of Materials, Work In Process, TCA Architecture, Receivables, Payables, Installed Base.
• Experienced in Design and Development of Conversion programs, Interfaces, Extensions Customizations to fulfill various user requirements.
• Expertise with Oracle ERP Applications development tools SQL, PL/SQL, Oracle Apex, Oracle Forms and Report 10G/6i, XML(BI) Publisher, Oracle Workflow, SQL*Loader, Unix Shell Scripting
• Experience in customizing standard Oracle forms with the use of Custom.pll and Forms Personalization
• Experienced in Using Oracle Applications standard API’s as wells as writing custom Oracle API’s and using it in Oracle Applications Interfaces/Conversions.
• Strong in Applications Object Library (Concurrent programs registration, Value Sets, Profiles, form registrations etc), and System Admin tasks.
• Experienced in SQL, PL/SQL Code optimization with Significant Performance Tuning (Trace Files, TKPROF, Explain Plan and UNIX with Solaris Environment) capabilities and experience related to the Oracle E-Business Suite.
• Experience in supporting the production system, handling day-to-day issues and end user training.
• Experienced with business process/requirements analysis, module set up and configuration, documentation, ability to spec customizations and reports, and knowledge transfer experience.
• Worked on end-to-end Oracle Applications implementations for multiple clients
• Good communication and interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications 11i,R12 - PO, OM, INV, BOM,WIPAccount Receivables,TCA, CRM (CRM Administration, Service, Install Base, Depot Repair),Oracle Financials, SYSADMIN, Application Object Library, Oracle Workflow

Oracle Databases: Oracle 9i,10g,11g

Programming Languages: SQL, PL/SQL, Unix Shell scripting, C, C++, Java

Oracle Development Tools: Oracle Forms and Report 10G/6i, Oracle Apex, XML (BI) PublisherOracle Workflow Builder, SQL*Loader

OS: UNIX (HP/Sun/), Windows 95/98/NT/2000/ XP.

Others: SQL* Plus, TOAD.

Version Control/Migration Tools: PVCS and Kintana, SVN.

PROFESSIONAL EXPERIENCE

Confidential, Milpitas, CA

Sr Application Developer

Responsibilities:

• Designed and Developed a Custom WebADI process to create AR Invoices & AP Invoices using excel, This custom process validates the data and reject or process based on the successful validation like seeded WebADI.
• Designed and Developed Customer Conversion program to convert customer’s data from 11i to R12. This includes customer accounts, sites, site uses and Locations.
• Designed and Developed Supplier Conversion program to convert supplier’s data from 11i to R12. This includes Supplier sites and Contacts, Banks, Bank branches and assign supplier to banks.
• Developed Employee conversion program to convert employee from 11i to R12 . Includes Address, Jobs and Assignments.
• Wrote SQL*Loader scripts to migrate the data from the text files, CSV Files etc. and populated the intermediate tables.
• Developed Several Unix Scripts as part of Interface/Conversion programs
• Developed various Custom Programs to support the client business.
• Developed unit test documents for all the possible test cases for the developed objects
• Trouble Shooting/Debug process flows by understanding seeded setups & code.
• Developed SQL scripts to extract the Customer data from 11i.
• Reports
• Developed custom XML/BI Publisher report, it finds all the RMA orders booked and closed since the last successful run and this report is used by Corp Ops to adjust Points for RMAs original orders.
• Modified the Invoice Print Report to display the Ordered Item from Order Lines instead of item name from inventory on the report output.
• Forms
• Developed a customized inventory form to mass update item attributes.
• Added the Features Like ZOOM, WHO columns by using Custom.pll
• Added Descriptive Flex Fields in custom form
• Attached calendar to date fields.
• Workflow Development/Customization
• Customized Order Management workflows to apply source ship from org based on the customer specific logic.

Confidential, Milpitas, CA

Sr Application Developer.

Responsibilities:

• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.
• Designed and Developed Price List conversion program to convert 11i data to R12 data.
• Designed and Developed Sales Order Conversion program to convert data from 11i to R12 using Order API’
• Customized Sales Order Acknowledgment Report in XML.
• Created Custom Value set of Dependent, Independent, and Table Types in R12.
• Wrote SQL*Loader scripts to migrate the data from the text files, Excel Spreadsheet etc. and populated the intermediate tables.
• Modified existing custom packages to add new functionality and to optimize the performance.
• Developed Item Cross Reference program to load Nano Item vs Vendor Item cross reference using seeded API’s
• Developed Several Unix Scripts as part of Interface/Conversion programs
• Developed various Custom Programs to support the client business.
• Developed unit test documents for all the possible test cases for the developed objects
• Developed scripts to verify all the country setups for new implementation.
• Report
• Customized & converted standard pick slip report as XML/BI Publisher report and developed report to display some fields as barcode.
• Developed a customer BI Publisher report to display Orders which are in header/line holds, Report including Order, Line, hold comments etc. details.
• Forms
• Created custom responsibility based on SysAdmin responsibility for users to change profiles values at user level and added form personalization on custom responsibility to enabled user filed.

Brocarde, San Jose, CA

Support Analyst / Onsite Coordinator.

Responsibilities:

• As part of Applications support worked on different helpdesk ticket to fix the existing process issues and worked on Change Requests to extend the functionally of the defined processes.
• Developed Various PL/SQL Objects
• Developed Shell scripts.
• Troubleshooting issues related to different modules and fixing.
• Worked on Oracle Applications ERP modules in fixing the issues.
• Created Several Service Requests with Oracle using metalink and worked/supported Oracle team with required diagnostics data.
• Created/Updated MD70 documents
• Used different tools like Clearcase and Kintana to maintain version control and code migration.
• Modified existing custom packages to add new functionality and to optimize the performance.
• Worked extensively with tools such as EXPLAIN PLAN, SQLTRACE and Oracle Diagnostics for troubleshooting application and SQL issues.

Confidential, Brea, CA

Sr Application Developer

Responsibilities:

• Ongoing day to day Production Support activities / issues and providing problem resolving solutions to Remedy Tickets.
• Primary Support for the Oracle Applications ERP Quote-to-Cash processes.
• Study the Functional requirements and work with Functional and Business teams to understand the client requirements.
• Development of custom objects as part of various projects using various tools.
• Tkprof all the Custom Objects to make sure performance is good before migrating the code to Production.
• Develop Custom code by taking the necessary performance precautions.
• Support for the Third party applications like eStore, Sales Force dot com and TIBCO.
• Implement Interfaces to integrate different systems with Oracle Applications ERP Suite.
• Preparing Technical Design documents and Test case documents using Oracle AIM Methodology.
• Creating Service Requests and work with Oracle (Metalink) in solving the Issues.
• Implemented Electronics Data Interchange(EDI) programs to translate the received customer PO information in the form of EDI.
• Developed Custom Order creation programs to validate the data and create call Standard Order Import API to create Orders in Oracle ERP.
• Developed EDI Trading Partner setup form to maintain EDI setups.
• Developed EDI Order History/Error Correction screen using forms to reprocess the failed orders
• Developed Reports using Report 10g and XML Publisher.
• Developed programs for EDI 850,855,856 and 810

Confidential, Duluth, Georgia

Technical Consultant.

Responsibilities:

• Involved in developing and Review of AIM (MD050, MD 070) documents for (INV, OM, PO) module implementation/development.
• Designed and Develop Item migration program using interface tables from ERP system to ES system And validate all the records before inserting interface tables.
• Designed and Developed "Bank Accounts conversion" conversion from 11i to R12.
• Hands on experience in Oracle Applications System administration, involved in setting up user responsibilities, privileges of users, administering concurrent registering various Forms and Reports.
• Developed a report based having all the Purchase orders having 2-way, 3-way and 4-way matching with item value more than X amount in Payables
• Actively involved in ongoing day to day Production Support activities / issues and providing problem resolving solutions to Tickets
• Reports
• Developed a discoverer report to show all Confidential .next orders booked and closed in the last successful run with the created Confidential .next hold and hold release reasons.
• Developed discoverer report and it finds all the Confidential RMA orders booked and closed since the last successful run and this report is used by Corp Ops to adjust Confidential Points for RMAs original orders.
• Developed discoverer report to show Confidential families tree structure containing their points, primary customer’s information and the affiliate details.
• Modified the Invoice Print Report to display the Ordered Item from Order Lines instead of item name from inventory on the report output.
• Forms
• Added the Features Like ZOOM, WHO columns by using Custom.pll
• Added Descriptive Flex Fields in custom form
• Attached calendar to date fields.

Confidential

Technical Consultant

Responsibilities:

• Registering Custom Applications, Concurrent Programs, Tables
• Defining Concurrent Programs and Executable.
• Adding Descriptive Flex Fields.
• Developed Report from the scratch as per client requirements
• Customization and development Interfaces. As per client requirements.
• Creation of Value sets in various Modules of the application
• Prepared UTC(Unit Test Cases) from various components.
• Defining Concurrent Programs, Executable.
• PL/SQL Method of submitting Concurrent Programs
• Developed interface program to Upload Journals into GL interface tables from Legacy System in Oracle General Ledger and Used SQL * Loader to upload data from Flat Files to Pre-interface table and wrote a PL/ SQL Procedure for all the business validations.
• Customized and generated the reports, customized forms and registered them
• As concurrent programs in Oracle applications using AOL.

Confidential

Associate Technical Consultant.

Responsibilities:

• Receiving Tickets (or) Enhancements from the client the object modified and we should deliver to onsite by updating both coding and documentation.
• Customization of Reports as per the Client requirement.
• Understanding the report functionality and analysis and review of high level documents mainly MD 050s.
• Registering of Concurrent Programs.
• Scheduling the Concurrent Programs.
• Created different types of Value Sets in Various modules of the application.
• Developing Procedures, Functions, Packages and Queries in PO, AP Modules