Chetan Pal
Phone: +919*********
Email: *************@*****.***
LinkedIn • Github • HackerRank • CodeChef • Leetcode PROFESSIONAL SUMMARY
Aspiring Data Analyst with a B.Tech in Computer Science and hands-on project experience using SQL, Advanced Excel, Power BI, and Python. Experienced in data cleaning, data transformation, exploratory analysis, KPI reporting, dashboard development, and business analysis. Worked with 10K+ records and relational datasets to identify trends, analyze user behavior, measure performance, and generate actionable insights. Strong understanding of SQL JOINs, CTEs, subqueries, window functions, Excel Pivot Tables, XLOOKUP, and Power BI visualizations. Seeking an entry-level Data Analyst opportunity to support data-driven business decisions. EDUCATION
Bachelor of Engineering (Computer Science) 2022 - 2026 Sagar institute of Science and technology Grade: 6.1/10.0 Intermediate (Class XII) 2021 - 2022
Prerna kiran public school Grade: 63.0%
Matriculation (Class X) 2019 - 2020
Prerna kiran public school Grade: 71.0%
PROJECTS
Social Media User Engagement Analysis ( Github) ( Demo) March 2026
Analyzed 7 relational datasets and 10K+ user-content interactions to measure user engagement, content performance, and behavioral trends.
Used SQL to combine and analyze data across multiple tables using JOINs, CTEs, subqueries, aggregations, and window functions.
Calculated key engagement metrics including likes, comments, user activity, content interactions, and engagement rates to identify performance trends.
Segmented users based on activity and engagement levels, identifying high-engagement, active, and low-engagement user groups.
Analyzed content types and hashtags to identify high-performing content and patterns contributing to stronger user engagement.
Translated analytical findings into actionable recommendations for improving user engagement, content strategy, and retention.
Zomato Restaurant Expansion Strategy’s ( Github) ( Demo) January 2026
Analyzed 10K+ restaurant records across locations, cuisines, ratings, pricing, and service availability to identify potential markets for restaurant expansion.
Cleaned and transformed raw restaurant data by handling missing values, duplicates, inconsistent formats, and data quality issues using Excel.
Performed exploratory data analysis using Pivot Tables, XLOOKUP, statistical summaries, and calculated metrics to uncover location, cuisine, rating, and pricing trends.
Evaluated key business metrics including restaurant distribution, average ratings, average cost, price-range distribution, and online delivery availability across markets.
Developed an interactive Power BI dashboard with KPIs, slicers, charts, and comparative visualizations to enable location-wise and category-wise analysis.
Generated data-driven insights and recommendations to support market selection, pricing analysis, and restaurant expansion decisions.
CERTIFICATIONS
SQL (Advanced) Certification – HackerRank HackerRank ( Link) March 2026
Certified advanced SQL proficiency in joins, subqueries, window functions, aggregations, and analytical querying for data analysis.
Microsoft Excel with A.I Masterclass Skill Course ( Link) December 2025
Certified training in advanced Excel, data manipulation, automation, and AI-assisted analytical workflows. Data Science Certification Newton School November 2025
Completed training in Python, SQL, statistics, data analysis, machine learning, and data-driven problem solving.
SKILLS
Computer Language: Python, Power BI, SQL
Databases & Data Tools: Excel, MySQL