Vol. II — The Broadsheet

The Whole Stack,One Byline.

Full systems, shipped solo — in days, not months.

By Xier Gabriel Mangunay

Read the WorksClassifieds
Print resume
Top StoryRoute planning drops from 20 minutes to two — Sec. B, below
NEXT.JSREACT NATIVEPYTHONSUPABASETAILWIND CSSTYPESCRIPTDUCKDBEXPOOPENSTREETMAPAIRTABLEVERCELNEXT.JSREACT NATIVEPYTHONSUPABASETAILWIND CSSTYPESCRIPTDUCKDBEXPOOPENSTREETMAPAIRTABLEVERCEL
Section B / Project archive

The Works

Selected systems, field notes, and independent builds.

Edition below ↓

Field Reports

Sec. B · Shipped & Shipping
From the Firm — a three-part featureThree systems for one land-investment firm: the storefront, the demand engine, the field logistics.
From the Firm · 1 of 3Live

The Storefront Runs Itself

A bilingual land-listings site where a new property goes from MLS sheet to published page in under two minutes.

Terra Prime Lots · Real Estate Website

A bilingual (English/Spanish) real-estate listing website where property listings update automatically through Airtable and Zapier. A companion tool extracts property details from MLS sheets and drafts near-complete listings — cutting upload time from 30 minutes to under two.

30→2
Min per listing
EN/ES
Fully bilingual
Next.jsTailwind CSSAirtableZapierCloudinaryVercel
Visit Site
Terra Prime Lots listing website front page
The storefront: listings publish themselves from Airtable.Press photo
From the Firm · 2 of 3In Production

Mail Engine Returns 6× on Spend

Weeks of manual list-building, replaced by a pipeline that runs in minutes.

Automated Mailing System · Data Engineering

An automated system that generates targeted mailing lists for a real estate land acquisition company. Replaced a slow manual process that took weeks with one that runs in minutes. Within the first batch of mailers, it pulled in 6x return on mailing costs and landed 24 signed contracts across 6 regions — all from a $27K spend that projected to $169K in profit.

6x
Return on Spend
$169K
Projected Profit
24
Contracts Signed
PythonDuckDBPandas
From the Firm · 3 of 3Internal Tool

Route Planning Drops From 20 Minutes to Two

Google Maps has no concept of a ‘busy intersection.’ OpenStreetMap knows where every traffic light is.

Field Route Generator · Geographic Marketing Logistics

Field teams place roadside signage along driving routes — and planning each route by hand took about twenty minutes in Google Maps, with no memory of where signs already were. This tool plans a full-day tour that visits every selected property, mining OpenStreetMap for the intersections where drivers actually stop, and exports the day as a chain of shareable map links. Three routing algorithms failed before the fix: reverse-engineering the field crew’s real hand-built routes into the model. Route memory keeps new tours clear of recent placements — and the whole thing was planned, built, and shipped solo in a day with an AI-assisted workflow.

20→2
Min per route
$0
New infrastructure
60
Stops per day
Next.jsTypeScriptOpenStreetMapOSRMGoogle Maps API
Route generator web app showing a mapped field tour with numbered stops
A generated field day: numbered stops, mapped and chained into shareable links.Staff photo
For commissions & inquiries — see Classifieds, below ↓
Independent PressBuilt solo, off the clock.
Independent PressBeta

A Back Office in Every Vendor’s Pocket

Contracts, invoices, and bookings for Philippine event vendors — with AI doing the data entry.

Momento · Event Management App

A mobile app for Philippine event vendors — photographers, caterers, coordinators — to run their business. Scan a client chat screenshot and it auto-fills event details using AI. Generate contracts, invoices, and quotations as PDFs, sync with your phone calendar, and manage clients in one place.

Desk notes

  • Client chat screenshot → structured event record
  • Contracts, invoices, and quotations generated as PDFs
  • Calendar, payment, client, and follow-up tracking in one place
React NativeExpoSupabaseNativeWind
Momento mobile dashboard showing upcoming events, payments, and follow-ups
The vendor dashboard: bookings, payments, and follow-ups at a glance.App still
Independent Press · Campus DeskDeployed

Lab Borrowing Leaves the Spreadsheet

Requests, approvals, and returns in one system for a university health-sciences laboratory.

CHS Inventory System · Lab Equipment Management

A web app built for a university’s College of Health Sciences to manage lab equipment borrowing. Students submit requests, instructors approve them, admins track everything. Replaced a Google Sheets and Forms setup that was hard to maintain.

Next.jsSupabaseshadcn/uiTailwind CSS
Visit Site
CHS Inventory System web app
Requests in, approvals out — no more spreadsheet wrangling.Press photo

In Brief

Flood Prediction Study

Research

Machine Learning Research

Comparative study using ML algorithms and Philippine flood data. Coordinated with government agencies (DPWH, PAGASA, MMDA, NAMRIA) for datasets. Used GIS for spatial analysis.

Python · Machine Learning · GIS

Pandalivery

Prototype

Live Auction App Design

A Figma prototype for a live-stream auction platform aimed at micro and small businesses in the Philippines.

Figma · UI/UX Design · User Research

Your Project HereInquire within — see Classifieds
End of Section BXGM / Vol. II
Section C / Personnel fileStatus: Active

The Developer

The person behind the systems: methods, milestones, and the tools currently on the desk.

Personnel File

Sec. C · Subject Profile
Xier Gabriel Mangunay smiling at a restaurant table
Exhibit C-01 · Subject portraitOn file

Subject / Lead operator

Xier Gabriel Mangunay

Software engineer, systems builder, and the person behind every byline in this edition.

I'm a software engineer from the Philippines. I build production systems that replace manual work: automated data pipelines, internal tools, mobile apps, and web platforms with real users behind them.

Since January 2026, I've run marketing and systems for a US land-investment firm while also operating as its entire engineering department. I plan, build, deploy, and maintain the full path from business problem to working software.

“I turn manual work into working software.”
Role
Marketing & Systems Manager
Current desk
January 2026 — Present
Base
Ocampo, Camarines Sur, PH
Education
BS Computer Science · 2024
Practice
AI-assisted · End to end
Availability
Open to commissions & inquiries

Career Record

Verified milestones only
  1. 2024

    Foundation

    Earned a BS in Computer Science from Ateneo de Naga University.

  2. JAN 2026—NOW

    The Firm

    Runs marketing and systems for a US land-investment firm while serving as its entire engineering department.

  3. OFF THE CLOCK

    Independent Press

    Builds independent products and operational tools, including Momento and the CHS Inventory System.

Operating procedure

How I Work

Start with the operation, finish with evidence that the new system is better.

  1. 01

    Investigate

    Observe the real workflow, find the repeated friction, and define the constraint worth removing.

  2. 02

    Map the system

    Turn loose steps into data, rules, handoffs, and one measurable outcome.

  3. 03

    Build

    Ship the complete path—from interface to automation and deployment—while keeping infrastructure lean.

  4. 04

    Measure

    Watch time, revenue, errors, and real usage; then tighten the system around what the evidence says.

Current Desk

Web

  • Next.js
  • TypeScript
  • Tailwind CSS

Mobile

  • React Native
  • Expo
  • NativeWind

Data & Automation

  • Python
  • DuckDB
  • Pandas
  • Airtable

Backend & Delivery

  • Supabase
  • Vercel
  • Cloudinary
  • APIs

Off the clock

A little life outside the terminal keeps the work observant, tactile, and human.

TravelingFilm PhotographyCooking

Classifieds · Sec. D

Developer Available — Inquiries Within

Full-stack builds, data pipelines, mobile apps. One engineer, team-sized output. Replies fast.

Emailxier.mangunay@gmail.com
Phone(+63) 9175062212
LinkedInlinkedin.com/in/xiergm
Place an inquiry