SUMMARY:

• Over 10 years of implementation and Support experience in Oracle Applications R11i/ R12i.
• Excellent work experience on RICE Components.
• Having good knowledge on SQL, PL/SQL, SQL*Loader, BI Publisher.
• Excellent work experience on Dataware House Concepts (OBIEE & ODI )
• Worked extensively in Oracle Applications R12/11i implementation, enhancement & customization of various modules.
• Accounts Payables (AP)
• Accounts Receivables (AR)
• General Ledger (GL)
• Order Management (OM)
• Fixed Assets (FA)
• Cash Management (CM)
• Purchasing (PO)
• Oracle Inventory (INV)
• Project Accounting (PA)
• Bills of Material (BOM)
• Work in Process (WIP)
• Depot Repair(DR)
• Application Objects Library (AOL)
• EBS Tax
• MES
• Strong working knowledge of business flows like Order - to-Cash (OTC) and Procure-to-Pay (PTP) along with the dependencies and relationships between Oracle Applications modules.
• Expert level knowledge and experience in developing objects for implementation and upgrade in Oracle Applications.
• Oracle Complex Report Development
• Interfaces (OM,AR,GL,AP,PO,FA,CM,INV,BOM)
• XML Reports / BI Publisher
• Data Conversions in (AP, AR, GL, INV, OM, PO,BOM)
• Web ADI (Standard / Custom)
• Forms Personalization
• Work flow Development
• SQL Loader / Shell Scripting / Unix / PLSQL
• Involved in 4 complete system development life cycle projects having analytical skills necessary to satisfy development, testing documentation, and Change Management requirements.
• Worked in Upgrade project to Migrate Customizations, Reports using FNDLOAD.
• Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers views, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
• Expertise in Oracle Application Object Library (AOL) features like Value Sets, Flex Fields, Request Sets, Registering Menus, Reports, Concurrent Programs, Profile Options, parameters and standard request submissions in the process of development.
• Experienced in writing AIM Documents - MD050, MD70, CV040, CV60, MD120, TE020.
• Performed application settings, testing of business scenarios and user training.
• Good knowledge in using tools like TOAD, Edit plus, SQL Developer.
• Engaged in Testing of Technical Interface enhancements.
• Strong analytical, interpersonal and troubleshooting skills and ability to work in a fast-paced and team- oriented environment.
• Involved in giving training to new Associates.
• Highly efficient in working closely with Oracle support to resolve seeded application issues by creating and monitoring Oracle Service Requests (SR)

TECHNICAL SKILLS:

ERP: Oracle Applications Release 12, 11i

ERP Modules: GL, AP, AR, CM, FA, PA, INV, PO, OM

Oracle Technologies: BI Publisher, Web ADI, OBIEE, ODI

Databases: Oracle 10g

Languages: SQL, PL/SQL, XML

Tools: & IDEs TOAD, FTP, Data Loader, SQL*Loader, Developer suite 10g

Operating Systems: UNIX, Windows NT/XP/98/2000

PROFESSIONAL EXPERIENCE:

Confidential, CO

Techno Functional Consultant

• Involved in the Post Go-live support of Oracle Applications.
• Involved in the day to day production support activities.
• Involved in Designing XSL-XML Reports with multiple excel sheets.
• Designed a report to generate excel sheets dynamically.
• Involved in Designing Price Protection Reports.
• Worked on discrete Manufacturing (BOM, WIP) reports.
• Involved with Business in gathering requirements during the Functional requirement and the change control process
• Involved in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
• Developed PL/SQL package code for sending email with Summary data in email and extracted data as an attachment using the Oracle supplied package UTL SMTP.
• Developed customized Accounts Payable Trial Balance Report using BI Publisher.
• Loading the Data in Target Warehouse tables Using Process Flows and viewing Data in the Dashboards.
• Used X-query method in one of the report and developed Bursting Report.
• Customized BI Publisher reports such as Sales Invoice Report, Asset Tracking Report.
• Created various reports in EBTax for understanding the rate flow.
• Developed 2 levels of Matrix Report and used sub template, Data template BI Publisher Reports.
• Done the unit testing, TE20, MD120 preparation.
• Modified the standard reports according to the customized requirements.
• Designed and developed XML Publisher data template and Bursting Reports.
• Worked on migrating components using FNDLOAD

Confidential, Seattle, WA

Techno Functional Consultant

