Ramesh Perumalla

Contributed to the development and architecture of Azure Data Factory pipelines, focusing on data transfer from Oracle databases to Azure Data Lake Store Raw Zone, with integration into Snowflake for data warehousing.
• Played a supportive role in crafting and executing specialized ETL pipelines at Blue Cross Blue Shield, specifically targeting Snowflake to streamline clinical data management.
• Aided in leveraging Snowflake for scalable data warehousing, specializing in storage and retrieval of extensive clinical data to meet diverse analytics and reporting requirements.
• Assisted in implementing Snowflake's security features, including row-level security and data masking, to uphold data governance and compliance standards.
• Supported data modeling and architecture discussions, contributing Snowflake-specific insights to ensure optimal performance and scalability of clinical data storage.
• Participated in the development of Azure Databricks for data transformations, aiding in the migration of data from on-premises SQL servers to Azure cloud databases.
• Involved in designing a variety of ETL pipelines using Azure Databricks, extracting, and loading data from multiple sources into Azure Data Lake and Synapse Analytics.
• Collaborated in creating and maintaining dynamic reports and dashboards in Power BI, built on top of Azure Synapse, Azure Data Warehouse, and Azure SQL.
• Engaged in the development and maintenance of data pipelines to support business intelligence, integrating with Azure DevOps, and utilizing Azure Data Factory for pipeline execution.
• Actively collaborated with cross-functional teams to understand data requirements, providing technical support and insights for data storage and management solutions in Azure environments.
• Integrated Power BI for enhanced data visualization, contributing to the design and implementation of data governance and security policies within Azure, ensuring data encryption and access controls were in place.