SUMMARY:

• Having around 10 years of work experience in Oracle Applications.
• Well versed wif 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 certifications.
• Worked on Order Management (OM), General Ledger (GL), Accounts Payables (AP), Account Receivables (AR), and Supply Chain Management Modules (SCM) and Financials modules.
• Well versed in designing, development and customization of Oracle Reports.
• Good experience in XML/BI Publisher.
• Experience in tuning concurrent programs.
• Exposure in SOA and BPEL Components.
• Worked on Unix Shell Scripts based concurrent programs.
• Exposure in Migration projects.
• Worked around 5 years wif ORACLE India Pvt Ltd, Hyderabad
• Worked on Sabrix Tax Engine Integration.
• Worked on OA Framework Extension and Personalization.
• Attitude to learn quickly and adapt to teh situations.

TECHNICAL SKILLS

ERP: Oracle E Business Suite 11i & R12, General Ledger (GL), Accounts Payables (AP), Service Contracts, Install Base, Accounts Receivables (AR), Order Management (OM), Oracle Projects, Application Object Library (AOL)

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

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

Other Tools: TOAD, SQL Developer, IBM Clearcase, Mercury Kintana, TFS, Sabrix Tax

PROFESSIONAL EXPERIENCE

Confidential, Salt Lake City, UT

Technical Lead

Responsibilities:

• Worked on Supplier Interface to create new suppliers from existing customers from Oracle EBS.
• Worked on BI Publisher report for Sales Invoice report.
• Worked on teh Sales Order Interface using teh Order Import APIs
• Worked on teh Auto invoice Interface in AR
• Worked on teh Lock Box interface in AR module
• Worked on teh Shipping interface in OM module
• Worked on Receipt Maturity Date update functionality using oracle api.
• Worked on Item On hand and Item Cost conversion
• Worked on BPEL for updating request date on Order Header table to delay teh shipping date from third party legacy system using WSDL in SOA.
• Worked on custom Product Search Page in OAF.
• Worked on TFS system for source control and work order management.
• Done teh unit testing, TE20, MD70 preparation.

Environment: Oracle Applications 12.1.3, Jdeveloper 11g, Oracle Payables (AP), General Ledger (GL), Inventory, OAF, BI Publisher, TFS, OPM Financials, SOA, BPEL

Confidential, Bethesda, MD

Oracle Apps Technical Lead Consultant

Responsibilities:

• Worked on PAM SPS Treasury system Integration from Oracle EBS.
• Create XML Publisher reports for Detail Reclass Reconciliation and Summary Reclass Reconciliation to have teh status of fully reclassified TAS-BETC details, partially reclassified TAS-BETC details and not reclassified TAS-BETC details for teh given schedules.
• Developed new Custom Oracle Form for Certify Payment Schedules in CTA to provide teh certify functionality to authorized users to search based on either reclass file names, accounting period names or schedule numbers to have teh functionality for their certification and status of already certified records in Oracle Federal Financials.
• Worked on teh Order Import interface in OM module
• Worked on teh AR Auto Invoice Interface
• Worked on teh Auto Lock Box interface in AR module
• Worked on teh BPEL/SOA Adapters like Data Base Adapters, file adapters, FTP adapters, etc.
• Developed Shell script concurrent program for reading OFM Agency Notification data files from inbound directory and storing teh file and data in custom table.
• 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 wif Default TAS BETC information and then processing those payments based on schedule number to reclassify teh imported records wif actual accounted payment invoices and correct TAS BETC details.
• Done teh unit testing, TE20, MD70 preparation.

Environment: Oracle Applications 11.5.10.2, Oracle Federal Financials, Oracle Payables (AP), General Ledger(GL),Tortoise SVN, PPM Kintana, TOAD, Shell, Unix

Confidential, Radford VA

Oracle Apps Technical Lead Consultant

Responsibilities:

• Worked on custom 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 some columns in Custom Supplier Search Page using OA Framework (OAF).
• Modification of custom components as per various requirements of teh project.
• Worked on Oracle Apps production support activities on 11i.
• Worked on OAF personalization e.g. changes in some column names.
• Done teh unit testing, TE20, MD120 preparation.

Environment: Oracle Applications 11i, Order Management (OM), Inventory (INV), HTML Quoting, Work in Process (WIP), Oracle Forms Builder 6i, Oracle Reports Builder 6i, Oracle 10g, SQL Developer, Workflow, BI Publisher, TOAD, OA Framework (OAF), UNIX

Confidential

Oracle Apps Developer

Responsibilities:

