logo

Powered by
Codebasics DA Bootcamp

Hello, I am

Shivtej Muthyala.

5

PowerBI Projects

1

SQL Project

About Me

I'm Shivtej Muthyala, a Data Analyst with hands-on experience in Power BI, SQL, Excel, and data storytelling. With a background in Information Technology Engineering, I specialize in transforming raw data into actionable insights through interactive dashboards and reports. I bring a strong understanding of the end-to-end BI lifecycle, from data ingestion and modeling to visualization and business decision support.

💼 What I Do
👉Create insightful dashboards using Power BI.
👉Perform data cleaning, modeling, and visualization.
👉Analyze KPIs to support executive decisions.
👉Automate and optimize reporting workflows.
👉Communicate complex insights with clarity.

Key Skills

Microsoft Power BI

Python

SQL

Advance Excel

My Experience

MIS Analyst | Dheeraj Engineering India | Reporting & Supply Chain Management | 11/2024 – Present

Evaluated component test data (5–7 components monthly) using SQL, uncovering recurring issues and implementing corrective actions that reduced failure rates from 5% to 4.5% over nine months.
• Created and maintained Power BI dashboards to monitor testing KPIs and supply chain metrics, cutting report preparation time by 10% and improving stakeholder visibility.
• Developed ETL workflows with n8n and Power Automate, reducing manual intervention and improving reporting turnaround speed.
• Consolidated and translated raw performance data into actionable insights, enabling design adjustments that enhanced product durability by 5%.
• Refined data collection and entry processes by developing structured templates and training 2 team members, achieving 3% higher data accuracy and a 4% faster test cycle.

Data Analyst Intern | Shield Insurance (AtliQ Technologies) | 05/2025 – 06/2025

• Designed and deployed BI dashboards in Power BI to track claims processing, policy renewals, and financial KPIs, reducing manual reporting by 70%.
• Audited 100+ claim records weekly with SQL, identifying coding errors and reducing rejection rates from 10% to 8%.
• Standardized and validated medical coding data (ICD-10, CPT, HCPCS) for 150+ records weekly, ensuring 98% accuracy and compliance with billing regulations.
• Optimized data workflows, cutting average processing time per record by 20% and boosting reporting efficiency.
• Partnered with healthcare providers and cross-functional teams to clarify incomplete data, reducing coding-related queries by 30%.
• Generated insights that strengthened fraud detection, boosted compliance monitoring, and lifted customer retention by 15%.

Associate Content Analyst | V2 Solutions Pvt. Ltd. | 04/2024 – 11/2024

• Monitored and processed large-scale digital content datasets to ensure accuracy, consistency, and compliance with client requirements.
• Developed Excel-based reporting templates that streamlined performance tracking and reduced report turnaround by 15%.
• Collaborated with senior analysts to conduct quality checks and enhance reporting workflows, improving overall data integrity.

Awards & Certificate

img

Excel: Mother of Business Intelligence

img

Get Job Ready: Power BI Data Analytics for All Levels 3.0

img

SQL Beginner to Advanced For Data Professionals

img

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.