SIMJANOKON

Project Image

Project Overview

SIMJANOKON is a web-based certification management system designed to support submission, verification, and issuance of certifications for non-construction service enterprises.


The previous system relied on Microsoft Access, which limited accessibility, scalability, and operational efficiency. The project aimed to fully migrate and rebuild the system into a modern, secure, and scalable web application.


The new system enables enterprises to register, submit certification requests, upload required documents, and monitor application status in real-time.



Core Features

  1. Authentication System

    • Login & registration

  2. Role-Based Access Control

    Implemented using Spatie Permission with multiple roles:

    • Admin BSAN

    • Admin BSAP

    • Badan Usaha

    • Validator

    • Asesor

    • Pemutus

    • Ketua Pemutus

    Each role has a dedicated dashboard tailored to their workflow.

  3. Digital Document Management

    • Online document upload

  4. Automated Notifications

    • Email notifications for status updates

  5. Real-Time Status Tracking

    Enterprises can monitor certification progress dynamically without manual follow-ups.



Database Architecture

Designed and normalized the MySQL database to ensure:

  • Reduced redundancy

  • Clear relational structure

  • Data integrity & consistency

  • Efficient query performance



Technical Highlights

  • Laravel (MVC architecture)

  • Filament (Admin panel framework)

  • MySQL (Normalized relational database)

  • Spatie Laravel Permission (RBAC)

  • Email notification system

  • Web-based system migration from legacy platform



My Role

Collaborated in a team of two to fully rebuild the system.

My responsibilities included:

  • Designing and normalizing the database schema

  • Developing dynamic dashboards

  • Implementing multi-role authorization

  • Building submission workflow logic

  • Supporting system migration from Access to web



Impact

  • Eliminated dependency on local Microsoft Access system

  • Increased accessibility to 24/7 online platform

  • Accelerated certification process up to 80%

  • Improved transparency & operational efficiency

  • Delivered scalable and maintainable architecture


Create a free website with Framer, the website builder loved by startups, designers and agencies.