Principal Consultant
Oracle
Total years of experience :18 years, 6 Months
• Oracle Fusion Financials Implementation and training
• R12 implementation of Oracle Financial (General Ledger) and Project Costing, Billing & Management Modules
• Study of current business processes, future business flows and identification of gaps and workarounds in order to provide an integrated information system solution to meet the business needs of the company.
• Responsible of business requirements gathering and definition, gap analysis, processes mapping, systems and environment testing during the implementation of E-Business Suite on GL, AR, AP, FA, PA, AGIS modules.
• Configuration/Set Up of GL and PA
• CRP presentation before the End users of the client.
• System Review/Business Process Review
Work Detail:
•Assisting clients in preparation of financial statements which includes preparation of Balance sheet, Income Statement, Cash Flow and Schedule Notes according to IFRS/I-GAAP for various client using Oracle ERP system.
•Period closing (Month end closing & Yearly closing activities) for Accounts Receivable, Accounts Payables, Fixed Asset and General ledger for all locations of clients.
•Expense Budget and Revenue Budget Preparation with use of oracle Budget functionality and Financial Statement Generator
•Reconciliation of sub ledgers with General ledger of Legacy system and Oracle ERP. Assisted the functional User in doing the reconciliation activity for further periods.
•Financial Statement Generator (FSG) setup for Preparing Financial Statements (Balance Sheet, Income & Expenditure and Schedules to notes of accounts.
•Business Process Reviews (Procure to Pay, Order to Cash, Fixed Asset and General Ledger)
•Gathering and documenting information about the client’s business processes related risk, system and controls (both application and Information Technology General Controls).
•Assessing and advising the team on the impact of significant system changes on the risk identified
•Provide training to all Functional User as and when required of Financial Modules (Accounts Payable, Accounts Receivable, Fixed Assets and General Ledger).
•Prepared and provided user manual as and when required for users pertaining to Financial Modules (Accounts Payable, Accounts Receivable, Fixed Assets and General Ledger).
• Assisting clients in IFRS reporting compliance by enabling them to provide IFRS related reports in accordance with IFRS methodology.
• Responsible of business requirements gathering and definition, gap analysis, processes mapping, systems and environment testing during the implementation of Oracle ERP on GL, FA, PA, AGIS modules.
• Implementation of Oracle Financial (General Ledger) and Project Costing, Billing & Management Modules
Preparing financial statements which includes preparation of Balance sheet, Income
Statement, Cash Flow and Schedule Notes according to IFRS for client which is Private Equity Company.
•Verify inter-company balances; identify transactions, if causing any imbalances and then doing rectification.
•Extracting Data from ERP database and uploading the file in excel for preparation of financial statement
•Perform the entire key control activities, contact the respective user for data clarity.
•Send the journals for uploading in ERP database to Financial control team.
•Using the Chart of Account, compile the primary financials, notes to the accounts and other disclosure tabs
•Ensure reconciliation, validation and consistency of data across the report
•Update the report to the respective business owner for review.
•Extract Trial Balance from ERP System for respective consolidated partnerships.
•compile a consolidated
•Using the Chart of Account, compile the primary financials, notes to the accounts and other disclosure tabs
•Ensure reconciliation, validation and consistency of data across the report
•Update the report to the respective business owner for review.
To manage the Dealer audit & Dealer Accounts Reconciliation
•To plan the Dealer audit schedules`
•To manage the Dealer audit team
•To communicate & co-ordinate with the Dealer Principal, Dealer audit team
as regards the undertaking of Dealer audit
Execution
•To undertake the Dealer audits through/along with the Dealer Audit Team as per
plan
•To analyze the reports and sign off before submission to appropriate authority.
Reporting
•To develop & submit reports to Vice President through Audit Manager.
•To provide fortnightly MIS about the status of Dealer audits.
•To highlight exceptions & gross deviations/variations.