Harsh Singoriya

Data Analyst

Bhopal, IN.

About

Detail-oriented Data Analyst with 8 months of hands-on experience transforming complex datasets into actionable insights to drive strategic decision-making. Proven expertise in SQL, Power BI, Python (Pandas, Matplotlib), and Excel, consistently improving reporting efficiency by over 30% and enhancing business insights through impactful dashboards. Committed to leveraging data storytelling and advanced analytical skills to support data-driven strategies and optimize operational performance.

Work

Ramani Ice Cream Company Ltd

|

Data Analyst Intern

Bhopal, Madhya Pradesh, India

→

Summary

Led data analysis initiatives, automating reporting and optimizing stock allocation, resulting in significant efficiency gains and improved operational visibility.

Highlights

Automated daily reporting using Excel formulas and Power BI, reducing manual effort by 35% and streamlining data processes.

Identified critical sales trends across regions, improving stock allocation efficiency by 20% through data-driven insights.

Designed and implemented interactive dashboards for SLA-driven KPIs, increasing tracking visibility by 40% for key performance indicators.

Maintained comprehensive shift logs and collaborated cross-functionally to ensure 100% shift adherence and operational compliance.

Enhanced team analytical capabilities by documenting and visualizing structured data, fostering a data-driven culture.

Tata Data Visualization Simulation (Forage)

|

Virtual Internship Trainee

Remote, Remote, India

→

Summary

Developed executive dashboards and analyzed financial KPIs, providing data-driven recommendations and contributing to cost-saving initiatives.

Highlights

Developed executive dashboards in Power BI, significantly improving leadership visibility on key operational and financial metrics.

Analyzed performance and financial KPIs, generating data-driven insights that contributed to actionable cost-saving recommendations.

Provided comprehensive data-driven recommendations, documenting potential risks and compliance concerns to support strategic planning.

Collaborated effectively with remote teams, adhering to simulated project deadlines and industry standards for high-quality deliverables.

Gained 25% proficiency in transforming raw business data into decision-support assets, enhancing analytical capabilities.

Education

LNCT University

Bhopal, Madhya Pradesh, India
→
Bachelor of Technology Technology Grade: 8.1/10 CGPA

Certificates

Google Data Analytics Professional Certificate (In Progress)

Google

MS Excel Certification

J.P. Morgan

SQL and Relational Data Base (101)

IBM

Skills

Data Analysis & Visualization

Power BI, MS Excel, Pivot Tables, VLOOKUP, Charts, Slicers, Dashboard Design, KPI Analysis, Business Intelligence.

Programming

Python, Pandas, NumPy, Matplotlib, Seaborn.

Databases

PostgreSQL, Joins, Aggregations, CTEs, Subqueries.

Data Management

Data Cleaning, Data Modeling.

Projects

Sales Order Analysis Project (End-to-End Pipeline)

→

Summary

Designed and implemented an end-to-end data pipeline for sales order analysis, from data acquisition to dashboard delivery.

Ola Ride Analytics (SQL + Power BI)

→

Summary

Performed comprehensive analytics on Ola ride data using SQL and Power BI to optimize driver allocation and visualize city-wise performance.