SUMMARY

• Member of the functional focus team and 8 years of IT experience, with primary concentration on Oracle ERP/CRM implementations and business process re - engineering.
• Senior Functional Consultant specializing in Oracle Application implementations, specifically Oracle Supply Chain modules of OM, ASCP, GOP, INV, PO, VCP, BOM, ASCP, WIP Advance Pricing, Shipping, Rapid Planning, WMS
• Extensive experience in the Functional aspects of Oracle Applications 11i, Release 12.0.3 and 12.1.1 and execution of 4 full lifecycle Oracle Applications implementations including the exposure to e-Business suite Release 12, numerous Application Support projects, RICE implementations, upgrades, with high level of Customer Satisfaction.
• Worked on i-Procurement and i-Supplier modules.
• Well conversant with Oracle Distribution Modules - Quoting, Sales Contracts, Service Contracts, WMS, Order Management and Purchasing, i-Procurement, i-Expense and Oracle Financials modules - Oracle AR, AP, GL and FA
• Extremely skilled with the Order to Cash and Procure to Pay business flows.
• Design validation & Setups of OM, INV, AR, Advanced Pricing PO, AP, and Shipping modules.
• Extensive engagement work and project implementation experience has given him an insight into the interactions between Oracle’s modules and project implementation methodologies.
• Business experience and background has helped to foster a detailed knowledge of best practices regarding the accounting and finance functions.

TECHNICAL SKILLS

ERP: Oracle e-Business Suite (11i and Release 12) - i-Procurement, Procure to Pay, Oracle Accounts Payables, O2C, INV, Oracle General Ledger, Accounts Receivables, Oracle Purchasing, Oracle Order Management and Oracle Inventory, WMS, ASCP, GOP, VCP

Scheduling Software: APPWORX

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

PROFESSIONAL EXPERIENCE

Confidential, Santa Ana, CA

SCM Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the Order to Cash Business flows including OM, INV, BOM, WIP, ASCP, VCP, GOP, PO, i-Procurement, Shipping and Advance Pricing, Rapid Planning modules.
• Worked in the configuration of the OM, INV, ASCP, GOP, BOM, PO, Rapid Planning, i-Procurement, Shipping and Advance Pricing modules.
• 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.
• Discussing with business users and preparing BP80 for future To Be Process documents for OM, INV, WMS, Shipping, Advance Pricing
• Performed Requirement and Gap analysis.
• Worked on the Value Chain Planning modules of Advance Planning Command Center, ASCP, Collaborative Planning, Demand Management, GOP
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• 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.
• Worked on the setups for AME including the setups of Approval Rules, Attributes, Parallel Approval Process, Conditions, Actions, etc.
• Defined all of the Transaction Types in OM module for all header and line workflows.
• Worked on the customization to the OM Backlog, Billing and Bookings report.
• Worked in a team in understanding the integration of OM with AR process
• Worked on setting up the Trading Community Architecture (TCA) Module.
• Progress the track through CRP1, CRP2, UAT & Go Alive.
• Pre upgrade testing and Post upgrade production live support.
• Worked on the WMS Setups like Warehouse setup, Warehouse Org Setups, Locator Zones and Parameters, task type assignment rules, label formats, associating label types to business flows, receiving parameters, picking rules for warehouses, operation plan selection rules, advanced lot control, lot and serial attributes, Cartonization, Container Items, Contained Items, cost groups, cycle counts, etc.
• Worked on the configuration of the INV module - setting up the Inventory Orgs, Sub Inventories, Categories, Catalogs, Item Templates, Min Max and Reorder point planning, Cycle counting, ABC Analysis, etc.
• Working with Technical team closely and getting done development for customizations for OM, INV, WMS, Shipping, Advance Pricing Modules.
• Working closely with Business users to understand the criteria’s and filters for converting data from 11.0.3 to 11.5.10 for OM, INV, WMS, Shipping, Advance Pricing
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of OM, O2C, INV, BOM, ASCP, GOP, PO, i-Procurement, Shipping and Advance Pricing Modules

Environment: - Oracle Applications Release 12.1.1 Upgrade from Release R 12.1.1/11.5.10.2 Rollout for Canada OM, O2C, INV, ASCP, GOP, BOM, WIP, VCP, PO, Rapid Planning, i-Procurement, Shipping and Advance Pricing, AOL, US, System Administrator

Confidential, Foster City, CA

