Financial Planning & Budgeting Specialist
Elan Qatar
مجموع سنوات الخبرة :20 years, 1 أشهر
* Managing Elan Group Budget and financial planning for all media sectors, entertainment, enterprise and event sectors, including the quarterly re-forecasts.
*Managing the treasury function of the group, including banking relations.
*Managing the group bank's facilities including Guarantees, Letters of credit, loans and Fixed deposited, and overseas accounts.
*Controlling the group expenses, as a preventive control to ensure group Expenditure remains inline with the budget.
• Handling internal and external reporting activates such as monthly, quarterly, and annual financial reporting packages including financial statements with its related analysis, disclosures.
• Responsible of the accounting and general ledger monthly activates up to finalize the monthly closing, includes validating and posting GL journal vouchers, and preparing the GL reports.
• Responsible of the monthly detailed balance sheet accounts analysis to explain and verify each account movements (Cause of change report).
• Member of Financial ERP implementation steering committee, with responsibility of migration and application implementation for all the financial data in all related accounting modules (Gl, AP, AR, Banking and the accuracy of the outcome reporting facility)…
• Play major role in the process of reviewing, enhancing and improving the current policies and procedures of the accounting and finance department to achieve efficiency of the day to day activates and to mitigate the estimated cycle and operation risk, internally and with other departments and outsiders.
• Liaise with internal/ external auditor queries, as well as frequent Egyptian government Central Auditing Organization compliance adherence requirements, as a control guard focal point of contact.
Handle full scope for the general Ledger section monthly activities up to finalization of monthly, quarterly and yearly end closing using Oracle (People soft) ERP financial application. This includes processing, reviewing, validating and posting GL journal vouchers, and preparing the GL reports.
Handle the operations/ business monthly accruals / amortizations and its related controls.
Prepare monthly detailed balance sheet accounts reconciliations to explain and verify each account movements (Cause of change report).
Manage the full project of implementation of Oracle (People soft) Assets Management module. This includes the preparation for the setup in the HQ in Vancouver, Canada to make sure that the implementation integrated with Methanex global standards, then the onsite testing (UAT) and the implementation on production environment on the ERP for Methanex Egypt Sep-Dec 2011.
Maintain and manage the fixed assets accounting activities post the FA project implementation (Including Monthly FA additions, disposals & Depreciation Movements), and its related reporting
Prepare the Monthly/Quarterly/Annual Financial Reporting package for the purpose of corporate & local financial management reporting.
Liaise with internal/ external auditor queries, as well as frequent SOX compliance adherence requirements, as a control guard focal point of contact.
Play major role in set up, testing and implementation processes and procedures of IBM Maximo (System used for procurements, inventory, assets management and financial)
Responsible for financial transactions interface from Maximo to Oracle PS for reporting and payment control purposes.
Prepare multiple adhoc reports as required by the management using different ERP modules (GL, AR, AP, FA, and reporting) to support the demanding reporting scheme from the local office to the HQ in Vancouver, Canada.
Supervise GSM Roaming settlements, accounting, and financial clearing activities for OMAN MOBILE.
Assist in setting up, testing and implementing Oracle AR/AP Module (for GSM Roaming financial Clearing), and related reconciliation to insure proper data migration from Sun Microsystems (running system) to Oracle Aug-Dec2008.
Handled monthly accruals/ actual netting off of debtors and creditors based on the estimated/ actual data received from Emirates Data Clearing House (EDCH) which represents the monthly traffic minutes and the other types of GSM data transactions between Oman mobile and all other worldwide mobile operators.
Report the monthly movement of the roaming expense and revenue accounts based on EDCH data vs. Oman mobile billing system, and take the necessary actions to clear the disputes (if any).
Apply netting off process of accounting operations to debtors and creditors balances to execute the payments and validate the AR balance.
Post the journal vouchers for the monthly actual payments and receipts for the debtors and creditors.
Ensure the accuracy of financial data flow between the AR and treasury sections by preparing the monthly bank reconciliations for the accounts related to GSM roaming activity and reporting, and monitoring the foreign currencies exchange gain or loss. Run the monthly payment transactions and report the related outcome results to the treasury department.
Liaise with the internal and external auditors to provide AR related financial reports on timely basis maintaining high satisfactory level of achievement. Major reports provided such as debtors and creditors ageing analysis, detailed analysis of income and expense by operator in compliance with IFRS.
Assist and guide Omantel AR team in handling the local subscriber’s revenue, local data clearance, managing the receivables factoring to present AR required reporting.
Generate detailed revenue journal vouchers and Update Great Plains accounting systems and its related subsidiary ledgers on a daily basis.
Prepare commissions calculations for company’s sales staff as well as different types of dealers on monthly basis.
Prepare analysis for various revenue streams, including home viewing subscriptions, hotels, muds, and hardware revenue.
Prepare monthly sales report and its related reconciliation with the booked revenue per segment.
Validate and reconcile cash on hand / banks / credit cards accounts balances with regard to home viewing subscriptions and hardware sales revenue.
Prepare monthly business review for all segments of the business, including net sales, churn, net growth and profitability per department and outlet.
Generating periodical receivables trial balance for all dealers and employees ensuring that it reconciles to GL control account.
Other Duties & Responsibilities (out of job description scope)
General Ledger related tasks
Preparing / posting journal entries and handling all book keeping tasks and requirements for financial transactions on ERP system (MS Great Plains Dynamics).
Preparing and controlling accruals as well as its analysis and payment control.
Managing the inter-company accounts and preparing necessary reconciliations with the head office.
Preparation of the monthly payroll and related issues, i.e. payroll tax, social insurance, etc.
Prepare the monthly payroll journal on a monthly basis and posting to the GL, and preparing related analysis to satisfy head office queries.
Managing departmental overheads and explaining variances against budgets (cause of variance reports)
Accounts Payable related tasks
To fill in for the role AP function upon requirements tasks include the following:
Manage activities and transactions with company vendors and suppliers to ensure timely recognition and reporting of company liabilities.
Ensure that adequate controls techniques are in place and acted upon to mitigate risks associated to the AP cycle (procure to pay).
Assist purchase department to establish an efficient and effective procurement cycle that addresses company and third parties needs and requirements.
Ensure that AP sub-ledger Great Plains system is updated on a timely basis with transactions relating to vendors and suppliers reflecting genuine transactions.
Preparation of settlements schedules to vendors and suppliers according to approved contractual agreements and payments terms ensuring that payments are made on due dates balancing out the company cash flow.
Generating periodical AP trial balance for all vendors and suppliers ensuring that it reconciles to GL control account.
Monthly Preparation of bank reconciliations to ensure that balances per ledgers are in agreement with banks.
Prepare fixed assets journals to update fixed assets register with all additions and disposals as well as for related fixed assets depreciation.
Prepare the monthly payroll sheets and the related calculations for income tax deductions and their filing with the authorities.
Prepare daily sales report for performance tracking.
Follow up on the receivables settlements according to collection due dates.
Prepare the payment vouchers and related journals allocations to the appropriate cost centers.
Prepare and monitor raw material consumption and prices Variation reports vs. standard and previous periods.
Prepare withholding tax return quarterly.
Participate in the preparation of the annual tax return for the corporate income tax.
BSC in commerce – Accounting, Faculty of Commerce, Menofia University.