Summary:

• Overeight Yearsof 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 AR, AP, GL, CM, CSF, CSI, CSD, CDH 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.
• Good exposure to Oracle Applications Implementation Methodology viz. AIM 3.0
• Very good understanding and exposure in Oracle Trading Community Architecture TCA
• entities and public APIs.
• Proficient with UNIX command line and shell scripting
• 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 Skill:

• Oracle Applications: Oracle Application 11i/12
• Technical Modules: AOL, System Administration.
• Functional Modules: AR, AP, GL, CM, OM, PO, INV, CSF. CSI, CSD, CDH
• Tools: Oracle Discoverer, Developer 2000, Form 6i and Reports 6i , TOAD,
• SQL 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

Responsibilities:

• Involved in the design and development of the inventory system for the real estate business for their website and building a dynamic system for the customer information
• Involved in building the technical design for the inventory and the CDH customer data hub .
• worked on building the inventory items using a conversion
• worked on the development of various interfaces to communicate with other system using SOA
• developed custom APIs to update customer information in oracle from other platforms like Siebel and X inventory
• developed custom programs scheduled to update inventory information based on the updates from Siebel system
• developed custom tables and related APIs to maintain the customer information in oracle from other systems
• developed interfaces to communicate the transaction information with different systems like Siebel, fulfilment system
• Developed conversion program to convert Items, Locators, Onhand Quantities and Transaction History
• Developed Custom Work Flows to accommodate the business process into oracle.
• Developed custom process to handle to reserve items, transact them into assets and back into available based on the business rules
• Developed complex views to provide data to different intelligent reporting tools
• Developed scheduled jobs to process the inventory on a daily basis using a stored procdure

Environment: Oracle Applications R12 EBS OM, IN, Oracle11g, SQL Loader, Developer 6i Forms and Reports 6i , Discoverer 10g, XML publisher, Workflow 2.6, VSS, TOAD, and SQL Developer.

Confidential

Responsibilities:

• Responsible for the Development of CONVERSIONS to convert data from legacy system into oracle apps and was responsible for the Technical Doc Preparation.
• Worked on Setting up Profile options to Org level. site level and user level
• developed personalization and interfaces to update service contracts
• developed reports for field services and deport repairs to reflect the on highway and off highway transactions
• modified oracle packages to reflect the pricing discounts modifiers and qualifiers in field services and deport repairs
• Developed EDI interface to forward oracle documents to different vendors for warranty purpose
• Worked on LOCKBOX, ACH, POSPAY and Check Printing Setup, Scripting and Template building.
• Worked on the interfacing issues with oracle between OM and CSD.
• Worked on configuring install base and converting serialized items form legacy system.
• Developed PL/SQL package to customize few business work flows in legacy systems ICS 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 inventory through Account Payables.
• Developed the PL/SQL API to populate the Defaulting Rules in Order Management, Account Payablesand Account Receivables.
• Worked on the dynamic solutions to resolve the DFF conflicts between different organizations
• 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 INmodules 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

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

Confidential

Responsibilities:

• Involved in the development of the automation process for an item from OM through AP.
• Worked on the setups of OPM life cycle. This included Shipping orders,
• Used using CONCSUB to call the Concurrent Process and execute the job in Unix Shell Script
• Developed the SQL Loader script to load the data to staging
• Developed custom API's to change and update the custom tables.
• Developed PL/SQL packages to ship confirm and cancel orders based on the business rules.
• 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.
• Developed custom APIs to run invoice from automated process with business rules validations
• Developed PL/SQL Packages to monitor the work flows using a schedule job and report any faulty activity.
• Written shell scripts and used them as Concurrent programs for data extraction from Inventory.
• Designed and developed the following custom reports in OM and INmodules as per the client requirement-
• Pre-Pick List Report
• Sales Order Report

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

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 move 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 INmodules as per the client requirement-
• Monthly Sales Report
• Pre-Pick List Report
• Orders on Hold 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

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 INmodule.
• 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, IN, Oracle11g, PL/SQL, SQL Loader, Oracle Reports, Discoverer 9i 6i, XML publisher 5.6.3, Workflow 2.6, Perforce, TOAD, and UNIX.

Confidential

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 INmodule.
• 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

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

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, IN, Oracle Workflow Builder 2.5, Oracle Database 9i, SQL, PL-SQL, Reports 6i, Forms 6i, XML Publisher, TOAD, SQL Loader