SUMMARY:

• Having 12+ years of work experience in Oracle Applications.

• Well versed with RICE - W (Reports, Interfaces, Conversions, Forms Extension and Workflow).
• Expertise in Design and development of interface and conversion programs to integrate Oracle Applications modules to import data from various sources using PL/SQL, SQL*Loader, etc.
• Done ITIL-V3 and OCA-I s.
• Worked on Order Management (OM), General Ledger (GL), Accounts Payables (AP), Account Receivables (AR), Oracle Application Express(APEX), Oracle Purchasing (PO), Oracle iProcurement, Oracle iReceivables, Oracle eBTax, Supply Chain Management Modules (SCM), Financials, HTML Quoting, Oracle Time and Labor (OTL), Oracle Service Procurement (OSP), Oracle HRMS, Oracle Projects, Inventory (INV) modules.
• Well versed in designing, development and customization of Oracle Reports.
• Worked with OAF to XML Publisher integration.
• Worked on Oracle Service Procurement (OSP) integration with iProcurement, HRMS, Purchasing (PO), Payables(AP) and Project Accounting (PA) modules.
• Well versed with Oracle Worfkflow.
• Worked on development and creation of New Apex Forms and Apex Reports.
• Good experience in XML/BI Publisher.
• Designed new custom java concurrent programs.
• Worked on Sabrix Tax Engine Integration.
• Worked on OA Framework Customizations and Personalization.
• Well versed with O2C and P2P cycle.
• Exposure to Oracle Time and Labor (OTL) and Oracle HRMS.
• Experience in Tuning concurrent programs.
• Exposed in Oracle Apex UI Design and reporting (HTML DB).
• Worked on Unix Shell Scripts based concurrent programs.
• Worked in Migration projects.
• Exposure to ADF in Oracle Fusion Apps V1 and V2 releases.
• Confidential itude to learn quickly and adapt to the situations.

SKILL:

ERP: Oracle E Business Suite 11i & R12, General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Purchasing(PO), Oracle eBTax, Order Management(OM), Oracle Projects, Oracle Service Procurement (OSP), iProcurement, Oracle Project Accounting (PA), Oracle Time and Labor (OTL), Oracle Service Procurement (OSP), Oracle HTML Quoting, Inventory(INV), Application Object Library (AOL)

Oracle: SQL, PL/SQL, Oracle Workflow Builder, Oracle Forms 6i/10g, Oracle Reports 6i/10g, Oracle Developer 10g & 11g, XML/BI Publisher, SQL * Loader, OA Framework (OAF), JDeveloper 10g, Oracle 10g/9i, Web ADI

Programming Languages:: SQL, PL/SQL, C, Core Java, Shell scripts, Power Shell

Other Tools: Oracle Application Express (Apex), TOAD, SQL Developer, IBM Clearcase, PPM Kintana, TFS, Sabrix Tax Engine

Operating Systems: Windows, UNIX, Linux

EXPERIENCE:

Confidential, Atlanta, GA

Oracle Apps Techno Functional Consultant

• Worked on iReceivables funds statement generation based on time period using OAF customization including CO extension and AM extension and added new params using personalization.

• Worked on EBS upgrade from R12.1.3 to R12.2.5
• Created and maintained. New Apex Forms Item Inquiry, Control Total, Quantity On Hand, Sales Details etc.
• Designed custom Java Concurrent Programs.
• Created designed documents e.g. MD70,TE20.
• Involved in SIT, CRP, UAT cycles and migrations of custom components during upgrade.
• Involved in creation and customization of BI Publisher reports.
• Worked on Oracle Form Personalization in AP Invoice pages.
• Worked on OAF Customization for iReceivables transaction page to show transaction reference for credit memos, invoices, debit memos, chargebacks etc.
• Worked on Positive Pay & Reconciliation Bank Interface design for the client.
• Worked on OAF customization for Requisition in iProcurement.
• Worked on design of new custom reports for Purchasing(PO) requirements.
• Worked on Control Total drilldown form design using Oracle Apex.
• Used Host concurrent program to call java class files with parameters passed from shell file.
• E nvironment: OA Framework(OAF), Java Concurrent Programs, Oracle Applications 12.2.5 & 12.1.3, Oracle iReceivables, Oracle Purchasing(PO), Oracle iProcurement, Oracle Receivables(AR), Oracle Payables (AP), Oracle Inventory (INV), Oracle General Ledger(GL), XML Publisher/ BI Publisher, Oracle Forms 10g, Oracle Reports 10g, JDeveloper 10g, Oracle Apex, TOAD

