Open to opportunities

Nicolas Garcia Rodriguez

@nicgarciarod

Message

Data analyst building dashboards, automating reports, and modeling experimental and operational data.

Colombia

Message

What I'm looking for

I’m looking for hybrid or on-site opportunities in Bogotá where I can build dashboards and automated reports, strengthen data quality and indicator definitions, and use Python/SQL/GIS to support decision-making with clear, trustworthy insights.

I’m a data analyst who builds dashboards, automates reporting, and models experimental and operational data across multidisciplinary settings. I focus on integrating multiple sources, enforcing data quality, and translating results into clear insights for both technical and non-technical audiences.

In recent roles, I consolidated 3,000+ production records into structured datasets to improve greenhouse crop performance reporting and enable yield and productivity trend analysis. I also supported indicator standardization and data-quality gap identification to lay the groundwork for anomaly detection in crop performance data.

Before that, I delivered full-territory GIS-based risk assessments by integrating 3 government data sources, extracting and cleaning 1,000+ records for traceability and indicator consistency. I built KPI dashboards for quality and post-harvest process metrics, and in laboratory work I processed 300+ chromatography-related readings—producing dashboards and analytical reports that supported quality control and results validation for research teams.

Experience

Work history, roles, and key accomplishments

Current

Professor

Current

Escuela Técnica Instituto Técnico Central (ETITC)

Aug 2025 - Present (10 months)

Improved greenhouse crop performance reporting for 2 crops by consolidating 3,000+ production records into structured datasets for yield and productivity trend analysis. Supported a 3-person academic team in standardizing indicator definitions and identifying data quality gaps to enable anomaly detection in crop performance data.

Data Consolidation Data Quality Trend Analysis Anomaly Detection Python SQL Power BI Statistical Analysis

Professor

Escuela Colombiana De Carreras Industriales (ECCI)

Apr 2025 - Jun 2025 (2 months)

Advised engineering students on data interpretation and process modeling, translating technical findings into clear reports for both technical and non-technical stakeholders.

Process Modeling Statistical Analysis Technical Communication Report Writing Data Visualization Python

Consultant & Quality Analyst

COODECAFEC

Sep 2024 - Dec 2024 (3 months)

Delivered a full-territory GIS-based crop production risk assessment covering 100% of the target region, finding over 60% of the area presented moderate-to-low risk to inform smallholder planning across Cundinamarca. Automated periodic risk and quality reporting by integrating 3 government datasets and building dashboards for quality and post-harvest process indicators.

GIS Based Risk Assessment ArcGIS QGIS Data Integration Data Cleaning Dashboarding Python SQL KPI Tracking

Laboratory Analyst

Universidad Nacional de Colombia (UNAL)

Jan 2023 - Sep 2024 (1 year 8 months)

Built 2 dashboards and 2 analytical reports consolidating physicochemical data to support quality control and results validation for a 4-person research team. Processed and standardized 300+ chromatography readings using data cleaning and transformation routines to ensure measurement traceability and reporting accuracy.

Data Cleaning data transformation Dashboarding Analytics Reporting Python Quality Control

Education

Degrees, certifications, and relevant coursework

Universidad Nacional de Colombia

Master in Biosystems Engineering, Biosystems Engineering

2023 - 2025

Master in Biosystems Engineering with a thesis on drying kinetics modeling, multi-source data integration (1,000+ records), GIS-based risk assessment, and statistical analysis of coffee quality indicators, resulting in a peer-reviewed article.