Back to Developers
Ehtesham Khan

Ehtesham Khan

Data Analyst

Okhla, New Delhi 110025 3+ yrs exp 87 · Excellent

About

Detail-oriented and analytical Data Analyst skilled in collecting, cleaning, and organizing large datasets to generate actionable business insights and structured reports. Proficient in MS Excel, SQL, and Power BI for building interactive dashboards and automating reporting and data workflows. Strong track record of ensuring absolute data accuracy, collaborating with cross-functional teams, and presenting complex analytical findings clearly to support strategic decision-making.

Skills & Expertise (18)

Python Advanced
8.5/10
3
Years Exp
Pandas Advanced
8.5/10
3
Years Exp
SQL Server Advanced
8.0/10
3
Years Exp
NumPy Advanced
8.0/10
3
Years Exp
MS Excel Advanced
8.0/10
3
Years Exp
Reporting Advanced
8.0/10
3
Years Exp
Power BI Intermediate
7.5/10
3
Years Exp
Data Reconciliation Intermediate
7.0/10
3
Years Exp
Documentation Intermediate
7.0/10
3
Years Exp
Statistical Analysis Intermediate
7.0/10
3
Years Exp
Anomaly Detection Intermediate
7.0/10
3
Years Exp
Data Validation Intermediate
7.0/10
3
Years Exp
Matplotlib Intermediate
7.0/10
2
Years Exp
Git Intermediate
6.0/10
2
Years Exp
GitHub Intermediate
6.0/10
2
Years Exp
Tableau Intermediate
5.0/10
1
Years Exp
Jira Intermediate
5.0/10
2
Years Exp
Confluence Intermediate
5.0/10
2
Years Exp

Work Experience

Data Analyst (Part-time)

TSS Global

Jan 2026 - Present

Collect, clean, and organize complex datasets for 500+ MSCI, S&P, and custom benchmark indexes, ensuring data accuracy across pricing, weights, and corporate actions. Leverage advanced SQL (CTEs, window functions) to extract and validate large data holdings, identifying and resolving daily index data discrepancies. Streamline tracking and reporting processes by designing Excel solutions using Power Query and Pivot Tables, reducing preparation time by 20%. Automate workflows and exception reporting using Python (Pandas, NumPy), cutting manual team effort by 15% and accelerating delivery turnaround times. Collaborate daily with cross-functional teams and data vendors to resolve queries, maintaining a 95%+ on-time issue resolution rate.

Data Analyst

Arbre Creations

Mar 2023 - Jan 2026

Conducted comprehensive EDA using Python to identify operational trends and data anomalies, increasing total reporting accuracy by 15–20%. Built and maintained interactive Power BI dashboards to track key production metrics, presenting findings clearly to enable data-driven decisions. Optimized SQL database queries and multi-table joins to accelerate data extraction timelines, reducing reporting turnaround times by 20%. Partnered with cross-functional teams to map data requirements and document automated Python pipelines, improving reporting workflows by 20–25%. Analyzed large operational datasets to detect structural bottlenecks, helping teams optimize workflows and improve production efficiency by 12–18%.

Education

MBA - Business Analytics - Amity University

2026 - 2028 · Afghanistan

Bachelor of Arts - University of Delhi

- 2022 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 12/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 87/100

Profile Overview

Member sinceJun 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation