Quick summary

Current role

Data Quality Analyst, Citibank
Oct 2025 – Present

Education

MS Analytics, Georgia Tech (2026–28)
BS Computer Science, UP Diliman cum laude

Core skills

Python · SQL · Pandas · Power BI · Next.js · AI workflow automation

Looking for

Data analyst and data scientist roles

Download résumé (PDF)

Open to opportunities · Manila, PH

Ezra Guiao

Data Quality Analyst @ Citibank · Data Science · Full-Stack

I make data tell the right story.

Résumé (PDF) Email GitHub LinkedIn

1M+

account applications risk-scored

35k+

survey records analyzed

10+

shipped projects

92%

processing time cut by automation

NowData Quality Analyst, Citibank
NextMS Analytics, Georgia Tech · 2026–28
DegreeBS Computer Science, UP Diliman · cum laude

I'm a CS graduate who sits at the intersection of data and finance.

Whether it's building predictive models in Python or shipping interactive dashboards with Power BI, I care about the question behind the analysis. I've worked with large-scale survey data, financial scrapers, and spatial flood simulations.

With my previous experience in software engineering, I can not only interpret data into business decisions, I can also build and maintain the data pipelines underneath them.

$ cat looking-for.txtWhat I'm looking for

Roles: Data Analyst · Data Scientist · Analytics Engineer
Domains: Finance, risk, and fraud — where I already have production experience
Based in: Manila, Philippines · open to remote and hybrid
Strengths: Owning a problem end to end: pipeline, model, dashboard, and the stakeholder call

Get in touch Résumé (PDF)

README.md

ezra-guiao / portfolio.sys

My portfolio, laid out as the workspace I actually work in. Click any file in the explorer. The terminal works, and every project links out to the code or the paper behind it.

How to explore

▤about.md — who I am and what I build
●resume.pdf — the one-pager, readable right here
{}projects.ipynb — four projects worth your time, with the numbers
▤experience.log — Citibank, Pointwest, Ayala Health, Bit Create, plus education
{}skills.json — every skill paired with where I actually used it
▤archive/ — earlier work, all of it still here
>_terminal — try help, git log, or open projects
⌘⌘K — jump to anything

or click any file in the explorer

Not into IDEs? Toggle recruiter mode in the top bar for plain-English everything.

Résumé

one page · updated 2026

Download PDF Open in new tab ↗

One-page résumé — experience, education, skills and projects.
Open résumé (PDF)

Projects

featured · the archive holds the rest

PSEye

Market intelligence · 2025

2,500 monthly visitors

A live market intelligence platform covering 282 PSE-listed companies — market map, portfolio and watchlist tracking, dividend history, and foreign fund flow. I designed the daily ingestion pipeline and the unified schema that standardizes inconsistent exchange sources into a single queryable model, powering an automated market recap.

ImpactLive product with real users, not a demo — 2,500 monthly visitors and full coverage of the exchange.

coverage282 / 282 listed

ingestiondaily · automated recap

status● live at pseye.site

Next.jsTypeScriptPostgres (Neon)Vercel

Live ↗

Flood Modeling & Visualization System

Hydrology · Simulation · 2024

NCTS-funded thesis

A geospatial flood simulation built as my undergraduate thesis under an NCTS-funded research initiative. Applies shallow water equations and RK2 numerical integration with cellular automata to model flood progression, infiltration rates, and critical flow thresholds across Philippine river systems, optimized with Numba JIT. Derived flood risk thresholds from rainfall and flow analysis for disaster risk assessment.

ImpactFunded undergraduate research, and the thresholds it produced are usable for real disaster risk planning.

methodshallow water equations · RK2

terrain scenariosmultiple, Philippine river systems

outputflood risk thresholds

fundingNCTS research initiative

PythonNumPyNumbaQGISMatplotlib

Code ↗ Paper ↗

Bank Fraud Risk Scoring

Finance · Fraud detection · 2024

6.56% top-tier fraud rate

A composite fraud risk score engineered over 1M+ bank account applications from the NeurIPS 2022 dataset. I analyzed feature distributions and fraud rates to isolate high-signal predictors, segmented applicants into risk tiers, and surfaced the result in an interactive Power BI dashboard. The top tier carries a 6.56% fraud rate — roughly 6× the portfolio average.

ImpactTurned 1M+ raw applications into a tiered screening rule a reviewer can act on.

top risk tier6.56% fraud rate

vs. portfolio average~6x higher

applications scored1,000,000+

PythonPandasPower BI

Perception Mapping of HIV Awareness in the Philippines

Public health · EDA · 2023

35k+ households

Analysis of NDHS 2022 survey data from over 35,000 households to quantify HIV knowledge and awareness. I engineered a composite perception metric and visualized the patterns disaggregated by region, age, and education level.

ImpactReduced a 35,000-household national survey to one comparable perception metric.

datasetNDHS 2022

households35,000+

disaggregated byregion · age · education

outputcomposite perception metric

PythonPandasPlotlyJupyter

Code ↗ Site ↗

Five more projects live in archive/ — Acoustify, the PSE Terminal, NBA playoff prediction, an xv6 scheduler, and Ugnayan.

Experience

most recent first

Oct 2025 – Present

Data Quality Analyst · Citibank

Owned data remediation (onboarding) change requests end to end, from scope submission and FRD through deployment and post-release monitoring.
Served as primary liaison between stakeholder teams across APAC and NAM, reviewing change requests and running calls to resolve clarifications and drive approvals.
Coordinated UAT and test validation through Jira, tracking defects to production sign-off.
Automated data validation workflows using Stylus and AI prompts, reducing processing time by 92%.
Volunteered to migrate legacy systems to SharePoint, reducing retrieval time and streamlining data validation.
Won a firm-wide prompt engineering competition, building a business recommendation from a live case scenario and presenting to executive leadership as the sole Officer-level competitor among VPs.

Jul 2024 – Aug 2024

Software Engineer Intern · Pointwest

Led UI/UX design and system architecture for an internal employee skills inventory platform, working with a 10-person engineering team; secured C-suite approval for company-wide adoption.
Built and optimized Angular and Bootstrap components, improving load time, consistency, and reliability.

Jul 2022 – Sept 2022

Data Analyst Intern · HealthNow (Ayala Health)

Optimized data pipelines and standardized cross-company database integrations, improving data consistency, scalability, and analytics efficiency.
Analyzed 500K+ user profiles and transaction records using Pandas and MySQL to shape audience targeting.

Jun 2022 – Aug 2022

Software Engineer Intern · Bit Create

Developed and deployed client websites using Vue.js, focusing on responsive design and maintainability.
Planned and designed the UI/UX of a real estate website and handled its back-end services.