Jayden Ontalan Capistrano

Data Operations and Systems Analyst

Unstructured data → auditable, decision-ready systems
Tax • IT • Platform migrations

Interests

  • System Design and Data Quality
  • Information Architecture
  • Process and Workflow Design
  • Platform Migrations
  • Project and Program Management
  • Document and Knowledge Systems

Projects

Financial Forecasting & Stress Testing Engine May 2025

Built the backend of a financial forecasting and stress-testing system for a real consulting client. Translated complex and partially broken spreadsheet logic into a validated, testable TypeScript codebase. Implemented multi-year forecasts, scenario-based stress tests, residual impact modelling, and comprehensive edge-case handling.

financial modeling system design testing api design stress testing backend

Read More
Modular Spell Damage Modelling System May 18 - July 19 2024

A modular spreadsheet tool built to model complex spell damage systems in a mobile game. The calculator translates layered game mechanics—items, traits, spell paths, and passives—into accurate, decision-ready outputs, with real-time validation to prevent invalid configurations. Designed for scalability and maintainability as the game’s systems evolve.

data modelling modular design error handling spreadsheets

Read More
Enterprise File & Client Classification System January 2026

Designed an internal file and client-classification system to manage thousands of unstructured financial documents in SharePoint. Built validation logic, naming heuristics, and review workflows to resolve ambiguous client identities, enforce consistency, and prevent downstream audit and retrieval failures. Focused on data hygiene, operational reliability, and human-error mitigation under real enterprise constraints.

data hygiene system design enterprise tooling error handling operational reliability

Read More

Essays

Reflections

AI: A Resource, a Tool, or a Solution

16 Dec 2024

"AI as enablers, not as the solution" ~Jayden 2024 In Academia, I have personally seen a dramatic rise in AI use for student assistance. This is not only found in the Computer Science (CS) major but in multiple majors. In...

Artificial Intelligence Software Engineering

Read More
ICS 314: Software Engineering I

18 Dec 2024

Throughout ICS314, what we worked on was considered web application development. This may seem rather odd in a class titled ‘Software Engineering I’. However, the concepts that we have learned are applicable to more than just web application development. Reflecting...

Project Manapement Coding Standards Design Patterns Software Engineering Web Application Development

Read More
Forecasting Funcitonality in Hindsight

16 May 2025

In ICS 414: Software Engineering II, we worked with a real-world customer–Spire, a financial consulting firm–that wanted to move beyond spreadsheets and toward a web application that could provide forecasts, stress test scenarios, and store data at a company level....

Team Project Web Application Project Management Real-world Project

Read More

Systems Thinking

Memory as Continuity

08 Jan 2026

Introduction The idea did not start with memory theory. It started with excess. A casual conversation about upgrading hardware spiralled into absurd dreams of luxury. Having dozens of servers, massive accelerators, and terabytes of VRAM. At some point, the joke...

Systems Design Memory Architecture Identity Continuity Personal Project Infrastructure Thoughts

Read More