Back to Projects

Internal Resource Allocation Manager

Sep 2025 - Present
RDA Corporation

Transformed a prototype resource management application into a production-ready enterprise system, migrating to MSSQL Server, implementing Entra ID SSO, and establishing robust CI/CD pipelines.

Authentication
Azure
CI/CD
Docker
GitHub
Next.js
React
SQL
Turborepo
TypeScript
Web Applications

Project Details

  • Inherited a prototype resource management application and led its transformation into a production-ready enterprise system.
  • Migrated backend from Supabase/PostgreSQL to MSSQL Server 2022, implementing database-first schema design with parameterized migration scripts.
  • Restructured the codebase into a Turborepo monorepo with @rram/web, @rram/db, and @rram/dal packages to improve maintainability and code reuse.
  • Implemented Microsoft Entra ID SSO authentication with JWT-only sessions, enabling fast Edge Runtime auth checks.
  • Developed role-based authorization with client-side hooks and server-side middleware separation for secure permission handling.
  • Established CI/CD pipeline deploying self-contained artifacts to Azure Web Apps, eliminating runtime dependency installation for faster, more reliable releases.