Back to Developers
Aachal Gupta

Aachal Gupta

Data Analyst

Pune, Maharashtra 80 · Excellent

About

BBA (Computer Applications) fresher skilled in SQL, Python, Power BI, and Advanced Excel, with hands-on project experience in data analysis, MIS reporting, sales analytics, operations tracking, and risk analytics. Delivered projects on datasets of 284,000+ and 50,000+ records with measurable outcomes including a 97.4% accuracy fraud detection model, automated MIS dashboards, sales operations dashboards, and customer churn analysis. Strong in KPI tracking, data cleaning, trend reporting, and stakeholder-ready dashboards. Certified in SQL, Advanced Excel, AML/KYC, and Cybersecurity.

Skills & Expertise (40)

SQL Advanced
8.1/10
1
Years Exp
Power BI Advanced
7.8/10
1
Years Exp
Excel Advanced
7.5/10
1
Years Exp
Python Intermediate
6.4/10
1
Years Exp
EDA Slicers Data Modeling Drill-throughs Pandas NumPy Matplotlib scikit-learn DAX Data Wrangling Automation MIS Reporting SLA tracking KPI Monitoring Sales Analytics Fraud Detection KYC AML Pivot Tables MySql Postgresql Joins GROUP BY Subqueries CTEs Aggregations Window Functions KPI Cards VLOOKUP XLOOKUP Power Query Macros Conditional Formatting SUMIF COUNTIF Dashboard Development

Work Experience

MIS Dashboard and Anomaly Detection Developer

Banking Transaction

Jan 2026 - Jan 2026

Analysed 50,000+ records to detect outlier transactions and flag high-risk accounts; built automated Excel MIS dashboards with Macros simulating weekly and monthly reporting cycles — zero-error output. Produced structured risk report with root-cause analysis and mitigation strategies formatted as a stakeholder-ready management summary.

Sales and Operations Analytics Dashboard Developer

Quick-Commerce

Jan 2025 - Jan 2025

Analysed 120,000+ order records across cities and product categories; identified top 3 city clusters driving 62% of revenue and peak demand hours for operations optimisation. Built interactive Power BI dashboard tracking daily orders, delivery TAT, cancellation rate, and city-wise KPIs; automated weekly MIS report in Excel with Macros — zero manual errors. Segmented customers by order frequency and basket size using SQL; top 20% customers contributing 68% of revenue flagged for retention focus.

Risk Analysis Developer

Credit Card Fraud Detection

Jan 2025 - Jan 2025

Built fraud detection model on 284,000+ transactions; achieved 97.4% accuracy, reduced false positive rate by 18% via SQL segmentation, and visualised KPIs and fraud trends on Power BI dashboard.

Education

Bachelor of Business Administration – Computer Applications (BBA-CA) - Ness Wadia College of Commerce

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

Profile Overview

Member sinceMay 2026

Skills (40)

Click a skill to find developers with the same skill