John Dill

Solutions engineer & technical consultant

Santa Cruz, California

John Dill

I solve business problems with practical engineering.

I work with teams to simplify workflows, connect business tools, and build solutions around their needs.

Recent production work at a glance

Selected production work

Subscription operations

~5,500 subscriptions

Custom print-issue billing alongside Recharge

Recharge didn’t support the publisher’s print-issue billing model. I built custom automation alongside it that used purchase history and release cadence to prevent repeat charges for issues already purchased and coordinate renewals and customer notifications.

I built the bulk-update tools with Python, Shopify GraphQL, and Recharge REST APIs, and trained staff for the handoff.

Python · Shopify · Recharge

Editorial tools & accessibility

16,000+ images

Alt text informed by the image and its article

I combined AI image analysis with article context and editorial guidance to suggest alt text. Editors reviewed, revised, and published descriptions through a workflow I built into their existing Google Sheets and WordPress tools.

The workflow identified missing or unusable alt text and supported review against the publisher’s content policy and accessibility requirements.

AI image analysis · Google Sheets · WordPress

Assignment & SOW preparation

~30 min saved per use

Estimated preparation time saved

Scattered assignment details into a draft in Docs

I built a Google Docs tool that turned scattered email, chat, and other source text into structured assignment and statement-of-work drafts. It flagged missing details for staff to resolve without leaving their document workflow.

Editorial staff used the tool regularly to prepare and review drafts.

Google Docs · Structured extraction · Human review

Workspace access review

5.8M files scanned by my permissions script

Inherited access made clear to business owners

I built a permissions-review script that traced stale external access and overly broad sharing to their source. I presented the findings in Google Sheets so business owners could decide what to retain or remove.

The purpose-built Python script used the Drive API to scan all shared-drive file and folder permissions. I applied owner-approved changes while preserving required access.

Python · Google Drive API · Access controls

Email platform transition

~500K subscriber records

Publisher’s subscriber population

Email migration while newsletters continued

I led the Email Service Provider move from Campaign Monitor to Mailchimp, using a gradual sender warm-up to protect sender trust while newsletters continued. I mapped differing platform metadata and preserved subscribers’ opt-in preferences through the live transition.

I mapped newsletter preferences and engagement groups, coordinated authentication and delivery monitoring with platform specialists, and migrated signup forms with custom signup automation.

Data migration · Deliverability · Signup workflows

Contact intake

Photos & notesReviewable records

A shared networking tool that fit the team and budget

Daily networking mattered, but existing services didn’t fit the team’s workflow or budget. I built a shared contact-intake tool tailored to their needs at substantially lower operating cost.

The Apps Script app combined OCR and AI field extraction to turn card photos, screenshots, and typed or dictated notes into standardized contacts with supporting context. Staff could review and correct each record.

OCR · Apps Script · Iterative development

Understand the system. Improve the work.

I look at the whole workflow: what comes in, what needs to happen, who makes decisions, and what a useful result looks like.

01 / Understand

Find the source of the friction

Work with people to understand current processes, constraints, and unmet needs.

02 / Build

Simplify, connect, automate

Combine existing tools, integration, and custom development, keeping human judgment where it matters.

03 / Verify

Make it hold up in practice

Refine a proof of concept through feedback and testing. Account for incomplete inputs, exceptions, and failures, then support adoption with documentation, training, and handoff.

More than two decades in enterprise technology and technical operations inform my work. Consulting has expanded my responsibility for business decisions, implementation, training, and ongoing support. I choose services and models around the task, cost, data sensitivity, and available infrastructure, including self-hosted models when third-party processing is inappropriate.

Community work

Preparedness & communications

Santa Cruz County CERT

Webmaster

I maintain the website and training calendar. My AI-assisted workflow takes update requests from email, checks published content through WordPress GraphQL, and prepares a change plan for my review. Changes go to staging for stakeholder approval before publication. I work with program administrators to use the automation I designed for them.

Santa Cruz County ARES

Disaster Service Worker & radio communications

As a Disaster Service Worker and member of the Amateur Radio Emergency Service, I participate in training nets, field exercises, and communications support for emergency preparedness, public service events, and community activities, including message handling and coordination.

Have a workflow that could work better?

I’m available for consulting in systems integration, workflow improvement, and AI automation. Let’s talk about your process, constraints, and what you want to accomplish.

Discuss a project