Open to opportunities

Shambhu Ram Mahto

@shambhurammahto

Message

Aspiring data analyst with strong skills in data visualization.

India

Message

What I'm looking for

I am looking for opportunities that allow me to grow in data analysis, collaborate with teams, and contribute to impactful projects.

I am a dedicated and passionate aspiring data analyst currently pursuing a Bachelor of Science in Computer Application from Ranchi University. My academic journey has equipped me with a solid foundation in database management, data analysis, and various programming languages, particularly Python and SQL. I have a keen interest in leveraging data to drive insights and support decision-making processes.

Throughout my education, I have engaged in several impactful projects, including a COVID-19 impact analysis where I utilized data visualization and statistical models to derive predictive insights. Additionally, I developed a movie recommendation system using Python and data encoding techniques, showcasing my ability to apply theoretical knowledge to practical scenarios. My technical skills extend to tools like Power BI and Tableau, where I have created interactive dashboards to analyze performance metrics and trends.

Experience

Work history, roles, and key accomplishments

Bachelor Of Science-Computer Application

Ranchi University

Jan 2022 - Present (3 years 8 months)

Completed a Bachelor of Science in Computer Application, focusing on core computer science principles and practical applications. Achieved a CGPA of 6.5, demonstrating a solid understanding of coursework.

Database Management Data Analysis Python SQL Data Visualization

Intermediate - PCM

Devi Mahto Memorial Inter College

Jan 2017 - Present (8 years 8 months)

Completed Intermediate studies with a focus on Physics, Chemistry, and Mathematics (PCM), achieving a percentage of 64%. Developed foundational analytical and problem-solving skills.

Chemistry Mathematics Analytical Skills Problem Solving

Online Store-Myntra Sales Analysis

Self Employed

Analyzed sales data from Myntra using Excel to track customer trends, inventory, and revenue growth. Utilized pivot tables, VLOOKUP, and data visualization techniques to generate actionable insights.

Microsoft Excel Pivot Tables Data Validation Sales Analysis

Music Store Data Management

Self Employed

Built an SQL database to manage music store operations, including product catalog, sales transactions, and customer details. Developed queries for data analysis and ensured data integrity through normalization and constraints.

MySQL PostgreSQL SQL Database Management Data Integrity Data Normalization

COVID-19 Impact Analysis Project

Self Employed

Analyzed the economic, social, and healthcare impacts of COVID-19 using data visualization and statistical models. Developed predictive insights on recovery trends and mitigation strategies collaborated with a multidisciplinary team for policy recommendations.

HTML CSS Python Data Visualization Statistical Modeling Predictive Analytics

Virat Kohli Performance Analysis

Self Employed

Built a Power BI dashboard to analyze Virat Kohli’s performance across formats, including runs, strike rates, and milestones. Integrated interactive visuals and filters for detailed insights.

Power BI DAX Data Modeling Excel Data Analysis Dashboards

FIFA World Cup Dashboard

Self Employed

Developed an interactive Tableau dashboard visualizing FIFA World Cup data, including team performance, player statistics, and historical trends. Utilized advanced data visualization techniques to enhance insights and storytelling.

Tableau Excel SQL Data Visualization Dashboard Development Data Storytelling

Movie Recommendation System

Self Employed

Built a Python-based movie recommendation system that suggests similar movies by analyzing genres using cosine similarity and data encoding techniques.

Python Pandas Cosine Similarity Data Encoding TMDb API TMDB API

Education

Degrees, certifications, and relevant coursework

Ranchi University

Bachelor of Science, Computer Application

2022 - 2025

Grade: 6.5 CGPA

Activities and societies: Participated in various online coding competitions and college competitions.

Studied Computer Application at Ranchi University, focusing on core concepts and practical applications. Gained foundational knowledge in computer science principles.