SUMMARY

• Proficient work experience as techno - functional consultant in Oracle ERP Application (R12, 11i).
• Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E-Business Suite (EBS).
• Lead consultant for Supply chain and manufacturing modules.
• Outstanding Functional/Technical Knowledge in Oracle Applications with Distribution and Supply Chain Modules(SCM) like (OM-Order Management, INV-Inventory, PO-Purchasing, AP-Oracle Payables, MRP-Material Requirements Planning, ASCP- Advance Supply Chain Planning, WSH-Shipping, OTM- Transportation Management), Manufacturing Modules such as (BOM-Bill of Materials, WIP-Work in Progress, WMS- Warehouse Management).
• Hands on experience on PO, OM, WMS, INV, AP, BOM, WIP, OTM modules.
• Expertise in Customization, Production Support, Upgrade and Implementation and of Oracle Supply Chain and Manufacturing modules.
• Excellent skills in Oracle 9i,10g,11g environments using SQL,PL/SQL, Developer 6i/2000 (Oracle Forms 6i/10g and Reports 6i/10g), Discoverer 10g.
• Experience in Designing and developing reports using XML/BI Publisher.
• Strong coding experience in PL/SQL development using Packages, Stored Procedures with Functions, Triggers, Writing and Tuning complex SQL statements.
• Expertise in Design, Development and Customization of RICE (Reports, Interface, Conversions and Extensions) using PL/SQL, SQL *Loader, UTL File etc.
• Extensive experience in customization of forms, Form Personalization, Customization of Reports, defining value sets and Defining Profile values by using Application Object Library (AOL) and Functional setups.
• Experience in all aspects of Software Development Life Cycle including System Analysis, Software Design, Development, Implementation and Testing.
• Strong working knowledge in Order to Cash (OTC), Procure to Pay (PTP) and Drop Ship processes.
• Experience included an Inventory implementations.
• Expertise on designing and implementing Oracle Alerts and Lookups.
• Worked in designing various Technical and Functional Documents like BR100, MD050, MD070 and MD120 and Conversion Mapping CV060 using AIM Methodology.
• Ability to learn and implement the setups needed for supply chain and distribution modules.
• Expertise in providing Proactive and reactive support for supply chain and manufacturing support issues.
• Excellent analytical, problem solving, communication skills and interpersonal skills and consistently being organized by management and peer for producing high quality work.

TECHNICAL SKILLS

ERP Versions: Oracle Applications EBS R12 (12.1.4, 12.0.4), 11i (11.0.3)

Modules: Oracle Purchasing (PO), Oracle Inventory (INV), Advanced Supply Chain Planning(ASCP), Material Requirements Planning(MRP), Order Management (OM), SCM, Shipping (WSH), Bill of Materials (BOM), Work in Process (WIP), General Ledger (GL), Oracle Payables (AP).

Languages: PL/SQL, SQL, C, C++, Java, HTML, XML

Self-Service Modules: iProcurement, i-Receivables

Tools: Developer 2000, XML Publisher, SQL*Loader, Toad, PL/SQL Developer, SQL*PLUS, Oracle Workflow, Oracle Discoverer 10g/9i, OA Framework

Databases: Oracle 11g, 10g, 9i, MS SQL Server 2010

Operating System: Windows NT, UNIX, Windows-95, 98, 2000, 2003, 2007

PROFESSIONAL EXPERIENCE

Confidential, Grand Rapids, MI

Supply Chain Techno-Functional Consultant

Responsibilities:

