SUMMARY

• Around 8 years of experience in providing cost effective solutions in Oracle Domain.
• Experience in requirement gathering, analysis, solution design, development, implementation, set up, testing, customization, troubleshooting, maintenance, support, and data migration.
• Experienced and involved in functionality of Oracle Applications R12 modules such as Order Management, INV, Purchasing, Shipping, iProcurement and Technically Involved in Order Management, Inventory, Purchasing, iProcurement, Account Payables, Account Receivables, General Ledger, Service Contract, Advance Pricing and Project Accounting.
• Extensive experience with understanding the client requirement and preparation of Functional specification documents.
• Excellent customer management and experience with integrated value chains.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers, and other database objects using SQL and PL/SQL.
• Expertise in writing SQL and PL/SQL scripts to improve the Performance.
• Experience in generating Reports and registering concurrent programs/reports.
• Experience in generating Business Intelligence Report and Discoverer Reports.
• Experienced in designing Data Conversion programs both inbound and outbound to integrate Oracle Applications modules to import data from various sources using PL/SQL, SQL*Loader.
• Proficient in developing concurrent programs using SQL and PL/SQL.
• Highly skilled in developing and testing applications using Stored Procedures, Functions, Packages and Database Triggers.
• Experience in implementing Business cycles like Order to Cash (O2C), Procure to Pay (P2P) and Quote to Cash (Q2C) Cycles.
• Experience in utilizing standard Oracle API’s for conversion programs.
• Ability to communicate well at the user level and technical levels and to breakdown complex problems into manageable parts and develop alternative solutions
• Self - starter with potential, initiative and a positive attitude. Able to meet very stringent deadlines and always deliver the package
• Keen and enthusiastic with constant desire to learn and a commitment to excel.

TECHNICAL SKILLS

ORACLE ERP: Oracle Applications 11i and R12

FUNCTIONAL MODULES: Inventory, Order Management, iProcurement, Purchasing, Shipping, Advance Pricing.

TECHNICAL MODULES: INV, PO, OM, iPROCURMENT, AP, AR, GL, FA and PA

LANGUAGES: SQL, PL/SQL, SQL*PLUS.

OPERATING SYSTEMS: UNIX, MS-DOS, Windows95/NT/2000/XP and Linux.

SCRIPTING LANGUAGES: XML and HTML

TOOLS: /UTILITIES: SQL*Loader, Report Builder, BI Publishers, Workflow Builder, JDeveloper, PLSQL Developer, TOAD, SQL * Plus Meteor.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Oracle App SCM Functional Consultant

Responsibilities:

• Understanding the current Business process and preparation of As-Is documentation.
• Setup Configuration - BR100 Preparation & Mapping of Business Process by understating the user requirements.
• Worked on all the setups for the INV, AP, I-Procurement, Procurement Contracts, Purchasing for inbound and outbound transactions.
• Performed all the setups for the Quoting Module in relation to Order Management.
• Designed CV40 document for Account payable conversion and designed data migration templates based on user requirement.
• Conducting CRP 1 Testing and CRP 2 Testing to super users.
• Conducting UAT - End to End Integration testing
• Performing out the Production Setups.
• Post production support
• Functional Business Support, and resolving day-to-day critical issues.
• Coordinating with Technical team and taking Ownership in delivering the Components.
• Understanding of new tool like METEOR for conversion and designing the code accordingly.
• Troubling shooting programming issue, supporting Citrix related issues.
• Maintaining team work order sheet and handling the off-shore team.
• Designed RDF reports for Commercial invoices for the US region and supported production issues related with it.
• Worked on the Mass update change from standard error and provided the solution for the functionality.
• Worked on year ending process and SQL performance tuning.
• Handling Support related issue and designing release note and test related documents.
• Created MD70 for the new changes/Enhancements on AR Interfaces like BillTrust and O2C functionality like Interface Trip Stop Errors.
• Proficient in SQL tuning the packages, procedures and enhance the performance related issues in real time environment
• Worked on the XML Publisher reports of java concurrent program type related with PO and AP.
• Developed Conversion packages for Banks, Branches and Accounts.
• Coordinated the Offshore Development activities as a lead and played a Vital role in the code reviewing process, design and production support.
• Worked on the Documentation MD70 and Migration checklist activities.

Environment: Oracle 12.1.3 OM, INV, iProcurement, PO, AR, AP, modules, P2P, O2C, Q2C Forms6i, Reports 6i Oracle, XML Publisher, PL/SQL, WorkFlows, Stored Procedures, Windows95/NT.

