<ul><li>Achieved SQL (Basic to Advanced) certification, demonstrating strong proficiency in JOINS, CTEs, window functions, and large-scale data analysis.</li></ul>

SQL (Basic to Advanced) Certification

<ul><li>Performed KPI analysis and exploratory data analysis (EDA) to derive actionable insights from datasets.</li></ul>

SQL Bootcamp 

<ul><li>Gained hands-on expertise in advanced Excel functions, Pivot Tables, and data analysis techniques for business insights.</li></ul>

Advanced Excel 

<ul><li>Pursuing a comprehensive, multi-phase certification covering data analysis, business intelligence, machine learning, deep learning, and artificial intelligence, aligned with industry requirements.</li><li>Gaining hands-on experience with tools including Advanced Excel, SQL, Power BI, Python, and libraries such as NumPy, Pandas, Matplotlib, and Seaborn.</li></ul>

Professional Certificate in Data Science & AI

<ul><li>Gained foundational experience in Excel, SQL, and basic Python concepts for data analysis and data-driven insights.</li></ul>

Data Science Course

<ul><li>Core Member, Dramatics Society – Developed strong communication, teamwork, and stakeholder interaction skills.</li><li>Volunteer, Social Club – Enhanced problem-solving and leadership abilities through community initiatives.</li></ul>

Bachelor of Technology

Chemical Engineering

Intermediate (Class XII)

Science

Matriculation (Class X)

India

Data Analyst skilled in SQL, Excel, and Power BI with experience in data cleaning, transformation, and visualization. Proficient in analyzing large datasets to identify trends, patterns, and actionable business insights. Experienced in building dashboards, performing KPI analysis, and supporting data-driven decision-making. Strong understanding of business requirements, process improvement, and stakeholder-focused analytics to drive organizational growth.

<ul><li>Analyzed a 119,390-record hotel booking dataset to identify customer behavior, booking trends, and cancellation patterns.</li><li>Conducted data preprocessing and feature engineering, creating variables such as stay length, total guests, and year-month for deeper analysis.</li><li>Discovered that City Hotels experienced ~30% cancellations vs. ~23.5% for Resort Hotels, while longer lead times were strongly associated with higher cancellation risk.</li><li>Recommended strategies including early booking confirmations, repeat customer retention programs, and optimized cancellation policies to improve occupancy and revenue.</li></ul>

Hotel Booking Analysis (EDA Project)

<ul><li>Analyzed 10,000+ customer records to identify key drivers of churn and retention.</li><li>Built MySQL queries to generate KPIs (avg credit score: 650.53, active membership: 51.5%).</li><li>Improved data accuracy by 30% through efficient data processing and validation.</li><li>Created Power BI dashboards to analyze churn trends, customer segments, and profitability.</li><li>Provided recommendations to reduce churn by 15–20% through targeted customer engagement.</li></ul>

Bank CRM Analysis | Power BI

<ul><li>Conducted an in-depth analysis of Instagram user engagement using MySQL Workbench to understand user behavior and activity patterns.</li><li>Analyzed activity distribution to gain insights into the platform’s user base.</li><li>Segmented users into high, moderate, and low engagement groups to improve user experience and retention strategies.</li><li>Identified that low-engagement users used fewer and less popular hashtags, while high-engagement users used relevant and trending hashtags.</li><li>Suggested strategies including influencer collaborations, hashtag optimization, and discount offers to increase reach.</li></ul>

Instagram User Engagement Analysis | SQL

<ul><li>Analyzed investment data of Rs. 1 Crore in AstroSage to ensure effective fund utilization and growth.</li><li>Conducted comprehensive data analysis on platform activities to identify key user behavior patterns.</li><li>Identified that 68% of consultations were failed or incomplete, impacting customer retention, while only 57% of calls were from repeat customers.</li><li>Observed that 52.8% of agents received ratings below 4, with calls generating the highest revenue and chats having the highest user interactions.</li><li><p>Developed data visualizations to support decision-making, improving customer satisfaction and profitability.</p></li></ul>

UPEKSHA

Social Accounts

Achievements

Projects

Hotel Booking Analysis (EDA Project)

Bank CRM Analysis | Power BI

Instagram User Engagement Analysis | SQL

AstroSage Call Center Analysis | Excel

Education

Institute of Engineering & Technology, Lucknow

S.V.M Inter College, Jhansi

S.M.J. Higher Secondary School

Certificates

SQL (Basic to Advanced) Certification

SQL Bootcamp

Advanced Excel

Professional Certificate in Data Science & AI

Data Science Course

Skills