Arun Kumar Gupta

Data Analyst

[email protected] +91 7974552459

Resume

Hello, I am

Arun Kumar Gupta.

3

PowerBI
Projects

1

SQL
Project

About Me

Hi, I’m Arun Kumar Gupta, a passionate Data Analyst with a B.Tech in Computer Science from IIIT Vadodara. I enjoy turning raw data into meaningful insights that support smarter business decisions.

Over the past year, I’ve built strong skills in SQL, Python, Power BI, Excel, and Power Query, working on data wrangling, visualization, and reporting. I love uncovering patterns that drive growth, efficiency, and strategy.

With a foundation in both technical tools and business thinking, I focus on communicating insights clearly and effectively to a range of audiences. I also value collaboration, problem-solving, and continuous learning.

Previously, I gained experience as an Android Developer, contributing to real-time applications and team-driven improvements — giving me a broader view of product and data alignment.

I’m currently open to new opportunities where I can contribute, grow, and apply my analytical mindset in a dynamic, data-driven environment.

Key Skills

Power BI

MySQL

Microsoft SQL Server

Excel

Python

Numpy

Pandas

Matplotlib

Data Visualizations

Data Cleaning

ETL

My Projects

Business Insights 360

Domain/Function: FMCG

Sales & Forecasting Analysis

Domain/Function: Sales & Forecasting Analytics

Uber Trip Analysis

Domain/Function: Transportation & Mobility Analytics

ShopEasy Case Study

Domain/Function: Marketing

My Experience

Android Developer Intern @Ypsilon IT Solutions Pvt Ltd

Jan 2024 – Jun 2024

- Debugged and optimized performance across 5+ Android applications to enhance user experience.

- Applied agile practices and received 100+ hours of mentoring from senior developers, sharpening Android development skills.

_______________________________________________________________

Android Developer Intern @AD Infocom Systems

May 2023 – Jul 2023

- Upgraded a farmer-centric app by adding 4+ functional modules, including e-commerce and APMC updates.

- Published 100+ articles and FAQs within the app, driving a 30% increase in user engagement.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/arun-kumar-gupta-393127208/

Call Me

+91 7974552459

GitHub

https://github.com/ArunGuptaaa

PowerBI Project

Business Insights 360

Domain/Function: FMCG

Developed a comprehensive Business Intelligence solution using Power BI and SQL for AtliQ Hardware, focusing on Sales, Marketing, Finance, and Supply Chain insights. Implemented interactive dashboards, dynamic KPIs, and data modeling to drive strategic decision-making.

View Project
on GitHUB

Hell

Project Details

- The Business Insights 360 project was created for AtliQ Hardware, a multinational hardware manufacturing company.
- The goal was to build an end-to-end analytics solution that provided actionable insights across multiple business domains, including sales, marketing, finance, and supply chain.
- I leveraged Power BI for data visualization and reporting, using advanced DAX calculations and dynamic KPIs to track key performance metrics.
- The project involved building a robust data model using the Snowflake schema, optimizing it for performance and flexibility.
- Dashboards were designed to support decision-making, featuring interactive visuals, trend analysis, and detailed reports on sales, revenue, customer performance, and operational efficiency.
- Additionally, Power Query was used for data cleaning and shaping, ensuring that the reports were accurate and up to date.
- The project empowered the management team to make data-driven decisions and improve business outcomes.

Live Interactive Dashboard

SQL Project

Sales & Forecasting Analysis

Domain/Function: Sales & Forecasting Analytics

Manufacturing Sales & Forecasting Analysis — Performed SQL-based analysis on 1M+ records to uncover sales trends, forecast accuracy, and customer insights using stored procedures, views, and automated reporting.

View Project
on GitHUB

Hell

Project Details

- This project involved end-to-end SQL analysis on a large-scale manufacturing dataset to generate actionable insights into sales performance, market trends, and forecast accuracy.
- Conducted 10+ ad-hoc analyses, including top customers/products by net sales and regional market share.
- Developed stored procedures, views, and implemented automation using triggers and events to streamline reporting and cut manual effort by ~60%.
- The solution empowered strategic decision-making across sales and supply chain functions.

PowerBI Project

Uber Trip Analysis

Domain/Function: Transportation & Mobility Analytics

Visualized and analyzed Uber trip data using Power BI to uncover trends in booking behavior, vehicle usage, and location demand with dynamic visuals and drill-through exploration.

View Project
on GitHUB

Hell

Project Details

- This interactive dashboard project explores Uber trip data to extract meaningful insights using Power BI.
- It highlights patterns in trip frequency, duration, surge pricing, payment types, and vehicle preferences.
- Advanced DAX measures and drill-through capabilities allow users to explore hourly trends, top pickup/drop-off points, and day vs. night booking behavior.
- Data was cleaned and transformed using Power Query from two Excel sources: trip details and a location mapping table.
- Designed to support data-driven decisions in urban mobility and ride-sharing operations.

Live Interactive Dashboard

PowerBI Project

ShopEasy Case Study

Domain/Function: Marketing

Developed an interactive Power BI report for ShopEasy to analyze engagement, conversion, and customer feedback using SQL and sentiment analysis. Enabled data filtering across months and years for dynamic insights.

View Project
on GitHUB

Hell

Project Details

- Designed a Power BI report for ShopEasy to address declining customer engagement and conversions despite high marketing spend.
- Transformed records using SQL and integrated Python with SQL Server to perform sentiment analysis on 10K+ customer reviews.
- Developed four dashboards:
i) Overview (KPI summary and navigation),
ii) Social Media (clicks, likes, views by content type and platform),
iii ) Conversion (actions like View, Click, Drop-off, Purchase with trends by product and month),
iv) Customer Reviews (average rating, sentiment vs review volume, detailed review table).
- Enabled time-based filtering and interactive drill-downs, empowering the marketing team to uncover performance gaps and make data-driven campaign decisions.