Confidential, Atlanta, GA

Oracle Apps Techno Functional Consultant

• Designed and developed new BI Publisher report for getting the inventory org and locations details using data template and rtf layout.

• Developed BI Publisher report for AR Transaction Register by Branch functionality.
• Used update apis for item Confidential ribute updates in inventory orgs.
• Done OAF personalization in Checkout Page to make the Buyer field mandatory at site level.
• Worked on Open PO Report using BI Publisher for client requirements.
• Worked on Certify Interface for creation of AP Invoices.
• Worked on Optimum Interface for creation and updation of Suppliers, Supplier Sites, Supplier Bank Accounts.
• Worked on setup of Desktop ADI.
• Used Partial Page Rendering (PPR) concept in OA Framework page.
• Created the journals using Web ADI.
• Worked on designing on AP Checks for different Operating Units including Texas and Kentucky.
• Worked on Catalogue and Non Catalogue requests and done OAF customization in iProcurement.
• Worked on various Production Issues and worked on Gap Analysis and design & development of custom components or customization of existing functionality based on requests from the user
• Worked on MD50 and MD70 documentation.
• E nvironment: OA Framework(OAF), Oracle Applications 12.1.3, Oracle Purchasing(PO), Oracle iProcurement, Oracle Receivables(AR), Oracle Payables (AP), Oracle Inventory (INV), Oracle General Ledger(GL), Web ADI, XML Publisher/ BI Publisher, Oracle Forms 10g, Oracle Reports 10g, JDeveloper 10g, TOAD

Confidential, Tucson, AZ

Oracle Apps Techno Functional Consultant

• Designed and developed new custom workflow for Contractor Management System (CMS) for TEP.

• Worked on Oracle Service Procurement (OSP) customization with iProcurement integration.
• Exposure to Oracle OTL customization with OSP integration.
• Oracle iProcurement OAF customization (CO extension) for removing mandatory fields of Contact Details in Contractor Requisition.
• OAF personalization in iProcurement to hide certain fields related with PO Number needed checkbox, suggest supplier field hiding. iProcurement changes to default project, task, expenditure type and expenditure org using user hook functionality for 'Rate Based Temp Labor'.
• AP Invoice customization for renaming AP Invoices created from OTL Timecards, to include PO Number, Period End Date and Person Name in Payable Invoice Number and Description fields.
• Integration with PeopleSoft by getting the Former Employee records using PeopleSoft views.
• Population of staging table for PeopleSoft and reading the process status back once record is successfully processed by PeopleSoft.
• Worked on OAF customization.
• Worked with Offshore team for triaging, delegation and review of various tasks and activities.
• Population of Buyer during PO Autocreate functionality from OSP iProcurment Requisition.
• Form Personalization to disable updates to First Name and Last Name fields in Temporary Labor tab in Oracle Purchase Order (PO) Form.
• Worked on creation and updation of HRMS record for contractor records using hr contingent worker API.
• Done the unit testing, TE20, MD70 preparation.
• E nvironment: OA Framework(OAF), Oracle Applications 12.1.3, Oracle Payables (AP), iProcurement, Oracle Service Procurement(OSP), Oracle Time and Labor(OTL), Oracle Purchasing(PO), Oracle Projects(PA), General Ledger(GL), Oracle HRMS, BI Publisher, Oracle Forms 10g, Oracle Reports 10g, JDeveloper 10g, TOAD

Confidential, Salt Lake City

Oracle Apps Techno Functional Consultant

• Worked on Supplier Interface to create new suppliers from existing customers from Oracle EBS.

