Abdullah khan Abdullah2139

👨‍💻 About Me

class Abdullah:
    name        = "Abdullah Khan"
    degree      = "Computer Systems Engineering, UET Peshawar"
    focus       = ["Data Engineering", "ETL Pipelines", "Data Warehousing", "Analytics"]
    cloud       = ["Azure", "AWS", "Snowflake"]
    languages   = ["Python", "SQL"]
    learning    = ["Apache Spark", "dbt", "Azure Data Factory orchestration"]
    currently   = "Open to Associate Data Engineer and entry-level DE / Analytics roles"
    fun_fact    = "I built an AI traffic violation detector for my final year project 🚦"

I'm a Computer Systems Engineering graduate who loves the full data journey: ingesting data from APIs and databases, transforming it with SQL and Python, and loading it into cloud warehouses where it becomes real insight.

🛠️ Tech Stack

☁️ Cloud & Data Warehousing

🐍 Languages & Databases

🔧 Tools & Frameworks

🤖 Applied AI / Computer Vision

🔄 How I Build Pipelines

flowchart LR
    A["📥 Sources<br/>APIs · CSV · Databases"] --> B["⚙️ Ingest<br/>Python · Azure Data Factory"]
    B --> C["🗄️ Storage<br/>AWS S3 · Azure Blob"]
    C --> D["🔧 Transform & Load<br/>SQL · Python"]
    D --> E["🏛️ Warehouse<br/>Snowflake · Azure SQL"]
    E --> F["📊 Analytics<br/>SQL queries & reports"]

🚀 Featured Projects

🏗️ Data Engineering Projects

ETL/ELT Pipelines · Cloud · Warehousing

End-to-end data engineering projects:

Azure ETL pipeline
Snowflake data warehouse (Instacart dataset)
E-commerce pipeline on Azure SQL
Last.fm API ETL pipeline with AWS S3

🗃️ SQL Projects

Analytics · Query Optimization

Hands-on SQL work covering aggregations, joins, window functions, CTEs and reporting queries, the fundamentals every data role demands.

🚦 AI Traffic Violation Detector

Final Year Project · Computer Vision + Django

Traffic monitoring system that detects violations, reads number plates via OCR, and logs incidents to a web dashboard with automated PDF reporting.

💼 Portfolio Projects

Analytics · Practice

Analytics projects built for practice across different technologies, showing how I learn and experiment.

🗺️ Expertise Map

Python                    ████████████████░  Proficient
SQL & Analytics           ███████████████░░  Intermediate-Advanced
ETL Pipeline Design       ███████████████░░  Intermediate-Advanced
Data Engineering          ██████████████░░░  Intermediate
Azure (ADF, Blob, SQL DB) ████████████░░░░░  Intermediate
Snowflake & DWH Design    ████████████░░░░░  Intermediate

📊 GitHub Stats

🌱 What I'm Working On

📦 Expanding my data-engineering-projects repo with Apache Spark and dbt projects
📈 Deepening my knowledge of Azure Data Factory orchestration patterns
🔍 Exploring dbt + Snowflake for analytics engineering workflows

🤝 Let's Connect

I'm actively looking for Associate Data Engineer, Data Engineering and Analytics roles. If you're building data infrastructure, I'd love to talk!

"Data is the new oil, and pipelines are how you refine it."

Navigation Menu