# John Dill — dill.dev

> John Dill is a solutions engineer and technical consultant based in Santa Cruz, California. He helps teams simplify workflows, connect business tools, and build reliable systems around their needs.

John brings more than two decades of experience in enterprise technology and technical operations. His consulting work combines systems integration, workflow improvement, custom development, and practical automation. He starts with the people, processes, inputs, and constraints, then chooses established tools and newer technology where they fit the problem. AI is one tool in that work.

The portfolio describes completed production work for live business operations. The resume provides career history, LinkedIn provides a professional profile, and the contact page is the route for consulting inquiries.

## Profile and contact

- [Portfolio](https://dill.dev/): John Dill's introduction, selected production work, consulting approach, and availability.
- [Resume (PDF)](https://dill.dev/John-Dill-Resume.pdf): Career history and professional experience.
- [LinkedIn](https://www.linkedin.com/in/johndill/): John Dill's professional profile.
- [Contact](https://dill.dev/contact/): Discuss systems integration, workflow improvement, or an automation project.
- [Approach](https://dill.dev/#approach): Understand the workflow, simplify and connect tools, then refine the solution through testing, feedback, training, and handoff.

## Selected production work

- [Archive access and recovery](https://dill.dev/#archive): Built automation to bring material from thousands of optical and hard disks into a searchable Google Workspace resource with previews and access tailored to the team; approximately 9.3 million archive files made searchable.
- [Print subscription billing](https://dill.dev/#subscriptions): Filled a gap in Recharge's support for the publisher's print-issue billing model. Custom automation alongside Recharge used purchase history and release cadence to prevent repeat charges for purchased issues and coordinate renewals and notifications across approximately 5,500 subscriptions.
- [Editorial alt-text workflow](https://dill.dev/#accessibility): Combined AI image analysis, article context, and editorial guidance to suggest alt text for more than 16,000 images. Built review and publication into the team's Google Sheets and WordPress tools.
- [Assignment and statement-of-work drafts](https://dill.dev/#assignments): Built a Google Docs tool that turned scattered email, chat, and other source text into structured drafts and flagged missing details. Estimated preparation time saved: approximately 30 minutes per draft.
- [Google Workspace permissions review](https://dill.dev/#access): Built a purpose-built Python script using the Drive API to scan shared-drive file and folder permissions across 5.8 million files. Traced inherited and overly broad access to its source, presented findings in Sheets, and applied owner-approved changes.
- [Email Service Provider transition](https://dill.dev/#email): Led the move from Campaign Monitor to Mailchimp while newsletters continued. Used gradual sender warm-up, mapped platform metadata, and preserved opt-in preferences for a publisher with approximately 500,000 subscriber records.
- [Shared contact intake](https://dill.dev/#contacts): Built an Apps Script tool suited to daily networking and the team's budget. OCR and AI field extraction turned card photos, screenshots, and typed or dictated notes into reviewable contacts with supporting context, at substantially lower operating cost than the services considered.

## Optional

- [Community work](https://dill.dev/#community): Webmaster for Santa Cruz County CERT, including a reviewed and staged website-update workflow; Disaster Service Worker and Santa Cruz County ARES participant supporting preparedness, public service, and radio communications.