Financials Functional Analyst Resume Profile
Woodland Hills, CA
PROFESSIONAL SUMMARY
- A successful financial functional consultant having 11 years of experience in the IT industry as Oracle Apps Financial Functional consultant GL, AP, AR, FA and CM with exposure to Supply Chain SCM , releases 11i and R12. Have worked closely with financial functional users and implementation teams in successfully translating business requirements into functional specifications and deliverables.
- Professional expertise in Designing, Implementation, Customization and Testing of Oracle Financials including General Ledger GL , Account Payables AP , Account Receivables AR , Fixed Assets FA , Cash Management CM , Order Management OM , Inventory INV and Purchase order PO .
- Multiple project life cycles experience Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering, Facilitated Workshops, Scope Verification Validation, Alternatives Identification and Analysis, Functional Design Development, Integration User Acceptance Testing, Training, Cut off, Go-live, , and post-implementation support.
- Experience in working with global implementations and implemented AGIS Advance Global Intercompany System , Involved in Multi-Org Multi-Currency, re-valuation, translation and GCS Global Consolidation System , Designed and developed Financial Statements FSG's as per Business Requirement .
- Worked on Oracle Service Contracts, Account Receivables, Order Management, TCA, Inventory Modules.
- Extension knowledge and expertise of business process flows in the areas of Procure to Pay P2P , Order to Cash O2C , Sub-Ledger Accounting SLA .
- Involved in Data Conversions/Migration and designed function specific document of data for Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and unapplied receipts from Legacy System to Oracle.
- Experience in using and maintaining documentation of Application Implementations Methodology AIM ,which includes Business Functional Requirement analysis, Gap analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration and testing BP 80,RD20,BR30,BR 100, MD 50, CV 40 TE 40
- Conducted CRP's, provide wide range of functional training to multiple business user groups and Co-ordinate UAT.
- Create SR's with Oracle Technical Support, coordinate and follow on multiple issues based on priority including identifying bugs and follow-up with Oracle Development
- Conduct multiple meetings with business, coordinate with Offshore team and create functional Impact Analysis documentation as part of Change Management Process
- Excellent communication skills and leadership qualities with analytical problem solving abilities
WORK EXPERIENCE
Confidential
Financials Functional Analyst
Responsibilities:
- Worked as a Financials Functional for implementation of EBS R12 was responsible for AP and AR through to Go-Live.
- Reviewed the Business Requirements Documents with the business and development teams On AP AR analyzed the functionality of the Oracle applications so as to finalize the solution.
- Participated in business planning and requirements review of Oracle Financials, Advanced Supply Chain Planning, 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.
- Solid project experience working with Oracle workflow, Oracle Forms, Oracle Reports.
- Coordinated 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.
Environment: Oracle apps Functional 11i to R12 upgrade Financials GL, AP, AR, FA, and CM
Confidential
Financials Functional Analyst
Responsibilities:
- My responsibilities include requirement gathering, current business process analysis, re-engineering and designing of business process, system configuration and system testing.
- Designed Key Accounting Flex field structure COA for Ledger and configured with Multi Org and Multi Reporting Currency setup. Defined system controls, intercompany accounts, summary accounts, journal sources, and journal categories. Defined various currencies for multi-currency operations and currency translation, conversion, revaluation has been done to meet the requirement. Cross validation rules have been setup for various GL codes. Configured Sub-ledger accounting process to GL. Defined Security rules at segment level.
- Reviewed current business process and documented the business procedures for Procure to Pay P2P
- Worked on integrates Oracle Financials applications and is designed to meet the business requirements of asset-based finances
- Payables process had been designed and system had been configured and setup for Financial option, Payable system option Payable option to meet the requirements such as batch invoices, batch payments, employee expense report process, withholding tax, 1099 reporting, cross currency invoices and payments.
- Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements.
- Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping.
- Configured CRP's, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
- Solid project experience working with Oracle workflow, Oracle Forms, Oracle Reports.
- Created/Maintained Business process Documents BP80,RD-20,BR-30,BR-100,MD-50,TE-40,CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions RICE and test scripts in AIM methodology as part of project implementation task.
Environment: Oracle apps Functional 11i to R12 upgrade Financials GL, AP, AR, FA, and CM
Confidential
Sr. Financials Functional
Responsibilities:
- Worked as a Financials Functional for implementation of EBS R12 was responsible for GL, AP, PO and AR implementation.
- Reviewed the Business Requirements Documents with the business and development teams and analyzed the functionality of the Oracle applications so as to finalize the solution.
- Identifying standard functionality, analyze gaps document and design solution for GL, AR depending on Business requirement.
- Participated in business planning and requirements review of Oracle Financials, Discrete Manufacturing, Order Management / Shipping, Advanced Supply Chain Planning, Customer Relationship Management, Logistics Management and Enterprise Asset Management solutions.
- Coordinated with project Manager, Business team for system updates and deadlines for the implementation.
- Solid project experience working with Oracle workflow, Oracle Forms, Oracle Reports.
- Setup union dues as deductions or adjust amount based on overages or shortages and have AP issue a check for the union monthly.
- Worked on revenue team and O2C Order to Cash team to Identify requirement and support implementation process and Document the functional requirement.
- Setting up Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, Defining Setup AR System option, payment term and Auto accounting.
- Create and setup customers and its profile class.
- Setting-up of AR for invoice transactions including auto invoicing from OM and Service Contracts, auto application of receipt application to invoices using auto lockbox functionality, sub ledger accounting
- Set-up receipt class, receipt methods, receivable activities and setting up accounting information for revenue recognition
- Configured CRP's, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
- Prepared Cut- over Plan, Listing down all Pre Post Go- live tasks with using Quality Center. Involved in Post-Production support
Environment: Oracle apps Functional 11i to R12 upgrade Financials GL, AP, AR, FA, and CM
Confidential
Sr. Financial Functional Analyst
Responsibilities:
- Worked as Functional Financials Analyst and provided R12 production support of financials modules GL, AP, AR, FA, CE and PO.
- Supporting day to day production issues, gathering requirements, configuring and testing system to meet the requirements. It includes documentation and user training on new processes.
- Resolved process issues, period end closing and interface issues in GL, AP, AR, FA, CE, PO modules.
- Worked on Procure to Pay P2P full life cycle on upgrade 11i to R12.
- Business process had been designed for interface issues in cash management and Receivables.
- Issue resolution, update functional impact analysis with proposed changes, if any in to issue tracker.
- Create and followed up SR's with Oracle Technical Support, coordinate and follow on multiple issues based on priority including identifying bugs and follow-up with Oracle Development
- Creating and Updating Functional Design Specification documents MD60/ MD65 based on BR100 on payroll
- Setup Payables options, financial options and Payables System options in AP, Set-up of System options in AR
- Defined Payment Terms, Accounting Rules, Accounting Periods, Invoice Sources, Bank Information, Receivables Quick Codes, Auto Invoice Grouping Rules, Transaction Types, Sales Tax Location Flex field.
- Used Accounting Rules to determine the number of periods and percentage of total revenue to be recognized Revenue Recognition in each accounting period payments to meet the requirements in AP
- Defined Profile Options to specify certain implementation parameters, Processing Options and System Options
- Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defining distribution sets
- Reviewed current business process and documented the business procedures for Procure to Pay and Project Invoicing to Cash Receipts.
- Configured CRP's, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration with using Quality Center.
- Created Business process documents BR-30, BR-100, MD-50, TE-40, CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions RICE and test scripts in AIM methodology as part of project implementation task.
- Provided period end closing process for Payables and General Ledger. Resolved period end closing issues.
- Coordinated with Oracle Support to resolve the issues through SR/TA
Environment: Oracle apps Functional R12 Financials GL, AP, AR, FA, CM,
Confidential
Financials Techno - Functional Consultant
Responsibilities:
- Worked as a Financials Functional Consultant for Oracle Financials system upgrade from release 11i to R12 and was responsible for GL, AP AR modules and from CRP1 Phase through to Go-Live.
- System setup audit has been done to ensure the system setups in R12 to meet the requirements in GL, AP, AR modules.
- New functionalities like Sub Ledger Accounting SAL and functionality changes in various modules are reviewed with CFO, Super users and Users of various Business areas.
- System has been tested to meet Procure to Pay with matching and payment batch process in payables system.
- Developed test cases on various functional scenarios and provided to users. User training has been provided on the new system.
- Carried out module configuration, solution design, process analysis, and implementation of Oracle Financials GL, AR and AP
- Created Business process documents BR-30, BR-100, MD-50, TE-40, CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions RICE and test scripts in AIM methodology as part of project implementation task.
- Business communications for the system updates and meeting the deadlines for the implementation
- Defined Payment Terms, Accounting Rules, Accounting Periods, Invoice Sources, Bank Information, Receivables Quick Codes, Auto Invoice Grouping Rules, Transaction Types, Sales Tax Location Flex field.
- Setups included Defined Invoice attributes- Payment Terms, Approve, Hold Release and Distribution Set, Special Calendar for Recurring Invoice, Payment Terms and Payable Quick Codes, Entering Supplier and Site Information, Payment Attributes-Payment Formats, Bank Account, Payable Documents, Tax Code, Rates, Groups and Withholding Tax, Open/Close of payable Accounting periods, and Payable Transfer to GL.
- Supported the implemented Receivable and Payables modules which involved daily issues and new customizations and enhancements based on the changing requirements
- Matched Vendor Invoices to Credit Memos from AP to AR to reduce vendor payments in AP and generated customer Invoices to vendors in AR to interface with get paid.
- Configured CRP's, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user Quality Center.
- Prepared Cut- over Plan, Listing down all Pre Post Go- live tasks. Involved in Post-Production support
- Coordinated with oracle support , created and followed up with service request
Environment: Oracle apps Functional 11i/R12 Financials GL, AP, AR, FA, and CM
Confidential
Oracle Financials Techno - Functional Consultant
Responsibilities:
- Reviewed the Business Requirements Documents with the Business and Development teams and analyzed the functionality of the Oracle applications so as to finalize the solution.
- Identifying standard functionality, analyze gaps document and design solution for GL and AP depending on business requirement
- 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 Configuration
- Configured Payables System options, financial options and payables options
- Defined Payment Terms and Distribution Sets ,Involved in the setup of auto invoice workflow
- Created Business process documents BR-30, BR-100, MD-50, TE-40, CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions RICE and test scripts in AIM methodology as part of project implementation task.
- Configured CRP's, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
- Worked with technical team for data conversion and custom object validation.
- Prepared Cut- over Plan, Listing down all Pre Post Go- live tasks. Involved in Post-Production support.
Environment: Oracle apps Functional 11i Financials GL, AP, AR, FA, CM
.