— Automated the creation of arbitrary combinations of country boundaries into regions (at any admin level, maintaining topology) — Designed editorial flow and built a spatial data QA pipeline for both raster and vector data — Ad-hoc dataset processing scripts; customer data extracts and deliverables

- Review and build data pipeline architecture with different types of spatial and non-spatial data (BigQuery, PostgreSQL, Python)

- Serverless development to track 3rd party SLA (puppeteer.js) - Azure to GCP migration, Pulumi / Terraform, dbt, BigQuery, DOMO, GitHub Actions CI/CD, Docker

- User data architect: led planning for how to organize and secure user data (PostGIS, PostgreSQL schema design) - Created GeoJSON datasets and MBTiles tilesets for interactive web and mobile apps - Frontend development (Mapbox, CSS, ES6 JavaScript, Parcel, TypeScript)

- Led product development for a web-based travel planning app - Developed GIS data pipelines (PyQGIS, Python, R, SQL, API, NodeJS, React, Git) - Learned how to define customer expectations as agile product requirements

- Trained 7 employees in a Tier 2 technical IT support environment - Led the migration from Windows 7 to Windows 10 - Resolved hardware and software issues in 300+ Windows and Mac OS computers

- Renegotiated publishing service contract and reduced annual cost by 43% - On-boarding, training, and flight approval for 300 volunteers (Mail merge, AHK) - Gained fluency in reading / writing Tagalog and other Filipino dialects

- Determined best-value IT solutions to improve business performance - Implemented policies for GDPR and PCI-DSS compliance - Automated repetitive business tasks with scripting languages like Bash and R

- Published the first online digital collection of the library with 87 years of records - Assisted in managing 100+ workstations with Active Directory for 4,000+ users