Data analyst, data science intern, python, SQL, Excel, powerBI, ML, DL

Anurag Prajapati

+91-740******* # ******************@*****.*** ï linkedin.com § github.com

SUMMARY

Data-focused B.Tech graduate specializing in Artificial Intelligence and Machine Learning, with hands-on experience in SQL, Python, Power BI, Excel, Power Query, and DAX. Skilled in data cleaning, ETL, data modeling, KPI development, exploratory data analysis, and dashboard development, with experience applying machine learning techniques for predictive analysis and deriving data-driven business insights.

TECHNICAL SKILLS

Programming: Python, SQL

Data Analysis: Pandas, NumPy, Excel

Data Visualization: Power BI, Matplotlib, Seaborn

BI & Analytics: Power Query, DAX

Machine Learning: Scikit-learn, Regression, Classification, Clustering, Feature Engineering, Model Evaluation Databases: MySQL, SQLite

Core Concepts: Data Cleaning, Data Preprocessing, Exploratory Data Analysis (EDA), Statistics, Data Modeling, ETL Tools: Git, GitHub, Jupyter Notebook, VS Code

PROJECTS

RetailIQ Python, SQL, MySQL, Power BI, Scikit-learn [GitHub]

• Developed a retail analytics and data warehousing pipeline using SQL and Python, with Power BI dashboards and KPIs to analyze sales, revenue, inventory, pricing, and demand.

• Developed and compared Logistic Regression, Random Forest, and Gradient Boosting for sales classification; identified potential data leakage and achieved 58.08% accuracy. Customer Churn Analysis Python, SQL, SQLite, Pandas, Matplotlib, Seaborn [GitHub]

• Engineered an end-to-end churn analytics pipeline across 3 relational tables, developing 20+ KPIs and identifying a 28.6% overall churn rate.

• Found 55.6% churn for monthly-contract subscribers vs. 8.3% for annual subscribers, quantifying $73.94/month MRR leakage and $2,047 CLTV erosion.

Customer Segmentation & Marketing Analytics Python, Pandas, NumPy, Scikit-learn, Matplotlib, Seaborn [GitHub]

• Engineered a customer segmentation pipeline on 2,240+ customer records, performing data cleaning, EDA, feature engineering, outlier handling, and PCA-based dimensionality reduction.

• Applied Agglomerative Clustering to identify 4 customer segments, profiling customers by income, spending, demographics, and campaign behavior to develop targeted marketing strategies. EDUCATION

Veer Madho Singh Bhandari Uttarakhand Technical University Dehradun, Uttarakhand Bachelor of Technology (B.Tech.) in Artificial Intelligence & Machine Learning 2022 – 2026 Sri Guru Teg Bahadur Public School Haldwani, Uttarakhand Senior Secondary (CBSE) – Class XII 2022

Beer Sheba Sr. Sec. School Haldwani, Uttarakhand

Secondary (CBSE) – Class X 2020

VIRTUAL EXPERIENCE

Deloitte Data Analytics Virtual Experience Remote

Forage 2026

• Completed a Deloitte job simulation focused on data analysis, reporting, and business insights.

• Analyzed employee compensation data, evaluated equality scores, and created Excel reports and dashboards to communicate insights.

Contact this candidate