Paid freelance contract for St. John Paul II College of Davao: a student services and exam scheduling portal with 7,125 Google SSO accounts (students and 249 faculty) across 9 academic departments. Replaces physical queues and spreadsheet scheduling with automated interval-sweep scheduling, role-based clearance passes, and a tracked sanctions ledger for the Supreme Student Council.

Google SSO Accounts

7,125

Masterlist Records

14,778

Exam Schedules

658

Schedule Overlaps

0

• Conflict-Free Scheduler: Implemented automated interval-sweep scheduling to eliminate timetable conflicts across 658 exam slots, replacing manual spreadsheet validation.
• Role-Based Access: Configured domain-locked Google Workspace SSO (@sjp2cd.edu.ph) paired with PostgreSQL Row-Level Security to isolate student and faculty data.

Internal reporting tool built during my OWWA Region XI internship, consolidating 4,632+ citizen feedback records across 10 regional units with live balance validation and 1-click Excel export for ARTA/CSC reporting requirements.

Citizen Feedback Records

4,632+

Monthly Reports

72 Submissions

Regional Units

10 Units

Report Generation Time

<1s (1-Click)

• On-Demand Aggregation: Aggregates regional survey metrics on the fly in Next.js Server Actions from JSONB survey snapshots in under 100ms without saving redundant table rows.
• In-Memory Excel Engine: Built an in-memory ExcelJS export engine generating multi-tab workbooks with formulas and audit styling for ARTA/CSC reporting requirements, reducing report generation time to under 1 second.

Live tournament leaderboard delivering real-time score synchronization across 23 sports divisions for 9 departments using Supabase Realtime, with an auto-cycling display mode for gym screens and mobile spectator devices.

Competing Departments

9 Departments

Sports Divisions

23 Divisions

Score Sync

Real-Time

Operational Uptime

100% (Zero Downtime)

• Live Score Sync: Delivered real-time score synchronization across 23 sports divisions using Supabase Realtime to push live standings to student devices.
• Auto-Cycling Display Mode: Developed an auto-cycling display mode deployed across campus gym screens and mobile spectator devices for continuous live score broadcasts.