Skip to content

Case Study

From scattered systems to one platform.

How Kube Native built ISPEMOS, Malaysia's first integrated solid waste management platform. Unifies 10+ data sources across multiple concessionaires and processes over 100 million records each month.

Client: SWCorp Malaysia · Year: 2024 · Category: Enterprise Platform, Data Integration

Executive summary

SWCorp Malaysia (a statutory corporation under KPKT) runs the country's solid waste management. Their data was spread across spreadsheets, old databases, and systems built by different contractors. Each concessionaire (Alam Flora, E-Idaman, SWM Environment, and others) sent reports in their own formats. SWCorp had no way to see what was happening across the country in real time.

Kube Native built ISPEMOS (Integrated Single Platform Monitoring System), a single web platform that pulls data from every concessionaire, normalises it, and gives SWCorp a clear view of collection schedules, recycling rates, and contractor performance.

10+

Data sources integrated

100M+

Records processed monthly

1st

In Malaysia - fully integrated waste platform

Real-time

Monitoring and KPI tracking

The problem

Data stuck in silos.

Each contractor ran their own system. Some used old databases, others sent Excel files every month. SWCorp had no central place to:

  • Track collection schedules and completion across all regions
  • Check if contractor-reported KPIs matched real operations
  • Catch missed collections or underperforming zones early
  • Generate national reports without typing data in by hand

Too much time went into reconciling spreadsheets. SWCorp needed a system that just worked, so they could focus on operations instead of data entry.

The solution

ISPEMOS: a single view of waste operations.

Kube Native built ISPEMOS as a web platform from scratch. Three things it does:

1. Ingests data from any source

We built an ETL layer that reads from MySQL, SQL Server, CSV uploads, and REST APIs. Each concessionaire kept using their own tools. ISPEMOS sits on top and standardises everything into one schema.

2. Processes data in near real time

Over 100 million records flow through the system each month. Dashboards update as data arrives. The system flags problems (missed collections, overdue schedules, KPI failures) and sends alerts to the right people.

3. Shows the right view for each user

Headquarters sees national numbers with drill-down to state and district. State officers see their region. Concessionaires get self-service access to their own data.

Technical architecture

How it was built.

The backend runs on PHP with Laravel, serving a responsive web frontend. MariaDB handles structured operational data. Redis is used for caching and job queues. Everything runs in Docker containers.

Each concessionaire's data source has a custom ETL adapter. New sources can be added without touching the rest of the system.

PHP & Laravel MariaDB Redis Docker REST APIs ETL Pipeline Real-time Dashboards Automated Alerts

Data Flow Architecture

DB

Alam Flora

MySQL

DB

E-Idaman

SQL Server

API

SWM Environment

API / CSV

API

More sources

REST / Custom

IS

ISPEMOS

Single Platform

100M+ Records / mo
Real-time Dashboards
Automated Alerts
KPI Tracking
Caching Redis
Image Machine Learning

Results

What changed.

  • Unified view of all concessionaires from one dashboard
  • 10+ data sources integrated, including MySQL, SQL Server, CSV, and APIs
  • 100M+ records processed and reported each month
  • Real-time KPI monitoring replaced manual spreadsheet work
  • First in Malaysia - a fully integrated waste management enforcement platform

Have a similar problem?

We build platforms that turn scattered data into something you can actually use. Talk to us.

Start a conversation