Johnson
Bolhayon

Approach

A stateless web toolkit: FastAPI backend and a React 18 / TypeScript / Vite frontend. Per-store credentials are pulled at runtime from AWS Parameter Store under a least-privilege IAM group, exports stream straight to the browser as CSV, and every run is audit-logged. Dev, staging and production environments run from Docker Compose behind nginx with Google SSO, plus a credential-free mock mode for local work.

Outcome

Versioned releases across three environments with real deploy discipline; the tool the later Next.js platform grew out of, and whose exports became the cell-for-cell reference for the automated replacements.

Approach

Wrote the team's single home for how internal tooling is built: an onboarding walkthrough, engineering conventions, a WSL2 / Windows dev setup, AI-agent (Claude Code) workflow rules, infrastructure patterns for Docker Compose, Cloud Run and secrets, copy-to-start project templates, and a read-only machine 'doctor' script that checks a workstation against the standard.

Outcome

A documented, repeatable path from a fresh laptop to a deployable tool - the engineering standards a solo builder leaves behind so the work outlives them.

Approach

Built the whole workflow in Google Apps Script on top of Sheets: product-list imports, SKU sales processing, a monthly posting workflow with data freezing so closed months cannot drift, register-to-outlet mapping, and journal exports ready for Xero.

Outcome

A month-end that runs as a sequence of clicks instead of a day of spreadsheet surgery - and the direct ancestor of the API-driven Sales Export and Xero COGS engines in the later platform.

Approach

Custom VBA macro tools automated the repetitive ETL steps, consolidated stakeholder reports, reconciled records and flagged errors from logic rules. Google Apps Script tools handled multi-sheet processing, pulled and pushed data through APIs, sent automated status emails and managed Drive files dynamically. Migration monitoring dashboards tracked readiness and progress per franchise.

Outcome

Rule-based validation and QA testing kept data accuracy and referential integrity across every migration, with progress visible to the business at a glance.

Approach

Built C# (LINQ) tools to automate complex transformations and standardise records from large datasets; wrote SQL against MySQL, SQL Server and Firebird to filter, clean and export exactly what the import needed; ran post-migration QA on record counts and format compliance, and worked directly with clients to define goals and manage the transition from legacy systems.

Outcome

Import-ready data on a repeatable pipeline instead of a per-client scramble, with QA evidence clients could sign off on.

Approach

Taught myself Excel VBA and built the team's automation: an automated QC tool with role-based templates, a consumer-health product tracker that removed manual duplication, and a patent-intelligence tool that consolidated 60+ global pharmaceutical datasets. Led the weekly and monthly production meetings and coordinated with global teams.

Outcome

Product migrations and imports preserved structure and classification integrity, and the tooling earned the IQVIA Impact Program Award for innovations improving data efficiency and quality control.