SUMMARY

• Having 10+ years of Professional Experience as Oracle Applications EBS Senior Consultant in Implementation, Integration, Customization, Analysis, Design, Development, Testing, Maintenance and Production Support of full life cycle projects on the ERP Oracle Applications E - Business Suite 11i and R12
• Expertise in Procure to Pay (P2P) and Order to Cash(O2C) cycles
• Strong Experience in Designing, Developing, Implementing, Testing and Troubleshooting RICEWF components
• Good noledge in OM Order Management, PO Purchasing, INV Inventory, AP Payables, AR Receivables, GL General Ledger, BOM Bills of Material, WIP Work in Process, CS Service, OKS Service Contracts, CSI Install Base, PA Projects, WMS Warehouse Management, FND Application Object Library modules
• Expertise in SQL, PL/SQL, Oracle Reports, Oracle Forms, XML/BI Publisher Reports, Custom.pll, PL/SQL reports, Oracle Workflow, Discoverer Reports, Oracle Alerts, Forms Personalization, APIs
• Strong Experience in Full life cycle Implementations, Upgrade, Development and Customization of Reports, Interfaces, Conversions, Forms, Workflows, Alerts as per requirements
• Proficient in writing Procedures, Packages, Triggers, Cursors and Functions using SQL, PL/SQL and Performance Tuning using SQL Trace, Explain Plan, Indexes and Hints
• Worked on Outbound Interfaces to transfer the data from Oracle Applications base tables into flat files using UTL FILE package
• Extensive Experience in design and development of new custom forms using Form builder 6i/10g and customizations through Forms Personalization and Custom.pll
• Experience in Application Object Library AOL activities like Applications User Setups, Defining Responsibilities, Profile Values, Value Sets, Flex Fields, Lookups, Data groups and Request groups, and registering Forms, Functions, Tables, Menus, Reports, Request sets, Executables and Concurrent Programs
• Migration of objects between instances by using LDT files, FNDLOAD download and upload
• Involved in Functional setups and provided Support for various modules
• Have good noledge in OBIEE, Java and Oracle Applications Framework OAF
• Ability to lead a team to accomplish goals/assignments and create team atmosphere
• Ability to deliver high quality results wif attention to details
• Excellent Analytical skills and ability to work efficiently in a multi-tasked environment
• Ability to interact wif individuals at all levels and Accustomed to work under tight schedules
• Experience in Production Support project, worked as Onsite Lead supporting various Oracle Applications modules
• Experience wif merger and acquisitions project in the streamlining of business processes systemsWorked along wif DBAs and peers for production migrations, participated in production preparedness meetings and suggested the impacts upon deployments, operations and supportability to ensure timely and uninterrupted service for the end user
• Incorporated best practices in Development work environment in all the phases of project lifecycle to in corporate Company’s norms and coding standards
• Documenting root cause analysis, providing documents and s to users
• Strong Experience in Requirement gathering, Gap Analysis, Business Process Modeling, Interacted wif all levels of business owners and users during the various stages of project lifecycle
• Ability to manage multiple responsibilities and meet individual deadlines, while effectively focusing on priority issues wif the emphasis of Integration & User Acceptance Testing s, provided the effort estimations, contributed to production migration, handled post production issues and performed root-cause analysis to ensure the issues are properly closed
• Well versed wif the AIM documentations of Functional (MD050), Technical (MD070), Installation documents (MD120), Test cases (TE020), Conversion Functional (CV040), Conversion Technical Design (CV060) and Conversion Installation document (CV120)
• Excellent communication, good organizational and problem solving skills, verbal and written communication skills, outgoing personality, self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly
• A good team player wif Strong interpersonal and negotiation skills and ability to articulate wif people at all levels and acquiring and implementing new Technologies easily, Self-motivated wif the ability to effectively manage time and succeed in it

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows 2000, Windows NT, Windows 7Oracle Applications 11i and R12 (OM, PO, INV, AP, AR, GL, FA, BOM, WIP, CS, OKS, CSI, PA, WMS, FND)

