Preston Duffield

Developer • Automations • Data • Clean code meets creative chaos.

View my work Get in touch

Selected Work

Bookings Dashboard

Power BI dashboard for bookings, cost, and profit with dynamic slicers and visuals.

BI
Data
SQL
Power BI

Case study coming soon

Dynamics GP SQL views and Power BI models

Dynamics GP SQL Suite

Reusable SQL views for AP/AR/Sales and PBI models with incremental refresh.

Data
SQL
BI

Overview

Webflow + RSS

Automated podcast RSS pipeline with validations and deploy hooks to Webflow.

Webflow
Automation
DevOps

n8n Multi-Agent Flows

Composable agents for HR knowledge retrieval, Teams notifications, and compliance.

Automation
AI
Integrations

Learn more

Lemon Gain — VST3 Audio Plugins

Lemon Gain, a lightweight VST3 gain plugin built with C++ and CMake for Lemon Live Studios.

C++
CMake
Object Oriented

Hear about it

Secure container CI/CD pipeline in GitLab

CI/CD Pipeline for Secure Container Deployment

A GitLab CI/CD pipeline that automatically scans Docker images for vulnerabilities before deployment.

DevOps
Automation
Security

Deep dive

About

I build practical systems with a polish: web apps, data pipelines, and automation that ship and scale. I like pairing strict structure with bursts of creative energy—think tidy architecture splashed with a bit of Jackson Pollock.

Full‑stack development (JS/TS, Python)
Data & BI (SQL, Power BI)
Automation (n8n, APIs, Webhooks)
Cloud (AWS, GCP)