• Over 5+ years of Experience in SQL server databases and Data Loading and Reporting tools with SSIS, SSAS, SSRS, Power BI, SQL Server Integration Services (SSIS). • Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications. • Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes (Clustered and Non Clustered), Stored Procedures, Views, User Defined Functions, Cursors and Triggers. • Proficient in designing and deployment SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Conditional Split, Aggregate, Derived Column, Sort, Multi-Cast, Union, and Data Conversion Transformations. • Experience in dealing with different source and target (like Oracle 11g, SQL Server 2008/2012, Hive, Tera Data, Cassandra, Sales Force, , CSV, flat file, Text Format Data) using different type of connection like ( OLE DB, ODBC, ADO .Net ). • Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management. • Maintaining the Log and Audit information in SQL tables, Experienced in providing Logging, Error Handling by using Event Handler for SSIS Packages • Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. • Hands on generating SSIS packages using Business Intelligence Markup Language (BIML) terminology. • Experienced in developing Window Batch Script to execute SSIS package. Configured Jobs using BMC product Control M 8.1. • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional , Table, Matrix, Chart and Sub Reports • Developing reports on SSRS on SQL Server. Understanding of SSAS, OLAP cube and Architecture. Knowledge of Storage Modes (MOLAP, ROLAP and HOLAP) and processing Cubes using SSIS and SSMS. • Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS. • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart. • Worked on Power BI and prepared dashboards using Tableau to make it more attractive. Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX. • Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects. • Designed and implemented data mart, facts, dimensio