Back to Developers
Anshika Shivhare

Anshika Shivhare

Data Analyst intern

New Delhi, Delhi, India 80 ยท Excellent

About

Computer Science undergraduate with hands-on experience in data analysis, SQL querying, data cleaning, and dashboard development using Python, Pandas, MySQL, and Power BI. Built end-to-end analytics projects involving multi-source data integration, validation, trend analysis, and data visualization. Seeking a Data Analyst internship to apply analytical and problem-solving skills to real-world business problems.

Skills & Expertise (24)

SQL Advanced
8.0/10
2
Years Exp
Pandas Advanced
8.0/10
2
Years Exp
Problem-solving Advanced
8.0/10
2
Years Exp
Analytical Thinking Advanced
8.0/10
2
Years Exp
Power BI Intermediate
7.5/10
1
Years Exp
Excel Intermediate
7.0/10
2
Years Exp
Data Cleaning Intermediate
7.0/10
2
Years Exp
Data Visualization Intermediate
7.0/10
2
Years Exp
Python Intermediate
7.0/10
2
Years Exp
Communication Intermediate
7.0/10
2
Years Exp
Git Intermediate
6.5/10
1
Years Exp
Matplotlib CustomTkinter Time management Attention to Detail CSS HTML VS Code GitHub SQLite JavaScript C++ Data Validation MySql

Work Experience

Developer

SpendWise AI

Present - Present

Built a desktop expense tracker with SQLite storage, supporting add/delete operations across 6+ spending categories. Developed monthly tracking with budget alerts for overspending detection. Created a category-wise analytics dashboard using Pandas and Matplotlib to visualize spending patterns. Added CSV export (100+ rows of transaction data) and automated spending insights summarizing user expense patterns.

Data Analyst

MetroPulse

Present - Present

Integrated Delhi Metro ridership reports with schedule, weather, and holiday datasets to build an end-to-end analytics pipeline. Cleaned and validated ridership data across 9 metro lines and 7 months, producing 63 line-month records for analysis. Used SQL aggregations, window functions (LAG, RANK), and conditional logic (CASE) to analyse ridership trends, line contributions, and service metrics. Developed an interactive Power BI dashboard to explore ridership trends, line performance, service efficiency, and weather/calendar patterns. Found that the Yellow and Blue lines accounted for approximately 53% of recorded passenger journeys during the study period.

Education

B.Tech in Computer Science Engineering - Dr. Akhilesh Das Gupta Institute of Professional Studies

2023 - 2027 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 5/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 80/100

Profile Overview

Member sinceOct 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation