Customer 360 — E-commerce Growth & Retention Intelligence
Engineered an end-to-end e-commerce data pipeline using Python, implemented RFM customer segmentation, analyzed sales and customer metrics with PostgreSQL, and designed a 7-page interactive Power BI dashboard. Identified At-Risk customers as accounting for 34% of total revenue opportunity.
RavenStack — Subscription Health & Revenue Retention Analytics
Analyzed churn and retention across approximately 500 subscription accounts using SQL and Power BI. Built KPI measures for MRR, churn rate, and customer risk score, identified industry and geography as key churn signals, and recommended shifting monthly-billing customers to annual billing.
InsightFlow Analytics — End-to-End Retail Data Pipeline
Built a Python and PostgreSQL retail analytics pipeline processing more than 15,000 orders across 15 stores and 2,000 customers. Designed a normalized database schema, cleaned data with Pandas and NumPy, automated Excel reporting, generated Matplotlib charts, and validated the workflow with 19 pytest unit tests.
BookVerse — SQL Analytics & Business Insights
Wrote 24 PostgreSQL analyses using joins, CTEs, window functions, and subqueries to identify top-performing books and genres by revenue and segment customers by spend relative to average order value.