• Developed a custom BI Publisher report for Sales Invoice Details.
• Created 'Receipt Maturity Date' update functionality in Receivables using oracle api as per the custom requested as part of the credit card functionality reconciliation functionality
• Taken care of Item Onhand and Item Cost conversion processes.
• Worked on custom Product Search Page in OAF.
• TFS system has been used for version control.
• Worked on P2P Process and O2C process.
• Done the unit testing, TE20, MD70 preparation.
• E nvironment: Oracle Applications 12.1.3, Oracle Receivables(AR), Purchasing(PO), Order Management(OM), Oracle Payables (AP), General Ledger(GL), Inventory(INV), OPM Financials, OA Framework(OAF), BI Publisher, Oracle Forms 10g, TFS

Confidential, Bethesda, MD

Oracle Apps Techno Functional Consultant

• Worked on PAM SPS Treasury system Integration with Oracle EBS(federal financials).

• Created XML Publisher reports for Detail Reclass Reconciliation and Summary Reclass Reconciliation to have the status of fully reclassified TAS-BETC details, partially reclassified TAS-BETC details and not reclassified TAS-BETC details for the given schedules.
• Developed new Custom Oracle Form for Certify Payment Schedules in CTA to provide the certify functionality to authorized users to search based on either reclass file names, accounting period names or schedule numbers to have the functionality for their and status of already certified records in Oracle Federal Financials.
• Developed Shell script concurrent program for reading OFM Agency Notification data files from inbound directory and storing the file and data in custom table.
• Created a new custom OAF page for schedule number search and update based on multiple user criterias.
• Worked on Tortoise SVN versioning system to maintain newly created files.
• Worked on PPM Kintana package for migrating code across instances e.g. Development to TEST and TEST to PROD.
• Worked on functionality for importing CARS statement for Schedule A payments with Default TAS BETC information and then processing those payments based on schedule number to reclassify the imported records with actual accounted payment invoices and correct TAS BETC details.
• Done the unit testing, TE20, MD70 preparation.
• E nvironment: Oracle Applications 11.5.10.2, Oracle Federal Financials, Oracle Payables (AP), General Ledger(GL), OA Framework(OAF), Tortoise SVN, PPM Kintana, TOAD, Shell, Unix

Confidential, Radford VA

Oracle Apps Techno Functional Consultant

• Worked on custom oracle forms developments like PO Master Detail Form, Order Management Delivery Number Search Form in Oracle EBusiness Suite 11.5.10.2 environment.

• Worked on Oracle XML Publisher reports like Custom Label Printing Report, Bank Account Change report etc.
• Developed new custom forms from scratch as per client requirements e.g OM Item Update Form, OM Item Warehouse form etc.
• Worked on form personalization e.g Standard Customer Master Form Personalization to work conditionally for various responsibilities and different users as per their profile settings.
• Worked on VO Extension for adding additional columns in Custom Supplier Search Page using OA Framework (OAF).
• Modification of custom components as per various requirements of the project.
• Worked on Oracle Apps production support activities on 11i.
• Worked on OAF personalization e.g. changes in some column names.
• Done the unit testing, TE20, MD120 preparation.
• E nvironment: Oracle Applications 11i, Oracle Purchasing, iProcurement, Order Management (OM), Inventory (INV), HTML Quoting, Work in Process (WIP), Fixed Assets(FA), Purchasing, Oracle Forms Builder 6i, Oracle Reports Builder 6i, Oracle 10g, SQL Developer, Workflow, BI Publisher, TOAD, OA Framework(OAF), UNIX

Confidential

Oracle Apps Fusion Developer

• Worked on Forward Porting of R12 features to Fusion Release 5, Release 6 and V2.

• Worked on inclusion of Withholding Tax Configuration Owner Tax Options UI feature for Withholding Tax in Fusion Tax Module of Fusion Apps release V1 and V2.
• Integrated server deployment using ADF.
• Done changes in DetailTaxLineEO and SummaryTaxLineEO for integration with payables module using ADF.
• Worked on Brazil AR Bank Transfer feature implementation.
• Standalone instance deployment for unit testing.
• Unit testing and system integration testing of the developed code.
• Provided fixes to the issues identified in testing phase.
• Environment: Oracle Fusion Apps Release 5, Release 6 & V2, ADF (Application Development Framework), Developer 11.1.1.1.6, PL/SQL

Confidential

Oracle Apps Technical Consultant

