SUMMARY

• Having 9+ years of diversified IT experience in Oracle applications Implementation, Development, support and upgrade projects.
• Experienced in preparing User Scripts, User Manuals, test scripts and provide User training
• Running Integration testing with other modules and verifying test results with other modules.
• Extensive experience in Analysis, Design, Preparation of Specification, Development, Testing, Implementation and Production Support of Oracle EBS Applications 11.5.10.2/9 and R12.1.3.
• Expertise in analyzing business requirements as a part of implementation projects and provided extensive functional support for Post - Production Support projects in SCM of Oracle Applications R12
• Extensive knowledge in Oracle EBS Distribution Modules including Inventory (INV), Order Management (OM), Purchasing (PO)
• Experienced in all aspects of Business Requirement Gathering, Business Process Analysis, Mapping, Fit/Gap analysis, System Requirement Specification set up, and Interfaces to non-oracle applications, Test Scenarios set up, Business System Testing, User training and Support.
• Hands on experience in creating and maintaining Oracle AIM (Application Implementation Methodology) documents such as MD-050, RD-020, BR-100 (Expertise in Analysis, design and documentation of client’s business requirements)
• Experience in working on cross functional modules in the environment of Order-to-Cash (O2C) and Procure-to-Pay (P2P) cycles.
• Hands on experience in development of inbound interfaces flat file to Oracle Applications Environment tables.
• Good exposure on design and development of RICE Components and involved in implementation and support projects.
• Good understanding on functional flows Order 2Cash, Procure 2Pay and technical architecture of R12 - INV, PO, BOM, WIP, AP, AR, Shipping and OM.
• Hands on Experience of Upgrade from 11i to Release 12.1.3
• Worked on the development of Template based reporting tool like XML Publisher and Discoverer.
• Good experience on PL/SQL programming.
• Experience in preparing Functional Design Documents like MD050, TE020.
• Experience in Customization of Standard Oracle Workflows.
• Experience in New Form development.
• Strong experience in ALERTS, AOL, SYSADMIN and experience in tools like Oracle D2k, PL/SQL Developer, Forms 6i/10g, Reports 6i/10g, Oracle10g/11g under Windows XP/2007
• Expertise in development of Multi-Layout and Multi-org report and customization of oracle standard reports using report builder 10g.
• Good in understanding of user requirements, converting into Functional Documents (MD50’S), technical specifications (MD70’S), statements of problems to detailed logical flow charts for coding into Oracle applications.
• Developed inbound and Outbound interfaces using SQL*Loader, UTL FILE and PL/SQL Packages.
• Has extensive hands-on experience in developing database triggers, stored procedures, functions and packages.
• Developed Interfaces using APIs and Interface tables.
• Experience in interacting with clients while being responsible for deliverables and ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries.
• Experience in Using Version control tools CVS, PVCS and tools like ZOHO, HPQC and Kintana
• Documentation experience, keeping in line with the AIM Methodology.

TECHNICAL SKILLS

Modules: SCM, Manufacturing and Finance

Domain: Oracle EBS Suite Applications R12.1.X, 11i Ver11.5.10.2 Modules (INV, PO, BOM, WIP, WSH, AP, AR, GL and OM) and P2P and O2C cycles.

Operating System: Solaris, Linux

Languages: SQL, PL/SQL, Shell Scripting and UNIX

Tools: /DB/Packages: Application Object Library, SYSADMIN, Forms Personalization, Reports 10g/9i/6i, Forms 10g/9i/6i, Oracle BI Publisher, SQL*Plus, SQL* Loader, Toad, Oracle SQL Developer, PVCS

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Techno-Functional Developer

Responsibilities:

• Responsible for the tracking of all issues and prioritize depending on the key business areas and time sensitive process constraints
• Working with Business leads in Resolving Production related issues of high priority.
• Process Flow Testing for Purchasing and Order Management Modules
• Monitoring the status of the Issues Logged and follow-up for its resolution.
• Analyze of existing business processes
• Requirements Gathering, Data Migration, Extensive work on RICE components that include Reports (RDF and XML Publisher), Conversions, Interfaces (using standard API’s), Customizations, Data Mapping, Technical Design, Code/Script Development, issues resolution, Performance Tuning, Documentation (AIM).
• Upgraded Custom forms from 11.5.10 to Release 12.1.3 version.
• Upgraded more than 40 reports of Oracle Applications from 11. .1.3
• Worked on the standard Purchasing reports like Printed Purchase Order report and Purchase Price Variance Reports and created the custom reports based on the client requirement.
• As part of unit testing of P2P cycle, have done testing of Purchasing and Payables modules components to see that transactions are created properly and the correct entries are created in General Ledgers.
• Worked on Item Conversion and Supplier Conversion.
• Developed Technical design, Unit Test Plan, Installation and Load Plan Documents.
• Developed and modified several custom packages according to the business needs.
• Customized several existing reports to have additional features.
• Developed new RDF reports and also XML publisher reports.
• Developed new application Alert based on the requirement.
• Developed new form in the custom Module
• Prepare MD070 and MD050 for the SR’s.
• Preparing Unit Test Documents.
• Customized the existing forms as per the business requirement.
• Created the shell scripts to migrate the developed objects across the instances.
• Created form personalization as per the business requirement.
• Have done Unit Test plan Execution.
• Part of maintenance Team delivered simple, complex & very complex Models.
• Developed complex shell script program calling PL SQL from shell scripts.
• Helped the team in solving critical issues.

