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.

SITRACK - Site Acquisition Tracking - 11/10
SITRACK - Site Acquisition Tracking - 22/10
SITRACK - Site Acquisition Tracking - 33/10
SITRACK - Site Acquisition Tracking - 44/10
SITRACK - Site Acquisition Tracking - 55/10
SITRACK - Site Acquisition Tracking - 66/10
SITRACK - Site Acquisition Tracking - 77/10
SITRACK - Site Acquisition Tracking - 88/10
SITRACK - Site Acquisition Tracking - 99/10
SITRACK - Site Acquisition Tracking - 1010/10

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
Taufiqurrahman Yudhi Atmadja | Software Engineer