SUMMARY

• 8+ years of Experience in Development of Applications in Oracle ERP Application (Financial, Manufacturing and Distributions) and Client - Server environment.
• Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E-Business Suite and Release 12.
• Extensive experience in Oracle Applications 11i Oracle Financials (OM, INV,PO, AR, AP, GL, CM, CSF, CSI, CSD) modules of Oracle Applications 11i in multi Org, multi Currency environment.
• Extensive Experience in Oracle Application customizations including Forms, Reports and Concurrent Programs.
• Extensively experienced in the technical and functional aspects of Oracle Applications R12/11i/10.7.
• Experience in Oracle Applications modules that includes Order Management, Inventory, Oracle Advanced Pricing, Shipping Execution, Accounts Receivables, Accounts Payable, General Ledger, Cash Management, Purchasing, Procurement,E-Commerce Gateway (EDI) and Workflow.
• Worked on Oracle Workflow involving various activities such as Notifications, Functions, and Processes.
• Strong working knowledge of business flows like Order-to-Cash and Procure-to-Pay along with the dependencies and relationships between Oracle Applications modules.
• Good understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Strong in PL/SQL and topics like Bulk collects, Dynamic SQL, Collections.
• Expertise in Design, Development and Customization of RICE (Reports, Interface, Data Conversions and Extensions/Customization) using SQL, PL/SQL, UNIX Shell scripts and SQL*Loader.
• Hands on Experience in Oracle Discoverer 4i/9i/10g which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
• Extensively used XML functions like XMLELEMENT( ), XMLFOREST( ), XMLAGG( ) etc.
• Very good understanding and exposure in Oracle Trading Community Architecture (TCA) entities and public APIs.
• Performance tuning of applications using built-in Oracle utilities like Explain Plan and TK-Prof and used Optimizer hints and Bulk Binding techniques where needed.
• Supported the production system with day-to-day issues and worked with business users and Oracle Support as required.
• Ability to interact with individuals at all levels and Accustomed to working under tight schedules.

TECHNICAL SKILLS

Oracle Applications: OracleApplication 11i/12

Technical Modules: AOL, System Administration.

Functional Modules: AR, AP, GL, CM, OM, PO, INV, CSF. CSI, CSD

Tools: OracleDiscoverer, Developer2000, (Form 6i and Reports 6i), TOADSQL*PLUS.

Languages: C, SQL, PL/SQL.

RDBMS: Oracle 10g, 9i, 8i, 6i.

Operating Systems: WINDOWS 7/XP/2000/NT, UNIX.

Other Tools: SQL Loader, Microsoft Office - Word, Excel, PowerPoint, MS Access.

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved with the study of existing system, preparing the Technical design document to extract data from legacy system into Oracle Applications open interface tables.
• Used CONCSUB to call the Concurrent Process and execute the job in Unix Shell Script
• Developed new custom processes, functions, defined new events, subscriptions in OEOH and OEOL Workflows to update the shipping method and carrier information after order has been BOOKED. Also modified the transaction type set ups to route the workflow through custom process.
• Developed the SQL*Loader script to load the data to staging tables and then to interface tables for Order Import program to import orders. Wrote packages to validate and populate the interface table.
• Developed custom API’s to change/update the custom tables.
• Developed PL/SQL package to convert data from legacy systems(MCS System) to oracle.
• Converted GL Balances, Purchase orders, Sales Orders, Pricing Discounts from Legacy System to Oracle.
• Developed Personalization in different forms ranging from Sales order form through purchase order form.
• Developed functions to implement intercompany rules.
• Developed the PL/SQL API to populate the Defaulting Rules in Order Management OM.
• Cancellation and creation of order lines using Process order API.
• Written shell scripts and used them as Concurrent programs for data extraction from Inventory.
• Designed and developed the following custom reports in OM and INV modules as per the client requirement-
• Quote report
• Part Ticket Report
• Purchase Order Report
• AR Invoice Report
• Developed the bursting process to email, Fax and print a document based on the business rules at the same time.
• Customized the Order line workflow to apply custom holds before the order is booked using Holds Pub API.
• Worked on Discoverer Administration and Desktop Editions. In Administration Edition, Created Business areas, Custom folders, Item classes, user views and joins for reporting. In desktop edition created workbooks and worksheets
• Designed a technical document MD-70 based on functional document MD-50

