SPMI (Sistem Penjaminan Mutu Internal)

The Sistem Penjaminan Mutu Internal (SPMI) is a high-performance web application designed to digitize and automate the entire Internal Quality Audit (AMI) lifecycle for the university. It transforms manual, paper-based compliance checks into a centralized, data-driven digital ecosystem.

Built with a focus on data integrity and scalability, the system handles complex hierarchical data for quality standards and implements a rigorous audit workflow involving multiple stakeholders: Auditors, Auditees (Prodi), and Administrators.

• Engineered a scalable, type-safe RESTful API using Express.js and Drizzle ORM with a modular Service-Repository architecture.
• Implemented Recursive CTEs (Common Table Expressions) to efficiently query and manage deep-nested Quality Standard trees.
• Developed a Transactional Cloning System to duplicate year-over-year audit criteria, preserving relationships between Standards, Indicators, and Supporting Documents.
• Designed sophisticated SQL aggregation queries to power Real-time Radar Charts for comparative faculty analysis.
• Enforced strict Role-Based Access Control (RBAC) integrating seamlessly with the university's academic structure.

Executive Dashboard & Analytics

Real-time visualization utilizing Radar Charts and Trend Lines to monitor faculty performance ('Ketercapaian Standar') across multiple academic years.

Hierarchical Standard Management

Complex recursive tree-structure management for Quality Standards (Levels 1-4) allowing deep-nested organization of audit criteria.

Digital Audit Workflow (AMI)

End-to-end digital audit lifecycle covering Self-Evaluation (Evaluasi Diri), Desk Evaluation, and Field Visitation (Visitasi) with evidence attachment support.

Automated Annual Migration

One-click duplication feature using transactional logic to clone entire standard trees, indicators, and document requirements to new academic periods.