Internal Tool / Gov
SCG Unillanos
Contract management system for a Colombian public university — built to replace Excel and paper.
The problem
The Universidad de los Llanos managed dozens of simultaneous institutional contracts — public works, supplies, services, inter-administrative agreements — each with its own lifecycle, critical deadlines, and multiple stakeholders. Without a dedicated system, tracking obligations across Excel sheets and physical folders made it easy to miss renewal dates, lose audit trails, or duplicate effort across departments.
The solution
We built a focused MVP that centralizes the full contract lifecycle under one roof. Contracts are created with all fields required by Colombian public procurement law (SECOP publication, CDP/RP numbers, budget source, policy coverage). Every modification — extensions, value additions, suspensions — is registered and the system automatically recalculates the real termination date. Role-based access ensures each user (Gestor, Abogado, Revisor) only sees the contracts they're involved in.
Screenshots
Dashboard — real-time metrics, committed value, and distribution by contract type
Contract management — full CRUD with normative fields for Colombian public procurement
Lifecycle — extensions, additions, and suspensions with automatic real termination date
Access control — role-filtered visibility with multi-role user support
Tech stack
Backend
Frontend
Infra
Results
0 Excel sheets
Entire contract portfolio centralized with full traceability
3 roles
Gestor, Abogado, and Revisor — each with exact visibility over their contracts
Auto calc
Real termination date recalculated dynamically on every extension or suspension