2025
Criminal Database - Republic of Palau
A complete ground up redesign and normalization of the criminal database for the Republic of Palau.

About This Project
As part of the TCinGC program, I worked with the Office of the Attorney General of the Republic of Palau to transform an outdated and fragmented legal case management system into a structured, scalable solution. By redesigning and normalizing a database of over 30,000 criminal case records, improving data integrity, and enhancing usability through better workflows and reporting, the project helped turn operational chaos into clarity and long-term sustainability. Read the full report.
Technologies Used
Microsoft AccessSQLVisual BasicUI/UXUser Testing
Team
Jonathan LindstromSolo


