Ferran Ferrer Marco

Ferran Ferrer Marco

Fellowship

Followers of Ferran Ferrer Marco249 followers
location of Ferran Ferrer MarcoPuebla de Farnals, Valencian Community, Spain

Connect with Ferran Ferrer Marco to Send Message

Connect

Connect with Ferran Ferrer Marco to Send Message

Connect
  • Timeline

  • About me

    Gis and Data Analyst, Database Manager Land Surveyor & Soil Mapping.

  • Education

    • Universidad Politécnica de Valencia (España)

      2013 - 2013
      Bases de datos espaciales: PostGIS 2 Geomatics Apto

      Activities and Societies: http://cartosig.upv.es/cursos/ Características:- Modalidad: online- Comienzo: 3 de febrero- Duración: 87,5 horas en 12 semanas.- Material docente: 13 módulos docentes con más de 120 prácticas y 350 pág. de apuntes teórico-prácticos, 8 horas de videos.- Certificación: Certificado oficial de aprovechamiento de la Universidad Politécnica de Valencia (UPV)- Profesorado: Profesorado Titular de la UPV, autor del libro "PostGIS 2. Análisis Espacial Avanzado"

    • Universidad de Valencia

      1994 - 1999
      Licentiate degree Biología/Ciencias biológicas, general 8
    • Universidad de Valencia

      1994 - 1999
      Licentiate degree Biology, General

      Activities and Societies: Baloncesto

    • Universitat de Girona

      2003 - 2006
      Máster Sistema de Información Geográfica
  • Experience

    • University of Valencia

      Jan 2001 - Dec 2002
      Fellowship

      Working in the preparation of EuroStarrs 2001 campaign, part of the SMOS (Soil Moisture and Sea Salinity) ESA's mission. Main task:Desgin and develop a ground sampling schema for Soil Moisture and Vegetation water content for ground validation of airborne L-band passive radiometer measures.Coordination of measurement campaign.Analysis and presentation of results.Related publications:http://www.esa.int/Our_Activities/Observing_the_Earth/The_Living_Planet_Programme/Earth_Explorers/SMOS/STARRS_flying_over_Europehttps://www.researchgate.net/publication/234376543_EuroSTARRS_ground_sampling_design_at_the_Nezer_Site_Agre_forest_and_Valencia_Sitehttps://www.researchgate.net/publication/234183527_Spatial_distribution_of_soil_moisture_content_and_its_relationship_to_other_surface_parameters_at_the_Valecia_site Show less

    • Consultor Freelance para TEMA3

      Jun 2005 - Dec 2011
      Soil Evaluation for TEMA3

      I have been working as a freelance consultant conducting Soil Evaluation studies for land-use planning plans at different levels, Whole Asturias Coast landscape, Asturias Central Area and some mountain counties from 2005 to 2011. the aim is to detect Prime Farmland areas in order to protect agricultural development from urban and infraestructural development. He realizado varios trabajos de consultoría para TEMA3.Centrados en la evaluación del territorio Asturiano para soportar diferentes usos. La evaluación de la capacidad agrológica del territorio ha permitido a Emilio Rico y Ramón Rañada de TEMA3 la realización de planes de ordenación del territorio asturiano a diferentes escalas, desde el plan del litoral, concejus a grandes zonas.Mi aporte ha sido la detección de aquellas zonas que tienen gran potencialidad agrológica en vistas de preservar estas de otros usos. Show less

    • Freelance

      Jan 2006 - now
      Consultant Freelance in Gis Analysis and Soil Mapping and Evaluation.

      I have been working as a freelance also to spanish clients and International Clients -USA, Canada, UK, Saudi Arabia, Australia,..- trough freelance web platforms. GISPGis Analysis.Spatial Market Analysis.Soil MapperWebGisTécnico en Cartografía y Evaluación de Suelos.Sistemas de Evaluación Geográfica.Análisis de Suelos.Ordenación del Territorio.

    • CIDE

      Apr 2006 - Apr 2008
      Técnico en Investigación en Suelos

      Desarrollo de Cartografía de Suelos.Evaluación de Procesos de Degradación de Suelos con Sistemas de Información Geográfica.

    • Iproma s.l.

      Jan 2008 - Jan 2009
      Técnico SIG y Medioambiente

      Técnico mediambiental especialista en GIS.Consultoría en suelos contaminados.Realización de asesorías GIS.Gestión de información GIS.Diseño y Gestión de BBDD.Participación en diferentes asesorias técnicas cómo técnico.

    • Vértex Consultoría Agroforestal S.L.

      Apr 2008 - May 2009
      Jefe de Campo Cartografía de Suelos

      Jefe de equipo de campo a cargo de 4 personas y gabinete para realización del Mapa de suelos 1:25.000 Ribera d'Ebre, Tarragona.

    • Ayuntamiento de Santander. New Technologies Department

      May 2008 - Mar 2009
      Consultor técnico

      Estudio del Suelos en el Medio Físico del 'Plan Director de la Peninsula de la Magdalena'

    • Inteligencia del agua

      Oct 2011 - Mar 2012
      Técnico analista agua

      Soporte tecnico

    • Upwork

      Apr 2012 - now
      Freelance Gis Analyst and Cartogarpher in Upwork

      Gis AnalystCartographerDatabase Manager

    • IIC Technologies

      Sept 2013 - Mar 2014
      Field Surveyor in IIC Technologies in the Ordnance's Survey GCIP project.

      I am with IIC TECHNOLOGIES in the Ordnance's Survey GCIP (Geographical Certification Improvment Program) project.

    • Https://www.itx.com

      Sept 2015 - May 2016
      Creation of Indoor Mall maps for a mall mobile navigation app.

      -Mapbox map development for indoor navigation. For web and mobile apps.-Creation of Indoor Mall maps for a mall mobile navigation app.http://www.rochestermalls.com/

    • Vsminvestments

      Nov 2015 - Apr 2016
      Gis Analyst and Developer in rentsurveyor.ca site development

      Gis Analyst and Developer in rentsurveyor.ca site development.Under development.Obtain Canada Census Demographics and construct a PostgreSQL database to represent demographic data into a a Real State portal.To get Canadian Census buerau statistics for demographics and integrate into a spatial database for use of demographics app engine.-Data gathering and technical consultancy in geospatial platform development.http://rentsurveyor.ca/

    • UC Merced

      Nov 2015 - May 2016
      External Consultant

      Provide Gis Building and Advisory capacities.DIGITIZED HISTORICAL MAP OFELECTRICITY NETWORKS AND REBUILD MAPS FOR EARLIERDATES.Digitazitation of old scanned maps.Direct contract with University of California at Merced with Miguel Morin -http://www.columbia.edu/~mm3509/research.html-, Rowena Gray - http://rowenagray.weebly.com/- & Paul Gaggl - https://belkcollegeofbusiness.uncc.edu/pgaggl/- . Providing gis services to digitize old USA official cartography as map scans for Electrical Transmission Lines and Power Plants from 1900 through 1950 from different sources, NELA,EEI, Walrath. Related papers:http://economics.ucdavis.edu/events/papers/121Morin.pdf Show less

    • UNICEF

      Jun 2016 - Mar 2017
      Gis and DataBase Designer for Consultant WASH Data Analyst

      I was assisting in the production of a methodology for estimating open defecation rates and population effected numbers in the States and Provinces of South Asia (Afghanistan, Bangladesh, India, Nepal and Pakistan).Extracted data on open defecation prevalence and analysed trends for the South Asia region, based on 80 surveys (DHS, MICS, CENSUS) for the period 1990 to 2016. Produced 40 snapshot reports containing choropleth maps, trend lines, and projections of population contributing to open defecation at region, country and state / province level. I conducted GIS data extraction and matching with existing national surveys and designed, produced and managed an online database based on PostgreSQL-Postgis to feed online Tableau Dashboard for data analysis and showcase. Show less

    • Theraphy box

      Sept 2016 - Apr 2017
      External consultancy in Gis Analysis, Database design and implementation.

      -Disaster Risk Analysis System (DRAS) is a product of United Nations Development Programme (UNDP)https://www.therapy-box.co.uk/drasapp url:https://dras.undp.ba/Where I reproduce existing flood and Landslide spatial explicit risk assessment done in arcgis into postgresql-sql environment. Main tasks were:-Converted data to common geographical format -wgs84- and rater to vector format.-Design sql spatial queries to reproduce arcgis model builder processes for flood and landslide processes.-Design and create a database to store data and processes.-Design queries to be used from php into web app.-Assess project manager in best processes-Asses app coders with best methods for spatial queries. Show less

    • UNESCO World Water Assessment Programme Secretariat

      May 2017 - Nov 2017
      GIS and Database Adminsitrator

      Assisted in the compilation of a database of cluster level data from national surveys, containing: 41 variables; 75,000 locations; from 130 sources; across 57 countries. Produced cluster level maps to pinpoint areas where progress on water and sanitation is slower, which gave more actionable information for targeting support than from area-wide statistics. Interpreted cluster maps to highlight linkages between peoples access to clean water and sanitation and catchment scale dimensions of water resources management. Applied statistical analysis to quantify the relative effectiveness of different interventions (WASH, Vaccines, Women’s Education, Housing) on U5YO children’s health, especially stunting. Show less

    • UTE PGO Oviedo

      Jan 2018 - now
      Land Evaluation

      I'm conducting a Land Capability Evaluation of Oviedo's municipality for the revision of city's urban planning documents.Works includes the creation of a detailed soil map of the municipality and the evaluation of land and soil for different potential uses.Information will be used during planning process to mantain highly potential agricultural sites from urban sprawl.

    • United Nations UN - WATER

      Apr 2018 - Feb 2020
      Contributor to'Suistanable Development Goal 6. Synthesis Report on Water and Sanitation. 2018. UN,NY

      Contributor with Kimberley Patrick as principal scientific and with Marvirender Rawat as gis analyst of global socioeconomic data for Shynthesis Report.Conducted Water and Sanitation sdg goals indicators gathering and analysis for display in world maps.

    • Hyqlab

      May 2018 - now
      Information Communication Technology Consultant

      Cómo parte del Equipo de HYAlab he particpado en el proyecto para la Oficina regional de Sud Asia de UNICEF que consiste en la generación de una aplicación web con cartografía para la monitorización de la situación de los sectores de Salud, Higiene y Sanitización de toda el área.El trabajo ha consistido en la generación de una base de datos que contiene todas la geografías de laregión hasta el nivel de subdistrito y la conexión con las estadísticas que provienen de los censos nacionales y de otras organizaciones cómo USAID y UNICEF. Show less

    • UNICEF

      Aug 2018 - Mar 2019
      GIS WASH Data Analyst

      Assisted as Gis and database designer and manager to build a comprehensive database of sub-national WASH (Water, Sanitation & Hygiene) related statistics for South Asia region. Successfully merged sub-national WASH data from more than 90 household survey sources (MICS, DHS, Census, LSS) for the period 2000 to 2019 into a set of individual District Level Snap Shots in support of UNICEF reporting on the elimination of Open Defecation and Sanitation Improvement in South Asia.Generated an Online Database based on PostgreSQL-Postgis that stored multi-administrative geographies and matched with raw survey data and produced internal database procedures to calculate SDG 6 WASH indicators. Show less

    • Action Against Hunger | ACF-USA

      Feb 2020 - May 2021
      Gis Consultor in 'Groundwater Monitoring Scoping & Feasibility Study in North East Nigeria' for AAH

      Groundwater Monitoring Scoping & Feasibility Study in North East Nigeria.-North East Nigeria Borno and Yobe State situation is the long recovery of a humanitarian crisis of refugees. International ngo work is extensive and there is no full control of territory yet.-Our duty is to help Action Against Hunger efforts inside the NE Nigeria Wash sector to establish an effective Groundwater Monitor System that includes ngo constructed and rehabilitated boreholes for IDP camps water supply and be part of a more complete system for the Nigerian administration.-We are studying existing historic data form boreholes and geological maps with also international remote sensing works to help determine where is the need to install monitoring wells. Show less

    • Goldfish Ads

      Jun 2020 - now
      Data Specialist

      I provide Goldfish Ads service of transforming American Census bureau, Canada statistics and UK Office for National Statistics between others providers data into a database workable version that will be used for Sales marketing using Machine Learning techniques.

  • Licenses & Certifications

    • EdX Certificat Verificat per Estructuras de Datos con Python

      University of Michigan - School of Information
      Oct 2020
      View certificate certificate
    • Using Python to Access Web Data

      University of Michigan - School of Information
      Nov 2020
      View certificate certificate
    • Capstone: Retrieving, Processing, and Visualizing Data with Python

      University of Michigan - School of Information
      Nov 2020
      View certificate certificate
    • Using Databases with Python

      University of Michigan - School of Information
      Nov 2020
      View certificate certificate
    • Programming for Everybody (Getting Started with Python)

      University of Michigan - School of Information
      Oct 2020
      View certificate certificate
  • Volunteer Experience

    • Monitor

      Issued by Meliana Basket Club on Sept 1990
      Meliana Basket ClubAssociated with Ferran Ferrer Marco