Selected Projects

Personal Portfolio Site

Vite 6 · Three.js · GSAP + Lenis

• Built and shipped to production two independent, framework-free Vite static sites with custom Three.js WebGL hero scenes and a shared GSAP/Lenis animation pattern
• Diagnosed a silent CI/CD deployment failure across two production pipelines, isolating a CDN-fronted hostname as root cause and restoring 100% deploy success
• Architected path-filtered, per-site GitHub Actions pipelines so unrelated site changes trigger zero cross-site rebuilds

Shoshin Systems — Agency Site

Vite 6 · Three.js · GSAP + Lenis

• Second independent site in the same path-filtered monorepo, deployed to a custom domain with zero shared runtime dependencies from the portfolio site
• Established a credentials-and-infrastructure runbook decoupling all secrets from source control while keeping deployment topology documented and reproducible
• Added a new privacy-policy page through the existing CI/CD pipeline with zero pipeline changes

CHMF Healthcare & Accounting System

Python · Django · PostgreSQL · QODBC

• Architected an enterprise in-house healthcare and accounting system from scratch for a medical cooperative federation, with a service-layer architecture separating business logic from controllers and models
• Implemented double-entry accounting with atomic transactions, debit/credit validation, and a Draft → Approved state machine with idempotency keys
• Solved a legacy 32-bit QuickBooks Desktop + Python integration via the QODBC driver, building a Chart-of-Accounts sync pipeline

Internal enterprise system — no public link

Republika Steel — Inventory & Admin Panel

Ruby on Rails · MySQL · Render

• Built a sales invoice and inventory admin panel with role-based access control and PDF invoice generation
• Deployed to production on Render with a Rails + MySQL stack

Private system — no public link

SmartResume — AI-Powered Resume Builder

FastAPI · Next.js 16 · React 19 · TypeScript

• Built an AI-powered resume builder with a knowledge-base system (profile, experience, education, skills, projects, certs), job URL scraping, fit scoring, and tailored resume/cover-letter generation
• Migrated the app from a shared-secret auth model to real per-user accounts — password hashing, DB-backed sessions, and per-user encrypted API-key storage across every table and router
• Fixed a live concurrency bug where AI provider credentials were read from a process-global environment variable shared across concurrent requests from different users

TCG Arbitrage Explorer

Next.js 16 · TypeScript · Prisma 7 + PostgreSQL · Playwright · Cheerio

• Designed a three-tier price-scraping fallback pipeline (headless-browser scrape → static HTML parse → cached snapshot) with heuristic DOM-candidate scoring, keeping the dashboard populated despite a third-party site with no public API
• Modeled a weighted arbitrage-scoring system in Prisma/PostgreSQL exposed through an aggregated dashboard API computing leaderboards and top movers over hundreds of tracked card pairs in a single request
• Implemented a scheduled background sync job (node-cron) that selectively refreshes only stale records, bounding scrape load to the stale subset of the catalog

Built, pending deployment — v2 architecture (Prisma/PostgreSQL, scheduled sync) rebuilt on this same concept

PSE Stock Compass

Next.js 16 · TypeScript · Cheerio · lightweight-charts

• Engineered a resilient data pipeline scraping the Philippine Stock Exchange with a three-tier fallback chain (disk cache → live scrape → static snapshot) guaranteeing near-100% uptime
• Built a composite financial health-scoring engine synthesizing earnings trends, debt-to-equity ratios, valuation multiples, and dividend sustainability into a single weighted score
• Designed a fault-tolerant Cheerio-based scraping layer with fuzzy label matching across 200+ listed companies with no per-ticker configuration

Built, scrapped for now — revisit post-September 2026

Only10 (ReelsCreator)

TypeScript · Node.js · Express · Puppeteer · FFmpeg

• Architected an end-to-end short-form video generation pipeline converting structured JSON content into rendered 1080x1920 MP4 reels with no external rendering service
• Solved deterministic frame-accurate video capture by pausing and manually stepping CSS Web-Animations time in headless Chrome
• Generated 2,016 real rendered video outputs proving a production-grade pipeline, not a prototype

Built, pending deployment

SkillStack Certification Tracker

Next.js 16 · React 19 · TypeScript · Recharts

• Architected a zero-backend certification-tracking dashboard using browser localStorage as the sole persistence layer, eliminating server infrastructure and hosting cost
• Built a weighted ROI-scoring engine ranking certifications across four independent axes, driving sorting, filtering, and a "Top 5" recommendation widget
• Designed a byte-accurate storage-guard system preventing silent browser-storage quota failures

Premium Video Downloader

FastAPI · yt-dlp · curl-cffi · React 19 + Vite

• Built a full-stack video retrieval service abstracting yt-dlp's raw multi-format output into a filtered, client-ready API
• Resolved a platform-compatibility blocker by integrating curl-cffi TLS/browser impersonation to unblock downloads against bot detection
• Implemented correct binary file delivery with RFC 5987-compliant filename headers

Built, pending deployment

Claude Usage Widget

Python 3 · PySide6 (Qt6) · keyring · pytest

• Re-architected a Windows-only desktop app into a fully cross-platform Qt client, replacing OS-specific credential storage and autostart mechanisms with unified APIs for Windows, macOS, and Linux
• Directed a structured, review-gated engineering process that surfaced and resolved a dozen-plus concurrency defects — including fatal thread-destruction crashes and a spoofable cookie-domain validation bug — before they reached end users
• Built a 76-test automated suite from zero coverage for a previously untested GUI application, validating threading and state-mutation logic headlessly with no physical display

Built — cross-platform release candidate

Content Guard

Chrome Extension · Manifest V3 · declarativeNetRequest

• Built a Manifest V3 Chrome extension enforcing network-level content blocking via declarativeNetRequest, eliminating reliance on deprecated blocking APIs ahead of Chrome's MV2 sunset
• Designed a dynamic rule-sync system scaling user-managed blocklists from a static 2-entry set to 500 concurrently enforced domains
• Audited the store listing and default configuration against platform disclosure policy before submission, correcting a metadata-transparency gap