SUMMARY:

• 8+ years of experience in ERP (Oracle Financials) as an Oracle Functional Analyst consultant and core team member.
• Experience with Global Roll Outs of Oracle e - Business suite.
• 3 Full Life Cycle implementations in Release 12.
• Strong Experience in Financial Accounting and Reporting with good leadership and interpersonal skills.
• Extensive experience with PO, i-Procurement, OM, AR, INV, Sub Ledger Accounting, Payment Manager, GL, FA and PO
• Extensive experience with “Procure to Pay” business processes.
• Extensive experience with documenting the “AS-IS” process and designing the “TO-BE” process.
• Involved in implementation and support projects in Oracle Financials.
• Good experience in Oracle Financial Modules including Procure to Pay and Order to Cash modules.
• Good experience working with Business owners and users; Preparing specification documentation; Gathering business requirement; Designing process workflow; Identifying and resolving Gaps; Documenting functional and reviewing technical specs; Providing functional inputs for specifications, Good understanding of business process, Good experience in tracking and resolving application bugs via the oracle TAR process using Oracle Meta link.
• Experience with Testing methodologies like Mercury Quality Center, Win Runner and Load Runner
• Good written and oral communication skills.

TECHNICAL SKILLS:

Functional: Business Requirements Analysis, Gap Analysis, Process mapping and Oracle Applications functional setup

ERP: Oracle Financials (12.0.5, 10.7 and 11i)

Modules: Primary: i-Procurement, INV, AP, AR, GL, i-Expense, OM, INV, Purchasing.

Methodology: AIM (Applications Implementation Methodology)

Business Intelligence: Working knowledge of Oracle Discoverer

Language: Reasonable understanding of SQL

Oracle and Other Tools: Data loader, ADI, Web ADI and MS-Office tools including Visio / MS Projects

PROFESSIONAL EXPERIENCE:

Confidential, St Peters, MO

Sr. Oracle Procure to Pay Functional Consultant

Responsibilities:

• Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating units for nine fiscal years until Sep-2007.
• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Worked on the P2P Modules of Purchasing, i-Supplier Portal, i-Procurement, AP, Payments, AME - setups and business process definition.
• Performed all the setups for i-Supplier Portal, i-Procurement, AP, Payments, AME modules.
• Worked on the setups for AME including the setups of Approval Rules, Attributes, Parallel Approval Process, Conditions, Actions, etc.
• Implemented TCA - for AR customer master conversions.
• Worked on the setups of the Payment Manager in the AP module.
• Worked on Line Level matching feature in oracle AP module.
• Setup the Payment Process Profiles (PPP) and Payment Process Requests in the Payment Manager in AP Module.
• Worked on the configuration of the INV module - setting up the Inventory Orgs, Sub Inventories, Categories, Catalogues, Item Templates, Min Max and Reorder point planning, Cycle counting, ABC Analysis, etc.
• Extensive experience with Banks, Bank Branches, Setup of Internal and External Banks, defining the integration between Oracle e-Business suite and Banks.
• Worked on the i-Procurement setups - configuring Punch Outs, Catalogs, categories, Approval process, etc.
• Worked on the i-Supplier portal setups - defining the supplier registration process, supplier creation and approval process, etc.
• Performed all of the setups for the OM module - defining the Transaction Types, processing constraints, defaulting rules, price lists, discounts and surcharges, drop ship process, back to back order process, IRISO Process.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Worked on the setups of the AME Module - defining the parallel approval process, custom attributes, attribute mapping, approval rules, exceptions and exemptions, approval limits, etc.
• 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.
• Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
• Flow Testing for Modules (Purchasing, i-Supplier Portal, Order Management, AME) to make sure flow is working without any issues.
• 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.

Environment: Release 12.1.3, Purchasing, WMS, i-Supplier Portal, Order Management, AR, AP, GL, FA, CM modules

Confidential, Phoenix, AZ

P2P Functional Consultant

Responsibilities:

• Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating units for nine fiscal years until Sep-2007.
• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Performed all the setups for OM, I-Procurement, Shipping, Inventory, AP, Purchasing modules.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Worked on the entire upgrade strategy to upgrade the application footprint from 11.5.10.2 to Release 12.1.3
• Worked on the setup of AME Approval rules for PO Approval, Requisition Approval and Expense Approval
• Worked on the setups of the Professional Buyers work center in Oracle Purchasing.
• Worked on the setting up of Punch Outs in Oracle i-Procurement
• Worked on the catalog setups in Oracle i-Procurement
• Worked on the configuration of stores in Oracle i-Procurement
• 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 PO, i-Proc, AP, OM and INV 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.

Environment: Oracle e-Business Suite Release 12.1.3 and OM, WIP, i-Procurement, AP, ASCP, BOM, AR and INV modules

Confidential, Irvine, CA

Financials Functional Analyst

Responsibilities:

