Relevant Experience

• Senior Oracle Apps Consultant with 10 years of experience in designing, developing, converting, implementing and customizing of Oracle Applications Oracle E Business Suite .
• Skills Inventory
• Extensive experience in General Ledger GL , Account Receivables AR , Account payables AP , Fixed Assets FA , Inventory INV , Order Management, iProcurement, iSupplier, Purchasing PO and Core HRMS modules
• Good knowledge of Order to Cash OTC , Procure to Pay P2P Business Flows, R12 Suppliers Architecture and CDH Customer Data Hub
• Successfully completed 3 Full life cycles projects with Oracle Applications 11i 11.5.10 and rich experience in R12 12.1.3 and 12.1.1
• Experienced in new implementation from legacy systems to Oracle EBS and have very good experience in Oracle API's
• Expertise in Design and Development of Interfaces and Conversion programs to import data from various sources into Oracle Applications
• Adept at development and customization of RICEFW Reports, Interfaces, Conversions, Extensions, Forms and Workflows objects
• Extensive experience in developing reports using XML/BI publisher 5.6.3/5.6.2, Reports 10g/6i/2.5 and Discoverer 10g/4i
• Experienced in registering PL/SQL procedures, Reports, Forms, XML/BI Reports, and SQL Loader scripts as concurrent programs in the Oracle Applications
• Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL Loader scripts, ODI Oracle Data Integrator
• Experience in SQL Loader, UTL FILE, Oracle Import/Export utilities, SQL Navigator, UNIX Shell scripting and Kintana.
• Experience in Oracle SOA Suite 11g and Oracle Service Bus.
• Experience in web services, ESB, SOAP, WSDL, BPEL, XML and XSD.
• Hands-on experience working with Data base adapters.
• Working knowledge on SOA Implementations involving Web Services using SOAP, WSDL and XML technologies XML, XSD, XSLT, XPath Oracle JDeveloper.
• Experience Installing and Configuring BPEL 10.1.3.4 on Oracle Application Server.
• Familiar with Oracle Applications Framework OAF technology, especially with personalization of existing OA Framework pages
• Have good experience on onshore/offshore model, working and interacting with business users, requirement gathering, writing BR documents, and Gap analysis, Functional Designs, Technical Designs and Test Scripts
• Adept at creating technical reference guides, user manuals and other related Agile, etc.

CHRONOLOGICAL SUMMARY of Experience

Oracle Apps Senior Technical Consultant

Confidential

• Create, Modify and test the, forms and script that allows the Oracle ERP applications to run.
• Responsible for gathering the requirements and preparing the XSD Schema files, worked on XSL, technologies.
• Architected the frame works like Notification, Error Handler and logging frame works in Oracle SOA Suite.
• Developed BPEL flows using File Adapter, Database Adapter.
• Developed XSLTs using Oracle seeded functions for string formats, date formats.

Developed SOA to EBs Interface:

• Below are the service calls which are being used in SOA as DB adapter.
• Customer Accounts
• Customer Address
• Customer Contacts/ Contacts Information
• Customer Receipt Methods
• Customer Credit Cards
• Customer Bank Accounts
• Developed AR Customer Conversion using CDH Customer Data Hub model.
• Developed AP Supplier Conversion using TCA model.
• Developed OPM Routing Conversion.
• Developed OPM Quality Specs Conversion.
• Developed OPM Quality Tests Conversion.
• Developed OPM Recipe Conversion.
• Developed below BI Reports using seeded data model.
• AP Check Printing Report
• AR Invoice Report
• Pack Slip Report
• Pick Slip Report
• Bill of Lading
• Developed OPM Master Formula Report.

Environment: Oracle Applications 12.1.3 OTC, AR, OPM , SQL, PL/SQL, Oracle 11g, XML/BI Publisher, ODI, SQL Loader, Shell Script, TOAD, SOA 11.1.1.7.0, OSB 11.1.1.7.0, Oracle WebLogic 11g, Enterprise Manager 11g, JDeveloper 11g, Oracle BPEL Process Manager 11g, BPEL, App Adapter, DB Adapter, SOAPUI

