Professional Summary:

• Around 9 years in years of IT experience in Requirement Analysis, Development, Implementation, Testing and Extensions of Oracle Applications R12, 11i in the Financial and Supply Chain modules.
• Functional and technical expertise in the modules of GL, AP, AR, OM, INV.
• Expertise in Procure to Pay and Order to Cash full life cycle implementation.
• Proficient in interfaces and conversions between modules through interface tables and APIs using SQL*loader, PL/SQL procedures to transfer data from Legacy systems to Oracle base tables.
• Expertise in SQL and PL/SQL programming, proficient in writing stored procedures, functions, packages and triggers.
• Expert in developing and customizing reports using Oracle Reports 10g/6i.
• Extensive experience on Testing on Oracle EBS
• Expert in Customizing the Oracle Application through Form Personalization and Custom.pll.
• Implementation and Customization of Oracle Applications 11i with good Technical Development skills in developing RICE (Reports, Interfaces, Conversions, and Extensions) components in the domain of Oracle Applications E-Business Suite.
• Good experience on Procure-to-Pay, Order-to-Cash
• Expertise on AIM Methodology, TCA and Multi org access control process.
• Good Knowledge on functional and technical knowledge of oracle SOA, BPEL Design and DOO (Distributed Order Orchestration), Shell Scripting.
• Excellent working knowledge in the area of Oracle 10g, Oracle 9i, Oracle 8i, Reports6i, and Developer/2000.
• Knowledge in Oracle Application Framework, Workflow Builder of Oracle Applications.
• Proven ability to conceptualize, design and implement solutions in Performance Tuning.
• Experience in reviewing the Functional Documents and preparing and modifying the Technical Design Document for the development work done like MD50, MD70
• Adaptability to any new business environment. Excellent team player and excellent communication and inter-personal skills.
• Good experience in migration tools - Kintana, Clearcase (Version Controlling).
• Good experience in support tools - HPQC, Remedy, and Bugzilla.

Technical Skills:

ERP

Oracle Applications R12 and 11i modules of Oracle Financials, Supply Chain Management and Technical Modules (Application Object Library, System Administrator). Order to cash, Procure to Pay

RDBMS and Reporting Tools

Oracle 11g, 10g, 9i, 8i, Reports6i, Forms 6i.

Operating Systems

Windows 98/NT/Server, Windows 7, UNIX

Technical Skills

SQL, PL/SQL, Work Flow, BPEL, SOA, JDeveloper , OAF, DOO

Database Tools

TOAD, SQL Developer, SQL * Loader, Data Loader, UTL file, HPQC, Kintana, Clearcase, Bugzilla.

Education:

• Diploma in Management in Information Technology.
• Bachelor of Engineering in Information Technology.
• Diploma in Computer Science.

Professional Experience:

Confidential, Pittsburgh, USA
Oracle Apps Techno-Functional Consultant
Phase: Development / Production support / Testing
June 2011 - Till Now

Description: Confidential, is a diversified power management company providing energy-efficient solutions. Eaton is a global technology leader in electrical components, systems and services for power quality, distribution and control. I worked in the implementation and post production support for OM, INV, PO, AR and AP.

Responsibilities:

