• Having 6+ years of Professional experience in the IT industry, working on Power BI Desktop, Power BI Service, and MSBI (SQL server, SSIS, SSRS).

• Good Working Knowledge on ETL Process using SQL Server Integration Services (SSIS). Collating and understanding business requirements.

• Good Working Knowledge on SQL Server 2014/2017/2019.

• Worked on writing Queries, Sub Queries and Joins for generating complex stored procedures, Userdefined functions, Views and Cursors.

• Experience in using recursive CTEs, CTE, temp tables and table variables.

• Established suitable Primary key, Unique and Foreign key relationships.

• Good experience in usage of Temp tables, Table variables and implementing best practices.

• Experience in importing/exporting data between various sources like Flat files/CSV/Excel etc.

using SSIS.

• Having experience in SQL Server Integration Services- SSIS with Various Control flow tasks and Data flow Transformations.

• Proficient in using Execute SQL Task, Data Flow task, Data Profiling Task, execute package task, Send Mail task, precedence constraints and for each loop Container.

• Strong experience in using Look up, Derived Column, Conditional Split, Multicast, Data Conversion, Merge Join and Merge transformations.

• Good knowledge on SSRS connecting multiple tables.

• Designed and developed Power bi graphical and visualization solutions with business requirement Documents and plans for creating interactive dashboards.

• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

• Provided continued maintenance and development of bug fixes for the existing and new Power Bi reports.

• Designed a power BI data model with multiple fact tables and dimensions depending on the business requirements.

• Expertise in creating different visualizations like Line, Bar, Scatter Plot, Waterfall Chart, Heat map, Tree map, Card, Multi card, Table, Area chart, Pie chart, Donut chart etc.

• Great knowledge on building dashboards, advanced dashboards using Power Bi expertise in creating storyboard with all the dashboards.

• Experience including analysis, design, development of reports and dashboards for analytics.

• Good Experience in implementation of RLS (Row Level Security) for the Reports.

• Experience in scheduling refresh of Power BI reports, hourly and on demand.