FP&A ANALYST
Chalhoub Group
مجموع سنوات الخبرة :22 years, 11 أشهر
Review financial statement and analyze sales revenues, costs and expenses for all business units. Develop detailed spreadsheets to identify trends and develop forecasts. Consolidate and analyze monthly results and budgets. Create and deliver presentations, dashboard, providing recommendations on short and long-range Cash Generation.
• Prepare and analyze budgets, plans and budget revisions working closely with the operational teams of the business units, challenging their assumptions and proposing revisions.
• Oversee the P&L and balance sheets, analyze and recommend on monthly figures from business units compared to budget and last year.
• Engage with the Cash forecasting team to assist with reporting and analyzing cash risk on a monthly basis to management and flag high-risk situations or trends.
• Define, design, and develop interactive dashboards and other automated reporting in Power BI/MS Excel.
• Provide detailed IRR/payback studies in the group format to justify capital expenditure, including all relevant analysis.
• Involved in creating different reports based on the business request and ad hoc requirements using Power BI desktop.
• Create Dashboards and visualization of different types for analysis, monitoring, management and better understanding of the business performance metrics
• Automate process to improve rigor and speed in the processing of critical information
• Lead ERP, Hyperion implementation. Develop the Variance report in Power BI which reduce the closing days by 50%
• Perform ad hoc analysis and special project as required
Review financial statement and analyze sales revenues, costs and expenses for all business units. Develop detailed spreadsheets to identify trends and develop forecasts. Preparing Budget and forecast to management and other stakeholders. Consolidate and analyze monthly results and budgets. Create and deliver presentations, dashboard, providing recommendations on short and long-range ROI. Prepare the Monthly Cashflow statement (both direct and indirect method)
• Monitored and analyzed key performance indicators (KPI) and financial ratio.
• Develop and manage complex excel and Power BI based financial models.
• Negotiated 20% reduction in yearly property and medical insurance premiums
• Reduced payment collection time from 85 to 70 days by introducing a collection budget
• Automate the process to improve rigor and speed in the processing of critical information
• Introduced automated annual budget forecasting and created an automated payment tracker for 30 shops
• Analyzed company’s financing needs and worked with management to raise working capital
Prepare and deliver timely and accurate monthly, quarterly and yearly financial statements monthly cash management reports, projected cash flows, account reconciliations and various detailed analysis reports as required by the senior management. Maintain the financial system ensuring that all posting is correctly reconciled and authorized. Work closely with the external auditors, provide all requested details and review their reports.
• Brought financial bookkeeping up to date through an intensive three-month process
• Analyzed the company’s financial needs and worked with management to raise the capital
• Reduced payment collection time, printing costs, and distribution costs
• Introduced cash flow forecasting to identify potential shortfalls and take corrective measures
• Preparing the financial report, including the report on relevant accounting standards disclosures and risk factors and cost assets management
• Preparing the end of month accounts, including Balance sheet and bank reconciliations, maintenance of fixed assets ledgers, cash flow statements and analysis of profit and loss statements.
• Prepared wage and salary payments, including annual leave, air tickets, and end of service benefits
• Prepare the ad hoc report for A/R reconciliation to develop the action plan for resolution.
• Ensure payable accounts information is properly recorded and appropriately authorized
• Research and resolve all payment problems
• Prepared Landing Cost Sheet for each purchase
• Prepared, examined, and analyzed accounting records, financial statements, and other financial reports to assess accuracy, completeness, and conformance to reporting and procedural standards
• Conducted quarterly, yearly, and periodic surprise inventory checks
• Analyzed monthly accounting statements, balance sheets and income statements prepared by accounting staff.
• Reviewed, approved and maintained journal entries, ledger schedules and balance sheets.
• Interacted with various departments to solve accounting issues and discrepancies.
• Prepared import-export documents including export benefit certificates (DEPB) and certificates of origin
• Prepared and submitted the Sales Tax & Excise returns and managed all import and export documentation
• Supervised and evaluated team members and took corrective action when appropriate
• Reviewed and analyzed general ledger accounts for interim and year-end closing
• Created, entered and posted adjusting, standard and recurring journal entries.
• Computed taxes owed and prepared tax returns, ensuring compliance with payment, reporting and other tax requirements.
• Analyzed manufacturing costs and wrote reports comparing standard and actual production costs
• Wrote reports comparing product prices and profitability
• Handled company petty cash, posting entries and supporting Senior accountant to close the book
Completed the 9 paper