Environment: Oracle Apps R12 - OM, INV, PO, BOM, WIP, AP, AR, GL, Cash Register and P2P cycle, SQL Developer, Oracle Reports, Oracle Forms, XML Publisher, SQL, PL/SQL.

Confidential

Techno-Functional Lead

Responsibilities:

• Gathering the business data requirement from the client and mapping them with the Oracle functionalities
• Performed AS-IS Analysis for setups and identified GAP’s
• Improving the process gaps and suggesting best practices.
• Communicated with business team frequently to get the approvals for requirements proposed
• Responsible for developing and maintaining documentations like BR-100
• Responsible for all RICEW deliverables.
• Gathering requirements and preparing MD 70 and TE20 and MD120 documents.
• Identified the impacted objects during this Upgrade.
• Migrated more than 30 reports from EBS Applications Ver11i to R12.1.3
• Customized Print Purchase Order report.
• Customized the PO, Requisition Workflows.
• Upgraded around 10 Discoverer reports.
• Involved in performance tuning of SQL queries
• Worked on retrofitting of the 11i reports and packages of AP and AR applications as part of upgrade.
• Analyzing the requirements and discuss with Functional users and prepare Technical documents.
• Gathering requirements from client and based on our understanding prepare and understanding document, later a Functional document is prepared based on this.
• Assigning tasks to the team members and coordinate with them in timely delivery of the objects.
• Upgraded the existing reports and forms and PL/SQL code from 11i toR12.1.3 instance.
• Review of functional documents for technical feasibility.
• Created new Discoverer workbooks based on Client requirement.
• Preparing technical designs as per AIM methodology and development of code, preparing Unit Test Scripts documents, issue resolution.
• Preparing Unit Test Documents.
• Unit Test Execution of the deliverables to see that its working as per the requirement.
• Prepared the Cut over plan for GO-Live and taken the Responsibilities to move all the CEMLI objects to PROD

Environment: Oracle Apps R12 - OM, INV, WHS, PO modules, XML Publisher, SQL, Forms, Reports, PL/SQL, Oracle Discoverer 4, Oracle Workflow.

Confidential

Techno-Functional Consultant

Responsibilities:

• Approved Supplier List, Employees, Jobs, Approval Groups, Approval assignments, Document Types
• Tested the move orders and sub inventory transfer functions
• Setting up of inventory parameters and receiving options
• Process Flow Testing for Purchasing and Order Management Modules
• Monitoring the status of the Issues Logged and follow-up for its resolution.
• Analyze of existing business processes
• Analyzed the EBS Applications 11i tables which are going to be modified in the R12.
• Retrofitted (changing the columns which are obsolete in 11i to R12) views In R12
• Created UNIX scripts to migrate the objects from one instance to other.
• Performance tuning of the views.
• Involved in converting Oracle Standard Reports into XML Reports.
• Creating Data Definitions, Template in Oracle XML Publisher Administrator.
• Involved in Creation of Testing Documents like TE20 document.
• Involved in Creation of Installation Documents like MD120 document
• Involved in Unit Testing of the objects developed.
• Done the end-to-end testing of the P2P and O2C cycle of the retrofitted components as part of Upgrade to R12 applications.
• Responsible for Creation of Technical Design Documents (TDD).
• Involved in registration of various AOL objects Functions, Value set, Concurrent programs.
• Designed and Developed necessary feeder system i.e. staging tables, validation routines using SQL* Loader, SQL and PL/SQL procedures
• Involved in development of Purchase Document Open Interface.
• Prepared Build Notes and Unit Test Scripts for the respective objects.

Environment: Oracle Apps R12 - OM, INV, PO, AP and AR modules and also P2P and O2C cycles, XML Publisher, SQL, and PL/SQL.

Confidential, Boston, MA

Techno-Functional Developer

Responsibilities:

