Shruti Patil

Client : Parexel International

Business Intelligence Reporting and View Creation.

• Engineered optimized SQL views by leveraging existing fact and dimension tables, enabling high-performance and insight-driven Power BI dashboards.
• Designed, automated, and managed end-to-end ETL workflows in Databricks, ensuring seamless data preparation and on-schedule data delivery.
• Collaborated proactively with Power BI developers to validate data integrity, enhance report performance, and drive continual dashboard improvements.
• Created comprehensive documentation covering SQL logic, data dependencies, and Databricks workflows to support scalability, maintainability, and future development.

Data Migration and Reporting Enhancement.

• Architected and deployed a robust Medallion Architecture (Bronze–Silver–Gold) to streamline data workflows, enabling optimized storage, enhanced data organization, and faster access for large-scale clinical and financial datasets.
• Leveraged Azure Cloud services, including Azure Data Factory, to design, orchestrate, and manage highly reliable data pipelines, ensuring seamless data integration across diverse environments and supporting near real-time data availability.
• Led the end-to-end migration of complex ETL processes from Informatica to Databricks, ensuring a smooth transition while preserving data integrity, improving scalability, and significantly enhancing transformation performance.
• Built secure, automated data pipelines to ingest client audit data from Excel files hosted on HTTPS servers, transforming and loading it efficiently into Azure SQL Database with full auditability and reliability.
• Implemented advanced Slowly Changing Dimensions (SCD) Type logic to manage evolving historical data, ensuring accurate, consistent, and timely insights for downstream Power BI reporting.
• Applied DevOps best practices to enable CI/CD, overseeing issue tracking, automated deployments, and release management across development, UAT, and production environments to ensure high availability and operational excellence.