• Worked on Forward Porting of R12 features to Fusion Release 5, Release 6 and V2.
• Worked on inclusion of Wifholding Tax Configuration Owner Tax Options UI feature for Wifholding Tax.
• Integrated server deployment using ADF.
• Changes in DetailTaxLineEO and SummaryTaxLineEO for integration wif payables module.
• Worked on Brazil AR Bank Transfer feature implementation.
• Standalone instance deployment for unit testing task flow functionality.
• Unit testing and system integration testing of teh developed code.
• Providing fixes to teh 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 Techno Functional Consultant

Responsibilities:

• Supported teh 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,
• 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 teh customer address using OAF personalization.
• Done teh Impact Analysis of Oracle Patches on custom components.
• Developed teh xml publisher version of 1099 report for teh client’s custom requirement.
• Worked on migration of all teh custom concurrent programs and interfaces from clients place to Oracle servers.
• Worked on CO Extension using OA Framework(OAF) for Item Search.
• Checked all teh hard coding in teh code and adopted standard directory structure e.g. $INTERFACE HOME/out during teh migration process.
• Prepared teh MD 50 and MD70 documentation.
• Worked on development of Invoice Printing Report using BI Publisher.
• Done teh unit testing, TE20, MD120 preparation.

Environment: 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

Responsibilities:

• 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.
• 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 teh unit testing, TE20, MD120 preparation.

Environment: Oracle Applications 11i, Oracle Projects, Oracle Order Management (OM), AR, Oracle Reports Builder 6i, XML Publisher, OA Framework, Oracle Reports Builder 6i/10g, Oracle 10g, SQL Developer, Workflow, TOAD, UNIX

Confidential, NY

Oracle Apps Technical Consultant

Responsibilities:

• 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 teh data from teh source system of 1800flowers.com and provided that data to staging area for upload to AR and AP tables.
• Designed/written one time florist conversion program to populate teh data in staging area of Payables module.
• 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 teh CV 40 and CV-60 documentation.

Environment: 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

Responsibilities:

• Coordinated on shore and off shore teams on regular basis for teh project.
• Worked for Sabrix Tax Integration for AP, OM, AR, GL, PO, INV and service contracts modules.
• Involved in requirement gathering, design and development and testing of System.
• Done teh Personalization and customization for Sales Order Form in Order Management.
• Worked on Outbound Interface for Customers, Tax Exemptions and Tax Zones for teh Sabrix Tax Engine System.
• Created teh Descriptive Flexfield (DFFs) in GL, AP, AR and OM for capturing teh Tax information.
• Customized teh XML publisher Template for Sales Order Acknowledgement Report.
• Customized teh automated check request process for teh tax calculation.
• Worked in Java Script for teh Procurement Card’s and Check Request’s custom functionalities to integrate it wif Sabrix Tax Engine.
• Customized teh code in Procurement Card functionality to populate teh ship to location and Sabrix Tax Flag to get teh Tax Calculation functionality from Sabrix.
• Written teh script for creation of new Item Category Set for Tax association to all teh existing items.
• Designed teh 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 P2P Process and O2C process.
• Worked on Object Activeum report using Oracle Reports Builder and XML template.
• Worked on Sales Order Acknowledgement report, PO Sabrix Error Report.
• Worked on Mercury Kintana Tool to migrate teh setup across instances.
• Used teh IBM Rational Clearcase tool for version control.
• Done teh MD-50 and MD-70 documentation.

Environment: Oracle Applications 11i (GL, AP, AR, OM, PO, INV, Service Contracts), 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

Responsibilities:

• Working as an Applications Developer, Involved in Design, Development and Providing solutions to Oracle Applications E-Business Suite 11i customers across teh 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.
• Bugs related wif customers in Oracle Financials GL and MRC modules. These include solving their queries, setting up steps for customers and finding teh possible causes and elimination of them by fixing teh problems in teh form of releasing new versions of files. Different bugs are related wif Summarization, Allocations, Journal Approval, Posting, Budgetary Controls, FSG Engine, Drilldown Reports, Currency Rates Manager, Accounting Setup Manager, Segment Value Inheritance etc
• 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 10g, Oracle 9i, Oracle Forms 6i, Oracle Reports 6i, Unix (Solaris, Linux), Toad, SQL Developer

Confidential

Oracle Developer

Responsibilities:

• Involved in Design Documentation and Software Requirement Specifications.
• Written teh Batch Programs in Pro*C and PL/SQL.
• Generated various reports using reports builder and integrated into teh system
• Developed PL/SQL Procedures for execution of different Business Logics in Reports.
• Written SQL code to create Views necessary for teh system.
• Developed program code for packages, forms, reports, triggers using SQL, PLSQL.
• Teh 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