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.

Tools Used

Python

BigQuery

SQL

Looker Studio

GitHub

Links

View GitHub Source

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.

Tools Used

REST API

Python

BigQuery

SQL

Looker Studio

GitHub

Links

View GitHub Source

This project processes customer review data from an unstructured CSV files, automatically cleans and organizes the information, and uses AI large language model to generate short summaries and sentiment insights. It demonstrates how raw, unstructured text can be transformed into clear, meaningful takeaways that help support better decision-making.

Tools Used

Python

Transformers

GitHub

Links

View GitHub

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.

Tools Used

JavaScript

Oracle

SQL

REST API

GitHub

Links

View GitHub

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.

Tools Used

JavaScript

AWS

SQL

REST API

GitHub

Links

View GitHub

This project ingests generated healthcare CSV datasets into Databricks Volumes, loads them into Delta tables, models BI-ready SQL views, and validates KPIs before embedding results in a Power BI dashboard.

Tools Used

Python

Databricks

SQL

Power BI

GitHub

Links

View GitHub