• Analyzed business requirements & performed Gap Analysis to map user requirements to oracle apps functionality & performed prototyping of “To Be” business process flows
• Defined inventories, sub inventories and Shipping Networks.
• Setting up of Document types, buyer, supplier and approved supplier list in purchasing module
• Prepared training materials to the business users
• Setting up of complete order cycle setups from order entry in order management to ship confirm in shipping execution
• Providing support for objects in Oracle SCM and Finance Modules
• Designed and developed custom conversions - Item Categories Conversion and Item Conversion.
• Updated the Technical Design Documents as per the changes made.
• Closely interacting with the users by providing resolution to the issues raised.
• Created Host Program which will send out an email of the output file to end users.
• Working closely with the DBA Team while moving the code to production.
• Involved in the supporting the interface between SAP and Oracle for the Purchase orders.
• Created many new concurrent programs to automate the process.
• Involved in functional setting up of approval hierarchy for Purchase Orders.
• Developed stored procedures and packages. Extensive experience in PL/SQL coding.
• Worked with development of packages and procedures using PL/SQL.
• Closely interacting with the users by providing updates day by day on the issues.
• Customization and development of reports Order Management module.
• Created various new value sets as per customer requirement.
• Customization and development of reports Purchasing module.
• Loading the data from external files to temporary table by using SQL*Loader, validated the data and then inserted the resulted data in the Inventory base table.
• Involved in required functional setups and form personalization.
• Reviewing the progress of issues with Project Manager.
• Involved in client discussions and gathered information directly with client.
• Responsible for User Accepting testing (UAT), Functional testing and System testing.
• Supported system for 24/7 basis if required.
• Understanding Functional Design and get the clarification, preparing technical design document based on AIM methodology standards.
• Developed reports using XML Publisher and also converted some standard reports to XML reports.
• Developed new reports in Oracle R12 using 10g report builder.
• Reviewing functional specification and get clarifications from onsite, Preparing technical specification, Coding and unit testing, preparing documents like UTP and installation instructions.
• Proposing solutions for the requirements and Involving in status calls.
• Registered Concurrent Programs and custom Applications using System Administration.
• Developed many reports for retail, distribution and supply chain modules in version R12.
• Test the developed code as per the cases given in FDD and fixing bugs.
• Designed MD070, TE20 and developed the code to meet the client’s requirements MD120, for extracting the correct data to meet the client requirements.
• Worked extensively in XMLP reports.
• Preparing Unit Test Plan and Installation Documents.

Environment: Oracle Apps R12 - INV, PO, OM, AP, AR and GL modules and also P2P cycle, Oracle Reports, XML Publisher, SQL, PL/SQL.

Confidential, Hamilton, NJ

Technical Consultant

Responsibilities:

• Involved in Technical designing, development and Installation documents
• Created Technical Design for Conversion, Interfaces and Reports
• Involved in developing Inbound and Outbound Interfaces.
• Responsible in developing Item Extract (Outbound Interface).
• Responsible in developing Requisition Import Interface.
• As part of support and enhancement used to fix all the issues in P2P cycle.
• Designed and Developed necessary feeder system i.e. staging tables, validation routines using SQL* Loader, SQL and PL/SQL procedures
• Involved in converting Oracle Standard Reports into XML Reports.
• Creating Data Definitions, Template in Oracle XML Publisher Administrator.
• Involved in Creation of Testing Documents like TE20 document.
• Involved in Creation of Installation Documents like MD120 document
• Involved in Unit Testing of the objects developed.
• Responsible for Creation of Technical Design Documents(TDD)
• Involved in design and development of Oracle XML Publisher Reports.

Environment: Oracle Apps R12 - INV, OM, PO, AP, AR, Procure to Pay cycle, SQL, PLSQL, TOAD and SQL*Plus.

Confidential

Technical Developer

Responsibilities:

• Worked on Item Conversion.
• Handling issues related Interfaces.
• Worked on AP Supplier Inbound Interface.
• Extensively used AOL for registering concurrent programs, Value Sets, Flex fields creating users and assigning responsibilities to end users.
• Involved in developing PL/SQL Packages, Stored Procedures and Functions.
• Involved in migrating the objects from one instance to other instances.
• Involved in converting Oracle Standard Reports into XML Reports.
• Creating Data Definitions, Template in Oracle XML Publisher Administrator.
• Involved in Creation of Testing Documents like TE20 document.
• Involved in Creation of Installation Documents like MD120 document
• Involved in Unit Testing of the objects developed.
• Responsible for Creation of Technical Design Documents (TDD).
• Interacted with the end users and functional architects to meet the requirement.

Environment: Oracle Apps R12 - AP, AR, SQL, PL/SQL, TOAD, Winscp, Putty and SQL*Plus.

Confidential

Technical Developer

Responsibilities:

• Analyzing the requirements.
• Regular meetings with the business users.
• Gathering requirements and preparing MD 50, MD 70.
• Worked on PO Conversion.
• Preparing Solution Design Documents for the developments.
• Interacting with clients to get the requirements and support activities.
• Involved in regular Support Activities.
• Involved in Unit Testing of the developed objects.
• Responsible in developing Sales Order Interface using the Standard API’s.
• Involved in design and development of Oracle 6i Reports.
• Designed and developed several PL/SQL packages.
• Data Extraction on request raised by end user.
• Interacted with the end users to meet the requirements.

Environment: Oracle Apps 11i - INV, PO, OM, AP, AR, SQL, PLSQL, TOAD, Winscp, and SQL*Plus and Putty.