Sai Madhulika

• Responsible for Business Operations Reporting for the collection and analysis of operational metrics and key performance indicators (KPI’s) to all of Technical Infrastructure management. • Extracting business data from different OLTP systems and loads into a data warehouse using SQL server Integration Services (SSIS). • Worked on providing row level securities using Power BI to restrict data access for various users. • Expertise in publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server. • Developed customized calculated Columns and measures using DAX Formula language in Power BI to satisfy business needs. • Utilized Power Query in Power BI to pivot and unpivot the data model for data cleansing and data transformation. • Utilized Power BI gateway to keep dashboards and reports up-to-date with on premise data sources. • Utilizes SQL- DML, DDL, and DCL classes to setup, create, maintain, and manage SQL databases backend functions daily. • Successfully migrated comprehensive data reporting from Spotfire to Power BI, enhancing data visualization and reporting capabilities. • Provided continuous support after the migration to address any issues and incorporate user feedback. • Identified and resolved challenges during the migration process, including data compatibility issues and report formatting discrepancies • Expertise in creating reports, dashboard and conducting Data Visualization using TIBCO Spotfire 10.10.1 LTS • Developed complex dashboards with multiple Data Sources using TIBCO Spotfire Professional • Expert in all aspects of tables, charts, graphs, calculated columns, data transformation, pivoting and unpivoting, creating hierarchies, bookmarks, and constructing complex reports • Experienced in sharing insights and collaborating with stakeholders by publishing Spotfire dashboards to the Spotfire Server or Spotfire Cloud, configuring access permissions, and scheduling data refreshes