Languages: SQL, PL/SQL, C, XML, UNIX, JAVA

Database: ORACLE 8i/9i, 10g and 11g

Tools: Oracle Developer Suite 6i/10g Forms/Reports, XML/BI Publisher, Oracle Workflow Builder, SQL*Plus, Discoverer, SQL*Loader, JDeveloper, Putty, SQL Developer, OBIEE, OAF, TOAD, Data Loader, FTP, PVCS

PROFESSIONAL EXPERIENCE

Confidential, Baraboo, Wisconsin

Oracle Apps EBS Senior Consultant

Responsibilities:

• Responsible for design, development, implementation, customization, testing and migration of various Reports, Conversions, Alerts, Interfaces, RICEWF
• Developed concurrent programs for Data Converison of Onhand Inventory Items, License Plate Numbers Direct Organization Transfer
• Worked on APIs and created packages, concurrent programs for generating Lot numbers, License Plate numbers
• Created custom staging table for loading data, package to validate, process General Ledger Interface and Journals Import
• Developed XML/BI Publisher report for Trailer Inspection Shipment by enabling DFF context for Additional Delivery Information of Shipping Execution to capture different Trailer Inspection methods
• Worked on Sales Orders Customer details report, Customized the standard Cycle count listing report, Pick slip report wif ordered and picked quantity
• Developed the Warehouse pallet sheets for sales order reservations, delivery shipments
• Created packages to generate XML tags and used in RTF Templates to generate barcodes
• Developed Periodic Oracle Alerts for delayed Shipment lines, duplicate Customer PO, Event based alert for schedule ship date changes or cancelled order lines
• Created XML/BI Publisher report for Process manufacturing execution of Batch variance report for closed batches to display Products, Ingredients and By-products
• Customized and converted standard Capital Projects Summary report to XML/BI Publisher report
• Developed XML/BI Publisher reports for Projects Purchase commitments, Receivables Invoices report wif Sales orders and Delivery details
• Created Concurrent programs, Value sets, Lookups in the Applications, developed FNDLOAD scripts for LDT download and upload of migrating objects between Instances
• Prepared Technical design documents from the functional specifications received from the functional team
• Responsible for Code build, Technical design reviews, Conversion dry runs, conversion data reconciliations, Code reviews and troubleshooting Technical issues
• Writing extensive PL/SQL Program units like Procedures, Functions, Triggers and Packages
• Prepared Technical Specification Design Document, Unit Test Plan Scripts, Technical specification review checklist
• Involved in the CRP1/CRP2/UAT Functional testing and provided assistance in fixing the identified issues
• Well versed wif the AIM documentations of Functional (MD050), Technical (MD070), Installation documents (MD120), Test cases (TE020), Conversion Functional (CV040), Conversion Technical Design (CV060) and Conversion Installation document (CV120)

Environment: Oracle Applications R12.2.7 (OM, INV, PO, GL, AP, AR, PA, GME, WMS) SQL, PL/SQL, Oracle Developer Suite 10g Forms/Reports, SQL*Plus, XML/BI Publisher, SQL*Loader, Oracle Workflow Builder, Oracle Alerts, TOAD, Putty, SQL Developer, WinSCP

Confidential Erlanger, Kentucky

Oracle Apps EBS Senior Consultant

Responsibilities:

