5+ years of IT experience in the Analysis, Design, Development, Administering, Implementing using Microsoft Power BI suite (Development, UAT, and Production Environment).

● Extensive experience with different phases of project life cycle (Analysis, Design, Implementation.

● Experience in writing complex SQL queries involving multiple tables with inner and outer joins, stored procedures, Experience in creating indexed views.

● Hands-on Experience in DAX Expressions, Power BI Power Pivot, Power integrated with Share Point, and in creating dashboards in Power BI.

● Experience in Dimensional Modeling, Designing of STAR, SNOWFLAKE Schemas.

● Creating powerful calculations, key metrics, and key performance indicators (KPIs).

● Expertise in adding Calculated Fields with Data Analysis Expressions (DAX)

● Worked on Calculated Columns vs. Measures, Row Context vs. Filter Context, DAX Syntax and Operators, Date and Time Formulas, Text, Math and Stats Functions

● Worked on DAX Iterators and Time Intelligence Formulas

● Worked on Designing Interactive Power BI Reports

● Worked on Formatting and Filtering Options, adding Matrix Visuals, Slicers & Timelines, Cards & KPIs

● Worked on Power BI Map Visuals, Treemaps, Lines, Areas & Gauges

● Worked on Edit interactions, Adding Drill through Filters, Linking to Report Bookmarks, using “What-If” Parameters, Managing and Viewing Roles

● Published / Shared the reports by creating Content Pack / Sharing the .pbix file

● Worked on On-Premises Gateway to refresh the data sources / creating a live connection with SQL SERVER, Gateway migration

● Having very good experience on building dashboards, reports