Case study · 2024 · Web Developer Intern

DPMPTSP Asset Management

Digitized a government division's asset lifecycle: inventory, borrowing, and reporting in one Laravel system.

Client
DPMPTSP Kota Bandung
Role
Web Developer Intern
Timeline
Sep–Dec 2024
Year
2024
Paper→Digital
asset workflow
Smart
item search
1-click
Excel export
LaravelPHPMySQLBootstrapJavaScriptHTML/CSS

Overview

A full-stack asset management application built during a placement at DPMPTSP Kota Bandung, alongside two teammates and under a department mentor. It replaced a manual asset ledger with a searchable system covering items, categories, locations, borrowing, and users.

The problem

The division tracked its assets on paper. Finding an item, knowing who borrowed it, or producing a report meant flipping through records by hand, slow and error-prone.

Approach

We modeled the asset lifecycle in Laravel: items belong to categories and locations, move through a borrowing log, and are administered by scoped users. An admin dashboard sits over it all, with search and Excel export for the reports staff actually needed.

What it does

Admin dashboard

A single overview of assets, categories, and activity.

Items & smart search

Find any asset instantly by name, category, or location.

Borrowing log

Who has what, since when, and its return status.

Excel export

One-click reports the office could hand up the chain.

Results

The division moved from a paper ledger to a searchable digital system: faster lookups, traceable borrowing, and reports in a click. Delivered as a working internship product with a completion certificate.

Lessons

Building for real government staff taught me to design around the workflow they already trust: the system had to feel like a faster version of what they did, not a foreign process.

Next project

TandaAir