At New York City Office of Technology and Innovation, I build ETL pipelines that ingest, validate, and transform data from multiple sources. Automating this work cut manual processing time by 15% and improved data accuracy.
I developed a pipeline that extracts semi-structured data from PDF forms into normalized SQL tables, feeding Power BI dashboards tracking 200+ legal requests monthly. I also implemented validation and error-handling workflows that reduced manual data-entry errors by 50%.
I work with stakeholders across 100+ NYC agencies to translate operational workflows into requirements, optimize SQL reporting queries, and present outcomes to senior leadership, including the CTO.
In my data projects, I built a Python ETL pipeline for NYC 311 data, transforming 500K+ records in BigQuery and creating Tableau dashboards. I also operate a self-hosted platform with containerized services, scheduled backups, and Node.js bots that integrate REST APIs.
