Back to Developers
Dharmik Shah

Dharmik Shah

Data Analyst

Pune, Maharashtra 1+ yrs exp 88 · Excellent

About

Data Analyst with 1+ years of hands-on experience building Power BI dashboards, writing SQL queries, and using Python (Pandas, NumPy) to transform operational data into decision-ready insights. Improved reporting turnaround by 40% and maintained 98% data accuracy through DAX measures, Power Query automation, ETL workflows, and structured data validation. Experienced in KPI reporting, stakeholder requirements, and AI-assisted analysis using Microsoft Copilot, with independent validation of AI-generated outputs.

Skills & Expertise (38)

Microsoft Excel Intermediate
7.0/10
1
Years Exp
Data Visualization Intermediate
6.8/10
1
Years Exp
Power BI Desktop Intermediate
6.5/10
1
Years Exp
Data visualisation Intermediate
6.5/10
1
Years Exp
Data Transformation Intermediate
6.0/10
1
Years Exp
Advanced Formulas Intermediate
6.0/10
1
Years Exp
PivotTables Intermediate
6.0/10
1
Years Exp
Charts Intermediate
6.0/10
1
Years Exp
ETL Intermediate
6.0/10
1
Years Exp
Data Cleaning Intermediate
6.0/10
1
Years Exp
Pandas Intermediate
6.0/10
1
Years Exp
Python Intermediate
6.0/10
1
Years Exp
SQL Intermediate
6.0/10
1
Years Exp
Data Modeling Intermediate
6.0/10
1
Years Exp
Power Query Intermediate
6.0/10
1
Years Exp
Exploratory data analysis Intermediate
5.8/10
1
Years Exp
Data Quality Management Intermediate
5.5/10
1
Years Exp
Data Modelling Intermediate
5.5/10
1
Years Exp
DAX Intermediate
5.5/10
1
Years Exp
Google Sheets Intermediate
5.0/10
1
Years Exp
Data Governance Intermediate
5.0/10
1
Years Exp
GitHub Beginner
4.0/10
1
Years Exp
Stakeholder Reporting YoY Variance Analysis Microsoft Copilot Process Improvement KPI Reporting Stakeholder Coordination Requirements Gathering Root-cause analysis Trend Analysis Data Validation ELT NumPy MS SQL Server MySql KPI Dashboards

Work Experience

Data Analyst (Associate Trainee)

Techvionix Solutions LLP

Jul 2025 - Jul 2026

Built Power BI dashboards for cash flow, debtors, and creditors, translating stakeholder reporting needs into KPIs and improving reporting turnaround by 40%. Designed and maintained an Excel-based inventory tracking system for 500+ SKUs, reducing stock discrepancies by 30% through automated validation and structured data records. Analysed daily sales data to identify demand trends, enabling data-driven procurement decisions that reduced overstock by 20%. Extracted, cleaned, transformed, and validated operational data through repeatable ETL workflows, maintaining 98% accuracy across weekly and monthly business reviews. Performed root-cause analysis on supplier lead times and order frequency to identify inventory bottlenecks, helping reduce stockout incidents by 25%.

Business Intelligence Intern

Novartis Tech System

Jan 2025 - Jun 2025

Maintained daily site-progress data in structured Excel templates, improving tracking consistency across three concurrent construction phases. Analysed material-consumption data to identify cost-saving opportunities, contributing to a 10% reduction in material wastage. Prepared weekly KPI and performance summaries for the project management team to support timely, data-informed decisions.

Education

B.Tech, Civil Engineering - MIT World Peace University

2020 - 2023 · Afghanistan

Diploma, Civil Engineering - Government Polytechnic Karad

2016 - 2019 · Afghanistan

Certifications

Microsoft Copilot for Data Analysis - Practical Training

· 2026

Data Analytics & Power BI

TechVision Academy · 2026

Python for Data Science

TechVision Academy · 2026

SQL for Data Analysis

TechVision Certified · 2025

Excel for Business Analytics

Udemy · 2024

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

Profile Overview

Member sinceSep 2026