We provide IT Staff Augmentation Services!

Oracle Financial Functional Consultant Resume

Omaha, NE

SUMMARY

  • 8+ years of strong Professional Financials Functional expertise in Oracle R12 & 11i versions and Functional domain expertise in diverse domain
  • Expertise working on multiple projects in implementation, up - gradation and post production support projects with change management process with Professional expertise in Designing, Implementation, Customization and Testing in Oracle Financials module which include General Ledger (GL), Account Payables(AP), Account Receivables(AR), Fixed Assets(FA), Cash Management(CE), E Business Tax(E-BTax), System Administration(Sys Admin)
  • Extensively experienced in the entire Oracle implementation cycle i.e. Baseline & Requirements analysis, solution design, system configuration & set-ups, data migration, pilot testing, trouble shooting, implementation, roll out, user training and post implementation support
  • Have been involved in working with Global implementations and AGIS (Advance Global Intercompany System)
  • Have been involved in MOAC & Multi-Currency, re-valuation, translation and GCS (Global Consolidation System), Designed and developed Financial Statements (FSG’s) as per Business Requirement.
  • Complete functional and integration knowledge on Purchasing (PO), Order Management (OM) and Inventory (INV).
  • Excellent understanding of business process flow in Procure to Pay (P2P), Order to Cash (O2C), Sub-Ledger Accounting (SLA).
  • Interacted with Oracle support to resolve application issues, bugs and TAR/SR management.
  • Involved in Data Conversions/Migration and designed function specific document of data (Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and open receipts) from Legacy System to Oracle.
  • Experience in using Oracle’s Application Implementation Methodology (AIM): Business Functional Requirement analysis, Understanding AS-IS process, TO-BE process, Gap analysis, Solution designing and building RICE components, System configuration, Conducted CRP’s, Co-ordinate UAT and extensively worked on Preparing documentation (BR 100, BR 150, BR 30, MD 50, BP 80, RD 20,CV 40 &TE 40) and Testing.
  • Experience in System Admin tasks like creating/administering Users, Responsibilities, Menus, Forms, Profile options, printer Configurations, registering of concurrent programs
  • Excellent communication skills and leadership qualities with analytical problem solving skills and thorough knowledge on Microsoft technologies like (Office, Project, Visio and Visual Studio).
  • Flexible to adapt any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

Oracle Applications: E- Business Suit versions 11i (11.5.8, 11.5.9, 11.5.10, 11.5.10.2), R12 (12.0.3, 12.0.5, 12.0.6, 12.1.1, 12.1.3) - GL including AGIS & SLA, AP, AR, FA, CE, e-B Tax, iExpenses and PO

Documentation: AIM Methodology (Scope, Business Process, Business Requirement, Conversions, Mapping).

Operating Systems: Windows (95, 98, XP, NT, Vista, 7), Linux.

Software Tools: MS Office, MS Visio, Use of SQL Developer, TOAD to extract data from core tables, Discoverer, MS Visual Studio, SQL server, UPK (User Productivity Kit), Hyperion, Web ADI, Data loader, OBEEI and XML publisher.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Oracle Financial Functional Consultant

Environment: Oracle E-Business Suite R11.5.10

Responsibilities:

  • Provide front line support of existing transactional, financial, and reporting systems in the areas of Accounting, Payables, Purchasing, Fixed Assets, Order Management, Receivables, Collections and Credit Management on current 11i system and also assists on R12 implementation under various capacities
  • Directly work with business users to resolve any problems with Oracle applications using trouble shooting skills and functional expertise.
  • Develop test strategy and author test plans as required for application releases, enhancements and patches.
  • Reviewed and approval for project documentation that includes BP 80, CV40, MD50 for all RICE Components and BR100 documents
  • Participate and contribute to all phases of systems development, including requirements, design, development, client training, data conversion, testing and maintenance to achieve the successful development and implementation of Oracle R12
  • Track lead for AP (also responsible for some item related to Purchasing and iExpense)
  • Track lead for Cash Management and Fixed Assets
  • Assign to lead development and documentation of end user training materials and desktop procedures for R12 and deliver training sessions in a class room type environment to Accounting transactional operations teams which support Accounting, General Ledger, Payables, Purchasing, Fixed Assets, Order Management, Service contract, Receivables, Collections and Credit Management
  • MD50 Functional design for all customization or GAP identified during GAP/FIT review
  • Prepared detail Test cases for FA, Payables, Purchasing, Cash Management
  • Provide solution for Payment Automation for US, GB, NL and IN and work with different Banks to developed Payment File(XML, GDFF etc.) as per Bank requirement along with the complete automation of Bank Statement and Auto reconciliation