• Involved in the Implémentation and Post Go-live support of Oracle Applications.
• Involved in functional support in Order-to-Cash and Purchase-to-Pay modules.
• Worked on Discrete Manufacturing Reports.
• Involved in developing financial accounting hub (FAH) reports.
• Worked on Engineering, Inventory, Bills of Materials, Work in Process and MES, Oracle Alerts .
• Designed and developed a onetime script to cancel the high volume of sales orders in OM.
• Involved in various extensions in Order Management & Purchasing.
• Developed Customized Project Accounting reports using BI Publisher.
• Developed Custom Interface in Project Accounting to import new Projects
• Developed customized Accounts Payable Trial Balance Report using BI Publisher.
• Worked on the setup of Revenue Recognition in AR module.
• Modified PO, BPA, CPA, and RFQ Style sheet Reports successfully.
• Used X-query method in one of the report and also developed Bursting Report.
• Customized BI Publisher reports such as Sales Invoice Report, Asset Tracking Report.
• Created various reports in EBTax for understanding the rate flow.
• Define WSDL for SOA process, partner links, BPEL process templates and developed process logic definition.
• Worked on Jdeveloper 10g for oracle Applications R12 for developing different OAF pages.
• Developed 2 levels of Matrix Report and used sub template, Data template BI Publisher Reports.
• Worked on development Check Printing Report using BI Publisher.
• Done the unit testing, TE20, MD120 preparation.
• Developed Sales Dashboard in OBIEE
• Designed and developed WEB ADI components to Upload AP Invoice from a text file.
• Modified the standard reports according to the customized requirements.
• Designed and developed XML Publisher data template and Bursting Reports.
• Worked on migrating components using FNDLOAD
• Creation of the Interfaces to external systems.
• Review of Code and Design documents.
• Prepared MD070 and TE040 documents.

Confidential, Irving, TX

Techno Functional Consultant

• Involved in the Implémentation and Post Go-live support of Oracle Applications.
• Involved in Requirement gathering and Analysis, Data Mapping and Client interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Involved in functional Testing of the custom components.
• Involved in EB TAX Testing
• Worked on Jdeveloper 10g for oracle Applications R12 for developing different OAF pages.
• Worked extensively on OAF extensions in the customer page and the supplier page.
• Extensively worked on OAF pages personalization in various modules like iProcurement, iExpenses etc.
• Development of conversion program for importing invoices, Suppliers, customers, Transactions, Fixed Assets from legacy system to Oracle using open interface.
• Define WSDL for SOA process, partner links, BPEL process templates and developed process logic definition.
• Designed and Developed WEBADI Interface to import Sales orders from a text file.
• Worked on Order Settlement process through AR receipt creation and closure.
• Worked on Custom AR Report AR Invoice Print To Billtrust using Oracle Reports Builder 10g.
• Customized Dunning Letters standard templates as per business requirements in Account Receivables
• Developed custom Reports in Order Management to achieve the business requirements.
• Used FND LOAD extensively for downloading LDTs for Concurrent Programs, XML Data definitions and Templates, Menus, Value Sets, Request sets, form personalization migration to TEST, UAT and production environments.
• Designed and developed WEB ADI components to Upload AP Invoice from a text file.
• Modified the standard reports according to the customized requirements.
• Designed and developed XML Bursting Reports.
• Worked on migrating components using FNDLOAD
• Creation of the Interfaces to external systems.
• Used RTF, e-text and Microsoft excel templates for BI Publisher reports to meet various report design requirements. Used OA MEDIA to print Company logos dynamically in BI Publisher
• Worked with the users, BA team, DBAs closely on a daily basis and communicating with the business team if any gaps and providing the solution as per the requirement before the delivery timelines .

Confidential

Techno Functional Consultant

• Involved in the Development of reusable components of Oracle Applications.
• Involved development of in AP, AR, GL, CM, FA, PA and BOM Interfaces.
• Developed Interface to import Sales orders from various systems using API.
• Involved in Pick Release process, Pick Confirm process and Ship Confirm process during Shipping Execution process using standard shipping API’s.
• Developed custom Reports in Order Management to achieve the business requirements.
• Developed Custom Interface in Project Accounting to import new Projects
• Developed Interface to load Receivables Invoices from an external system, contract base to Oracle using Auto Invoice Concurrent Programs.
• Extensively worked on development and customization of Oracle RICE components as per business needs.
• Defining Journal line types, Journal Entry description, Mapping Sets. Worked on create accounting and transfer Journal Entries to GL.
• Worked on various conversion programs including Supplier Master Data, Customer Meta Data, Items, AP Invoices, Purchase Orders, price lists and On hand quantity Conversions.
• Uploaded the values for all Value sets using Data load in set up steps of General Ledger, Fixed Assets, Accounts Payables and Cash Management modules including System Administration set ups.
• Developed interface programs to load the data from external systems into Oracle Purchasing (PO) and Payables Invoices tables.
• Extensively developed SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables

Confidential

Senior Technical Consultant

