← Back to Portfolio
03

All Projects

Customer Segmentation & CLV Prediction Pipeline

End-to-end automated ML pipeline for customer lifetime value prediction and segmentation using RFM analysis. Built with Medallion architecture on GCP, integrating data quality checks and interactive dashboards.

Automated customer segmentation reducing manual analysis time by 80%, enabling data-driven marketing strategies.

Python BigQuery Airflow dbt Docker Looker Studio
View Project →

Attendance ETL Pipeline

Scalable ETL pipeline for university attendance data processing with Docker containerization. Three-layer architecture (Staging → Warehouse → Mart) with automated weekly reporting.

Three-layer Medallion architecture with containerized deployment; automated weekly attendance reporting.

Python PostgreSQL Docker pandas
View Project →

BigQuery Data Ingestion Pipeline

Data ingestion pipeline from local PostgreSQL to BigQuery using Python transformation and Cloud SQL. Processes banking fraud detection dataset through a clean data flow.

End-to-end data flow from local CSV through transformation to BigQuery data warehouse.

Python BigQuery PostgreSQL GCP Cloud SQL pandas
View Project →

CI/CD Pipeline for AWS Glue Jobs

Production-ready CI/CD pipeline automating AWS Glue job deployment using Azure DevOps with multi-environment support (DEV/PRD), smart change detection, and S3 Tables integration with Apache Iceberg.

Reduced manual deployment time from hours to minutes; zero-downtime deployments across environments.

AWS Glue AWS S3 Azure DevOps Python boto3 Apache Iceberg
View Project →

Stock Market Dashboard

Interactive stock market analysis dashboard visualizing market trends, trading volumes, and performance metrics with drill-down capabilities.

Enables quick identification of market patterns and trading opportunities through visual analytics.

Tableau Python
View Project →

Online Rental Movies Analysis

Comprehensive SQL analysis of an online movie rental platform exploring customer behavior, revenue patterns, actor popularity, and subscription trends.

Delivered insights on customer demographics, revenue patterns, and subscription behavior.

SQL SQLite Jupyter Notebook
View Project →