Back to Developers
Himanshu karlekar

Himanshu karlekar

65 · Good

About

No bio added yet

Skills & Expertise (22)

SQL Intermediate
7.5/10
1
Years Exp
Tableau Intermediate
7.5/10
1
Years Exp
Power BI Intermediate
7.5/10
1
Years Exp
Python Intermediate
7.0/10
1
Years Exp
Pandas Intermediate
7.0/10
1
Years Exp
Data Cleaning Intermediate
7.0/10
1
Years Exp
NumPy Intermediate
6.5/10
1
Years Exp
Matplotlib Intermediate
6.5/10
1
Years Exp
ETL Basics Beginner
5.5/10
1
Years Exp
XLOOKUP EDA Exploratory data analysis Normalization Dashboard Design DAX Data Modeling VLOOKUP Pivot Tables Advanced Excel Window Functions Subqueries Joins

Work Experience

Capstone Project

ExcelR

Present - Present

Cleaned a raw loan-applicant dataset of 40114 rows in Excel — fixed missing values, standardized formats, and removed 397 duplicate/invalid records before analysis. Loaded the cleaned data into SQL and wrote queries to calculate total applications, funded amount, average interest rate and average DTI. Classified loans as 'Verified' or 'Not-Verified' based on employment/income verification, finding 58.88% of applications were verified. Built dashboards in Power BI and Tableau to break down loan performance by region, time period, and loan purpose, using filters so users could drill into specific segments.

Zomato Order Analytics & Consumer Behaviour Insights

Personal Project

Present - Present

Combined 5 related tables — Orders, Customers, Restaurants, Partners, and Promotions — into one dataset using Pandas, covering 5000 orders. Analyzed order volume by city and time of day using Pandas/NumPy to find peak ordering hours and seasonal demand patterns. Compared delivery completion time against customer ratings across cities using Matplotlib charts, to spot cities with slower or lower-rated deliveries. Compared average order value between Gold and Silver membership tiers, finding Silver members had an average order value 2.52% higher.

Education

B.Tech in Computer Science & Engineering - Dr. Babasaheb Ambedkar Technological University (DBATU)

- 2022 · Afghanistan

Higher Secondary Certificate (H.S.C.) - Gurunanak College of Science, Ballarpur

- 2018 · Afghanistan

Secondary School Certificate (S.S.C.) - Dilasagram Convent High School, Ballarpur

- 2016 · Afghanistan

Certifications

Data analyst

ExcelR · 2026

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 0/10
✍️ Bio 0/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 65/100

Profile Overview

Member sinceJul 2026