Confidential, Orange County, CA

Sr.Oracle Financial Functional Consultant

Environment: Oracle E-Business Suite R11.5.9

Responsibilities:

  • Involved in Configurations, Consulting and Training Business Users for new R12 features
  • Responsible for setting up functional like MOAC, Data Access sets, Report Manager, Payment Process
  • Replacing existing CEMLI / RICE components in 11i with ceded R12 Functionalities
  • Conducted conference room pilot testing sessions, HP testing and Mercury testing.
  • Responsible for complete functional testing and resolving issues
  • Actively involved with BSAs and SMEs to provide all kind of support related to the Project
  • Responsible for SLA Configuration for Cost Management and Payables for Confidential Reporting requirement
  • Interacted with Oracle support and raised SR for critical issues
  • Responsible for Offshore Team Coordination with the assigned tasks/issues
  • Set-up receipt class, receipt methods, receivable activities and setting up accounting information for revenue recognition
  • Defined Customers, organizations, locations, control rules and groups.
  • Setting up Consolidation Ledgers, AGIS for intercompany Transactions
  • Auto import and reconciliation of bank statement in CE
  • Successfully conducted CRP 2 and CRP 3
  • Conducted UAT and closed UAT issues on a timely basis
  • Responsible for developing User Training Document for GL,AP and AR Users
  • Resolved issues that occurred in the production using Help Desk Ticket and Share Point Portal
  • Have followed up with the business for approval of the resolved issues
  • Post-Go Live, was responsible for Production issue resolution and for any Change Request used Change Management Protocol to get it approved from the Business before it migrates to Production

Confidential, New Albany, OH

Sr.Oracle Financial Functional Consultant

Environment: Oracle E-Business Suite R12.1.3

Responsibilities:

  • Implementing Accounts Payables, Purchasing, General Ledger and Fixed Assets for all business units of Justice
  • Identifying standard functionality, and analyze gaps and complete solution for GL, AP, PO and FA depending on Business requirement
  • Business communications for the system updates and meeting deadlines for the implementation.
  • Setting up Multi-ORG and Multi Currency
  • Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies
  • Setting up Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, Defining FSG’s, Creating Ad-hoc Reports, and Open and Close Accounting Periods
  • Setting up AP for PO matching and non-matching supplier invoices, payment profiles for check and wire, sub ledger accounting of payables transactions and transfer to GL
  • Setup Banks, Bank Accounts and documents
  • Set-up of invoices, debit and credit memos
  • Defined payables lookup, payables option, tax codes, set up bank details, invoice payment terms.
  • Defined distribution sets, matching tolerances for purchase order matching, payment programs and payment formats.
  • Created different types of invoices and payment methods.
  • Setup financials and payables options including all key configurations in Accounts Payable
  • Conducted CRP 1 & CRP 2, Tested RICE components and UAT
  • Prepared BP 40, CV40, BR100 documents and created MD 50 for all RICE components

Confidential, Long Beach, NY

Oracle Financial Functional Consultant

Environment: Oracle E-Business Suite R12.1.1.

