Projects

Below are selected projects that demonstrate my skills in analytics engineering, data modeling, visualization, and applied machine learning.

📌 E‑commerce Revenue Optimization & RFM Segmentation

PostgreSQL, Power BI

• Analyzed a $7.26M dataset, uncovering $326,501 in operational waste.
• Modeled an 8.4× efficiency shift by reallocating marketing spend.
• Built an RFM model to identify “Champion” customers.
• Designed a narrative-driven dashboard for executive decision-making.

View GitHub Repo

📌 Holiday Sales Promo Dashboard

Tableau

• Built executive dashboards with KPI tiles, comparative charts, and dynamic tooltips.
• Created uplift metrics (Promo vs Organic) to identify underperforming segments.
• Published on Tableau Public with full documentation.

View Dashboard

📌 Explainable & Agentic AI for Hospital Cost Management

Python, SHAP, LIME

• Analyzed SPARCS inpatient data to identify key cost drivers.
• Built a hybrid XAI simulation framework for cost-reduction strategies.
• Achieved potential savings of up to $10,460 per patient.

View GitHub Repo

📌 CRM → Data Warehouse Pipeline (dbt + SQL + Python)

• Modeled Salesforce objects into analytics-ready marts.
• Implemented data quality tests and lineage.
• Built churn & revenue dashboards.

View GitHub Repo