SUMMARY

• Over 14 years in Software Development & Quality Management in IT industry, out of which 11 Years in Oracle Applications.
• Extensive experience in Oracle Applications E - Business Suite including Implementations, Upgrades, Data Conversions, Interfaces, Customizations, and Maintenance.
• Successfully completed 5 full life cycle implementations in Oracle application releases R 12/ 11.5.10 / 11.0.3.
• Techno/Functional experience in Oracle OM (Order Management), PO (Oracle Purchasing), Manufacturing (INV, WIP, BOM), Financials (AP, AR), PIM (Product Data Hub), Oracle Sourcing, Payroll, AOL (Application Object Library) and System Administrator.
• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, design, Resource Planning, Coding, Testing and implementing business applications.
• Having knowledge in GL, SCM, HRMS, OA frame work, Workflows and Oracle Discoverer.
• Excellent technical knowledge in Order Management (OM), Inventory (INV), Work in Process (WIP), Accounts Payables (AP), Accounts Receivables (AR), Purchasing (PO), Bills of material (BOM), Oracle Sourcing, PIM (Product Data Hub), Advanced Collections, GL, HRMS, SCM, Application Object Library, System Administrator.
• Good exposure and efficient programing on RICE components.
• Well versed programing skills in PL/SQL, SQL*PLUS, SQL*LOADER, Reports 2.5/6i/10g, Forms 4.5/6i/10g, Discoverer, Workflows, OAF, BI Publisher, Forms Personalization’s and shell scripting.
• Efficient knowledge in fine tuning the programs.
• Proficient knowledge on Oracle 11g/10g/9i/8i/8.0/7.3.
• Good Knowledge in ADF, Business Objects 6.5, Teradata C, C++, SQL, PL/SQL, COBOL, JAVA, XML.
• Excellent exposure on the tools like Kintana, SVN, PVCS, MS Visual Source safe, MS-Project, Load Runner, SQL Assistance, Remedy, Power Builder, Win runner, Test Director8.0, Eclipse, JDeveloper.
• Hands on exposure in design using AIM and Agile methodologies.

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Lead Oracle EBS Technical Consultant

Responsibilities:

• Successfully managing a team of 20 members and responsible for project delivery from onshore. Playing an important role in interacting with the clients to understand the project requirements and various issues pertaining to the project.
• Preparation of Business Requirement documents, demonstration of Prototypes to the end users and getting the User sign-off for designing the end product.
• Prepared technical design documents for RICE components as per business requirements.
• Developed the RICE components for: Bill Trust Commercial and Regular Invoice Programs, External ATP Calculation Program, Ship confirm interface program, EBS to CSE Purchase Orders Program, Sales Order Acknowledge/Returns Report, WIP Attributes extract program, Soft Goods Form development, Parent Child workflow changes, Sales Order Form personalization’s.
• Tuned the complex interfaces: Cricket delivery interface, B2B External ATP extract, Refco Item Update program, Star item description update program and AR Invoice pre processer program by generating and analyzing the trace files in making the programs to execute faster and more efficiently.
• Prepared Test Plans and executed the work products to ensure proper functionality, data accuracy, and that modifications have no adverse impact on integrated system environment as per the business expectations.
• Provided technical & functional solutions in Oracle Applications modules and custom developments, for the issues raised by business.
• Collaborating with the team members to communicate the requirements of the project as well as guiding them in the execution. Supporting all team members in understanding the business requirements for effective deliverables.
• Responsible in performing the system and integration testing for all deliverables, to analyze the adequacy and applicability of the system output.
• JP rollout, involved with study of existing system, preparing the extraction template documents and Conversion Mapping Documents to convert data from legacy systems to R12.

Environment: Oracle Applications R12, SCM Modules, Oracle 10g, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX.

Confidential

Lead Oracle EBS Technical Consultant

Responsibilities:

• Analyze the existing system, and provide custom solutions to meet the client’s business requirements. Work with the end user for functional enhancements & application interface development and delivery.
• Involved in understanding the existing system, preparing the transition documents for the custom objects in Oracle Application modules in Finance, iExpense, iProcurement, HRMS, Payroll and legacy applications.
• Prepared Technical Specifications for the custom objects as per the functional and business needs.
• Based on the end user requirements, provided technical & functional solutions in the areas of Oracle Applications Finance modules and custom developments.
• Developed the RICE components for: AP Invoice Interface, AR Rectification Extract Claims, Yodel expenses extract, Thomson benefit upload, Pensions Audit Extract Program, Multicurrency Payments Program, Claims Set-up Form, Foreign Receipts Interface, Requisition Interface.
• Prepared Test Plans and executed the work products to ensure proper functionality, data accuracy, and that modifications have no adverse impact on integrated system environment as per the business expectations.
• Part of R12 upgrade, provided the solution in integrating the custom applications: Merchandise Payment System to Accounts Payables and Yodel System to HRMS in R12.
• Developed the OAF pages as a part of R12 upgrade, Employee Bonus Payable Form, Group Scheme Setup Form, Bonus Protection Form.
• Responsible for system testing to all enhancements to analyze the adequacy and applicability of the system output.
• Manage the client expectations, deliverables, and production support and ensure smooth interactions between onshore and offshore team members.

