Ramya Padamata
Sql Power Bi Developer @RBC
Signup · Get unlimited contacts
WORK HISTORY
Sql Power Bi Developer @RBC
Toronto, ON, CA
Creating and managing Power BI datasets with data transformation and data enrichment.• Designing and implementing Azure Synapse firewalls to restrict data access based on IP addresses.• Creating and managing Data Factory parameterized pipelines to facilitate reusability and maintainability of data integration processes, harmonizing a symphony of efficient workflows.• Utilizing Azure Key Vault\'s import and export policies for secure data transfer and sharing with external partners• Configuring and customizing report parameters in Power BI and SSRS to allow for dynamic report filtering and data selection.• Developing and maintaining SSAS data source views for logical data modeling, creating logical views of data for easier understanding and usage within the analytical models.• Designing and implementing data refresh schedules in Power BI to keep reports up to date with the latest data.• Troubleshooting and resolving issues related to Power BI and MSBI solutions to ensure smooth functioning.• Created and managed SQL server database maintenance plans for regular data integrity checks and index maintenance• Developing and maintaining metadata repositories to provide a comprehensive view of the data used in Power BI and MSBI solutions.
EDUCATION
Acharya Nagarjuna University
Bachelor's degree
ABOUT RAMYA PADAMATA
4+ years of IT experience in Microsoft Business Intelligence technologies like Power Bi, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS), RDBMS like MS SQL server, MySQL, and Azure SQL DB. • Experienced in Azure with a background in BI development. Skilled in architecting and implementing Azure solutions, optimizing data processing, and transforming businesses through analytics. • Implementing and meticulously managing data transformation and aggregation activities to refine data within Azure Data Factory, conducting a symphony of refined data processing. • Utilizing Azure Key Vault\'s event grid integration to monitor real-time changes to keys and secrets, facilitating proactive response to key updates and data security events. • Implemented BI data encryption and masking to protect sensitive information. • Ensuring the security and integrity of databases by implementing appropriate access controls, backup and recovery strategies, and data validation routines. • Utilizing Power BI\'s integration with Microsoft Excel for importing data from Excel workbooks. • Collaborate with stakeholders to understand SSIS data integration requirements and ensure alignment. • Implementing and managing automated database schema migrations and updates in Azure DevOps. • Configuring and meticulously managing access controls and permissions in Azure Data Lake, ensuring data security and compliance • Developed and maintained BI data search and discovery capabilities for enhanced data exploration. • Working with DBAs to optimize hardware resources and database configurations for SSAS performance. • Collaborating on server settings, memory allocations, and disk configurations to ensure optimal cube processing.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.