Environment: Oracle Applications R12 (EBS) (GL, AR, AP, OM, INV, PO, DR, FS), Oracle11g, SQL*Loader, Developer 6i (Forms and Reports 6i), Discoverer 10g, XML publisher, Workflow 2.6, VSS, TOAD, and UNIX.

Confidential, Texas

Oracle Applications Technical Consultant

Responsibilities:

• Involved with the study of existing system, preparing the Technical design document to extract data from legacy system into Oracle Applications open interface tables.
• Created custom Interfaces per the client requirements to convert Standard Orders, RMA’s and Dropship orders.
• Developed a custom program to upload the item attributes into the Oracle using the ITEM Import. This program will read the CSV file uploaded by user and create/update the item category/category sets and updates item attributes.
• Extracting and loading catalog data from internal and external data sources for use with oracle internet Procurement, Creating Item level, Category level information templates, Settings for Realms for iProcurement.
• Developed PL/SQL packages to ship confirm and cancel orders based on the conditions.
• Developed functions to implement intercompany rules.
• Developed the PL/SQL API to populate the Defaulting Rules in Order Management OM.
• Cancellation and creation of order lines using Process order API.
• Written shell scripts and used them as Concurrent programs for data extraction from Inventory.
• Designed and developed the following custom reports in OM and INV modules as per the client requirement-
• Orders on Hold Report
• Pre-Pick List Report
• Sales Order Report
• Customized the Order line workflow to apply custom holds before the order is booked using Holds Pub API.
• Worked on Discoverer Administration and Desktop Editions. In Administration Edition, Created Business areas, Custom folders, Item classes, user views and joins for reporting. In desktop edition created workbooks and worksheets

Environment: Oracle Applications R12 (EBS) (GL, AR, AP, OM, INV, PO), Oracle11g, SQL*Loader, Developer 6i (Forms and Reports 6i), Discoverer 10g, XML publisher, Workflow 2.6, VSS, TOAD, and UNIX.

Confidential, Pennsylvania

Oracle Applications Techno Functional Consultant

Responsibilities:

• Involved with the study of existing system, preparing the Technical design document to extract data from legacy system into Oracle Applications open interface tables.
• Worked on the setups of Order to Cash life cycle. This included Customer, Order Types, Item and credit checking rules.
• Used using CONCSUB to call the Concurrent Process and execute the job in Unix Shell Script
• Used the EDI 810 Inbound data to capture the information and initiate the shipping transaction in Oracle.
• Developed the SQL*Loader script to load the data to staging tables and then to interface tables for Order Import program to import orders. Wrote packages to validate and populate the interface table.
• Utilized the purchase order extractions program to extract Purchase Order data in EDI 850 format and transfer to GENTRAN, the EDI Translator. GENTRAN transmits the data to the drop ship vendor
• Developed custom API’s to change the Confidential order lines after pick release.
• Developed the PL/SQL API to populate the Defaulting Rules in Order Management OM.
• Cancellation and creation of order lines using Process order API.
• Written shell scripts and used them as Concurrent programs for data extraction from Inventory.
• Designed and developed the following custom reports in OM and INV modules as per the client requirement-
• Monthly Sales Report
• Pre-Pick List Report
• Orders on Hold Report
• Sales Order Report
• Customized the order header workflow to make certain header level attributes mandatory before the order is booked.
• Customized the Order line workflow to apply custom holds before the order is booked using Holds Pub API.
• Designed and developed Bill and Routing Interface by dumping the data files into the BOM base tables.
• Worked on Discoverer Administration and Desktop Editions. In Administration Edition, Created Business areas, Custom folders, Item classes, user views and joins for reporting. In desktop edition created workbooks and worksheets

Environment: Oracle Applications R12 (EBS) (GL, AR, AP, OM, INV, PO, BOM), Oracle11g, SQL*Loader, Developer 6i (Forms and Reports 6i), Discoverer 10g, XML publisher, Workflow 2.6, VSS, TOAD, and UNIX.

Confidential, California

Oracle Applications Techno Functional consultant

Responsibilities:

