Business Management

Khizaans

Creative Agency Management Platform

1 / 2

Executive Summary

The Situation:A high-volume video editing agency was struggling with fragmented internal operations, relying on scattered tools for task assignment, attendance, and client delivery.

The Mandate:Architect a dual-sided digital solution: a highly visual marketing frontend to attract clients, and a deeply secure, role-based backend portal for internal operations, both powered by Next.js.

The Result:Successfully centralized their entire operational workflow into a single, custom-built SaaS ecosystem, saving the agency hours of administrative overhead weekly.

Architecture Stack

Next.js

TypeScript

Supabase

PostgreSQL

Role-Based Auth

Vercel

Tailwind CSS

Technical Deep-Dive

Overcoming Bottlenecks

Developing a strict Role-Based Access Control (RBAC) system where Editors, Managers, and Admins had entirely different views, permissions, and data constraints within the same Next.js application.

First-Principles Engineering

Integrated Supabase for backend infrastructure. I leveraged PostgreSQL Row Level Security (RLS) policies to guarantee data isolation at the database level, combined with Next.js middleware for instant route protection and JWT verification at the edge.

Business Impact

Operational Centralization

Unified task tracking, attendance, and meeting schedules into one dashboard.

Enterprise Security

Supabase RLS ensured that sensitive client video assets were only accessible by assigned personnel.

Dual Value Delivery

Solved an internal HR problem while simultaneously delivering a world-class marketing website.