SCM Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the following modules: OM, ASCP, INV, BOM, PO, i-Procurement, Shipping and Advance Pricing, Rapid Planning, WIP, VCP modules.
• Worked on the Functional mapping of data Conversions & Enhancements for OM, INV, BOM, WIP, PO, ASCP, i-Procurement, Shipping and Advance Pricing modules.
• Working with Technical team closely and getting done development for customizations for OM, INV, WMS, Shipping, Advance Pricing Modules
• Worked on the Auto Invoice Setups in the AR module, defining Line Ordering rules, Grouping Rules, Line Transaction Flex Field and Invoice Sources.
• Preparing technical specification documents for OM, INV, WMS, Shipping, Advance Pricing modules.
• Defined Customer Master (TCA) module
• Worked on the set ups all the modules in Order to cash cycle.
• Worked on the setups for AME including the AME Rules, Actions, Attributes, Conditions, etc.
• Fixing the issues for converted data for OM, INV, WMS, Shipping, Advance Pricing modules
• Integrated Value Chain Planning modules of Advance Planning Command Center, ASCP, Collaborative Planning, Demand Management, GOP
• 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, WMS, INV, BOM, WIP, PO, i-Procurement, Shipping and Advance Pricing, Rapid Planning Modules.

Environment: Oracle Apps Release 12.1.3/11.5.10 e-Business suite (OM, INV, WMS, Shipping, Advance Pricing SQL*Loader, Data Loader, file loader, Toad, Windows NT, HP UNIX.

Confidential, Mountain View, and CA

SCM Functional Consultant

Responsibilities:

• Worked as a SCM Functional Consultant implemented modules - OM, INV, O2C, VCP, BOM, PO, WIP, i-Procurement, Shipping, Rapid Planning and Advance Pricing of Oracle e-Business Suite.
• Implemented 2 SOB’s (2 Operating Units) using multi org structure, multi currency along with 1 Consolidation SOB.
• Worked on a Deferred revenue customization using the Revenue Recognition process in AR.
• Doing setups in OM, INV, PO, WMS and Master Scheduling to operating unit and Inventory org levels.
• Functional Design for the Auto Invoice interface in AR to load invoices into AR from an external system.
• Implemented TCA - for AR customer master conversions.
• Designed and developed the customer interface to load customers into the TCA Module from an external customer database.
• Implemented Auto Lock box Functionality in AR for Bank of America & Royal Bank of Canada.
• Functional Designing and executing ‘Data migration’ strategy for Master and Transactional data.
• Developed different reports as per the client’s requirement.
• Trained business owners and business end-users on OM, INV, BOM, WIP, ASCP, PO, i-Procurement, Shipping and Advance Pricing modules as part of User Training Strategy.
• Conducted pilot testing, integration with other financial modules testing.

Confidential, Emeryville, CA

SCM Functional Consultant

Responsibilities:

• As a SCM Functional Consultant implemented financial modules: OM, INV, BOM, WIP, PO, i-Procurement, Shipping and Advance Pricing Release 11.5.10.2
• Performed all the Configurations and Setups for INV, PO, OM Modules
• Preparing BR30, 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 from BAAN & D1.
• Created New FSG Reports, using multi currency features including foreign currencies for multi org structures.
• Worked on a customization for Deferred Revenue is AR using Revenue Recognition process.
• Performed all of the setups and configurations for OM, PO, INV, WMS, Advance Pricing, Shipping and BOM Modules.
• Implemented internal control features using Form Personalization’s for modules GL, AP, and AR.
• Configured Auto Invoice in AR to import data from the non Oracle ERP instance in Japan.
• Implemented TCA - for AR customer master conversions.
• Implemented the Data Quality Management (DQM) in TCA.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks.
• Establish the best practices and controls in Oracle like... Security, Segregation of duties.
• Unit & Integration testing across all modules.

Confidential, Mountain View, CA

Functional Consultant

Responsibilities:

• Managing the project end-to-end. Management responsibilities include planning, coordinating, executing, tracking, reporting, Issue resolution, dependency/risk management/Mitigation, change management and quality assurance.
• Implemented modules: INV, Shipping, Pricing, O2C, OM along with PO integrated with internal e-Procure system, Rapid Planning Release 11i of oracle (11.5.7).
• Implemented 3 SOB’s (3 Operating Units) using multi org structure, multi currency along with Consolidation SOB.
• Worked on Revenue recognition in AR.
• Implemented the TCA including setting up Parties, Customer Accounts, Party Relationships, etc.
• Implemented Party Relationships in the TCA.
• Implemented the Data Quality Management in TCA.
• Setup document validation, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Created New FSG Reports, using multi-currency features including foreign currencies for multi org structures.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.7, OM, PO, AR & INV).

Confidential

Order to Cash Functional Consultant

Responsibilities:

• Gathering business requirement by having detailed discussions with business team.
• Functional Specification writing, Reviewing Master business requirement details, Gap analysis.
• Review other functional Specifications.
• Worked on the set ups all the modules in Order to cash cycle.
• Preparing various functional requirement and propose high-level design details for programs to keep data in Order Management and i-Store,
• Involved in setups, requirement gathering and functional specs preparation for Oracle incentive compensation.
• Prepared high-level technical design document.
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, conversions, customizations, testing, training, documentation and implementation of modules.
• Interacting with upper management to identify the business process and needs and with end users to identify their requirements.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.10.2), AR, i-Procurement, OM, INV, WIP, BOM, ASCP, WMS, Shipping, PO & AP.