Oracle Financial Qa Analyst Resume
Plano, TX
SUMMARY
- Over 7 years of Functional & Business experience which consists of Oracle Applications (E - Business) experience in Core Financials, Procure to Pay, and related business processes with good understanding of integration with ERP.
- Extensive experience in designing Functional aspects in implementations, upgrades, global rollouts, support and customizations of Conversions, Interface, Forms, Reports and Extensions including Migration works in Oracle Applications (R12, 11i and Prior versions).
- Worked extensively on Oracle Core Financials (GL, AR, AP, FA, EB-tax and CE), Procure to pay (PO, IP) Project Management (Billing and Costing), Sys Admin modules.
- Extensive Functional experience in requirement analysis, design, development, testing and implementation and Production Support of complex Servers with applications using Oracle Applications (Financials, Procure to Pay, Planning and Administration).
- Good R12 Experience in GL, AP, FA, AR, EB-Tax, PO, CE modules with MOAC, TCA Architecture, Reporting Currency and SLA, AIM Deliverables, Oracle Business Accelerator, Maintenance Wizard
- Expertise in developing Business Process documents using AIM Methodology Setup Document implementing (BR100s), Design Documents (MD20’s, MD 050s), Developing and creating Conversion Documents (CV40s and 60s)
- Proficiency in working with users, identifying functional and technical gaps, estimating work to fulfill business requirements, designing, custom solutions, programming, scheduling, documentation and production support, besides Integration and forecasting the financial information’s in Legacy Applications and Oracle Applications.
- Good oral and written communication skills, with demonstrated ability to interface with all levels and across organizational lines, including leading/facilitating meetings and preparing/making presentations to both technical and non-technical personnel
- Strong Team Player. Ability and Enthusiasm to learn new Tools/Technologies Quickly.
- Functional responsibilities: Interfacing with users, requirements gathering, functional gap analysis, application design, module setup, writing guides, end users, and production support.
- Technical activities: identifying functional and technical gaps, estimating work, architecting system interactions, designing custom solutions, scheduling, producing documentation, user manual to users and providing production support.
TECHNICAL SKILLS
ERP: Oracle Applications (R12, 11.5.10, 11.5.7, 11.5.5, 11.5.3 and 10.7)
Operating Systems: UNIX, Windows Vista/XP/NT/95/2000, MS-DOS.
Languages: SQL, HTML
Tools: Toad,Java Decompile, J-Developer, Oracle Enterprise managerRational Tools, Test Director, DevTrack and Compuware Track Record
Development Tools: Reports 6i and Forms 6i, TOAD, MS-WORD, Visio, PowerPoint, Excel
Database: ORACLE 8i, 9i and 10g
PROFESSIONAL EXPERIENCE
Confidential, Plano TX
Oracle Financial QA Analyst
Responsibilities:
- Participated in the gathering business requirements from business users and diverse business groups
- Assisted in the design of functional specifications documents for diverse business groups
- Involved in Super User meetings to gather specific business requirements for setting up the modules.
- Monitored and documented team members activities and provided updates to the management on project progress
- Participated in the analysis of Account Payable ( Invoices, Suppliers, Receipts, Payments) information for diverse business units
- Worked with business users in gathering business requirements for diverse business units
- Designed financial documentation based on AIM Methodology (BR100, MD 20, MD50)
- Designed and setup diverse expense reports within I-expense and monitored diverse invoice in account payable application
- Design diverse business processes and involved in mapping various business scenarios
- Provided analysis for the changes in configuration within the financial modules of the application
- Identify gaps between business requirements and current application within the environment
- Identifying the requirements from User. & developed functional specs for the General ledger, Account payables, Account Receivables, Fixed Assets,
- Worked with the testing tea mTest Plan, Test Design (Test scenarios, Test cases / Test Data generation), Defect tracking, Reporting and Reviews of Test Deliverables.
- Designed functional specifications document for diverse financial requirements based on AIM Methodology
- Analyzed financial data from diverse legacy systems and documented changes as per the requirements
- Involved in the implementation of Account payables, I-expense module within the financial application
- Set up and monitored diverse match options for purchases orders and invoices
- Assisted in the integration of I-expenses with Account payables to maintain flow of expense reports into invoices
- Worked with the testing team in testing diverse functionalities within financial application of the project
- Participated in tracking diverse approval routes within the diverse business units
- Assisted in the design of test cases and scripts for various functionalities within the financial application
- Maintained assets accounts, participated in asset maintenance, depreciation and asset reclassification
- Assisted in designing documentation for the application users and diverse business groups
Environment: Oracle Apps 11.5.10 & R12 (GL, AP, PO, FA, PA, IE) Reports 6i, Oracle 9i, 10g
Confidential, Tampa, Florida
Oracle EBS Financial Functional Analyst
Responsibilities:
- Participated in the gathering business requirements from business users and diverse business groups
- Assisted in the design of functional specifications documents for diverse business groups
- Involved in Super User meetings to gather specific business requirements for setting up the modules.
- Monitored and documented team members activities and provided updates to the management on project progress
- Designed financial documentation based on AIM Methodology (BR100, MD 50)
- Configured and implemented diverse oracle financial modules (GL,AP, PO,AR,FA,CM
- Worked with the diverse business groups and technical team in the communicating business requirements within the business organization
- Provided analysis for the changes in configuration within the financial modules of the application
- Identify gaps between business requirements and current application within the environment
- Identifying the requirements from User. & developed functional specs for the General ledger, Account payables, Account Receivables, Fixed Assets and Cash Management, I-Expenses
- Designed diverse business process flows using MS Visio for diverse business units
- Designed functional specifications document for diverse financial requirements based on AIM Methodology
- Analyzed
- Participated in the design of technical specification document for diverse requirements
- Analyzed financial data from diverse legacy systems and documented changes as per the requirements
- Involved in the implementation of Account payables, I-expense module within the financial application
- Set up and monitored diverse match options for purchases orders and invoices
- Assisted in the integration of I-expenses with Account payables to maintain flow of expense reports into invoices
- Participated in tracking diverse approval routes within the diverse business units
- Configured and setup diverse Credit Card and P-card programs in accounts payables
- Assisted in the setup of ledgers, segment value, MOAC, Multi-Org, TCA Architecture, and Sub-ledger accounting engine within the R12 Environment of the financial application
- Designed diverse security rules and cross validation rules for diverse accounts within the GL application
- Maintained assets accounts, participated in asset maintenance, depreciation and asset reclassification
- Designed and setup diverse expense reports within I-expense and monitored diverse invoice in account payable application
- Design diverse business processes and involved in mapping various business scenarios
- Assisted in the setup of diverse profile options for General ledger, Account Payable, Account Receivable, Fixed Assets and I-Expenses
- Assisted in designing documentation for the application users and diverse business groups
Environment: Oracle Apps 11.5.10 & R12 (GL, AP, AR, CE, FA, PO, IE) Reports 6i, Oracle 9i, 10g
Confidential, New York, NY
Oracle EBS Functional Consultant
Responsibilities:
- Gathered business requirements from end users and participated documentation of requirements
- Performed GAP Analysis for analysis of existing system and Proposed Future system
- Involved in gathering business requirements from super users for setting up the modules.
- Worked closely with the Project Managers to design of project plan and track work plans.
- Identifying the reporting requirements from User. & developed functional specs for the reporting requirements
- Performed upgrades to Oracle Application 11i to R12 using Maintenance Wizard and documented changes within the process
- Assisted in the team in the installing diverse patches in the process of upgrade and maintenance
- Identifying the requirements from User. & developed functional specs for the General ledger, Account payables, Account Receivables, Fixed Assets and Cash Management, I-Expenses
- Designed diverse business process flows using MS Visio for diverse business units
- Designed functional specifications document for diverse financial requirements based on AIM Methodology
- Assisted in the financial group in design and customization of financial reports using FSG and Report manager within GL Application
- Analyzed financial data from diverse legacy systems and documented changes as per the requirements
- Involved in the implementation of Account payables, I-expense module within the financial application
- Set up and monitored diverse match options for purchases orders and invoices
- Assisted in the integration of I-expenses with Account payables to maintain flow of expense reports into invoices
- Participated in tracking diverse approval routes within the diverse business units
- Configured and setup diverse Credit Card and P-card programs in accounts payables
- Assisted in the setup of ledgers, segment value, MOAC, Multi-org, TCA Architecture, and Sub-ledger
accounting engine within the R12 Environment of the financial application
- Designed Customization of AP Requisitions with Invoice Details Report and Offsetting account list Report.
- Worked with the technical team in design, development and testing of the Conversion, Interfaces, Reports and Workflow Customization.
- Monitored and Supported Reconciliation and Validation Testing system integration and CRP testing
Environment: Oracle Apps 11.5.9 & R12 (GL, AP, AR, FA, PO, I-procurement and I-Expenses) Reports 6i, Oracle 9i & 10g, OM
Confidential, Boston, MA
Oracle EBS Business Analyst
Responsibilities:
- Worked in the implementation of core financial and Procure to Pay module
- Involved in gathering business requirements from business users and diverse group
- Worked closely with the Project Managers to design of project plan and schedules
- Identifying the reporting requirements from User. & developed functional specs for the reporting requirements
- Identifying the reporting requirements from User. & developed functional specs for the reporting requirements
- Performed upgrades to Oracle Application 11i to R12 using Maintenance Wizard and documented changes within the process
- Assisted in the team in the installing diverse patches in the process of upgrade and maintenance
- Identifying the requirements from User. & developed functional specs for the General ledger, Account payables, Account Receivables, Fixed Assets and Cash Management, I-Expenses
- Analyzed the needs of functional departments and establishes priorities for feasibility studies and finance systems design and implementation to develop new and/or modify information processing systems
- Worked in the setups to configure P2P applications in line with business requirements.
- Performed gap analysis to understand the requirement to be developed for the customer. Defined Calendar, Currency, Chart of Accounts for General Ledger
- Assisted the client with the functional aspects of upgrade from 11i to R12 in AR, AP, FA and GL from end to end process cycle, month en close and reconciliation activities
- In addition, defined accounting calendar, currencies, inter-company accounts.
- Enhanced usage the of Bank Transfers to internal Banks and suit the Batch Reconciliation
- Execution of Testing Based on Business Cycles for Procure to Pay including Projects and Fixed Assets
- Validation of Bug Fixes and new Features with 12.1.2 Upgrade
- Worked with the technical team in design, development and testing of the Conversion, Interfaces, Reports and Workflow Customization.
- Monitored and Supported Reconciliation and Validation Testing
- Involved in unit, system integration and CRP testing
- Documented issues and assist with problem resolution
- Provided Post Implementation production support
- Part of the implementation and Testing Team - Validating reports, testing the standard functionality and custom components for GL, AP and AR
Environment: Oracle Apps 11.5.9 & R12 (GL, AP, AR, FA, Sub Ledger Accounting and I-Expenses) Reports 6i, Oracle 10g OMW
Confidential, Englishtown, NJ
Functional Consultant / Business Analyst
Responsibilities:
- Worked in the implementation of core financial and Procure to Pay module
- Involved in gathering business requirements from business users and diverse group
- Worked closely with the Project Managers to design of project plan and schedules
- Identifying the reporting requirements from User. & developed functional specs for the reporting requirements
- Analyzed the needs of functional departments and establishes priorities for feasibility studies and finance systems design and implementation to develop new and/or modify information processing
- Identifying the requirements from User. & developed functional specs for the General ledger, Account payables, Account Receivables, Fixed assets and Inventory, Purchasing
- Assisted in defining Charts of Accounts, Descriptive Flex-fields, Segments Qualifiers, Setup account hierarchy
- Worked with diverse segments and segment values, design of cross validation rules and Security rules within the financial application
- Participated in the setup of ledgers, ledger sets, Journal sources, Categories and worked with diverse data access sets
- Assisted with the configuration of diverse General ledger profile options and setup function security within the module
- Participated in the implementation of Global charts of accounts within diverse region (EMEA, APAC)
- Worked in intercompany account transactions within AGIS application
- Used report manager to generated diverse reports based on requirements
- Defined Chart of Accounts, Currencies, Set of Books, Budgets and Budgetary Control in GL
- Worked with the team in General ledger consolidation process and documenting requirements
- Customized diverse reports within the General ledger application using FSG Functionality
- Worked with the integration of financial application with oracle General ledger module
- Assisted with the opening and closing of diverse accounting periods
- Participated in the consolidation of diverse sets of accounts within financial application
- Designed Functional Approach, Written MD50(Functional Design as per AIM Methodology), Validated and Reconciled the below RICE
- Designed Customization of AP Requisitions with Invoice Details Report and Offsetting account list Report.
- Designed Customization of AR-CE Bank Reconciliation Batch Info Report
- Worked with the technical team in design, development and testing of the Conversion, Interfaces, Reports and Workflow Customization.
- Monitored and Supported Reconciliation and Validation Testing
- Involved in unit, system integration and CRP testing
- Documented issues and assist with problem resolution
- Provided Post Implementation production support
- Part of the implementation and Testing Team - Validating reports, testing the standard functionality and custom components for GL, AP and AR
Environment: Oracle Apps 11.5.9 (GL, AP, AR, FA, Sub Ledger Accounting and I-Expenses) Reports 6i, Oracle 9i
Confidential
Functional Consultant / Business Analyst
Responsibilities:
- Proactively Involved in Data Mapping and Business Requirement Analysis.
- Involved from planning, testing, documentation, and user for new features to deployment and support
- Set up of Financial Options, Payable options
- Involved in Business requirements gathering, Requirement Analysis, GAP Analysis and Business Modeling As per AWS standards
- Set up of Inter Company System.
- Set up of Consolidation Mappings and Mapping sets.
- Defined System Options, Customers, Customer Addresses, Customer Profile Classes and Banks in AR
- Defined Transaction Types, Transaction Sources, Receipt Classes and Receipt Sources in Account Receivables
- Defined Chart of Accounts, Currencies, Set of Books, Budgets and Budgetary Control in GL
- Define Streams and Pricing, Formulas, Accounting Options, Lease Accounting Templates, Account Generator, Financial Products, Invoice Group Parameters, Set up Interest Rates, Late Charges Parameters, Set Up Subsidies, Off-Lease Asset Amortization Rules, Loss Provision Rules, Lease Income Accrual Rules in FA
- Provided functional design for data conversions for Invoices and Customer Master.
- Used the Customer Bill to address for Auto Accounting in one scenario, created new transaction types.
- Design and testing of Invoice Correction Process AR, GL, Custom Workflow
- Implemented and influenced the resources and the implementation of GL, AP, AR and PO.
- Conducted CRP at various levels with different groups of End Users from each Lines of Business.
- Functional Design of procedure to upload Budgets to Projects.
- Assisted in changing the customer model using the TCA architecture and helped in creating party relationship to define the organizational structure of the business rather than creating one party to one customer account.
- Responsible for evolving a plan on how the System could be upgraded to Order Management, Shipping Execution, AR, AP, Purchasing and Inventory in 11i.
- Preparation of the GAP and functional documents to determine the customizations that would be either effected or rendered obsolete by the upgrade.
- Responsible for creating a batch process to run the Collect Data program periodically.
- Set up of the GL, AR, AP and FA modules.
Environment: Oracle Applications 11i (GL, AP, AR, FA), Reports 6i, Sun Solaris.