Portfolio

Client needed to look up make, model, and current market value for vehicles by VIN number. There was no integration in place — staff were doing manual lookups and copying data by hand, which was slow and error-prone.

A scheduled service that runs once a day — or on demand when needed — to pull vehicle data directly from Kelley Blue Book (KBB) by VIN and store it in their database automatically.

Vehicle data is always current without any manual effort. Staff stopped doing lookups by hand, and the business had accurate valuations available the moment they were needed.

The company had a reliable process for receiving data as CSV files from a 3rd-party vendor via SFTP. Their developer left, and the process continued running — until the vendor switched to dropping JSON files on an S3 bucket instead. That change broke everything and brought the client's data pipeline to a halt.

Modified the integration to read from S3 instead of SFTP, parse the new JSON format, and map the incoming data back into their existing system. No changes were required on the client's side — the output was identical to what their system had always expected.

Operations resumed immediately. The client's pipeline was restored with minimal disruption, and the updated integration can accommodate future vendor schema changes without a full rebuild.

Technicians were tracking quotes, repair hours, photos, and commissions across spreadsheets and paper logs. No visibility into status, no easy way to generate customer-facing documents.

A web-based shop management tool. Technicians log time, upload photos, and generate customer quotes that are emailed for approval. Once approved, work orders are tracked through completion. Commission reports and payment status are calculated automatically.

Eliminated paper logs entirely. Quotes sent in minutes instead of days. Commission disputes dropped to zero because every hour and approval is tracked.

Legacy COBOL database drove order entry. When the primary system went down, the business had no way to create or look up orders — operations stopped.

A real-time sync layer that mirrored the COBOL data into SQL Server. Built an emergency order entry system on top of it with pick ticket and packing slip generation. Operations could continue through any outage.

Zero unplanned downtime impact. Staff could process orders normally regardless of mainframe status. Printed pick tickets replaced manual fulfillment coordination.

Veterans with disabilities living at home had limited support between caregiver visits. Clinicians had no visibility into daily activity patterns, medication timing, or mobility.

An IoT smart home platform that tracked patient location and activity throughout the home using sensors and smart devices. The system prompted patients for scheduled tasks and generated daily activity reports for clinicians and caregivers.

Patients maintained independence longer. Clinicians received automated daily reports without manual charting. Caregiver visit frequency was optimized based on real data.

Propulsion engineers needed to analyze telemetry data from Space Shuttle tanking events across multiple launches. Data lived in separate systems. Pulling it manually and comparing trends took hours and was error-prone.

A telemetry retrieval and analysis tool that aggregated data from multiple sources, rendered it as overlaid plots and tables, and flagged out-of-family readings automatically. Engineers could compare data across launch events in minutes.

Received a NASA performance award. The tool became the standard used by the engineering community for every Shuttle launch. Analysis time dropped from hours to minutes.

Propulsion engineers navigated between multiple disconnected systems to find device specs, electrical schematics, telemetry data, and maintenance history for individual components.

An integrated data platform that linked all device data behind a single interface. Clicking a valve on a graphical schematic immediately surfaced all associated data — schematics, telemetry, part numbers, maintenance history — from whatever source system it lived in.

Received a second NASA performance award. Dramatically reduced time spent context-switching between tools during pre-launch operations.

A batch process handling hundreds of thousands of messages encoded all business logic inside massive SQL queries. The job took over 8 hours to run, was fragile and nearly impossible to debug. If anything failed after hours of processing, nothing was committed — the entire run had to restart from scratch with no way to know which data caused the failure.

Rewrote the service in a traditional programming language with clean, testable business logic. Integrated Azure Service Bus for reliable message delivery and used parallel processing to distribute the workload. Added structured logging so failures were immediately identifiable and the process could resume from where it left off.

Processing time dropped from 8+ hours to 15 minutes. Partial failures no longer required a full restart — completed work was preserved and errors were pinpointed instantly through logs.

A youth sports league needed profile photos of 200+ athletes during registration — before identities were confirmed on-site. Asking parents to submit photos on their own simply didn't work: images came in wrong formats, mismatched to athletes, or not at all.

An app where league staff upload the roster, select an athlete from the list, and photograph them on the spot. The image is automatically associated to the athlete's record, cropped to a square, resized, and uploaded — all in one step at registration.

All athlete photos collected accurately at registration events. No manual follow-up, no mismatched images, and no post-processing required by staff.

The business needed a simple, affordable way to manage contacts and send targeted emails. Enterprise CRM and email platforms were too expensive and too complex for what they actually needed.

A lightweight contact management and email marketing tool. Staff collect contacts, tag them with metadata, and send targeted emails or newsletters to selected groups. A dedicated newsletter feature was built around their weekly blog post summary. Every send is logged — who received it and when.

The business gained a full contact and email workflow at a fraction of the cost of third-party platforms. Targeted campaigns replaced mass blasts, and the team had complete visibility into send history.

League administrators managed athlete registration, team rosters, game schedules, and coach assignments manually across spreadsheets and email threads. Game day programs were created by hand.

A full league management platform covering athlete registration with compliance document tracking, roster management, schedule generation, and automated game day program creation. Sports cards generated from roster data with print-ready output.

Administrative time per season cut significantly. Game day programs produced in minutes rather than days. Compliance documents tracked automatically rather than chased manually.