Design and implement business intelligence solutions including back-end data warehouse design and implementation on Microsoft SQL Server, ETL design and implementation using SSIS (SQL Server Integration Services), and front-end reporting and dashboards using SSRS (SQL Server Reporting Services), Crystal Reports, Excel, PowerPivot, PowerView, QlikView, etc. Designing and implementing multidimensional models using SSAS (SQL Server Analysis Services) including traditional OLAP models as well as in-memory tabular models. Designing and implementing TSQL queries and stored procedures to prepare data for reporting. Experience in performance optimization of TSQL scripts and database design to ensure maximum performance and timliness of queries and processes.