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

Anurag Prajapati

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

SUMMARY

Recent B.Tech graduate seeking a Data Analyst role with hands-on experience in SQL, Python, Power BI, Excel, Power Query, and DAX. Skilled in data cleaning, data modeling, ETL, dashboard development, KPI reporting, and business analytics. Built end-to-end analytics dashboards and data-driven projects to uncover trends, monitor performance, and support informed decision-making. Strong analytical, problem-solving, and communication skills with a passion for delivering actionable insights from data. TECHNICAL SKILLS

Programming Languages: Python, SQL

Data Analysis: Pandas, NumPy, Excel, DAX

Data Visualization: Matplotlib, Power BI, Tableau

Machine Learning: Scikit-learn, PyTorch, Regression, Classification, Clustering, Feature Engineering, Model Evaluation

Deep Learning: Convolutional Neural Networks (CNNs), Transfer Learning, Computer Vision Databases: MySQL

Tools & Technologies: Git, GitHub, Jupyter Notebook, Visual Studio Code, Streamlit Core Concepts: Data Preprocessing, Data Cleaning, Exploratory Data Analysis (EDA), Statistics PROJECTS

Transaction Analytics Dashboard Power BI, DAX, Power Query, Excel

• Built an interactive analytics dashboard using Power BI with data modeling, DAX measures, and Power Query transformations.

• Implemented KPIs, MoM analysis, Top-N insights, and interactive tooltips to analyze transaction and user trends. CreditWise Loan Approval Prediction Python, Pandas, NumPy, Scikit-learn, MySQL

• Developed a machine learning model to predict loan approval using customer demographic and financial information.

• Preprocessed the dataset by handling missing values, encoding categorical features, scaling numerical data, and applying Principal Component Analysis (PCA).

• Evaluated multiple classification models using Accuracy, Precision, Recall, F1-score, and Confusion Matrix. Text Summarization using T5 Transformer Python, PyTorch, Hugging Face Transformers

• Built an abstractive text summarization system using the T5 Transformer architecture.

• Fine-tuned a pre-trained T5 model using PyTorch and the Hugging Face Transformers library.

• Implemented preprocessing, tokenization, training, and inference pipelines for efficient text summarization. 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, classified equality scores, and generated business reports using Excel.

• Created dashboards to visualize key insights and support data-driven decision-making.

Contact this candidate