PROFESSIONAL SUMMARY:

• Over 12 years of experience in Oracle Applications OTC and P2P, worked as a functional lead for the Implementation and Conversion and set up of Oracle Distribution/ Manufacturing / Supply chain / financial applications. Experience includes managing projects using Oracle’s AIM methodologies.
• Experienced in Requirement Analysis, Data Mapping, Gap Analysis, Design, Development, Implementation, Upgrade, RICE Developments, Data Conversion/Migration, Testing and Production Support in Oracle EBS 11.5.10, R12 versions and related products, tools and integrations with third party tools and external Applications.
• Has broad experience in all phases of design, development and implementation of Order Management, Inventory, WMS, Purchasing, MRP, ASCP, MSCA, Advanced Pricing, WIP, BOM, Receivables, EDI, and GL.
• Experienced in all phase of Project Implementation on both Functional and Technical activities. Completed multiple full lifecycle implementations in OM, INV, PO, WMS, MSCA, AR, AP, GL, WIP, BOM, EDI modules.
• Also have broad experience with Oracle Apps technical architecture and Oracle tools and experienced in Pl/Sql,, Workflow, Forms and Reports, Discoverer, NOETIX,OA Framework and XML Publisher Reports .
• Serve as a liaison between the business and IT to provide Oracle Functional and technical business solutions that meets needs of client managers and other stake holders.
• Strong Documentation skills and analyzing the business processes and on developing detailed user requirements and functional specification documents and strong process management, analytical skills, and experience in quality assurance testing
• Ability to lead and motivate high potential project teams to ensure timeliness and quality of deliverables.
• Currently working as a Business IT Analyst for AT&T. Extensively Involved in Analysis, Design, Testing, and Maintenance, Data Migration, Data mapping and Quality Related Activities with SOX requirement for full life cycle of the ERP project.
• Self - motivated and results oriented collaborative thinking, experienced in managing multiple competing priorities and tasks effectively across multiple functional and technical tracks.

TECHNICAL SKILLS:

Packages: Oracle Applications R12, 11.5.10.2, 11i, 11.5.9, 10.7, 11.0.3Modules:Oracle Manufacturing: Order Management (OM), Inventory

(INV), Purchasing (PO), Advanced Pricing (QP)Work in Process (WIP), Bill of Materials (BOM), Costing (CST), ASCP, MSCA, WMS

Oracle Financials Oracle Payables (AP), Receivables (AR)General Ledger (GL), Project Accounting and Billing (PA)

Programming Languages: PL/SQL, Shell scripting, SQL, XML

Development Tools: Oracle Forms 6i, 4.5, Oracle Reports 6i, 2.5, Oracle BIOracle Workflow 2.4, XML Publisher, Oracle Discoverer

Database: Oracle8i/9i, 10g

Operating System: Windows XP, UNIX, WINDOWS NT

Tools: LOFTWARE, NOETIX, Kintana, ClearCase, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Functional Consultant

Responsibilities:

• Responsible for designing process maps and leading SIT, UAT and user and implementation at on site in the distributions and Logistics center.
• Worked on signoff on Business Requirement Traceability Matrix, process maps, solution designs, documentation on test plans, UAT scripts, User docs and implementation plans etc.
• Responsible for implementing Shipping Execution and MSCA in R12, Implementation involves pick/pack and shipping execution in Mobile Supply chain environment and bar-coding the items, sub-inventories and locations.
• Requirements gathering, facilitation of learning, defining process for implementation and and work with the business (Supply chain analysts, warehouse workers, etc).
• Requirements gathering, facilitation of technical docs (MD-50, MD-70s, MD-100). Responsible for translating high-level business requirements into detailed IT specifications

Confidential - Atlanta, GA

Business Analyst

Responsibilities:

• Worked as business analyst in Order Management, Shipping Execution and Warehouse Management System (Oracle WMS) implementation, which includes the Warehouse and Inventory Management sections, and the simultaneous implementation of the Label printings with Bar Codes.
• Responsible for Requirement Analysis /Feasibility Study Regression Testing Update/Create (BR100, MD50, TE050), for functional application processes and Participation in Business Lean workouts Solution Prototyping-Analysis/Control of application function.
• Major activities includes process maps and gap analysis, developing solution designs, end user and creation of test case documents
• Designed MD50s for Sales orders interface from Legacy systems, Backorders interface, stock Replenishments interface and pricing interface from legacy systems.
• Configuration of Shipping Labels and printing the shipping Content Labels.

Confidential, Charleston, SC

SCM Functional Consultant

Responsibilities:

• Worked as a Business Analyst for Enhancing OM for upgrade to R12, Implemented Holds, Processing Constraints and Defaulting Rules to support new processes, Implemented Item Relationships and Customer Item Cross s to enable substitution and cross- during Order entry, Setup Profile options, System parameters, Quick Codes, Document Sequences, Transaction Types, Defaulting Rules, Order Import Source, Validation Templates, resolving stuck Sales Orders, Returns and Invoices, correcting serial numbers, resolving delivery exceptions, design and implemented new Credit and rebill process including, enhancing and creating new workflows, setup form personalization for Order, line delivery and ship set Weight.
• In shipping execution, involved in the Setup Roles, Shipping and Pick Release Parameters, Delivery Parameters, Freight Carriers and Ship Methods, Document Sequences and Categories Etc
• In WMS worked on the Configuration of Shipping Labels, and printing the shipping Content Labels and Concatenate the Sub inventory and Locators in the WMS and produced new barcodes in order to save time while scanning and reduce Picking errors.
• In WMS worked on Cartonization of Container Items, Defining Load Container Relationship and Multi Level Cartonization and worked on the setting up automatically suggest packing configurations for groups of items.
• Worked on the Transaction Management like Material Transaction which supports both non-stocked items and stocked items and involved in the setup of RF Device Compliance and LPN Based Returns
• Worked on feasibility and effort analysis, and explaining R12 new functionality to Users and managers in Oracle Distribution Modules. Developed solution design for Planning Bill Of Material firmed order history interface and developed solution design for PBOM Forecast load interface from Legacy mainframe application.
• Developed solution design for Pegging Report, Demand vs Replenishment, Forecast Comparison Report, Projected Inventory Level Report and 12 month forecast for specific Product types.
• Responsible for setup Trading Partners and maintenance of EDI "OUT: Planning Schedule (830/DELFOR)" for Planning Schedule with Release Capacity.
• Responsible for developing and maintaining trading partner definitions, and handling communications with trading partners for EDI transaction set-up and ongoing maintenance.
• Developed integrated test scenarios, identify test data, execute test scenarios as part of system integration testing, troubleshoot and resolve issues identified and document test results.

