SUMMARY:

• Member of the functional focus team and about 8.6 years of IT experience, with primary concentration on Oracle ERP/CRM implementations and business process re - engineering.
• Functional Consultant specializing in Oracle Application implementations, specifically Oracle Supply Chain modules of OM, INV, PO, Advance Pricing, Shipping.
• Worked on i-Procurement and i-Supplier 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.
• Over 8.6 years’ experience in IT industry which includes experience in i-Procurement, General Ledger (GL), Purchasing (PO), Oracle Order Management (OM), Inventory (INV), Shipping, Pricing, AOL and System Admin and integrated custom applications.
• Extremely skilled on Procure to Pay as well as Order to Cash business flows.
• Experience with Approval Manager Engine (AME)
• Strong experience in Functional Specification design and writing clear Business specifications, understanding of project life cycles and methodologies, Analytical skills and problem-solving abilities, including the ability to troubleshoot effectively, make applications run very efficiently and/or with excellent real time response and ability to work in a professional manner, be flexible, and handle interactions with all levels of the organization and with external clients.
• Extremely strong on Oracle’s Application Implementation Methodology (AIM)

TECHNICAL EXPERIENCE:

ERP: Oracle e-Business Suite (11i and Release 12) - i-Procurement, Oracle Accounts Payables, Oracle General Ledger, Accounts Receivables, Oracle Purchasing, Oracle Order Management and Oracle Inventory

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, PO, i-Procurement, Shipping and Advance Pricing modules.
• Worked in the configuration of the OM, INV, BOM, PO, i-Procurement, Shipping and Advance Pricing modules.
• Performed Requirement and Gap analysis.
• 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.
• Involved in the Auto Invoice Setups in AR module including setting up of Auto Invoice Grouping Rules, Line Ordering Rules, Sources and Line Transaction Flex Field
• Worked on the Auto Lock Box Setups in AR module for Bank of America and Wells Fargo Bank.
• Worked on the Revenue Recognition process in the AR Module, including the setup of Accounting and Invoicing rules.
• 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.
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of OM, INV, BOM, 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, INV, BOM, PO, i-Procurement, Shipping and Advance Pricing, AOL, US, System Administrator

Confidential, Foster City, CA

Oracle SCM Functional

Responsibilities:

• As a SCM Functional Analyst implemented the following modules: OM, Advance Pricing, Shipping, Inventory, BOM, WIP, ASCP modules.
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP and GL modules.
• Worked on the setups of Drop Ship and Back to Back order process in OM module.
• Defined Customer Master (TCA) module
• Worked on setting up processing constraints in OM Module
• Designed and setup the Modifiers and Qualifiers in Advance Pricing module.
• Worked on the defining the formulas in Advance Pricing
• Worked on the configuration of the RMA process in OM Module.
• Worked on the Deferred COGS and Deferred Revenue process.
• Worked on setting up Auto Lock Box in the AR Module.
• Worked on the AGIS 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 OM, Advance Pricing, Shipping, Inventory, BOM. Modules 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.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users OM, Advance Pricing, Shipping, Inventory, BOM, WIP, ASCP Modules.

Confidential, Columbus, OH

SCM Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the following modules: OM, INV, BOM, PO, i-Procurement, Shipping and Advance Pricing modules.
• Worked on the Functional mapping of data Conversions & Enhancements for OM, INV, BOM, PO, i-Procurement, Shipping and 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.
• Defined Customer Master (TCA) module
• Worked on the setups for AME including the AME Rules, Actions, Attributes, Conditions, 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, INV, BOM, PO, i-Procurement, Shipping and Advance Pricing Modules.

Confidential, Emeryville, CA

SCM Functional Consultant

Responsibilities:

• As a SCM Functional Consultant implemented financial modules: OM, INV, BOM, 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.
• 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, OM along with PO integrated with internal e-Procure system, 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).