Aspiring Data Analyst
Motivated Computer Applications graduate with hands-on experience in data wrangling, dashboard creation, visualization, and exploratory data analysis.
About Me
I am an MCA student and aspiring Data Analyst with a strong foundation in Python, SQL, Power BI, Excel, HTML, CSS, and JavaScript. I completed a 45-day intensive Data Analysis training where I worked on real-world datasets, performed data cleaning, created visualizations, and developed dashboards to present meaningful business insights.
Data Analysis Training
Major Projects
In Progress
Skills
Python, Pandas, NumPy, Matplotlib, SQL, MySQL
Power BI, Microsoft Excel, Pivot Tables, VLOOKUP, Charts
HTML, CSS, JavaScript, Responsive Web Design
Analytical Thinking, Data Storytelling, Team Collaboration, Problem Solving
Projects
Desktop-based employee management application with user authentication, CRUD operations, employee record tracking, database integration, and an interactive GUI for efficient workforce management.
Discuss Project →Analyzed credit card transaction data to identify fraudulent activities using data cleaning, exploratory data analysis, visualization, and predictive modeling. Built interactive dashboards to monitor fraud patterns and risk indicators.
Discuss Project →Real-time weather app using OpenWeatherMap API to display temperature, humidity, forecasts, weather icons, and dynamic UI updates.
Discuss Project →Analyzed match data to identify player and team performance trends with KPIs like batting average, bowling economy, and win rates.
Discuss Project →Responsive front-end clones demonstrating UI/UX design, layout building, navigation, and interactive web development concepts.
Discuss Project →Browser-based music player with playlist, playback controls, modern UI, and JavaScript-based interaction handling.
Discuss Project →Certifications
Machine Learning Using Python – SimpliLearn
IoT-Network Specialist Certificate Programme – Reliance Foundation
Python Programming – Allsoft Solutions, Mohali
AI Tools Mastery Program – be10X
Web Designing – National Institute of Computer Education, Palampur
Social Media Management – N.S.D.C., SCVB College, Palampur
Education
Chandigarh Group of Colleges, Landran | 2024 – 2026
SCVB Govt. Degree College, Palampur | 2021 – 2024 | 69%
Rainbow International School, Nagrota Bagwan | 2021 | 61%
National Institute of Computer Education, Palampur | 2024
Contact
Email: rana.shayam2002@gmail.com
Phone: +91 6230471022
LinkedIn GithubLocation: Kangra, Himachal Pradesh
Languages: English, Hindi
