Summary
Overview
Work History
Education
Skills
Affiliations
Certification
Languages
Voluntary Experience
Timeline
Generic

Avi Gupta

New Delhi

Summary

I’m a budding data analyst with a strong foundation in Excel, SQL, Power BI, and Python for data analysis and visualization. I’ve worked on hands-on projects involving real-world datasets where I cleaned data, analyzed trends, and created dashboards. I enjoy working with data and am always eager to learn and improve my skills to draw meaningful insights.

Overview

1
1
Certification

Work History

Web Developer Intern

Teachnook
New Delhi
06.2024 - 07.2024
  • Hands-on experience in Web Development through internship, working with HTML, CSS, JavaScript, and React to build responsive and interactive websites.
  • Gained knowledge in front-end development, user interface design, and API integration.
  • Developed strong team collaboration skills, following best practices, and managing project timelines effectively.
  • Built expertise in Data Analysis using Microsoft Excel, SQL, Power BI for data visualization and reporting.
  • Proficient in Python for data analysis, with experience using Pandas, NumPy, and Matplotlib for data cleaning, processing, and visualization.
  • Completed data analysis projects involving real-world datasets to uncover trends, generate reports, and create interactive dashboards.

Education

Senior School Certificate (Class XII) - PCM

Salwan Public School
New Delhi,India
01-2022

Skills

  • Microsoft Excel – Data cleaning, formulas, pivot tables, VLOOKUP, charts
  • SQL – Writing queries to extract, filter, and join data from databases
  • Python – Basics for data analysis using:
    Pandas (data manipulation)
    NumPy (numerical operations)
    Matplotlib / Seaborn (visualizations)
  • Data Visualization Tools

  • Power BI (dashboards, interactive visuals)
  • Data Cleaning and Preprocessing – Handling missing data, removing duplicates, formatting
  • Statistics Basics – Mean, median, mode, standard deviation, correlation, hypothesis testing
  • Problem Solving & Logical Thinking
  • Communication Skills – Explaining insights clearly
  • Critical Thinking – Interpreting data to support decisions
  • Curiosity & Willingness to Learn – Staying updated with tools and trends
  • Team Collaboration – Working with developers, managers, and other analysts

Affiliations

  • Outside of my professional development, I make sure to maintain a healthy balance in life, managing my academic responsibilities while staying engaged in extracurricular activities. I believe in working hard but also making time for hobbies like reading and fitness, which help me stay focused and energized. This ability to manage multiple aspects of life has helped me become adaptable, organized, and resilient in facing challenges.

Certification

  • Certificate of Completion and Excellence in C++ (Coding Ninjas)
  • Certificate of Course completion in Web Development (Teachnook in collaboration with Cognizance'24 IIT Roorkee)
  • Certificate of Internship completion in Web Development (Teachnook and RHYNO)
  • Certificate of Participation in Online Aptitude Assessment L'Oréal Sustainability Challenge 2024 (L'Oréal)
  • LOR issued by Teachnook

Languages

Hindi
First Language
English
Proficient (C2)
C2

Voluntary Experience

NGO voluntarily works in a needy children's school in a rural location

Timeline

Web Developer Intern

Teachnook
06.2024 - 07.2024

Senior School Certificate (Class XII) - PCM

Salwan Public School
Avi Gupta