Translating complex data streams into high-impact business decisions, automated KPI architectures, and interactive executive dashboards.
- 🎯 Focus Areas: Customer & Product Analytics, Conversion Funnel Optimization, Executive Dashboarding, Cloud Data Warehousing, and Statistical Testing.
- 💡 Core Expertise: End-to-end data pipelines, advanced SQL data modeling (CTEs, Window Functions, Retention Cohorts, RFM), and cross-functional business storytelling.
- 📊 Hands-on Platforms: Google BigQuery, PostgreSQL, Power BI, Tableau, Looker Studio, Amplitude, Google Analytics 4 (GA4), and Python.
- 📬 Open to Data Analyst, Business Intelligence (BI) Developer / Specialist, and Analytics Engineer roles.
| Category | Technologies & Tools |
|---|---|
| SQL & Cloud Warehousing | Google BigQuery PostgreSQL Data Modeling CTEs Window Functions JSON/ARRAY Unnesting |
| BI & Data Visualization | Power BI (DAX, Star Schema) Tableau Public Looker Studio Interactive Dashboards |
| Product & Digital Analytics | Google Analytics 4 (GA4) Amplitude Customer Tracking Plans Funnel & Retention Analysis |
| Statistical & Data Science | Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn) A/B Hypothesis Testing |
| Business Frameworks | RFM Segmentation Cohort Retention Analysis ROAS Optimization Churn Prediction |
| Platform | Project Showcase | Focus Area | Live Link |
|---|---|---|---|
| Power BI | Executive Sales & Performance Report | Interactive Financial & Operational KPIs (DAX) | Explore Report ↗ |
| Tableau | Business Intelligence & Analytics Portfolio | Multi-dimensional Vizzes & Data Storytelling | View Vizzes ↗ |
| Looker Studio | Dynamic Performance Dashboard | Real-time Web Traffic & E-Commerce Metrics | Open Dashboard ↗ |
| Amplitude | Behavioral Analytics Workspace | User Engagement, Drop-off & Funnel Analysis | View Analytics ↗ |
| Google Sheets | Enterprise Customer Tracking Plan | Event Tracking Taxonomy & Data Governance | View Tracking Plan ↗ |
- 🔍 SQL Customer Analytics & Insights Engine
- Built a PostgreSQL analytics pipeline performing RFM customer segmentation, multi-month cohort retention modeling, and executive KPI reporting on e-commerce transaction data.
- ☁️ Google BigQuery Cloud SQL Analytics
- Analyzed high-volume e-commerce event streams, user session journeys, and GA4 event parameters using advanced BigQuery SQL (Window functions, CTEs, complex unnesting).
- 📊 E-Commerce Marketing & Performance Analytics
- End-to-end data analytics evaluating multi-channel marketing performance, cross-channel ROAS, category revenue share, and conversion trends across 1,825 daily records.
- 🧪 A/B Test Statistical Analysis
- Conducted reproducible statistical hypothesis testing evaluating conversion rates across 19,998 users using two-proportion z-tests and rigorous confidence interval estimation.
- 🔮 Customer Churn Prediction
- Developed baseline machine learning classification models (Logistic Regression & Random Forest) to identify churn risk factors and support customer retention strategies.