Pranav Murali

Hi, I'm Pranav Murali

A Data & BI Analyst specializing in SQL, Power BI, and Python. I deliver scalable, data-driven reporting and business insights.

Learn More About Me

About Me

Iโ€™m a passionate Data and Business Intelligence Analyst with over four years of experience supporting healthcare, financial, and SaaS organizations across India and the United States. I specialize in translating business requirements into SQL-driven analytics, automated reporting systems, and executive dashboards that support data-driven decision-making. With hands-on experience working with large-scale datasets exceeding 50 million records, I have built reliable and auditable reporting solutions using tools such as SQL, Python, Power BI, and cloud-based analytics platforms.

I am especially focused on transforming complex data into clear and actionable insights through KPI standardization, utilization analysis, and performance monitoring. I work closely with business stakeholders, product owners, and data engineering teams to validate data pipelines and ensure reporting accuracy. Known for structured problem solving, strong documentation practices, and attention to data governance, I am always eager to learn, grow, and contribute to projects that create meaningful business impact.

Education

Master of Science (M.S.)

Illinois Institute of Technology | Aug 2023 โ€“ May 2025

Major: Computer Science

Coursework: Advanced Databases Organization, Mobile Development Application, Science of Programming, Introduction to Information Security, Cloud Computing, Computer Networks, Big Data Technologies, Software Management, Parallel and Distributed Systems, Data Preparation and Analysis.

Bachelor of Technology (B.Tech)

Jain University, Bangalore | Aug 2018 โ€“ Jul 2022

Major: Information Science

Coursework: Software Engineering, Problem-Solving through Programming, Data Structures with C, Object-oriented programming using Java, Python Programming, Automata Theory and Logic, Design and Analysis of Algorithms, Object-oriented Design, and software testing.

Work Experience

Data & BI Analyst

UnitedHealth Group, USA

Jun 2025 โ€“ Present

๐Ÿ“Š 30M+ Records โฑ๏ธ 10 Hrs/Week Saved โœ… 95% Accuracy ๐Ÿ“ˆ 18% Fewer Requests
  • ๐Ÿ—„๏ธ Built SQL datasets for large healthcare reporting systems.
  • ๐Ÿ“Š Created Power BI dashboards for business users.
  • ๐Ÿ Analyzed trends using SQL and Python.
  • ๐Ÿ” Implemented automated data validation checks.
  • ๐Ÿ“ Documented metrics and data workflows.
  • ๐Ÿ“ข Delivered insights for leadership decisions.

BI Analyst

Brownframe Technologies, India

Feb 2022 โ€“ Jul 2023

๐Ÿ“Š 20M+ Rows โšก 60% Faster Reports โฑ๏ธ 8 Hrs/Week Saved ๐Ÿ‘ฅ 40+ Users
  • ๐Ÿ—„๏ธ Designed SQL views for finance and operations data.
  • ๐Ÿ“Š Built optimized Power BI dashboards.
  • โš™๏ธ Tuned queries for faster refresh times.
  • ๐Ÿ Automated data preparation using Python.
  • ๐Ÿ” Investigated KPI issues and root causes.
  • ๐Ÿ”„ Managed analytics assets using Git.

Data Analyst

Sage Softech, India

Jan 2020 โ€“ Jan 2022

๐Ÿ“Š 10M+ Records ๐Ÿ“‰ 30% Less Manual Work ๐Ÿ“… On-Time Reports โœ”๏ธ High Data Quality
  • ๐Ÿ“‹ Collected reporting requirements from teams.
  • ๐Ÿ—„๏ธ Wrote SQL queries for business reports.
  • ๐Ÿ“Š Created Excel and Power BI reports.
  • ๐Ÿ” Validated datasets for accuracy.
  • ๐Ÿ Prepared clean data using Python.
  • ๐Ÿ“ Documented reporting logic.

Technical Skills

Data Analysis & Business Analytics

๐Ÿ“Š Requirements Gathering ๐Ÿ“Œ KPI Definition ๐Ÿ“ˆ Trend Analysis ๐Ÿ“‰ Variance Analysis ๐Ÿ” Root Cause Analysis ๐Ÿ“‹ Metric Standardization

SQL & Data Querying

๐Ÿ—„๏ธ SQL ๐Ÿ”— Complex Joins ๐ŸชŸ Window Functions ๐Ÿ“„ CTEs โš™๏ธ Query Optimization ๐Ÿ“Š Data Reconciliation

Python & Data Processing

๐Ÿ Python ๐Ÿผ Pandas ๐Ÿ”ข NumPy ๐Ÿงน Data Cleaning ๐Ÿ”„ Data Transformation ๐Ÿ“ Batch Processing

BI, Cloud & Collaboration

๐Ÿ“Š Power BI ๐Ÿงฎ DAX ๐Ÿ” Power Query โ˜๏ธ AWS (S3, EC2) ๐ŸŒฟ Git ๐Ÿ“ Documentation

Projects

Healthcare Dashboard

Healthcare Claims Utilization Dashboard

Built Power BI dashboards analyzing 25M+ healthcare claims records, enabling weekly utilization monitoring and reducing manual reporting by 10 hours per week through automated refresh and validated measures.

๐Ÿ“Š Power BI ๐Ÿ—„๏ธ SQL ๐Ÿงฎ DAX ๐Ÿ“ˆ KPI Analysis ๐Ÿ” Data Validation ๐Ÿฅ Healthcare Analytics
Financial Automation

Financial Performance Reporting Automation

Developed Python data workflows processing 6M+ records per cycle, replacing spreadsheets and improving month-end close accuracy and reporting consistency.

๐Ÿ Python ๐Ÿผ Pandas ๐Ÿ—„๏ธ SQL ๐Ÿ”„ Automation ๐Ÿ“Š Financial Reporting ๐Ÿ“ ETL Processing
Data Quality Framework

Data Quality Validation Framework

Implemented SQL-based reconciliation and validation checks across batch pipelines, identifying data issues early and reducing reporting defects in leadership reviews.

๐Ÿ—„๏ธ SQL ๐Ÿ” Data Reconciliation โœ”๏ธ Quality Checks ๐Ÿ“ Batch Processing ๐Ÿ“ Documentation โš™๏ธ ETL Validation

Get In Touch

My Resume

Interested in my qualifications? Feel free to download a copy of my professional rรฉsumรฉ to see the full details of my experience and skills.

Download Resume