Data Engineer with 8 years of experience across legacy Microsoft stacks and modern cloud platforms.
End-to-end data pipelines — from raw source ingestion through transformation layers to analytics-ready reporting.
- Orchestration: Apache Airflow (Astronomer)
- Transformation: dbt-core, dbt-postgres, dbt-snowflake
- Databases: PostgreSQL (Neon), Snowflake
- Visualization: Power BI
- ETL (Legacy): SSIS, SQL Server
- Languages: Python, SQL
- Dev Environment: GitHub Codespaces, Astro CLI
End-to-end pipeline ingesting daily Pakistan Stock Exchange market data through a Medallion architecture (Bronze → Silver → Gold), with dual-target dbt models running on both PostgreSQL and Snowflake.
- 6-task Airflow DAG — seed, transform, test, sync, repeat
- 25 automated dbt data quality tests
- Custom cross-database macros for Postgres/Snowflake compatibility
- Portfolio analytics models tracking personal PSX holdings
- Power BI dashboard on gold layer
Currently working as SDE-III / Data Engineer at ThinkEnabled, supporting a global medical data pipeline serving franchises across MENA, Canada, Taiwan, and Germany — source replication through transformation layers to regional marts feeding Power BI dashboards.