• Analyzed existing elements for pre-conversion processing.
• Worked on complete setups of Order to Cash life cycle. This includes Defining Customers, Defining Order Types, Defining Organizations, Defining Items and Credit checking rules.
• Worked on the Item import conversion to import Inventory items from the legacy system into Oracle Applications.
• Set up of inventory organizations, sub inventories, shipping networks, transaction sources etc.
• Customized Oracle Seeded reports in Order Management and Accounts receivables. Includes customization of Orders by Item and Sales Order Acknowledgement report as per the functional requirements
• Developed and Implemented Interface program to import invoices to AR, performed validations of invoices and performed necessary setups for the auto invoice master program.
• Resolved the performance issues of key reports in OM, INV.
• Created custom Interfaces per the client requirements to convert Standard Orders, RMA’s and Dropship orders.
• Developed PL/SQL packages to validate legacy data for items conversion with categories in Oracle Inventory (INV) module.
• Used the FTP utility to transfer files like raw data, reports etc between UNIX servers.
• Used SQL*LOADER with the help of Control Files to load data from pipe delimited flat files into ORACLE staging tables.
• Developed a package that validates invoice information and load the invoices into AR by running auto invoice daily.
• Worked on Customer Listing - Detail/Summary report and Dunning History report. Registered these reports as concurrent programs in AOL and modified request group to add these concurrent programs.
• Created of various Oracle Alerts (ALR) to inform internal users of certain events, or to notify customers of account status.
• Customized a number of financial reports like Invoice History Report, Invoice Aging Report, Payment Register Report etc in AP using ORACLE Report Builder 6i.
• Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the journal import interface provided by Oracle General Ledger.
• Worked with Discoverer 9i so users would have the ability to generate ad-hoc reports and also show the data in the form of Excel Files.
• Involved in document and code reviews.
• Performed Pl/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, TkProf, Indexing and Hints.
• Deeply involved in writing ORACLE database objects like STORED PROCEDURES, FUNCTIONS, and PACKAGES using PL/SQL.

Environment: Oracle Applications 11.5.10.2 - (GL, AR, AP, FA, CM, INV), Oracle11g, PL/SQL, SQL*Loader, Oracle Reports, Discoverer 9i & 6i, XML publisher 5.6.3, Workflow 2.6, Perforce, TOAD, and UNIX.

Confidential, Pasadena,CA

Oracle Applications Technical Consultant

Responsibilities:

• Communicated effectively with the clients to understand and get information regarding their Business practice. Involved in requirement gathering and analysis and design of the application.
• Involved in the complete setup of pricing that included price lists, modifiers, qualifiers, profile options, lookups, attribute mapping, etc.
• Defined Transaction Type, Payment terms and Invoicing rule setups and invoice, receipt related setups in AR.
• Developed the PL/SQL Scripts to translate the old Asset Category to new Asset category values that are been setup in the R12 Fixed Assets
• Developed the SQL*Loader script to load the data to staging tables and then to interface tables for Order Import program to import orders. Wrote packages to validate and populate the interface table
• Developed PL/SQL packages to validate legacy data for items conversion with categories in Oracle Inventory (INV) module.
• Customized standard Oracle reports like Suppliers Report, Account Status Report, Account Analysis Report and Backorder Summary Report as per the business requirements.
• Extracting and loading catalog data from internal and external data sources for use with oracle internet Procurement, Creating Item level, Category level information templates, Settings for Realms for iProcurement.
• Oracle Workflow:
• Developed workflow business events to report the promise date and schedule ship date changes on the orders.
• Customized the PO workflow to send notifications to specific people using adhoc roles.
• Xml Publisher:
• Extensively used XML functions like XMLELEMENT(), XMLFOREST(), XMLAGG() etc.for XML output and integrated with Xml Publisher for better lookup of the reports.
• Designed and Developed Blanket Sales Agreement and Blanket Release Reports using XML Publisher for better lookup.
• Used CONCSUB to invoke and execute the Concurrent Programs from Unix Shell Scripts.
• Developed ad-hoc reports according to user requirements and created custom business views/folders using Discoverer10g.

Environment: Oracle Applications R12 (EBS) (GL, AR, AP, OM, INV, PO), Oracle10g, PL/SQL, SQL*Loader, Developer 6i (Forms and Reports 6i), Discoverer 10g, XML publisher, Workflow 2.6, VSS, TOAD, and UNI

Confidential, San Francisco, CA.

Oracle Applications Technical Consultant