• Supported the client’s R12 apps installation in Reports, PL/SQL Packages/ Procedures.

• Done enhancement and maintenance of inbound interface e.g. florist data import interface to receivables, AP Invoice Import Interface.
• Created OAF LOV's, Picklists and Advance tables for different pages as per client Requirement.
• Worked on development of Supplier Summary, Purchase Order and Invoice Import BI Reports.
• Worked on Oracle Apps development activities on R12.
• Worked on new form for Oracle Waybill Number search and update form.
• Added Language and Account Number to the customer address using OAF personalization.
• Done the Impact Analysis of Oracle Patches on custom components.
• Developed the xml publisher version of 1099 report for the client’s custom requirement.
• Worked on migration of all the custom concurrent programs and interfaces from clients place to Oracle servers.
• Worked on custom CO Extension using OA Framework(OAF) for Item Search.
• Checked all the hard coding in the code and adopted standard directory structure e.g. $INTERFACE HOME/out during the migration process.
• Prepared the MD 50 and MD70 documentation.
• Worked on development of Invoice Printing Report using BI Publisher.
• Done the unit testing, TE20, MD120 preparation.
• E nvironment: Oracle Applications R12, AP, AR, GL, Oracle Forms 10g, Oracle Reports Builder 10g, Oracle Workflow, OA Framework(OAF), Oracle 10g, SQL Developer, BI Publisher, TOAD and UNIX

Confidential

Oracle Apps Technical Consultant

• Worked on Legacy Shell Script’s conversion to Oracle Ebiz Concurrent Programs as part of migration process from customer hosted servers to Oracle hosted servers.

• Worked on Oracle Project’s Task creation interface.
• Involved in creating new Self-Service Pages using OA Framework (OAF).
• Worked on development of new Jobs Scheduler Form for client’s custom scheduling requirement.
• Worked on Oracle Payment Format report and customer billing report using XML Publisher.
• Modification of custom components as per various requirements.
• Worked on Oracle Apps production support activities on 11i.
• Done the unit testing, TE20, MD120 preparation.
• En vironment: Oracle Applications 11i, Oracle Projects, Oracle Order Management (OM), AR, Oracle Reports Builder 6i, XML Publisher, OA Framework (OAF), Oracle Reports Builder 6i/10g, Oracle 10g, SQL Developer, Workflow, TOAD, UNIX

Confidential

Oracle Apps Technical Consultant

• Designed and developed new Reports, Forms, PL/SQL Packages/ Procedures pages.

• Worked on Oracle Apps upgrade from 11.0.3 to R12 12.0.4
• Worked on conversion of customer’s legacy Florist form from their ATLAS legacy system to Oracle EBusiness Suite compatible forms by adopting Oracle standard process.
• Designed florist interface program to get the data from the source system of 1800flowers.com and provided that data to staging area for upload to AR and AP tables.
• Worked on extending OAF pages to have the VO customization in payables.
• Designed/written one time florist conversion program to populate the data in staging area of Payables module.
• Worked on deployment of OAF Pages and Regions into Oracle Applications.
• Preparation of Technical Design in OA Framework.
• Successfully cut annual operational costs by $45,000 by saving 6000 man hours per year by implementing FPT Discounting for 1-800-Flowers.com.
• Developed new form Florist Special Product Price Maintenance form, Direct Pay Maintenance Form, Direct Pay Maintenance History form.
• Worked on development of Florist FPT Price import conversion from ATLAS legacy system.
• Developed Price Change Report, Mercury Message Report and Product Summary Report in client’s ATLAS Legacy System using report builder 6i.
• Done the CV 40 and CV-60 documentation.
• E nvironment: Oracle Applications 11.0.3 and R12 (12.0.6) (AP, AR), Oracle Forms Builder 6i/10g, Oracle Reports Builder 6i/10g, Oracle 9i, SQL Loader, TOAD, UNIX

Confidential, San Jose, CA

Oracle Apps Technical Consultant

• Coordinated on shore and off shore teams on regular basis for the project.

