Sirisha Madhagani Email & Phone Number

In my current role as an Information Analyst at Greater Manchester Mental Health NHS Foundation Trust, I have successfully designed and maintained comprehensive Power BI dashboards, resulting in a 20% improvement in data-driven decision-making.SQL Server Expertise: Proficient in developing, managing, and optimizing SQL Server databases, including creating tables, views, indexes, and stored procedures.Advanced T-SQL Skills: Skilled in writing complex T-SQL commands, sub-queries, dynamic queries, joins, and handling database transactions effectively.Data Integrity and Normalization: Strong understanding of database normalization, relational integrity constraints, and implementing SQL Server constraints (Primary Keys, Foreign Keys, etc.).ETL Development with SSIS: Extensive experience in designing SSIS packages for ETL processes, employing tools like Slowly Changing Dimensions (SCD), Change Data Capture (CDC), and Data Conversion.Power BI Dashboard Design: Expert in designing and maintaining Power BI dashboards, utilizing Power Pivot, Power View, and Power Map for comprehensive data analysis and visualization.DAX Proficiency: Proficient in creating and optimizing DAX queries for computed columns and tables, and implementing DAX Quick Measures for data categorization.Data Integration: Experience in importing data from various sources, such as SQL Server and Azure SQL DB, into Power BI to generate insightful reports.Automated Data Refresh: Skilled in configuring Power BI Gateways for automated and manual data refresh, ensuring up-to-date dashboards and reports.Database Performance Optimization: Expertise in developing and optimizing stored procedures, performing table partitioning, and using appropriate indexes for enhanced database performance.

• 

  Kingston University

  International Business Management