Business warehouseBusiness warehouse project is processing data from different sources to process Premium, Claim and Financial data to analyze Premium, Claim and Financial data.Responsibilities:• Involved in writing Complex T-SQL queries and Stored Procedures to meet the report and ETL requirements. • Involved in performance tuning of T SQL and Created indexes if necessary.• Involved in creating database objects (Tables, Views, Functions and Stored Procedures) and involved in moving objects into different environments.• Used different Tasks in Control Flow and Dataflow Tasks to meet the business requirement.• Worked on upgrading the packages from 2012 to 2016.• Deployed the packages into SSISDB(Catalogs) and done the parameter configuration for DEV, QA, UAT and Production with environments; automated/scheduled execution with SQL agent jobs.• Created error handling for all control and data flow tasks.• Enhanced SSIS packages for better performance of the jobs.• Designed, Developed, Unit Testing and Deployed SSIS Packages, SSAS Cubes and SSRS Reports.• Involved in SSAS tabular model design and implementation.• Different SSRS reports developed by using existing Table, Matrix controls, Chart and also used formulas, functional coding.• Developed Sub reports, Drill Down and Drill through reports.• Developed SSRS reports using different Parameters, column, bar, line and Pie charts.• Developed Power BI Reports and Dash boards using different types of visualizations and filters.• Used DAX expressions in Power BI reports to meet business requirements.• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.• Created Power BI Dashboards as per Business needs.• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.Environment: Windows, T-SQL, SSMS, SSIS, SSRS, SQL Server 2016, Power BI, TFS, DevOps and Visual Studio 2017.