← Erwin Glenn Capitan II View repo

Project summary · Python · PostgreSQL · Streamlit

Fintech Fraud Analytics

A live Streamlit dashboard over 6.3 million simulated transactions in PostgreSQL — built to surface fraud patterns across 6.3M records.

Role
Personal build
Stack
Python · PostgreSQL · Streamlit
Status
Deployed live
Repository
glcapitan / fintech-analytics

Why I built it

Fraud is a rare-event problem, which makes it a good test of whether an analysis holds up when the interesting cases are a fraction of a percent of the rows.

Questions it answers

How I built it

  1. Load and model. The PaySim dataset lands in PostgreSQL with the query patterns the dashboard needs designed in up front.
  2. Analysis in Python. Transaction-type breakdowns and behavioural comparisons between flagged and clean records.
  3. Streamlit front end. An interactive dashboard deployed publicly on Streamlit Community Cloud rather than left as a notebook.
  4. Hosting migration. Moved the database from Supabase to Neon after hitting free-tier limits — a real constraint, handled rather than worked around.
Streamlit dashboard — executive overview
Streamlit dashboard — executive overview
Data flow from PaySim to the dashboard
Data flow from PaySim to the dashboard

How I know it works

Honest notes

Built on the public PaySim simulated mobile-money dataset.