Back to Developers
Arup Ranjan

Arup Ranjan

Data Analyst

Gurugram, Haryana 0+ yrs exp 86 · Excellent

About

Data Analyst and Computer Science graduate (B.Tech, 2025) with hands-on expertise in SQL, Python, Power BI, and Excel — skilled in gathering and analyzing data, building dashboards, and supporting business performance tracking. Developed an end-to-end analytics project analyzing 100,000+ UPI transactions — implementing anomaly detection, defining metric logic for 20+ KPIs, and building 4 Power BI dashboards for executive and operational reporting. Strong analytical mindset with a passion for data-driven decision-making, ownership mentality, and excellent attention to detail. Available to join immediately.

Skills & Expertise (41)

Python Advanced
8.5/10
2
Years Exp
SQL Advanced
8.2/10
2
Years Exp
Data Cleaning Advanced
8.0/10
2
Years Exp
Data Wrangling Advanced
8.0/10
2
Years Exp
Power BI Advanced
8.0/10
2
Years Exp
Business Intelligence Advanced
7.5/10
2
Years Exp
PowerPoint Pivot Tables Pandas NumPy SciPy Matplotlib Seaborn Data Modeling Star Schema database design Query Optimization Data Validation KPI Reporting Dashboard Development Fraud Detection Risk Analysis Financial data analysis T-SQL ETL Anomaly Detection Business Requirements Analysis Business Performance Tracking Root Cause Analysis Trend Analysis Ad-hoc Analysis Hypothesis Testing Jupyter Notebook SQL Server SSMS DAX Power Query Excel EDA VLOOKUP XLOOKUP

Work Experience

Dashboard

UPI Transaction Analytics & Fraud Risk Analysis

Mar 2026 - Jun 2026

Designed a 7-table normalized SQL Server schema with 8 FK constraints, composite indexes, and data validation rules — managing 139,500+ records across 7 entity types to support analytics and business performance tracking. Authored 20+ T-SQL queries (JOINs, CTEs, Window Functions, Subqueries) to collect, analyze, and report KPIs — transaction trends, fraud rates, merchant revenue, customer segmentation — for stakeholder reporting. Conducted end-to-end EDA in Python (Pandas, NumPy) — performing data quality audits, anomaly detection (NULL checks, outlier identification), and generating 12 visualizations (Matplotlib, Seaborn) to surface data errors and support decision-making. Applied 6 hypothesis tests (T-test, ANOVA, Chi-square, Pearson Correlation) using SciPy — confirming 15× higher fraud risk on rooted devices (20.69% vs 1.39%, p=0.0000) and generating anomaly insights for incident prioritization. Built 4 Power BI dashboards (Executive, Merchant, Fraud Monitoring, Fraud Analysis) using DAX, Power Query, and Star Schema modeling — enabling business performance tracking with KPI cards, drill-through filters, and tooltips for executive stakeholders. Performed root cause analysis revealing 3.1% of rooted devices drive 32.8% of fraud — developed incident prioritization logic and 3 actionable recommendations with ₹1,49,500 estimated business impact.

GitHub

Customer Analysis for Retail

Jan 2026 - Mar 2026

Gathered, merged, and validated customer, transaction, and product datasets (50,000+ records) using Python Pandas — resolving nulls, correcting data types, and standardizing fields to support business requirement documentation. Analyzed and reported customer purchasing behavior using Matplotlib and Seaborn — identifying 3 customer segments and seasonal demand trends through market and competitive trend analysis. Conducted business performance analysis on seasonal buying patterns — generating insights and supporting data-driven decision-making across product and customer segments.

Education

Bachelor of Technology (B.Tech) – Computer Science Engineering - Panipat Institute of Engineering & Technology, Kurukshetra University

2022 - 2025 · Afghanistan

Certifications

SQL (Intermediate)

HackerRank · 2026

Python (Basic)

HackerRank · 2026

Data Analytics Job Simulation

Deloitte Forage · 2026

Power BI for Beginners

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

Profile Overview

Member sinceJul 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation