Ayon Rahman

Data Engineering & Analytics

Hi, I'm Ayon Rahman.

Computer Science student at UMBC. I build reliable data pipelines, clean relational models, and tools that turn messy real-world data into something people can actually trust.

📍 Baltimore, MD  ·  Open to data engineering / analytics internships

01 About

I care about correctness and good schema design — the unglamorous work that makes data trustworthy. My focus is the full path from raw source to usable insight: modeling the data, writing performant SQL, and building ETL that cleans and validates instead of blindly loading.

Most of my projects come from real problems. My most recent one replaced a fragile stack of shared spreadsheets with a single app that flags bad data before it can cause a mistake — because when a system is used to charge people, "close enough" isn't good enough.

Education — B.S. Computer Science, University of Maryland, Baltimore County (UMBC) · Expected May 2027. Coursework: Data Structures, Database Management Systems, Design & Algorithms, Linear Algebra, Statistics.

02 Technical Skills

Languages & Query

  • Python
  • SQL
  • PostgreSQL
  • C++
  • JavaScript

Data & Analytics

  • Pandas
  • NumPy
  • ETL Pipelines
  • DBMS / Data Modeling
  • Tableau
  • Power BI
  • Excel

Frameworks & Tools

  • Flask
  • Streamlit
  • React
  • Node / Express
  • Docker
  • Railway
  • Git / GitHub

03 Featured Projects

MoneyMate — Personal Finance App

Turns ~1,500 raw bank transactions into a live budget — and matches real payroll tax to the penny.

A mobile-first finance app that runs from a single dependency-free HTML file. A Python pipeline parses bank statements and a Chase CSV export, keyword-categorizes ~1,500 transactions, detects recurring subscriptions, and reconciles the running balance exactly. Ships with a 2026 Maryland payroll-tax engine that handles the F-1 nonresident (FICA-exempt) case — validated to the cent against real pay stubs — plus budgeting, savings goals, analytics, and pay-stub reconciliation.

  • JavaScript
  • Python
  • Pandas
  • ETL
  • localStorage
  • GitHub Pages

Temp Card Tracker

Catches bad roster data before it can cause a billing error.

A full-stack app that replaces juggling multiple Google Sheets for temporary room-access key cards. A one-way ETL pipeline cleans a messy multi-tab roster, a reference-set classifier resolves free-text cells (fuzzy staff matching, broken date formats, junk detection), and a data-quality report flags bad entries before they cause billing errors.

  • React
  • Express
  • SQLite
  • ETL
  • SheetJS

Workout Analytics & Recommendation Engine

4,500+ rows of raw data → progression insights and real-time weight/rep targets.

An end-to-end ETL pipeline processing 4,500+ rows of strength-training data into a relational SQLite database — surfacing progression trends, stall detection, and volume insights across 161 sessions via 7 interactive Plotly dashboards. A Flask REST API on Railway serves a real-time engine that prescribes weight/rep targets using Epley's e1RM and double-progression logic.

  • Python
  • Flask
  • SQLite
  • Plotly
  • ETL
  • Railway

UMBC Parking Management System

Eliminates 100% of double-booking conflicts under concurrent load.

A production-hardened relational database that automates campus parking operations — from real-time sensor ingestion and permit enforcement to automated citation billing. Eliminates 100% of double-booking conflicts under concurrent load using per-spot advisory locks, and ships as a one-command Docker stack (PostgreSQL + Streamlit + pgAdmin) that auto-loads its schema and seed data on boot.

  • PostgreSQL
  • PL/pgSQL
  • Streamlit
  • Docker
  • Concurrency
  • Python

Demo login password: admin

04 Experience

Summer Conference Assistant

Events & Conferences, UMBC

May 2026 – Aug 2026 · Baltimore, MD

  • Built an internal temp-card tracking web app (React / Express / SQLite) that replaced multiple shared spreadsheets and flags roster data errors before they affect billing.
  • Secured campus building integrity by auditing administrative database logs for high-volume guest processing and electronic room-access programming.
  • Resolved 100% of operational logistics issues and guest emergency responses for 500+ summer conference guests by managing real-time facilities data.
  • Sustained a 99% hospitality satisfaction score through standardized, data-logged room inspections and guest-service compliance audits.

Co-Founder

Boomerang BD

Apr 2021 – Jan 2024 · Dhaka, Bangladesh

  • Expanded e-commerce revenue by $3,000+ within the first 90 days by analyzing historical sales and inventory-turnover metrics to optimize pricing strategy.
  • Scaled a digital community to 20K+ followers by building an analytical tracking system for social-media engagement to refine demographic targeting.
  • Reduced order-fulfillment cycles by 15% by streamlining logistics pipelines and automating order-tracking data entry.

05 Get in touch

I'm open to internships and collaboration in data engineering and analytics. The fastest way to reach me: