Immediate Joiner · Open to Delhi NCR
DATA ANALYST
Anas Khan
Turning raw data into decision-ready business insights.
Hands-on internship and project experience across data cleaning, SQL analysis, KPI reporting, dashboard development and cloud analytics using SQL, Python, Power BI, Advanced Excel and Microsoft Azure.
ABOUT ME
Analytics with a business-first mindset
I focus on the complete path from messy data to clear decisions—not just charts.
Professional Summary
I am a Data Analyst with hands-on internship and project experience in SQL, Python, Power BI and Advanced Excel. My work includes data extraction, cleaning, validation, exploratory analysis, KPI development, dashboarding, reporting automation and communicating actionable findings.
I have also built an end-to-end Azure analytics workflow using ADLS Gen2, Azure Data Factory and Azure SQL Database, connecting the final data model to Power BI for analysis and reporting.
What I bring
Reliable analysisData quality, validation, SQL and Python analysis
Decision-focused KPIsMetrics aligned to business performance
Clear reportingPower BI dashboards, DAX and storytelling
Cloud project exposureADLS Gen2, ADF, Azure SQL and Managed Identity
EXPERIENCE
Hands-on work with business data
PROFESSIONAL EXPERIENCE
Data Analyst Intern
Jivik Interio · Firozabad, Uttar Pradesh
- Reduced repetitive manual reporting effort by 10+ hours per week through data extraction, cleaning, transformation and validation using Python, PostgreSQL, Power Query and Excel.
- Improved reporting efficiency by 40% by building interactive Power BI dashboards and KPI reports for revenue, sales growth, footfall, conversion rate and inventory turnover.
- Contributed to a 15% reduction in dead stock through exploratory and root-cause analysis of inventory and operational bottlenecks.
- Used SQL joins, CTEs, window functions, aggregations and date-based analysis to examine sales, customer and operational performance trends.
- Collaborated with stakeholders to understand reporting needs, define KPIs and communicate findings through dashboards and business reports.
TECHNICAL SKILLS
Tools I use across the analytics lifecycle
SQL & Databases
PostgreSQL · Azure SQL Database · Joins · CTEs · Window Functions · Subqueries · Aggregations
Python & Analytics
Python · Pandas · NumPy · Data Cleaning · EDA · Feature Engineering · Statistical Analysis
Business Intelligence
Power BI · DAX · Power Query · Data Modeling · KPI Dashboards · Interactive Reports
Advanced Excel
XLOOKUP · INDEX-MATCH · Pivot Tables · Pivot Charts · SUMIFS · COUNTIFS · Data Validation
Microsoft Azure — Project Experience
ADLS Gen2 · Azure Data Factory · Linked Services · Datasets · Copy Activity · Pipeline Monitoring · Azure SQL · Managed Identity
FEATURED PROJECTS
Projects built around real business questions
Selected work that best represents my current analytics capabilities.
Featured · Azure
01
Azure Financial Transaction Risk & Fraud Analytics
Python · ADLS Gen2 · Azure Data Factory · Azure SQL · Power BI · DAX
End-to-end batch analytics project analysing 6.36 million financial transactions and fraud-labelled activity through an Azure data pipeline and a two-page Power BI report.
Python
ADLS Gen2
ADF
Azure SQL
Power BI
6,362,620transactions validated
8,213fraud-labelled records
21processed columns
- Engineered balance-related features, amount percentiles and rule-based risk indicators in Python.
- Configured ADF linked services, datasets, Copy Activity and explicit source-to-destination mappings.
- Validated row counts, amount totals and key null checks in Azure SQL before reporting.
- Built Overview & Risk plus Insights & Recommendations pages in Power BI.
Operations Analytics
02
Logistics Delivery Performance Analytics
Python · PostgreSQL · SQL · Power BI
Analysed delivery reliability, delays, shipping modes, regions and customer segments to identify high-risk operational patterns across the supply chain.
PostgreSQL
Python
SQL Views
Power BI
1.2M+deliveries tracked
85%on-time rate
15regions analysed
- Compared scheduled versus actual delivery performance to highlight SLA breaches.
- Used CTEs, window functions, and date-based aggregations to process historical records.
- Built KPI-driven reporting to prioritise high-risk shipping segments and reduce operational delays.
- Created interactive map visualizations to pinpoint regional bottlenecks.
Commercial Analytics
03
E-Commerce Analytics Dashboard
Power BI · DAX · Power Query
Analysed sales, pricing, discounts, ratings, seller performance and inventory availability to support product and pricing decisions.
Raw Data
Power Query
Data Model
DAX
Power BI
500K+orders analysed
$2.5Mtotal revenue
1,200products tracked
- Modelled and validated e-commerce product and seller data ensuring relational integrity.
- Developed complex DAX measures for rankings, profit contribution, and out-of-stock analysis.
- Created overview and recommendation pages for decision-ready reporting.
- Identified top 10 underperforming product categories to optimize promotional spend.
How I Solve Business Problems
My End-to-End Analytics Process
Understand Business Problem
Explore & Profile Data
Clean & Transform
Analyze with SQL / Python
Identify Trends & Root Causes
Build KPI Dashboard
Generate Insights
Recommend Business Actions
CERTIFICATIONS
Continuous learning
- SQL — Basic, Intermediate & AdvancedHackerRank Verified · 2026
- Python — BasicHackerRank Verified · 2026
- Power BI Data Modelling & AnalyticsSimplilearn & Microsoft · 2026
- Artificial Intelligence — Data Engineering AnalystNASSCOM & Skill India Digital Hub · 2026
EDUCATION
Bachelor of Computer Applications
J.S University · Shikohabad, Uttar Pradesh
Built a practical analytics portfolio alongside degree coursework, with emphasis on SQL, Python, BI reporting and cloud analytics projects.
LET'S CONNECT
Open to Data Analyst opportunities in Delhi NCR
I am available to join immediately and open to work-from-office, hybrid and relevant remote opportunities.
Emailanaskhan82730@gmail.com
Phone+91 7505384167
LocationFirozabad, UP · Open to Delhi NCR
GitHubgithub.com/Anaskhan1245