Responsibilities:

  • Defined Business requirements for Oracle GL and AR, involved in identifying GAPS
  • Prepared Documentation of BR 100, BR 30 and Functional Extension and design Document MD 50
  • Involved in all the business meetings and communicated with the business for system updates and the meeting of implementation deadlines
  • Was involved in finding effective solutions that consisted of both work around and customizations to the forms and reports
  • Prepared impact analysis document for the upgrade of financials module
  • Created users and modified the privileges for users, rollup group and summary accounts
  • Created suspense accounts for automatic balancing journal entries from particular sources and categories
  • Created budget, budget organization, master detail relationship, budgetary control and budgetary control groups
  • Developed several FSG reports, including balance sheet and income statements
  • Set-up supplier and supplier sites for suppliers in payables
  • Developed several custom reports and customized oracle reports for payables
  • Set up banks, receipts, transactions, plus training for invoicing, receipts, adjustments, and period close
  • Created updating adjustment of invoices, debit memos, credit memos
  • Defined banks, customers, receipt classes, collectors
  • Analyzed and mapped historical data of existing customers
  • Setup customer profile class, profile attributes, customer relationships, statement cycles and accounting rules
  • Defined system options, transaction types, auto cash rule sets, remittance banks, bank accounts, receipt classes, distribution sets and payment methods Trained and guided users through the testing period
  • Responsible for setting up delta functional like MOAC, Data Access sets, Report Manager, Payment Process
  • Responsible for complete functional testing and resolving issues
  • Identified RICE components according to the client needs
  • Created Chart of Accounts, accounting Calendar, Currency, defined Legal entities and completed Ledger accounting options as per client requirement
  • Created multiple responsibilities, developed security rules and customized menu to restrict user access to GL functionality as per client’s requirement
  • Defined formulas for Mass Allocation and Recurring Journals and completed setup of options required to perform Mass Allocations
  • Defined Budgets, Budget Organizations, Budget Formulas, and Defined Budgetary control options, Created Master/Detail budgets, Defined Mass Budgets and Mass Budget formulas
  • Involved in the setup of intercompany balancing and global intercompany system
  • Designed and created reports for client using the FSG
  • Defined setup steps of the AR module. These included System Options, Receipts, Lockbox, Quick Codes and Taxes. Exemptions were defined, as products were not subject to tax in all states
  • Defined Customers, customer profile classes, payment terms, and distribution sets, and Auto Cash Rule Sets
  • Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources
  • Defined accounting options, methods of accounting, realized gain/loss account, unallocated revenue account, auto cash rule set, and auto invoice tuning
  • Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defined collectors, and defined aging buckets
  • Created customer profile classes, attached payment terms, collectors, matched receipts, statement cycle to profile classes
  • Setup transaction types, invoices, guarantees, deposit, and credit memos, debit memos
  • Assigned receivable account, revenue account, unbilled account, freight account, cleared account, and unearned account to transaction types
  • Conducted CRP 1, CRP2, CRP3 and tested all the setup

Confidential, San Francisco, CA

Oracle Financial Functional Consultant

Environment: Oracle E-Business Suite R12.0.6

Responsibilities:

  • Involved in Month-end support for close and reconciliation for AP and AR modules
  • Prepared impact analysis for critical issues
  • Resolved issues that occurred in the production
  • Have followed up with the business for approval of the resolved issues
  • Worked with the business to develop updated business policies based on issues resolved
  • Actively involved in troubleshooting various issues
  • Provided production support on GL, AP, AR, FA, PO, and iExpense modules and resolved period end closing and interface issues in production. Trained user on process design and enhancements
  • Resolved all the issues which were raised in Bugzilla
  • Interacted with Oracle Support to resolve critical issues through SR/TAR
  • Periodical status updates to PMO and follow up with pending business input or issue resolutions as part of status meeting

Confidential, Dallas, TX

Oracle Financial Functional Consultant

Environment: Oracle E-Business Suite R12.0.6

Responsibilities:

  • Interacted with the Business and analyzed existing business practice and prepared business requirement document and identified Gaps
  • Created Chart of Accounts, calendar and currency according to the business requirement
  • Defined Primary Ledger, secondary ledger and defined accounting setup options
  • Setup Security rules, data access sets, Cross validation rules, recurring journals, revaluation template and translation
  • Involved in the design and setup of legal entities and the related inventory organizations using the legal entity Configurator
  • Setup of PO matching options, invoice tolerance, term holds, expense report templates, banks, bank branches and bank accounts
  • Configured Payables System options, financial options and payables options
  • Defined Payment Terms and Distribution Sets
  • Designed and configured setups in Inventory, Purchase and Account Payables modules to meet the Purchase Requisition to create asset process
  • Involved in the setup of auto invoice workflow
  • Reviewed current business process and documented the business procedures for Purchase to Pay and Payments.
  • Involved in the setup of tax configuration using the Regime to Rate flow and setup the tax rules
  • Conducted CRP’s and trained end users for GL, AP, PO and E-B Tax
  • Conducted User Acceptance Test (UAT)
  • Involved in Documentation of Current Business setup (BR 100, BR 30), Conversion (CV 40), Test scripts
  • Responsible for unit and integration testing
  • Worked with technical team for data conversion

