Available for opportunities

Vanshika Kumar

📊 Data Analyst 🎨 Creative Head 📈 Strategy Lead 🌟 VP – Street Cause

Transforming raw data into actionable business intelligence — and raw ideas into compelling creative content. Where analytics meets storytelling.

View My Work Hire Me
Vanshika Kumar
SCROLL DOWN
Who I am
About Me

I'm Vanshika Kumar, a final-year Statistics student at Ramjas College, Delhi University (B.Sc. Statistics, 2023–2026) with a dual edge — data analyst and creative strategist.

On the analytics side, I turn messy datasets into decision-ready insights using SQL, Python, Power BI & Tableau, across healthcare, retail, procurement, and cybercrime domains.

On the creative side, I lead the entire digital presence of the Statistics Department at Ramjas College and currently drive strategy at AICC (All India Culture Council).

📍 Delhi, India🎓 B.Sc. Statistics 💼 Open to Full-time🔍 Data Storyteller🎬 Content Creator
3+
Internships
7+
Projects
10K+
Records Processed
2K+
Volunteers Led
Work history
My Experience
Head of Strategy Department ONGOING
AICC – All India Culture Council
2025 – Present
  • Leading the Strategy Department, overseeing planning, execution, and direction of key organisational initiatives.
  • Developing data-informed strategies to strengthen AICC's outreach and cultural programming impact across India.
  • Coordinating cross-functional teams to align creative, operational, and analytical goals under a unified strategy.
Data Analyst Intern
CognoRise Infotech
Jul 2024 – Aug 2024
  • Designed analytics solutions identifying business trends, improving operational efficiency by 12%.
  • Built Power BI & Tableau dashboards, improving reporting accuracy by 25%.
  • Extracted, cleaned and validated 1,000+ real-time records with advanced SQL for strategic insights.
Data Analyst Intern
Ignite Intern
May 2024 – Jul 2024
  • Cleaned and preprocessed 2,000+ sales records using Python & Excel, improving data accuracy by 15%.
  • Conducted EDA to identify seasonal purchasing trends and high-margin products.
  • Designed dashboards supporting pricing and sales optimization strategies.
Technical stack
My Skills
📊 BI & Visualization
Power BI90%
Tableau85%
Microsoft Excel92%
DAX / KPI Design85%
💾 Data & Databases
SQL93%
MySQL88%
ETL Pipelines80%
Data Warehousing78%
🐍 Python Ecosystem
Python88%
Pandas / NumPy87%
Matplotlib / Seaborn83%
Scikit-learn72%
🎨 Creative Tools
Canva92%
Video Editing85%
Social Media Strategy88%
Content Planning90%
🧠 Soft Skills
Analytical ThinkingReport BuildingTeam ManagementLeadershipAdaptabilityData StorytellingCreative DirectionStrategic PlanningCommunicationProblem Solving
What I've built
Featured Projects
01
🚬 Smoking Behavior & Risk Assessment
In-depth analysis of 2,000+ patient records uncovering smoking patterns and clinical risk factors with interactive Power BI dashboards.
Power BIExcelPythonData Modeling
↗ Live Demo⌥ GitHub
02
🏗️ SQL Data Warehouse
Medallion Architecture (Bronze → Silver → Gold) warehouse with ETL pipelines integrating 10,000+ CRM & ERP records.
Advanced SQLETLData Architecture
↗ Live Demo⌥ GitHub
03
📦 Vendor Performance Analysis
Revealed 65.7% purchase concentration, 72% cost reduction, and flagged $2.71M low-performing inventory via hypothesis testing.
SQLPythonETLPower BI
↗ Live Demo⌥ GitHub
04
🎵 Spotify Insights Dashboard
Identified artist dominance, chart trends, listener behavior and monthly popularity shifts via interactive KPI dashboards.
Power BIDAXData ModelingKPI
↗ Live Demo⌥ GitHub
05
🛒 Blinkit Sales Analysis
Tier 3 outlets at 472K sales, Supermarket Type 1 at 787K (65%+), customer shift toward low-fat items revealed.
Power BISQLDAXKPI
↗ Live Demo⌥ GitHub
06
🔐 Cyber Crime Trends – India
NCRB & NCRP data analytics uncovering rising fraud trends (2021–2023), metro hotspots, and education scam patterns.
Power BIPythonPandasData Cleaning
↗ Live Demo⌥ GitHub
07
🏠 Global Airbnb Performance Dashboard
Explored key trends across major global cities — Paris, NY & Sydney dominate 50% listings. Uncovered COVID-19 impact, seasonal peaks, and host verification insights.
Power BIData VisualizationStorytellingBusiness Insights
↗ Live Demo⌥ GitHub
Beyond data
Leadership & Impact
🌟
Vice President
Street Cause – Delhi
June 2025 – Present · New Delhi
8Divisions Led
2,000+Volunteers
₹1L+Funds Raised
  • Led 8 divisions and coordinated 2,000+ volunteers through weekly leadership meetings.
  • Raised ₹1,00,000+ through fundraising initiatives supporting community welfare programs.
  • Directed food drives, clothing donations, and government classroom renovation projects.
🍽️ Food Drives👕 Clothing Donations🏫 Classroom Renovations🤝 Community Welfare
🎨
Advisory Creative Head
Statistics Department – Ramjas College, Delhi University
Ongoing · New Delhi
360°Creative Ownership
∞Posts & Reels
1Fest Managed
  • Own the entire digital identity — managing all social media channels with consistent branding and content strategy.
  • End-to-end production of department reels — scripting, shooting, editing, and publishing short-form video content.
  • Design all department posts, event creatives, and promotional material maintaining a unified visual identity.
  • Manage all creative operations during the annual department fest — from pre-fest promotions to post-event highlights.
📱 Social Media🎬 Reels & Video🎨 Graphic Design🎪 Fest Management📣 Content Strategy
Let's connect
Get In Touch

Open to roles, collaborations & freelance.

Whether you have a data challenge, a creative project, or a strategy problem — I'd love to hear from you.

✉️
vanshikakr2004@gmail.com
📞
+91 98910 46677
💼
linkedin.com/in/vanshika-kumar
🐙
github.com/vanshika-kumar
📍
Delhi, India