ID
← Back to work

Case Study Nov 2025 — Mei 2026

Information System @ BSN — Gamal Musthofa

Developing various information systems for the National Standardization Agency (BSN) — from legal documentation websites, SNI data management, internal back office, to an integrated metrology service system. Core stack: CodeIgniter, Laravel, Next.js, PostgreSQL.

  • RoleFullstack Developer
  • StackCodeIgniter · Laravel · Next.js · PostgreSQL
  • PeriodNov 2025 — Mei 2026
Logo BSN
01

JDIH — Legal Documentation & Information Network

Development of the BSN JDIH website using the CodeIgniter framework and PostgreSQL database. Built new modules, fixed existing errors, and added new features as requested by BSN's Legal Division. Focused on system reliability and accuracy of legal documentation workflows.

CodeIgniter PostgreSQL Bug Fixing Modul Baru Fitur Custom

Work Done

  • Built new modules per Legal Division requirements
  • Identified & fixed system bugs/errors
  • Implemented new features from user requirements
  • Maintained and optimized database performance

Tech Stack

  • CodeIgniter Framework (PHP)
  • PostgreSQL Database
  • Internal RESTful routing
  • Server-side rendering

Screenshots

JDIH Screenshot 1 JDIH Screenshot 2 JDIH Screenshot 3 JDIH Screenshot 4
02

SNI Data Management

Built a website to comprehensively manage Indonesian National Standard (SNI) data. Key features include: displaying all SNI data, CRUD standard data, displaying PDF documents for each SNI entry, and integration with an existing API containing SNI data from the legacy system.

Next.js / React Laravel PostgreSQL API Integration PDF Viewer CRUD System

Key Features

  • Display all SNI data with pagination
  • Full CRUD for standard data management
  • Integrated PDF viewer per SNI document
  • External SNI data API integration

Architecture

  • Frontend: Next.js (SSR + ISR)
  • Backend: Laravel REST API
  • Database: PostgreSQL
  • API Bridge: SNI legacy system data
Screenshots not yet available — coming soon
03

Back Office — BSN Data & Information Center

Built an internal BSN website for business model management, specifically for the BSN Data and Information Center. Developed using Laravel and PostgreSQL with integrated APIs. This system serves as the operational backbone used by the BSN Pusdatin team.

Laravel PostgreSQL API Integration Internal System Business Management

Scope of Work

  • Designed and built internal business management system
  • API integration with Pusdatin-related systems
  • Multi-level role & access management
  • Reporting dashboard & operational monitoring

Tech Stack

  • Laravel Framework (PHP 8+)
  • PostgreSQL Database
  • Integrated REST API
  • Blade templating + Vite

Screenshots

Back Office Screenshot 1 Back Office Screenshot 2 Back Office Screenshot 3 Back Office Screenshot 4
04

SPARTA — Integrated Metrology Service Center

Performed comprehensive system flow fixes on the SPARTA website, with over 300 documented fixes. Worked with a team of 3 programmers (including myself) and 2 QA members — ensuring every metrology service flow runs correctly, efficiently, and up to standard.

Team: 3 Programmers + 2 QA · 300+ Fixes
System Fix & Refactor QA Collaboration 300+ Test Cases Metrologi / Pelayanan Publik

Work Done

  • Comprehensive system flow audit & fixes
  • 300+ bug fixes and flow inconsistencies resolved
  • Active collaboration with QA team
  • Post-fix validation through re-testing

Process & Methodology

  • Test case documentation per feature (Google Sheets)
  • Iterative bug triage with QA
  • Fix → review → re-test → close
  • Remote & on-site team coordination
View SPARTA Test Case Documentation (Google Sheets)

Screenshots

SPARTA Screenshot 1 SPARTA Screenshot 2 SPARTA Screenshot 3