• Training up client resources to own analytics work in the future• Helping assess/determine what applications from the HC library would be valuable to deploy at the client site• Providing analytic continuity at the client through all phases of deployment.• Implementing and promoting Catalyst methodologies, while acting in the long-term best interest of the client. • Managing client expectations and timelines for analytic deliverables.• Navigating difficult client conversations with professionalism.• Presenting analytic insights to clinical/operational/financial leadership at client.• Interfacing with a variety of Health Catalyst (HC) roles (such as senior directors, product line managers, clinical staff, etc.) on an as needed basis.• Leverage HC software and technologies to lead and perform varied analyses to support client outcomes improvement initiatives across clinical, operational and financial domains.• Design data models and visualizations that meet project requirements and comply with HC design standards and principles.• Manage technical client projects by providing technical oversight; ensure assigned projects are executed efficiently and according to project requirements and timelines.• Lead data validation tests to ensure quality of measurement.• Work with client data architects to train and mentor on HC tools and methodologies• Creating KPI’s to see the trend of a Health Organization

• Translated user requirements for reporting and analysis into data warehouse deliverables • Developed SSIS packages and implemented data auditing strategies and processes to ensure data accuracy and integrity• Supported operation and expansion of data warehouse and reporting environment• Monitored the performance and technical integrity of applications for internal and external customers• Managed multiple projects in a fast-paced environment• Assisted in the construction of an enterprise data warehouse • Extracted and loaded enterprise data warehouse data using cutting edge technology• Monitored the performance and reliability of processes (SSIS packages)• Worked with business analysts to implement business intelligence solutions

• Worked directly with transactional databases writing ad-hoc T-SQL statements in a production environment
• Managed system alerts and load-balanced servers in a production environment to fix performance issues• Created complex stored procedures in T-SQL• Created and displayed SSRS reports using SQL report manager• Monitored the performance and technical integrity of applications for the support of internal and external customers• Analyzed application data to reveal potential problems or areas for improvement• Provided instruction or clarification of the underlying logic to the end users.• Prioritized numerous issues of varying severity• Managed the resolution of all issues within SLA’s (JIRA, TFS)• Deployed production applications, service packs and updates during off hours• Provided emergency coverage 24/7 during designated on-call times• Monitored long running queries, locks, index fragmentation, and other metrics• Designed, configured, and tested computer hardware, networking software and operating system software

• Architected a system using MS-SQL for the McKay School of Education at Brigham Young University• Implemented the plan to migrate from File-Maker Pro to MS-SQL• Developed and implemented scripts, programs and other technical software components into the system• Extracted, transformed and loaded (ETL) great volumes of data from various sources into a data warehouse• Detected, removed, and corrected inconsistent data from the database in order to improve accuracy• Developed stored procedures that provided condensed information to create business decisions• Managed continual improvement of the system while keeping the integrity of the data• Analyzed the data from different perspectives and created summaries to communicate solutions to other teams• Oversaw backup, clustering, mirroring, replication and failover of the databases• Redesigned the system in a regular basis to achieve new objectives