Mithaq Management System

An enterprise-grade Lead Management System designed for educational institutions to centralize, automate, and optimize their lead generation and conversion pipeline.

Features

  • Lead Lifecycle Management — Complete tracking from NEW → CONTACTED → FOLLOW_UP → REGISTERED/NOT_REGISTERED
  • Automated Distribution — Round-robin algorithm with database-level locking to prevent race conditions
  • SLA Monitoring — Automated tracking of initial contact timeframes with breach detection
  • Role-Based Access Control — Four user roles (Admin, Manager, Moderation, Sales) with different permissions
  • Real-Time Synchronization — WebSocket-based instant updates across all connected clients
  • Analytics Dashboard — Live KPIs, conversion funnel analysis, and agent productivity metrics
  • Multi-Channel Notifications — Push notifications, WhatsApp integration, and email alerts

Technical Highlights

  • 35,000+ lines of TypeScript and SQL
  • 15+ database tables with optimized relationships and Row-Level Security
  • 100+ concurrent users with sub-100ms response times
  • 46x performance improvement through query optimization
  • Supabase backend with PostgreSQL, Edge Functions, Auth, and Real-time subscriptions

Tech Stack

FrontendBackend
React 19PostgreSQL 17
TypeScript 5.9Supabase
Tailwind CSS 4Deno Edge Functions
shadcn/uiWebSocket

Architecture

Built with enterprise best practices: composite indexes, materialized views for dashboards, PostgreSQL cron jobs for automation, and optimistic concurrency control for conflict detection.