jaffer shaik

Power BI Developer

Tata Consultancy Services

May 2023 - Present

Built interactive dashboards and reports using Power BI Desktop and Service with strong storytelling approach. Designed structured datasets using star schema, relationships, and fact-dimension architecture. Developed advanced DAX calculations including time intelligence and dynamic KPIs. Executed ETL workflows through Power Query for data cleaning, transformation, and reshaping. Connected multiple sources such as databases, spreadsheets, APIs, and cloud platforms. Engineered efficient queries in relational systems for extracting and transforming datasets. Applied role-based access control through Row-Level Security for secure data visibility. Deployed solutions on cloud platform with workspace management and automated Schedule Refreshing. Enhanced performance by optimizing models, reducing redundancy, and improving calculation efficiency. Implemented advanced features like drill-through, bookmarks, tooltips, and dynamic visuals. Wrote complex SQL queries using JOINs, subqueries, and CTEs for data extraction and analysis. Performed data aggregation using GROUP BY, HAVING, and window functions (ROW_NUMBER, RANK, DENSE_RANK). Optimized query performance through indexing, query tuning, and execution plan analysis. Created and managed views, and temporary tables. Worked with relational databases like SQL Server / MySQL for data integration with Power BI. Utilized advanced formulas like VLOOKUP, XLOOKUP, INDEX-MATCH, IF, and COUNTIFS. Built Pivot Tables and Pivot Charts for data summarization and reporting. Performed data cleaning using text functions, conditional formatting, and data validation. Automated tasks using basic macros and Excel shortcuts.