• Requirement gathering and solution designing for implementing the design of processing Sales Order from Oracle to SAP and final receiving of data from SAP to Oracle after shipment.
• Tested all the scenarios of booking the order in oracle SAP SOA
• Testing the ATO and Non-ATO items
• Testing of orders in different type of holds ( invoicing, shipping, credit check)
• Organized and managed Business user acceptance testing (UAT) and Business Solution Walk-Thru Demo's in coordination with Analysts
• Overlooked the progress of Manual and Automation testing using QTP
• Executed test cases, test scripts, maintained test results and test data, logged and tracked defects in HP Quality center.
• Prepared QA test plans & strategy documents
• Organized and managed Business user acceptance testing (UAT) and Business Solution Walk-Thru Demo's in coordination with Analysts
• Worked on designing and developing a solution for making specific segments of a DFF as read only.
• Developed the interface for cancelling the Sales Order in oracle with the integration to SAP.
• Worked on designing and developing a process for booking a Sales Order in bulk and trigger the information from Oracle to SAP.
• Worked on solution to send a sales order update after changing the ship to address in case of Partial shipment.
• Worked on the designing of Web services for integrating two ERPS (oracle and SAP).
• Worked on the design and development of lock/unlock interface which is used for locking a sales order in SAP before allowing the user to make any change in Oracle.
• Developed workflows in different modules like PO approval, AP Invoices.
• Worked on the process design and development for globally purging data from custom tables.
• Performed End to End testing while delivering Procure to pay cycle during UAT across the modules AP, PO.
• Analyzed the changes in financial custom reports and interfaces for upgrading the same to R12 XML reports such as check printing and Separate Remittance Advice report and sending the same as PDF attachment in email.
• Designed and developed a report on cancelled lines with PO details where such PO has receipts made against any of lines.
• Developed Report on cancelled lines with PO details where such PO has receipts made against any of the lines.
• Wrote control file using Unix Script to load Open AP Invoices into Temporary Table and PL/SQL stored procedure to validate and load into Interface Tables and run Payables Open Interface Import Concurrent Program.
• Worked on personalizing the Oracle Application through Form Personalization and Custom.pll.
• Worked on the designing and developing an approach for handling an issue of deadlocking while processing the response received from SAP in Oracle.
• Developed a Super User form which was used for defining the specific roles to a user with specific period of time.
• Developed a Configuration form for defining the custom configuration in the system.
• Worked with different teams (SOA, SAP) in resolving an issue of handling a sales order having large number of lines.
• Deploying the components in UAT and Production with the help of Clearcase and Kintana.
• Defining the business rules and alerts in the Oracle System.
• Worked on debugging production issues of booking a sales order and shipment.
• Defining concurrent programs, executable, forms, request set, values set.
• Worked on the enhancement of Postal Code changes for splitting the tax code in zip code and populate the tax code in PostalPlus4Code from EBS to SAP.
• Deployment of SOA composites.
• DOO server configuration for deploying the EFF in DOO composites- MDS Sync up, Export and Import of MDS.
• Worked on establishing the connectivity between EBS SOA DOO SOA SAP.

Environment: Oracle Applications 11.5.10 Financials (AP, AR), Purchasing Modules (PO), Supply Chain Modules (OM, INV), SQL, PL/SQL, TOAD, Oracle D2K (Forms and Reports), Oracle Jdeveloper, SOA Workbench, DOO Workbench.

Confidential, Santa Clara, US
Jun'2010 - May'2011
Phase: Development / Production support
Oracle Techno-Functional Consultant

Description: Confidential, is the manufacturer of test and measurement devices such as oscilloscopes, logic analyzer and video and mobile test protocol equipment. They used the Oracle Application 11.5.10 for booking the Order and creating the Customer invoices and integrating with General Ledger. This project involved in the Customization of Reports and development of Interfaces for importing the Orders from Legacy system to Oracle and finally booking and customer invoicing.

Responsibilities:

