SUMMARY:

• 10 years of proven experience in Oracle E - Business Suite (R12, 11i) involved implementation, Upgrade, Enhancement, Support projects including requirements gathering, analysis, process mapping, solution design, unit and functional testing for Fortune clients like Xerox corporation, Boeing, Fisher Scientific International Inc, Jacmel Jewelry and Tektronix Inc.
• Extensively worked on Implementation, Enhancements, Support as well as Upgrade Projects in Supply Chain, CRM and Oracle Financial modules.
• Excellent Techno-functional knowledge in Order to Cash, Procure to pay and contract to cash in CRM modules.
• Expertise in working with end-users for support, troubleshooting and giving effective & efficient resolutions for the technical & Functional issues.
• Experience in Requirements gathering, functional gap analysis, architectural design, interfaces design, process data-flow design and preparation of System Design documents (SDDs), various module initial setups, test script generation and execution, preparation of training guides, training end users, and production support.
• Experience working with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• In depth knowledge about Oracle apps data flow and data model for P2P, O2C and CRM areas including Order Management, Purchasing, Inventory,Service contracts, Install Base and Application Object Library Modules.
• Worked as a technical consultant in Oracle Application including functional modules Account Payables, Account Receivables, Cash Management, PO, GL and Order Management and AR modules.
• Extensive experience in developing Oracle backend objects like Database Triggers, Stored Procedures, Functions, Cursors, and Packages using PL/SQL and Workflow customizations.
• Experience in various development tools like PL/SQL Developer, Toad,SQL*Loader, Oracle 10g/9i, Forms 10g/6i, Reports 10g/6i.workflow builder etc.
• Experience in developing UNIX Shell scripts for loading data into staging tables.
• Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace and Oracle hints etc
• Expertise in understanding, Modifying and development of RICE components, proficiency in Design, develop, deploy, test and maintain technical objects that exist in Oracle applications environment which includes forms, reports, interfaces, conversions and custom applications extensions.
• Good experience on Form Personalization, Performance Tuning, XML Publisher Reports and Oracle BI Publisher Reports.
• Provide customer support for business critical application problems and issues, Assist with testing and deployment of solutions in production environment. Proactively work through service requests with vendor support as needed.
• Having working knowledge on workflows,ADF, BPEL and SOA architecture.
• Create process flows, high level functional and detailed technical design specifications from business requirements as well as test plans and test scenarios using AIM Methodology (Application Implementation Methodology).
• Having Good Communication, Self Motivated and Inter Personal Skills., organize multiple tasks to meet schedules and deadlines.

TECHNICAL SKILLS:

Technical: Strong Technical knowledge of Oracle e-Business suite R12/11i Order to Cash, Procure to pay and CRM modules in developing of RICE (Forms, Reports, Interfaces and Conversions) Components, SQL, PL/SQL, Forms, Reports, Workflows, Form Personalization,ADF, XML, and Oracle BI Publisher Reports.

Functional: Excellent Techno-functional knowledge in Order to Cash, Procure to pay and Finance Modules

Tools Used: TOAD, Putty, Data Loader, PL SQL Developer, BI Publisher, SSH client, Forms 6i, Reports 6i, Forms 10g, Workflow builder 2.0, RCS Menu, MKS Integrity, ITT (Integrated Ticket Tracking System)

Methods: Software Development Life Cycle (SDLC), Product Life Cycle Management (PLM) Application and Oracle AIM Methodology(Application Implementation Methodology)

Management Experience: Worked as Technical Consultant, Techno Functional Consultant, Module lead and Onsite coordinator with offshore team on multiple project activities.

PROFESSIONAL EXPERIENCE

Confidential

Sr.Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked with Business Systems Analysts/Designers to identify and research new functionality required to meet business users’ needs.
• To analyze Business Requirement and provide solution using Oracle Apps E-Business Suite. Checking the feasibility of the requirement and prepare System requirement document (SRD).
• Developed customization of OTS Supplier Outbound Interface for SOA Integration Projects from ERP.
• Developed customization of OTS Invoice Outbound transactions Interface for SOA Integration Projects from ERP.
• Troubleshooting of problems related to delivered Oracle E-Business solutions and interaction with business users. Provided techno-functional solution as needed.
• Conducting requirements walk through to understand requirements properly and for getting required clarifications. Preparing solution design documents based on system requirement documents
• Preparing technical design document based on system design documents.
• To ensure quality deliverables will review design/code through walkthroughs within the team before giving to functional or user acceptance testing.

