Back to Developers
Pranjal Waim

Pranjal Waim

Data Analyst

Chh. Sambhajinagar, Maharashtra 0+ yrs exp 85 · Excellent

About

2025 B.Tech CSE graduate and Data Analyst Intern with proven experience building end-to-end analytics solutions — from raw data collection, SQL querying, and Python-based cleaning to Power BI dashboards and stakeholder reporting. Skilled in KPI tracking, anomaly detection, and translating complex datasets into clear business insights, including risk and financial data analytics. Detail-oriented, fast learner, and strong communicator seeking a full-time Data Analyst / BI Analyst role, open to relocating to Mumbai, Pune, Bengaluru, and other locations.

Skills & Expertise (24)

Power BI Advanced
8.0/10
0.5
Years Exp
SQL Advanced
8.0/10
0.5
Years Exp
Excel Charts Advanced
8.0/10
0.5
Years Exp
KPI Dashboards Advanced
8.0/10
0.5
Years Exp
Python Advanced
8.0/10
0.5
Years Exp
Pandas Advanced
8.0/10
0.5
Years Exp
DAX Advanced
7.5/10
0.5
Years Exp
Data Wrangling Advanced
7.5/10
0.5
Years Exp
EDA Advanced
7.5/10
0.5
Years Exp
Pivot Tables Advanced
7.0/10
0.5
Years Exp
VLOOKUP Advanced
7.0/10
0.5
Years Exp
NumPy Advanced
7.0/10
0.5
Years Exp
MySql Advanced
7.0/10
0.5
Years Exp
Business Intelligence Advanced
7.0/10
0.5
Years Exp
MS Office Advanced
7.0/10
0.5
Years Exp
Anomaly Detection Advanced
7.0/10
0.5
Years Exp
Power Query Advanced
7.0/10
0.5
Years Exp
XLOOKUP Intermediate
6.5/10
0.5
Years Exp
Joins Intermediate
6.5/10
0.5
Years Exp
Postgresql Intermediate
6.5/10
0.5
Years Exp
Window Functions Intermediate
6.0/10
0.5
Years Exp
Dynamic Arrays Intermediate
6.0/10
0.5
Years Exp
GitHub Intermediate
6.0/10
0.5
Years Exp
Google Colab Intermediate
6.0/10
0.5
Years Exp

Work Experience

Data Analyst Intern

Syntecxhub

Jun 2026 - Present

Collected, cleaned, and validated datasets up to 38,576 rows using Python (Pandas) and Advanced Excel; applied QA checks to detect anomalies and ensure data integrity before reporting. Delivered weekly stakeholder-ready reports and Power BI dashboards with KPI cards, trend visuals, and exception flags — supporting data-driven decisions across all project milestones. Wrote 13 production-grade SQL KPI queries for loan performance tracking (funded amount, DTI, interest rate, good/bad loan split) with MTD/MoM trends; flagged revenue-risk segment (bad loan rate = 13.8%). Built DAX measures (CALCULATE, DIVIDE, RANKX, SAMEPERIODLASTYEAR) for dynamic KPI tracking; maintained full GitHub documentation for version control and audit traceability.

Education

B.Tech in Computer Science & Engineering - MIT College of Engineering

2021 - 2025 · Afghanistan

12th (HSC) - Shivchhatrapati College

- 2021 · Afghanistan

10th (SSC) - S.B.O.A Public School

- 2019 · Afghanistan

Certifications

Introduction to Power BI Analyst

Great Learning · 2026

AI Tools & ChatGPT Workshop

be10x · 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 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceJul 2026

Availability Details

Visa Status

Need Sponsorship

Relocation

Depends on Offer