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).

PROJECTS:

Confidential, Coppell, TX 06/2011 - Present
Oracle Function Consultant (P2P, GL, SLA) (Version 12.1.3)

Brink\'s,Incorporatedprovides U.S. and global security services including secure transportation and logistics solutions.

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 04/2010 - 06/2011
Oracle Functional Consultant (P2P, GL, AR, Adv collection, SLA) (Version 12.1.1)

Confidential, is global leader in logistics and transportation services.

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 12/2008 - 01/2010
Oracle Functional Consultant (GL, P2P,AR) (Version 11.5.10.2)

Perry Equipment manufactures of filtration, flow measurement, vessels and metering systems for major oil and natural gas companies in Texas area.

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 07/2008 - 11/2008
Oracle Functional Consultant (AP, FA) (Version 11.5.8)

Confidential, is one of the famous software industries with inventing new innovative software's and providing support to their worldwide customers.

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 05/2007 - 07/2008
Oracle Functional Consultant (GL, AP, AR, CE) (Version 11.5.10.2)

Confidential, is one of the famous business group in retail business of office stationery and accessories in United States of America and Canada.

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, 07/2006- 05/2007 Moberly, Missouri
Functional Consultant (AP, AR, FA), (Version 11.5.10.2)

Confidential, is one of the retail business company offerings products, which includes grown lawn and garden,farm supplies, livestock feed, animal health, pet food and supplies, hardware, plumbing,electrical, automotive, toys, housewares, work and western clothing, and in select locations - sporting goods.

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 09/2005- 06/2006
Oracle Functional Consultant (GL, P2P, AR), (Version 11.5.10.2)

Confidential, is a global leader in enabling process materials and process technology for semiconductor, display and life science industries. At ATMI, process ingenuity unleashes new process possibilities for customers.
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 03/2005 - 08/2005
Oracle Functional Consultant (AR, AP, CE), (Version 11.5.10.2)

Confidential, is one of the famous business group in the fields of Graphic & Designs, Business Services, Consultation, web design, and technology sales.

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

Confidential, Tempe, Arizona 10/2004- 01/2005
Functional Consultant (GL, AP, PO), (Version 11.5.10.2)

Confidential, has multiple business products of computer hardware, software and software manufacturing.

Responsibilities:

• Defined profile options to specify certain implementation parameters, Processing Options and System Options
• Defining System Item Flex field, Defining Organization and worked with customization of forms and reports
• Defining accounting options, methods of accounting, realized gain/loss account, unallocated revenue account, auto cash rule set, and auto invoice tuning
• Set up suppliers, defined payment terms, locations, item category flex field and purchasing quick codes
• 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 profile options to specify certain implementation parameters, Processing Options and System Options
• Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defining collectors, defining aging buckets
• 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
• Created user-manuals for programs and user procedures
• Interacted with Oracle support through SRs and OWCs to resolve production issues

Confidential, Ahmedabad, India 03/2003 - 06/2004
Business Analyst

• Conducted System Analysis by interacting with managers and users to gather requirements
• Liaison with business managers to coordinate periodic & accurate report generation to manage MIS activities
• Created logical and physical design of the database
• Provided development support for any business requirements for existing applications and supporting client requests
• Provided unit testing, module testing and integration testing