Hadyan Fico
Mahardika

SGIntern — Social & Internship Platform

A production social platform connecting students, built and deployed end to end with Next.js, TypeScript, and PostgreSQL.

• Built social features — posts, comments, media uploads, and public feeds.
• Implemented role-based access control with Clerk to separate students, providers, and administrators.
• Designed a file-management workflow with asset states (temporary, active, orphaned, deleted) and automated cleanup of unused files.
• Set up scheduled background jobs for data analytics and file cleanup.
• Integrated PostgreSQL through a repository and use-case layer for data access.

SGIntern Backend Rewrite

A ground-up redesign of the SGIntern backend to cut coupling between business logic and any specific framework or infrastructure — while keeping the live production app running throughout.

• Drew explicit boundaries between domain, application, infrastructure, and transport layers.
• Replaced framework/infrastructure-bound components with independent definitions for authentication, persistence, transactions, and file storage.
• Introduced Go for safe concurrency, transaction management, worker pools, queues, and automated testing.
• Kept the existing production app running as a live reference while the new architecture is developed and tested in parallel.

Note — the rewrite is still in progress; the production app keeps running through the migration.