Billy James Ramos

ICT Systems Developer & Full Stack Engineer

BS in Computer Science (Magna Cum Laude) from Centro Escolar University. Building scalable web systems, database architectures, and applied AI & RAG solutions.

Resume

Contact

Projects

Showcasing impactful software applications and open-source systems.

PSGC API & Interactive Dashboard

Next.js dashboard and public REST API for the Philippine Standard Geographic Code (PSA PSGC) covering 42,010 barangays, 1,493 municipalities, 149 cities, 82 provinces, and 18 regions with staged quarterly updates.

Full Stack

Web Dev

Frontend

Schema Atlas - Database Architecture Studio

Local-first database architecture studio and interactive ERD canvas for visual schema design, inspection, Prisma import/export, and PostgreSQL SQL generation.

Full Stack

Web Dev

UI/UX

CourtScribe AI

Mobile-first live transcription and digital stenography PWA tailored for Philippine court hearings, legal proceedings, and interviews with 5-second crash checkpoints and RA 10173 compliance.

Mobile Dev

Applied AI

Web Dev

UI/UX

Experience

Professional journey, career timeline, and educational background.

ICT Systems Developer - CoS

Civil Service Commission•Quezon City / Taguig, Philippines

2025 - Present

Designed, developed, and maintained internal websites, administrative web applications, and AI chatbot systems to support institutional digital transformation.

Next.jsReact+6 more

View Details

Digital Education Coordinator

Taguig City Hall - Mayor's Office•Taguig City, Philippines

2024 - 2025

Collaborated with IT and education teams to evaluate, align, and deploy digital education solutions across municipal programs.

JavascriptTypescript+3 more

View Details

Software Engineer Associate Intern

Rakso CT•Makati City, Philippines

2024 - 2024

Conducted day-to-day project coordination and feature implementation across cross-functional engineering teams.

ReactJavascript+4 more

View Details

Contributions

Open-source projects, tools, and technical resources.

psgc-api

Public REST API & interactive dashboard for the Philippine Standard Geographic Code (42,000+ barangays, 1,493 municipalities).

rbillyjames0221

schema-atlas

Local-first visual database architecture studio with interactive ERD canvas, Dagre auto-layout, and Prisma/SQL sync.

rbillyjames0221

courtscribe-ai

Mobile-first live transcription & digital stenography PWA tailored for Philippine court hearings with crash-safe IndexedDB audio.

rbillyjames0221

Blogs

Articles and notes on full-stack development, database architecture, and applied AI.

Next.jsTypeScriptREST API+2

Architecting a High-Performance PSGC REST API & Next.js Explorer for 42,000+ Barangays

How I designed a verified, staged quarterly data pipeline and interactive explorer for the Philippine Standard Geographic Code (PSA PSGC).

October 24, 2026

DatabasePrismaPostgreSQL+2

Schema Atlas: Building a Local-First Database Architecture Studio

Deep dive into designing an interactive ERD canvas with Dagre auto-layout, bi-directional Prisma schema parsing, and SQL DDL synchronization.

October 22, 2026

Applied AIPWAWeb Speech API+2

CourtScribe AI: Engineering Resilient Live Transcription for Court Hearings

Developing a crash-resilient audio ingestion pipeline with 5-second IndexedDB checkpoints, bilingual recognition, and judicial role tagging.

October 20, 2026

Skills

Technical competencies, programming languages, and tools.

Next.js

Build high-performance full-stack web applications with App Router, server actions, and SSR.

TypeScript

Develop type-safe, maintainable, and scalable enterprise applications with strict static typing.

React

Craft reactive and intuitive user interfaces using modern hooks, state management, and reusable components.

Python

Implement backend services, AI data pipelines, RAG ingestion scripts, and Flask applications.

Retrieval-Augmented Generation (RAG)

Build production RAG pipelines, semantic document chunking, embeddings, and context-grounded AI chat systems.

Node.js

Engineer fast and scalable server-side APIs, microservices, and asynchronous event-driven backends.