Sr. Oracle Financial Functional Analyst Resume Profile
San Francisco, CA
PROFICIENCY
- Over 7 years of experience in all Financial Modules including General Ledger GL , Account Payable AP , Account Receivables AR , Fixed Asset FA , Cash Management CM , E-Business Tax E-B Tax and Purchasing PO .
- Experienced in preparation and maintenance of Oracle AIM methodology documentation RD20, BR30, BP80, BR100, MD50, CV040 and TE40 and Change Management Process.
- Good integration knowledge on Procure to Pay P2P , Order to Cash O2C , Acquire to Retire A2R .
- Experienced in all levels of testing including functional testing, integration testing, system testing, regression testing, user acceptance testing using SQL.
- Good working experience on Data Conversion and Migrations life cycle.
- Experienced in identifying GAPS, providing Fit-Gap analysis and solution designing to the RICE components.
- Good experience and co-ordination with technical team for the timely deliverable.
- Conducted CRP's and provided wide range of functional training to multiple business user groups and co-ordinate UAT sessions.
- Experienced in Functional Analysis, Requirement Analysis, Process mapping, Functional specification preparation, application configuration, Testing, Data migration and user training.
- Experienced in Managerial Accounting, Principles of Financial Accounting and Financial Business Processes.
- Good communication skills and leadership qualities with analytical problem solving abilities.
- Good experience in co-ordinating multiple business meetings and following up on open item.
TECHNICAL SKILLS
Oracle Applications : R12 GL, AP, AR, FA, PO, CE, E-B.Tax 11i 11.5.8, 11.5.9, 11.5.10 and
11.5.10.2
Languages and Tools : PL/SQL, SQL, HTML, Web ADI, Load runner, Data Loader, Discoverer, Toad
Knowledge on other Modules : PO, iExpenses and Cycles including P2P, O2C, A2R
Applications : MS Office Word, Excel, PowerPoint, Outlook , MS Visio
PROFESSIONAL EXPERIENCE
Confidential
Role: Sr. Oracle Financial Functional Analyst
Responsibilities:
- Provided various custom solutions for client specific needs along with functional impact analysis
- Setting up Payment methods, Payment format and Payment Process Profile etc, Set up suppliers, locations, and purchasing quick codes
- Setup payment terms, invoice distribution, matching of invoices against Purchase orders, Setting up PO matching option, invoice tolerances, distribution options, terms, holds etc
- Prepared System Test Scripts TE040 for UAT sessions and Training Documents with screenshots for end users.
- Prepared BR.100 Application setup and MD 50 Application Extensions Functional Design documents according to AIM.
- Used the System Administrator responsibility to define users and assign responsibilities and set profile options
- Define Organization Structure MOAC , Users and Responsibilities, Security Profiles and Flex Fields
- Set-ups and maintenance, converted the headers, lines and line locations from the legacy system to Oracle Payables
- Involved in setup for Payables, Inventory, Purchasing, General Ledger based on deep understanding of the functional processes
- Design Develop FSG reports in GL, Set up AP bank accounts, bank documents, bank codes and expense report templates, defined profile options to specify certain implementation parameters
- Set up Recurring journals template, recurring journals and Auto-reversal in GL, set up suppliers, locations, and purchasing quick codes.
- Setup payment terms, invoice distribution, matching of invoices against PO. Configured Financial Options and Payables Options in AP.
Environment: OracleEBS Release 12 General Ledger, Accounts Payable, Accounts Receivables, Procure to Pay, CE, Inventory, SLA.
Confidential
Role: Oracle EBS Financial Functional Analyst
Responsibilities:
- 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.
- Identified gaps between business requirements and current application within the environment.
- Identified the requirements from User developed functional specs for the General ledger, Account payables, Account Receivables.
- Involved in developing specs for Fixed Assets and Cash Management.
- Assisted in the setup of ledgers, segment value, MOAC, Multi-Org, 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.
- Assisted in the setup of diverse profile options for General ledger, Account Payable, Account Receivable, Fixed Assets and I-Expenses.
- Assisted in designing training 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
Role: 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
- Participated in meetings in the design of new chart of accounts and analysis of diverse financial accounts
- Assisted in resolving business users issues pertaining to the financial application
- Participated in the analysis of diverse financial accounts Expenses and Assets Accounts
- Worked in the setup and configuration of ledgers, Cross validation Rules, Data Access Sets, diverse segments within the accounting structure
- Identify gaps between business requirements and current application within the environment
- 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
- Worked in the configuration of diverse FSG reports within the General Application based on requirements
- Assisted in the design of test cases and scripts for various functionalities within the financial application
- Assisted in designing training 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
Role: Junior: Oracle Functional consultant
Responsibilities:
- Reviewed the Business Requirements Documents with the business and development teams On GL AP AR OM and PO.
- Analyzed the functionality of the Oracle applications so as to finalize the solution.
- Participated in business planning and requirements review of Oracle Financials, Discrete Manufacturing, Order Management / Shipping and Inventory.
- Responsible for requirements review of Customer Relationship Management, Logistics Management and Enterprise Asset Management solutions.
- Worked on Procure to Pay P2P current business process and documented the business procedures and prepared end user documentation.
- Co-ordinated with project Manager, Business team for system updates and deadlines for the implementation.
- Worked on migration of a legacy system to the client's Oracle apps R12 system.
- Prepared and posted monthly journal entries.
- Bank reconciliation's and reclassify the charges.
- Prepared monthly financial statements and account analysis.
- Consolidated statement of operation comparison and update capital expenditure log.
- Prepared packages for assigned location managers and provide explanations for respective charges.
Environment:Oracle Apps 11.5.10.