Confidential, Plainville, CT

Oracle Financial Functional Consultant

Environment: Oracle E-Business Suite R12.0.5

Responsibilities:

  • Conducted meetings with Business users to perform the requirement analysis and developing functional specifications for the module including interaction with other modules.
  • Involved with study of existing system, preparing the Functional (MD50), design document and Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables.
  • Drafted extensive set of requirements, questionnaire and gap analysis.
  • Involved in design and configuration of chart of accounts, calendar and currency.
  • Set up Suppliers, created Purchase requisitions, Purchase orders in Oracle Purchasing.
  • Setting up PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds, etc.
  • Customized business areas simple and complex folders using Discoverer administrator and customized and created new reports using desktop.
  • Implemented user/responsibility level security for workbooks as well as business areas in discoverer.
  • Worked on inbound interfaces in PO and AP module to import the data from legacy system to Oracle Application.
  • Interacted with Oracle support and raised SR for critical issues
  • Successfully conducted CRP 1 and CRP 2
  • Conducted UAT and closed UAT issues on a timely basis
  • Created and generated system test scripts for different test scenarios covering all aspects of project functionality.
  • Handled functional related issues by investigating and applying solution for specific problems.
  • Conducted designing test automation strategies, created test scenarios, test plans and performed inspection of test scripts.
  • Interacted and worked with the development team to solve the problems encountered in the test scenario run.
  • Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
  • Involved in development of RICE components as per business requirement.
  • Defined payment terms and recurring invoice templates. Set up employee expense template.
  • Provided support to users during go live by way of problem solving and instructions.

Confidential, Summit, NJ

Oracle Financial Functional Consultant

Environment: Oracle E-Business Suite R12.0.4

Responsibilities:

  • Responsible to conceptualize, design and implement the Oracle Payables and Fixed Assets modules.
  • Gathering Business requirements from business users and studied in depth of existing business process flow.
  • Carried out Requirement Study for Oracle Payables and Fixed Assets. This involved extensive user interactions, understanding business requirements, identifying information needs, mapping them on to the Oracle Applications functionality, demonstrating them to client group and recommending the relevant Applications Fit. This included identifying the ‘As Is’ flows, arriving at the ‘To Be’ business flows & documenting them.
  • Firming up the Requirements Definition, Presentation of the process flows to the client team and obtaining concurrence on the final process flows
  • Handling additional user requirements on different screens using descriptive flex fields.
  • Provided workaround solutions whenever application didn’t support for the client’s requirements.
  • Defined mass allocation formula for budgeting issue when assets are transferred from AP to FA.
  • Developed design document for Customizations around integration of Purchasing with Payables during invoice match with Purchase order.
  • Firming up of the final prototype and the set-ups after incorporating the feedback from the client team.
  • Carrying out production set-ups for setting up live system.
  • Provide training to the client team (Both First cut & End user) for the above modules.
  • Interacted with purchasing users for the matching of invoices with Pos.
  • Provided functional support for the design & development of custom forms & reports, to meet specific client requirement.
  • Planned and executed data migration / conversion activities. Used ADI tool to load assets.

Confidential, San Jose, CA

Oracle Financial Functional Consultant

Environment: Oracle E-Business Suite R12.0.2

Responsibilities:

  • Track all issues in the issue tracker and update with proposed solution for future reference
  • Conduct OWC sessions with Oracle for speedy resolution of Pending high prioritized issues
  • Assist business team with complete month end process including third party integration issues, if any.
  • Supported the implemented Receivable and Payables modules which involved daily issues and new customizations and enhancements based on the changing requirements in the system.
  • Supported Month End & day to day Activities as part of Post Production Support
  • Written SQL queries from bank-end using TOAD.
  • Opened and followed through on Technical Assistant Request (TAR) with Oracle

Hire Now