CRM Lifecycle Management
Covers sales pipelines, lead tracking, HR operations, employee attendance, EOD reports, and project lifecycle management.
← Back to Work
2026 • Software Developer Intern
Media Masala CRM
Production CRM with Sales Pipelines, HR & 4-Level RBAC Scoping
Project Overview
Media Masala CRM is an enterprise-grade Customer Relationship Management system developed during my software developer internship. Used daily by 10-12 staff members, it covers sales pipelines, lead tracking, HR operations, employee attendance, EOD reports, and project lifecycle management. Designed a normalized PostgreSQL relational schema (Neon + Prisma) and implemented a 4-level Hierarchical RBAC system (Super Admin ➔ Admin ➔ Team Lead ➔ Employee) using NextAuth + JWT with scoped database filters. Features React 18 analytics dashboards for tracking sales funnels, employee productivity, and attendance.
Technologies Used
Next.js 14Node.jsExpressPostgreSQLPrisma ORMNextAuthTailwind CSSJWTReact 18
Key Features
Relational Schema Design
Designed a clean, normalized PostgreSQL relational schema using Neon database and Prisma ORM for integrity.
4-Level Scoped RBAC
Implemented custom RBAC (Super Admin → Employee) via NextAuth + JWT with scope hierarchy to restrict record visibility.
Analytics Dashboards
Built React 18 analytics dashboards for tracking sales funnels, employee productivity metrics, and attendance data.