Confidential, Burbank, CA

Functional Consultant - SCM

Responsibilities:

• Involved in designing, developing interfaces, customizing user requests and implementation change requests. During these processes interacted with end users and implemented their requirements into the Application Systems.
• Involved in the implementation of new enhancements in OTC.
• Developed custom Workflow for RMA Receipts in Order Management. For the RMA's based on the returns value the Approval notifications should be sent to the Primary and Secondary approvers.
• Designed MD50 and implemented the ‘RMA with Quality and Finance Approval processes’ based on the transaction types. lid Terminations etc.
• Designed MD50 for complex reports for business users such as Supplier Delivery Performance, Purchase Price Variance reports Etc in Purchasing, Planned Order Reports, On-time Delivery Bucket Reports Etc in OM and PO.
• Worked on configuring the Discoverer Reports with NOETIX Views and custom views and end User s.
• Creation of test script documents; lead the conference room pilot (CRP) phase of the project.
• Wrote a guide for users, and used this guide to conduct sessions.
• Designed various rtf Templates with BI / XML Publisher to print the report values with Barcodes for scanning purposes.

Confidential

Functional CONSULTANT

Responsibilities:

• Worked as Functional Lead for the Order to Cash (OTC) business cycle process implementation
• Involved in business requirement gathering, identifying gaps, design solution to resolve gaps in the standard Oracle Apps, Configuration, testing, and all documentations
• Designed MD50 and implemented the solution design for ‘Daily Sales Orders Interface and maintenance’ Interface program.
• Worked on solution design for customized Internal Sales orders cycle, Item sourcing and internal customer Returns customizations.
• Complete ownership on the Implementation of Custom Internal Returns Process between the Inter/Intra Organizations across the Operating units.
• Implemented the Custom Calculate Price Interface from FO legacy system and Price List Conversion and Maintenance.
• Involved in Post-production troubleshooting and analysis of business process issues within: OM, WMS, Shipping, INV and Customer Master and Involved in the sorting technical problems with team related to Order Management, Purchasing and Inventory.
• Designed various functional design documents MD50s and technical design documents MD70s and process maps related to various custom components for the implementation of EBS.
• Developed MD50 for On Hand vs Available Report, Planned order Reports for Inventory projection.

Confidential, Schaumburg, IL

Functional Consultant - OTC

Responsibilities:

• Worked on the requirement gathering, estimations and preparing the Emergency/ Micro Project documents for new enhancement requests from client.
• Designed MD50 and MD70 for Customers & Open Invoice conversions. Created specifications for custom reporting requirements, worked with technical team for development & testing of the custom reports (OM, AR, INV)
• Designed solution design for various custom forms like 'Stock Enquiry Screen’, 'Custom ASN Form' in Oracle11i using Forms6i and modified Oracle Standard forms 'Inter Organization Transfer Form’ (INVTTMTX.fmb), 'Miscellaneous Transaction Form (INVTTMTX.fmb) using CUSTOM.pll.
• Designed solution design for developing and printing various custom reports like ‘MIN-Max Planning Report’, ‘Print Sales Order Report’, ‘LPN Label reports’, ‘Stock Receipt reports’, ‘Commercial Invoice Report’, ‘Custom Sales Order Printing Report’, ’Customer Returns Report’ etc. to the 3rd Party printing tools OPTIO, LOFTWARE.

Environment: Oracle E Business Suite11.5.8, Oracle9i, Forms6i, Reports6i, KINTANA, TOAD

Confidential

Functional Consultant

Responsibilities:

• Studying client processes, developing AS-IS and TO-BE maps, assisting in implementation.
• Responsible to Capture Functional & Technical requirements in interaction with the Client.
• Mapping the business requirements in relation to Oracle Application functionality.
• TO-BE design to meet the client needs.
• Complete ownership of customer issues in Order management, Inventory and Purchasing and providing end-to-end solutions

Environment: Oracle Applications E Business Suite11.5.7, Oracle9i, Forms6i, Reports6i, KINTANA, TOAD

Confidential

Technical Lead

Responsibilities:

• Responsible to Capture Technical requirements in interaction with the Client.
• Worked in Custom.pll to customize the Forms to meet the Client Requirements.
• Worked in the customization of Reports and registration of Forms and Reports, adding Value sets and DFF’s.
• Implementing Oracle defined Patch sets and Upgrades Interfacing Apps with external applications as required. Regular interaction with Oracle Corp. - (Localization support teams) through the Metalink.
• Implemented in the data setups like Organization setups and Items
• Giving online with test data to end users in Purchase and Inventory modules.

Environment: Oracle Applications E Business Suite11.5.7 (OM, PO, INV), Oracle9i, Forms6i, Reports6i, KINTANA, TOAD