SUMMARY

• Been a member of the Functional focus team and about 8 years of IT experience, with a primary concentration on Oracle ERP/CRM implementations and business process re - engineering.
• Functional Consultant specializing in Oracle Application implementations, specifically Financials.
• Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities.
• Experience with Oracle Business Accelerators for e-Business Suite Release 12.
• Experienced in working with Oracle Applications Release 12
• Possess strong knowledge of Supply Chain Management modules of Oracle applications, with concentration on Quoting, OM, OTM, Advance Pricing (QP), i-Procurement, PO, INV, ASCP, GOP, MRP combined with a unique combination of their integration with other modules like Advanced Pricing, Shipping and Oracle Discoverer.
• Extensive experience with the Order to Cash (O2C) and Procure to Report (P2R) business flows.
• Formulated solution design and implementation strategy based on client requirements.
• Configured the application based on solution design, performed gap analysis and designed work around solutions.
• Trained the clients’ super users on the application and conducted pilot testing, integrated testing.
• Design validation & Setups of OM, OTM, INV, AR, Advanced Pricing PO, AP, and Shipping modules.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Experience in preparing Requirement Analysis Documentation, Training scripts, Functional Documentation, User Training Documents and Customization Documents.

TECHNICAL SKILLS

ERP: Oracle Applications R12, 11i

Modules: Quoting, i-Procurement, OM, OTM, Advance Pricing (QP), ASCP, GOP, MRP, PO, BOM, WIP, MRP, INV, AP, AR

Databases: DB2 and Oracle 7.x./8.0.5/8i/9i/10g.

Oracle Tools/ Utilities: TOAD, PL/SQ: developer SQL * Loader, Export, Import, SQL & Monitors.

Operating Systems: UNIX, Windows 95/98/2000, Windows NT

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis IN

SCM Functional Consultant

Responsibilities:

• Created Functional design documents using Data Flow Diagrams and Use Cases and developed Test scripts using Oracle AIM Methodology as part of Bookings- ETM integration project to apply sales rep and territory information from an external system (ETM) to Oracle OM.
• Responsible for driving data conversion/migration and interface planning activities to integrate ETM with Oracle PO and i-Procurement modules.
• Worked on the setup of ASCP, OTM, BOM, GOP, OM, INV and PO Modules.
• Responsible for driving project meetings with various stakeholders from internal Oracle Business teams to external teams (downstream and upstream) to discuss gaps in application design, develop solutions, and formulate testing strategies.
• Study AS-IS Business Process of the Order to Cash and Procure to Pay Flows.
• Worked on Oracle ASCP to setup Constrained plan options, setup for multi node instance, configured the planning flex fields, worked on the ODS Load process, defined the plans and plan options, worked on the ASCP Collection process.
• Worked on the setups of the OTM module.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Worked on setting up of the BOM Structures in Oracle instance.
• Responsible for training the end users on the new processes and facilitated on-the-job training.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in SCM track.
• Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
• Provide inputs and part of the team for new solution.
• Test various business scenarios in the new system.
• Interact directly with end users, infrastructure teams, and project teams.
• Functional design of the Conversion / Integration programs.
• Progress the track thro CRP1, CRP2, UAT & Go Alive.
• Provide user training & documentation

Confidential, St Louis, MO

Oracle SCM Functional Consultant

Responsibilities:

• Created Inventory setups - defined Key Flex fields, Organizations, Inventory Parameters, UOM, Sub Inventories, Item Attribute controls, Categories, Category Sets, Item Statuses, Item Types, Item Templates, Customer Items and Customer Item Cross References, and performed Item Conversion for CRP1, CRP2, and UAT instances for Arco.
• Created OM and Pricing Setups - defined Descriptive Flex fields, Profile Options, System Parameters, Lookup Codes, Order Sources, Transaction types, Document Sequencing, Document Categories, Shipping Parameters, Defaulting Rules, Processing constraints, Order holds, Blanket Sales Agreements, Workflow background process, Price Lists, Modifiers, and Qualifiers for various Arco instances.
• Worked on Oracle ASCP module - setting up the Source definition, Destination definitions plan parameters, supply and demand sources, etc
• Worked on the collection process in ASCP
• Worked on the creating the ATP Flex fields
• Created the routing and BOM for Make Items
• Creating of the ASCP Plans
• Worked on the setups of Global Order Promising (GOP), configuring the ATP Collection Data and Planned Output, Maintenance as a source of supply, supply part condition, defining the instances, ATP Item attributes, Transit Lead Times, Product Family ATP, etc.
• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Performed all the setups for ASCP, GOP, MRP, Advance Pricing (QP), i-Procurement, PO, INV, BOM modules.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Pricing Business Requirement Study and designed / documented Functional Specification.
• Identification of Gap & put collaborative effort with the Technical team to address the same thro Technical Specification.
• Designed and Developed the Test Plan for testing of the System as wells as testing of the entire bolt on modules and custom RICEW components.
• Involved in the Testing of the Advance Pricing (QP), i-Procurement, PO, INV, ASCP, GOP, BOM modules including developing Test Cases, Conducting UATs and CRPs as well as logging defects in the Mercury Quality Center tool.
• Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Conducting Pre Project Review & Post Project Review.
• Providing Post Implementation support
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.
• Created Users, Responsibilities, Menus, Request Groups, and System Profile Options using System Administrator responsibility.
• Created Test scripts for Inventory, OM, and Pricing for scenarios including and excluding customized Order Interface program which linked legacy Order creation system to Oracle OM.
• Created Data Load scripts for loading various forms like Modifiers, Value sets, Lookup codes, Item categories, Items etc.
• Created user training manuals like Customer setup and Supplier setup documents and conducted training sessions for users

