Lead GIS & Earth Observation Engineer | Project Manager | GeoAI, Remote Sensing & Environmental EIA Specialist
Lead GIS & Earth Observation Engineer at Bochica-GPT & Geospatial Environmental Consulting
Instituto Geográfico Agustín Codazzi (IGAC) · contract
Jul 2025 – Dec 2025 · 5 mos · Bogotá D.C., Colombia (National Scope)
• Directed the consolidation, topological verification, and official publishing of national soil cartographic layers for the Subdirectorate of Agrology. • Engineered automated quality-control Python scripts and ArcGIS Pro ModelBuilder pipelines, reducing manual review times by 40%. • Developed custom ArcTools for standardized ICDE metadata cataloging, geodatabase versioning, and seamless integration into the Institutional Geographic System (SGI). • Applied spatial statistics and probabilistic modeling to enhance thematic cartographic accuracy across agricultural soil classes, water bodies, and artificialized surfaces.
Bochica-GPT (Territorial AI & Autonomous Environmental Systems) · freelance
Jan 2025 – Present · 1 yr 9 mos · Remote
• Architected autonomous GeoAI pipelines combining PostgreSQL 16/PostGIS, pgvector, and OWL2-DL/SHACL ontologies for automated environmental compliance analysis. • Built multimodal RAG pipelines for processing environmental impact studies, satellite imagery (Sentinel-1 SAR / Sentinel-2), and national investment project banks (BPIN/MGA). • Designed automated microservices in Python and Rust for ultra-fast spatial indexing and semantic document retrieval.
IDEAM (Institute of Hydrology, Meteorology and Environmental Studies) · contract
Sep 2023 – Dec 2023 · 3 mos · Bogotá D.C., Colombia
• Developed an interactive, real-time analytics dashboard (Power BI) and database backend (PostgreSQL, DuckDB, SQLite) for the National Forecast and Alert Office (OSPA). • Built an automated AI-assisted alert generation agent processing preliminary daily hydrometeorological time-series from the national station network using R and Python. • Standardized statistical analysis workflows in RStudio and Python to detect hydrometeorological anomalies and accelerate emergency alert publishing.
Suelos & Riego Consultoría S.A.S. · contract
Jul 2022 – Sep 2026 · 4 yrs 2 mos · Colombia (National Scope)
• Formulated and audited Environmental Impact Assessments (EIA), Environmental Management Plans (PMA), and Environmental Diagnosis of Alternatives (DAA) for Tier-1 energy concessions (María Conchita, Llanos 111, Fandango, Estero A/B, Espiguero, Corocora, Tren del Pacífico). • Rigorously enforced ANLA geodatabase standards (Resolutions 2182/2016 and 2026 guidelines) and Corine Land Cover (CLC) methodology. • Deployed QField on rugged mobile tablets for offline real-time geodatabase editing in field campaigns, cutting office post-processing times by 50% and securing strict data custody. • Implemented AI-driven segmentation with the Segment Anything Model (SAM) in QGIS and ArcGIS Pro for automated raster/shapefile classification across biotic, abiotic, and social layers. • Coordinated territorial field work integrating indigenous community perspectives (Wayúu in La Guajira, Sáliba and Achagua in the Eastern Plains).
Banco Agrario de Colombia & Job and Talent · contract
Apr 2022 – Dec 2022 · 8 mos · Bogotá D.C., Colombia (National Scope)
• Audited and scored nationwide agricultural and agro-industrial credit investment reports under FINAGRO and ICA regulatory standards. • Modeled spatial credit risk factors using GIS and SQL databases, evaluating agrometeorological variables, flood/drought exposure, harvest schedules, and livestock inventories. • Developed automated Excel/VBA and Python analytics templates that streamlined investment control processing times by 5% across nationwide operations.
Unión Temporal Almacenamiento 2021 · contract
Jan 2022 – May 2022 · 4 mos · Cundinamarca, Colombia
• Directed engineering inspection and construction of 60 Australian-type water storage tanks and soil stabilization bioengineering works. • Conducted farm-level geospatial viability surveys and participatory social cartography across 60 beneficiary agricultural properties. • Designed localized pressurized irrigation networks, hydraulic pressure distributions, and material specifications optimizing on-farm water efficiency.
ALTTEC S.A.S. · contract
Aug 2018 – Aug 2023 · 5 yrs · Cundinamarca, Colombia
• Directed end-to-end rural infrastructure and agricultural development contracts (48 months total) funded by regional environmental authorities (CAR, FONDECUN, ASOHOFRUCOL). • Supervised construction and civil engineering of water harvesting reservoirs, Australian-type tanks, and intrapredial pressurized drip/sprinkler irrigation networks. • Executed social cartography and participatory GIS assessments across peasant farming units in 15 municipalities of Cundinamarca. • Managed project budgets, construction logistics, and multi-disciplinary field crews (technicians, operators, and survey teams) using MS Project and CAD/GIS integration.
Technical and spatial quality assurance of Geodatabases under ANLA Resolution 2182/2016 for major energy and infrastructure projects (Canal del Dique Sacyr/ANI, Hocol, Parex). Processing of Sentinel-1 SAR and Sentinel-2 optical imagery for multitemporal Corine Land Cover (CLC) mapping.
Predictive modeling of aboveground biomass and carbon sequestration for Payment for Environmental Services (PES) and ecological restoration across Caquetá and Huila, Colombia. Implemented using Google Earth Engine, Random Forest regression, and Sentinel-1/2 time series.
Autonomous territorial AI architecture integrating PostgreSQL 16/PostGIS, OWL2-DL/SHACL ontologies, and multimodal RAG for environmental licensing compliance, public investment banks (BPIN/MGA), and predictive project monitoring.
Corporación Unificada Nacional de Educación Superior (CUN) · Project Management, Agile Frameworks (Scrum), Predictive Analytics, PMBOK 7th Ed., and Artificial Intelligence
Feb 2025 – Dec 2026
Universidad Internacional de Valencia (VIU) · Data Science, Machine Learning, Big Data Architectures, Advanced Statistical Modeling and Cloud Analytics
Jan 2022 – Dec 2026
ADAHCOL S.A.S. (Academia de Aviones y Helicópteros de Colombia) · Aerial Photogrammetry, UAS Flight Mission Planning, GSD Calculation, Ground Control Points (GCPs), and Aerocivil Aviation Regulations
Jan 2026 – Mar 2026
Universidad Nacional de Colombia (Sede Bogotá) · Water Resources, Geomatics, Remote Sensing, Land Reclamation, Agricultural Drainage, and Rural Civil Structures
Feb 2012 – Sep 2017
National Administrative Department of Statistics (DANE) · 2024-11-20
View CredentialInter-American Development Bank (IDB) · 2024-11-15
View CredentialFood and Agriculture Organization of the United Nations (FAO) · 2024-11-10
View CredentialMicrosoft & Intelligent Training · 2024-11-06
View CredentialInstituto Geográfico Agustín Codazzi (IGAC) · 2024-09-15
View CredentialJohn Deere (Casa Toro) · 2021-07-10
View CredentialIngeniero Agrícola Matriculado (25241-325257 CND) · Miembro Profesional Certificado
Investigador / Candidato a Magíster · Comunidad Académica y Científica
JUAN CAMILO ORDOÑEZ BETANCOURTHhasn't published any blog posts yet.