PROFESSIONAL SUMMARY:

• Seven years of extensive experience as Oracle Applications Technical Consultant in Design, Development and implementation of Oracle Applications 11i/11.o.x.,R12 in Financials modules like Receivables, Collections, Payables, General ledger, Cash Management, Projects, Supply Chain & Manufacturing modules like purchasing, Inventory, Order Management, Advanced Pricing, Shipping, Costing, Quality & Service Contracts
• Extensive knowledge of Business Processes across the E - Business Suite, Order to Cash (O2C) and Procure to Pay (P2P).
• Expert in Trading Community Architecture (TCA)
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Extensive experience in developing Interface/Conversion Programs to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader and UTL File.
• Strong Experience in designing, developing and troubleshooting developing Reports, interfaces (Inbound & outbound), Customization and Extensions (WRICE) in Oracle Applications.
• Designed, developed and customized Workflows to automate processes using Oracle Workflow builder.
• Expert in preparing technical design documents for customizations and conversions using AIM.
• Extensive experience in developing SQL, PL/SQL codes and UNIX Shell scripts.
• Good knowledge and proficiency in fine tuning codes for better performance.

TECHNICAL SKILLS:

Packages: Oracle Applications EBS (Versions 11.0.3/11.5.6/11.5.9/11.5.10.1/11.5.10.2, R12)

ERP Modules: General Ledger (GL), Accounts Payables (AP), Accounts Receivables(AR), Project Accounting, Advanced Pricing(QP), Inventory (INV), Work in Process (WIP), Oracle Time and Labor, Bills of material(BOM), Order Management (OM), Purchasing (PO), Shipping(WSH), iSetup, Application Object Library (AOL).

Processes: Order to Cash, Procure to Pay

Operating Systems: Windows 7, Windows Vista, XP, NT, UNIX, Linux, Sun Solaris, AIX

Database: Oracle 8i / 9i / 10g

Tools: Discoverer, XML Publisher, SQL * Loader, SQL developer, Toad, SQL *plus, Udeploy, Kintana, PVCS, SVN, Jenkins/Hudson, Artifactory, Clearcase, ClearQuest, Remedy, Putty

Languages: SQL, PL/SQL, C, C++, Java, JSP, Servlets, JDBC, UML, VB .Net, ASP .Net

Web Scripts: HTML, XML, XHTML, PHP, CFML, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential, Linthicum, MD

Oracle Apps Techno Functional Consultant/Performance Engineer

Responsibilities:

• Responsible for loading payment batch specific data into tables using SQL loader
• Worked on the AP Invoice Import, to load the Open and future dated invoices into Oracle
• Developed conversion programs for validating and importing Open AR transactions (Invoices) from legacy system to Oracle Interface tables. Used Autoinvoice Master Program to load the interface table data in oracle AR base tables.
• Worked on all the enhancements or error reports if any issues encountered during Alpha/Beta/UAT testing.
• Developed Conversion scripts to process the vendor, vendor sites, contacts and bank information into Oracle, as per the detailed mapping and requirements from the business.
• Involved in interacting with functional leads, technical lead and data management team in order to document the technical/functional and development specifications using standard AIM documents like MD070, MD050 and BR100 and resolve certain data requirement issues.
• Worked on generating AWR/ASH reports to gather the performance metrics
• Reviewed majority of the change requests (HCR), PMR, BR100 to see if there is any performance concern and provided recommendations if required.
• Reviewed jil files that were used to kick off the Autosys jobs/threads
• Reviewed many custom components like supplier’s payment history, Invoice history reports etc
• Worked on AR setups to create new transaction sources with transaction type as both Manual and Imported, Receivable classes and defined new receivable quick codes
• Worked on AP setups to create new netting, TPP and NTDO banks, respective bank branches, setting bank accounts, Adding organization access to bank account, payment document setup and payment process profile setups
• Created multiple validation value sets for a custom program in R12
• Created many declarative/programmatic EO, VO in ADF (JDeveloper) depending on the requirements
• Customized defimpl.java for a request to generate passwords for every new user or a user whose password has not been updated since 60days
• Created a JSF page that gives the list of objects that were deployed today to R12 test instance and a page that lists down the concurrent program details for every R12 component
• Responsible for SQL performance tuning using Tkprof, Explain plan
• Involved in providing performance recommendations for many custom packages to use indexes, hints, forced indexes, gather stats to optimize the performance
• Worked closely with oracle on SRs related to performance like format payment instructions which was completing in error because of volume of the data.
• Responsible for testing payment batches via Autosys, moving the inbound files(claims data) from production to test instance using a sh script
• Worked on component testing for all the custom programs and compared the performance in 11i and R12
• Worked on all the incident/tickets assigned to team in remedy and was responsible for resolving the issue depending on the SLA
• Worked across different teams and had discussions on various issues on a regular basis.

