EXPERIENCE SUMMARY

• Having 9 years of IT experience in complete SDLC (gathering Business Requirements, Analysis, Design, Implementation and Testing) cycle using Oracle Applications R12, 11i, SQL, PL/SQL, Oracle RDBMS, Developer 2000.
• Extensively worked on Oracle ERP modules like Financial Modules (AP, AR, GL, FA, CM) Supply chain Modules (PO, OM, INV), Service Contracts, HRMS, I - Store, Oracle Product Information Management (PIM), Oracle Projects and AOL Objects.
• Strong knowledge on business flow’s in Order-to-Cash, Procure-to-Pay and Dropship cycles.
• Technically proficient in RICEW (Reports, Interfaces, Conversions, Extensions, workflows) Components.\
• Expertise in Design and Development of Interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
• Having Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, collections, records, views, materialized views and Packages using PL/SQL.
• Extensively worked on Oracle Application Framework (OAF).
• Expertise in System Administration including oracle application activities like application user setups, defining responsibilities, request groups, value sets, registering, menus, forms, reports, Concurrent programs and providing support to apps users for any technical and functional issues.
• Good working experience with Service Desk (Assigning Tickets and entering work log and tracking the status of a Defect and update Service Desk).
• Expertise in creating inbound and outbound interfaces, creation of automated processes using Application Program Interfaces (API).
• Well versed with Unix Shell Scripting and Data Conversion from Flat files to Oracle using Oracle SQL* Loader and SQL*Loader scripts.
• Experienced in Developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV060) and Migration documents (MD0120).
• Extensive experience in developing and customizing Reports using XML/BI Publisher with xml data template and Oracle Reports data template.
• Tuning of customized application including reports and backend customization by using different application tuning techniques.
• Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
• Thorough knowledge of Oracle Apps Data model and how to leverage the data for effective

TECHNICAL SKILLS:

ERP: Oracle Applications EBS R12, 11i

Databases: Oracle Database 9i, 10g, 11g

Languages: SQL, PL/SQL, Java, XML

ERP Processes: Quote to Order(Q2C), Order-2-Cash (O2C), Procure-2-Pay (P2P), DROPSHIP

Technical Applications: Oracle Workflow, Oracle Application Framework (OAF), AOL and SYSADMIN

Financial Applications: GL, AP, AR, PO,CM, FA

Supply Chain Applications: Order Management, Oracle Purchasing, Oracle Inventory, Oracle Pricing.

Reporting Tools: Developer 2000, Discoverer, and XML Publisher

Development Tools: TOAD, SQL*Plus, SQL Developer

Operating System: Windows NT, UNIX

Other Tool: Visual SourceSafe

Multimedia: Flash, Adobe Photoshop

PROFESSIONAL EXPERIENCE

Confidential, Redwood city, CA

Oracle Apps Techno-Functional Production Support

Responsibilities

• Developed Custom OAF page to list the GL Periods and their status.
• Worked on integration of AP, AR and GL with the RECON-NET(Cash Management).
• Worked on BI publisher Intercompany Matching report.
• Worked on creating the Business event for the AFF values Insert/update.
• Worked on creating the AP extract for the Bank accounts.
• Worked on the Inbound AP Check Reconciliation/Un-Reconciliation program.
• Worked on the Inbound AR Receipt Reconciliation/Un-Reconciliation program.
• Involved in day to day support activities.
• Worked on Customizing AR Aging RDF Report.
• Worked on Customizing the GL batch Workflow Notification.
• Developed a custom program to import customer receipt data into AR.
• Worked on a Shell Script to Load the file and send email in case of errors.
• Extensively worked on HP Project and Portfolio Management Center, Service Now and SVN.

Environment E-Business Suite Release 12.1.3, AR, AP, GL, TCA, Purchase Order, Oracle Application Framework(OAF), Forms 10g, PL/SQL, SQL*Loader, SQL*Plus, TOAD, HP-PPM, Service Now, SVN,UNIX.

Confidential, Sunrise, FL

Oracle Apps Techno-Functional Consultant

Responsibilities

• Worked on the PLSQL Scheduled program for Service Contract Auto Renewal process to automatically renew the Contract before the expiration date.
• Worked on oracle payment process, developed custom Check layout and reports (formatting checks and positive pay file layouts) in AP.
• Worked on creating a Java Integrated Custom Customer API where all the operations like creating and updating the Customer, Parties, Sites, Contacts, Relationships, Bank accounts and Address have been handled.
• Worked on the COM Customer Search PLSQL API to retrieve the Customer details based on the Service Contract/Zip Code and Customer details.
• Worked on various conversions activity such as Customer Conversion, Invoices and Receipts conversion, GL conversion (Journals), Inventory (INV) and PO Conversion.
• Worked on the COM customer search PLSQL API to retrieve the customer details based on the Service Contract/Zip Code and Customer details.
• Extended standard Oracle Marketing details OAF page to add the Confidential and its attributes using JDEVELOPER.
• OAF Customizations to develop the Questionnaire fields for supervisors to enter the Surveys.
• Extended standard Create Campaign (Oracle Marketing) activity OAF page to add the Confidential and its attributes like purchase type and associated activity code etc.
• DevelopedInterface of Sales Orders Import in OMafter actively participating in the preparation of the conversion mapping documents.
• Developed a custom program to import customer receipt data into AR.
• Worked on creating annotations for custom objects and created the REST web service for those custom objects R12.2.5.
• Extended the Campaign (Oracle Marketing) Activity details OAF page for the Confidential and its attributes like payment method and payment frequency etc.
• Prepared Technical design documents for all the Campaign (Oracle Marketing) functional design documents.
• Work on the design for the Pagination on the customer, campaign and broker search results.
• Extensively worked on JIRA, JENKINS, Source tree and GIT.

Environment E-Business Suite Release 12.1.3, R12.2.5, AR, AP, GL, TCA, Service Contracts, Oracle Marketing, Oracle Application Framework(OAF), Forms 10g, PL/SQL, SQL*Loader, SQL*Plus, TOAD, JENKINS, JIRA, Source Tree, GIT and UNIX.

Confidential, Sanjose, CA

Oracle Apps Techno-Functional Consultant

Responsibilities