• Played a key role as supply chain production support specialist by addressing client global markets in Europe and Asia with the required Oracle specialty needs.
• Helped stabilize new implemented large markets like Russia, Ukraine and multiple Europe countries by resolving root causes.
• Hands on with Oracle Supply Chain modules OM, INV, PO, WSH, WMS, WIP, BOM according with the new business process on EBS.
• Performing month-end closure activities and resolve pending transactions which are preventing the closure.
• Performed Year End Closure and wall-to-wall cycle count and resolved pending material and shipping transaction using a proper action plan.
• Hands on experience in Oracle Procure to Pay (P2P) and Order To Cash (OTC) business cycles.
• Perform End-To-End testing transactions after system maintenance window.
• Played a vital role on process improvements, identified process defects, and assisted business users resolving shipping, inventory, procurement and invoice problems.
• Create or enhance INV, OM, PO modules setups according to business requirements.
• Performing troubleshooting Oracle production issues reported by business users through tickets or other requests through Remedy ticketing tool.
• Assisted creating a sharepoint site plan to help business users to resolve the repetitive process errors by themselves hence the number of tickets would be decreased.
• Resolve production support tickets as per organization SLE protocol using ticket monitoring tool Remedy.
• Trained new team members joined the team with a detailed scheduled plan.
• Collaborate and work with offshore team in Malaysia to ensure the production issues getting resolved the soonest possible.
• Maintaining health on Oracle Inventory, Receiving, WIP, Shipping Interface tables.
• Analyze and modify concurrent job schedules and complete the change documentation accordingly.
• Assist in development of other functional specifications for enhancements as per business requirements.
• Run various Oracle reports and SQL scripts to make sure that the development work comply with organizational procedures.
• Collaborate in definition of business processes, documentation of business processes and systems requirements, conceptual designs and/or feasibility studies for proposed system capabilities.
• Perform proactive and reactive support for organizational Oracle issues.
• Provide automation for fixing frequently occurring oracle issues working through a standard operating procedure.

Environment: Oracle Apps EBS 12.1.3, Oracle Apps EBS 12.0.4, Procure-2-Pay(PTP), Order-To-Cash(OTC), SCM, Oracle D2K 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, OM, INV, PO, WMS, WSH, OTM, ASCP, BOM, WIP, TOAD, Discoverer, XML Publisher, SQL*Developer, Oracle Forms, Oracle Reports, UNIX, Shell Scripting, WINDOWS XP.

Confidential, Ann Arbor, MI

Techno-Functional Consultant and MFG Lead

Responsibilities:

• Working in Confidential Support Project as Supply Chain (SCM) and Manufacturing support consultant.
• Manufacturing lead for the onsite and offshore resources.
• Hands on with Oracle Supply Chain modules OM, INV, BOM, WIP, PO, WMS, WSH according with the new business process on EBS.
• Hand on experience in Oracle Procure to Pay (P2P) and Order To Cash (OTC) business cycles.
• Create or enhance INV, OM, PO modules setups according to business requirements.
• Developing PL/SQL packages, Oracle forms, Reports, API to fulfill business requirements.
• Performing troubleshooting of Oracle problems reported by business users through tickets or other requests through Tract It ticketing tool.
• Designed and developed automation process to fix frequently occurring errors in Inventory Transaction Open Interface.
• Designed and developed automation process to push workflow if the orders stuck at ‘INTERNAL REQ REQUESTED’ or ‘SUPPLY ELIGIBLE’ status.
• Designed the plan to create a web portal to assist business users to resolve the common process errors by themselves hence the number of tickets would be decreased.
• Automation through alerts: Developed alerts to notify warehouse managers if the on hand quantity of transaction items fails in sub-inventory locators.
• Design and Develop Oracle EBS R12 functionalities using Custom Alerts and API’s.
• Creation and execution of test plans for Oracle business enhancements.
• Helped client setup and train off shore support team in India so as to keep 24X7 production support.
• Lead offshore towards tangible results.
• Maintaining health on Oracle Inventory, WIP, Shipping Interface tables.
• Fixing month end pending inventory and cost transactions in MMTT and MMT tables and closing inventory accounting periods.
• Develop Reports using BI publisher and Discoverer.
• Assist in development of other functional specifications for enhancements as per business requirements.
• Performs Oracle month end Inventory accounting period closures.
• Run various Oracle reports and SQL scripts to make sure that the development work comply with organizational procedures.
• Collaborate in definition of business processes, documentation of business processes and systems requirements, conceptual designs and/or feasibility studies for proposed system capabilities.
• Perform proactive and reactive support for organizational Oracle issues.
• Provide automation for fixing frequently occurring oracle issues working through a standard operating procedure.
• Fixing manufacturing, shipping issues and LPN receiving issues.

Environment: Oracle Apps EBS 12.0.4, Procure-2-Pay(PTP), Order-To-Cash(OTC), SCM, Oracle D2K 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, PO, OM, INV, WMS, WSH, OTM, ASCP, BOM, WIP, TOAD, Discoverer, XML Publisher, SQL*Developer, Oracle Forms, Oracle Reports, UNIX, Shell Scripting, WINDOWS XP.

