SUMMARY

• 3.8 years of experience in Oracle Applications 11i, R12 involved in the areas of Implementation, Migration, support, development as well as customization of RICE Components.
• A competent professional working with Path InfoTech Ltd. having nearly around 3 years experience as Oracle Apps Techno Functional Consultant.
• Worked on development and customization of Oracle Apps RICE Components, API’s and TCA (Trading Community Architecture).
• Extensively worked on Procure to Pay and Order to Cash (P2P & O2C).
• Strong knowledge in Multi - Org.
• Extensively experienced in Development of Interfaces and Conversions to validate and load data from legacy and feeder system to Oracle applications.
• Proficient in Programming Using PL/SQL, Reports 6i,10g, Oracle 9i,10g,11g and Experience in Importing Information into Oracle Applications through SQL* Loader .
• Having Experience in building D2k reports (RDF) and XML Reports and Discoverer Reports.
• Extensive Technical skills in the area of Business User Interaction, Requirement Gathering, Application Development, Application Support and Customizations of software applications in Client-server, database and enterprise software environments.

AREA OF EXPERTISE:

Primary Skills: Oracle EBS R12, 11i (PO, INV, AR, OM, GL, AP, AOL)

Development Tools: Discoverer (4i), XML/BI Publisher, Report Builder10g, 6i.

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

Database Connectivity: Toad, PLSQL Developer, SQL * Loader, Winscp, Putty.

Operating Systems: Microsoft Windows

PROFESSIONAL EXPERIENCE

Oracle EBS

Confidential

Responsibilities:

• Create Java Based Web-ADI in which attached Lov are dependent on Prior columns. Use these Lov templates in Item loading Interface and AR Invoice Creating Interface.
• Interfaces Design: Develop Interfaces like AR Invoice Interface, AP Invoice Uploading Interface, Item Loading Interface from scratch: creating Staging tables, Do WEB-ADI Setup to create templates so dat user can download the template, select the some columns from lov and upload records.
• Worked on UTL SMPT API to send mail to the user on the Report output.
• Worked on Discoverer Administrator and Discoverer Desktop to create various reports and modification of existing reports.
• Reports Development: Developed RDF and PL/SQL Reports from Scratch and Customizing Oracle Standard Reports using report builder 10g and registered reports in Oracle Applications for various modules.
• Developed PL/SQL procedures, functions and packages used in the creation of Interfaces and Reports.
• Modify and create PL/Sql Procedures, Triggers and Packages as part of Implementation and Production support requirement.
• Migrate Table and Independent type of Value Sets as per requirement.
• Develop various DFF’s and enable DFF’s in the forms to capture extra information in the forms.
• Reviewing the progress of issues with Project Manager.

Confidential

Oracle EBS 12.1.3 Migration

Responsibilities:

• Modify and create PL/Sql Procedures, Triggers and Packages as part of Implementation and Production support requirement.
• Reports Development: Developed RDF and PL/SQL Reports from Scratch and Customizing Oracle Standard Reports using report builder 10g and registered reports in Oracle Applications for various modules.
• Developed PL/SQL procedures, functions and packages used in the creation of Interfaces and Reports.
• Requirement Gathering for Reports and AOL components useful for migration to Oracle Applications R-12.
• Creation of Control files for SQL*Loader to load data from text files.
• Writing SQL queries to fetch data from database.
• Developed XML Reports using BI Publisher.
• Developed Discoverer Reports using Oracle discoverer.
• Multi-Org: Familiar of Multi-Org Environment.
• Query Tuning to avoid performance issues.
• Managing data in Excel sheets.
• Developed Check Printing Reports.
• Involved in client discussions and gatheird information directly with client.
• Reviewing the progress of issues with Project Manager
• Migrate all custom Objects From 11i to R12.
• Migrate all Custom objects Data from 11i to R12 with Mapping.

Confidential

Oracle EBS 12.1.3 Implementation

Responsibilities:

• Developed various stored procedures, functions, packages and triggers using Oracle PL/SQL in multiple projects.
• Worked on AIM Methodology.
• Functional knowledge of AP to GL and AR to GL cycle.
• Worked on Reports (Discoverer Reports & XML Publisher & Self Service Report).
• Worked on SQL Loader.
• Worked on Discoverer Administrator and Discoverer Desktop to create various reports and modification of existing reports.
• Working on Finance Modules (Understanding the requirement, prepare understanding document, prepared technical design document, preparing test cases and UAT).
• Modify and create PL/SQLl Procedures, Triggers and Packages as part of Implementation and Production support requirement.
• Working on Interface as Vendor loading, invoice loading interface, Item loading interface, supplier loading interface and various issues for Ticketing Tools like Request for Change and Information Management as per business application user requirement and preparing Technical documents for them.

Confidential

Oracle EBS 12.1.1 Migration

Responsibilities:

• Developed various Interfaces to transfer data from legacy system to Oracle Base Tables using SQL*Loader and checked data validation by creating PL/SQL package.
• Developed Ad-hoc reports using PL/SQL according to client requirements.
• Defining Concurrent programs, Executables.
• Creation of Value sets, Flex fields for all modules and done Registration of Reports, PLSQL Stored Procedures and SQL*Loader files.
• Reports Development: Developed RDF and XML Reports from Scratch and Customized Oracle Standard Reports using report builder 10G and BI Publisher respectively and Registered reports in Oracle Applications for various modules like PO, AP, INV
• Developed PL/SQL procedures, functions and packages used in the creation of Interfaces and Reports.
• Creation of Control files for SQL*Loader to load data from text files.
• Writing SQL queries to fetch data from database.
• Developed XML Reports using BI Publisher.
• Developed Discoverer Reports using Oracle discoverer.
• Multi-Org: Familiar of Multi-Org Environment.
• Query Tuning to avoid performance issues.Managing data in Excel sheets.
• Create various Reports as customer Balance sheet Report, Payables report as payment voucher report, Prepayment Detail Report, Account Analysts Report and Customised Trial Balance Report.
• Created Table and Independent type of Value Sets as per requirement.
• Develop various DFF’s and enable DFF’s in the forms to capture extra information in the forms.
• As a functional consultant, responsible for studying the business process identifying the scope of the enhancements based on the user requirements.
• As a functional consultant, responsible for studying the business process identifying the scope of the enhancements based on the user requirements.
• Create AP voucher Report, Payment Voucher Report, Item Detail Report
• Customer Conversion: load customer, accounts, sites, profiles, org contacts, contact points with tax profile, tax exemptions, GL Accounts, Account Relationships and Customer attachments for multiple organizations in implementation to successfully transfer all the Sales Order and Customer information from legacy system to Oracle Apps.
• Developed inbound interfaces.
• Involved in client discussions and gatheird information directly with client.
• Reviewing the progress of issues with Project Manager.
• Multi-Org: Familiar of Multi-Org Environment.
• Query Tuning to avoid performance issues.
• Academia:
• B.E. (Information Technology) from Dronacharya College of Engineering, (M.D. University), Haryana.