Back to Developers
Gunnit Walia

Gunnit Walia

Business Analyst

Faridabad, Haryana 0+ yrs exp 81 · Excellent

About

Business Analyst & ENC student at Thapar Institute with hands-on experience in SQL, Power BI, and Excel. Built production dashboards tracking realization rates and MOM collections KPIs at Midland Credit Management (on-site). Adept at translating business requirements into analytical solutions.

Skills & Expertise (31)

Power BI Intermediate
7.3/10
1
Years Exp
Excel Intermediate
6.0/10
1
Years Exp
DAX Intermediate
6.0/10
1
Years Exp
SQL Intermediate
5.4/10
1
Years Exp
Competitor analysis Intermediate
5.0/10
1
Years Exp
Variance Analysis Intermediate
5.0/10
1
Years Exp
KPI Reporting Intermediate
5.0/10
1
Years Exp
RFM Analysis Intermediate
5.0/10
1
Years Exp
Python Beginner
4.8/10
1
Years Exp
NumPy Beginner
4.0/10
1
Years Exp
Linear Regression Beginner
4.0/10
1
Years Exp
Generative AI Beginner
4.0/10
1
Years Exp
Predictive Modeling Beginner
4.0/10
1
Years Exp
K-Means Clustering Beginner
4.0/10
1
Years Exp
Matplotlib Beginner
4.0/10
1
Years Exp
scikit-learn Beginner
4.0/10
1
Years Exp
Pandas Beginner
4.0/10
1
Years Exp
Tableau Beginner
4.0/10
1
Years Exp
C++ Beginner
3.8/10
1
Years Exp
DSA Beginner
3.8/10
1
Years Exp
OOPs Beginner
3.8/10
1
Years Exp
Computer Networks Beginner
3.8/10
1
Years Exp
Operating systems Beginner
3.8/10
1
Years Exp
DBMS MySql SUMIFS Index-match VLOOKUP Pivot Slicers Drill-down

Work Experience

Business Analyst Intern

Midland Credit Management

Jan 2026 - May 2026

Built a Power BI Realization Rate dashboard covering 12M+ accounts & $964M cash — breaking down RR by Payment Method (LD_ACH 91.5%, CARD 79.3%, OTHER 66.4%), Product Type (Fintech/Auto/Other), and Plan Age cohorts, enabling leadership to flag underperforming segments instantly. Developed MOM workgroup dashboard (Jul–Dec 2025) with Web vs Non-Web RR bar charts, stage-contribution donut (Passive/Early/Mid/Late Stage), and a variance matrix across Plan Age & Setup $ buckets with color-coded Var % and Var vs 2M % indicators. Gained end-to-end account lifecycle knowledge — portfolio purchase, account tagging (workgroup, plan age, stage, setup bucket), collections, payment plans, settlement, and closure — informing all KPI definitions and DAX logic.

SDE Intern

IITian Guide

Jun 2025 - Jul 2025

Integrated REST APIs for student data visualization and built automated daily test-result reporting, streamlining analytics for academic coordinators using React and MongoDB.

Product Analyst Intern

Siemens Pvt. Ltd.

Dec 2024 - Jan 2025

Benchmarked Cerberus PRO Fire Safety System against 5+ competitors; synthesized findings into a product improvement report aligned with EN 54 safety standards.

Education

B.E. — Electronics & Computer Engineering (ENC) - Thapar Institute of Engineering & Technology

2022 - · Afghanistan

Class XII — Science (Non-Medical) - USM Public School, CBSE

2020 - 2022 · 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 6/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 81/100

Profile Overview

Member sinceJun 2026

Availability Details

Visa Status

H1B

Relocation

Depends on Offer