About
Results-driven Azure Certified Data Engineer with over 5 years of expertise in designing scalable data pipelines and building robust lakehouse architectures. Proven ability to deliver business-critical KPIs and dashboards using technologies like Databricks, Microsoft Fabric, Azure Data Factory, and Snowflake. Adept at optimizing solutions with PySpark and SQL to drive data modernization and enhance decision-making across E-commerce, Real Estate, and Banking sectors.
Work
Kavtech Pvt Ltd.
|Senior Data Engineer
Islamabad, Islamabad Capital Territory, Pakistan
→
Summary
Led the migration and optimization of critical ETL pipelines, significantly boosting data performance and ensuring seamless data access for diverse business applications.
Highlights
Migrated over 15 legacy ETL pipelines to Microsoft Databricks, boosting data processing performance by up to 60% and significantly reducing maintenance overhead.
Engineered over 40 robust ETL workflows to ingest complex ad-marketing and CRM data from multiple sources into Databricks Unity Catalog, ensuring centralized governance and seamless data access.
Developed more than 20 modular ELT models using DBT on Snowflake, reducing query runtimes by 40% and enabling near real-time marketing performance insights.
Automated data quality checks and incremental loads for CRM and ad data pipelines, increasing data reliability by 70% across 5+ downstream Power BI reports.
Achieved 30% cloud cost savings by redesigning data flows and optimizing Spark SQL queries.
Systems Limited
|Consultant Data Engineer
Islamabad, Islamabad Capital Territory, Pakistan
→
Summary
Currently leading the design and implementation of end-to-end lakehouse architectures, driving enterprise-grade BI and reporting solutions for diverse clients.
Highlights
Architected and deployed an end-to-end lakehouse architecture with Microsoft Fabric, enhancing enterprise-grade BI and reporting capabilities.
Developed over 25 key performance indicators (KPIs) from CRM and GA4 data, visualizing insights in Power BI dashboards to inform cross-functional decision-making.
Established and managed an HTAP connection between Azure Cosmos and Azure Synapse Dedicated SQL Pool, enabling real-time data streaming and custom ad-hoc reporting for 12 diverse clients.
Streamlined CI/CD pipelines for automated deployment of data assets, accelerating release cycles by 50%.
Maintained 99.9% system availability through the implementation of robust monitoring, alerting, and failover strategies within the Fabric ecosystem.
RNS Solutions
|Associate Data Engineer
Islamabad, Islamabad Capital Territory, Pakistan
→
Summary
Contributed to the development of a blockchain-based financial platform by building real-time ELT pipelines and designing scalable data warehouse solutions.
Highlights
Contributed as an ETL Developer to a blockchain-based financial platform (Cashero), extracting customer journey data from Kafka to enhance analysis and throughput.
Developed real-time ELT pipelines with Kafka and Snowflake, enabling low-latency data ingestion for multi-currency wallets and cross-border payment analytics.
Designed and implemented a medallion architecture with layered data storage (bronze, silver, gold), building a scalable data warehouse using dimensional modeling.
Education
FAST-NUCES
Bachelor of Science
Computer Science
Certificates
Microsoft Azure Data Engineer (DP-203)
Issued By
Microsoft
dbt on Databricks
Issued By
Databricks
Data Warehouse Concepts, Design, and Data Integration
Skills
Data Engineering
Data Pipelines, ETL, ELT, Data Warehousing, Lakehouse Architecture, Data Modeling, Dimensional Modeling, Data Integration, Data Quality, Real-time Data Streaming, Data Modernization, CI/CD.
Cloud Platforms
Azure, AWS S3, Snowflake, Microsoft Fabric, Databricks, Azure Data Factory, Azure Cosmos, Azure Synapse.
Programming & Scripting
Python, PySpark, SQL, GoLang.
Databases & Data Stores
Delta Lake, NoSQL, Kafka, Azure Synapse Dedicated SQL Pool.
BI & Reporting
Power BI, KPIs, Dashboards.
Tools & Methodologies
DBT, Spark, Synapse, Pentaho DI, SCD Type 2 & 3, Monitoring, Alerting, Failover Strategies, HTAP.
Domain Expertise
E-commerce, Real Estate, Banking, Blockchain, Ad-marketing, CRM.
Project Management & Communication
Client Relationship Management, Cross-functional Collaboration, Technical Communication, Problem-Solving.