Shivansh Rai

SR

Looking for a job

Shivansh Rai

@shivanshrai

Data Analytics Intern at InternshipStudio who turned complex datasets into KPI dashboards and business intelligence reports.

What I'm looking for

I'm looking to bring my end-to-end analyst workflow to a consulting or insights team.

At InternshipStudio, I extracted, cleaned, and validated complex datasets using SQL and Advanced Excel, with data quality checks to maintain data integrity.

I built and deployed interactive Tableau dashboards to track KPIs, helping the team spot operational bottlenecks faster.

I used exploratory data analysis to surface sales trends, seasonal patterns, and customer behavior, then turned the findings into business intelligence reports and recommendations.

For my BigBasket Capstone Project, I analyzed consumer retail data for purchasing patterns, product affinity, and supply chain efficiencies, and created Tableau visualizations for inventory turnover and regional sales.

Experience

Work history, roles, and key accomplishments

IN

Data Analytics Intern

InternshipStudio

Mar 2026 - Aug 2026 (5 months)

Extracted, cleaned, and validated complex datasets using SQL and Advanced Excel, ensuring data integrity. Built interactive Tableau dashboards to track KPIs and conducted exploratory data analysis to surface sales trends and customer behavior.

SQL Excel Tableau Data Cleaning Data Validation Exploratory Data Analysis KPI Tracking PowerPoint

Education

Degrees, certifications, and relevant coursework

BM

BITS School of Management

Minor, Business Analytics

2026 -

Pursuing a Minor in Business Analytics, expected to complete in September 2026.

UL

University of Lucknow

Bachelor of Commerce, Commerce

2023 - 2026

Bachelor of Commerce (B.Com) with relevant coursework in Economic Statistics, Business Administration, and Financial Accounting.

IP

IIT Patna

Certification, Applied AI and Data Intelligence

Certification in Applied AI and Data Intelligence from Vishlesani Hub, IIT Patna.

DE

Deloitte

Job Simulation, Data Analytics

Completed Data Analytics Job Simulation through Forage.

CA

Cisco Networking Academy

Certification, Data Analytics

Completed Data Analytics Essentials certification.

IB

IBM

Certification, Generative AI

Completed Generative AI in Action certification.

AN

Anthropic

Certification, AI Fluency

Completed AI Fluency Framework and Foundations certification.

Tech stack

Software and tools used professionally

Tableau

NumPy

Pandas

Node.js

Python

Google Sheets

SQL

Power BI

Availability

Looking for a job

Location

India

Authorized to work in

Salary expectations

456k-1000k INR

Social media

Job categories

Data Analyst Business Analyst Research Analyst

Skills

Data Analysis Business intelligence reporting Exploratory Data Analysis Data Cleaning Data Validation Data Wrangling ETL Statistical Analysis A B Testing KPI Tracking MIS Reporting SQL Python Pandas NumPy Microsoft Excel (Logical Functions)Tableau Power BI

Interested in hiring Shivansh?

You can contact Shivansh and 90k+ other talented remote workers on Himalayas.

Message Shivansh

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!