JobTrax CRM

JobTrax CRM was a challenging modernization project that involved rebuilding a legacy ColdFusion application from the 1990s into a modern, secure, and maintainable web application. The original system was running on an insecure HTTP server with a heavily flawed PostgreSQL database that had been modified by non-developers over the years, resulting in broken relationships and inconsistent data structures.

As the lead developer, I was tasked with creating a proof-of-concept MVP to demonstrate that we could replicate the existing CRM functionality using modern technologies. I chose Next.js for the frontend framework, Supabase for backend infrastructure, and TypeScript for type-safe development. One of the most significant challenges was migrating the legacy database—after attempting PostgreSQL's native migration tools, I utilized FullConvert by SpectralCore to successfully transfer all data while preserving as much integrity as possible.

The project taught valuable lessons about scope management and client communication. Without a formal Statement of Work, the project expanded beyond the original MVP goals, highlighting the importance of clear boundaries and documentation in client work. Despite these challenges, the application successfully demonstrated modern CRM capabilities with real-time data synchronization, a responsive mobile-friendly interface, and production-grade architecture.