Oracle Apps Senior Technical Consultant

Confidential

• Used SQL Loader and UTL FILE for loading data into the interface tables.
• Utilized Oracle's Application Implementation Method AIM approach, and documented the process using the recommended AIM documentation
• Involved in writing UNIX Shell Scripts for moving and copying files from server to client and from client to server.
• Developed an interface program to convert the Payables AP invoice data from other source to Oracle Payables using Invoice Import Program.
• GL JE BATCHES, GL JE HEADERS and GL JE LINES base tables using journal import concurrent program tables and then created Journal Entries to upload budgets into General Ledger GL .
• Developed an interface program to Import Journals to load data from custom tables to
• Involved in creating Month End Revenue Report, which makes the remarkable impact on month end close of Yahoo . This report provides the data into excel sheet with multiple tabs.
• Converted old discoverer reports to BI reports.
• Worked on the Auto Invoice Interface program to create invoices into AR.
• This project includes enhancements and customizing the Oracle EBS including the process improvements, automation, reports XML Publisher/ Discoverer/ RDF and interface programs and as per the user and business requirements.
• Created AR Receipts interface to convert data from other source to Oracle.
• Worked on Custom API to add new Suppliers, Update either Supplier site address or Supplier name and Delete Deactivate Supplier.
• Designed INBOUND and OUTBOUND interfaces.
• Involved in creating BI reports time to time for PWC Audit.
• Developed conversion program to create vendor/ vendor sites/ vendor bank details.
• Changed the manual process and automate the system, earlier manual transactions being performed in AR for Non-CAM related transactions. Currently for Non-CAM transactions like GAMES or MOBILEs in TW, the transactions are loaded using a CSV file directly to AR. The billing team does not have a single interface or report to check all these transaction details loaded in a batch. The change request is to route these transactions through an Invoice workbench.
• Developed PO interface to import Purchase Orders from other system.
• Developed an interface program which handles the Yahoo Inventory and keep track of items are present in Warehouse.
• Apart from projects and other activity, I worked on tickets which are the primary objective of the role.
• Wrote PL/SQL packages for different validations, for processing data in order to create valid POs and for populating the PO interface tables and called the seeded import programs to populate the base tables.
• Responsible for daily status to manager about the progress of the project.
• Unit testing of all objects that includes flows of the system and set with business User for UAT.
• Experienced in using the performance tuning methods like TKPROF, Explain plan, Trace and indexes.
• Used SCRUM master and AGILE methodology

Environment: Oracle Applications 11.5.10 GL, AP, AR, PO, FA, iProcurement , SQL, PL/SQL, Oracle 11g, XML/BI Publisher, Reports 10g, Discoverer, Forms 10g/4.5, SQL Loader, Shell Script, TOAD.

Oracle Apps Technical Consultant

Confidential

Clients

Confidential

• This project was to implement Oracle HRMS R12 12.1.3 .
• My primary role was to set with business user and understand their Legacy System.
• Developed CV040 with business user to make sure that requirement is correct.
• Involved in daily stand up meeting with Toyota team regarding the status of the project and discuss about the project hurdles if any.
• Responsible for data migration.
• Responsible for delivery of all the objects built for this project.
• End to end testing for each objects created by technical team.
• Developed employee conversion program using standard API.
• Developed employee assignments conversion program using standard API.
• Developed employee extra information and SIT using standard APIs.
• Utilized Oracle's Application Implementation Method AIM approach, and documented the process using the recommended AIM documentation
• Provide solution both technically and functionally.
• Prepared a design document and get it signed off from the business users.
• UAT with Business Users
• Responsible for verifying technical design documents created by technical team.

Environment: Oracle Applications 12.1.3 Core HRMS , Oracle 11g, SQL, PL/SQL, SQL Loader, Shell Script, TOAD.

Confidential

