Back to Developers
Dev Pawar

Dev Pawar

Data Analyst

Indore, India 1+ yrs exp 88 ยท Excellent

About

Data Analyst with 1+ years of experience in reporting, dashboarding, and data validation, with additional expertise in Power BI development, Python automation, ETL workflows, and SQL-based data modeling. Skilled in cleaning and validating data from multiple sources, building and maintaining reports/dashboards, spotting trends and anomalies, and handling ad-hoc data requests with business teams. Strong in Excel (Pivot Tables, VLOOKUP/XLOOKUP), SQL, and Python (Pandas/NumPy), with proven experience in the E-commerce and Insurance domains delivering automated dashboards, advanced analytics, and end-to-end reporting solutions.

Skills & Expertise (20)

Advanced Excel Intermediate
7.1/10
1
Years Exp
MySql Intermediate
7.1/10
1
Years Exp
Postgresql Intermediate
7.1/10
1
Years Exp
RLS Intermediate
7.1/10
1
Years Exp
Power Query Intermediate
7.1/10
1
Years Exp
Data Modeling Intermediate
7.1/10
1
Years Exp
Power BI Intermediate
7.1/10
1
Years Exp
XLOOKUP Intermediate
7.1/10
1
Years Exp
VLOOKUP Intermediate
7.1/10
1
Years Exp
Pivot Tables Intermediate
7.1/10
1
Years Exp
Data Analysis Intermediate
7.1/10
1
Years Exp
DAX Intermediate
7.1/10
1
Years Exp
SQL Intermediate
7.1/10
1
Years Exp
NumPy Intermediate
7.1/10
1
Years Exp
Pandas Intermediate
7.1/10
1
Years Exp
Python Intermediate
7.1/10
1
Years Exp
Trend & Anomaly Analysis Intermediate
7.1/10
1
Years Exp
Ad-Hoc Reporting Intermediate
7.1/10
1
Years Exp
Dashboards Intermediate
7.1/10
1
Years Exp
Reports Intermediate
7.1/10
1
Years Exp

Work Experience

Data Analyst

Swiftsoft Infotech

May 2025 - Present

Built and maintained reports/dashboards in Power BI and Excel, tracking KPIs across Claims, Sales, and Insurance business lines. Cleaned and validated data from multiple sources (SQL, Excel/CSV) to ensure accurate, consistent, and audit-ready datasets. Spotted trends and anomalies in transactional and claims data, presenting findings clearly to business stakeholders. Handled ad-hoc data requests from business teams, delivering quick-turnaround analysis using SQL and Excel (Pivot Tables, VLOOKUP/XLOOKUP). Automated ETL workflows and recurring reports using SQL, Power Query, and Python, and built DAX measures and KPIs for business reporting.

Education

M.Sc. Data Science & Analytics - DAVV, Indore (School of Data Science and Forecasting)

2023 - 2025 ยท Afghanistan

B.Sc. Computer Science - IPS Academy, Indore

2018 - 2021 ยท Afghanistan

Certifications

Deloitte Data Analytics Job Simulation

Forage ยท 2026

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 sinceOct 2026

Availability Details

Visa Status

Need Sponsorship

Relocation

Open to Relocation