Francis Tarectican — Backend Systems Developer

01 — About

Who I Am

I'm a BSIT student from Palawan, Philippines, studying at Palawan Technological College, Inc. Currently serving as IT Specialist at Bureau of Internal Revenue — RDO 036, Puerto Princesa City. I build web applications with a focus on the backend — how data flows, how systems hold up, and how things work when real people are using them.

I built Mix & Match Kain for a real client, deployed it to a real restaurant, and debugged concurrent-write failures during live service without taking the system offline. That's the standard I hold work to.

Daily development runs a local 30B-parameter coding model on-device via Ollama — GPU-accelerated, no cloud dependency, no data leaving the machine.

Production System

Years Coding

75+

Client Sites

Palawan Based

BS Information Technology

Palawan Technological College, Inc. — Puerto Princesa City

Ongoing

Cisco Networking Academy

Networking · Security · Programming · IT Fundamentals

31 Badges 32 Courses 2025

02 — Evidence

Shipped. Deployed. Verified.

Every capability below is backed by production work, not side projects.

Backend APIs Node.js / Express

Built the full backend for Mix & Match Kain — order recording, payment tracking, and stock updates running on a LAN-only Express server. No cloud required.

ProofMix & Match Kain →

Database Design Schema / State

Designed the data model for carts, orders, payments, and stock under concurrent write pressure in a live restaurant environment.

ProofArchitecture diagram →

Real-Time Operations WebSockets

Handled live order updates and stock sync during active service. Fixed two concurrent-write bugs without taking the system offline while customers were ordering.

ProofProduction incidents →

Frontend Delivery Vanilla JS / HTML / CSS

Built the customer ordering flow and QR checkout interface without a framework. Ran on customer phones over restaurant WiFi with no app install.

ProofView portfolio →

Production Judgment Live debugging

Two bugs fixed during active service. System survived a full internet outage mid-event — local architecture kept orders processing without interruption.

ProofView portfolio →

Client Web Delivery 75+ Sites Shipped

Production websites built for local businesses across the Philippines — restaurants, cafes, retail, and institutions. Custom HTML/CSS/JS, no templates. Each client owns a site built to their operation, not a theme.

ProofView all clients →

Government Systems BIR RDO 036

IT Specialist at Bureau of Internal Revenue — RDO 036, Puerto Princesa City. Maintain internal systems supporting taxpayer data processing across multiple departments. Focus: system reliability, data integrity, and uptime.

2026 — PresentPuerto Princesa, Palawan

Technical Certifications 31 Badges · Cisco NA

32 courses completed across Cisco Networking Academy covering four domains: Networking (Basics, Devices & Config, Network Addressing, Support & Troubleshooting, Network Defense) — Security (Endpoint Security, Cyber Threat Management, Junior Cybersecurity Analyst, Ethical Hacker) — Programming (Python Essentials 1 & 2, JavaScript Essentials, HTML & CSS Essentials) — IT Fundamentals (Computer Hardware, Operating Systems, IT Customer Support, Data Analytics, IoT).

Cisco Networking Academy · 2025 netacad.com ↗

03 — Work

Deployed Work

Full-Stack Web App December 2025

Mix & Match Kain

A food ordering system for a real restaurant in Palawan. Customers order from their own phones via QR code. The Node.js/Express backend runs on a local machine over LAN — serving customer devices through restaurant WiFi with no internet dependency. Built to keep working through connectivity loss.

Production Incidents

Duplicate order writes caused by simultaneous stock updates under peak load — fixed live without downtime.

Full internet outage mid-event — local architecture continued processing orders uninterrupted.

Local-First Architecture QR Checkout Flow Real-Time Order Management Offline Capable

Node.js Express WebSockets Vanilla JS HTML/CSS