Srijan Shankar

Entry-level Data Analyst proficient in SQL, Python, Excel, and Power BI. Demonstrated ability in data cleaning, exploratory data analysis, and dashboard creation. Analyzed large datasets to produce actionable insights that enhance data-driven decision-making. Strong analytical and problem-solving skills with a commitment to data analytics.

Music Store Data Analysis| Python, SQL.                                                               (NOV 2025 - DEC 2025)

• Extracted and transformed over 1M+ records from a complex music store database using advanced SQL techniques, achieving 99.9% data accuracy.
• Analyzed 100,000+ customer transactions using Python (Pandas, NumPy) to identify trends in customer behavior and sales performance.
• Created 50+ data visualizations with Matplotlib and Seaborn to communicate insights clearly and support decision-making.
• Prepared 10+ analytical reports summarizing findings and recommendations, contributing to a 20% improvement in marketing efficiency.
• Optimized inventory insights through data analysis, supporting a 15% improvement in inventory management.

Coffee chain company Dashboard| Excel, Power BI                                                     (DEC 2025- JAN 2026) 

• Cleaned and merged 500,000+ records from multiple data sources using Excel to ensure data accuracy and consistency.
• Designed an interactive Power BI dashboard to visualize key KPIs including sales trends, revenue, and location-wise performance.
• Analyzed sales patterns and operational metrics to identify performance gaps and improvement opportunities.
• Generated actionable insights that contributed to a 10% increase in sales and a 15% improvement in operational efficiency.
• Strengthened skills in data cleaning, dashboard development, and translating business requirements into visual insights.

• Sports Secretary, AAGAAZ, Official Inter Hostel Tournament, 02/01/24, 03/31/24, Managed the hostel student selection process for over 200 students, maintained the database, and collaborated with 10+ students and Hostel office officials. Increased participation in sports events by a significant 40% compared to previous years.
• Teacher, Volunteer, National Service Scheme DTU, Implemented interactive teaching methods that improved the foundational understanding of mathematics and social science resulting in an average increase in their overall test scores. Collaborated with other volunteers to create and implement custom lesson plans tailored to individual student needs, leading to a noticeable improvement in academic performance and confidence levels within the classroom.