Oracle Applications Financials Consultant Resume
2.00/5 (Submit Your Rating)
Foster City, CA
SUMMARY
- Around 8 years of experience in implementation, upgrade and support projects on Oracle Applications. Worked extensively as Oracle Application Functional Consultant in modules like Oracle General Ledger (GL), Accounts Payables (AP), Payments (IBY), Accounts Receivables (AR), Cash Management (CE), Fixed Assets (FA), Sub ledger Accounting (SLA), Order Management (ONT), iProcurment, iExpenses, Approvals Management Engine (AME) and Purchase Orders (PO).
- Experience in ERP Oracle Application E - Business suite on 11i and R12.
- Comprehensive noledge of various implementation methodologies and good understanding of Business flows like P2P, R2R and O2C.
- Proficient in Legacy conversions, Application Customizations and Interface design.
- Experience with end-to-end complete ERP implementation and support. Very strong Business/Functional noledge, experience.
- Multiple full life cycle implementations of Oracle Applications.
- Outstanding functional expertise in identifying and gathering requirements, designing business processes, Fit Gap analysis, application design, configuration, setup, personalization and designing interfaces from 3rd party systems into Oracle Applications.
- Managing and leading testing cycles (system integration testing, unit testing and user acceptance testing), detecting and resolving system issues.
- Conducting multiple iterations of CRP, creating As-Is and To-Be process documentation, facilitating design meetings with users.
- Implementation experience in General Ledger, Purchasing, Accounts Payables, Account Receivables, Fixed Assets, Cash Management, Multi-Org, Sub Ledger Accounting, Order Management, Inventory and Web ADI
- Managing and testing Advanced Global Intercompany System (AGIS)
- Designed and Configured AME (Approvals Management Engine) for iProcurement and iExpenses approval as per business requirement.
- Extensive familiarity with Oracle Discover, Kofax Markview 170 Systems and OBIEE.
- Conducted end to end system and functional testing including scan, email, invoice approval functionality of Kofax Markview 170 Systems
- Worked on multiple P2P and R2R Country Rollouts.
- Experience in SQL and other programing language.
- Experience in various stages of SDLC, including end-to-end system testing, defining testing strategy, test scenarios and managed team for complete testing cycle.
- Excellent Analytic, Problem Solving, Communication and Interpersonal skills to interact with individuals at all levels.
PROFESSIONAL EXPERIENCE
Confidential, Foster City, CA
Oracle Applications Financials Consultant
Responsibilities:
- Analyzing Business Requirements Definition (BR 100)
- Interacting extensively with Developers and end-users to gather requirements for Functional Document (MD50).
- Worked on GAP Analysis and Mapping Business Requirements.
- Done the Configuration for GL, AP, AR, and Cash Management modules as per the client needs.
- Configured intercompany (AGIS) setups
- Performing period-end processing for Oracle Cash Management.
- Responsible for Validating Setups in Financial Modules such as Payables, Receivables, General Ledger, Purchasing, Cash Management and Fixed Assets in the Production Environment of the R12 Oracle E-Business Suite
- Modified SLA Definition as per client's requirement and resolve problems with SLA.
- Validation of Oracle ADI integration with Fixed Assets and General ledger
- Configured AME for iProcurement and back ported parallel approval logic from R12 to 11i instance since parallel approval is not supported for iProcurement AME transaction type in 11i.
- Upgraded the above AME logic to R12 and used out of box parallel approval logic to satisfy business req.
- Configured AME for chain of authority approval routing for iExpenses.
- Validation of Markview System integration with Oracle payables and iExpenses module.
- Played a Key role in upgrading Kofax Capture and Markview application to 10 and 7.1 respectively and integrating it with Oracle Applications R12 by closely working with the vendors.
- Supported Kofax Capture application 10.0 including scanning and email functionality.
- Performing Standard Functionality testing in GL, Service Contracts, AR, iProcurement, iExpenses, PO and AP.
- Generated Reports In oracle Discover and OBIEE.
- Worked on production support including month-end reconciliation, interface issues, support enhancements, ad-hoc reports and bug fixes.
Confidential
Responsibilities:
- Successfully Upgraded and Gatheird requirements for upgrade and implementation of R12
- Gatheird requirements and Prepared BR100 Financial Modules for New features of AP and EBTax
- Gatheird requirements and Partially Implemented Financial Accounting Hub for processing Accounting for external systems
- Implemented E-Business Sales Tax for US - Regime to Rate flow with Rules and Exceptions and Self-assessment Tax
- Assisted the client with the functional aspects of upgrade from 11i to R12 in AR, AP, FA,CM, PO and GL from end to end process cycle, month end close and reconciliation activities
- Created and Executed the Upgrade Test Scripts for all Financial modules and integration with EBTax
Confidential
Responsibilities:
- Gathering the Client Requirements and preparing the documents using AIM Methodology.
- Created security profile for each geographic OU group
- Ran Security List Maintenance for all security profiles
- Created all required Purchasing Accounting responsibilities
- Assigning MO: Security Profile and the MO: Default Operating Unit profile options to all Purchasing Accounting responsibilities
- Assigning the Organization Access for all OUs for the newly created Purchasing Accounting responsibilities
Confidential
Responsibilities:
- Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
- Performed Data Mapping for data conversions.
- Understand Division-specific business processes from the end users and implement the same.
- Responsible for training the end users on the new processes and facilitated on-the-job training.
- Worked on the integration of GXS (open Source) with Oracle payables Module
- Reconciliations of bank statement in Cash Management
- Coordinated activities with testing and the technical team to resolve daily reported production issues. Facilitated discussions with end-users/managers to gather functional requirements on their issues.
Confidential
Responsibilities:
- Working as functional lead in GL, AP, CM, iExpenses, iProcurement, SLA, PO and FA.
- Configured the Sub ledger Accounting (SLA) setups for Payables, Purchasing and Cash Management.
- Actively participated in Acquired company implementations in very tight schedule
- Prepared Requirement Documents and GAPs for newly acquired companies
- Functional flow: Procurement flow including Punch-out, Capitalized Assets, Mass Additions, Catalog Bulk load and approval hierarchy
- Functional flow: Global Intercompany Transactions, Expenses Reports using iExpenses, Payment process Manager, Electronic Payments.
- Configured intercompany (AGIS) setups
- Configured MRC setups and created Journals with foreign currency.
- Conducted kick off/CRP
- Configured Finance and Procurement Modules in DEV and UAT instances
- Integration testing with internal and external modules/applications
- Prepared UAT plan and Test Cases
- Acted liaison between IT implementation team and Business Super Users
- Tracked UAT issues with solutions
- Supported Post Go Live issues
Confidential, San Jose, CA
Functional Consultant
Responsibilities:
- Documenting the mapping and requirements for the interfaces and conversions between the source and Oracle Applications.
- Preparing the questionnaire and required documents by using AIM Methodology.
- Making required setups and Customizations in corresponding modules.
- Performed setups and testing in CRP instance during conversion from legacy system to Oracle.
- Gatheird requirements from OM users for development of custom reports.
- 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 Performed testing for custom reports, setups. Performed user training for new implementations
- Developed BR100 Application setup documents for iExpenses.
- Performed Conference Room Pilot (CRP)
- Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice tables.
- Customized the Accounts Payable Vendor Entry Form as per requirements
- Created Alerts to notify users on various business events
- Developed a package to import expense information into Oracle Payables.
- Creating custom Reports and Forms for the end users to check the details and errors.
- Executed the Payables Transfer to GL program and resolved the issues during the process.
- Technical and user documentation of the customizations.
Confidential, San Jose, CA
Apps Consultant
Responsibilities:
- Co-ordinated between stake holders and EDW IT to analyze the business requirements and feasible solutions.
- Documenting the mapping and requirements for the interfaces and conversions between the source and Oracle Applications.
- Preparing the questionnaire and required documents by using AIM Methodology.
- Making required setups and Customizations in corresponding modules.
- Performed System integration testing Oracle IProcurment and Maximo Asset Management.
- Created the test scenarios and reviewed with several user teams.
- Assist new users in understanding the modules and other day to day activities
- Periodic User Training for new employees.
- Responsible for diagnosing the root cause analysis of the support issues observed to avoid reoccurrence of such issues in the future.
Confidential, Irving, TX
Apps Consultant
Responsibilities:
- Purchasing/iProcurement: Define Regions and attributes through AK Developer. Position approval hierarchy setup based on organization structure. Defined custom descriptive flexfields and enabled those in iProcurement using AK Developer.
- SOP: order creation, pick release, move order transact, shipping and auto invoice and related setups like Transaction Types, Price List, Modifiers for freight and discount, credit holds and other manual holds, ship set and fulfillment sets, foreign currency sales order, drop shipment, pick rules and delivery grouping and sequence rules.
- Accounts Receivables Cycle: Autoinvoice, AR Transaction Types, manual invoice, receipt and quick receipts, AR lockbox, setting up receivable activities, banks and receipt class Credit memos and adjustments
- Organization Structure: Inventory Orgs, Sub-Inventory, Stock Locator and Locations
- Item Master: Categories, Category Sets, Item Attribute Controls, Item template and Catalog Groups.
- Created MD050 (Functional Design Document for customization) for integration of bank and supplier information in Oracle.
- Prepared Requirement document for FA custom reports
- Prepared GAP analysis and Functional Design documents for iExpenses and Accounts Payables.
- Country specific implementations for iExpenses and Accounts payables
- Conducted Several sessions/demos with different business users like Corporate travel, Services and Finance Group for iExpenses Custom Discoverer Reports Requirements
- Configured various payment types including Draft, ACH, Wire and Check
- Prepared Electronic invoice process design document and custom solution
- Worked with users in ASPAC, CEMEA operating units to test custom Bank Payment and Transfer programs.
- Resolved escalated issues to meet Go Live deadlines for APAC and EMEA operating units.
- Provided post-production support to users.