Data Engineering | Analytics Engineering | Cloud Data Platforms
I turn messy business problems into working technical systems, focusing on structure, logic, and testability.
Portfolio proof: ahmedyassershalaby.github.io/ahmed-yasser-portfolio
| Project | Demo | What it proves | Stack |
|---|---|---|---|
| E-Commerce Cloud Data Platform | Technical report | Batch + streaming lakehouse, Airflow orchestration, DuckDB marts, quality observability, AWS-ready Terraform | Python, SQL, DuckDB, Parquet, Airflow, Docker |
| Cloud Security Auditor | Repo only | Security automation, policy-as-code, severity scoring, remediation reporting | Python, YAML, pandas, Streamlit |
| OpsTwin Control Tower | Live demo | Business systems simulation, scenario decisions, Monte Carlo worker, network risk, browser SQL | React, TypeScript, D3, DuckDB-Wasm |
| SaaS Analytics Pipeline | Repo only | Analytics marts, DuckDB/Parquet layers, MRR/churn/adoption metrics, data quality checks | Python, DuckDB, Parquet, SQL |
| Retail Data Pipeline | Repo only | ETL, data contracts, incremental loading, rejected-row reporting, health checks | Python, SQL, SQLite, Streamlit |
- Software Engineering: I design modular, testable codebases using Python and TypeScript, prioritizing maintainability and clean architecture over one-off scripts.
- Data & Analytics Engineering: I build reliable ETL/ELT pipelines, lakehouse layers, orchestration, and dbt-style SQL models that turn messy raw data into trustworthy, explainable KPIs.
- Engineering Workflow: Every project includes unit testing (pytest/Vitest), CI/CD pipelines (GitHub Actions), and containerization (Docker).
- Stack: Python, SQL, TypeScript, React, DuckDB, Parquet, Airflow, Docker, Terraform, AWS basics.