• Responsible for design, development, implementation, customization and testing of various Reports, Conversions, Forms, Alerts, Personalizations, WMS Labels
• Creating PL/SQL Packages, Procedures, Functions for data population and modification as per project requirements
• Developed concurrent program to update Item Master Attributes by using Inventory Items API
• Data load programs for BOM Routings and created conversion program by using Routings API
• Worked on XML/BI Publisher reports using RDF and Data Template for Scanned pallets, Pick load, Shipper document, Bill of lading
• Request group additions and submitting concurrent requests by using FND APIs
• Developed conversion programs for Items Master, Inventory Items Onhand, Items Category, BOM Routings
• Designed and developed custom forms for Outside Processing Items, Customer master labels, Machine Details form
• Created Oracle Alerts for OSP PO Receipts to inform users to perform shipping and also Alerts for WIP jobs
• Forms personalization for Steel coil PO receipts to populate sequence value, label print flag, to make input values of some DFF as required
• Developed concurrent program to load, validate and update Items Attributes as per the business need
• Involved in design and development of Forms personalization of Shipping transactions to restrict ship confirm for deliveries wif no trailer and serial numbers
• Desgined WMS labels and registered concurrent programs for Customer master labels, PO Steel coils, OSP Items and PO Kanban labels
• Data Loader scripts for creating WMS custom sql fields and Label formats
• Assigned work to Offshore resources, performed testing and delivered the client objects
• Created Concurrent programs, Value sets, Lookups in the Applications, developed FNDLOAD scripts for download and upload of migrating objects between Instances
• Prepared Technical design documents from the functional specifications received from the functional team
• Custom tables are created for various objects like Conversions as Staging, Custom Forms to store input data, WMS labels to store and print custom labels
• Responsible for Code build, Technical design reviews, Conversion dry runs, conversion data reconciliations, Code reviews and troubleshooting Technical issues
• Writing extensive PL/SQL Program units like Procedures, Functions, Triggers and Packages
• Prepared Technical Specification Design Document, Unit Test Plan Scripts, Technical specification review checklist
• Involved in the CRP1/CRP2/UAT Functional testing and provided assistance in fixing the identified issues
• Well versed wif the AIM documentations of Functional (MD050), Technical (MD070), Installation documents (MD120), Test cases (TE020), Conversion Functional (CV040), Conversion Technical Design (CV060) and Conversion Installation document (CV120)

Environment: Oracle Applications R12.2.4 (PO, OM, INV, GL, AP, AR, BOM, WIP, WMS), SQL, PL/SQL, Oracle Developer Suite 10g Forms/Reports, SQL*Plus, XML/BI Publisher, SQL*Loader, Oracle Workflow Builder, Oracle Alerts, TOAD, Putty, SQL Developer

Confidential, Little Rock, Arkansas

Oracle Apps EBS Senior Consultant

Responsibilities:

• Responsible for design, development, implementation, customization and testing of various RICEWF components
• Developed various custom reports for Purchasing, Inventory Items Master, Order Management, Receivables, General Ledger, Payables, Service modules
• Developed XML/BI Publisher reports for Pick release Sales order Barcode, Sales orders financial verification, Sub-inventory transfer, Outservice Request reports for Purchasing, AP Invoices payment details, GL Account Details, GL Interface errors
• Worked on program to print Component Invoices, Consolidated Invoice reports for customer services Requests
• Developed outbound interfaces to write the details of Inventory items master, customer details and supplier details onto flat files for use in an External system
• Worked on Conversions for Sales orders, Suppliers conversion, Customer Items Cross s
• Developed Purchase orders interface to upload standard purchase order transactions into Oracle Applications
• Developed Custom forms for annual purchase history monthwise details, Custom superceded items form wif onhand, available and reserved quantity
• Concurrent program to create AR Invoices by using API
• Request group additions and submitting concurrent requests by using FND APIs
• Worked on various Forms personalization for Inventory, Order Management, Purchasing and Service
• Worked on Resolving technical and functional issues during Production support for Distribution, Financial and Service modules
• Developed workflow process for sales order equipment staged and direct flows, process for Margin holds and Credit card payments, Sales order credit hold workflow notifications to Credit Admin group
• Created Oracle Alerts for Receivables interface transactions, Purchase receiving errors alert, Concurrent programs exceptions alert
• Worked on development of new objects and Customization of seeded objects as per the client requirements
• Worked on the Production support issues, unit testing and Integration testing of functionality for PO, INV, OM, CS, AP, AR and GL modules
• Developed reports, conversions and interface programs and registering them as concurrent programs, developed FNDLOAD scripts for download and upload of migrating objects between Instances
• Prepared Technical design documents from the functional specifications received from the functional team
• Developed the assigned RICE components by following development standards for the project
• Creating temporary tables and SQL *Loader control files to load the legacy data into the temporary tables
• Developing packages for mapping, validating the records in conversion staging tables
• Responsible for Code build, Technical design reviews, Conversion dry runs, conversion data reconciliations, Code reviews and troubleshooting Technical issues
• Developed CV060 and CV120 documents for conversions and MD070 and MD120 documents for components
• Writing extensive PL/SQL Program units like procedures, functions, triggers and packages
• Prepared Technical Specification Design Document, Unit Test Plan Scripts, Technical specification review checklist
• Involved in the CRP1/CRP2/UAT Functional testing
• Reviewed the high-level technical architecture of the supply chain solutions and financials
• Well versed wif the AIM documentations of Functional (MD050), Technical (MD070), Installation documents (MD120), Test cases (TE020), Conversion Functional (CV040), Conversion Technical Design (CV060) and Conversion Installation document (CV120)

