Skip to content

Selected Work

Projects

Things I've built — the stack behind each and the details that mattered. Select a card to expand it.

  • Data Engineering2026

    spotify-elt-pipeline

    An end-to-end ELT pipeline that turns personal Spotify listening data into an analytics-ready warehouse.

    • Python
    • PostgreSQL
    • dbt
    • Docker Compose
    • Metabase
    • pytest

    Highlights

    • Extracts personal Spotify listening data through the Spotify Web API in Python, lands it raw in PostgreSQL, and transforms it in-warehouse with dbt.
    • Models an analytics-ready star schema (fact_plays with dim_track, dim_artist, dim_genre, dim_date, and an artist–genre bridge) using layered dbt models across staging, intermediate, and mart layers.
    • Enforces data quality with 39 dbt tests and a pytest suite covering API client units and idempotent loader integration, keeping runs fully replayable.
    View case study
  • Android App2025

    WhatsPackt

    A modular Android messaging app with real-time chat, built on feature-based Clean Architecture.

    • Kotlin
    • Jetpack Compose
    • Coroutines
    • Room
    • Hilt
    • Firebase
    • Firestore

    Highlights

    • Architected the app with feature-based Clean Architecture — distinct auth, chat, create-chat, and profile modules for testability and scalability.
    • Implemented Firebase Authentication with secure username-based sign-up and login, and integrated Firestore for real-time user and chat syncing and message delivery.
    • Built a responsive, modern UI with Jetpack Compose, optimized for performance and accessibility.
    • Used Room for offline message persistence and caching, and Firebase Cloud Storage to back up media and profile assets.