• Extensively involved in Development, Implementation and Reporting in MS SQL Server 2016/ 2014/2012/2008 R2/2008 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).• Proficient in Creating, Configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Engine Tuning advisor.• Involved in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.• Responsible for creating reports such as Cascading, Drill down/Drill through Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.• Involved in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.• Worked extensively on Data visualization and Data analyzation using Power BI.• Designing and Developing the Dashboard Reports in Power BI using DAX.• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.• Developing the reports using Power BI, Power Pivot and SSRS.• Implementing Drill Through & Hyperlinks in Power BI report.• Developed and maintained multiple Power BI dashboards/reports and content packs.• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.

• Responsible for gathering/refining requirements from the customer for developing reports in Power BI.• Built Data Analytics or visualization using Power BI (Power View integrated with Share Point).• Worked with DAX/MDX queries in building expressions for various business calculations.• Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.• Involved in Developing Power BI visualizations and dashboards using Power BI Desktop.• Created Grouping, sorting columns and writing expressions according to the business requirements.• Transferred the data using SSIS packages.• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.• Created SSIS packages to Export data from text file to SQL Server Database.• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.• Generated Reports using Global Variables, Expressions and Functions for the reports.• Identified and worked with Parameters for parameterized reports in SSRS.• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.• Generating Ad-Hoc reports on a timely basis and also to fulfill immediate requirements.• Used star and snowflake schema in designing cubes for creating SSAS packages.