Environment: Oracle Applications R12.2.4 (PO, OM, INV, GL, AP, AR, CS, OKS, CSI), SQL, PL/SQL, Oracle Developer Suite 10g Forms/Reports, SQL*Plus, XML/BI Publisher, SQL*Loader, Oracle Workflow Builder, Oracle Alerts, TOAD, Putty, SQL Developer

Confidential

Oracle Apps EBS Senior Consultant

Responsibilities:

• Worked on project that mainly deals wif the Oracle applications modules of Financials, Distribution and manufacturing
• Responsible for design, development, implementation, customization and testing of various RICEWF components
• Worked on the PROD support issues, unit testing and Integration testing of functionality for PO, INV, OM, AP, AR and GL modules
• Developed new Custom XML/BI Publisher reports and Customized standard reports for sales order equipment summary report, pick slip, packing slip, Approved purchase order report, Receivables Payment schedules, Customer sales invoices details, Service Request task notes, Service Request billing schedules, AP Invoices register, AP Expense details report
• Developed programs to Update AR Transactions Wif Shipping Instructions, Print draft, accept, reject, reprint Consolidated Invoices, Program to email Invoices, Program to process stuck service lines
• Worked on Items Conversion, Inventory Onhand Quantity conversion, Purchase Orders Interface, Purchase Requisitions Interface
• Developed outbound interfaces for inventory items, Sales order Booking Data Extract for Management reports
• Worked on various Forms personalization for OM, PO, INV modules
• Developed custom forms for inventory items price list wif items cost and subinventory status, Purchase service request details form
• Worked on Custom.pll changes for Inventory, Order Management, Purchasing
• Created Oracle Alerts for Service Request severity update task notes, new Service Request severity creation, Sales order holds notification
• Worked on period closing activities
• Developed reports, conversions and interface programs and registering them as concurrent programs, created value sets for concurrent program parameters
• Review the team codes and approve, involved in Solution Mappings for Business Requirements
• Responsible for Code build, Technical design reviews, Conversion dry runs, conversion data reconciliations, Code reviews and troubleshooting Technical issues
• Preparation of Technical Specification Design Document, Unit Test Plan Scripts, Technical specification review checklist

Environment: Oracle Applications R12.1.3 (OM, INV, PO, CS, GL, AP, AR), SQL, PL/SQL, Oracle Developer Suite 10g Forms/Reports, SQL*Plus, XML/BI Publisher, SQL*Loader, Oracle Workflow Builder, Oracle Alerts, TOAD, Putty, SQL Developer

Confidential

Oracle Apps EBS Consultant

Responsibilities:

