Projects

Projects

A dashboard-style table of case studies. Click a row to open the full project walkthrough.

Projects Table

Project Description Tools Used Architecture Links
Retail Sales Analytics Pipeline This project is built on a public warehouse and retail alcohol sales data published by Montgomery County, Maryland Alcohol Beverage Services (ABS). The dataset includes monthly, category-level sales and distribution records, enabling full ETL development, BigQuery warehousing, and analytical KPI modeling.
Python logo Python
BigQuery logo BigQuery
SQL database SQL
Looker Studio logo Looker Studio
GitHub logo GitHub
Source → Batch ETL → BigQuery → KPI view → Looker Studio
View GitHub Source
Energy Net Metering This project builds an end-to-end ETL pipeline using public energy net metering data from the U.S. Energy Information Administration (EIA). Data is extracted via API, transformed with Python, and loaded into BigQuery to support analytical views and KPI reporting. The pipeline enables analysis of net metering adoption trends across U.S. states and territories over time.
REST API REST API
Python logo Python
BigQuery logo BigQuery
SQL database SQL
Looker Studio logo Looker Studio
GitHub logo GitHub
Source → API → ETL → BigQuery → Looker Studio
View GitHub Source
Reservation App This project is a real-time restaurant reservation application backed by an Oracle relational database. The front end communicates with a REST API to manage seat availability, enforce capacity rules, and prevent double bookings. Reservation state is persisted in Oracle tables and reflected immediately on an interactive seat map.
Flutter logo JavaScript
Oracle Autonomous DB logo Oracle
SQL database SQL
REST API REST API
GitHub logo GitHub
HTML/JavaScript → REST API → Oracle Relational Database
View GitHub
EHR App This project is a full-stack EHR web application that simulates secure patient data management. Built with HTML and JavaScript on the front end, an AWS-hosted relational database on the backend, and a REST API for data access. Focused on data modeling, API integration, and scalable system design to mirror real-world healthcare information systems.
Flutter logo JavaScript
Oracle Autonomous DB logo AWS
SQL database SQL
REST API REST API
GitHub logo GitHub
HTML/JavaScript → REST API → AWS Relational Database
View GitHub