Colton Sam Fong
AI & automation to replace manual work and scale operations
New to Contra
Colton is ready for their next project!
Patient File Cleanup & Data Standardization Automation
Problem
During the closure of a surgical office, thousands of patient files were inconsistently named, unsorted, and difficult to reconcile. Manually cleaning and organizing the records would have required weeks of staff time and introduced risk to record integrity and compliance during the shutdown process.
Solution
I built a Python-based automation script that analyzed existing file structures, recognized inconsistent naming patterns using regex, and reorganized the files into a standardized, patient-specific structure. The system reduced an estimated 2–3 week manual cleanup process to 2–3 days while preserving record integrity and enabling compliant post-closure access to patient records.
0
18
Outreach Efficiency Data Automation (Healthcare)
Problem-
A clinic needed to evaluate the effectiveness of its patient outreach program by comparing participants against the full list of clinic patients. The underlying data lived in poorly structured Google Sheets with inconsistent name formatting, making reliable comparison and reporting difficult and error-prone.
Solution-
I developed an automated comparison system using Google Apps Script that ingested multiple sheets, normalized inconsistent naming conventions, and identified both exact and close matches between outreach participants and clinic patients. As the sole developer, I delivered a reliable data-cleaning and reporting workflow that enabled accurate measurement of program effectiveness and supported the continuation of outreach funding.
0
19
Problem
Surgical Office Internal Scheduling & Operations System
Problem -
A surgical office relied on fragmented tools and manual processes for intake, scheduling, task coordination, and internal operations, creating inefficiencies and operational risk.
Solution -
Over an extended engagement, I designed and built a suite of internal web tools to handle patient intake, scheduling, task automation, secure backend logic, and operational dashboards. The system centralized day-to-day workflows and replaced manual processes with reliable internal software tailored to how the office actually operated.
0
26
Construction AI Platform
Problem-
Construction teams were manually reviewing large, complex PDF plans and estimates, making it easy for scope gaps and costly estimating errors to slip through unnoticed.
Solution -
I built an AI-powered system that ingests construction PDFs, extracts scope items, and matches them to trade codes using a deterministic + AI-assisted justification engine. The system produces structured summaries for subcontractors and flags discrepancies automatically, helping teams catch expensive mistakes earlier in the workflow.
0
25