• Involved in the Implementation and Support activities of Oracle Applications.
• Worked on Migrating the reports and customizations using FNDLOAD as part of upgrade process.
• Involved in supplier data and supplier Bank data conversion from legacy system to ERP.
• Designed and worked on custom programs and functional setups as per the client requirements in Inventory & Order Management modules along with O2C cycle.
• Coordinated with the Business Teams during CRP sessions, providing feasible solutions and additional support during testing phase.
• Creation of Database tables and other objects, developing Reports by using Oracle Developer suite.
• Involved in the Migration of 11i Custom Financial Reports to R12. This includes understanding the source code of 11i reports, developing and modifying them to fit as per the R12 solution design.
• Developed Custom BI Reports which includes Graphs.
• Developed Dynamic Column Reports with BI Publisher.
• Designed and developed the New Alerts, Work Flows and XML Publisher Reports meeting the business requirements.
• Worked on migrating components using FNDLOAD

Confidential

Technical Consultant

• Involved in the Implementation and Support activities of Oracle Applications.
• Designed and developed Reports in PTP process.
• Developed Customized Project Accounting reports using BI Publisher.
• Developed Custom Interface in Project Accounting to import new Projects.
• Worked on Order Import to bring the orders from legacy system, which is already made available in flat file to Oracle Applications R12 using Order import concurrent program.
• Involved in supplier data and supplier Bank data conversion from legacy system to ERP.
• Creation of Database tables and other objects, developing Reports by using Oracle Developer suite.
• Designed and developed New Alerts, Work Flows and XML Publisher Reports to meet the business requirements.
• Designed and developed XML Bursting Reports.
• Designed and developed Project Accounting and Financial Reports.
• Involved in Development of XSL-FO report from the standard RFQ report.

Confidential

Techno- Functional Consultant

• Involved in the Roll-out of Implementation and Post Go-live support of Oracle Applications.
• Preparing financial project documents like BP080, BR100, TE40 and SOPs in line with AIM terminology
• Involved in Integrating the OTC and PTP process.
• Developed Interface to import Sales orders third party system (Active Retail) using API.
• Worked on Data fixes in Order Management as part of daily Production Support.
• Developed custom Reports in Order Management to achieve the business requirements.
• To do the setups and Training in KUT, UAT and finally PROD instances for all financial modules (GL, AP, AR, FA, CM and E-business Tax )
• Developing FSG reports like Balance sheet, Income statement etc.
• Handling post production functional support issues related to Financial modules
• Interacting with functional users to understand the business issues and troubleshooting the problems.
• Developed the integration between ABILITY (Legacy system) and Oracle Receivables.
• Monitored Interfaces, Concurrent Programs & for the monthly closure.
• To resolve the production support issues on time within defined SLA’s. Responsible for the technical Issues in Interfaces.
• Developed new Concurrent Programs, executables and registered to responsibility.
• Engaged in Testing of Technical/Interface enhancements.
• Development of Custom Reports.
• Development of conversion program for importing invoices, Suppliers, customers, Transactions, Fixed Assets from legacy system to Oracle using open interface.

Confidential

Techno- Functional Consultant

• Outbound of Suppliers, Items & PO’s to TABS.
• Transfer of Inventory Item Transactions from TABS to Oracle Inventory (Inbound with respect to Oracle APPS)
• Designed and Developed Interface to import Sales orders from TABS system using Interface Tables in Order Management.
• Design and developed the XML reports like Order Status report, Packing Slip report etc.
• Developed custom Reports in Order Management to achieve the business requirements.
• Designed and Developed GL Interface to import Journals.
• Interface the Invoices for sales in Shops, Roaming Customers, Interconnect Customers to Oracle Receivables
• Interface the Receipts to Oracle Receivables.
• Interface the invoices to Accounts Payables, to be paid to the suppliers for using their services for roaming calls.
• Interface the invoices and receipts relating to Postpaid Transactions in the form JV to Oracle General Ledger
• Interface the movement of stock (Items) from one shop to another. This was done in Order management as an internal sales order.
• To do the setups in KUT, UAT and finally PROD instances for the above interfaces.
• To give training to key users and provide assistance to them in UAT
• To Prepare Test scripts for UAT.
• To resolve the production support issues on time within defined SLA’s for the above interfaces

Confidential

Techno- Functional Consultant

• Involved in the Roll-out of Implementation and Post Go-live support of Oracle Applications.
• Interacting with Business users, gathering and analyzing requirements.
• Preparing financial project documents like BP080, BR100, TE40 and SOPs in line with AIM terminology
• To do the setups and Training in KUT, UAT and finally PROD instances for all financial modules (GL, AP, AR, FA, CM and E-business Tax )
• Developing FSG reports like Balance sheet, Income statement etc.
• Designed and Developed Interface for Oracle Order-to-Cash from Third Party Systems.