• As a Distribution Functional Consultant implemented financial modules: PO, i-Procurement, i-Supplier, AP, Sourcing, GL and INV modules of Release 12.1.3 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 the configurations of the Sourcing module - setting up the Supplier, Supplier communications, Catalog Hosting, Negotiation workflow, etc.
• Worked on the integration of I-Procurement with PO and also worked on the functional specifications for customizations to I-Procurement module.
• Worked on all of the Order Management module including setting up of Transaction Types, Defaulting Rules, Processing Constraints, Shipping Rules, Modifiers and Qualifiers in Advance Pricing, etc.
• Worked on the setups of i-Supplier module setting up the Supplier responsibilities, supplier invitation lists, supplier registration process etc.
• Worked on all of the Test Cycles SIT, CRP and UAT.
• Worked on the Inventory module setting up the Item Master, Templates, Inventory Orgs, defining sub inventories, locators, serial number controls, Min Max and Reorder Point planning, Cycle Counting and ABC Analysis, etc.
• 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
• Created New FSG Reports, using multi currency features including foreign currencies for multi org structures.
• Defined the AS-IS and TO-BE processes.
• Implemented TCA - for AR customer master conversions.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks BOA & RBC.
• Developed and executed test cases in Mercury Quality Center.
• Used Load runner to test interfaces.

Environment: Oracle Applications R12.1.3 OM, INV, Sourcing, i-Procurement, i-Supplier, PO

Confidential, Los Angeles, California

Oracle P2P Functional Analyst

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 OM.
• Worked on the setup of OM, I-Procurement, Shipping, Inventory, AP, Purchasing 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 Oracle OM Territory Assignment.
• Analyze the external Enterprise Territory Management System (ETM) to be integrated with Oracle OM.
• Identification of GAPs & proposal of Solution.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Carry out Data Mapping.
• 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 distribution track.
• Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing 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

Environment: OM, I-Procurement, Shipping, Inventory, AP, Purchasing modules

Confidential, Foster City, CA

Oracle Apps P2P Functional Consultant

Responsibilities:

• Requirements gathering from end users, Requirement analysis.
• Preparing the AS Process, TO Be Process, Use Case Diagrams, Process flow diagrams, Swim Lane diagrams, process breakdowns, etc.
• Worked on the entire Financials business process.
• Performed all of the setups required for PO, i-Procurement, AP and INV modules
• Developed several enhancements to the Business Processes on the Procure to Pay side.
• I procurement: Define system profile options. Extract catalog and item data. Setup of Sourcing Rules and Sourcing rules assignment using Blanket Purchase Orders.
• Coordinated all rounds of CRP and SIT testing with the business users.
• Supervised and helped business users in UAT (User Acceptance Test) testing.
• Support Production issues on a day to day basis including month end closure p1 issues
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Categories, Document Sequence Assignment, Profile Options.
• Preparing the BR030, BR100, To-Be Document.
• Prepared MD050 functional design document.
• Prepared the test script documents TE040, TE050 & TE130 for SIT & UAT testing.
• Prepared i-procurement training manual for the Ship users and the Casino Managers.
• Performed Framework Personalization setups.

Confidential, San Jose, CA

P2P Functional Analyst

Responsibilities:

• Worked on the entire Procure to Pay business process.
• Worked on the AS Is Process, TO Be Process, Swim Lane diagrams, Use Cases, Process Flows, etc.
• Performed all of the setups for i-Procurement, PO, AP and GL
• Developed several enhancements to the Business Processes on the Procure to Pay side.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Hungary.
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of Cash Management and Account Payable Module
• Functional Support for SOX and PWC Audit
• Integration and Implementation of Foreign exposure through Fire Apps external software with Oracle GL
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, CM, and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Setup and Support of Markview170 System

Confidential, Minneapolis, MN

Oracle Apps Functional consultant

Responsibilities:

• Created functional specification documents for customized interfaces, reports and extensions.
• Performed GAP analysis for Payables module.
• Created test scripts for testing of standard application functions and customizations.
• Created functional design and test scripts for EDI inbound and outbound processes.
• Coordinated all rounds of CRP and SIT testing with the business users.
• Executed and tested Payables closing process and fixed issues.
• Supervised and helped business users in UAT (User Acceptance Test) process for reports, interfaces and extensions.
• Worked on configuration and set-ups.
• Worked on business requirement gathering and created design documents.
• Created functional specification documents for customized interfaces and reports.
• Worked on configuration purchasing for all CRP and SIT instances.

Environment: Oracle Applications Implementation 11.5.10.2/R12, AP, OM, INV

Confidential

Oracle Apps Consultant

Responsibilities:

• Defined Accounting Flex Field Structure, Security Rules, Assigned Security Rules Setup, Define Cross-Validation Rules.
• Defined Period Types, Accounting Calendar, Currencies, Conversion Rate Types, Enter Daily Rates, Set of Books.
• Defined Journal Sources, Journal Categories, Shorthand Aliases
• Implemented Oracle Cash Management for Bank reconciliation.
• Performed Bank Reconciliation.
• Trained users on Cash Management and General ledger.
• Fully participated in Conference Room Pilot (CRP) and authored user’s manuals.
• Writing and executing detail manual test scripts in Mercury Test Director.
• Developed input test data and expected results for test plans.
• Researched testing errors for resolution and documented all defects in detail with attachments, before passing on to the senior business analysts for further review.
• Interacted with the end users to get necessary feedbacks.