• This project is to Upgrade/ Customization in R12 includes 130 CEMIL's out of which I have worked on 21 CEMLI's.
• Developed an Interface Program which does following:
• Create Employee
• Update Employee
• Terminate Employee
• Create Assignment
• Update Assignment
• Create Apps User
• Once User created then send the notification to that particular user with login details
• Assign the responsibilities to a user who is newly created
• Delete Apps User
• Update Apps User
• Create Profile Options
• Create PO Agents
• Utilized Oracle's Application Implementation Method AIM approach, and documented the process using the recommended AIM documentation
• End to end testing for each object.
• Provide solution both technically and functionally.
• Involved in helping team member wherever technical help required.
• Prepared a Technical design document and get it signed off from the business users.
• Developed quite few XML Reports, out of which one report is based on i-Procurement. What report does: when user creates a requisition, as soon as he submit then concurrent program will launch and create a XML report and stored the report output into CLOB column. Based on the supplier country report output generate in respective language E.g. If Supplier is Chinese then report output will be in Chinese language, if supplier is Japanese then report output in Japanese format else all other languages for English.
• Developed PL/SQL stored procedures, functions and triggers Followed MD050 functional documents and designed the MD070 technical specifications, provided support for end users and documented the modifications.

Environment: Oracle Applications 12.1.3 i-Procurement, PO, HRMS, Supplier, Inventory Items , XML Publisher, Web ADI, Workflow, OAF 10.1.3, Oracle 11g, SQL, PL/SQL, SQL Loader, Shell Script, TOAD.

Confidential

• This project is to Migrate data from Legacy System to EBS R12.
• Involved in writing UNIX Shell Scripts for moving and copying files from server to client.
• Involved in creating HOST program will fetch CSV files from server and insert into custom table.
• Developed conversion program to convert the Payables AP invoice data from legacy system to Oracle Payables using Invoice Import Program.
• Developed item interface in inventory INV to import the item information from the legacy system into oracle inventory INV using parallel processing.
• Developed an Employee Assignment Conversion program using API HR ASSIGNMENT API.update emp asg criteria.
• Developed an Employee Extra Information Conversion program using API HR PERSON API.update person.
• Developed an Employee Assignment Extra Information Conversion program using API HR ASSIGNMENT EXTRA INFO API.
• Developed an interface program to Import Journals to load data from custom tables to GL JE BATCHES, GL JE HEADERS and GL JE LINES base tables using journal import concurrent program tables and then created Journal Entries to upload budgets into General Ledger GL .
• Utilized Oracle's Application Implementation Method AIM approach, and documented the process using the recommended AIM documentation.
• Developed PL/SQL stored procedures, functions and triggers.
• Followed CV 040 functional documents and designed the CV 060 technical specifications, provided support for end users and documented the modifications.

Environment: Oracle Applications 12.1.1 Core HRMS, GL Journals, GL Balances, AP Invoice, Inventory Items , Oracle 10g, SQL, PL/SQL, SQL Loader, Shell Script, TOAD.

Confidential

• This project is to Migrate data from Legacy System to EBS R12.
• Involved in writing UNIX Shell Scripts for moving and copying files from server to client.
• Involved in creating HOST program will fetch CSV files from server and insert into custom table.
• Developed an Employee Assignment Conversion program using API HR ASSIGNMENT API.update emp asg criteria.
• Developed an Employee Extra Information Conversion program using API HR PERSON API.update person.
• Developed an Employee Assignment Extra Information Conversion program using API HR ASSIGNMENT EXTRA INFO API.
• Developed an interface program to Import Journals to load data from custom tables to GL JE BATCHES, GL JE HEADERS and GL JE LINES base tables using journal import concurrent program tables and then created Journal Entries to upload budgets into General Ledger GL .
• Utilized Oracle's Application Implementation Method AIM approach, and documented the process using the recommended AIM documentation.
• Developed PL/SQL stored procedures, functions and triggers.
• Followed CV 040 functional documents and designed the CV 060 technical specifications, provided support for end users and documented the modifications.

Environment: Oracle Applications 12.1.1 GL Journals, Oracle HRMS includes Employee/

