SUMMARY

• Oracle Financial Business Analyst with over 8 years of domain experience and over 7+ years of oracle applications experience in various implementation and integration of Financials applications, business process analysis, quality management processes, system analysis, system integration, testing, post production support and training.
• Interacted with all levels of business owners, users, and implementation and production team during the various stages of project life cycle.
• Assisted the client with the formation of a business case to move from legacy system to Oracle 11i and R12.
• Coordinated several process design and requirements gathering activities.
• Conducted and evaluated business process review and gap analysis to meet the business requirements not addressed by the applications.
• Prepared various documents required under the AIM and OUM methodologies
• Managed the execution of key deliverables including process flows, configuration documents, test execution, training, conversion, deployment and post production support within the set timelines.
• Identified the requirements, issues and impacts of consolidating multiple systems under one instance.
• Interacted with the Oracle support team to resolve application issues, bugs and TAR/SR management
• Designed and developed test scripts.
• Created mapping for interfaces to existing systems and conversion of legacy data.Designed custom financial reports using ADI.
• Conducted Link, System and Integration testing.
• Conducted user acceptance testing (UAT) and end user training through instructor led sessions and virtual classes.
• Created user - manuals for programs and user procedures. Provided post production support for the financial modules.
• Designed and developed training material for end user training

TECHNICAL SKILLS

Applications: Oracle ERP Applications 11i and R12

Primary Modules: General Ledger and GCS, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Purchasing and iExpenses (GL, AP, AR, CE, FA, PO and iExpenses).

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Oracle Functional Consultant

Responsibilities:

• Conducted end-user meetings to review current business processes and requirement gathering.
• Prepared the various requirement gathering and functional design documents
• Designed the training material for introductory super user training
• Worked with the users to come up with the future business process
• Set up Financial and Payable option AP
• Defined payment terms, invoice approval hierarchy and payables look-ups in AP
• Enabled assets key, category and location key flex fields
• Created mass additions
• Defined the prorate calendars, depreciation rate and calendars, fiscal calendars and book controls
• Defined Asset Categories
• Resolved complex issue through metalink

Confidential, Coppell, TX

Oracle Function Consultant

Responsibilities:

• Conducted end-user meetings to review current business processes and requirement gathering.
• Prepared the various requirement gathering and functional design documents
• Designed the training material for introductory super user training
• Worked with the users to come up with the future business process
• Configured Ledgers
• Defined Chart of Accounts, Currency, Calendar
• Set up suppliers, locations, and purchasing quick codes.
• Setup Purchasing Categories, Sourcing Rules, Approved Supplier Lists, Suppliers, Purchasing and Receiving Options in Purchasing module
• Setup payment terms, invoice distribution, matching of invoices against PO
• Involved with migration of historical data for Accounts Payables.
• Set up Financial and Payable option AP
• Defined payment terms, invoice approval hierarchy and payables look-ups in AP
• Implementation of the Accounts Receivables module, trouble shooting and conducted CRP
• Set-up of invoices, debit and credit memos, guarantees, transaction types, and deposit.
• Defined receipt class.
• Created customer profile classes, attached payment terms, collectors, matching receipts, statement cycle to profile classes.
• Configured SLA for invoice, Credit memo, Debit memo
• Resolved complex issue through metalink

Confidential, Green bay, WI

Oracle Functional Consultant

Responsibilities:

• Conducted end-user meetings to review current business processes and requirement gathering.
• Prepared the various requirement gathering and functional design documents.
• Defining accounting options, methods of accounting, realized gain/loss account, unallocated revenue account, auto cash rule set, and auto invoice tuning
• Set up suppliers, locations, and purchasing quick codes.
• Setup Purchasing Categories, Sourcing Rules, Approved Supplier Lists, Suppliers, Purchasing and Receiving Options in Purchasing module
• Setup payment terms, invoice distribution, matching of invoices against PO
• Defined location, control rule and group, buyers and document controls
• Designed and tested FSG report
• Defined profile options to specify certain implementation parameters, Processing Options and System Options
• Set-ups and maintenance, converted the headers, lines and line locations from the legacy system to Oracle purchases
• Set up Oracle purchasing by defining locations, buyers, approval groups, lookup codes, and approval procedures for RFQ’s, purchase orders and long term contracts
• Involved with migration of historical data for Accounts Payables.
• Set up Financial and Payable option AP
• Defined payment terms, invoice approval hierarchy and payables look-ups in AP
• Configured SLA AAD, custom source, mapping sets for Account Payable
• Configured SLA AAD, mapping sets, condition for Receivable Adjustment, invoice, Credit memo, Debit memo
• Conducted end user training
• Involved in Month end closing
• Provided support on AR, Adv collection, GL, FA modules.
• Resolved complex issue through metalink

Confidential, Mineral wells, Texas

Oracle Functional Consultant

Responsibilities:

• Conducted end-user meetings to review current business processes and requirement gathering.
• Prepared the various requirement gathering and functional design documents
• Designed the training material for introductory super user training
• Worked with the users to come up with the future business process
• Configured Set of book
• Developed month end and other financial reports
• Involved with migration of historical data for Accounts Payables.
• Set up Financial option AP
• Defined payment terms, invoice approval hierarchy and payables look-ups
• Calendar change in GL from Fiscal to a Calendar year, includes create new calendar and set of books, update the existing calendar.
• Implementation of the Accounts Receivables module, trouble shooting and conducted CRP
• Set-up of invoices, debit and credit memos, guarantees, transaction types, and deposit.
• Defined receipt class.
• Created customer profile classes, attached payment terms, collectors, matching receipts, statement cycle to profile classes.
• Assigned receivable account, revenue account, unbilled account, freight account, clearing account, and unearned account to transaction types
• Conducted end user training
• Involved in Month end Closing
• Worked on Quality Center tool for Test Script
• Resolved complex issue through metalink

