Back to Developers
Gunjan Khatri

Gunjan Khatri

Data Analyst

Surat, India 2+ yrs exp 84 ยท Excellent

About

Data Analyst with 2+ years of hands-on experience collecting, cleaning, and analyzing multi-source data to support business reporting and decision-making. Strong in SQL, Excel, and Power BI, with practical experience validating data accuracy, building dashboards, and presenting findings to stakeholders. Comfortable working independently in a fully remote environment.

Skills & Expertise (25)

Power BI Advanced
8.3/10
2
Years Exp
Excel Advanced
7.5/10
2
Years Exp
Python Advanced
7.5/10
2
Years Exp
SQL Advanced
7.5/10
2
Years Exp
Data Cleaning Advanced
7.3/10
2
Years Exp
ETL Processes Advanced
7.0/10
2
Years Exp
DAX Intermediate
6.8/10
2
Years Exp
Tableau Intermediate
6.5/10
2
Years Exp
Power Query Intermediate
6.5/10
2
Years Exp
Business Reporting Intermediate
6.0/10
2
Years Exp
Statistical Analysis Intermediate
6.0/10
2
Years Exp
Google Sheets Intermediate
6.0/10
2
Years Exp
Azure Data Factory Intermediate
5.5/10
2
Years Exp
Azure Cosmos DB Intermediate
5.5/10
2
Years Exp
SharePoint Intermediate
5.0/10
2
Years Exp
REST APIs Intermediate
5.0/10
2
Years Exp
Power Automate Intermediate
5.0/10
2
Years Exp
Pandas VLOOKUP Pivot Tables XLOOKUP Charts Requirement gathering Formulas SQL Server

Work Experience

Data Analyst

PropVIVO

Jun 2024 - Present

Collected and integrated data from Cosmos DB, SQL Server, SharePoint, and REST APIs into centralized, validated reports for 100K+ records daily with 99% data accuracy. Wrote Python scripts to clean and standardize raw data exports, and SQL queries (joins, aggregations) to retrieve and manipulate large datasets, improving retrieval efficiency 45%. Built Power BI dashboards to track workforce productivity, attendance, and financial performance, improving visibility 40% and cutting reporting turnaround 60%. Prepared and presented weekly and monthly business reports to 200+ stakeholders across operations and finance teams. Validated data accuracy and reconciled outputs across multiple source systems to maintain data integrity for company-wide reporting. Assisted in translating business requirements into KPI models and scoring systems, increasing productivity scores 25% and SLA compliance 18%. Automated recurring reporting workflows using Power Automate, cutting manual reporting effort 70% (~15 hrs/week saved). Documented analysis processes and dashboard logic to support knowledge-sharing across the analytics team.

Education

Bachelor of Technology, Civil Engineering - Malaviya National Institute of Technology, Jaipur

2020 - 2024 ยท 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 9/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 84/100

Profile Overview

Member sinceJul 2026