Hussnain Akbar

I designed and maintained end-to-end ETL/ELT pipelines using Python, SQL, and Azure Data Factory, automating data ingestion from APIs, flat files, and relational databases. I built and orchestrated production-grade workflows with Airflow and dbt, improving pipeline reliability and reducing manual intervention by 35%. I developed analytics-ready dimensional data models (fact and dimension tables) to support forecasting, KPI reporting, and marketing analytics, resulting in a 40% improvement in BI refresh performance. I optimized warehouse schemas and SQL queries through indexing, partitioning, and model refactoring to accelerate data retrieval for BI teams. Additionally, I implemented incremental and event-driven ingestion to enable near-real-time dashboards, and established data contracts, quality checks, and lineage tracking to ensure consistent, trustworthy data delivery across stakeholders.