Case Studies
Real problems. Practical solutions. Measurable results.
Building a Full-Stack PWA from Scratch
Problem
Needed a production-quality progressive web app with real-time data, geospatial features, OAuth authentication, and role-based access control — built and shipped as a solo developer.
Approach
Designed and built dogmap.ca using Next.js, TypeScript, Supabase (PostgreSQL + PostGIS), and Vercel. Implemented Row Level Security on all tables, OAuth with Google and Apple, JWT-protected API routes, admin dashboard with moderation queue, and MapLibre-powered interactive maps.
Result
Live production application at dogmap.ca serving real users. Demonstrates full-stack architecture, security-first design, cloud infrastructure, and the ability to ship end-to-end as a solo engineer.
Building Inventory System: Legacy to Modern in 2 Days
Problem
A university's Facilities Information System — used daily to manage buildings, rooms, utilities, maintenance, and reporting across multiple campuses — was running on Classic ASP with VBScript. The aging codebase was difficult to maintain, lacked modern security practices, and couldn't support responsive design or modern CI/CD workflows.
Approach
Using AI agents guided by comprehensive context documents, I extracted all business logic from the legacy Oracle/Classic ASP system and rebuilt the entire application in .NET 8 Blazor Server. The modernization preserved the existing Oracle database schema and SSO authentication system — zero breaking changes to production infrastructure. I delivered 13 Razor pages, 10 data models, 5 backend services, and 40+ CRUD operations with a full CI/CD pipeline and 30+ automated tests.
Result
Complete feature parity delivered in 2 days with zero downtime. The modernized system now has responsive Bootstrap 5 UI, real-time Blazor updates (replacing full-page refreshes), parameterized queries for SQL injection prevention, and automated deployment via GitLab CI/CD. The architecture was documented as a reusable template for modernizing additional legacy applications across the institution.
Room Booking System: Replacing 700K Lines of PL/SQL in 8 Days
Problem
A university's room booking system relied on a Classic ASP front-end backed by a 705,714-line Oracle PL/SQL package. The legacy system used XML DOM to transfer data between the database and browser, had no mobile support, and offered limited conflict detection for scheduling. The complexity of the PL/SQL package made changes risky and time-consuming.
Approach
I wrote comprehensive context documents and a phased modernization plan, then used AI agents to execute the rebuild. The agents replaced all XML-based Oracle calls with direct parameterized SQL, built 7 Blazor pages with 16 data models and 5 C# services (1,827 lines), and implemented a color-coded availability matrix with real-time conflict detection. The system maintained full compatibility with the existing Oracle database, SSO authentication, and 4-level privilege hierarchy.
Result
MVP delivered in 1 day, production-ready in 8 days. The modernized system features a mobile-responsive interface, real-time room availability with conflict-level indicators (green/yellow/red), parallel authentication checks for faster load times, and a full GitLab CI/CD pipeline. Users can now search, filter, and book rooms from any device — including mobile Safari, which required targeted fixes for Data Protection keys and antiforgery tokens.
Let's Build Your Success Story
Every engagement starts with a conversation.
Book a Free Discovery Call