Hi, I am
Ashutosh Pant

I am a

I am a motivated and versatile individual, always eager to take on new challenges. With a passion for learning I am dedicated to delivering high-quality results. With a positive attitude and a growth mindset, I am ready to make a meaningful contribution and achieve great things.

Check Resume

Hi, I am Ashutosh Pant

I’m a data analyst skilled in Excel, SQL, Python, Power BI, and Tableau. Passionate about transforming raw data into actionable insights, I specialize in creating impactful dashboards and working on real-world analytical projects — from Airbnb market analysis to customer sales trends. With a strong foundation in analytics and a focus on business value, I’m driven to help organizations make smarter, data-informed decisions.

View Visuals

Skills

Here are some of my skills on which I have been working on for the past 3 years.

Data & Analytics

Excel

Google Sheets

MySQL

Python

Numpy

Tableau

Power BI

Frontend

React Js

Tailwindcss

HTML

CSS

JavaScript

Bootstrap

Backend

Node Js

Express Js

Python

MySQL

MongoDB

Firebase

DevOps

AWS

Google Cloud

Docker

Kubernetes

Prometheus

Machine Learning

Python

Tenserflow

Keras

Jupyter

Google Colab

Others

Git

GitHub

Netlify

VS Code

Linux

Ubuntu

Java

C++

Experience

My work experience as a software engineer and working on different companies and projects.

Data Analyst

Data Analysis Projects

April 2024 - Present

Spearheaded a series of end-to-end data analysis projects, transforming complex datasets into actionable business insights. Key projects include developing a Netflix content dashboard, conducting in-depth market analysis for Pratilipi and Airbnb, and analyzing user engagement trends on Wattpad. Designed and built interactive dashboards using Tableau and Power BI to visualize sales performance, customer segmentation, and market trends, consistently delivering data-driven recommendations.

Skills:

Tableau

Power BI

Python (Pandas, NumPy)

SQL

Data Visualization

Market Research

Data Scraping

Excel

Recharts

Next.js

Financial Analysis

Competitor Benchmarking

SkyScope Developer

SkyScope

2024 - Present

Developed a weather application using ReactJS, TypeScript, TanStack Query, and ShadCN UI. Integrated third-party APIs for real-time weather updates and enhanced user experience with intuitive UI/UX design.

Skills:

ReactJS

TypeScript

TanStack Query

ShadCN UI

Vite

API Integration

HOSS Ecosystem Developer

Hotel Om Shiv Shankar

Nov 2024 - March 2025

Developed two core applications for the Hotel Om Shiv Shankar ecosystem: a modern, internal management system (React, Vite, Express) for handling bookings and financial reporting, and a public-facing booking website (PHP, MySQL, AJAX) for guest reservations. Together, these platforms provide a complete, end-to-end solution for both hotel administration and customer experience.

Skills:

React

Express

PHP

MySQL

AJAX

JavaScript

TailwindCSS

Full-Stack Web Development Internship

INTERNSHIP | YHILLS -Learning Beyond Expectation

Feb 2024 - Jun 2024

Enhanced website functionality and user experience by collaborating with senior developers to design and implement new features using MongoDB, Express.js, ReactJS, and Node.js (MERN stack). Coordinated content management systems (CMS) and participated in comprehensive testing using various tools and frameworks, ensuring high-quality code and functionality.

Skills:

MongoDB

Express.js

ReactJS

Node.js

Core Java Trainee

Internshala Trainings

Feb 2024 - Aug 2023

Completed training in Core Java at Internshala Trainings, covering modules on Java fundamentals, Object-Oriented Programming, and Java application development.Gained a solid understanding of core Java concepts and application development, preparing for advanced software development roles.

Skills:

Java

Object-Oriented Programming (OOP)

Java Application Development

Projects

I have worked on a wide range of projects. From web apps to machine learning models. Here are some of my projects.

Bank Loan Analytics Dashboard

2024

SQL Server

Power BI

DAX

Data Modeling

This project demonstrates end-to-end data analysis and visualization using SQL Server and Microsoft Power BI. The goal was to analyze a financial institution’s loan dataset to uncover insights into loan performance, borrower behavior, and portfolio health.

Fitness Dashboard

2024

Power BI

DAX

Data Modeling

Excel/CSV

A dynamic Power BI dashboard designed to track fitness activities and health metrics. It provides real-time insights into finances (revenue, expenses, profit), client memberships (active and expired statuses), and monthly membership trends.

Spotify Music Analytics Dashboard

July 2024

Power BI

DAX

Data Modeling

Excel/CSV

This project showcases an interactive Power BI dashboard built to explore and visualize Spotify’s global music trends. It analyzes songs by artist, album type, popularity, explicit content, and release date.

Netflix Content Analysis Dashboard

July 1, 2024

Recharts

Next.js

Tailwind CSS

TypeScript

A comprehensive dashboard analyzing the Netflix content library, inspired by a Tableau visualization.

Pratilipi Market Analysis

June 2025

Excel

Power BI

Market Research

Financial Analysis

Competitor Benchmarking

An end-to-end market research and strategic analysis of Pratilipi, a digital storytelling platform, covering monetary growth, product features, user demographics, revenue models, market positioning, and more.

Wattpad Author & Story Analysis

Completed

Python

Jupyter Notebook

Excel

Data Scraping

Pandas

An in-depth analysis of Wattpad authors and stories to uncover trends in content, engagement, and author success, involving data scraping, analysis, and visualization.

Education

My educational journey and qualifications.

2022 - Jul 2024

Uttaranchal University, Dehradun

Master of Computer Applications - MCA

Grade: 8.33 CGPA

I recently graduated with a Master of Computer Applications (MCA) from Uttaranchal University, Dehradun. I have a CGPA of 8.33. I have taken courses in Data Structures, Algorithms, Object-Oriented Programming, Database Management Systems, Operating Systems, and Computer Networks, among others.

May 2019 - 2022

Sri Dev Suman Uttarakhand University,Uttarkashi

Bachelor of Science - BSc

I hold a Bachelor of Science (BSc) in Physics, Chemistry, and Mathematics from Sri Dev Suman Uttarakhand University, Uttarkashi. Throughout my degree, I developed a strong foundation in mathematical modeling, scientific analysis, and problem-solving, which has enhanced my analytical thinking. My coursework covered key topics in classical mechanics, organic and inorganic chemistry, linear algebra, calculus, and statistical methods. This academic background has sharpened my logical reasoning and data interpretation skills, which I effectively apply in technical problem-solving and data analysis.

May 2017 - May 2019

Rishiram Shikshan Sansthan Sr. Secondary School, Joshiyara

CBSE(XII), Science with Computer

I completed my class 12 high school education at Rishiram Shikshan Sansthan Sr. Secondary School, Joshiyara, where I studied Science with Computer Science.

May 2017

HIM Christian Academy School, Matli

ICSC(X), Science with Computer

I completed my class 10 education at HIM Christian Academy School, Matli, where I studied Science with Computer Application.

Certificates

A curated list of my professional certifications & credentials.

Certificate of Training on Core Java

Internshala Trainings

September 15, 2025

Full-Stack Web Development

YHHills

June 1, 2024

Research Methodology

NPTEL

October 2023

Data Analysis with Python

DataCamp

2024

Advanced Data Analytics

Coursera

2025

Contact Me

I'd love to hear from you. Drop me a line!