What changed
- Cut key processing time by up to 50% by building a backend of 40+ Next.js API routes and 25+ Postgres RPCs on Supabase.
- Automated risk detection and reporting for security staff by integrating 3 AI features - rule-based risk scoring, Gemini shift reports, and signature verification.
- Achieved zero missing or altered records by writing every state change and its audit entry in one atomic database transaction.
What I worked on
- I designed and built the backend - API routes, transactional Postgres RPCs, and Row-Level Security across all database tables.
- I built the AI security layer, including pixel-level signature verification and Gemini-generated shift reports with a deterministic fallback.
- I implemented four role-specific dashboards for security officers, deans, verifiers, and staff requesters.


