Hi, I’m Shua.dev

A recurring Excel dashboard tracking every scholarship trainee through the five EGACE stages — Enrolled, Graduated, Assessed, Certified, Employed — built on lookups against the trainee records so the counts update from one source rather than being tallied by hand.

→ One place to see where a batch stands, instead of five separate counts.

A GitHub Skills challenge completed end to end: an agentic GitHub Actions workflow authored in markdown and compiled to a .lock.yml pipeline. Runs on a daily schedule or on demand with read-only permissions, fetches sources over an explicit network allowlist, keeps its credentials in repository secrets, and returns its change as a draft pull request instead of pushing to main.

→ Triggers, least privilege, secrets and a human review gate.

Two custom Claude Code skills that automate the branch-to-PR loop for teams using Linear with the GitHub integration. Linear links a branch to an issue only by matching the branch name it would have generated itself, so create-feature-branch reproduces that format exactly rather than re-implementing the slug, and create-pr runs the project's checks, summarizes the real diff, and updates an open PR instead of failing on one.

→ Read-only against Linear, so a two-way sync can't produce duplicate issues.

A monthly 2015–2024 dataset for SOCCSKSARGEN, reconciled from DOH-CHD case records, Google Earth Engine rasters and NAMRIA shapefiles, and the forecasting model built on it.

→ 2,918 rows × 19 columns from three incompatible source types. First author of four.

A repeatable pipeline built in Claude: topic and niche validation, source gathering, automated scraping with Firecrawl, claim verification against official documentation and peer-reviewed sources, then an editorial pass for voice and consistency.

→ Ran on every article, so the process stayed auditable and each claim traceable.

A Claude skill that outputs publication-ready drafts directly into Google Docs, so research and publishing meet without a manual reformatting step in between.

→ Removed the reformatting step entirely.

Built at LEADSolutions INC as an on-the-job trainee: a Flutter mobile application for transaction tracking, integrated with the company's existing web system on Azure Cloud so data moved between the two without manual re-entry.

→ Designed the UI/UX as well as the build, from navigation through to cloud integration.

An n8n workflow that polls Gmail every 30 minutes for messages under monitored labels, extracts the metadata, detects attachments, and archives them into a Google Drive hierarchy keyed by label/date/sender while logging one row per email to Google Sheets. Now running on a self-hosted n8n instance, deployed via Docker on a VPS.

→ Duplicate-folder prevention and a read-mark step, so re-runs stay idempotent.

An n8n workflow that takes receipt photos sent through Telegram, runs them through Google Gemini Vision with a receipt-specific prompt to extract merchant, amount and date, archives the original photo to Google Drive by submission date, and logs the extraction with a direct Drive link in Google Sheets. Runs on the same self-hosted n8n instance, deployed via Docker on a VPS.

→ A photo in Telegram becomes a logged, linked Sheets row with no manual entry.

Trainee, programme and scholarship records encoded into T2MIS, TESDA’s national training management information system, plus the compliance documentation behind them and the billing reconciled against government purchase orders.

→ Three vocational programmes kept audit-ready for four years running.

Order-to-receipt system built for Nenita Farm Lechon Haus and Catering Services — React 19 on Vite, Supabase behind row-level security policies, sales trends charted with Recharts, and receipts, daily reconciliation and payroll reports generated as PDFs in-app. Past the point of sale it carries inventory and menu management, staff scheduling, financial reporting and catering bookings.

→ Covers the shop floor end to end: orders, bookings, GCash payments, Senior/PWD discounts, payroll and an offline paper-POS import.

A Looker Studio dashboard consolidating JDVP enrollment reports for participating schools: total enrollment, learner demographics, barangay-level distribution, client classifications and training status in one live view.

→ Enrollment across participating schools read from one dashboard.

A multi-tenant compliance and document tracker for TVIs running TESDA scholarship programmes. Each school’s batches move through the internal lifecycle — AOU, NTP, TIP, Training, Assessment, Billing — while a per-programme document checklist holds every required file at missing, pending, submitted or verified. Clerk handles sign-in for Admin, Coordinator, Trainer and Viewer roles, and Supabase row-level security scopes every query to the signed-in school. Billing documents generate only when the compound gate passes: training progress at or above 80% and every required document verified. It stays an internal working layer by design — official records remain in TESDA’s own SIS, T2MIS and BSRS.

→ Billing gated on verified documents rather than on a calendar date.

Job applications tracked without a spreadsheet. n8n polls Gmail every fifteen minutes, classifies each confirmation or status update with pattern rules, and upserts one row per application into Airtable. Only when the rules fail does an LLM get one attempt, capped at medium confidence so it can never override a rules match. Rows are keyed on company and job title, so a hand-typed entry and a generated one are the same application; a corrected status is never overwritten or regressed, and an email that cannot be classified lands in Needs Review rather than poisoning the feed. An Airtable webhook triggers a GitHub Actions rebuild within seconds, and an hourly health check compares the live n8n instance against the repo and emails when anything is stuck or drifted.

→ A status change in Gmail reaches the live dashboard in under a minute.

A PySide6 desktop tool that takes the verified masterlist and fills TESDA’s T2MIS learner registration form row by row with Selenium — while a human operator reviews and submits every record. Three stages: encoding from a masterlist CSV, enrollment against an enrollees CSV, and offline attendance-sheet generation as DOCX. The CSV preview shows the first 500 rows with a per-row status — queued, filling, review, done, failed — so the operator can see where a run stands, and a legacy CLI is kept for scripted runs.

→ Data entry becomes review-and-submit instead of type-and-check.

A full-stack app for running communities: group runs with distance, pace category and live RSVP headcounts, verified routes on interactive Leaflet GPS maps with elevation profiles, and a filterable club roster carrying pacer badges and session counts. React 19 and Tailwind v4 on the front, Express and Drizzle over PostgreSQL behind it, with Firebase Authentication and Google OAuth handling sign-in.

→ Route discovery, RSVP coordination and club rostering in one app.