▪ Proficient use of MSSQL Server, SSIS, Power Query, SSRS and Power-BI to develop the solution.
▪ Creating and maintaining SSRS reports using a data warehouse as the data source
▪ Integrating property data from multiple government data sources to build a complete data set.
▪ Design of the Data Warehouse and SSIS package consistent with the existing design
▪ Creation of SQL queries, stored procedures, and functions to implement medium-to-complex business
logic for reporting and analysis purposes.
▪ Query optimization of SSRS reports and stored procedures.