Summary
Overview
Work History
Education
Skills
Websites
Achievementsinternships
Projects
Timeline
Generic

Aditya Vijapurapu

Data Analyst
Visakhapatnam,AP

Summary

Highly motivated and analytical recent graduate with a strong foundation in statistics, programming, and data analysis, seeking to launch a career in data science. Possess hands-on experience with Python and SQL, as well as expertise in machine learning, data visualization, and statistical modelling. Eager to apply problem-solving skills and technical knowledge to drive insightful decision-making and deliver data-driven solutions. Looking forward to contributing to a dynamic team and leveraging analytical skills to support the growth and success of an innovative organization.

Overview

2
2
years of professional experience
22
22
years of post-secondary education

Work History

Hotel Booking Cancellation Project

Personal
06.2024 - 07.2024

Analyzed 119,390 hotel booking records to identify booking trends and cancellation reasons. Performed extensive data preparation, including outlier treatment and feature encoding. Developed machine learning models (Logistic Regression, Decision Tree, Random Forest) to predict cancellations, enabling personalized guest services and improved customer satisfaction.

Black Friday Sales Analysis Project

Personal
04.2024 - 05.2024

Analyzed 783,667 customer purchase records to uncover purchasing patterns across demographics. Preprocessed data, including missing value handling and feature engineering. Built and evaluated machine learning models (Linear Regression, Decision Tree, Random Forest, XGBoost) to predict purchase amounts, driving targeted marketing and personalized promotions.

IPL Match Bidding App Optimization

Personal
03.2023 - 04.2023

Optimized app performance by analyzing IPL game data using MySQL for efficient data storage and manipulation. Examined bidder, match, player, and team statistics to enhance functionality. Leveraged Tableau for data visualization, uncovering patterns and insights to improve user engagement and experience.

Intern

Visakhapatnam Port Authority
02.2023 - 04.2023

Contributed to developing a web application for managing ship berthing processes using HTML, CSS, and PHP. Gained experience in building and deploying web-based solutions for government operations, focusing on streamlining the ship berthing process through an intuitive user interface and backend functionality.

Intern

Amazon (Online)
09.2022 - 11.2022

Developed hands-on skills in AWS services like EC2, S3, and Lambda, focusing on cloud deployment, resource optimization, and security. Gained experience in managing applications, automating tasks, and enhancing performance within the AWS environment.

Education

Bachelor of Science - Statistics, India

Great Lakes Institute of Management Via Great Learning Institute
Pune, India
04.2001 - 01.2023

B.Sc (M.S.C) - undefined

Gayatri vidya parishad for degree & PG courses

12th Std - undefined

Narayana intermediate college

10th Std - undefined

Ravindra Bharathi school

Skills

SQL

Python Programming

Tableau

Data manupulation

Regression

Classification

Clustering

NLP

Prompt Engineering & Generative AI Basics

Data Analysis

Python Programming

Statistical Analysis

Microsoft Power BI

Achievementsinternships

SQL - Basic, Intermediate, Python - Basic, Intermediate, AWS cloud virtual internship, Visakhpatnam Port Trust

Projects

Optimal IPL Match Bidding App Performance - DBMS, Link Optimizing the IPL Match Bidding App., Conducted a meticulous analysis of IPL game data, aiming to extract valuable & actionable insights that can be leveraged to enhance user engagement, and elevate the overall user experience & satisfaction., - The primary focus was on improving the functionality & user experience of the IPL match bidding app. Employed the robust MySQL database management system for proficient data storage, retrieval, & manipulation. Thoroughly examined Bidder and Bidding details, Match, Player, Team information & player cum team's performance statistics etc. Utilized the power of Tableau, a cutting-edge data visualization tool, to gain a deeper understanding and uncover meaningful patterns and trends present in the visually captivating yet insightful representations of the data. Black Friday Sales Analysis Project, Comprehensive Data Analysis: Analyzed 783,667 customer purchase records to understand purchasing patterns and preferences across various demographics, providing insights into consumer behavior during Black Friday sales. Data Engineering: Carried out extensive data preprocessing, including missing value imputation, feature engineering, and categorical encoding, ensuring robust datasets for model training. Predictive Modeling: Developed and evaluated machine learning models (Linear Regression, Decision Tree, Random Forest, XGBoost) to predict purchase amounts, enabling the creation of targeted marketing strategies and personalized promotions. Hotel Booking Cancellation Project, In-Depth Data Analysis: Analyzed 119,390 hotel booking records to uncover customer booking trends, preferences, and cancellation reasons, offering actionable insights for strategic decision-making. Data Engineering: Conducted comprehensive data preparation, including outlier treatment, encoding, transformation, and scaling, to ensure high-quality datasets for machine learning model development. Predictive Modeling: Implemented and assessed ML algorithms (Logistic Regression, Decision Tree, Random Forest) to accurately forecast cancellations and demand, facilitating personalized guest services and enhancing overall satisfaction.

Timeline

Hotel Booking Cancellation Project

Personal
06.2024 - 07.2024

Black Friday Sales Analysis Project

Personal
04.2024 - 05.2024

IPL Match Bidding App Optimization

Personal
03.2023 - 04.2023

Intern

Visakhapatnam Port Authority
02.2023 - 04.2023

Intern

Amazon (Online)
09.2022 - 11.2022

Bachelor of Science - Statistics, India

Great Lakes Institute of Management Via Great Learning Institute
04.2001 - 01.2023

B.Sc (M.S.C) - undefined

Gayatri vidya parishad for degree & PG courses

12th Std - undefined

Narayana intermediate college

10th Std - undefined

Ravindra Bharathi school
Aditya VijapurapuData Analyst