-6A5ACD?style=for-the-badge){kind=icon}
Final-year Statistics undergraduate at Ramjas College, University of Delhi, passionate about transforming raw data into actionable business insights.
I specialize in:
- Data Analytics
- Business Intelligence
- Data Visualization
- SQL Query Optimization
- Dashboard Development
- KPI Reporting
- Statistical Analysis
My portfolio includes:
✔ AI-Powered Applications
✔ Machine Learning Projects
✔ Power BI Dashboards
✔ SQL Analytics Solutions
✔ Business Intelligence Projects
✔ Data Storytelling Initiatives
I enjoy solving real-world business problems using data and continuously exploring advanced analytics, AI applications, and data engineering concepts.
- Data Analyst Roles
- Business Intelligence Analyst Roles
- Reporting Analyst Roles
- Analytics Internships
- Data-Driven Consulting Projects
| Domain | Proficiency | Details |
|---|---|---|
| Data Analysis | Advanced | Data Cleaning, EDA, KPI Development |
| SQL | Advanced | Joins, CTEs, Window Functions, Aggregations |
| Power BI | Advanced | DAX, Data Modeling, Dashboard Development |
| Business Intelligence | Advanced | Reporting, KPI Monitoring, Insights |
| Python | Intermediate | Pandas, Analytics, Automation |
| Machine Learning | Intermediate | Classification, Predictive Modeling |
| Statistics | Advanced | Hypothesis Testing, Data Interpretation |
| Data Visualization | Advanced | Storytelling, Interactive Dashboards |
🤖 SkillGap AI — AI-Powered Career Intelligence Platform
SkillGap AI is an AI-powered career intelligence platform that transforms job market data into personalized career insights.
- Career Match Score
- Skill Gap Analysis
- Salary Impact Insights
- Personalized Learning Roadmaps
- Career Intelligence Reports
- Hiring Trend Analytics
- Learning Progress Tracking
| Category | Technology |
|---|---|
| Programming | Python |
| Analytics | Power BI |
| AI | Generative AI |
| Visualization | Interactive Dashboards |
- Helps students make data-driven career decisions.
- Identifies skill gaps based on market demand.
- Generates personalized growth roadmaps.
📄 ResumeIQ — AI-Powered ATS Resume Optimization Platform
ResumeIQ analyzes resumes against job descriptions and generates ATS optimization recommendations.
- ATS Score Generation
- Keyword Gap Detection
- AI Bullet Rewriting
- Resume Tracking Dashboard
- Weekly Goal Tracking
- Multi-JD Comparison
| Category | Technology |
|---|---|
| Programming | Python |
| Frontend | JavaScript |
| AI | Generative AI |
| Analytics | Dashboard Reporting |
- Improves ATS compatibility.
- Helps candidates optimize resumes.
- Tracks resume performance over time.
💳 Credit Card Fraud Detection — Machine Learning Project
Developed a machine learning solution to detect fraudulent credit card transactions and reduce financial risk through predictive analytics.
- Fraud Detection Modeling
- Transaction Pattern Analysis
- Feature Engineering
- Classification Algorithms
- Performance Evaluation
- Risk Analytics
| Category | Technology |
|---|---|
| Programming | Python |
| ML Libraries | Scikit-Learn |
| Analysis | Pandas, NumPy |
| Visualization | Matplotlib |
- Improved fraud identification accuracy.
- Analyzed transaction anomalies.
- Demonstrated predictive analytics in financial services.
https://github.com/Vanshika26Ramjas/credit_card_fraud_detection_ml
🧬 STD Healthcare Analytics Dashboard
Built an interactive Power BI dashboard to analyze global trends in HIV/AIDS, Syphilis, HPV, and Hepatitis B.
- Africa recorded the highest prevalence.
- Europe demonstrated stronger disease control.
- Syphilis showed irregular spikes.
- HPV and Hepatitis B displayed declining trends.
| Category | Technology |
|---|---|
| Visualization | Power BI |
| Data Modeling | DAX |
| ETL | Power Query |
| Analysis | Healthcare Analytics |
- Highlighted prevention gaps.
- Enabled geographic trend analysis.
- Demonstrated healthcare storytelling through data.
https://github.com/Vanshika26Ramjas/STD_Healthcare_Dashboard
🏥 Healthcare Analytics Dashboard
Healthcare intelligence dashboard focused on operational metrics, KPI monitoring, and performance reporting.
- Patient Metrics Analysis
- KPI Monitoring
- Interactive Reporting
- Trend Analysis
- Dashboard Storytelling
https://github.com/Vanshika26Ramjas/Healthcare-Analytics-Dashboard
🌍 Global Airbnb Analytics Dashboard
Analyzed Airbnb performance across major cities to identify pricing trends, customer engagement, and marketplace dynamics.
- Paris emerged as a top-performing city.
- Entire-place listings generated premium pricing.
- Seasonal trends influenced booking patterns.
- Host verification improved customer trust.
| Category | Technology |
|---|---|
| BI Tool | Power BI |
| Modeling | DAX |
| Data Prep | Power Query |
🎵 Spotify Analytics Dashboard
Analyzed global music trends, artist performance, and listener behavior using Spotify Top 50 datasets.
- Popularity Analysis
- Artist Performance Tracking
- Explicit vs Non-Explicit Analysis
- Trend Monitoring
- KPI Development
https://github.com/Vanshika26Ramjas/Spotify-Analytics-Dashboard
🛒 Blinkit Sales Analytics Dashboard
Retail analytics dashboard focused on sales performance, customer behavior, and outlet efficiency.
- Sales Analysis
- Product Performance
- Customer Ratings
- Revenue Insights
- Operational Monitoring
🏗 SQL Data Warehouse Project
Designed and implemented a SQL-based data warehouse using dimensional modeling principles.
- Fact & Dimension Tables
- ETL Processes
- Analytical Reporting
- Business Intelligence Layer
https://github.com/Vanshika26Ramjas/sql_data_warehouse_project
- Performed data cleaning and transformation.
- Built dashboards and reports for business insights.
- Conducted data validation and quality checks.
- Supported decision-making through analytics.
Power BI SQL Excel Data Analysis
- Analyzed datasets to uncover business insights.
- Built visual dashboards for stakeholders.
- Created reports and performance summaries.
- Assisted in KPI monitoring.
Power BI SQL Data Visualization
- Supported operational reporting processes.
- Improved workflow efficiency through analysis.
- Assisted with process documentation and tracking.
Operations Reporting Analytics
- Led branding and promotional initiatives.
- Designed event marketing assets.
- Managed digital communication strategies.
- Increased event engagement through creative campaigns.
Leadership Marketing Design
- Managed project quality standards.
- Oversaw financial planning and tracking.
- Coordinated cross-functional teams.
- Supported social impact initiatives.
Leadership Project Management Finance
| Recognition | Details |
|---|---|
| AI Product Builder | Built SkillGap AI & ResumeIQ |
| Analytics Portfolio | Developed multiple end-to-end analytics projects |
| Leadership Experience | Head of Designing & Marketing |
| Business Intelligence | Built 10+ Power BI dashboards |
| Data Storytelling | Created domain-focused analytics solutions |
| Statistics Background | B.Sc. Statistics (Hons), Ramjas College |
- AWS Summit Certification
- Google Cloud Generative AI Certification
- Deloitte Data Analytics Job Simulation
- Deloitte Cyber Security Job Simulation
- Tata Data Visualization Simulation
- HP Data Science & Analytics
- Data Analyst Certification — OneRoadmap
- Advanced Excel Certification
- HubSpot Certification
Coming Soon 🚀
You can replace this section later with:
- LeetCode
- HackerRank
- GeeksforGeeks
- CodeChef
Create this later using GitHub Actions.
After setting it up, add:
<p align="center">
<img src="https://raw.githubusercontent.com/Vanshika26Ramjas/Vanshika26Ramjas/output/github-contribution-grid-snake.svg" alt="snake animation"/>
</p>name: Vanshika Kumar
education:
degree: B.Sc Statistics (Hons)
college: Ramjas College
graduation: 2026
currently_learning:
- Advanced SQL
- Data Engineering Fundamentals
- Machine Learning
- Business Intelligence
- Cloud Analytics
currently_building:
- AI-Powered Analytics Solutions
- Interactive Power BI Dashboards
- Data Storytelling Projects
interested_in:
- Data Analytics
- Business Intelligence
- Machine Learning
- Data Engineering
- Product Analytics
open_to:
- Data Analyst Roles
- Business Intelligence Analyst Roles
- Analytics Internships
- Consulting Opportunities- Master Advanced SQL
- Strengthen Python for Analytics
- Build End-to-End Analytics Projects
- Contribute to Open Source
- Land a Full-Time Data Analyst Role
- Become a Data & Business Intelligence Professional
- Build AI-Powered Analytics Products
- Explore Data Engineering
- Create Scalable Data Solutions
|
AI-powered Career Intelligence Platform |
AI-powered ATS Resume Optimization Tool |
|
Machine Learning Classification Project 🔗 https://github.com/Vanshika26Ramjas/credit_card_fraud_detection_ml |
Power BI Business Intelligence Dashboard 🔗 https://github.com/Vanshika26Ramjas/Global-Airbnb-Analytics |
|
Music Industry Analytics & Insights 🔗 https://github.com/Vanshika26Ramjas/Spotify-Analytics-Dashboard |
Dimensional Modeling & ETL Project 🔗 https://github.com/Vanshika26Ramjas/sql_data_warehouse_project |
📊 Data Analytics
📈 Business Intelligence
🤖 AI Applications
💡 Data-Driven Problem Solving
🚀 Career Opportunities
while True:
learn()
analyze()
build()
improve()