Confidential, Pittsburgh, PA

Technical consultant

Responsibilities:

• Worked in Confidential ERP implementation project as an Oracle Applications Technical Consultant.
• Setup update in SCM modules OM, INV, PO according with the new business process on EBS.
• Involved in the requirement gathering, analysis and design of the interfaces and reports.
• Developed custom forms and reports to correct interface errors and send the error messages to legacy system owners.
• Designed and developed custom forms for the data collection of Confidential Customer health diagnostics, health history, subsequent financial information, desired shipping details.
• Handled various responsibilities in Advanced Supply Chain Planning (ASCP) module.
• Using SQL*Loader loaded the data into staging table, Developed PL/SQL packages to validate the data and load into interface tables.
• Responsibilities included technical design, development and support for “Order to Cash (OTC)” and “Procure to Pay (PTP)” business processes.
• Developed a custom layout XML format according to the user specifications and worked on incorporating it to the standard print Purchase Order and Invoice reports using XML Publisher (BI Publisher).
• Trained in process flows of SCM modules.
• Developed packages to validate and to load data from staging table to interface tables related to procure to pay life cycle.
• Developed custom reports: Sub Ledger Accounting Report and New Account Code Combination Report using XML Publisher.
• Involved in migrating developed objects between instances.
• Developed custom shell scripts to create synonyms and grant necessary permissions for the objects which are being migrated into new instances.
• Well versed with application setups.
• Generated reports in D2K level.
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).

Environment: Oracle Apps EBS 11.5.8, Procure-2-Pay(PTP), Order-To-Cash(OTC), SCM, Oracle D2K 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, PO, OM, INV, WMS, SHIPPING, AP, AR, GL, MRP, ASCP, BOM, WIP, TOAD, Discoverer, XML Publisher, SQL*Developer, Forms(6i), UNIX, Shell Scripting, WINDOWS XP.

Confidential, Washington D.C

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).
• Responsible of business requirements gathering and definition, gap analysis, processes mapping, Proposal Design of Third Party Management Project Proposal.
• Handled application setups.
• Developed reports to handle multi-currency exchange gain and losses.
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables.
• Experience includes technical design, development and support for “Order to Cash (OTC)” and “Procure to Pay (PTP)” business processes.
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level
• Modified custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Developed Business Areas, Custom folders, Item classes, Hierarchies in Discoverer Administration Edition
• Modified Workbooks based on the Custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop.
• Involved in Performance tuning of the discoverer reports.
• Generated reports in D2K level.
• Modified and created new concurrent programs as well as executable files when new reports were created.
• 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.
• Development/modification of custom reports in purchasing and payables.
• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.
• Preparation of technical and Solution Design document for offshore developers.

Environment: Oracle Applications EBS R12, OM, AP, AR, Reports D2K 6i/10g, SQL, PL/SQL of Oracle 9i/10g, Order-To-Cash(OTC), PL/SQL on UNIX, Windows 2000/NT environment, Forms 6i/10g, Discoverer10g, XML/BI Publisher, Toad, SQL*Loader.

Confidential, Seattle, WA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Studied the existing system, reviewed it and suggested possible enhancements and implemented the changes as per the new business process upon approval.
• Involved in preparing BR 040 documents in order to map the data elements from the legacy system to the target application modules.
• Performed migration of lookup types, value sets, Descriptive Flex fields, Profiles, XML templates, concurrent programs, request sets, requestgroups, menus, responsibilities, and alerts between database instances.
• Analyzed the various reports that require customization in EBS OM, Inventory (INV), Advanced Supply Chain Planning (ASCP), Material Resources Planning (MRP). Customized Sales Order Acknowledgement report to meet the business requirements for Retail orders.
• Extensively worked on “Order to Cash (OTC)” and “Procure to Pay (PTP)” business processes.
• Strong experience in EBS SCM INV, ASCP, MRP, BOM, WIP modules.
• Designed & developed the custom interface program to create and update an item in Item Hub with database validations.
• Developed Schedule Ship report to identify the errors in the shipment dates for the retail customers.
• This report lets the internal sales force identify the manual errors committed during the order booking process.
• Developed custom edits to notify the user about the faulty data based on different business rules.
• Developed AR Customer Conversion Process from the legacy systems to Oracle Apps.
• Worked in Data Analysis of various systems to compare data and the data flow of the complete system.
• Developed reports like Pick Slip, Packing Slip, and Mailing Label for Shipping and Credit Order Detail, Orders by Item, Order Detail & Summary Reports for Order Management and also Created New Reports as per client requests using XML Publisher.
• Developed error report to display the multiple quotes, quotes missing an order, orders missing quotes and all the other error scenarios. Also scheduled all the above reports to run periodically.

