Data analyst

HARSHVARDHAN SINGH SONGIRA

Bhopal, India +919********* ************************@*****.*** Linked in

PROFESSIONAL SUMMARY

Aspiring Data Analyst with hands-on experience in Advanced Excel, SQL, and Power BI through projects and online certifications. Skilled in data cleaning, transformation, visualization, and KPI reporting. Passionate about leveraging data to generate actionable business insights and eager to contribute to a data-driven team.

EDUCATION

B.Tech (Artificial Intelligence and Data Science) Aug 2021 – June 2025

Jai Narain college of technology, Bhopal CGPA: 7.93

12th Jun 2020 – Mar 2021

Royal Heights Higher Secondary, Zirapur Percentage: 82.80

10th Jun 2018 – Mar 2019

Royal Heights Higher Secondary, Zirapur Percentage: 84.80

PROJECT

Sales performance and KPI Dashboard: Apr 2025-Jul 2025

Design a Dynamic Excel Dashboard to analyse Sales performance Profit Margin, and best-selling product across the region.

Utilised PivotTables, PivotCharts, slicers, and conditional formatting for interactive visualization.

Automated data cleaning and transformation using Power Query, handling 1,000+ transaction records efficiently.

Applied advanced Excel formulas, including SUMIFS, XLOOKUP, FILTER, and IFERROR for accurate KPI calculation and reporting.

Skills: Advanced Excel, Power Query, Pivot Tables & Charts, KPI Analysis, Data Visualization, Formula Automation

College result management system using SQL: Feb 2025-Mar 2025

Developed a database-driven system using SQL to manage and analyse student academic records. Designed relational tables to store student details, subjects, and marks. Wrote SQL queries to calculate total marks, generate result reports, identify failures, and list top performers. Enabled efficient result tracking for college departments

SKILLS

PROGRAMMING LANGUAGES: Python, SQL

TOOLS & TECHNOLOGY: Excel, MySQL, Power BI

CERTIFICATES

Preparing Data for Analysis with MS Excel : Microsoft via Coursera

Python Programming Essentials: Open Edge

Data Analysis With Python: Free Code Camp

Data analytics job Simulation, Deloitte Australia : Forage