Back to homepage

Systems Archive

Additional data, analytics, and infrastructure systems.

A grouped view of selected projects across pipeline engineering, analytics modeling, cloud workflows, and supporting software systems.

Data Engineering

Pipelight Event-Driven Analytics Platform

Storefront events streamed through FastAPI and Redpanda, validated with quarantine, modeled in dbt, and served to live dashboards.

View Case Study

Real-Time Crypto Streaming on Azure

Binance WebSocket events ingested through Azure Event Hub, processed in Databricks, and modeled into Delta Lake Bronze/Silver/Gold tables.

View Case Study

CDC E-commerce Analytics Pipeline

PostgreSQL WAL changes captured with Debezium, streamed through Kafka, and transformed into SCD Type 2 dimensions and fact tables.

View Case Study

Azure Data Factory & Databricks ETL Pipeline

Cloud ETL workflow using Azure Data Factory orchestration and Databricks/PySpark transformations.

View Project

YouTube Analysis Project on AWS

AWS-based analytics pipeline using storage, transformation, querying, and quality checks for YouTube data.

View Project

Web Scraping Automation Suite

Airflow and Docker-based scraping workflows that extract structured data from web sources with retries.

View Project

Analytics Engineering & Modeling

dbt E-commerce Analytics Models

Layered dbt project with staging, intermediate, and mart models for trusted e-commerce analytics.

View Case Study

Database Design and Data Modeling

Relational schema design and ER modeling focused on normalization, integrity, and maintainability.

View Project

Data Exploration in SQL

PostgreSQL projects covering cleaning, joins, aggregations, exploratory analysis, and query optimization.

View Project

Sales Analysis Using Spark

PySpark analysis workflow for distributed sales trend analysis and structured insight generation.

View Project

Software Engineering

Kubernetes + Mongo-Express Deployment

Container deployment with Kubernetes services, secrets, ConfigMaps, MongoDB, and Mongo-Express.

View Project

MERN E-commerce Platform

Full-stack store with product listings, cart, checkout, and an admin dashboard for inventory management.

View Project

Ex-Libris Book-Sharing Platform

Full-stack application with relational modeling, authentication, listings, and book discovery workflows.

View Project

ETL Trivia Game Platform

Full-stack trivia app supported by an automated ETL process for cleaning and structuring question data.

View Project

Airvend Digital Vending Platform

Transaction-focused platform with authentication, wallet management, role-based access, and history tracking.

View Project