• Over 16+ years of Professional experience. Microsoft Power-BI certified data analyst specializing in Business Intelligence tools SQL Server, Snowflake, Power Bi, Tableau, Excel & MS Access. • Excellent knowledge on Power Query Parameters, Query Lists, Tables, Records and having expertise in Cleansing and Transforming data with Power Query Editor. • Experience in adjusting cross filter direction for a complex set of tables and relationships. • Hands-on experience in utilizing DAX functions and measures and implemented several DAX functions, which includes Aggregation, Counting, Logical and date functions for efficient data visualization.• Used Power BI, power pivot to develop data analysis and power map to visualize reports.• Developed dashboard visualizations and complex reports, which involves custom controls and custom expressions using bars, lines and pies, maps, scatter plots.• Made Power BI dashboards available in web clients and scheduled automatic refresh in Power BI Service.• Worked on Power BI Performance Tuning using Performance analyzer, information of each visual or DAX formula in real time and worked on Row level security.• Developed event-driven analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions• Used DAX Functions for filtering and creating calculated columns and measures in the Data View.• Complex business logic into Database design, Migration and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views & Data Modeling. • Proficient in gathering business requirements from business stakeholder’s, excellent interpersonal skill and Team management skill with strong expertise in preparing the specifications.• Expert in MS office – Advanced Excel (X&V Lookup, Indirect, Sum if), MS access and Power Query.