Confidential, Greenwood Village, CO

SCM Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the following modules: OM, ASCP, INV, BOM, PO modules.
• Worked on the Functional mapping of data Conversions & Enhancements for OM, ASCP, INV, BOM, PO modules.
• Worked on the ASCP Setups - setting up the planning flex fields, defining the plan options, setting up constraints for the plan, worked on defining the demand and supply sources, worked on tweaking the plan attributes for tuning the plan, etc.
• Worked on setting up Defaulting Rules and Processing Constraints in the OM Module.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured Oracle AR, OM and Shipping from scratch and simultaneously created BR100 documentation for the setups.
• Setup the Approval Hierarchies in Oracle Purchasing module.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for SCEA by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in OM, ASCP, GOP, INV, BOM, PO, i-Procurement, Shipping and Advance Pricing Modules.

Confidential, Nashville, TN

Oracle SCM Functional Consultant

Responsibilities:

• Responsible for resolving their day-to-day issues in Advance Pricing (QP), i-Procurement, PO, INV, AP, AR.
• Providing functional Support assistance to OM and AR Internal Customers.
• Actively handling Order Management & Shipping Production issues in areas like stuck SO lines, RMAs, Pick Release, Pick slip & Shipping documents, Adjustments & maintaining setups.
• Worked on Inventory setup changes, real time defect resolution in areas like Inventory Move Order, pending Inventory transactions, material on hand & transaction quantity mismatch, Item control, Sub inventory Transfer & Month end closure.
• Played an important role on Advanced Pricing setups, designing Pricing Formulas, Price rounding, Modifiers, Pricing Events, Partial Pricing, Qualifiers, DFFs to track Price changes, assessment for tiered Pricing for expedited orders & maintaining Intercompany Transfer Pricing.
• Ensured appropriate seeded workflows in OM are used in the transactions. Resolved issues in application setup and configuration with the Financial Consultant to ensure proper interfacing of AR with OM and AP with Purchasing, and Inventory with GL.
• Extensively worked on Receivables and configured setups for organization structure, Auto invoice, auto accounting, Receivables Activities, distribution sets, Application of Receipts to transactions and invoice printing with remit address
• Creating Service Requests & coordinating with Oracle Metalink Support for issue resolution, bug tracking, requesting back ported patches, testing patches towards defect fixes in OM, Shipping, Inventory, Pricing & Purchasing areas.
• Update the BRD’s manuals/cheat sheets on a regular basis for all the business processes.
• Handling a team of 4 members and responsible for their productivity, efficiency & quality.

Confidential, Detroit, Michigan

Oracle SCM Functional Consultant

Responsibilities:

• Setup Document Approval / Approval Group / Assignments, Purchasing Options
• Define Line Types and Doc Types, Lookup Codes, PO Profile Options
• Create Requisition, Auto Create RFQ, Corrections
• Defining Standard, Blanket Purchase and Contract Purchase Agreement
• Define Supplier & Item Combination, Sourcing Rule, Approved Supplier List,
• PO Control, Release PO, Receipts, Run Reports & Journal Import Programs Quoting/Order Management/Costing
• Defining Flex field, Profile options, System parameters, Document Sequences
• Worked on both CTO and ATO Models.
• Worked on setting up the warranty contracts in Service Contracts.
• Worked on configuring Install Base to capture Reseller, End User and Distributor information for each Instance item.
• Set up Transaction Types, Applying & Releasing Holds, Credit Checking
• Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes
• Defining Modifiers, Qualifiers, GSA Price List, Pricing Formula
• Defining Standard, Internal, RMA and Drop shipment Orders
• Define Pick Release, Pick Release rules, Shipping Parameters
• ATO & PTO Models, ATP Checking, Availability & Reservation
• Setup Modifiers and Qualifiers in QP.
• Setup the pricing attributes in QP
• Setup the Dynamic formulas for pricing in QP.
• Setup the Attribute mapping in QP
• Setup the QP profile options.
• Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type
• Established a Item Category and Item Cataloging for their products.
• Defined a ABC Analysis and Cycle Count
• Established Customer Item and Customer Item Cross Reference
• Established a process for smooth month end closing procedure in Inventory

Environment: Oracle Applications 11.5.9 (AR, AP, GL, AOL), Forms 6i, Reports 6i, Oracle 9i (SQL, PLSQL), TOAD, SQL Loader and HP-UNIX, Discoverer

Confidential, San Diego, CA

Oracle Applications Business Anlayst

Responsibilities:

• Prototype the business process by mapping against the functionality of the modules in a test database installed as a part of the Oracle Applications installation process.
• Set up OM Transaction Types, OM Parameters.
• Set up Inventory Organization for OM related items.
• Defined time limit for Booking of Order, Scheduling of Order, Closing Order Lines and Order Headers.
• Set up pricing parameters/list.
• Inventory On hand availability Checking, Pick Release Rules, and Back Ordering decision.
• Set up Shipping Parameters/Rules, Containers, and Granting Roles to Users.
• Document sequencing for Order Numbering.
• Modification/cancellation of Orders/Order lines.
• Created MD050 based on RD020 and RD050.
• Prepared TE020, TE040 based on MD050.
• Developing test scenarios and testing the code units developed
• Testing the system for specific scenarios after upgrade to 11.5.9
• Coordinating with the client for requirement related discussions.

Environment: Oracle Applications 11.5.9(AP, OM, GL, Oracle Workflow 2.6, PL/SQL)