Intern · Agrinorthwest · Jun 2024 - Aug 2024

Built an ETL Pipeline and No-Training UI for Crop Managers

Context

The business needed one reliable view of irrigation and operations data across multiple systems.

Challenge

Data lived in three databases, and current tools were too technical for non-technical users.

Actions

I engineered an ETL pipeline using 20 SQL queries and 500+ lines of Python, then helped design an HTML/CSS interface focused on quick, intuitive decision support.

Outcome

Crop managers gained real-time visibility into irrigation metrics without added training burden.

Metrics: 100,000+ acres supported; 30 crop managers served; 20 hours/week saved company-wide.

Reflection

← Back to all stories