Open to opportunities

Shivansh User

@shivanshuser5

Aspiring Data Analyst turning Python, SQL, and Power BI into actionable insights through clean, visual, dashboard-ready analysis.

India

Message

What I'm looking for

I’m looking for an entry-level data/BI role where I can build interactive dashboards, run Python-SQL analysis, and help teams make data-driven decisions using clean, visual, insight-focused reporting.

I’m an aspiring Data Analyst with hands-on experience in Python, SQL, and Power BI, focused on turning raw data into actionable business insights. I’m currently pursuing a B.S. in Data Science and Artificial Intelligence, and I enjoy transforming messy datasets into reliable, decision-ready analysis.

In my projects, I analyze real-world business data end-to-end: cleaning and preprocessing, running exploratory and statistical analysis, and building interactive dashboards. For COVID-19 India data, I engineered derived metrics, created multiple visualizations, and extended the work into a Power BI dashboard with drill-through pages, bookmarks, and a state-wise shape map.

I also built an e-commerce analytics dashboard using Python across 100K+ orders and multiple relational datasets, including modeling a star schema in Power BI. I computed RFM scores for segmentation, identified correlations between delivery delays and review scores, and designed slicers and drill-down visuals so non-technical stakeholders can explore results confidently.

Experience

Work history, roles, and key accomplishments

E-Commerce Customer & Order Analytics

Personal Project

Analyzed 100K+ e-commerce orders across multiple relational datasets to study sales, delivery, and customer behavior, including customer RFM scoring for segmentation. Built an interactive Power BI dashboard using a star schema and identified a correlation between delivery delays and review scores.

data preprocessing Recency Frequency Monetary Customer Segmentation Python Pandas NumPy Power BI Data Cleaning Star Schemas Data Visualization Slicers and Drill Down Dashboards

COVID-19 India Data Analysis

Personal Project

Analyzed state-wise COVID-19 cases and vaccination data using Python to compute active cases, recovery rate, and mortality rate, and produced multiple visualizations. Built an interactive Power BI dashboard with drill-through pages and bookmarks for cases and vaccination progress views.

data preprocessing Python Pandas NumPy Matplotlib SeaBorn Plotly Data Cleaning Statistical Analysis Data Visualization Power BI Data Modeling Pivot Tables

Python Developer Certification

FreeCodeCamp

Completed 300+ hours of Python learning covering OOP, algorithms, data structures, and error handling, and shipped multiple certification projects demonstrating modular code design.

Python Algorithms Data Structures Error Handling