Confidential, Aliso Viejo, CA

Oracle Functional Consultant

Responsibilities:

• Conducted end-user meetings to review current business processes
• Prepared the various requirement gathering and functional design documents
• Setup payment terms, invoice distribution, matching of invoices against PO
• Set up Financial option & Payable option in AP
• Defined invoice approval hierarchy and payables look-ups
• Set up AP bank accounts, bank documents, bank codes and expense report templates
• Set-up of custom request set, Check Program format
• Enabled assets key, category and location key flex fields
• Created mass additions
• Defined the prorate calendars, depreciation rate and calendars, fiscal calendars and book controls
• Defined Asset Categories
• Conducted end user training
• Involved in Month end Closing
• Worked on Quality Center tool for Test Script

Confidential, Delray Beach, FL

Oracle Functional Consultant

Responsibilities:

• Conducted end-user meetings to review current business processes
• Prepared the various requirement gathering and functional design documents
• Involved with migration of historical data for Accounts Payables
• Set up Financial option & Payable option in AP
• Defined payment terms, invoice approval hierarchy and payables look-ups
• Set-up of invoices, debit and credit memos, guarantees, transaction types
• Setup Receipt Class, Receipt Methods, Receivable Activities and Document Sequences
• Created customer profile classes, attached payment terms, collectors, matching receipts, statement cycle to profile classes
• Defined system parameters and Bank Statement Mapping
• Defined transaction code for reconciliation
• Reconciled AP and AR with bank statement
• Worked on Mercury Quality Center for Defect and Test Script
• Resolved complex issue through metalink

Confidential, Missouri

Functional Consultant

Responsibilities:

• Defined Business requirements for Accounts Payables, Accounts Receivable and Fixed Assets. This involved identifying GAPs
• Prepared the various documents required under the AIM methodology
• Involved in finding effective solutions that involved both work around and customizations to the forms and reports.
• Conducted business process review and gap analysis to determine business requirements
• Set up AP bank accounts, bank documents, bank codes and expense report templates
• Defined payment terms, invoice approval codes and payables look-ups
• Defined the 1099 suppliers and testing the tax payment extractions for reporting purpose
• Set up transaction types, invoices, guarantees, deposit and credit memos, debit memos
• Worked with technical team to migrate suppliers, employees, bank information and open invoices data for AP.
• Participated in testing, user accepting testing in production and test instance
• Interacted with Oracle Support to resolve application issues through SR and OWC.
• Worked on clearing out invoices, amounting to more than 3 million, which were on hold because of 3-Way matching issues
• Corrected the system configuration to take care multi currency invoice entry and payments
• Conducted refresher training for end users into various processes of Accounts Payables like supplier entry, matching invoices to Purchase Order.
• Defined payment terms, invoicing, accounting rules, auto cash rule set, auto invoicing and invoice sources.
• Transferring receivable transactions to the general ledger module.
• Defined receipt class
• Created training material and user guides for the end users
• Coordinated with the off-shore technical team to customize the invoice approval workflow.
• Provided Post production support for AP, AR, and GL
• Resolved complex issue in post production through metalink

Confidential, Danbury, CT

Oracle Functional Consultant

Responsibilities:

• Set up suppliers, defined payment terms, locations, item category flexfield and purchasing quick codes
• Worked with Oracle Support to resolve application issues, bugs and TAR/SR management
• Set up Account Payables to create invoices by using ‘Oracle Pay-on-Receipt Option’
• Setup payment terms, invoice distribution, matching of invoices against PO
• Defined location, control rule and group, buyers and document controls
• Designed and tested FSG report
• Defined payment terms, invoicing, accounting rules, auto cash rule set, auto invoicing and invoice sources.
• Transferring receivable transactions to the general ledger module.
• Defined receipt class.
• Created customer profile classes, attached payment terms, collectors, matching receipts, statement cycle to profile classes.
• Assigned receivable account, revenue account, unbilled account, freight account, clearing account, and unearned account to transaction types
• Involved with writing and executing test scripts
• Created user-manuals for programs and user procedures
• Interacted with Oracle support through SRs and OWCs to resolve production issues
• Provided Post production support for AP, AR, and GL.
• Resolved complex issue in post production through metalink

Confidential, Atlanta, GA

Oracle Functional Consultant

Responsibilities:

• Assisted the team lead in preparing CRP scripts and delivering CRP to AP, AR Team including senior Management
• Involved with migration of historical data for Accounts Payables and Accounts Receivable
• Used the System Administrator’s responsibility to define users and assign responsibilities and set profile options
• Defined the employees, suppliers, and banks
• Provided basic end user training to selected client employees
• Defined payment terms, invoicing, accounting rules, auto cash rule set, auto invoicing and invoice sources
• Transferring receivable transactions to the general ledger module
• Defined receipt class
• Defined system parameters and bank transaction codes for cash management
• Designed and developed test scripts
• Integrated testing, user accepting testing in production and test instance
• Interacted with Oracle support to resolve application issues, BUGs and TAR/SR managementon, prorate calendars, depreciation rate and calendars, fiscal calendars, book controls and system controls
• Participated in testing, user accepting testing in production and test instance