Prajwal H P

Prajwal H P

Data Analyst
India
Kannada, Hindi, English

نبذة عني

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…

الخبرة

Trainee Decision Scientist

Mu Sigma Business Solutions
Jul 2023 - Apr 2024 · 8 أشهر

● 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 أشهر

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.

المهارات

بايثون (لغة برمجة) لغة الاستعلامات الهيكلية (SQL) الإحصاء تابلو 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
الإبلاغ عن هذا الملف الشخصي؟