Responsibilities:

• Designed and Developed Payables Open Interface to validate and import Invoice information into the Payables Interface tables and into the Payables base tables using Payables Open Interface Import.
• Worked on complete setups of Order to Cash life cycle.
• Developed the PL/SQL API to populate the Defaulting Rules in Order Management OM.
• Used SQL*Loader and PL/SQL package to import invoice data into Interface table in Accounts Receivables and by using Auto Invoice Master Interface transferred data into Oracle Receivables.
• Workflow:
• Customized workflow for customer credit check in order entry process of Oracle Order Management.
• Developed PL/SQL procedures for conversion of items using the open items import program.
• Involved in setups of pricing that included price lists, modifiers, qualifiers, profile options, lookups, attribute mapping, etc.
• Oracle Reports:
• Developed and customized Oracle seeded reports in Order Management and Shipping. Reports were generated for Pick Slip, Pack Slip, Purchase Order and Shipping Label.
• Customized Invoice on Hold Report in Payables module according to user requirement.
• Customized the Customer order backlog report.
• Involved in modification of Credit Memo Transactions form in AR module. The transactions form was customized to make the reason field mandatory using CUSTOM.PLL.
• Extensively used FNDLOAD utility to migrate concurrent programs, request sets, value sets etc.
• Developed UNIX scripts to extract data and dump it into files and send e-mail report.
• Developed PL/SQL Procedures using Oracle Provided Standard API’s to update tables.
• As a Techno Functional Consultant, Involved in the preparation of MD050, MD070 documents using AIM methodology.

Environment: Oracle Apps 11.5.10.2(EBS), OM, AR, AP, GL, PO, INV, Advanced Pricing (QP), TOAD, Oracle Reports 6i, Oracle Forms 6i, SQL* Plus, SQL*Loader, Workflow Builder 2.6, SQL, PL/SQL.

Confidential, MN

Oracle Applications Technical Consultant

Responsibilities:

• Used SQL loader to import data into temporary tables and validated this data by creating custom PL/SQL procedures as required.
• Developed an Interface to load Requisitions data from flat file to Oracle Purchasing using PL/SQL Packages and Procedures, Validations and SQL*Loader Scripts.
• Extensively used API’s in the data conversion process and also in situations where complex business logic needs to be implemented.
• Customizedstandard Invoice on Hold report, Supplier Payment History Report and Aging Report as per the client requirements.
• Customized the Order Header and line workflow for lines fulfillment process.
• Worked on Customer conversions to import new customer accounts into Oracle Account Receivables.
• Developed PL/SQL procedures to load Price list Data (Qualifiers, Modifiers and Price Lists).
• Worked with the Oracle support teams and raised TARs to resolve issues.
• Create custom reports using XML publisher as requested by users.
• Worked on post-production support to debug and resolve issues.

Environment: Oracle Applications 11.5.9 (GL, AR, AP, PO, INV), Oracle Workflow Builder 2.5, Oracle Database 9i, SQL, PL-SQL, Reports 6i, Forms 6i, XML Publisher, TOAD, SQL* Loader.

Confidential

Oracle Developer

Responsibilities:

• System analysis and design for enhancements, Testing Forms, Reports and User Interaction.
• Database development included writing PL/SQLstored procedures, triggers, and functions.
• Developed Error-Handling package using PL/SQL tables to handle user-defined errors.
• Design and execute complex SQL Queries and PL/SQL codes to enhance the existing Reports.
• Accessed remote databases using DB-Links.
• Tuning the SQL scripts to improve performance.

Environment: Developer 2000, PL/SQL, SQL*Loader, TOAD, Windows 2000

Confidential

Software Engineer

Responsibilities:

• Responsible for design, development, testing and maintenance Involved in XML development, to populate data into client application using API Xml, Using API xml performance is fast and uses less system resources.
• Involved in creating reports for FCIS
• Creation of Packages, stored procedures & triggers using PL/SQL
• Developing Generic Packages using PL/SQL to migrate data from fat files to Oracle Systems
• Involved in creating rule sets as for the business rules
• Involved in System Testing and Test plan preparation

Environment: Oracle 7.1, Developer 2000, Forms 5.0, Reports 3.0,SQL, PL/SQL, COM, XMLWindows NT 4.0, MS Access 2000.