Summary
Overview
Work History
Education
Skills
Websites
Projects
Timeline
Generic

PRINCE DAGAR

Delhi

Summary

Experienced IT professional with strong analytical skills. Proficient in Python, SQL, and Excel for data manipulation and interpretation. Detail-oriented learner who delivers high-quality insights and reports to drive informed business decisions.

Overview

2
2
years of professional experience

Work History

Assistant Software Engineer

Tata Consultancy Services (TCS)
Gurgaon
11.2022 - Current
  • Successfully conducted data analysis and reporting to support strategic decision-making.
  • Developed and implemented data-driven solutions to optimize business processes and improve efficiency.
  • Utilized SQL and Python to extract, clean, and analyze large datasets from various sources.
  • Built interactive dashboards and visualizations using tools like Excel and Power BI to communicate insights effectively.

Education

B. Tech, Information Technology -

Dr Akhilesh Das Gupta Institute of Technology & Management
07-2022

Senior Secondary (XII), Science -

N. C. Jindal Public School (CBSE Board)
05-2018

Secondary (X) -

N. C. Jindal Public School (CBSE Board)
05-2016

Skills

  • Python
  • Power BI
  • Git
  • Data Analysis
  • Microsoft Office Excel
  • UNIX

Projects

Pizza Sales Report using Power BI & SQL

Link: https://github.com/princedagar71/Pizza-Sales-Report-SQL-Power-BI-Project-

  • Utilized SQL and Power BI to analyze pizza sales data, uncover trends and insights.
  • Created KPIs, daily/monthly trends, % of sales by category/size, and top/bottom 5 products using SQL queries.
  • Developed dashboards in Power BI for effective data visualization and stakeholder communication.

Technical Skills: SQL, Power BI, Data Analysis, Data Visualization, Dashboarding

Electronics Sales Analysis using Python

Link: https://github.com/princedagar71/Electronic-Sales-Analysis-Python-Project

  • Analyzed electronics sales data to identify trends and derive insights.
  • Employed Python libraries for data merging, cleaning, visualization, and analysis.
  • Leveraged data to answer business-critical questions and support decision-making.

Technical Skills: Python, Data Analysis, Data Visualization, Problem-Solving

Bikes Sales Dashboard using Excel 

Link: https://github.com/princedagar71/Bike-Sales-Dashboard-Excel-Project

  • Set up, cleaned, and analyzed bike sales data using Excel.
  • Created pivot tables and dashboards for data visualization and trend identification.
  • Effectively communicated findings to stakeholders in a clear and concise manner.

Technical Skills: Excel, Data Analysis, Data Visualization, Presentation Skills

Timeline

Assistant Software Engineer

Tata Consultancy Services (TCS)
11.2022 - Current

B. Tech, Information Technology -

Dr Akhilesh Das Gupta Institute of Technology & Management

Senior Secondary (XII), Science -

N. C. Jindal Public School (CBSE Board)

Secondary (X) -

N. C. Jindal Public School (CBSE Board)
PRINCE DAGAR