Acme Enterprise CRM
A secure, lightning-fast dashboard system serving 10k+ daily operators with custom workflows.
Project Scopes & Goals
The Acme CRM Showcase
Acme Corp needed a unified CRM platform that would sync call records, billing events, and ticket workflows under a single visual dashboard. We designed and built a tailored SaaS system that optimized transaction times by 45%.
Project Objectives
- Transition 10 legacy databases into a singular PostgreSQL core.
- Implement strict JWT and multi-tenant security layers.
- Build lightning-fast tabular search filtering across millions of records.
System Architecture
Next.js App Router acting as the unified client/server boundary, speaking directly to PostgreSQL hosted on AWS RDS via Prisma ORM. Authentication is delegated to Clerk, utilizing metadata for business segment assignment.
Technical Challenges
Synchronizing high-frequency ticket updates across concurrent operators without running into database lock contentions.
Lessons Learned
Implementing cursor-based pagination and database indexing on query filters is critical when tables exceed 10 million items.
Core Specifications
Screenshots
