• Strong experience in using Microsoft Suite–SQL Server Management Studio (SSMS), SQL Server Integration Service (SSIS) and SQL Server Reporting Service (SSRS).• Technical experience with design and hands-on programming on diverse technology platforms including RDBMS, ETL (Extract, Transform and Load) engines, BI Dashboards and KPI Scorecards. • Experience in Logical modeling using the Dimensional Modeling techniques such as Star schema and Snowflake schema. • Experienced working in an Agile environment with SCRUM development framework. Complete understanding of Software Development Life Cycle (SDLC) including requirement analysis, requirement gathering, design, development, implementation, testing, and deployment experience. • IT professional with extensive work experience in developing BI/EDW Applications using Microsoft SQL Server versions 2014-2019.• Experience in Designing, implementation and maintaining Database Schema, Entity relationship diagrams, Data modeling, Constraints, Rules, Defaults, and complex T-SQL statements. • Expertise in creating Tables, Views, Indexes, SQL Joins, complex Stored Procedures, User-defined Functions (UDF), Common Table Expressions (CTEs) providing efficient data retrieval and Triggers to facilitate efficient data manipulation to maintain data consistency. • Experience in Table Normalization, Query Optimization and Performance Tuning using SQL Profiler and estimated Query plans. • Integration and Migration of unstructured data from various types of sources (Excel, XML, Flat file/CSV, OLE DB, JSON) in SSIS. • Good experience in creating complex SSIS ETL packages using various tasks and transformations in Control flow and Data flow. • Implemented Various Error handling and Event Handling Techniques to ensure efficient package execution.• Proficient in developing Dashboards including Drill through and Drill down reports using Expressions and Functions, Parameterized reports, Sub reports, Ad hoc reports, Table and Matrix reports, Interactive reports and various Chart reports using SSRS. • Deployed and configured the reports in the Report Server. • Experience with Report Server and Report Manager. • Experience in Microsoft Power BI Desktop to gather information from multiple sources (SQL Server, Azure SQL Database, Excel, CSV, JSON) and deliver information to the end user. • Experience in building statistical KPI reporting dashboards with predictive analysis.