Majlis Bandaraya Johor Bahru (MBJB) is the local city council responsible for managing business licensing, compliance enforcement, and city operations across Johor Bahru. With a large number of businesses, billboards, and licensing requirements, MBJB needed a more efficient and scalable way to manage operations.

The Challenge

MBJB faced several operational inefficiencies due to manual and fragmented processes:

  • Manual Tracking of Licenses — Licensing records were scattered across Excel files and internal systems, making it difficult to track expiration dates and renewal status
  • Lack of Centralized Visibility — No single dashboard to monitor all licenses, assets, and enforcement status. Hard to get real-time insights for decision making
  • Inefficient Enforcement Workflow — Officers relied on manual processes for inspections and follow-ups, causing delays in identifying expired or non-compliant licenses
  • High Risk of Missed Renewals — No automated reminders or alerts. Businesses could easily fall into non-compliance without anyone noticing

"We needed a system that could work for everyone — from the officer inspecting billboards in the field to the finance team tracking renewal revenue for audit."

Our Solution

We developed a Centralized Licensing & Enforcement Management System that digitizes and automates MBJB's entire workflow — connecting licensing records, inspections, and enforcement into one unified platform.

License Management System

  • Centralized Database — All licenses in one place, searchable by type, expiry date, renewal status, and owner
  • Search & Filter — Locate any license record instantly via keyword, business name, or custom filters
  • Complete Lifecycle Tracking — From application to approval, renewal, and expiry — every stage is tracked

Automated Renewal Tracking

  • Expiry Monitoring — System automatically tracks license expiry dates across all categories
  • Smart Alerts — Sends notifications for upcoming renewals and flags expired licenses
  • Reduced Manual Workload — No more spreadsheet-based monitoring or manual follow-ups

Enforcement & Inspection Module

  • On-Site Recording — Officers record inspection results, upload photos and evidence, and update compliance status directly from the field
  • Digital Case Tracking — Track violations, follow-up actions, and case status from report to resolution
  • Faster Response — Automated workflows replace manual handoffs between departments

Asset & Billboard Management

  • Location Tracking — Track billboard locations and ownership across the city
  • License Linking — Each asset is linked to its licensing records for compliance monitoring
  • Visual Monitoring — See compliance status at a glance on the dashboard

Dashboard & Reporting

  • Real-Time Dashboard — Active vs expired licenses, enforcement cases, compliance rates — all visible at a glance
  • Report Generation — Generate reports for internal tracking and management decisions
  • Multi-Department Access — Role-based access ensures each department sees what they need

Tech Stack

⚙️
Backend
Laravel
REST API
🌐
Frontend
Web App
Modern Interface
🗄️
Database
MySQL
Relational
☁️
Hosting
AWS EC2
Scalable Compute

Before vs After

Before
License trackingExcel-based
InspectionsManual & paper
Centralized systemNone
Renewal alertsNone
Enforcement speedSlow
After
License trackingFully digital
InspectionsDigital & real-time
Centralized systemUnified platform
Renewal alertsAutomated
Enforcement speedAccelerated

Results & Impact

  1. Significant reduction in manual administrative work across departments
  2. Faster enforcement response time — from reactive to proactive compliance monitoring
  3. Improved compliance tracking accuracy — automated alerts eliminate missed renewals
  4. Better visibility across departments — real-time dashboards replace guesswork
  5. Scalable system ready for future expansion to additional licensing categories

"We helped MBJB move from manual tracking and reactive enforcement to a centralized system with automated compliance monitoring and faster action."

Key Takeaways

This project demonstrates how digital systems can transform government workflows from reactive to proactive — replacing fragmented tools with a single source of truth and enabling data-driven enforcement and compliance management.

The biggest win wasn't any single feature — it was the shift from "we don't know what's expired" to "the system tells us before it expires." That mindset shift, powered by automated alerts and centralized visibility, fundamentally changed how MBJB operates.