Juan Daniel Gaitán Flórez

Juan Daniel Gaitán Flórez

About

Detail

GIS & Spatial Data Analyst | Cadastral and Geodetic Engineer
Bogotá, D.C., Colombia

Contact Juan regarding: 
work
Full-time jobs
Starting at COP4.5M/month ~USD1.18k/month
groups
Networking

Timeline


work
Job

Résumé


Jobs verified_user 0% verified
  • C
    Database Manager
    Cityland Analytics S.A.S
    Jul 2024 - Aug 2025 (1 year 2 months)
    • Provided support services for cadastral updating in the municipality of Floridablanca through the administration and optimization of spatial databases implemented in PostgreSQL/PostGIS under the LADM-COL 1.2 model. • Developed advanced SQL queries for validation, cleansing, and analysis of cadastral information, ensuring data quality and accuracy. • Integrated geospatial information from QField and GIS tools for proper structuring and storage. • Performed database performance analysis and optimization to improve processing speed and system scalability. Additionally, utilized Microsoft Access to manage and preprocess tabular data before migration to PostgreSQL, ensuring data integrity and consistency. Achievements: ✔ Optimized database
  • Departamento Administrativo Nacional de Estadística
    Junior Professional
    Departamento Administrativo Nacional de Estadística
    May 2024 - Dec 2024 (8 months)
    • Provided professional services for testing, socialization, support, and monitoring of data collection instruments that integrate the geographic component, location module, and address normalizer for mobile devices and web questionnaires. • Ensured proper use of geographic tools for the Economic Census, while utilizing Microsoft Access to manage and analyze statistical and survey data. Created queries and reports to facilitate data validation and transformation, ensuring accurate integration into broader databases for national statistical analysis.
  • C
    GIS Specialist
    Cityland Analytics S.A.S
    Mar 2024 - Jun 2024 (4 months)
    • Validated and verified compliance with technical standards and parameters to ensure the quality of cartographic and digital products resulting from cadastral processes with a multipurpose approach. • Conducted cartographic editing using QGIS for updating and correcting geospatial information, ensuring cadastral data accuracy and consistency. Additionally, utilized Microsoft Access to manage and preprocess tabular data prior to migration to PostgreSQL, which enhanced data integrity and consistency throughout the project lifecycle.
  • Unidad Administrativa Especial de Catastro Distrital
    Senior GIS Professional
    Unidad Administrativa Especial de Catastro Distrital
    Jan 2024 - Feb 2024 (2 months)
    • Provided support for cadastral management, including cartographic and alphanumeric editing for cadastral updating and maintenance processes. • Utilized Microsoft Access to consolidate and manage tabular data prior to migration to GIS environments, creating queries and workflows that facilitated efficient data integration. • Developed ETL workflows to extract, transform, and load data from various sources, including spatial databases, CSV files, and shapefiles into PostgreSQL/PostGIS, employing Python and GeoPandas for automation. • Designed and optimized SQL queries and implemented stored procedures to enhance the cadastral depuration process, ensuring data accuracy and reliability.
  • C
    GIS Specialist
    Cityland Analytics S.A.S
    Mar 2023 - Dec 2023 (10 months)
    • Supported and managed the spatial database for cadastral maintenance processes with a multipurpose approach in the municipality of Soacha, Cundinamarca. • Implemented the LADM-COL model, ensuring compliance with necessary standards for proper cadastral information management.
  • C
    Cadastral Data Structuring and Processing Manager
    Cityland Analytics S.A.S
    Oct 2022 - Feb 2023 (5 months)
    • Supported and managed the spatial database for cadastral updating processes in various urban and rural areas of 14 municipalities in Cundinamarca. • Implemented the LADM-COL model to ensure compliance with necessary cadastral data management standards. • Applied data analysis techniques and integrated multiple information sources to obtain a comprehensive and detailed view of the territories involved. ✔ Generated and validated the database, ensuring data structure and quality in terms of completeness, thematic accuracy, and positional accuracy. Designed a model to and semi-automatically the topology geometries.
  • C
    Technical Digitizer
    Cityland Analytics S.A.S
    Mar 2022 - Oct 2022 (8 months)
    • Digitized information for cadastral updating processes with a multipurpose approach in urban and rural areas of municipalities such as Chaguaní, Nimaima, Quebradanegra, Nocaima, Sutatausa, Supatá, Vergara, Tausa, Villeta, Guaduas, Villa de San Diego de Ubaté, and the urban areas of Nemocón, Arbeláez, and Fómeque. • Implemented the LADM-COL model while ensuring compliance with necessary standards.
  • T
    Field GIS Professional
    Telespazio Argentina SA
    Dec 2021 - Apr 2022 (5 months)
    • Implemented the Cadastral Information System according to the Land Administration and Multipurpose Cadastral Information Management System (LADM-COL). • Entered and updated cadastral information collected in the field using direct, indirect, and collaborative methods, following IGAC technical regulations. • Ensured the integrity and management of the cadastral project information.
  • A
    GIS Assistant
    Aviatek SAS
    Oct 2021 - Dec 2021 (3 months)
    • Incorporated and updated property information in the cadastral updating process. • Conducted quality control and ensured the availability of geographic and cadastral data, as well as documents and other physical and legal components.
  • c
    Intern
    corporación autónoma regional
    Apr 2021 - Oct 2021 (7 months)
    • Supported the development of cartographic outputs for the social component and user census in the formulation of Water Resource Management Plans (PORH) in prioritized territories within CAR jurisdiction. Consolidated census data for municipalities PORH
Education verified_user 0% verified
  • Esri Colombia
    Online Course: "GIS for Humanitarian Mine Action: Data Types and Data Exploration"
    Esri Colombia
  • S
    "The Current State of Mapping APIs and Graphic Editing for Publication"
    SELPER
  • C
    International Seminar: "Evolution of Multipurpose Cadastre for Sustainable Development in Latin America"
    Colombian Association of Cadastral and Geodetic Engineers (ACIG)
  • Esri Colombia
    "Spatial Data Analysis with Insights for ArcGIS"
    Esri Colombia
  • UNIVERSIDAD DISTRITAL FRANCISCO JOSÉ DE CALDAS
    Cadastral and Geodetic Engineer
    UNIVERSIDAD DISTRITAL FRANCISCO JOSÉ DE CALDAS