Environment: Oracle Applications 11i, R12.2.2 (General Ledger, Account Payables, Account Receivables, Purchasing), Oracle 11g, SQL, PL/SQL, Reports 10g, Forms Developer, XML Publisher.

Confidential, San Jose, CA

Oracle Apps Technical Consultant

Responsibilities:

• Responsible for inserting build/ship data into custom tables using SQL loader
• Developed custom packages to transfer/interface all the container items from 11i to R12
• Worked on split org functionality for export orders - Creation of purchase order and order booked in different operating unit
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Worked on API which is used for two purposes: Custom ASN and enablement; to provide all the order related information to customer
• Worked on API which provides serial number, shipment number information of orders used during invoicing
• Used standard API ego item pub.process items to update item's attributes and container item flag
• Designed and developed SQL loader scripts to load PO requisitions from the legacy System in to purchasing interface tables. Developed PL/SQL packages for different validations, for processing data in order to create valid PO's and Receipts and for populating the PO interface tables and called the seeded import programs to populate the base tables.
• Worked on interfacing Sales Order Backlog (3A4 Message) and Cancellation message (3A9) to the manufacturing partner. Interfacing 3A4 and 3A9 records and also responsible for reprocessing of error records.
• Developed scripts for On hand quantity interface in Inventory.
• Developed Scripts for the Receiving Open Interface to generate the Receipts for the items received against the standard Purchase Orders.
• Worked on OM / Shipping - Order Booking, Release Sales Order, Shipment - Transaction, Ship Confirm etc.
• Imported BOM data from Legacy system to Oracle through Open BOM Interface. This process includes loading data from flat file to temporary table using the SQL * Loader, validated the temporary table data and moved to the Interface table.
• Worked on employer/supervisor hierarchy setup so that purchase order after a certain limit gets approved by default supervisor rather than it getting stuck with individual supervisors
• Worked on a process to pay correct material cost to the Partners that did not have an approved cost at the time of shipment.
• Worked on Return to Vendor process in case if the order is being returned because of damage or any other reason. Used inv reservation pub.delete reservation to delete reservation
• Worked on process of validating purchase order price such that we don’t end up paying more to suppliers
• Contributed to a project ITDT - IT Delivery Transformation. This project involved transforming all the third party tools that currently Cisco is using.
• Contributed to a project UOV - Universal Order Visibility tool. This project was to provide interface to business users which gives all the details about order at every stage.
• SQL Performance tuning using Tkprof, SQL Trace and Explain Plan.
• Responsible for fixing defects related to quarterly releases
• Responsible for providing support during GO LIVE and post GO LIVE
• Worked across cross functional teams and also guided offshore team on various tasks

Environment: Oracle Applications 11.5.10 - R12.1.2, Oracle EBS v12.2.3,INV, AR, TCA, AP, Oracle 10g, Xml Publisher, TOAD, Windows 2000, UNIX,WINSCP, JDEV,AOL.

Confidential, Irving, Texas

Oracle Apps Technical Consultant

Responsibilities:

• Inserted OTM (Oracle Time Management) data into custom tables using SQL*Loader
• Worked on AP Open Invoice Interface to convert all the Invoice Headers and Invoice Lines from legacy system to Oracle Applications.
• Created invoices in AR using Auto Invoice import program
• Developed custom packages to transfer/interface all the costs pertaining to Labor/Materials in Oracle Time Management to Project Accounting
• Involved in AR Open Invoices conversion by writing a wrapper program which calls an API to validate and load the data from staging tables into AR interface tables.
• Extensively involved in auto invoicing to create Invoices from external feeder system and Auto lock box to create Receipts.
• Developed custom package to create Cost Clearance JE’s and interface it to the General Ledger from Project Accounting based on business rules
• In AR module, customized the standard forms in AR using Forms Personalization to make some fields required and to disable fields as per the business requirement.
• Customized standard reports such as Account Analysis Report, Journal Batch Summary report (GL Transaction report), Past due Invoice report and AGING BUCKETS in General Ledger and Accounts Receivable
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report and consolidation journal report in General Ledger (GL).
• Designed a report which holds all the material costs on a project for a particular period. Report included project level details, expenditure level details and also included customer information
• Customized AR account status report and AP trial balance report using report builder
• Involved in development of Discoverer reports like PA account information report, AR aging report etc.
• Customized the AR invoice sales tax report in Receivables using report builder and XML Publisher
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer
• Designed, developed, registered customized forms, tables and reports using AOL.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-50, MD-70) for all conversions and reports.

Environment: Oracle Applications 11.5.10, PA, OTM, INV, AR, TCA, AP, GL, Oracle 10g, Xml Publisher, TOAD, SQL Developer, Windows 2000/2007, UNIX, WINSCP, JDEV, AOL.

Confidential, Baltimore, Maryland

Oracle Apps Technical Consultant

Responsibilities:

• Developed control files for SQL*Loader and PL/SQL programs for loading, data mapping, interfacing, data conversions and validating the data into the interface tables of GL, AP, AR, INV, PO modules.
• Worked on GL budgets interface to load the budgets data into the base tables using the budgets upload program.
• Worked on the journal import interfaces to upload the journal entries into GL interface tables.
• Processed Item Open Interface by Developing SQL loader scripts and custom interface programs for importing, validating and inserting the Item Attributes data from 3rd party system to staging and interface tables. Scheduled a standard API to load data into the target base tables.
• Worked on Supplier Conversion Interface to load all suppliers, sites and contacts information into base tables
• Developed interfaces for Bank Reconciliation and Positive Pay transactions through Oracle Cash Management
• Developed custom program (Inbound interface) to validate and load the PO documents from Legacy (a third party supplier site) into Oracle Purchasing interface table. Used Purchasing Document Open Interface program to load the data into Oracle base tables.
• Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into AP Interface tables and then populate the Oracle Base tables by calling Payable invoice Import Program
• Extensively involved in creating several ad-hoc reports in GL, SLA, AP modules. Created multiple FSG reports in General Ledger module.
• Worked on standard reports in AP and PO modules like AP- Invoice History Report and PO- Print purchase order reports to enhance and make necessary changes according to the business needs.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes using XML/BI Publisher.
• Developed Summary Cash Requirement Report, Detailed Cash Requirements Report and Invoice RegisterReport using XML Publisher (BI Reports) Reporting Tool.
• Developed a new report to get users who have Purchase order and requisition open and are out of the company.
• Modified several Customized Reports using XML/BI Publisher like Credit/Debit Memo Report, Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports as per changing business needs.
• Defined Value sets, Reports, registered Concurrent Programs and custom build Forms and Reports using Application Object Library (AOL) in the development environment.
• Involved with study of existing system, preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables. Used AOL and System Administrator modules for registering the developed and customized reports.

Environment: Oracle Applications 11.5.10 - R12.1.2, Oracle EBS v12.2.3, INV, AR, TCA, AP, Oracle 10g, Xml Publisher, TOAD, Windows 2000, UNIX,WINSCP, JDEV,AOL.

Confidential, Milwaukee, Wisconsin

Oracle Apps Technical Consultant

Responsibilities:

• Involved in designing, developing interfacing, customizing user requests and implementing change requests. During these processes interacted with end users and implemented the changes in the Application Systems, according to their requirements.
• Developed control files for SQL*Loader and PL/SQL programs for loading, data mapping, interfacing, data conversions and validating the data into the interface tables of GL, AP, AR, PO modules.
• Worked on AP Open Invoice Interface to convert all the Invoice Headers and Invoice Lines from legacy system to Oracle Applications.
• In the GL module, designed and developed PL/SQL packages for Journal Import Interface to import journals information into the system.
• Involved in design and development of Order Import interface in General Legers (GL).
• Developed SQL loader scripts and custom interface programs for importing, validating and inserting the On Hand Quantity data from legacy system to staging and interface tables. Scheduled a standard API to load data into the target base tables.
• Designed and developed SQL loader scripts to load PO requisitions from the legacy System in to purchasing interface tables. Developed PL/SQL packages for different validations, for processing data in order to create valid POs and Receipts and for populating the PO interface tables and called the seeded import programs to populate the base tables.
• Developed a custom interface: AR Customer Conversion using TCA API’s to migrate Customers, Sites and Contacts to R12.
• Developed Auto Invoice interface program to validate and import invoices from the legacy system into Oracle Receivables.
• Worked on Form Personalization to personalize the purchase order form to default the acceptance required for purchase orders created manually.
• Developed Vendor and Purchase order summary report using Report Builder
• Designed and developed Customer Invoice, Purchase Order Report using XML Publisher.
• Designed and developed Exception Reports in Custom Interfaces using XML Publisher.
• Extensively used AOL and System Administrator modules for Creation of users and creation of roles and responsibilities, assigning various customers to users, set up of various Concurrent programs, Request sets, Values sets and Descriptive flex fields Registered concurrent programs, request groups for reports and concurrent requests.
• Documented technical features and behavior of required customizations using AIM.

Environment: Oracle Applications 11.5.10 - R12.1.2 INV, QP, OM, AR, TCA, GL, AP, Oracle 10g, Xml Publisher, TOAD, Windows 2000, UNIX,WINSCP, AOL.

Confidential, Sterling, Virginia

Oracle Apps Technical Consultant

Responsibilities:

• Worked with the implementation team having detailed discussions with the client on system requirements and mapping on Oracle Applications.
• Involved in resolving the technical issues related to Purchase to Pay and Order to Cash cycles.
• Developed SQL * Loader programs to load data from flat file to stage tables. Written PL/SQL procedures to validate and load the data into the Oracle Interface tables for the respective modules.
• Developed a custom program in order to validate and load the data from staging tables into Vendors which is a three step process in which the 1st phase is like loading all the vendors and the 2nd phase is like loading all the vendor Sites and 3rd phase is loading all the vendor contacts with the help of Supplier, Supplier Sites & Supplier Contact Conversions in AP
• Involved in resolving the technical issues related to Purchase to Pay and Order to Cash cycles.
• We used to get the data from the MASS200 legacy system into pre-staging tables with the help of SQLLDR Then to move the data into oracle base tables we used to write several custom wrappers.
• Worked on various API’s in AP and applying Hold’s on the Invoice’s with help of some API’s.
• Developed Scripts for the Receiving Open Interface to generate the Receipts for the items received against the standard Purchase Orders.
• Designed and developed interface for Auto Invoice to import standard credit memos debit memos from legacy system to AR .
• Personalized standard forms and developed new forms according to the client specific business requirements, using Oracle Forms.
• Customized Invoice Register Report by appending additional columns like invoice terms, supplier site promotions cost and descriptive flex field information
• Developed online queries and multiple custom reports in INV, OM, PO modules, like Item Revision Exception Report, Works Order Print Report, Overdue Vendor Shipment Report, Kanban Planning Report etc, using Oracle Reports 6i and XML Publisher.
• Created a custom XML Publisher PDF report for Commercial Invoice Report

Environment: Oracle Applications 11.5.10 - R12.1.2 QP, OM, AR, TCA, AP, Oracle 10g, Xml Publisher, SQL Developer, TOAD, Windows 2000, UNIX,WINSCP,AOL.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Interacted with the functional team to understand the business and user requirements
• Performed Various System Administrator activities like defining a concurrent program, creating users, creating menus, creating responsibilities.
• Gathered requirements for various RICE elements from business users and created technical documents
• Used TCA APIs to create new customers, customer sites, customer accounts and contact points.
• Worked on purchasing documents open interface to import standard PO, Blanket PO into PO module using SQL*loader and PL/SQL
• Migrated the Oracle Forms 4.5 to Oracle 6i and made necessary changes to the PL/SQL Code and made necessary changes to the tables.
• Involved in Auto Invoice Interface to load invoices automatically from legacy systems to Oracle Receivables AR.
• Documented functional features and behavior of required customizations using AIM.
• Creation of Value sets in various Modules of the application.

Environment: SQL, PL/SQL, PO, AR, TCA, Oracle 10g, Report Builder, Xml Publisher, TOAD, SQL Developer, Windows 2000, UNIX, WINSCP

Confidential

Oracle Developer

Responsibilities:

• Created various (Back-end) PL/SQL code to implement business rules through procedures, functions, and packages using SQL*Plus Editor.
• Documented the business flowchart, user manual and technical manual.
• Development of screens in forms using oracle at backend according to the requirements of Clients.
• Developed various Business Reports
• Created Data Flow Diagram, Entity Relationship Diagram from Designer.

Environment: SQL, PL/SQL, SQL developer, TOAD, forms 4.5, Reports 2.5, Windows NT