Data warehouse / BI developer with 18 years of experience across a broad technical background, including 8+ years of working fully remote. This background is largely centered around developing reporting systems and includes traditional software development, working with large data sets, ETL / ELT, as well as some elements of project management such as build / release management, mentoring junior developers and working with end users to establish requirements and set expectations.Domain Experience: Health care, life sciences, law enforcement, financial services, general government, real estateSkill Summary: T-SQL, SQL Server BI stack, column oriented databases (Amazon Redshift / Snowflake), Tableau, C#Core Competencies:- Data modelling, report and data visualization development, including writing complex and high performance queries to retrieve the required data- Exploring and understanding a user's requirements so that a better solution can be developed- Reducing project risk by maintaining focus on the big picture and creating procedures to promote consistent usage of source control and continuous integrationProject SummaryHealth care: Development and maintenance of data warehousing BI applications designed to enable analysis of surgical wait times. Reports to identify orphaned patient records in need of cleanup. Reports based off of an SSAS cube to provide the ability to analyze the efficiency of a cancer screening program. SSRS reports for a hospital clinical management system, including requirements analysis and user training.Life sciences: Development of a data warehouse and Tableau dashboards for epidemiology based sales targeting and measuring customer loyalty. Analysis of data and user requirements. Development of queries to populate the data warehouse and to retrieve data for the dashboards.Law enforcement: Java middleware application that enabled the RCMP to query local police force systems and vice versa.Financial services: Analysis of a legacy reporting system and development of SSRS reports to recreate the required functionalityReal Estate: Analysis and cleanup of data stored in Yardi Voyager to allow proper classification of properties in a data warehouse. Creation and maintenance of ETLs to integrate data coming in and out of Yardi