Mukunda Rachamalla

Power Bi Devoloper @CalOptima

US

Designed and deployed 25+ Power BI dashboards tracking clinical trial metrics including patient enrollment, adverse events, and site performance. Implemented natural language Q&A, AI-powered anomaly detection, and drill-through to source data that reduced ad-hoc requests by 60%.• Developed complex DAX measures for time intelligence calculations, rolling averages, and cohort analysis. Created reusable measure templates that standardized calculations across 50+ reports and reduced development time by 40%.• Optimized 120+ Snowflake stored procedures through query plan analysis and performance tuning. Implemented clustering keys and materialized views that improved ETL pipeline speed by 65%, reducing cloud costs by $12K/month.• Built Python scripts automating FDA submission reports that previously required 150 manual hours/month. Implemented data validation checks and audit trails ensuring compliance with 21 CFR Part 11 regulations.• Conducted A/B testing of patient engagement strategies using statistical analysis in Python. Identified approaches that improved retention rates by 15% while maintaining 95% confidence intervals.• Migrated 10TB of clinical trial data from legacy systems to Snowflake. Designed optimized star-schema models and incremental load patterns that reduced storage costs by 35% while improving query performance.• Implemented row-level security in Power BI based on Active Directory groups and clinical trial protocols. Ensured HIPAA compliance across all dashboards with zero PHI breaches during audits.