Environment: Oracle Applications R12, SCM Modules, Oracle 10g, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX.

Confidential, MA

Lead Oracle EBS Technical Consultant

Responsibilities:

• Involved with study of existing system, preparing the extraction template documents and Conversion Mapping Documents (CV40) to convert data from existing 10.7 and legacy systems to R12.
• Prepared Technical Specification (MD070) documents for conversion, interface components as per business requirements.
• Preparation of Customization Requirement Specification (CRS), demonstration of Prototype to the end Users and getting the User sign-off.
• Designed and Developed below RICE components: Conversion of Item Master, Item Org Assignment, Item Revisions, Item Category Assignments and Standard Cost. Conversion of Item Spanish Description from legacy system to R12. Conversion of UDA’s at PIM level. Forecast Interface from legacy system to R12. Conversion of Customer History and Notes information from legacy system to R12 Advanced Collections Module. Item Cost comparison Report. Update Salesrep defaulting rule at Sales order lines.
• Involved in fine tuning on the SQL and PL/SQL objects, making the programs to execute faster and more efficiently.
• Used SQL trace files in the tuning process, performance testing results were shared with the performance team and the scripts behind the transactions were optimized.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse impact on integrated system environment as per the business expectations. Responsible for delivering and implementing the objects as per the business requirements.

Environment: Oracle Applications R12.1.1, PIM (Product Data Hub), Advanced Collections, Forecasting and I-Payments, Oracle 10g, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Rational Clear case Clear Quest, RPM and Promopack.

Confidential, CA

Senior Oracle EBS Technical Consultant

Responsibilities:

• Involved with study of existing system, preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from existing system into open interface tables.
• Designed, documented Functional (MD050), Technical Specification (MD070) documents for existing components and developed interfaces as per business requirements.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL to import the data into staging tables.
• Designed and developed custom interfaces for Conversion of Historical and Incremental Sourcing data. Conversion of Historical and Incremental Costing data. Weekly demand interface.
• Developed various Custom reports, Customized existing reports according to the functional specifications including weekly demand report, costing report and sourcing reports by channel and by customer.
• Did tuning on the SQL and PL/SQL, making the Procedures runs faster and more efficiently. Used SQL trace files in the tuning process.
• Used Oracle's optimizer and monitored how it chooses and execution path/plan for the procedures. Performance testing results were shared with the performance team and the scripts behind the transactions were optimized.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse impact on integrated system environment.
• Prepared UAT plan for all the components and executed as per the business needs. Responsible for delivering and implementing the objects as per specifications.

Environment: Oracle Applications 11i (11.5.10/11.5.8 ), Oracle Sourcing, BOM, Costing, Oracle 9i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Kintana, PVCS, BO, and SQL Assistance.

Confidential, CA

Senior Oracle EBS Technical Consultant and Project Manager

Responsibilities:

• Responsible for analysis of the Requirements by interacting with the business users and understanding the process flow of the system.
• Preparation of Customization Requirement Specification (CRS), demonstration of Prototype to the Users and getting the User sign-off.
• Designed Functional (MD050), Technical Specification (MD070) documents for new components as per business requirements and getting the user sign-off.
• Prepared functional and technical specifications for the below process and shared the same to the team. Order Import process, Shop floor process, Pick release process, WIP Process, Invoice Creation, Inventory Program.
• Fulfilled the above process, by developing the custom forms, custom reports, interfaces and packages/procedures.
• Preparing Unit Test Cases, Unit Test Plans, User Acceptance Test Plans and Test Cases, Setup Document, Code Review Document and responsible for the obtaining user acceptances.
• Coordinating with the performance testing team for obtaining optimized testing results. Worked extensively in Order to Cash cycle.
• Ensured the objects are delivered as per the customer standards. Implemented the Project successfully without any deviations as per the schedule.
• Providing post-delivery support for objects which are released in this phase while simultaneously working on the enhancements.

Environment: Oracle Applications 11i (11.5.8), OM, AR, AP, AOL, SysAdmin, Forms 6i, Reports 6i, Oracle 9i (SQL, PLSQL), SQL*Loader, Toad8.6, Kintana, PVCS, and UNIX.

Confidential, CA

Senior Oracle EBS Technical Consultant and Project Manager

Responsibilities:

• Analysis of the Requirements by interacting with the business users and E&Y auditors. Identified the key conflicts as per the E&Y standards.
• Worked as a Team Leader to develop EXCISE modules to meet the statutory and business requirements.
• Preparation of Customization Requirement Specification (CRS), demonstration of Prototype to the Users and getting the User sign-off.
• Developed SQL script to fetch responsibilities that are assigned to a user, menus and sub menus which are attached to a responsibility.
• Prepared custom request groups to assign it to conflict responsibilities. Identified the conflict forms and disabled or enabled the functions/buttons or adding the new functionalities as per the business requirements using the forms personalization.
• Prepared test plans for UAT and responsible for getting the user acceptance for those setups. AOL set up like registering or excluding the Executables, Concurrent Programs in the assigned Request Groups or Responsibilities in Version 11.0.3 and 11i.
• Developed a new SOD tool in 11i oracle applications using forms 6i and reports 6i to identify the key conflicts for the upcoming.