• Worked with the end user and FA's for requirement gathering and solution designing.
• Designed interface for Journal data upload in oracle General Ledger.
• Worked on mapping of account code values for Varian (Agilent's subsidiary) and Agilent's Chart of Accounts for journal data interface.
• Developed customized report for Journal reconciliation and error report for data validation error.
• Prepared the MD070 for all customizations.
• Worked on debugging production issues of importing a Journal data.
• Defining concurrent programs, executable, forms, request set, values set.
• Worked on the design and approach to correct the customer addresses in production environment.
• Developed an interface to load the new customers in Oracle application.

Environment: Oracle Applications 11.5.10 Financials (GL, AR), SQL, PL/SQL, TOAD, Oracle D2K (Forms and Reports).

Confidential, Santa Clara, USA
Oracle Techno-Functional Consultant
Phase: Re-designing / customization
Aug 2009 - May 2010

Description: Confidential, is the manufacturer of test and measurement devices such as oscilloscopes, logic analyzer and video and mobile test protocol equipment. They used the Oracle Application 11.5.10 for booking the Order and creating the Customer invoices. This project involved in the Customization of Reports and development of Interfaces for importing the Orders from Legacy system to Oracle and finally booking and customer invoicing.

Responsibilities:

• Re-Designed Customer and Item interfaces in terms of merging the two interfaces into one without hampering the existing functionality.
• Support the third parties (boundary application teams) in testing the Fusion interfaces from Oracle Apps end.
• Customized the code for removing the duplicate tables from the database.
• Defining concurrent programs, executable, forms, request set, values set.
• Prepared the MD070 for all customizations corresponding to removal of duplicate tables as well as re-designing of Item and Customer Interfaces.
• Worked in UAT/Post Go Live Support for the business.

Environment: Oracle Applications 11.5.10 Financials (AR), Supply chain Module (INV), SQL, PL/SQL, TOAD, Oracle D2K (Forms and Reports).

Confidential, Bhopal, India
Oracle Apps Techno - Functional Consultant
Apr'2009 - Jul'2009

Description: MP Electricity board is the Government Company and provider of electricity in MP state of India. They also manufactured the electric appliances like transformers, generators etc. They implemented Oracle Application R12 for capturing the information about the goods purchased and sale to the customer.

Responsibilities:

• Prepared the AS-IS process document for Finance Modules (AP, CM and FA).
• Prepared the User training document for AP, CM and FA.
• PO Workflow modification to pick approvers based on custom made rules, Timeout configuration on the PO workflow, developed Account generator Workflow for PO and requisition, Firing Auto Workflow events After AP invoices are imported. Developed a brand new Workflow for Material transfer custom Form. Setup Approval Management (AME) Rules for AP invoice approval.
• Have done technical designing for various components of conversions and interfaces.
• Finalized the design for various required Custom Oracle Reports.
• Finalized the requirement and design of the Custom Interfaces for AP, GL.

Environment: Oracle Applications R12 Financials (AP, PO, P2P, GL, FA, CM), SQL, PL/SQL, TOAD, Oracle D2K (Forms and Reports).

Confidential, Noida, India
Oracle Techno- Functional Consultant
Phase: Enhancement / Production support / Testing
Jun'2008 - Mar'2009

Description: Confidential, is the company manufacturing electronic appliances like Refrigerators, Invertors etc. They used Oracle Application ERP 11.5.10 system for intercompany transfer AP invoices and calculating the tax with the help of 3rd party tool Sabrix and finally making a payment to Vendors.

Responsibilities:

• Enhancement in the custom module of IBS to AP (used under the concept of Inter org Transfer Payment). Developed API for data migration from legacy to Oracle Apps for IBS to AP (Inter Org Module).
• Testing of third party tax implementation concept- SABRIX.
• Prepared the test result documents for AP interfaces.
• Prepared the invoice validation documents.
• Worked on Customization of Oracle Reports (11.5.10) as well as Oracle Forms
• Customized the oracle reports according to the requirement of client.
• Worked on the UNIX shell scripts for FTP.
• Testing of AP interfaces.
• Defining concurrent programs, executable, forms, request set, values set.
• Have done UAT/Post Go Live Support for the business.

Environment: Oracle Applications 11.5.10 Financials (AP), SQL, PL/SQL, TOAD, Oracle D2K (Forms and Reports).

Confidential, Delhi, India
Oracle Techno-Functional Consultant
Phase: Development / Production support / Testing
Sep'2007 - May'2008

Description: Confidential, is India\'s second largest cigarette maker. It is the number one cigarette company in North India and India\'s number one cigar marketing organization. I was involved in Implementation team right from information gathering for the requirement of Oracle needs.

Responsibilities:

• Worked on the concept of Form Personalization and made the changes in Oracle standard forms as per the client requirement.
• Techno-functional Analyst for oracle EBS Procure to Pay (P2P) modules
• Requirements gathering, Gap Analysis, functional testing, conducting CRPs, UAT and training of Procure to Pay solution for marketing department. This involves Requisition, PO, Release and AP Processes. It also involves custom processes for prior month accrual, negative accruals
• Designing and leading the development of Purchase Document Open Interface for Standard POs. Oracle purchasing previously allowed Blankets and Catalogs to be imported using open interface. I extended this feature to allow import of Standard Purchase Order.
• Once the customer creates a PO, the vendor could immediately see the PO online using PO acknowledgement and acknowledge it online. Vendor could change the promise date online using "Promise Date Change" feature.
• Designing and Coding "View Purchase Order flow".
• Supporting and Enhancing Requisition approval Workflow
• Supporting and Enhancing PO Approval workflow
• Developed new Oracle reports of AR, Inventory, AP, and PO along with the customization in the standard oracle reports.
• Performed requirement gathering for RICE components for AR, AP modules.
• Prepared the test documents for AR interfaces for Oracle Audit.
• Participated in doing the setups for AR, Inventory module.
• Partially involved in the setups of AR, AP and Inventory and presented the demo to the client.
• Prepared the documents for all customized objects like reports, forms and interfaces etc.
• Developed and tested for conversions and enhancements in PO, INV modules.
• Created value sets for various components in the modules of GL, AP, AR, PA, and PO.
• Used Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in the process of development.
• Implemented conversions scripts and developed Install Scripts for Code Movement.
• Done Sanity Testing after the code movement in Production Instance.
• Defining concurrent programs, executable, forms, request set, values set.
• Responsible for writing UNIX Shell scripts for automating tasks like FTP, Migration automation.
• Worked on personalizing the Oracle Application through Form Personalization and Custom.pll.

Environment: Oracle Applications 11.5.10 Financials (AP, FA, PO, P2P, AP, CM), Supply chain Modules (INV, PO), SQL, PL/SQL, TOAD, Oracle D2K (Forms and Reports).

Confidential, Noida, India
Sep'2005 - Aug'2007
Oracle Technical Consultant
Phase: Development / Testing

Description: Confidential, is the company to manufacture test and measurement devices such as oscilloscopes, logic analyzer and video and mobile test protocol equipment. They used the Oracle Application 11.5.10 for booking the Order and creating the Customer invoices. This project involved in the Customization of Reports and development of Interfaces for importing the Orders from Legacy system to Oracle and finally booking and customer invoicing.

Responsibilities:

• Developed new forms and customized the Oracle Forms of OM and Inventory modules.
• Added the new form functionality on new developed oracle forms like Zoom, Folder, and Row LOV etc.
• Prepared the test documents of Order Import Interface.
• Developed Order Import Interface and Form for showing Sales Order and shipping information together.
• Developed oracle reports and also converted RDF report into SQL and tab delimited reports.
• Creating staging tables and mapping data elements of functional specification with flat file fields.
• Creating value sets in various modules of the application.
• Defining Concurrent Programs, Executables, request sets and Request Groups.
• Involved in the development of interfaces.

Environment: Oracle Applications 11i (11.5.10), SQL, PL/SQL, TOAD, Oracle D2K (Forms and Reports).

Confidential, Noida, India
Oracle Technical Consultant
Jul'2005 - Aug'2005

Description: Confidential, is an airline company in Africa providing air-transport service globally. They used the Oracle ERP system for capturing the information about all flights take-off and landing.

Responsibilities:

• Defined concurrent programs, executables, Creation of responsibilities, request groups, values sets, and functions in System Administration and AOL.
• Developed and Registered Oracle Forms and Reports in applications environment.
• Customization of forms and reports.
• Developed couple of packages for populating the data according to the "FLIGHT" take-off and "FLIGHT" landing.

Environment: Oracle Applications 11i, SQL, PL/SQL, TOAD, Oracle D2K (Forms and Reports).

Projects Done:

Project: Library Management System
Jan'2005 - May'2005

Project Description:
The system was developed to maintain the books in the library. It captures the book details available in the library.

• The project involved auto generation of accession number based on the subject or magazine
• Generation of various reports like list of books to be returned on a particular day, books which are overdue and lost books
• On-line updating of number of books.
• It also provides an on-line query system to get information about availability of books.
• Capturing student information joining different courses and auto generation of student roll numbers based on the course and batch were also featured.
• Various reports like fee defaulters, student status and performance report were generated.
• It also provides on-line updating of student details. The system keeps track of student details and student transfers from one batch to another.

Project: Export Management System
Jul'2004 - Dec'2004

• Responsible for studying, designing, developing, testing and documenting the Export Management System.
• The Export Management System maintains details such as contracts, schedules, total quantities dispatched and outstanding quantities.
• Worked as a development team member in custom systems using Oracle RDBMS in areas like Order processing, Inventory, Quality Assurance.
• Designed and developed custom order Hold module, which allow defining holds, applying and releasing holds on Order, Order line, Customer, Item etc. Develop custom forms to define, apply and release holds. PL*SQL package procedures were used to do business validations as well as to populate necessary holds tables.
• Developed custom Item Entry form .Also designed and developed an item template to apply on every item for ease of data entry and standardization.
• Also developed custom forms for keeping internal records of QA Department and developed reports for vendor rating.

Environment: Oracle 5, Unix, SQL*Forms 2/2.3, SQL*Plus, Unix Shell.