<ul><li>Demonstrated proficiency in SQL querying and data extraction.</li><li>Worked with SELECT, WHERE, JOIN, GROUP BY, ORDER BY clauses.</li><li>Performed data filtering, aggregation (COUNT, SUM, AVG), and sorting.</li><li>Applied SQL for analyzing structured datasets and generating insights.</li></ul>

- Gained hands-on experience in data cleaning, data analysis and dashboard creation.- Worked with Pivot Tables, VLOOKUP and advanced Excel functions.- Applied Excel techniques to analyze datasets and generate insights.- Developed practical understanding of data visualization and reporting.

Spreadsheets

MS EXCEL : Beginner to advanced course

Advanced Microsoft Excel 

<ul><li>Delivered multiple academic presentations using structured data and visual aids.</li><li>Collaborated in group discussions to analyze topics and present key insights.</li><li>Designed professional PowerPoint presentations using charts and data visualization.</li><li>Assisted peers in organizing and improving presentation content and structure.</li><li>Active learner through online skill-based courses.</li></ul>

Bachelor of Commerce

Commerce

Intermediate (Class XII)

Punjabi University, Patiala

India

Aspiring Data Analyst with hands-on experience in SQL, Excel and social media engagement analysis. Skilled in analyzing user behaviour, identifying trends, building dashboards and generating actionable insights through data visualization and reporting. Strong interest in data-driven reporting, audience analytics and trend analysis.


<ul><li>Analyzed Instagram-style social media dataset containing 100 users, photos, likes, comments and follows data using MySQL Workbench.</li><li>Performed user engagement analysis by writing complex SQL queries using JOINS, CTEs, subqueries, aggregate functions and window functions.</li><li>Identified top influencers, highly engaged users and inactive users by analyzing follower count, posting activity, likes and comments trends.</li><li>Discovered a strong positive correlation (~0.99) between posting activity and user likes helping understand engagement behaviour patterns.</li><li>Conducted user segmentation and interaction trend analysis to generate business insights for improving platform engagement and user retention.</li></ul>

Social Media Engagement  Analysis

<ul><li>Analyzed 97000+ IT support tickets to identify inefficiencies in resolution time, ticket prioritization and service performance.</li><li>Detected misalignment between ticket severity and assigned priority highlighting gaps in escalation.</li><li>Evaluated system effectiveness with average resolution time of 4.5 days and average satisfaction score of 4.1/5 across all tickets.</li><li>Analyzed year-wise ticket growth (2016-2020) showing consistent increase in volume.</li><li>Provided data-driven recommendations to improve operational efficiency through automation, training and system upgrades.</li></ul>

Harmanpreet kaurIndia

Social Accounts

Achievements

Projects

Social Media Engagement Analysis

IT Ticket Analysis Excel

Education

Punjabi University Patiala

Central Board of Secondary Education

Certificates

SQL

Spreadsheets

Advanced Microsoft Excel

Skills