Bagas

Overview

About the
Project

Architected, developed, and maintained the web portal for SIH3 (Hydrology, Hydrometeorology, and Hydrogeology Information System) for Balai Wilayah Sungai (BWS) Bali Penida under the Ministry of Public Works and Public Housing (PUPR). This portal serves as a mission-critical digital infrastructure to aggregate, process, and present centralized water resource telemetry data from monitoring stations across the river basins of Bali and Nusa Penida.

As the lead Web Developer, I engineered the backend architecture, developed inter-agency RESTful APIs, and created periodic time-series data analytics dashboards to empower data-driven water resource management and hydrological disaster mitigation.

  • Institution
    BWS Bali Penida (PUPR)
  • Year / Duration
    2024 - Present
  • Role
    Web Developer
  • Status
    Production Active
Laravel MySQL RESTful API Tailwind CSS Telemetry Analytics Time-Series DB
Portal SIH3 Balai Wilayah Sungai Bali Penida Showcase
Portal SIH3 BWS Bali Penida Interface — Centralized Hydrological Monitoring, Rainfall Station Telemetry, and Water Level Gauging Dashboard
"Architecting a high-frequency telemetry data pipeline to deliver precise, transparent, and actionable hydrological intelligence for water governance resilience across Bali Province."

Engineering Architecture

Technical Challenges &
Engineering Solutions

Automated Telemetry Aggregation

Integrated automated data synchronization via background schedulers across dozens of remote telemetry stations (water level, rainfall, and climatology stations) distributed throughout Bali and Nusa Penida river basins with zero packet loss.

High-Throughput RESTful API

Architected standardized REST APIs for cross-institutional integration (Central PUPR, BMKG, academic institutions, and regional agencies) featuring bearer token authentication and adaptive rate-limiting to protect against server saturation.

Time-Series Query Optimization

Optimized MySQL schema architecture with timestamp-based table partitioning and composite indexing, accelerating historical precipitation and water discharge analytics calculations to sub-millisecond query execution times.

Dynamic Interactive Visualization

Engineered interactive time-series chart modules and visual trend monitors utilizing Tailwind CSS and Chart.js, enabling hydrological analysts and agency leadership to comprehend seasonal fluctuations effortlessly.

Deliverables

Implementation Scope & Engineering Deliverables

  • Backend Engineering: Designed a robust Laravel service-layer architecture for reliable, high-integrity numerical data computation and ingest pipelines.
  • Automated Alert Thresholds: Implemented real-time river water level threshold detection (Normal, Advisory, Watch, Warning) triggering immediate visual indicators across monitoring consoles.
  • Multi-Format Data Export: Engineered flexible historical reporting pipelines (CSV, Excel, PDF) customizable by monitoring station and date intervals for environmental researchers.
  • Hierarchical Role Management: Configured granular role-based access control separating field telemetry operators, balai data analysts, system administrators, and public read-only access.
  • Sensor Telemetry Validation: Designed automated anomaly filters to identify and isolate erratic sensor readings (spike anomalies or negative values) caused by field hardware glitches.