Certified in advanced SQL with proficiency in joins, window functions, CTEs, query optimization, indexing and data modelling

SQL (Advanced)

<ul><li>Built a strong foundation in data science concepts, including data cleaning, data analysis, and visualization, as part of Newton School’s structured curriculum.</li><li>Developed expertise in SQL and Advanced SQL for data querying, manipulation, and optimization, along with proficiency in Power BI for creating interactive dashboards and visual reports.</li><li>Completed Excel, SQL, and Power BI modules, culminating in capstone projects focused on data visualization and actionable insights for business solutions.</li></ul>

Data Science and AI

<ul><li>Worked with Pivot Tables, VLOOKUP and advanced Excel functions.</li><li>Applied Excel techniques to analyze datasets and generate insights.</li><li>Developed practical understanding of data visualization and reporting.</li></ul>

Advanced Microsoft Excel 

Bachelor of Commerce

Commerce

Intermediate (Class XII)

Matriculation (Class X)

Punjabi University, Patiala

India

Aspiring Data Analyst with hands-on experience in SQL, Excel and Power BI. 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>Developed an end-to-end Bank Customer Churn Analysis solution by analyzing 10,000 customer records across 7 integrated datasets.</li><li>Built 3 interactive Power BI dashboards with KPIs and visualizations to monitor customer behavior, churn trends and banking performance.</li><li>Performed data cleaning, transformation and data modeling using Power Query, establishing relationships across multiple tables.</li><li>Created DAX measures and calculated columns to analyze KPIs such as Churn Rate, Active Customers, Average Balance and Customer Segmentation.</li><li>Wrote SQL queries for customer segmentation, churn analysis and business insight generation.</li><li>Identified key churn drivers, including Germany (32.44% churn) and customers aged 46–55 (50.57% churn), and proposed data-driven retention strategies.</li></ul>

Bank Customer Churn 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 kaur

Social Accounts

Achievements

Projects

Bank Customer Churn Analysis

Social Media Engagement Analysis

IT Ticket Analysis Excel

Education

Punjabi University Patiala

Central Board of Secondary Education

Central Board of Secondary Education

Certificates

SQL (Advanced)

Data Science and AI

Advanced Microsoft Excel

Skills