INDEX / 02 — SELECTED WORK

The projects.

Questions, datasets, and the work in between. A collection of analytics and data engineering projects, with the code and methodology open on GitHub.

/01
Predictive analytics

Financial Operations
Analytics

PythonPower BIScikit-learnProphet
forecast terminal artwork

Five years of simulated SaaS data. Revenue forecasting, churn prediction, and customer clustering — with an emphasis on finding and fixing data leakage.

An end-to-end exploration of financial performance and customer behavior, paired with a five-page Power BI dashboard.

/02
Customer intelligence

Retail & Marketing
Analytics

PythonPandasPower BIJupyter
segments terminal artwork

An analysis of 10,000 retail orders, connecting RFM segmentation, customer lifetime value, and cohort retention to practical business recommendations.

From customer behavior to targeted win-back campaigns: making the analysis useful beyond the notebook.

/03
Data engineering & BI

E-Commerce
Data Warehouse

PostgreSQLSQLPythonPower BI
warehouse terminal artwork

Raw e-commerce data transformed into a star schema: one fact table, four dimensions, a validated ETL pipeline, and a connected BI dashboard.

A foundation for reliable reporting, with window functions, pivot queries, and row-count validation.

/04
Database reliability

ACID Transaction
Ledger

PostgreSQLPythonSQLAlchemyPsycopg2
ledger terminal artwork

A bank-style fund transfer system that tests atomicity, consistency, isolation, and durability through concurrent transaction experiments.

A focused demonstration of the database guarantees that keep financial transactions reliable.

END OF INDEX / 04 PROJECTS[ GitHub profile ↗ ]