I am Darshil Mangukiya, a Computer Engineering student based in Fullerton, California, focused on data analytics, business analysis, BI development, and data engineering. I build production-style portfolio projects that transform raw data into reliable pipelines, governed KPI layers, executive dashboards, and business-ready insights.
SQL · Python · Power BI · PostgreSQL · Airflow · dbt · Kafka · Spark
All projects are portfolio implementations built with simulated business data unless otherwise noted.
Project Index
Multi-marketplace e-commerce analytics across five marketplaces with marketplace-level sales, fee, refund, revenue-quality, and margin-risk analysis — an 8-page Streamlit dashboard and an 8-page Power BI report.
Customer intelligence and product analytics platform using SQL, Python, PostgreSQL, Streamlit, and Excel to analyze churn, CLV, cohorts, segmentation, product profitability, KPI reporting, and activation.
Local-first multi-source marketing ETL and analytics warehouse with Python, Airflow, PostgreSQL, dbt, Streamlit dashboards, data quality checks, and BI-ready marts.
Customer 360 data platform with CDC ingestion, identity resolution, dbt/PostgreSQL modeling, validation, and privacy-safe reverse ETL activation.
Cloud-ready lakehouse observability platform with Airflow, dbt, PostgreSQL, MinIO, data quality checks, schema drift detection, release gates, and Streamlit dashboards.
Event-driven, multi-tenant data platform with FastAPI microservices, Kafka pipelines, PostgreSQL analytics storage, Redis caching, PySpark batch jobs, Airflow orchestration, data contracts, and observability.
Multi-marketplace e-commerce analytics across five marketplaces with marketplace-level sales, fee, refund, revenue-quality, and margin-risk analysis — an 8-page Streamlit dashboard and an 8-page Power BI report.
Customer intelligence and product analytics platform using SQL, Python, PostgreSQL, Streamlit, and Excel to analyze churn, CLV, cohorts, segmentation, product profitability, KPI reporting, and activation.
Local-first multi-source marketing ETL and analytics warehouse with Python, Airflow, PostgreSQL, dbt, Streamlit dashboards, data quality checks, and BI-ready marts.
Customer 360 data platform with CDC ingestion, identity resolution, dbt/PostgreSQL modeling, validation, and privacy-safe reverse ETL activation.
Cloud-ready lakehouse observability platform with Airflow, dbt, PostgreSQL, MinIO, data quality checks, schema drift detection, release gates, and Streamlit dashboards.
Event-driven, multi-tenant data platform with FastAPI microservices, Kafka pipelines, PostgreSQL analytics storage, Redis caching, PySpark batch jobs, Airflow orchestration, data contracts, and observability.