Environment: Oracle e-Business Suite 12.1.3Special Software: Oracle Apps R12,PL/SQL Developer, Toad,SOA, Oracle Forms, Oracle Reports, Data Loader, SQL loader, SSH client,, MKS Integrity

Confidential

Sr.Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked with Business Systems Analysts/Designers to identify and research new functionality required to meet business users’ needs.
• To analyze Business Requirement and provide solution using Oracle Apps E-Business Suite. Checking the feasibility of the requirement and prepare System requirement document (SRD).
• Developed shell program to FTP files to outbound server and reading inbound files into GSCB system
• Developed critical BI reports and scheduled so that users can receive email reports data in a required format
• Developed forecast split report in Oracle that provides split for WO quantity based on Forecast split by location.
• Worked on supplier entry form customizations in GSCB oracle apps environment.
• Troubleshooting of problems related to delivered Oracle E-Business solutions and interaction with business users. Provided techno-functional solution as needed.
• Conducting requirements walk through to understand requirements properly and for getting required clarifications. Preparing solution design documents based on system requirement documents
• Preparing technical design document based on system design documents.
• To ensure quality deliverables will review design/code through walkthroughs within the team before giving to functional or user acceptance testing.
• Coordinating with offshore team for tracking the project related activities and preparing weekly reports and communicating with the Xerox GSCB Team.
• To develop custom components like forms, reports and interfaces Workflow customizations as per the System Requirement Document and System Design Documents.

Environment: Oracle e-Business Suite 12.1.3, Advanced Supply Chain Planning instance

Special Software: Oracle Apps R12,PL/SQL Developer, Toad,Oracle Workflows, Oracle Forms, Oracle Reports, Data Loader, SQL loader, SSH client,, MKS Integrity

Confidential

Sr.Oracle Apps Techno Functional Consultant

Responsibilities

• Perform impact analysis feasibility study of all existing PE’s/customizations in DMO application before start the upgrade process.
• Ensuring that DMO XBRA and XMEX current functionality works as-is after upgrade
• Reviewed oracle documents to capture all pre-upgrade steps and activities for DMO system.
• Identification of required change controls for R12 upgrade and prepare new System Requirement Documents (SRD’s)
• Understanding technical upgrade process, Compiled an inventory of custom apps, third party apps, interfaces, custom reports, customizations/extensions etc
• Involved in technical upgrade like Concurrent custom reports had to be re-compiled and executed using Oracle Developer Tools 10g XML reports were updated and executed in BI Publisher.
• Technical upgrade of all forms were re-compiled and executed in Oracle Developer Tools 10g. Moved custom and customized forms to correct directory (new APPL TOP) on the R12 EBS Application server.
• Modified the existing old performance test cases to fit for R12 upgrade functionality
• Performed a technical upgrade which includes Reports, forms, interfaces and various customizations during R12 upgrade.
• Updating solution design documents and technical design documents after upgrading.
• To ensure quality deliverables during technical upgrade, will review design/code through walkthroughs within the team before giving to functional or user acceptance testing.
• Coordinate with functional areas to ensure minimal or no interruption to support critical business needs during R12 upgrade.

Environment: Oracle e-Business Suite 12.1.3, Oracle Data base 11g, Sun Solaris Platform.

Special Software: Oracle Apps R12,PL/SQL Developer, Toad,Oracle Workflows, Oracle Forms, Oracle Reports, Data Loader, SQL loader, SSH client,, MKS Integrity

Confidential

Sr.Oracle Apps Techno Functional Consultant

Responsibilities

• To analyze Business Requirement and provide solution using Oracle Apps E-Business Suite. Checking the feasibility of the requirement and prepare System requirement document (SRD).
• Developed shell program to FTP files to outbound server and reading inbound files into DMO environment.
• Developed an interface program that loads all the Equipment’s and Accessory Items for Xerox Mexico.
• Developed XBRA Orders follow up report for DMO Brazil
• Developed Link Sales order-Move order-Job order from for DMO Mexico
• Developed customization XMEX Warranty Update Information for Equipment in Install base module.
• Developed Purchase Order interface to bring external po’s into ERP.
• Developed the complete automatic contract creation process from Order Management using APIs.
• Worked on several workflow customizations
• Conducting requirements walk through to understand requirements properly and for getting required clarifications.
• Preparing solution design documents based on system requirement documents
• Preparing technical design document based on system design documents.
• To ensure quality deliverables will review design/code through walkthroughs within the team before giving to functional or user acceptance testing.
• To develop custom components like forms, reports and interfaces Workflow customizations as per the System Requirement Document and System Design Documents.

