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 (32)

Microsoft Excel Advanced
7.0/10
1
Years Exp
Power BI Desktop Intermediate
6.8/10
1
Years Exp
Data Visualization Intermediate
6.8/10
1
Years Exp
DAX Intermediate
6.0/10
1
Years Exp
Power Query Intermediate
6.0/10
1
Years Exp
Data Modeling Intermediate
6.0/10
1
Years Exp
ETL Intermediate
6.0/10
1
Years Exp
Charts Intermediate
6.0/10
1
Years Exp
Data Transformation Intermediate
6.0/10
1
Years Exp
PivotTables Intermediate
6.0/10
1
Years Exp
Advanced Formulas Intermediate
6.0/10
1
Years Exp
Data Cleaning Intermediate
6.0/10
1
Years Exp
Exploratory data analysis Intermediate
5.8/10
1
Years Exp
SQL Intermediate
5.8/10
1
Years Exp
Python Intermediate
5.0/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
Trend Analysis Root-cause analysis Data Validation Requirements Gathering Stakeholder Coordination KPI Reporting Process Improvement ELT NumPy Pandas MS SQL Server Microsoft Copilot 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