Alfie Pelicano

Full-Stack Developer

Building tools that actually solve problems

GNSS geodesy data wrangler turned full-stack developer โ€” because precision scales better with code. Tracking how the ground moves and building web apps have more in common than you'd think: both demand accuracy, patience, and a taste for solving problems most people never notice. I create practical, human-centered tools for everyday challenges โ€” parking chaos, lab bookings, and affordable math worksheets that make teachersโ€™ lives easier.

Featured Projects

Where precision scales with code โ€” real tools solving real-world problems

๐Ÿ”ฌ
In Production

PipetGo

A B2B marketplace connecting companies with ISO 17025-certified laboratory testing services across the Philippines.

Problem: Businesses had no centralized source for accredited labs โ€” data was scattered, outdated, and often missing accreditation details.
Solution: A searchable, filterable directory with quotation features that directly connects certified labs and clients through verified profiles.
Stage: Currently undergoing User Acceptance Testing with initial partner organizations before pilot deployment.
Next.js 14 TypeScript Prisma NextAuth Zod Vitest
๐Ÿš™
In Production

Carpool Coordinator

A community carpooling platform that helps residents post and coordinate ride shares with live updates and vehicle info.

Problem: Carpool plans were managed in chat threads โ€” easy to lose track of, and difficult to match riders by time or route.
Solution: A structured posting system with schedule matching, vehicle details, and interest tracking for organized community rides.
Impact: Deployed on Render for a residential group; improved participation rates and reduced coordination time for parents and commuters.
Node.js Express PostgreSQL Vanilla JS Playwright
โž•
In Production

Window Cards Generator

A printable math worksheet generator for multi-digit arithmetic, designed for SPED and early-grade classrooms.

Problem: Teachers needed customizable math materials without recurring costs from commercial workbook sets.
Solution: A browser-based generator that prints reusable arithmetic worksheets on demand, adjustable by range and operation type.
Impact: Used in classrooms for SPED and early learners โ€” providing a free, flexible alternative to paid materials.
Vanilla JS HTML5 CSS3 Print CSS
Washboard dashboard showing real-time queue management with customer bookings
๐Ÿšฟ
In Production

Washboard

Car wash queue and booking system that replaces pen-and-paper operations with contactless QR bookings and a real-time dashboard.

Problem: Paper-based queue tracking offered zero visibility, required manual position management, and caused long waits during peak hours.
Solution: Contactless QR bookings combined with a receptionist dashboard that provides live queue updates, position reordering, magic-link check-ins, and status tracking.
Impact: Production-ready (130/130 tests passing, 94/100 security score); piloting with car wash operators to refine real-world workflows.
Next.js 14 React 19 TypeScript PostgreSQL Passport.js Vitest
๐Ÿ“‚
Active Development

Drive Archaeologist

Python CLI for excavating and organizing legacy GNSS (GPS) data from old drives with inconsistent file structures.

Problem: Decades of GNSS data scattered across drives: random directories, duplicates, and missing metadata โ€” making retrieval and reuse difficult.
Solution: Automated scanner that detects GNSS file types (RINEX and others), extracts metadata, flags duplicates, recommends reorganization, and generates safe migration scripts.
Stage: Phase 1/4 โ€” foundation scanning and classification; built for geodesists managing legacy scientific archives.
Python 3.11+ Click CLI Rich Terminal Pandas Pytest
๐Ÿค–
Active Development

NightCoder Orchestrator

Python-based automation engine that reads ADRs, generates structured implementation plans, and produces git-style patches using local LLMs (via Ollama).

Problem: Engineering tasks tied to ADRs required repetitive planning and manual patch authoring across multiple repos โ€” slow, error-prone, and inconsistent.
Solution: A multi-agent runner that scans ADRs, synthesizes a step-by-step plan, generates patches, logs runs, and optionally applies changes through a safety-gated workflow.
Stage: Phase 2/4 โ€” stable planner/coder loop; refining patch validation and multi-repo robustness.
Python 3.11+ Ollama deepseek-r1 (1.5B) qwen2.5-coder (1.5B) Subprocess / Shell Scripts JSON Config Markdown ADR Parsing
๐Ÿ“„
Active Development

SciWriter Orchestrator

Automated writing pipeline that converts research notes into structured drafts โ€” with refinement passes, terminology checks, LaTeX export, and optional slide generation.

Problem: Drafting scientific manuscripts from scratch is slow, inconsistent, and prone to terminology drift across revisions.
Solution: A configurable multi-stage workflow that generates a draft, performs iterative refinement, normalizes terminology, and outputs LaTeX or slide formats.
Stage: Phase 2/4 โ€” pipeline functional with draft/refine/terminology steps; improving LaTeX and slide output consistency.
Python 3.11+ Ollama qwen2.5 (3B Instruct) Shell Script Pipeline LaTeX / Beamer Terminology DB (JSON) Config-Driven Workflow

Technical Skills

Frontend

  • Next.js 14 (App Router)
  • React 19 (Server Components)
  • TypeScript
  • Vanilla JavaScript
  • Tailwind CSS
  • shadcn/ui

Backend

  • Node.js / Express
  • Next.js API Routes
  • Prisma ORM
  • NextAuth.js / Passport.js
  • Zod Validation

Database & Infrastructure

  • PostgreSQL (Advanced SQL)
  • Neon (Serverless)
  • Supabase

Python & Automation

  • Python 3.11+
  • Click CLI / Rich Terminal
  • Pandas (Data Processing)
  • Pytest (Testing)
  • Shell Scripting
  • Ollama (Local LLMs)

Testing & Quality

  • Playwright (E2E)
  • Vitest (Unit)
  • Pytest (Python)
  • Git Workflows

Tools & Workflows

  • AI-assisted Development (Claude Code, ChatGPT) - for test and data generation, refactoring, and debugging
  • LaTeX / Beamer
  • ADR-driven Architecture
  • Linux / Bash

About Me

I used to work with GNSS data to study how the Earth shifts โ€” during earthquakes and in the quiet, gradual movements between them. Now I build web apps, but the mindsetโ€™s the same: precision, spatial reasoning, and an appreciation for complex systems (looking at you, CSS Grid).

My philosophy is simple: build things that solve real problems for real people. No moonshot hype or blockchain detours โ€” just thoughtful tools that make everyday work a little smoother.

I believe in:

  • Test-driven development โ€” if itโ€™s not tested, itโ€™s not done
  • Systematic problem-solving โ€” big problems get smaller when you break them right
  • Clear documentation โ€” your future self deserves clarity
  • Practical design โ€” tech should help people, not just impress developers

When Iโ€™m not coding, Iโ€™m helping my kids with homework or automating something that probably didnโ€™t need automating โ€” because curiosity doesnโ€™t switch off after work.

Let's Connect

Building something interesting? Need a developer who actually ships?
Let's talk.