Nahum Castro

Serves as technical project manager for data-integration processes, owning execution and design end to end. Built and iterated a road-surface discrepancy pipeline for Spain and designed grid-parallel delta-detection engines comparing HERE NavStreets against OSM and government sources.

Owns and operates an independent software consultancy delivering GIS, infrastructure, and security projects for institutional clients. Designed and deployed a production GeoServer/MapStore/PostgreSQL/PostGIS stack and delivered network-security assessments.

Designed and built a diagnostic-control system for tissue analysis and patient reporting using Java JSP/Servlets on Apache Tomcat, PostgreSQL, and SQL Server via ODBC. The system has operated for over 16 years with only 2 hours of downtime.

Analyzed ISP internet plans and pricing across the US and Canada using PostgreSQL and Google BigQuery. Implemented H3 hexagonal geospatial indexing and built PostgreSQL/PL-pgSQL pipelines for efficient storage and retrieval.

Reduced aggregation processing time from 4 hours to 12 seconds by redesigning the data pipeline with PL/pgSQL, PL/Python, Pandas, and SQLAlchemy. Designed and built the entire pipeline with automated data-quality tests and delivered aggregations in Tableau/PostgreSQL.

Led a six-person team to design and deliver a cadastral platform handling 600,000 cadastral accounts statewide. Applied TensorFlow to detect new construction from digital elevation models and drone imagery, and digitized legacy OCR-scanned cadastral records.

Developed a PostgreSQL/PostGIS platform for environmental-impact evaluation and soil-use/vegetation-change analysis, publishing JavaScript/PDF reports through GeoServer web services.

Built a web GIS platform publishing all municipal actions georeferenced with costs and contracts, using PHP and GeoServer (WMS/WFS transformed to GeoJSON) for dynamic map publishing.

Designed a PostGIS/PL-pgSQL geographic-analysis platform to plan housing settlements for residents without access to credit.

Built a renewable-energy potential viewer (solar, wind, wave/tide) for the Yucatán and Baja California peninsulas, combining PostGIS/PostgreSQL with Grass GIS raster/vector analysis and a Mapserver-based PHP front end.

Built and administered the Guanajuato State GIS, aggregating data across government dependencies; the platform earned the state's First Place Public Administration Award (2010). Trained government staff on deploying geographic web servers and distributing data through OGC web services.

Ran penetration and SQL-injection tests (NESSUS, Python) across Oracle, SQL Server, PHP, and .NET platforms; delivered an IT-infrastructure security report.

Implemented statistical quality control on Linux/mSQL and built CGI/Perl reporting tools for product-lot traceability.

Commissioned Perkin Elmer flame atomic absorption spectroscopy equipment for trace-metal water testing.

Developed silicon-polymer electrochemical synthesis electrodes and a MS-DOS/C serial-port data-acquisition sensor.

Completed Micro Data Management training with the World Bank in 2009.

Bachelor's Degree in Computer Systems Engineering from Universidad Iberoamericana, completed in 2004.

Completed Operating System Security: Windows and Linux training at Universidad Iberoamericana in 2003.

Bachelor's Degree in Chemistry from Universidad de Guanajuato, completed in 1996.

Completed Environmental Remediation Through Electrochemical Technology training at Universidad de Guanajuato in 1995.

Completed Basic Polymer Principles training at Universidad de Guanajuato in 1994.