2026 · dashboard
MegaSec — Asset & Inventory Management System
An internal full-stack platform for managing tangible and intangible assets, software licenses, purchases, contracts, repairs, and employee assignments — with Microsoft 365 SSO and group-based RBAC for finance, HR, IT, and admin teams.
Gallery & architecture
Challenges
- Built a modular NestJS + Prisma/PostgreSQL API covering assets, licenses, purchases, contracts, repairs, employees, and reports
- Implemented group-based RBAC across 14 menu modules with NONE/READ/WRITE/FULL access levels and action-level API guards
- Integrated Microsoft 365 SSO via MSAL with Azure token exchange and httpOnly JWT session cookies
- Designed license lifecycle tracking with Excel-aligned expiry statuses and scheduled cron notifications
- Shipped asset QR generation, assignment acknowledge/return flows, and employee offboarding checklists
- Added contracts registry, file attachments, append-only audit logs, and Excel/CSV import-export across modules
Stack
TypeScriptReactNestJSPostgreSQLPrismaAnt DesignMSALPassport JWTTanStack QueryReact RouterViteAxiosExcelJSDocker