Sangeetha Gunasekaran

• Developed Power BI dashboards with data from SQL Server, Flat files, and Azure sources.
• Built DAX measures for KPIs, year-to-date calculations, dynamic slicers, and advanced analytics.
• Created and scheduled data refreshes, set up role-based security, and embedded reports into web applications.
• Automated PDF export as email using Power Automate and integrated in SharePoint storage.
• Used ERDs and physical models to guide database object development using T-SQL & SQL Server.
• Delivered performance-optimized visualizations using DAX Studio, Performance Analyzer, and profiling tools.
• Worked with end users to define reporting needs and provide analytical support for business decisions.

• Involved in understanding the reporting requirements and providing reports.
• Develop, maintain and document highly visualized comprehensive dashboards using POWER BI Desktop and publish it to POWER BI Service to meet business specific challenges.
• Worked on Data manipulation by using POWER BI QUERY EDITOR.
• Build Different visualizations such as Dounut chart, Bar chart, Waterfall Chart, Area Chart and Shape maps.
• Created and modified some of the existing reports and dashboards.
• Created conditional filters and Action links to filter the data on dashboard.

Deploying the generated reports on the production server through Gateways.

• Setting up role-based security to access role-specific data in dashboards.
• Establishing a scheduled refresh and sharing Power BI reports.
• Embedding Power BI reports into webpages
• Setting up user accounts in Power BI Service.
• Using Power Apps, I created some cloud instant flows and integrated them into Power BI.
• Implemented Incremental refresh in Power BI desktop & created What if analysis parameters for creating dynamic slicers & charts.

• Create SSIS packages to automate Jobs / Data Management activities as per business demands
• Create SSRS 2008 Reports as per Business demands.
• End to end solution and responsible for Migrating 70+ SSIS 2008 Version Packages into SSIS 2014 and deployed them into SSIS 2014 Catalog DB to Go Live.
• Create Power Pivot Reports as per Business demands
• Prepare Design and Analysis Documentation For each Developed Job and analyzed recommended performance remediation either in Project/Process/Query level
• Created Excel Reports using Power Pivot Add-In Reports for Business Analysis as demand
• Creating database objects e.g. UDF, Dynamic Stored Procedures, Views, writing T-SQL queries, performance tuning etc
• Created Power BI Desktop Reports as business demand
• Power BI - Data sets refresh scheduling have been set up as demand

§ Published and shared developed reports to the organizational content pack through the Power BI service