Yashwanth Nallani

Lead Powerbi Etl Developer @Alcanza Clinical Research

Built and deployed end-to-end Power BI reporting solutions by integrating data from Snowflake, SQL Server, Facebook Meta Ads, and HubSpot CRM, delivering highly interactive and scalable enterprise dashboards.•Architected semantic models using star schema and subject-area data marts, optimizing query performance and enabling real-time insights across key operational KPIs like enrollment rates, screening failures, and study status tracking.•Published, certified, and managed clinical dashboards in Power BI Service using structured workspace deployment (Development → UAT → Production) and enforced deployment pipelines for secure production releases.•Established monitoring and governance practices using Power BI Service audit logs, refresh failure alerts, and data sensitivity labeling for critical clinical trial datasets.•Implemented dynamic Row-Level Security (RLS) and Object-Level Security (OLS) in Power BI datasets to restrict access to sensitive patient and study data based on user roles (Care Coordinators, Principal Investigators, Executive Leadership).•Designed and developed scalable ETL pipelines using Azure Databricks (PySpark/Scala) to ingest, cleanse, and transform large-scale healthcare datasets (e.g, patient records, clinical trials, medications, lab results) from multiple sources including SQL Server, APIs, and flat files.•Leveraged Azure Data Lake Gen2 as a central data repository for raw, curated, and transformed data layers, ensuring secure and cost-effective storage of HIPAA-sensitive healthcare data.•Configured ADF triggers and integration runtimes to automate pipeline execution and scale workloads dynamically across batch and near real-time processing modes.•Architected a multi-layered Data Lake house solution on Azure Data Lake Gen2 using Delta Lake for storing raw, bronze, silver, and gold healthcare datasets (EHR, lab data, patient demographics, medications), supporting both batch and streaming workloads.