Environment: Oracle Applications 11i (11.5.8/11.0.3 ), OM, AR, AP, PA, PO, AOL, SysAdmin, Forms 6i, Reports 6i, Oracle 9i (SQL, PLSQL), SQL*Loader, Toad8.6, Kintana, PVCS, and UNIX.

Confidential, CA

Senior Oracle EBS Technical Consultant

Responsibilities:

• Analyzed the Requirements in enhancements by interacting with the business user. Designed Functional (MD050), Technical Specification (MD070) documents for new components as per business requirements for sales order shipment status.
• Developed and modified the existing Interface for the Standard Items of Sales Orders Import in OM. Design and Developed a new interface program of sales order shipment status to show the current order status to the customer/end user. Developed custom ship confirmation interface.
• Developed reports for the Manufacturing, and financial modules according to the business needs. Worked on the Open Invoices Interface in the AP Module.
• Developed a new custom form to show the errors to business user during the invoice creation. Worked in AOL (Application Object Library), which involves Registering Reports, Forms, Procedures and Concurrent Programs, etc.
• Responsible for Unit Testing and User Acceptance Testing for the modified objects.

Environment: Oracle APPS 11.0.3, UNIX, Oracle 8.0(SQL, PLSQL), Reports 2.5, Forms 4.5, TOAD, AR, AP, OM, BOM, WIP, PVCS, Kintana, AOL, SysAdmin.

Confidential, CA

Senior Oracle Applications Technical Consultant

Responsibilities:

• Provided 24X7 customer support by resolving client’s day to day technical issues. The daily issues could be like expediting the workflow, unable to logon to oracle apps, managing apps user responsibilities.
• Involved in Post-production support of Oracle Manufacturing Applications using PO, BOM, and INV. Involved in simulation of errors, solving the Bugs, Resolving the Issues in PO, BOM, INV modules and working with ORACLE SUPPORT regarding TAR (Technical Assistance Request).
• Designed and developed complete Vendor interface for import of vendor information into the system. Created SQL*Loader file to import Vendor information into interface tables and, created PL/SQL program to validate and insert successful data into base tables.
• Design and development of importing BOM data from Legacy system to Oracle through Open BOM Interface. This process includes loading data from flat file to temp table using the SQL * Loader, validated the temp table data and moved to the Interface table. Used the concurrent program to update the Production table.
• Used performance-tuning tools like SQL Trace and Explain Plan to tune the queries. Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support.

Environment: Oracle APPS (11.5.8/ 11.0.3/ 10.7 ), UNIX, Oracle 8.0(SQL, PLSQL), Reports 6i/2.5, Forms 6i/4.5, TOAD, PO, OM, BOM, WIP, PVCS, Kintana, AOL, SysAdmin.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Involved in upgrade Oracle Applications upgrading from release 11.0.3 to 11.5.8. Created Technical Design Documents (TDD) and wrote interfaces for Customer Data creation using TCA API’s (AR).
• Designed Technical Specification (MD070) documents for new components as per business requirements and getting the user sign-off.
• Created Tables, Views, Synonyms, Sequences and Indexes as per the requirements. Designed and developed complete Vendor interface for import of vendor information into the system.
• Created SQL*Loader file to import Vendor information into interface tables and, created PL/SQL program to validate and insert successful data into custom tables.
• Developed new forms using TEMPLATE.fmb and customized the existing forms as per the business needs.
• Developed a custom error maintenance form to view and correct the failure records of customer creation interface process.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse impact on integrated system environment.
• Worked in AOL (Application Object Library), which involves Registering Reports, Forms, Procedures and Concurrent Programs, etc.
• Performance testing results were shared with the groups and the scripts behind the transactions were optimized.

Environment: Oracle Applications 11i (11.5.8/11.0.3 ), OM, AR, AOL, SysAdmin, Forms 6i, Reports 6i, Oracle 9i (SQL, PLSQL), SQL*Loader, Toad8.6, Kintana, PVCS, UNIX, and Test Director.

Oracle Consultant

Responsibilities:

• Analyzed the existing system and gathered requirements by interacting with the onsite coordinator. Design and preparing the technical specifications of the system for proposed system changes.
• Worked on development of forms, reports and shell scripts. Worked on developing PL/SQL packages, procedures and functions.
• Worked on developing triggers as per the DB design and did documentation for all the assigned work. Interacting with coworkers and helping them join the business process.
• Co-developed programs and responsible for testing. Ensuring the quality standards in the processes. Prepared integration test plan and responsible for testing and implementation.

Environment: Reports 2.5/6i, Forms 4.5/6i, Oracle 8i (SQL, PLSQL), SQL Plus, TOAD, MS Visual Source safe, Win runner, Windows 2000, and UNIX.