Confidential, Tampa, FL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Team member of development team, involved in customizations of various Oracle manufacturing modules like Order Management, Inventory, PO, AP and AR.
• Worked on Order to cash O2C and Procure to Pay P2P and good knowledge on Quote to Cash Q2C.
• Involved in the complete life cycle of software development: Analysis, Design, Development, Testing and Implementation
• Have done Technical designs for conversion documents of AP, GL and PO modules.
• Extensive experience in technical specification design, development, unit testing Oracle e-business suite of Applications.
• Worked on the Custom Order organizer form to customize the Order fill % based on the reservation set.
• Worked on the production issues on Generic FTP Shell script to improve the performance.
• Created complex validation units based on Value Sets and list of values by creating various views and tables
• Created Value Sets and attaching those value sets to the value set name for the parameters of the report or PL/SQL Packages.
• Implementation of business specific custom programs by writing PL/SQL stored procedures.
• Created Custom forms for specific users and assigned those forms to their menus to restrict their accessibility
• Supported on Workflow issue for approval to increase the CEO time to maximum.
• Worked on AP Invoice Interface using WEBadi to transfer the data.
• Worked on Performance Issue like GL Account Analysis Report such as Profit and loss report and GL balances.
• Worked on the Work Order extraction and configuration of the custom club orders and the end to end process of Pick release and Ship confirmation.
• Defined concurrent program and assigned to request groups
• Created and register Tables in Oracle Application
• Developed custom XML reports using Report 6i for generating the orders that have got the invoices. Also, validated the date columns by writing PL SQL script in the value set at the front end
• Designed and developed numerous packages and procedures utilizing various seeded APIs to UPDATE task assignment status from one to other and also to load data from temporary tables into Oracle base table
• Created DB Triggers, Functions, Packages, Stored Procedures, Views, Sequences, Synonyms at the back end using SQL and PL/SQL

Environment: Oracle R12 OM, INV, PO modules, Reports 6i Oracle, XML Publisher, PL/SQL, Stored Procedures, Windows95/NT.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Developed Purchasing Analysis Report By vendor.
• Customized Physical Inventory Count Report.
• Developed Invoice Details Report.
• Developed Customer Related Invoices Report
• Developed PO Receipts Relation Report.
• Development of monthly Value of Work done (VOWD) Report.
• Development of Actual cost and budgets account and Report which gives detail report for Actuals and Budgets.
• Involved in Development of Interfaces.
• Registrations of Concurrent Programs and Executable.
• Development and Customization of Reports.
• Defining Value sets and Lookups.
• Provided Support to Rice Components.
• Developed item import interface.
• Developed AP Open Interface to Validate invoice data from legacy system into Oracle Apps base tables.
• Developed the purchase order interface to load the purchase order data from legacy system into oracle Apps TABLES.
• Developed new package to extract the data from Oracle project creation and work plan from staging table which need to migrate the data into Oracle primavera and then primavera to Oracle Project (vice-versa).
• Developed Technical documents and Release notes for every component migrated to Production Instance.

Environment: Oracle Apps Implementation Release 12 Modules: PA, AP, PO, INV, P2P cycle and SQL, PL-SQL, Reports 10g/6i, Putty, Winscp 3, Windows XP/2003.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in developing the BI Reports.
• Involved in developing the Inbound and outbound Interfaces.
• Registrations of Concurrent Programs and executable.
• Creation of Value sets in various Modules of the application.
• Preparation and Execution of unit test case.
• Developed Vendor Received Quantity report.
• Developed Invoice Payment Status Report.
• Developed Customers Shipment Details Report.
• Customized Credit Transfer Report.
• Developed GL Interface to upload data from legacy system into Oracle Apps PO base tables.
• Developed Item Upload Interface to upload data from legacy system into Oracle Apps INV base tables.
• Developed new Package to extract the Purchase order release details from Oracle PO base Tables into flat files by using UTL FILE.

Environment: Oracle Apps Release 11i (11.5.10.2), Modules: AP, PO, INV and SQL, PL-SQL, Reports 10g/6i, Putty, Winscp 3, Windows XP/2003 and UNIX Server.

Confidential

Oracle Apps Technical consultant

Responsibilities:

• Team member of development team, involved in customizations and Process flows in various Oracle ERP Modules like OM, PO, INV.
• Creation of Service Requests and diligently following with Oracle support for problem resolution.
• Actively participated in Defects resolutions.
• Raising & Tracking SR’s for weekly, Daily Migrations Refresh.
• Successfully Prepared Remigration Builds of different instances with no issues.
• Checked log reports & Took immediate action for all types of issues.
• Actively participated in client interaction and meetings.
• Maintained Quality Centre up to date for all Migrations & Remigrations Successfully
• Developed reports for printing invoices sent to various customers for cross verification purpose.
• Created PL/SQL View and Materialized views for the Price Book Generation.
• Generated Error File as Excel Sheet and send it to the appropriate Email through PL/SQL package concurrent program.
• Preparing the Solution Design documents and Technical Design documents
• Testing all the application and PL/SQL components for providing quality assurance and various kinds of hints and outer joins.
• Tuning all the application components for better performance and throughput.
• Worked on 24/7 environment (baseball and Christmas leaves)

Environment: Oracle Apps Implementation Release 11i (11.5.10.2), Modules: AP, GL, PO, INV,P2P cycle and SQL, PL-SQL, Reports 10g/6i, Putty, Winscp 3, Windows XP/2003 and UNIX Server.