Environment: Oracle Applications EBS R12 SCM(OM, PO, ASCP, MRP, BOM, WIP, INV, Order-To-Cash(OTC), Oracle D2K Reports 10g, Oracle Forms 10g, SQL, Oracle 10g, SQL* Loader, PL/SQL, TOAD, Windows 2000/XP, UNIX.

Confidential, Boca raton, Florida

Oracle Technical Consultant

Responsibilities:

• Worked on the entire life cycle of the project starting from Requirements Gathering, Analysis, Design, Development, System Testing and Production support
• Involved in the complete Order-To-Cash (OTC), Procure to pay cycle (PTP), Oracle Grants and Projects implementation.
• Worked on Project Costing to monitor Project Performance, Capitalize on Global Opportunities and Evaluate expenditures.
• Developed interface programs for the conversion of grants accounting data into Oracle database
• Developed interface program for conversion of sales orders using the Order Import Open Interface program.
• Customized various EBS SCM modules INV, BOM, WIP.
• Developed interface program to import Purchase Order receipts from the legacy system to Oracle Applications
• Developed interface programs for conversion of PO data using Requisitions Open Interface and purchasing documents Open interface
• Designed and developed an Interface program to load open invoices from legacy system into Oracle Payables
• Designed and developed an Interface program to load receivables data from legacy system into Oracle Receivables
• Worked with Auto Invoice interface to upload the invoices into the AR tables
• Worked on creating custom programs to import Journals from a legacy system into Oracle General Ledger.
• Customized the Order Header workflow to place custom holds as per client requirement before the order is booked.
• Customized PO Requisition Workflow and FA account generation workflow.
• Customized Requisition Account Generator and Approval workflow for iProcurement and Customized the Accounts Payable Vendor Entry Form as per requirements.
• Worked on design, customization and personalization of forms using Forms 6i.
• Gathered user requirements on AR revenue-reports from executive team and designed the revenue reports using Discoverer 10g.
• Developed Business Areas and respective folders for various departments and created Budget Balance Reports using Discoverer 10g
• Developed Cross functional, Budgeting and Grants Activity History reports using Discoverer 10g.
• Developed new reports in BI Publisher and converted various Oracle Reports to BI Publisher.
• Involved in Unit testing of the components in development instance according to the test cases provided.
• Worked with various performance tuning techniques.
• Involved in the development of BR120, MD50s and MD70s using AIM.

Environment: Oracle Applications EBS 11.0.3 (OM, INV, Shipping, PO, AP, ASCP) Order-To-Cash(OTC), PTP, WIP, BOM, BI Publisher, Crystal, Builder 2.6, Developer 2000/6i, Discoverer 10g,PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX.

Confidential

PL/SQL Developer

Responsibilities:

• Created of system design document and estimation of efforts
• Modified existing Packages and stored procedures.
• Created tables, functions and procedures.
• Created Synonyms, sequences wherever necessary.
• Created various triggers to enforce business rules.
• Analyzed the departments Oracle 9i configuration, architecture, and open Application Programming Interface API in the current environment.
• Involved rebuilding the modified application and deploying in the production environment.
• Frequently interacted with Business analysts, testers and end users to optimize modified object.
• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs, for best results, used these tools with EXPLAIN PLAN.
• Created various SQL and PL/SQL scripts for verification of the required functionality.
• Involved in Index Monitoring for identifying the Unused Indexes.
• PL/SQL Collections were extensively used for high performance of stored procedures
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Developed Forms, Triggers and Shell Scripts to load the staging tables.

Environment: Oracle 9i, PL/SQL, SQL Developer, SQL*Loader, Forms, Power Builder 9.0, UNIX.