Data Analyst · AI Automation

Turning raw data
into decisions.

I'm Kamran Khan — a Data Analyst with 4+ years building ETL pipelines, dashboards, and AI-driven analytics that help teams see what matters, faster.

Python SQL Power BI Tableau Azure Synapse DAX AI Automation
View Dashboards
100K+
Records analyzed
50%
Reporting time cut
4+ yrs
Experience
LIVE
Kamran Khan
Data Analyst
What I work with

Skills & tools

Core competencies built across 4+ years of analytics, dashboarding, and cloud data engineering work.

Python
Pandas · NumPy · Scikit-learn
SQL
CTEs · Window Functions
Power BI
DAX · Interactive Dashboards
Tableau
Visualization · EDA
Azure
Data Factory · Synapse Analytics
Machine Learning
Scikit-learn · EDA
ETL Pipelines
Extraction · Transformation · Validation
Excel
Data Cleaning · Reporting
Selected work

Projects

A few of the dashboards and pipelines I've shipped — spanning finance, healthcare, and cloud data engineering.

Finance · Analytics

Financial Risk & Performance Analytics Dashboard

  • Analyzed 100K+ financial transactions using SQL (CTEs, window functions) to calculate ROI, revenue growth, and profit margins.
  • Built an interactive Power BI dashboard with DAX measures tracking portfolio performance and cash flow forecasts.
  • Detected anomalies in financial data with Python, cutting discrepancies by 30% before executive reporting.
PythonSQLPower BIDAXExcel
Healthcare · EDA

Healthcare Patient Outcomes & Readmission Analysis

  • Cleaned 80K+ patient records, resolving missing values and standardizing clinical data fields.
  • Identified readmission risk factors across demographics and treatment plans using Seaborn and Matplotlib.
  • Built a Tableau dashboard for clinical stakeholders, contributing to a 15% reduction in average length of stay.
PythonSQLTableauEDAScikit-learn
Cloud · Data Engineering

Azure Cloud Data Pipeline & Analytics Solution

  • Designed and deployed an ETL pipeline with Azure Data Factory to ingest data from cloud and on-premise sources.
  • Used Azure Synapse Analytics and ADLS Gen2 to store and query large-scale structured and semi-structured datasets.
  • Automated transformation workflows using Python scripts and ADF mapping data flows.
Azure Data FactoryAzure SynapsePower BISQLPython
Career path

Experience & education

Where the work has taken place — and the foundation behind it.

Feb 2022 — Present

Data Analyst

Foster Technologies India Pvt Ltd, Bangalore
  • Cleaned and transformed structured datasets using Python (Pandas, NumPy) and Excel, improving data accuracy for downstream reporting.
  • Built interactive Power BI dashboards from exploratory data analysis, giving stakeholders real-time visibility into key metrics.
  • Built ETL pipelines covering extraction, transformation, and validation, cutting data errors across multiple source systems.
  • Led a Power BI dashboard project that eliminated 50% of manual reporting workload; awarded internal Project Lead recognition.
Education

B.Sc. in Computer Science

Integral University, Lucknow, India · Top 5% of Batch
  • Relevant coursework: Data Structures, Database Management Systems, Statistics, Artificial Intelligence.
🎓
Data Science Certification
Ducat AI School, Noida
🤖
AI and Data Scientist Certification
OneRoadMap
🏆
Project Lead Award
50% reduction in manual reporting
🥈
Runner-up, Coding Competition
200+ participants
Get in touch

Let's build something with data.

Open to data analyst and AI automation roles, freelance dashboard work, and consulting.

📍
Location
Bangalore, India