Mohd Atif Khan

About

Data Analyst with a data engineering foundation, skilled in turning raw datasets into decision-ready business insights using Python, SQL, and Power BI. Hands-on with exploratory analysis, statistical analysis, customer segmentation, KPI dashboarding, and production ETL workflows on Snowflake, dbt, and AWS.

Experience

• Data Analyst
  TheYouthTalks
  Feb 2026 – May 2026
• Chairperson
  National Student Data Corps — Jamia Hamdard (NSF-funded)
  Mar 2025 – Mar 2026
• AI Engineering Intern
  TechSaksham — Microsoft & SAP CSR Initiative (AICTE)
  Feb 2025 – Mar 2025
• Bot Developer Intern
  Warp Velocity
  Jul 2024 – Nov 2024

Education

• B.Tech
  Jamia Hamdard University
  Computer Science & Engineering · 2023 – 2027

Skills

• SQL
• FastAPI
• Python
• Feature Engineering
• Matplotlib
• NumPy
• Pandas
• scikit-learn
• DAX
• Seaborn
• Reporting
• PySpark
• Customer Segmentation
• Data Modeling
• ETL
• Statistical Analysis
• CI/CD
• KPI Analysis
• Data Quality
• Window functions
• Jinja
• Common Table Expressions (CTEs)

Projects

• Netflix Advanced SQL Analytics
  PostgreSQL

  Audited and segmented ~8,800 titles across 10+ analytical dimensions using advanced SQL, resolving missing and inconsistent data to produce reliable content-strategy insights.

• Customer Purchase Behavior Analytics & Revenue Optimization
  Python, SQL, Power BI

  Segmented 10,000+ transactions, identifying the top 20% of customers driving 65% of revenue and a 23% spending variance across discount cohorts; delivered an 8-KPI Power BI dashboard for executive reporting.

• Agentic AI Data Agent
  LangGraph, Python, PostgreSQL, LLMs

  Orchestrated a 3-agent LangGraph system with a 7-stage SQL workflow and 3-tier LLM routing, enabling natural-language querying and API extraction across CSV, JSON, and Parquet sources with safety-validated execution.

• Production-Grade Airbnb Data Platform
  AWS, Snowflake, dbt, FastAPI

  Engineered a cloud-native platform processing 10,700+ records across 3 data domains through Bronze–Silver–Gold transformations, with CI-validated checks for schema drift, freshness, and duplicates. Extended the warehouse into an AI-assisted observability system linking dbt execution logs to an LLM-driven interface for root-cause analysis and remediation guidance.

Courses & certifications

• Oracle Certified Foundations Associate – Data Platform · Oracle · 2025
• Building Scalable Bots Using Automation 360 · Automation Anywhere
• Python for Data Science · IBM
• SQL Intermediate & Advanced · HackerRank

🏆 Achievements & awards

• 98th Percentile — Mathematics, JEE Mains · 2023
• Winner — BrainHack Ideathon · 2025