Kumaraguru M M

Power BI Developer

Mphasis

Jun 2020 - Present

Designed, developed, and maintained interactive Power BI dashboards and reports to track KPIs and business performance. Integrated data from multiple sources including SQL Server, Oracle, Excel, cloud databases, and APIs to create accurate and unified reports. Developed and optimized SQL queries, views, and stored procedures using DDL, DML, and DQL for efficient data retrieval. Used Power Query (M) and DAX to perform data transformations and create complex calculations and business metrics. Built scalable ETL processes to prepare and standardize data for analytics and reporting. Created and managed data models, establishing strong relationships and joins for smooth data flow across reports. Implemented Row-Level Security (RLS) to control user access and ensure secure data visibility. Published and managed reports in Power BI Service, including deployment and scheduled data refreshes. Built user-friendly report designs using custom themes, interactive slicers, and dynamic tooltips. Improved report and model performance by optimizing queries, visuals, and data structures. Configured and maintained the On-Premises Data Gateway to enable secure data connectivity. Provided support for report issues, documentation, and continuous improvements. Worked in an Agile environment, participating in stand-ups, sprint planning, and review meetings. Collaborated with business stakeholders to gather reporting requirements and translate them into technical solutions. Created and maintained technical documentation, including data dictionaries and report user guides. Monitored data quality and implemented validation checks to ensure accuracy and consistency across reports.