Prajwal H P

Prajwal H P

Data Analyst
India
Kannada, Hindi, English

About Me

Detail-oriented Data Analyst with hands-on experience in cleaning, transforming, and analyzing large datasets using SQL, Power BI, Excel, and Tableau. Skilled in creating dynamic dashboards, writing optimized SQL queries…

Experience

Trainee Decision Scientist

Mu Sigma Business Solutions
Jul 2023 - Apr 2024 · 8 months

● Analyzed over 500,000 clinical trial records using SQL and Excel, focusing on drug effectiveness and patient outcomes for a major American pharmaceutical client.
● Cleaned, validated, and transformed raw datasets in Excel, increasing data quality and consistency by 35%, which reduced reporting errors.
● Built interactive dashboards in Power BI to track key KPIs such as response rate, trial completion rate, and dosage efficacy across multiple demographics.
● Identified anomalies and outliers in clinical data enabling better trial monitoring and protocol adjustments.
● Delivered insightful data visualizations that helped stakeholders evaluate treatment performance across age groups, leading to an improved focus on target demographics.
● Supported strategic decisions by identifying the top-performing compounds, leading to a 15% improvement in trial success rate.
● Contributed to internal knowledge sharing by presenting project findings during weekly review meetings.

Trainee Decision Scientist

Mu Sigma Business Solutions – Bengaluru, India
Jul 2023 - Apr 2024 · 9 months

Analyzed over 500,000 clinical trial records using SQL and Excel, focusing on drug effectiveness and patient outcomes for a major American pharmaceutical client.
Cleaned, validated, and transformed raw datasets in Excel, increasing data quality and consistency by 35%, which reduced reporting errors.
Built interactive dashboards in Power BI to track key KPIs such as response rate, trial completion rate, and dosage efficacy across multiple demographics.
Identified anomalies and outliers in clinical data enabling better trial monitoring and protocol adjustments.
Delivered insightful data visualizations that helped stakeholders evaluate treatment performance across age groups, leading to an improved focus on target demographics.
Supported strategic decisions by identifying the top-performing compounds, leading to a 15% improvement in trial success rate.
Contributed to internal knowledge sharing by presenting project findings during weekly review meetings.

Skills

Python Structured Query Language (SQL) Statistics Tableau Data Extraction Joins Sub-Query CTE Index Stored Procedures Excel VLOOKUP Conditional Formatting Pivot Table Power Query Power Pivot VBA Macros Power BI Data Modeling Dashboards Parameter Pandas NumPy Matplotlib
Report this Profile?