Sr. Oracle Business Analyst Resume
Boston, MA
PROFESSIONAL SUMMARY:
- Fusion Financials Functional Lead with 15+ years of Consulting and Implementation Experience
- Led multiple Oracle Implementation, Multi Country Roll Outs and Upgrade Assignments
- Experience advising clients and designing solutions for multiple business process areas and Integrating Legacy Applications to Oracle Fusion / EBS, viz Oracle General Ledger, Accounts Payable, Payments, Accounts Receivable, Cash Management, Sub ledger Accounting, iExpense, Fixed Assets and OPM Financials
- Well verse with Oracle Fusion Financials Month End Process, Multi - Ledger, Multi-Currency, Global Financial Consolidation, Revaluation - Translation process, Reconciliation, Inbound and Outbound Extracts to FDW, HFM, AGIS, Revenue Recognition Principles
- Oracle Certified Implementation Expert - Accounts Payable
- Possess excellent Functional skills, Finance Business Process Knowledge having managed teams of various sizes based out of different geographical locations.
- Intermediate knowledge of PL/SQL and well versed with IT Productivity tools including Config Snapshot, HPQC, MS Visio, Data Loader, UPK, MS Office Suite
EXPERIENCE:
Confidential, Boston, MA
Sr. Oracle Business Analyst
Responsibilities:
- Sr. Oracle Business Analyst for Charles River Acquisition Integration Assignment
- Responsible for Chart of Accounts Mapping between Charles River entities and Confidential Corporation
- Led the Subledger Designing of AP, AR, I Expense, CM, Tax Process
- Led the month end process, account consolidation in Confidential Books, Reconciliation and Reporting
- Responsible for Subledger Conversion (Vendors, FA, Bank Account, ASC 606, ASC 842, ORMB, Avalara Tax Solution, E-Business Tax)
Confidential, Marlborough, MA
Sr. Oracle Financials Business Analyst
Responsibilities:
- Implementing Lease Management Solution for Confidential US Stores
- Responsible for Interfaces between Confidential (Real Estate Management provider) and Oracle
- Part of their global R12 Oracle Financials upgrade program, R12.2.6
- Deployed the changes on Lease Accounting including ASC 842 and IFRS 16
- Worked closely with business users for workshop, to gather and document requirements, perform fit/gap analysis, solution and application set-ups/configuration
- Led and drove the testing cycles (i.e. CRP, UAT & Cutover activities)
Confidential, Boston, MA
Sr. Oracle Finance Consultant
Responsibilities:
- Sr. Oracle Finance Consultant for R12 Oracle Reimplementation Assignment
- Responsible for General Ledger, Accounts Payables, Payments Solution Design and Development
- Led design process for a Custom GL and Sub-ledger Journals Approval Workflow, and controls related to Future Dated Posting (SEC Requirement for Banking companies)
- Handled validation of Inbound Interfaces to GL, and Outbound Extracts to HFM, FDW Tools and building controls related to Variances and Reconciliation
- Liaise with key business stakeholders, including MD Finance, VP Finance & IT, Global Process owners for 30+ Countries spanning APAC (Phase 1), NA (US & Canada in Phase 2) and EMEA (Phase 3) Geo’s
- Extensive use of R12 Finance Functionalities (Journal Approval, Intercompany Accounting, Document Sequencing) for 140+ GL Ledgers (PL, Reporting and Secondary) and 275+ Legal Entities/Establishment
- Led development related to Custom Document Sequencing for Italy Legal Requirement
- Analysis on Localization related to COA Maintenance in Brazil
- Provided active support to business users during UAT cycles, ensuring quick turnaround on queries/defects raised by business
Confidential, Boston
Sr. Oracle Finance Consultant
Responsibilities:
- Sr. Oracle Finance Consultant for R12 Oracle Reimplementation Assignment
- Responsible for General Ledger, Accounts Payables, Payments Solution Design and Development
- Led design process for a Custom GL and Sub-ledger Journals Approval Workflow, and controls related to Future Dated Posting (SEC Requirement for Banking companies)
- Handled validation of Inbound Interfaces to GL, and Outbound Extracts to HFM, FDW Tools and building controls related to Variances and Reconciliation
Confidential
Sr. Fusion Financials Consultant
Responsibilities:
- Functional Consultant for Implementing Fusion financial modules using rapid implementation approach.
- Requirement Gathering, Design, Proof of Concepts and Solutions
- Data Conversion for Sub-Ledger and GL
- Configuring Common Financials, AP, AR, GL & CE, IDM user roles matrix, developing test scripts, handling CRP1 and UAT
- Implementation of OCR, Cross Validation Rules, Fixed Assets Tax books and Approvals setup across Requisitions, PO, AP, Payments & GL
- Specific solution for retail car Sales industry such as trade in’s, Loan sales etc.,
- Handling external integrations for Banks for Payment Manager and Positive pay
- Revenue recognition Rules and custom solution for Loans and warranty, Designing smart view queries
- Post Production support and issue resolutions
Confidential
Fusion Financials Consultant
Responsibilities:
- Account Lead for Ongoing support and Enhancements
- Automation Bank Reconciliation process for Payables, Receivables and External Transactions
- Development of Smart View reports for Financial reporting pack
- Review and validation of custom OTBI reports developed by technical team
- Managing user role matrix with R12 upgrade changes and fixing upgrade issues
Confidential, Boston, MA
Solution Architect
Responsibilities:
- Solution Architect for a Chart of Accountants Conversion Assignment for a Confidential Giant based in Massachusetts USA
- Responsible for Analysis and Development of all Objects impacted by Conversion
- Involved in Segment Mapping from Source to Target COA Flex field and execution process
- Got Trained on Confidential Tool for the Conversion Activity
Confidential, Oklahoma
Oracle Financials Functional Consultant
Responsibilities:
- Led a Team on an Oracle Financials Upgrade Assignment for an Oil and energy giant based out of Oklahoma
- As a Lead Consultant Responsible for Oracle AP, Payments, AR, and Cash Management Upgrade Solution.
- Led the Org Merge Analysis and Solution Development on AP, I Expense, AR, CM
- Responsible for Financial Month End Process and Financial Reporting
- Successfully reduced the cycle time of Financial Month end process and attained milestones within the aggressive timeline
Confidential
Oracle Financials Functional Consultant
Responsibilities:
- Implemented R12 Accounts Payables, Sub ledger Accounting, OPM Financials
- As a Lead Consultant Designed Morrison’s P2P Process flows for three manufacturing sites
- Responsible for scoping, mobilization, initiation and definition of the Overall Payment Solution
- Successfully reduced the cycle time of Financial Month end process and attained milestones within the aggressive timeline
- Designing Interface solution between Legacy System and Oracle EBS suite for AP and Supplier
- Involved in preparation of Data Migration specs which describes Data Rationalization requirements and migration of data from source to target system for entities Customers, Suppliers , Banks, Bank accounts , Open purchase orders, Inventory Items.
- Responsible for Testing of Solution, to Business Users on BPC, IR, PORC, RTV & Payables Transactions
Confidential
Oracle Financial Functional Consultant
Responsibilities:
- Implemented GL, Payables, Purchasing, Costing, Oracle Lease Management
- Created Process definition document for Maaden Phosphate Payables and Costing Process
- Conducted Requirement Gathering, CRP Sessions, User, UAT & Set Up in PROD
- Restructuring of Chart of Accounts, User on GL Functionality (Mass Allocation),
- Handling complicated issues during cutover migration of P2P cycle, COA etc.
- Prepared setup docs and test scripts (TE-40) for Accounts Payables, General Ledger, and Costing Process
- Maintenance of BR100, SDD, RDD, MD-50 etc. documents
Confidential
Oracle Financials & OPM Functional Consultant
Responsibilities:
- Implemented Oracle integration with Delta V at Hamina Site; Finland
- Handled Roll out activities on all OPM Modules for Site Dynea Poland
- Handling functional issues on Oracle Financials & OPM Modules as part of Roll out for sites Norway, Poland & Belgium
Confidential
Financial and Costing Functional Consultant
Responsibilities:
- Implementation of Payables, OPM Financials
- Responsible for Setup, designing, loading of data of OPM Modules
- Responsible for Integration of Oracle data with their legacy system
- Building Interface between OGAS System (Oil & gas accounting system) and Oracle