Back to projects
Enterprise Internal — Telkom Infrastruktur8 weeksFrontend + Backend Engineer (internship) — schema design, workflows, notifications
SITRACK - Site Acquisition Tracking
Internal platform replacing Excel + Telegram-bot tracking for fiber-optic site acquisition, land leases, and legal approvals.
100%
Manual rekap eliminated
↓ significantly
Missed-renewal risk
3 (field, office, legal)
Teams on one source
Challenge
Site data scattered across spreadsheets; lease expiries checked manually, risking missed renewals and legal exposure.
Solution
Centralized dashboard with site/device registry, lease submission + legal approval workflow, role-based access, and automated expiry notifications.
Architecture
1Next.js + TypeScript frontend
2Supabase (Auth, Postgres, Storage)
3Row-Level Security per role
4Scheduled expiry notification jobs
5Audit trail for legal approvals
Tech Stack
Next.js (TypeScript)ReactTailwind CSSSupabase (Auth, Database, Storage)PostgreSQL
Key Features
- Centralized management of fiber optic site data (ODP, GPON, FTB, FTM, and related devices)
- Land lease submission workflow with approval process involving legal teams
- Lease period monitoring with automated notifications before expiration
- Role-based access control for operational, legal, and monitoring roles
- Site status tracking for field and office infrastructure









