Oracle Functional Consultant Resume
Dallas, TX
SUMMARY
- Over 16 years of experience as an Oracle Financial Functional Consultant including, Business Process and Improvements, Requirement Gathering, Process Design, System Analysis, Systems Development Life Cycle (SDLC), Testing, Training and Application Support.
- Expert level experience in implementation, support and upgrade of Oracle E - Business Suite(10.7/11.x/11i/R12)
- Expert level Functional experience in Oracle ERP modules GL, AR, AP, IBY,CM, FA, FSG, PO, Sys admin, i-proc, i-exps, e-Tax. And have moderate level exposure on PA, OM, INV, and HR.
- Extensive Experience in Oracle Business flow in Procure to Pay (P2P) and Order to Cash (O2C)
- Strong experience with development and customization using Interfaces and XML Publisher, Oracle Application Framework (OAF).
- Designed and managed interfaces to /from Oracle to third party software, data migration and data cleansing.
- Prepared functional design documents all setups in relation to module configuration (BR100),for customizations (CEMLI) (MD50) / data conversions (CV10/CV60) using AIM/OUM methodologies
- Strong functional and good technical skills.
- Identify process problems and implemented new and improved policies and processes.
- Experience in End-to-End Implementation projects as well as Supporting clients
- Excellent team player with immense ability to grasp new concepts and apply them as per business requirements.
- Excellent communication and stakeholder management skills - Ability to present to business executives, hold discussions, run workshops, requirement gathering, process documentation and preparing functional specifications.
- Ability to work under pressure and work on multiple projects.
TECHNICAL SKILLS
Application Package: Oracle Financials R12, 11i, 11 & 10.7 (GUI & Character)
Modules: GL, AR, AP, IBY, CM, FA, FSG, PO, Sys admin, i-proc, i-exps, e-Tax, PA, OM, INV, HR
Tools: Toad, SQL Developer, Data loader, ADI, More4Apps, Sql plus, Microsoft Office 2010, Microsoft Visio, Microsoft Projects, Microsoft PowerPoint, Config Snapshot
PROFESSIONAL EXPERIENCE
Confidential, Dallas, TX
Oracle Functional consultant
Responsibilities:
- Liaised with Departmental Team Leaders and users in planning and gather requirements
- Working around the constraints posed by the existing Pronto system used in the branches
- Designed and managed interfaces to /from Oracle to Pronto - Suppliers /PO /PO Receipts/Customers / Sales Invoices/ Cash Receipts/ Banking & GL
- Data migration and data cleansing - Suppliers & Customers
- Documented all setups in relation to configuration of AP, AR, PO & GL - BR100 using AIM methodology for Australian Regional Wholesalers
- Documented CEMLI Requirements and interfaces using AIM methodology
- Implemented & tested - SIT, UAT and resolved issues raised
- Production Support after go live
Confidential
Oracle Functional Consultant
Responsibilities:
- Liaised with SME’s and users in planning and gather business requirements, understand business process and third party interfaces to and from the existing Oracle database.
- Working around the constraints posed by the existing legacy system and custom processes used by the business and external sources.
- Documented CEMLI Requirements - interfaces and data migration
- Wrote detailed functional test plans to ensure business requirements and user needs are met. - P2P, i-exps, e-tax, FA, PA, Sys admin & RBAC Testing in HP Quality Center
- Ran workshops to discuss processes with SME’s & stakeholders, CRP workshops, gap analysis
- Provided user Training
- Documented setups in relation to configuration of AP, IBY, System Administration & Role-Based Access Control (RBAC)
- Implemented & tested - SIT and resolved issues raised
Confidential
Oracle Functional Consultant
Responsibilities:
- Liaised with Departmental Team Leaders and users in planning and gather requirements
- Engaging with appropriate stakeholders throughout the project
- Working around the constraints posed by the existing Pronto system used in the branches
- Designed and managed interfaces to /from Oracle to Pronto - Suppliers /PO /PO Receipts
- Data migration and data cleansing - Suppliers
- Prepared functional design documents for customizations (CEMLI) / data conversions using AIM/OUM methodologies
- Ran workshops to discuss processes with SME’s & stakeholders, CRP workshops, gap analysis
- Provided user Training
- Documented all setups in relation to configuration of AP, IBY, i-Exps, PO & E-Tax - BR100 using AIM methodology
- Documented CEMLI Requirements and interfaces using AIM methodology
- Created documents for training all internal users, support personnel
- Implemented & tested - SIT, UAT1 & UAT2 and resolved issues raised
- Production Support after go live
Confidential
Oracle Functional Consultant
Responsibilities:
- Liaised with Departmental Team Leaders in planning the migration
- Implemented & tested - SIT, UAT & Pre-prod, and resolved issues raised
- Wrote detailed functional test plans to ensure system changes work properly, existing processes remain unaffected, and business requirements and user needs are met.
- Created documents for training all internal users
- Documented all setups in relation to configuration of GL, AP, AR & CM - BR100 using AIM methodology
- Generated BR100 using Config Snapshot and to compare changes between environments.
- Data Conversion
- Production Support after go live
Confidential
Oracle Functional Consultant
Responsibilities:
- Liaised with Departmental Team Leaders & oracle users in planning the migration and to resolve issues
- Ran workshops to discuss processes with SME’s & stakeholders and trained users
- Planned, Implemented & tested - Mock1, Mock2, SIT, E2E, UAT & Pre-prod in HP Quality Center
- Documented all setups in relation to P2P configuration & BR100 using AIM methodology - i-proc, PO, AP, i-exps
- Data Conversion
- Review and planning Supplier cleansing, migrating to Oracle, and reconciliation
- Review and planning Open BPA & PO’s to Oracle and reconciliation
- Production Support after go live
Confidential
Business Consultant
Responsibilities:
- Designing and documenting a Payables Shared Services division for Global SKM offices
- Delivery of a blueprint for establishing a fully functioning SSC in Kuala Lumpur, Malaysia process all AP functionalities including a scanning solution and a payment hub
- Interviewed relevant regional staff to understand current process and SKM requirements
- Identify process problems and implemented new and improved policies and processes to the proposed solution design
- Conducted workshop on the proposed process with relevant mangers
- Prepared and documented existing regional processes (AS IS) including flow diagrams with swim lanes - AP, AR, Concur, FA, CM, PA & GL
- Prepared and documented proposed processes (TO BE) including flow diagrams with swim lanes - i-proc, PO, AP, i-exps, AR, FA, CM, PA & GL including invoice automation & payment hub
Confidential
Oracle Functional Consultant
Responsibilities:
- Liaised with Departmental Team Leaders & oracle users in Planning, designing, testing & implemented Payable migration from PeopleSoft to Oracle
- Supplier cleansing & migrating to Oracle
- Planning Asset migration from PeopleSoft to Oracle
- Split Assets from one to two books and implement security profiles & rules
- Business process improvement - Implemented invoice upload to AP using More4Apps wizard for AP, and created template using excel to convert supplier invoice information into Oracle format
- Designed and implemented solution for Electronic Expense Voucher(EEV) self-service system (a web based system for users to enter payment requests ) to interface to/from Oracle
- Configured automatic offset method using balancing segments. Tax recovery rates were captured by recovery rules and invoice forms customized to capture tax in the same entity as per the entity in the line
- Ran workshops to discuss processes with SME’s & stakeholders and trained users
- Generated BR100 using Config Snapshot and to compare changes between environments.
- Review and designing a solution for processing AMEX & Cab charge expenses
- Liaised with Departmental Team Leaders & oracle users in planning the migration and to resolve issues
- Wrote SQL scripts to extract ad-hoc information
- Review requirements, Designed, Managed and Implemented custom reports, extracts & feeds
- Production Support on AP, AR, GL, FA, ADI, i-exps - 11i environment
- Applied Data fix to resolve system and user errors