Data Specialist | Microsoft Azure Certified | Data Science Enthusiast
10+ years of IT experience in Database Design and Development using Microsoft SQL Server, T-SQL, Performance Tuning and Query Optimization
5+ years of IT experience in SSIS and SSRS.
2+ year exp in Power BI.
1 years exp in Azure Data Factory
Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, Data Dictionaries and Data Integrity.
Good knowledge of Normalization and Relational Database Management Systems.
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, CSV files into MS SQL Server by using SSIS.
Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in SQL SERVER DATA TOOL (SSDT).
Experience in Developing Power BI reports.
Experience data modeling in Power Bi using Query Editor and used calculated columns, concatenation, merge, append etc.
Experience in designing Power Bi dashboard using Slicer, Line Chart, Clustered column Chart, Table, Matrix, PI Chart etc.
Strong in Data Warehousing Concepts.