Andrea Roetti

Andrea Roetti

Business Intelligence Consultant

Followers of Andrea Roetti636 followers
location of Andrea RoettiLuxembourg

Connect with Andrea Roetti to Send Message

Connect

Connect with Andrea Roetti to Send Message

Connect
  • Timeline

  • About me

    Manager | Reins. Data & Analysis | Generali Future Owner | CFA level III candidate

  • Education

    • MIB School of Management

      2016 - 2017
      Master in Insurance & Risk Management Insurance Graduation with Honours

      The XVII edition has been ranked #9 worldwide - Eduniversal Best Master Ranking 2016 (Insurance area)ASFOR (Italy) and EPAS (by EFMD, Brussels) accreditationsFinal thesis with title: "Evolving Pricing Sophistication in P&C retail".

    • Università degli Studi di Torino

      2011 - 2014
      Master's degree Mathematics 110/110 cum laude

      Master's degree with specialisation in geometry and final thesis with title: "Il funzionale di Willmore" ("The Willmore's functional").

    • Università degli Studi di Torino

      2008 - 2011
      Bachelor's degree Mathematics 110/110 cum laude

      Final thesis with title "Trasformazioni di Moebius" ("Moebius' transformations").

  • Experience

    • SYSTEM EVOLUTION

      Oct 2014 - Jan 2016
      Business Intelligence Consultant

      Implementation of ETL processes to extract, transform and load data, by the use of IBM suite InfoSphere DataStage. Maintenance of DataStage applications and softwares, use of SQL and Unix languages.Main client served has been Intesa SanPaolo Bank, guaranteeing at least once every two weeks of presence at client's office and, in turn within the team, 24h availability for the maintenance of specific applications, running daily/weekly/monthly.

    • Generali

      Oct 2016 - Sept 2017
      Group Strategic Planning, Control & Integrated Reporting Intern.

      Followed the yearly development of group monthly and quarterly financials reporting processes to the top management, including the top-down targets setting and the bottom-up results reporting.Monitored Technical Excellence initiatives results.

    • Generali Employee Benefits - GEB

      Jan 2018 - now

      Increased responsibilities in supporting the head of department in organizing, leading and supervising the activities of the team. Renaming of the department that moves under CFO area. Increased responsibilities in conducting analysis and presenting results to upper management and providing guidance and technical trainings to other departments or newcomers. Responsible for direct report of high sums insured to the Group Head Office. Followed the company transfer to the new Assicurazioni Generali S.p.A. - Luxembourg Branch. In addition to the portfolios analysis activity, the data gathering process management, after the merge with Data Management department. Control and validation of reinsurance data flows from 15+ GEB's Network Partners located in 10+ countries. Analysis and monitoring of local partners’ portfolio performances and trends, validation of consolidated statements by country portfolio, reports production for internal or external use, technical support to other departments in particular planning & control, finance & accounting and client services.

      • Reinsurance Data Management & Analysis Manager

        Apr 2023 - now
      • Reinsurance Data Management & Analysis Specialist

        Dec 2022 - Apr 2023
      • Data & Portfolio Management Specialist

        Mar 2021 - Dec 2022
      • Data & Portfolio Management Analyst

        Sept 2019 - Mar 2021
      • Data & Portfolio Management Analyst

        Jul 2018 - Aug 2019
      • Portfolio Management Analyst

        Jan 2018 - Jun 2018
  • Licenses & Certifications

    • Google Project Management: Professional Certificate

      Google Career Certificates
      Jul 2022
      View certificate certificate
    • Data Science Professional Certificate

      HarvardX - An Online Learning Initiative by Harvard University through edX
      Jul 2020
      View certificate certificate
    • Academy of Cheese Level Two - Member

      Academy of Cheese
      Oct 2023
    • McKinsey Forward Program

      McKinsey & Company
      Dec 2024
      View certificate certificate
    • Generali Future Owners Leadership Training

      INSEAD Executive Education
      Sept 2021
      View certificate certificate
    • Passed Level III of the CFA Program

      CFA Institute
      Oct 2025
    • WSET Level 3 Award in Wines - Passed with merit

      Wine & Spirit Education Trust
      Aug 2024
    • Diploma Cortador Profesional de Jamón

      EICJ - Escuela Internacional de Cortadores de Jamón
      Sept 2025
  • Volunteer Experience

    • Volunteer

      Issued by Paris 2024 - Comité d'organisation des Jeux Olympiques et Paralympiques de 2024 on Jul 2024
      Paris 2024 - Comité d'organisation des Jeux Olympiques et Paralympiques de 2024Associated with Andrea Roetti
    • Sustain & Grow project

      Issued by The Human Safety Net on May 2021
      The Human Safety NetAssociated with Andrea Roetti
    • Mathematics Tutoring

      Issued by Associazione Subalpina Mathesis on Dec 2009
      Associazione Subalpina MathesisAssociated with Andrea Roetti