Projects
A few things I've built and written up.
Company Data Analysis on Databricks
Nearly 12 million company records from People Data Labs, processed with PySpark and Spark SQL on Databricks and presented in a Databricks dashboard: 11.7M companies across 149 industries, broken down by country and size.
- PySpark
- Spark SQL
- Databricks
- +1
Health Insurance Claim Analysis
750,000+ synthetic healthcare records generated with Faker, pushed through an ETL pipeline into 6 normalized MySQL tables, then queried for trends in claim costs, approval rates, providers and patient utilization.
- Python
- SQL
- SQLAlchemy
- +1
Stock Portfolio Analytics
A 6-table PostgreSQL schema fed by a yfinance ETL pipeline, with 15+ advanced SQL queries computing returns, volatility, Sharpe ratio and position-level P&L, surfaced through an interactive Streamlit dashboard.
- Python
- PostgreSQL
- ETL Pipeline
- +2
Business Analysis Dashboards
Three end-to-end Power BI dashboards across banking, toy retail and superstore data: 30+ interactive visuals, reusable DAX measures, and drill-throughs that take you from headline KPIs to the detail behind them.
- Power BI
- DAX
- Power Query