Environment: Oracle e-Business Suite 11.5.10, Oracle Data base 10g, Sun Solaris Platform.

Special Software: Oracle Apps 11i,PL/SQL Developer, Toad,Oracle Workflows, Oracle Forms, Oracle Reports, Data Loader, SQL loader, SSH client,, MKS Integrity

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities

• Studying business requirements and all the customizations required for implementing IMM Application.
• As a Techno Functional consultant responsible for creating multiple conversions to support client's migration from a legacy system to Oracle ERP suite of applications including Purchasing, Inventory, and Order Management.
• Created Shell script program to call the SQL loader program that transfers data in data file to staging table and runs the custom concurrent program to transfer data from staging table to interface tables.
• Responsible for developing Mass Update of Item Attributes process is used for mass update of Item Attributes as desired by the users at both the Organization and Sub-inventory levels
• Developed customization of inter-warehouse Transfer will be used to transfer move orders from one Subinventory to another Subinventory in GAIN Applications
• To develop custom components like forms, reports and interfaces Workflow customizations as per the System Requirement Document and System Design Documents.
• Involved in Development and enhancement of GAIN applications like TE, PDMS and Forecast.
• Design and Development of Technical Specifications (MD70) based on functional Specifications(MD50), Preparation of Unit Test Cases (TE30) and Installation (MD120) Documents.

Environment: Oracle e-Business Suite 11.5.9, Oracle Data base 9i.

Special Software: Oracle Apps 11i,PL/SQL Developer, Toad,Oracle Workflows, Oracle Forms, Oracle Reports, Data Loader, SQL loader and Putty

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Understanding technical upgrade process. Compiled and executed number of forms, interfaces, custom reports, customizations/extensions etc
• Involved in technical upgrade like Concurrent custom reports had to be re-compiled and executed using Oracle reports and forms.
• Modified the existing old performance test cases to fit for new upgrade functionality
• Performed a technical upgrade which includes Reports, forms, interfaces and various customizations during upgrade process.
• Involved in Form personalization.
• Tuned the reports to improve performance during upgrade process.
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands.
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes in upgrade.
• Updating MD70 documents after upgrade based on MD50 documents.

Environment: Oracle e-Business Suite 11.5.10.

Special Software: Oracle Applications 11.5.10(INV, OM, AR), Oracle PL/SQL, Forms 6i, Reports 6i, Toad, Oracle 9i

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Worked as a Member of the Production support system to address day to day issues in the system
• Everyday Production Support activities, Troubleshooting of problems related to delivered Oracle E-Business solutions and interaction with business users. Provided techno-functional solution as needed.
• Responsible for managing help desk ticket reports and monitoring progress and resolution withOracle Support to log and resolve SRs.
• Monitor of various jobs and batch processes and resolving the issues and providing beeper support
• Performed application tuning, tuned SQL Scripts using Optimizer Hints, Explain Plan, SQL Trace & TKPROF and Packages / Stored Procedures
• Worked on the OM-Sales Order interface that enabled the user to import a Sales Order from any external system into Oracle Applications, wherein the data from the external system was available as a flat file and imported into Oracle Applications through several steps with proper validations
• Experience includes supporting application system administration activities such as user setup, defining responsibilities, value sets, flex fields, data groups and request groups, registering applications,, forms, reports, concurrent programs, providing support to apps users for any technical and functional day to day issues.
• Modifying the Technical design documents (MD70) and test case documents required for the project during production support.

Environment: Oracle e-Business Suite 11.5.9

Special Software: Oracle Application 11.5.9, Oracle PL/SQL, Forms 6i, Reports 6i, Toad, Oracle Pl/SQl Developer, Oracle 9i

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Understanding technical upgrade process. As a technical I have involved number of oracle reports upgrade from Reports3i to Reports6i.
• Modifying the existing reports which includes replacing old tables from 11.03 to new tables 11.5.10 and compile the reports and moved to new environment.
• Modified the existing old performance test cases to fit for new upgrade functionality
• Performed a technical upgrade which includes Reports, interfaces and various customizations during upgrade process.
• Worked technical upgrade of various reports such as the AP Vendor Trail Balance report, AP Check Code Combination report, Regional Exploited ATB report, and GL-AP Journal report
• Tuned the reports to improve performance during upgrade process.
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands.
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes in upgrade.
• Updating MD70 documents after upgrade based on MD50 documents.

Environment: Oracle e-Business Suite 11.5.10