Shivam Kumar

Aspiring Data Analyst pursuing a B.Tech in Computer Science Engineering. Hands-on experience in transforming raw data into actionable insights using Python, SQL, Excel, and data visualization tools. Proven ability to build interactive dashboards, track key performance indicators (KPIs), and optimize business reporting to support data-driven operational decision-making.

Data Analyst

Developed an interactive sales dashboard to monitor enterprise revenue, customer purchasing behavior, sales trends, and product performance.

• Wrote optimized SQL queries to extract and compute critical KPI metrics, including total revenue, peak sales hours, and top-selling inventory items.
• Engineered dynamic reporting layouts using Pivot Tables, interactive slicers, and charts to establish cross-functional performance tracking.
• Delivered data-driven operational insights to help management optimize staff shifts and product inventory alignment during peak demand hours.

Data Analyst

Built a robust healthcare analytics dashboard to monitor operational metrics, including patient wait times, satisfaction scores, admission statuses, and department referrals.

• Utilized Power Query to automate data cleaning, merging, and transformation workflows, substantially reducing data processing and validation errors.
• Designed a modular visual interface featuring Pivot Charts, interactive filters, KPI cards, and custom conditional formatting for real-time overview analysis.
• Generated critical operational insights to support medical management in optimizing staff allocation and improving patient-flow efficiency.

Bachelor of Technology (B.Tech) - Computer Science Engineering - A.P.J. Abdul Kalam Technical University (2022 - 2026)