Back to Developers
Anushal Gupta

Anushal Gupta

Data Analyst

India 85 · Excellent

About

Results-driven Data Analyst and BI Developer with hands-on experience building production-grade ETL pipelines, SQL-driven analytics, and Power BI dashboards at DRDO Delhi. Delivered end-to-end analytics projects uncovering $2.71M in locked inventory capital, 65.69% vendor concentration risk, and top-15% customer revenue drivers. Completed industry job simulations with BCG X (Data Science), Deloitte (Data Analytics), and JPMorgan Chase (Quantitative Research). Proficient in Python (Pandas, NumPy, Scikit-learn), SQL (advanced joins, CTEs, window functions), Power BI (DAX), Tableau, and Excel. Open to Data Analyst, BI Analyst, MIS Analyst, and Junior Data Engineer roles across India.

Skills & Expertise (55)

Python Advanced
8.9/10
3
Years Exp
SQL Advanced
8.5/10
3
Years Exp
Pandas Advanced
8.3/10
3
Years Exp
NumPy Advanced
8.3/10
3
Years Exp
Feature Engineering Advanced
8.0/10
3
Years Exp
ETL Pipeline Design Intermediate
7.0/10
0.5
Years Exp
Random Forest Intermediate
6.5/10
0.5
Years Exp
VS Code Streamlit EDA Statistical Analysis AWS Hadoop PySpark BigQuery Git GitHub Jupyter Notebook Google Cloud Google Sheets Google Gemini API Prompt Engineering MediaPipe OpenCV JavaScript Typescript Java Firebase Firestore MongoDb Vercel Tableau scikit-learn Matplotlib Seaborn Joins CTEs Window Functions Subqueries Aggregations Power BI DAX Power Query Data Modelling Data Cleaning Excel Pivot Tables VLOOKUP Index-match Dynamic Arrays MySql Postgresql SQLite Snowflake Data Validation Anomaly Detection

Work Experience

Data Analyst Intern

Defence Research and Development Organisation (DRDO)

Oct 2025 - Apr 2026

Designed and implemented Python and SQL ETL pipelines to ingest, clean, and standardize 50,000+ records per dataset, cutting manual preprocessing effort by ~60% and accelerating downstream analysis cycles. Performed systematic data validation and anomaly detection using SQL window functions and Python (Pandas/NumPy), resolving 3,200+ data quality issues to achieve ~94% dataset accuracy for reporting. Built an EEG-based mental state classification system (Focused / Unfocused / Drowsy) using Random Forest on multi-channel time-series signal data, improving macro F1-score from 0.49 to 0.56 through iterative spectral feature engineering and class-imbalance correction. Translated stakeholder reporting requirements into structured analytical reports and SQL-backed dashboards, supporting operational decision-making workflows. Documented ETL workflows, validation logic, and troubleshooting procedures, ensuring audit-ready and reproducible analytics processes compliant with organizational standards.

Education

B.Tech – Computer Science & Engineering - KCC Institute of Technology and Management, Greater Noida (Dr. A.P.J. Abdul Kalam Technical University)

2022 - 2026 · Afghanistan

Certifications

Data Science Job Simulation – EDA, Feature Engineering, Modelling & Business Insights

BCG X (Forage) · 2026

Data Analytics Job Simulation – Data Analysis & Forensic Technology

Deloitte (Forage) · 2026

Quantitative Research Job Simulation – Price Analysis, Credit Risk & FICO Scoring

JPMorgan Chase & Co. (Forage) · 2026

Snowflake Data Warehousing – Hands-On Essentials Badge 1

Snowflake Inc. · 2026

DRDO Internship Certificate – Data Analyst

INMAS, Defence Research & Development Organisation (DRDO) · 2026

Introduction to Data Analytics

Simplilearn SkillUp · 2025

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 sinceApr 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation