John Sabel Email and Phone Number

• Manage education data analysis projects with minimal oversight.• Develop probabilistic and deterministic linking methods for the entity resolution of person data.• Perform probabilistic and deterministic linking methods for the entity resolution.• Develop SQL based and SAS based QA and QI processes for entity resolution and data warehouse integrity and correctness.• Model education domain and health domain data, including student data, NSC data, death certificate data, hospitalization data.• Develop SAS macros and SAS macro libraries. See• Tools in use include SAS 9.3, Embarcadero DBArtisan, Embarcadero ER/Studio, SQL Server Management Studio, Link Plus, AutoMatch.

• Developed SAS based QI process to increase the efficiency of the intake and coding of marriage and divorce data.• Developed a complex SAS based QA process to automate the loading of, and the correctness of, Behavior Risk Factor Surveillance System (BRFSS) data into the BRFSS-IQ online data analysis system.• Provided the technical expertise for the creation of the Washington State Living Will Registry website.• Developed a process to longitudinally match multiple years of hospitalization data files in order to create hospitalization revisit analysis file.• Performed data analysis using hospitalization data and death certificate data.• Provided technical consultation to other DOH employees and outside partners regarding the analysis of hospitalization, death, divorce, and marriage data.• Skilled in the analysis of morbidity data using ICD-9-CM codes.• Skilled in the analysis of mortality data using ICD-10 codes.

• Systems analyst and database manager for the statewide injury datasystem.• Developed and maintained the Excel based data mining application InjuryRateAnalyzer, for analyzing injury rates within Washington State.• Provided technical assistance regarding the analysis of injury data using ICD-9-CM and ICD-10 codes.