Back to Developers
kartik gupta

kartik gupta

Data Analyst

Mumbai, India 4+ yrs exp 94 · Outstanding

About

Data Analyst with 4.5 years of experience across financial systems and technical support, specializing in Power BI dashboard development, SQL-driven data analysis, and KPI reporting. Skilled in transforming large, high-volume datasets into clear business insights using Power BI, DAX, Power Query, Python, and SQL. Track record of improving reporting accuracy, reducing recurring production issues through structured root cause analysis, and enabling data-driven decisions across cross-functional teams.

Skills & Expertise (32)

Power Query Advanced
8.0/10
5
Years Exp
Power BI Advanced
8.0/10
5
Years Exp
Data Cleaning and Transformation Advanced
8.0/10
5
Years Exp
Python Advanced
8.0/10
5
Years Exp
SQL Advanced
8.0/10
5
Years Exp
DAX Advanced
7.5/10
5
Years Exp
Data Modelling Advanced
7.5/10
5
Years Exp
Excel Advanced
7.5/10
5
Years Exp
ETL Advanced
7.0/10
5
Years Exp
Git Intermediate
6.5/10
5
Years Exp
Agile Intermediate
6.0/10
5
Years Exp
Jira GitHub SQL Server Automation Log Parsing Data Validation Scrum Data Warehousing UAT Documentation MIS Reporting NumPy Pandas Aggregations Window Functions CTEs Joins Advanced Formulas Pivot Tables Row-Level Security Dimensional Modelling

Work Experience

System Analyst, Data Analytics and Reporting

National Stock Exchange of India (NSE)

May 2022 - Sep 2025

Analysed high-volume trading data spanning 100K+ weekly transactions to uncover failure patterns and system performance trends, helping avoid an estimated ₹1.5 Cr in potential downtime costs and giving engineering teams faster visibility into recurring issues. Reduced recurring production issues by 20% by building Python-based log parsing scripts that structured raw log data for faster root cause analysis, saving an estimated ₹40 Lakhs in operational costs through more reliable system monitoring. Standardized 5+ KPI definitions across business and engineering teams by extracting, aggregating, and validating data through SQL, cutting reporting discrepancies by 60% across multiple datasets. Validated data accuracy across 5+ data sources in partnership with engineering and business stakeholders, using Power Query to clean and transform 70,000+ records per week into audit-ready reports.

Service Market Engineer

Canon India Pvt Ltd

Apr 2019 - Apr 2020

Diagnosed and resolved technical issues on Canon's imaging and printing equipment for corporate clients, reducing average case resolution time by 15% through structured, checklist-driven troubleshooting. Supported 200+ client accounts across on-site and remote visits, logging recurring failure patterns that fed into proactive maintenance recommendations, an early introduction to data-led problem solving that shaped the shift toward analytics.

Education

PG Diploma in Advanced Computing (PG-DAC) - CDAC-YCP Mumbai

- 2022 · Afghanistan

B. E. Electronics and Telecommunication - Rajarshi Shahu College of Engineering, Pune University

- 2018 · Afghanistan

Certifications

Data Analytics Course

Coding Ninjas · 2025

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 14/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 94/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation