Marouan Ismaili

Marouan Ismaili

Business analyst _ Cost accounting

Followers of Marouan Ismaili2000 followers
location of Marouan IsmailiBouskoura, Casablanca-Settat, Morocco

Connect with Marouan Ismaili to Send Message

Connect

Connect with Marouan Ismaili to Send Message

Connect
  • Timeline

  • About me

    Data-Driven FP&A specialist | Power BI Developer | Transitioning to Data Science & AI

  • Education

    • École Supérieure de Commerce Et de Management - ESCEM

      2008 - 2010
      Master's degree Finance and controlling
  • Experience

    • Biougnach

      Sept 2010 - May 2014
      Business analyst _ Cost accounting

      • Budget/Forecast arrangements, Dashboards design and and variance analysis• Detailed sales analysis (Brand, supplier, category, department, product’s family, etc.).• Business reports /Monthly board meeting.• Implement new cost accounting system and monitor the company’s variable costs.• Profitability analysis of the different stores.

    • MARJANE HOLDING

      Jun 2014 - Jun 2020

      • Participate in the Monthly end-closing process with corporate accounting managers.• Create and distribute standard reports and KPI (Business activity, P&L, OPEX report, death stock …).• Ensure the “Budget planning calendar” (stores, warehouse, headquarters…).• Budgets/forecasts hypothesis consolidation; functional three years strategic business plan.• Recruit, organize, train and manage staff (newcomers_controllers).• Support stores controllers throughout the big events such as monthly closing, budgeting process and inventories.• Support IT managers in systems improvement. Show less

      • Group Reporting Controller (Headquarters)

        Feb 2018 - Jun 2020
      • Financial Controller (store)

        Jun 2014 - Jan 2018
    • SMT Africa

      Jun 2020 - now
      Country FP&A / Sr Controller (Morocco subsidiary)

      | BI duties |• Oversaw data collection and consolidation for reporting; Design and build dashboards used to monitor performance metrics• Developing Power BI reports from scratch / Ongoing projects: After sales Analytics – Machinery Analytics - CFO Dashboard• Supporting managers by providing various automatic tools for daily actions (using MS Excel : Powe query, Powe pivot and VBA)• HQ Business Intelligence team member (working as an internal consultant on improving several automatic reports)| Controlling duties |• Overseeing daily acounting transactions / Monthly end closing process• P&L and business review updates/analysis • Budgeting and forecasting (budgets and rolling forecasts)• Monthly meetings with managers and executives (Subsidiary and headquarters) Show less

  • Licenses & Certifications

    • Intermediate DAX & Time Intelligence

      Corporate Finance Institute
      Jan 2024
      View certificate certificate
    • Data Analysis in Excel

      Corporate Finance Institute
      Dec 2023
      View certificate certificate
    • Fundamentals of Data Analysis in Excel

      Corporate Finance Institute
      Dec 2023
      View certificate certificate
    • Power BI Fundamentals

      Corporate Finance Institute
      Dec 2023
      View certificate certificate
    • Power Pivot Fundamentals

      Corporate Finance Institute
      Dec 2023
      View certificate certificate
    • Power Query Fundamentals

      Corporate Finance Institute
      Dec 2023
      View certificate certificate
    • Excel Fundamentals – Formulas for Finance

      Corporate Finance Institute
      Nov 2023
      View certificate certificate
    • Statistics Fundamentals

      Corporate Finance Institute
      Nov 2023
      View certificate certificate
    • Verified International Academic Qualifications

      World Education Services
      Dec 2020
      View certificate certificate
    • The Assessment of Sustainability Knowledge Certificate

      Sulitest
      May 2023