Talk to sales Try for Free
Francesco Mitolo

Francesco Mitolo

Technical expert in urban planning

Followers of Francesco Mitolo4000 followers
location of Francesco MitoloVigo, Galicia, Spain

Connect with Francesco Mitolo to Send Message

Connect

Connect with Francesco Mitolo to Send Message

Connect

  • Timeline

  • About me

    Urban planner + Data analyst

  • Education

    • IT Academy de Barcelona Activa

      2019 - 2019
      Course Business Intelligence: data processing and visualization (220 hours)

      Methodologies for BI projectsSQL databases: Data modeling, DSL-DML-DDL-TCL-DCL operations, Users, Triggers, Events, Stored procedures with MySQL WorkbenchETL: Data transformation, Process automation, API, Web scrapping, Bots, Encryption, Multidimensional analysis with OLAP cubes with Pentaho Spoon, Workbench and ServerVisualization: Report design and dashboard with Microsoft Power BIIntroduction to KNIME Analytics Platform and Weka

    • Universidade da Coruña

      2017 - 2017
      Erasmus+ SMS Architecture and Building engineering

    • Universidade da Coruña

      2015 - 2015
      Erasmus+ SMS Architecture

    • Universidad Politécnica de Madrid

      2023 - 2023
      Course Modelling and analysis of urban-territorial networks

      Modules: Creation and definition of networks, Coverage areas, Calculation of optimal routes, Calculation of accessibility and proximity to facilities, Optimal location of services, Analysis of configurational accessibility with Space Syntax - UCL Depthmap X, Introduction to Model Builder, Accessibility indicators and urban and territorial applications, Estimation and allocation of flow along networks, Introduction to working with non-conventional data sources and Big Data, Spatial statistics.

    • Universitat de Barcelona

      2018 - 2019
      Master's degree Advanced urban studies

      Master's thesis in Consumption and urban commerce"Retailess urban commerce in the framework of last mile logistics, commons and housing"Modules: Urban studies, Political economy of city and housing problem, City and gender, Consumption and urban commerce, Urban planning and management, Research techniques and fieldwork

    • Politecnico di Bari

      2011 - 2018
      Master's degree Architectural Engineering 110/110

      Degree thesis in Tecnica Urbanistica I + Laboratorio, ICAR/20"From sustainable mobility to urban regeneration: theories, methodologies, scenarios. A project for Loseto"

  • Experience

    • BCNecologia

      Jun 2018 - Jul 2019
      Technical expert in urban planning

      · Parametric planning algorithms development· GIS - Grasshopper compatibility development· Urbanism indicators analysis and processing· Study of theoretical framework and urban management models (5G City Barcelona, Lugo)· Sustainable urban planning (Superblocks Barcellona, A Coruña, Buenos Aires, Vancouver)

    • Urbanistan

      Mar 2020 - now
      Digital content creator

      · Video, blog posts and articles writing on urban planning· Creation of digital content (videos and images) for social networks

    • Evotic

      Mar 2020 - Apr 2020
      Data analyst

      · Cleaning and verification of data integrity· SQL database modeling and management· ETL processes (API and jobs)· Creation of dashboards for sales and marketing analysis

    • Vectio | traffic & transport planning

      Oct 2020 - Mar 2023
      Urban planner and data analyst

      · Traffic, demand and service level reports· Development of dashboards with mobility data· Mapping and visualisation of urban data

    • Datfor

      Mar 2023 - Oct 2023
      Urban planner and data analyst

      · Big Query and PostGis database maintenance, consultation and development· Normalisation and processing of urban data· ETL process editing· Creation of visualisations and dashboard in Tableau and Looker Studio· Creation of urban data mapping with GIS tools· Support to mobility projects for data improvement and optimisation· Analysis of the application of new data sources (telephony and GPS) and new technologies to solve mobility problems.

    • Premier Tax Procedure

      Nov 2023 - now
      Urban planner and data analyst

  • Licenses & Certifications

    • Español B2.1

      University of A Coruna
      Feb 2017

    • English B1

      Politecnico di Bari
      Feb 2012

  • Honors & Awards

    • Awarded to Francesco Mitolo
      Bari IV Municipio patrimonio, paesaggio, spazio pubblico Urban Center Bari Oct 2018 Mostra di tesi di laurea organizzata in attuazione del Protocollo d’Intesa tra il Comune di Bari, Assessorato all’Urbanistica e politiche del territorio e il Dipartimento di Scienze dell’Ingegneria Civile e dell’Architettura del Politecnico di Bari, sottoscritto nel settembre 2017 e finalizzato alla costruzione di quadri di conoscenze e scenari, sperimentazioni progettuali e strategie di rigenerazione urbana e paesaggistica per i quartieri e i Municipi del Comune di Bari, a partire dal caso del… Show more Mostra di tesi di laurea organizzata in attuazione del Protocollo d’Intesa tra il Comune di Bari, Assessorato all’Urbanistica e politiche del territorio e il Dipartimento di Scienze dell’Ingegneria Civile e dell’Architettura del Politecnico di Bari, sottoscritto nel settembre 2017 e finalizzato alla costruzione di quadri di conoscenze e scenari, sperimentazioni progettuali e strategie di rigenerazione urbana e paesaggistica per i quartieri e i Municipi del Comune di Bari, a partire dal caso del IV Municipio. Show less