CPU Retirement Office Loan Management System
Modernizing legacy paper records into a CPA-backed automated loan platform.
Lead Full-Stack Engineer & Architect
Central Philippine University Retirement Office
2024 — Present
Live Production
Executive Summary & Strategic Overview
Institutional financial records modernization and loan processing ecosystem built for Central Philippine University Retirement Office. Replaced decades of legacy paper records with a CPA-validated automated calculation engine.
Verified Performance Metrics & Business Impact
Paperless Records
Replaced decades of physical ledgers with automated digital workflows
Amortization Precision
CPA-validated compound interest formula engine eliminating accounting discrepancies
Historical Data Migrated
Clean schema transformation normalizing legacy spreadsheets into structured MongoDB collections
System Access
Web administrative management portal paired with member mobile client integration
The Engineering Challenge
The CPU Retirement Office managed multi-tier institutional loans across decades using physical ledgers and unstandardized Excel spreadsheets. Manual compound interest calculations caused accounting delays and reconciliation risks.
The Architectural Solution
Engineered a centralized, dual-platform software ecosystem powered by Next.js and Prisma ORM. Codified strict institutional accounting formulas into a deterministic calculation engine with automated validation.
Core Technical & Architectural Highlights
CPA-Backed Financial Formula Engine
Codified complex institutional loan amortization schedules and penalty deduction rules into validated pure TypeScript modules with automated test coverage.
Legacy Spreadsheet Normalization Pipeline
Sanitized and migrated 15+ years of unstandardized financial spreadsheets into structured MongoDB collections with Prisma guarantees.
Role-Based Access Control (RBAC)
Implemented granular permissions separating loan officers, system administrators, and member inquiry workflows.
Agentic AI Pair Programming & Antigravity Acceleration
Leveraged Antigravity agentic workflows to rapidly test complex edge cases in amortization math, scaffold Prisma data models from legacy CSV dumps, and verify financial formula precision.