Expertise in end-to-end stack based (MSBI) ETL Solution Design (Data Warehouses, Data Marts), reporting to provide structured and timely access to large datasets.Built and Implemented Data Warehouse application from scratch for multinational Currency using tools- Integration Services (SSIS), SSRS.Built Integration packages (SSIS) and ETL\ELT process to populate the data warehouse from various source systems.Extensive experience in MS SQL Server 2008/2012/2017, Business Intelligence in MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS). Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as MS Access. Expertise in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports, Sub reports and Ad-Hoc reports using SQL Server Reporting Services (SSRS).Expert in Creating and Deploying SSRS Reports and report models on the report manager for user accessibility. Experienced in writing Parameterized Queries for generating reports, Formatting report layout, reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2012.Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions and SQL joins. Key strengths: VB.Net, VB (6.0), Macros (VBA), Crystal Reports, SQL SERVER BI, MS Access and Oracle 8i