ARYAN
● Open to Work

ARYAN

Data Analyst Intern

About Me

Results-driven Data Analyst and final-year B.Tech CSE student with hands-on experience in Python (Pandas, NumPy, Seaborn), SQL, Power BI, and Excel for end-to-end data analysis, ETL pipelines, and dashboard development. Proven ability to clean large datasets, perform EDA, build predictive models, and deliver actionable insights that support data-driven decision-making.

Skills & Technologies

PythonPandasNumPySeabornSQLPower BIExcelTableauC++RETL pipelinesEDAdata cleaningstatistical analysisA/B testingregressionforecastingMySQLPostgreSQLSQLiteGitJupyter NotebookGoogle ColabVS CodeMicrosoft ExcelPower BI DesktopPython for Everybody Specialization — Coursera (UnData Analytics Course — EDUCBAPower BI Data Analyst Certification — Infosys SpriData Analytics Training & Internship Program — Tra

Work Experience

Data Analyst Intern

Trainity
2025NOW

Designed and optimized SQL queries to extract, transform, and analyze datasets from multiple sources. Built Power BI and Tableau dashboards to monitor KPIs and track performance trends across business units. Performed data cleaning and statistical analysis using Python to uncover actionable business insights and delivered customized Excel training to cross-functional teams, boosting analytical efficiency by 30%.

Projects

Customer Churn Analysis & Prediction Dashboard

Analyzed 7,000+ telecom customer records using Python and SQL to identify top churn drivers across tenure, contract type, and service usage. Built a logistic regression model with 83% accuracy; exported results to Power BI for an interactive executive dashboard with KPI cards and drill-through filters.

PythonSQLPower BI

Retail Sales Performance Analysis & Forecasting

Cleaned and transformed 50,000+ rows of retail transaction data, resolving nulls, outliers, and schema inconsistencies using Pandas and Power Query. Conducted time-series analysis to uncover seasonal trends; built a 3-month revenue forecast using moving-average modeling for weekly business reviews.

PythonExcelPower BI

COVID-19 Global Data Analysis & Visualization

Queried a public COVID-19 dataset via PostgreSQL to track infection rates, mortality trends, and vaccination progress across 50+ countries. Merged and cleaned multi-source datasets using Pandas, resolving schema mismatches and 15%+ missing values.

PythonPostgreSQLMatplotlib

Education

B.Tech

Computer Science

NIMS University2022 - 2026

Class 12

Science (PCM)

Navyug Sr. Sec. School2021 - 2021

Class 10

Navyug Sr. Sec. School2019 - 2019
ARYAN - Data Analyst Intern | HiringAnt