• The project involved the implementation of data conversions in various modules like AR, AP, TCA, FA and customization of reports.
• Implementation and upgrade of AP, AR, TCA and FA modules in R12.
• Developed Sales Order Report, Purchase order report, Purchase Order Arrival using XML Publisher.
• Designed, documented Functional (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents and developed conversion routines, Created Staging tables, and custom PL/SQL API’s.
• Worked on a Refund Process Customization to refund the amount to the Customer by cutting a check in AP.
• Developed Custom Program for Party Merge in AR.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Customers using TCA (Parties, Party Sites, Party Accounts, Party Account Uses), Items, Item Categories, Item Revisions, Open Sales Ordered., from legacy system.
• Designed and developed OAF pages for the Custom One Step Shipping Process and Custom BOL Solution.
• Designed and Developed OAF pages in WIP Labor vouchering process.
• Developed Sales Tax for the tax jurisdictions appropriate to the geographic ship to or Install at address.
• Determined Sales Tax Rate and Exceptions based on a Legacy Geo Code associated to the Customer Record.
• Designed OAF pages to track the customer information changes and update the information based on approvals made by the users.
• Developed a XSL template for customizing the AR Sales profit reportusing XML/BI Publisher and distribute the offer document generated from XML Publisher.
• Customized and developed Oracle Forms/Reports, workflow and Data conversion in AR, AP and FA Project Modules, and sub ledger accounting. Interacted with the business users and collected the technical requirements and Involved in Development, Customization of the Interface Applications.

EnvironmentE-Business Suite Release 11.5.10, CRM Foundation, AR, AP, TCA, FA, Service Contracts, Application Lifecycle Management (ALM) tool, Forms 10g/6i and Reports 10g/6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, OAF, Unix

Confidential, Charlotte, NC

Oracle Apps Techno-Functional Consultant

Responsibilities

• Developed SQL scripts to create temporary tables and SQL*Loader control files to load the item legacy data into the temporary tables.
• Loaded the vendor’s information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Imported new, changed and completed sales orders from legacy system to oracle using order import (order management open interface).
• Developed AP Invoice interface to load data from legacy system to AP interface tables.
• Designed and developed reports to handle multi-currency exchange gain and losses.
• Development of new OAF pages and embedded the same to Oracle Apps instances to cater to the business needs.
• Worked on the Budget Upload Open Interface to load the data from legacy systems to the GL Budget Interface table using SQL*Loader.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables.
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level.
• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Strong knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Zoom feature is enabled using custom.pll, and whenever user in sales order form clicks the zoom button. It displays the discount amount calculated for that order basing on the payment terms of the order.
• Migrated custom interfaces on the Oracle AR and Oracle AP from 11i to R12.
• Development/modification of custom reports in purchasing and payables
• Experienced in Performance Tuning of SQL queries & Views using Explain Plan, Hints and indexes.

Environment Oracle Applications R12/11.5.10, AR, AP, PO, Reports10g/6i, SQL, PL/SQL of Oracle 10g/9i, UNIX, Windows 2000/NT environment, Forms 10g/6i, Discoverer10g, XML/BI Publisher, Toad, SQL * Loader.

Confidential, Grafton, WI

Oracle Apps Techno-Functional Consultant

Responsibilities

• Prepared technical specifications document (MD70) based on the functional requirement specifications (MD50).
• Used SQL *Loader control file to import the customer information provided in the form of flat files into staging tables
• Performed Extensive Application tuning for Order to Cash Business process.
• Developed and implemented AP Invoice interface. This involved importing data from the legacy system into staging tables using SQL*Loader, validating the data using PL/SQL procedure, inserting data into interface tables and running the invoice import concurrent program to load the data into oracle AP tables.
• Involved in Development and Implementation of Customer Interface using TCA APIs, to bring customers into Oracle AR which arecreated in Legacy system, on a Daily basis.
• Worked with GL tables i.e. GL JE HEADERS, GL JE LINES, GL SET OF BOOKS, AR Interface, Customer Interface and GL interface (GL INTERFACE, GL BUDGET INTERFACE)
• Developed custom PL/SQL conversion program for loading GL Balances using Oracle Standard GL Interface program.
• Customized various transactions in Accounts Receivables like Invoices, Receipts, and Credit Memos and Debit Memos etc.
• Used Import Standard Purchase Orders and Receiving Transaction Processor interface programs to create purchase orders and receipts in Oracle Purchasing
• Imported the customers into Oracle Receivables using the CUSTOMER IMPORT form with in oracle applications.
• Creation of new custom reports and customizing of existing reports using Oracle XML Publisher.
• Worked on Oracle Discoverer Admin for creating item classes, custom folders and parameterized reports for OM, AR, AP and PO modules.
• Extensively worked on Format Triggers, Formula Columns, Summary Columns and Placeholder Columns for developing the reports using Oracle Reports Builder 6i.
• Designed and customized reports like New Customer Setup Report and Contract Price List Report using Discoverer 10g.
• Involved in the tuning of 11i applications (includes PL/SQL, SQL scripts) using Explain Plan and TKProf.

Environment Oracle Applications R11.5.10.2, Discoverer, Oracle 9i, LINUX, Reports 6i, PL/SQL, SQL*Loader and Toad 8.0

Confidential

Oracle Apps Technical Consultant

Responsibilities

• In all phases of project life cycle from inception to deployment.
• Created project Documentation, Coordinated and arranged requirement gathering Meetings, Breakout Sessions, Documenting Outcomes, Events, Business flows and process step analysis, gap and map analysis.
• Involved in writing interface program to load the data from external systems into Oracle purchasing (PO) interface tables.
• Developed SQL Loader scripts for various interfaces for loading data from input file to custom staging tables.
• Worked on various conversions to import data (Sales Orders, AR Invoices, Customers, Inventory, and Supplier) from the legacy system into Oracle Applications.
• Analysis and design of Application Security Documents Multiple Reporting Currencies, Multi-Org Structure, Financial Statement Generator Reports.
• Change Migration from Test Instances into Production.
• Gap and Issue Analysis and resolution of conflicts Coordination of Change verification from corporate users and business customers.
• Developed Custom outbound Interface to send the Invoices file to third party system in AP Module.
• Developed Custom outbound Interface to send the Payments file to third party system in AP Module.
• Creation of new custom reports and customizing of existing reports using Oracle XML Publisher.
• Designed and customized reports like New Customer Setup Report and Contract Price List Report using Discoverer.
• Customized forms using CUSTOM.PLL file to meet the specific requirements.
• Utilized Forms Personalization utility to call a PLSQL procedure and updated the AR Descriptive flex fields with Depot Repair flex field data.
• Experience in System Administration activities like Managing Concurrent Programs and Responsibilities.

Environment Oracle Applications 11i, PL/SQL, AP, AR, FA, GL, Projects, Forms 6i Reports 6i, Windows NT, System Administration.