• Assignment/ Employee Extra Information/ Assignment Extra Information/ Schools
• Qualifications , Oracle 10g, SQL, PL/SQL, SQL Loader, Shell Script, TOAD

Confidential

• The requirement was to migrate with their legacy system to Oracle EBS R12. This project was purely based on the SCM objects.
• Involved in writing UNIX Shell Scripts for moving and copying files from server to client.
• Involved in creating HOST program will fetch CSV files from server and insert into custom table.
• Developed an interface program to create Supplier using Supplier API.
• Developed an interface program to create Item Costs using standard API.
• Developed an interface program to create Item Locators using standard API.
• Developed an interface program for Item Locator Assignments using standard API.
• Developed an interface program for Modifiers using standard API.
• Developed PO interface to import Purchase Orders from legacy systems
• Utilized Oracle's Application Implementation Method AIM approach, and documented the process using the recommended AIM documentation.
• Developed PL/SQL stored procedures, functions and triggers.
• Followed CV 040 functional documents and designed the CV 060 technical specifications, provided support for end users and documented the modifications.

Environment: Oracle Applications 12.1.1 Suppliers, Item Costs, Item Locators, Item Locator

• Assignments, Modifiers and Purchase Order , Oracle 10g, SQL, PL/SQL, SQL Loader, Shell Script,
• TOAD

Confidential

• The requirement was to implement with their legacy system to Oracle EBS R12.
• Involved in writing UNIX Shell Scripts for moving and copying files from server to client.
• Involved in creating HOST program will fetch CSV files from server and insert into custom table.
• Developed a conversion program for Oracle General Ledger using Standard Import.
• Developed a conversion program for Customer using Standard Import.
• Developed a conversion program for Suppliers using Standard Import.
• Developed PO interface to import Purchase Orders from legacy systems
• Utilized Oracle's Application Implementation Method AIM approach, and documented the process using the recommended AIM documentation.
• Developed PL/SQL stored procedures, functions and triggers.
• Followed CV 040 functional documents and designed the CV 060 technical specifications and TE 020 installation document for provided support for end users and documented the modifications.

Environment: Oracle Applications EBS R12 Suppliers, Purchase Orders, GL, Customers , Oracle10g, SQL, PL/SQL, SQL Loader, Shell Script, TOAD

Oracle Apps Technical Consultant

Confidential

• MFund-ISS process of designing a software application that considers the requirements of international users, an internationalized program should be able to be localized Converted for use with other languages without recompiling the application
• Requirement gathering from business users
• Writing the functional and technical designs based on the requirements
• Writing the code based on the functional designs
• Writing test scripts for the objects that are technically developed by me

Environment: Oracle Applications 11.5.0 Oracle CRM , Legacy System Finance , Oracle 10g, SQL, PL/SQL, SQL Loader, Shell Script, Report 6i, TOAD

Oracle Technical Consultant

Confidential

• IPOS application is a comprehensive management tool that incorporates all the documentation, operational controls and monitoring of a port's operations, it takes into account the requirements of all types of operation handled at MbPT Mumbai Port Trust . In addition, it provides various operations viz., IPOS.CTA, IPOS.RAIL, IPOS.MRN, IPOS.ORM, IPOS.EIS and IPOS.INV thus forming an integral part of the IPOS suite of modules.
• Requirement gathering from business users
• Writing the functional and technical designs based on the requirements
• Writing the code based on the functional designs
• Writing test scripts for the objects that are technically developed by me
• After successful implementation of IPOS in MbPT, 25 reports were pending from CMC which I have developed at client place.

Environment: Oracle 9i Developer 9i Forms 9i and Reports 9i , Container, Cargo

Oracle Technical Consultant

Confidential

• This system is an ERP system which is purely meant for Media Industry such as News Paper agencies
• Writing the functional and technical designs based on the requirements
• Requirement gathering from business users.
• Writing the code based on the functional designs
• Writing test scripts for the objects that are technically developed by me

Environment: Oracle 9i Developer 6i Forms 6i and Reports 6i , Circulation, Subscription

Got couple of time Top Performer Award from Oracle based on the client appreciation.