RHRoy Heinrich
Featured Projects

Selected work — engineered for performance, shipped for impact.

Three recent technical projects covering full-stack administrative platforms, public-sector application rollout, and applied AI/NLP solutions.

React 19 · TanStack · PHP · PostgreSQL

PFLC Alumni Tracker & Admin Portal

Overview

A full-stack alumni tracking and administration platform designed to streamline student record management, cohort promotions, and fee tracking for 500+ student records.

Problem

Administrative staff spent hours manually processing student spreadsheets, risking duplicate records, data inconsistencies, and data loss during upload interruptions.

Stack

React 19TypeScriptTanStack Start/Router/QueryPHPNeon PostgreSQLSupabaseTailwind CSSRadix UISheetJS (xlsx)

Impact

  • Reduced administrative onboarding and registration time by ~80% through bulk Excel/CSV import operations and automated cohort promotion tools.
  • Designed a custom REST API in PHP using transactional repository patterns and automated memory caching, cutting average API response time to under 200ms.
  • Built a fallback mechanism redirecting media uploads to local storage during Supabase cloud outages, sustaining 99%+ operational continuity.
  • Built a multi-step Excel/CSV import pipeline with SheetJS (xlsx) and custom schema validation, processing 500+ legacy records per batch with an interactive duplicate Conflict Resolution Wizard.
  • Implemented secure, multi-role authentication with SMTP-driven 6-digit OTP recovery, rate-limiting (429 Too Many Requests), and inactivity-based session expiration.
GitHubLive demo

PHP · Laravel · MySQL · GitHub

DICT DTC Aklan Digital Logbook System

Overview

An internal logbook and reporting platform built during a DICT engagement to replace manual paper-based tracking and automate administrative compliance.

Problem

Manual logs were slow, lossy, difficult to search, and made weekly/monthly reporting nearly impossible at scale across provincial offices.

Stack

PHPLaravelJavaScriptHTMLCSSMySQLGitHubExcel Queries

Impact

  • Developed and deployed the DICT DTC Aklan Digital Logbook System achieving 90% uptime and 100+ daily entries at production launch.
  • Validated and compared 100+ daily log entries using advanced Excel matching to verify data accuracy, eliminating discrepancies prior to supervisor review.
  • Prepared and submitted 5 technical documents per week - including system logs, process guides, and incident reports - maintaining a complete and audit-ready documentation trail.
  • Implemented SQL injection protection, dynamic logging, and maintained version control across 11 active GitHub repositories.
GitHubLive demo

Python · FastAPI · Redis · Supabase

Multilingual School Chatbot - Tomas S.M. Bautista Elementary School

Overview

A conversational natural language assistant deployed to handle admissions, policies, and general student inquiries across multiple language dialects.

Problem

Administrative staff were overwhelmed with repetitive inquiry questions in multiple local dialects, especially during enrollment seasons.

Stack

PythonFastAPINLTKTextBlobRedis CachingSupabaseRender

Impact

  • Planned and deployed a multilingual chatbot (English, Tagalog, Aklanon) handling 50+ FAQs with 95%+ intent accuracy across 15+ categories, improving query accuracy by 60% over the baseline.
  • Built a Python NLP engine (NLTK, TextBlob) with FastAPI, RESTful APIs, Redis caching (achieving an 80%+ hit rate), and Supabase integration.
  • Deployed on Render, sustaining sub-2s response times under simulated loads of 100+ concurrent users.
GitHub