Akash Gupta

Final-year B.Tech AI & ML student · Aspiring Data Analyst

Dehradun, Uttarakhand, India

@akash_gupta

LinkedIn GitHub

0 followers

🎓 B.Tech in Artificial Intelligence & Machine Learning at JB Institute of Technology, Dehradun · Graduating 2027

About

Final-year B.Tech AI & ML student with hands-on experience in Python, SQL, Excel, and Power BI for data cleaning, EDA, customer segmentation, KPI reporting, dashboards, and statistical analysis. Has worked with datasets ranging from 7K to 498K+ records and translated raw data into structured analytical outputs.

Experience

Data Analytics Intern

Thiranex

Sep 2026 – Present

Cleaned, validated, and transformed structured datasets using Python, SQL, and Excel; performed EDA and prepared analytical summaries. Identified duplicate and incomplete records affecting ~4% of the dataset and standardized key fields before analysis; summarized segment-level trends for reporting.
Data Analysis Intern

Prodigy InfoTech

Jun 2025 – Jul 2025

Queried and validated relational business data with SQL and built Power BI dashboards for sales, customer activity, conversion, and operational KPIs. Automated recurring Excel/Python data-preparation steps, reducing repetitive manual processing and standardizing the preparation workflow for recurring reports.
Python Programming Intern

YHills

Jun 2024 – Jul 2024

Applied Python to practical data-handling mini-projects; built and tested solutions through structured exercises.

Education

B.Tech

JB Institute of Technology, Dehradun

Artificial Intelligence & Machine Learning · 2027

Skills

<3 months

SQL NumPy Python Pandas Seaborn Reporting Statistics Matplotlib A/B Testing Data Cleaning Hypothesis Testing Feature Engineering

Tools / apps / platforms

3 to 6 months

Microsoft Excel

<3 months

Git MySQL GitHub Tableau PostgreSQL Jupyter Notebook Microsoft Power BI

Languages

Not stated

Hindi Speak English Speak

Projects

Website A/B Test Analysis

Python, Statistics, Excel

Evaluated 25K+ simulated visitors across control/treatment groups; calculated conversion rate, uplift, confidence intervals, and hypothesis-test results. Determined whether the observed conversion difference met the selected significance threshold and documented experiment limitations.
US Road Accident Data Analysis

Python, SQL, Excel

Analyzed 498K+ accident records across severity, location, time, weather, and road conditions; cleaned missing values and inconsistent categories with Pandas. Used SQL/Python to identify geographic, temporal, weather, and severity patterns; documented the strongest patterns in a reproducible report.
Telecom Customer Churn Analysis

Python, SQL, Power BI

Analyzed 7K+ customer records across contract, tenure, payment method, and monthly charges to identify churn patterns. Found higher/lower churn concentration across selected customer segments and tested relationships between attributes and churn. Built an interactive Power BI dashboard with churn KPIs and segment-level breakdowns.
E-Commerce Sales & Customer Analysis

Python, SQL, Power BI, Excel

Analyzed 100K+ retail transactions; cleaned duplicate/incomplete records with Pandas and profiled revenue, AOV, products, customers, regions, and monthly trends. Segmented customers in SQL by recency, purchase frequency, and order value; identified high-value segments and category/seasonal patterns. Built a Power BI dashboard for revenue, orders, AOV, top products, and monthly performance to support sales and promotional analysis.

Courses & certifications

Real World Problem Solving in Data Analytics · Prodigy InfoTech
Data Analytics Professional Certificate · Thiranex

🏆 Achievements & awards

Academic Excellence Award

2× award from JBIT
Runner-Up, 24-hour National-Level Hackathon

Data Engineer

Explore the Broxer community

💬 Q&A Ask about roles, salaries and interviews — and help others. 👥 Circles Join discussions on skills, companies and industries. 📰 Feed Follow updates and insights from the community.