• Developed various Custom reports using Reports builder and XML/BI Publisher Reports for Sales order summary, Order Entry Daily, onhand quantity details, Sales quote report, Reseller Packing Slip, Print Barcode Labels, Purchase Requisition details
• Worked on Financial reports for Accounts Payable Trial Balance, Scheduled payments report, Receivables Invoices summary, Sales Tax Report, Customers wif active bill to and ship to locations, Concurrent program to print new Invoices
• Developed Conversion programs for Account Receivables invoices, Account Payables invoices conversion, General Ledger Import Interface
• Worked on Outbound interfaces for customers and contacts details
• Worked on forms personalization for requisitions, purchase orders and sales orders forms
• Creating temporary tables and SQL *Loader control files to load the legacy data into the temporary tables, developing packages for mapping, validating the records in conversion staging tables
• Writing extensive PL/SQL Program units like procedures, functions, triggers and packages
• Developing CV060 and CV120 documents for conversions and MD070 and MD120 documents for components
• Registered the reports and interfaces as concurrent programs
• Developed the assigned RICE component by following the development standards for the project

Environment: Oracle Applications R12 (AP, AR, GL, FA, OM, INV, PO), SQL, PL/SQL, Oracle Developer Suite 10g Forms/Reports, SQL*Plus, XML/BI Publisher, SQL*Loader, TOAD, Putty, SQL Developer

Confidential

Oracle Apps EBS Consultant

Responsibilities:

• Developed RMA receipts XML/BI Publisher report for daily, monthly and yearly transactions, Sales Booking Details, Sales order lines detail
• Customized OM price list extract report, Inventory Items usage report displaying Invoice details along wif Item costs
• Worked on Open transactions check for Items inactive, Intercompany inventory report
• Developed daily, monthly and yearly transactions purchase receipts, Purchase order details printing report
• Worked on Active suppliers distribution sets and terms report
• Created AP Expense Details Report
• Worked on Customers Invoices Receipt details report
• Worked on program to Update Shipping Instructions
• Developed AR customer credit report to display open and closed invoices
• Worked on Items conversion, Price list conversion
• Developed Outbound program for Salesreps, Catalog and Customers
• Worked on Custom.pll changes for Inventory, Order Management and Purchasing
• Developed MD070, MD120, CV060 and CV120 documents
• Registered the reports and interfaces as concurrent programs, created Value sets in various modules of the application, prepared SQL *Loader scripts
• Developed the assigned RICE components by following the development standards for the project

Environment: Oracle Applications R12 (OM, INV, PO, AP, AR, GL), SQL, PL/SQL, Oracle Developer Suite 10g Forms/Reports, SQL*Plus, XML/BI Publisher, SQL*Loader, Oracle Workflow Builder, Oracle Alerts, TOAD, Putty, SQL Developer

Confidential, Irvine, California

Oracle Apps EBS Consultant

Responsibilities:

• Development and Customization of Forms, Reports as per the client requirement
• Developed Service orders service request details, Items setup issues, Inactive items and Inventory Items category details report
• Worked on shipped serial numbers report, developed purchases details report by sales order, inventory on hand quantites by locator
• Developed program to update Requisitions Lines Wif Sales Order Information
• Developed AP Invoice Details report and AP payments register report
• Worked on AR collector notes report, AR Invoice details report, Daily cash receipts report
• Worked on consolidated billing summary and consolidated billing details report
• Worked on GL Inventory source details report, GL Receivables revenue report
• Worked on report for application users not logged from n days
• Developed outbound interfaces to extract Purchase orders and inventory items details
• Developed staged items form to process staged sales order lines, Customer Systems details form and custom form for Items product specifications
• Worked on alerts for RMA receiving errors and return lines wif Awaiting Return Disposition
• Writing extensive PL/SQL Program units like procedures, functions, triggers, cursors, packages
• Defined value sets, concurrent programs, registering reports and PL/SQL procedures and functions, created MD070 and MD120 documents
• Worked on the Production support issues, unit testing and Integration testing of functionality
• Developed assigned RICE components by following development standards for the project

Environment: Oracle Applications 11i (PO, OM, INV, CS, AP, GL, AR), SQL, PL/SQL, Oracle Developer Suite 6i Forms/Reports, SQL*Plus, XML/BI Publisher, SQL*Loader, TOAD, Putty, SQL Developer, Oracle AlertS