• Worked on having unified tax solution for AR, OM, AP, PO and Service Contracts through Sabrix.
• Involved in requirement gathering, design and development and testing of System.
• For the current items in INV, associated the Tax category to the Items by writing the script for creation of new Item Category Set to all the existing items.
• Worked on service contracts customization using form personalization to restrict the Oracle to mandate the Exemption Number field, for exempting a particular service contract from tax. So by relaxing this condition allowed business process to enter the number if available.
• Created a DFF to capture the ship-to information at the invoice distribution level in case of manually distributed Payables invoice.
• Captured "ship to" information and "tax amount" for the invoices created through PCARD process.
• Done the Personalization and customization for Sales Order Form in Order Management.
• As Sabrix requires Customers, Exemptions & Zones information to be available in their system for tax calculation, so created a custom program for generating the one time extract.
• Created the Descriptive Flexfield (DFFs) in GL, AP, AR and OM for capturing the Tax information.
• Customized the XML publisher Template for Sales Order Acknowledgement Report.
• Customized the automated check request process for the tax calculation.
• Customized the code in Procurement Card functionality to populate the actual ship to location values and Sabrix Tax Flag with values of 'R' (required) or 'D' (do not calculate) .
• Designed the ship to location population logic in Check Request, Procurement Card, AP Invoices, and AR Invoices.
• Worked for Customization of Sales Order form for various scenarios for Tax Determination.
• Worked on Sales Order Acknowledgement report, PO Sabrix Error Report.
• Worked on Mercury Kintana Tool to migrate the setup across instances.
• Used the IBM Rational Clearcase tool for version control.
• Done the MD-50 and MD-70 documentation.
• E nvironment: Oracle Applications 11i (GL, AP, AR, OM, PO, INV, Service Contracts), OA Framework (OAF), Sabrix Tax Engine, IBM Clearcase for version control, Mercury Kintana, Oracle Reports Builder 6i, Oracle Forms Builder 6i, XML Publisher, Java Script, Oracle 10g, SQL Loader, TOAD, UNIX

Confidential

Oracle Applications Developer:

• Working as an Applications Developer, Involved in Design, Development and Providing solutions to Oracle Applications E-Business Suite 11i customers across the globe for helping them in setup and in working of various modules of Oracle Financials (GL) that are not behaving as expected.

• Designed and developed Conversions and Extracts for GL. Release of new version of files from time to time. Adding new functionalities to product.
• Worked on EBTax module for regime to rate flow.
• Bugs related with customers in Oracle Financials GL and MRC modules. These include solving their queries, setting up steps for customers and finding the possible causes and elimination of them by fixing the problems in the form of releasing new versions of files. Different bugs are related with Summarization, Allocations, Journal Approval, Posting, Budgetary Controls, FSG Engine, Drilldown Reports, Currency Rates Manager, Accounting Setup Manager, Segment Value Inheritance etc.
• Worked on OA Framework for determining the exeception and exemption conditions in eBTax integration with AR.
• Worked on eBTax for Tax calculation.
• Provided development support for GL, MRC modules and MOAC concept.
• Prepared patches of Standard and Standalone nature according to requirements of customer and product team. These patches are both in branches and main line releases.
• Environment: Oracle E Business Suite 11i and R12 (till 12.0.4), Oracle General Ledger (GL) and Multi Reporting Currency (MRC) for financials, Oracle eBTax, Oracle 10g, Oracle 9i, Oracle Forms 6i, Oracle Reports 6i, Unix (Solaris, Linux), Toad, SQL Developer

Confidential

Oracle Developer

• Involved in Design Documentation and Software Requirement Specifications.

• Written the Batch Programs in Pro*C and PL/SQL.
• Generated various reports using reports builder and integrated into the system
• Developed PL/SQL Procedures for execution of different Business Logics in Reports.
• Written SQL code to create Views necessary for the system.
• Developed program code for packages, forms, reports, triggers using SQL, PLSQL.
• The data was standardized to store various Business Units in tables.
• Responsible for testing and preparing test cases and implementation.
• Worked on monitoring of batch jobs and processes.
• Created Tables, Indexes, Synonyms and prepared Altering tables scripts
• Created and executed Test Scripts.
• Created Functional and Technical Documentations
• Environment: Oracle Reports 6i, SQL, PL/SQL and Windows 2000, Pro*C, Sun Solaris, SQL Loader, TOAD, PL/SQL Developer