Database and data-science projects, built end to end.

Three self-directed projects exploring relational databases, NLP, and NoSQL alternatives — schema design, data pipelines, and working output for each.

About this work

Each project below explores a different way of storing and working with data — relational design, SQL, and non-relational alternatives — then applies those ideas to natural-language data. Every one started from a concrete goal and ended with something I could run and explain end to end: schema design, data pipeline, and output.

Projects

Three projects — click one to open its write-up.

Project What it does Stack
Celtics25 A relational database for the 2024–25 Celtics starting five, modeled in 3NF, queried with Python, and surfaced as a refreshable Excel PivotTable.
  • PostgreSQL
  • Python
  • Django
Polarity Checker An NLP pipeline that scores sentiment in open-ended survey responses from Arlington's 2050 planning project, then visualizes the results.
  • Python
  • pandas
  • spaCy
Firebase Notes A written tutorial on Firebase's Realtime Database — how a NoSQL, JSON-based store compares to PostgreSQL, and how to connect to one from Python.
  • Firebase
  • NoSQL
  • Python