Vedant Patil

Data Analyst

Remote, India 0+ yrs exp 85 · Excellent

About

Detail-oriented and metric-driven postgraduate in Computer Applications (MCA, BCA) and Microsoft Certified: Power BI Data Analyst Associate (PL-300). Proficient in writing optimized SQL queries (CTEs, joins, aggregations) to extract, validate, and clean structured data across relational databases. Experienced in designing interactive Power BI and Excel dashboards, monitoring cross-functional KPIs, conducting anomaly investigations, and automating recurring analytical workflows. Skilled in translating complex business requirements into clear data visualizations and technical documentation. Available immediately on 0-day notice for full-time remote roles.

Skills & Expertise (31)

Advanced SQL Intermediate

6.5/10

Years Exp

Microsoft Power BI Intermediate

6.5/10

Years Exp

Python Intermediate

6.5/10

Years Exp

MySql Intermediate

6.0/10

Years Exp

Conditional Formatting Intermediate

6.0/10

Years Exp

Index-match Intermediate

6.0/10

Years Exp

XLOOKUP Intermediate

6.0/10

Years Exp

Pivot Tables Intermediate

6.0/10

Years Exp

Google Sheets Intermediate

6.0/10

Years Exp

Advanced MS Excel Intermediate

6.0/10

Years Exp

Exploratory data analysis Intermediate

6.0/10

Years Exp

NumPy Intermediate

6.0/10

Years Exp

Pandas Intermediate

6.0/10

Years Exp

KPI Dashboards Intermediate

6.0/10

Years Exp

Postgresql Intermediate

6.0/10

Years Exp

Power Query Intermediate

6.0/10

Years Exp

DAX Intermediate

6.0/10

Years Exp

Visual Analytics Intermediate

5.5/10

Years Exp

Data Reconciliation Intermediate

5.5/10

Years Exp

CTEs Intermediate

5.5/10

Years Exp

Window Functions Intermediate

5.5/10

Years Exp

Subqueries Intermediate

5.5/10

Years Exp

Star Schema Modeling Intermediate

5.5/10

Years Exp

Drill-through Reports Intermediate

5.5/10

Years Exp

Schema Validation Intermediate

5.0/10

Years Exp

Query Optimization Intermediate

5.0/10

Years Exp

Macros Intermediate

5.0/10

Years Exp

Quality assurance testing Intermediate

5.0/10

Years Exp

Standard Operating Procedures Intermediate

5.0/10

Years Exp

scikit-learn Intermediate

5.0/10

Years Exp

Matplotlib Intermediate

5.0/10

Years Exp

Work Experience

Data Analytics Intern

iStudio Technologies

Aug 2024 - Sep 2024

Extracted, cleaned, and reconciled 25,000+ operational records using SQL and Python, ensuring complete data accuracy across weekly reporting cycles. Designed interactive Power BI dashboards tracking business volume trends and service-level agreements (SLAs), reducing manual reporting turnaround by 30%. Conducted root cause analysis on data discrepancies and anomalies, documenting findings to support cross-functional process improvements. Authored technical documentation, data dictionaries, and SOPs for dashboard maintenance and data governance alignment.