Zachery McDougall

United States

@mcdougallzachery

Analytics Team Lead @Crumbl HQ | MSBA Candidate

Badges

Sql

Certifications

Work Experience

  • Analytics Team Lead

    Crumbl•  April 2023 - Present

  • Analytics Engineer

    Health Catalyst•  November 2021 - April 2023

    •Generate insights into costs of care utilizing medical claims and events data to find ways to save money and improve patient experience. •Ensure HEDIS compliance by updating measures, stores procedures and data visualizations. •Ensure data quality and cleanliness by utilizing Azure DevOps via Visual Studio for QA and version control. •Create or review technical design documentation to ensure the accurate development of reporting solutions. •Manage timely flow of business intelligence information to users. •Provide technical support for existing reports, dashboards, or other tools.

  • Business Inteligence Analyst

    ASEA, LLC•  September 2017 - November 2021

    •Used SnowSQL to create dimensional models and data cubes to make data quickly an intuitively accessible. •Created ETL processes using Python for API connection and DBT for data transformation. •Developed intuitive and navigable dashboards to convey complex data in simple manner using Dundas BI. •Slash vendor implementation costs by learning, creating, and updating IVR (Interactive Voice Response) menu system with DTMF and chat text responses using Nice inContact proprietary programing language. •Continually drive improvement and automation of reporting by utilizing tools such as r, python, vba, and power query.

Education

  • University of Utah

    Busieness Analytics, MS•  January 2021 - May 2022

    In 2021 and 2022, this program was ranked in the top 10 Best MSBA Programs in the U.S. by the TFE Times. The program used R as its preferred language with additional exposure to Python. I gained expertise and experience in elements of machine learning in addition to more traditional statistical approaches. My coursework included many meaningful classes. Some of my favorites were Statistics and Predictive Analytics, Data Science with Big Data, Data Mining, Data Warehousing, Algorithms for Business Decisions, Machine Learning, Analytical Decision Models, and Text Analytics (NLP).

  • Utah Valley University

    Healthcare Administration, BS•  August 2017 - December 2020

    The Healthcare Administration program at UVU included many important courses such as: Business Statistics, Epidemiology, Financial and Managerial Accounting, Effective Business Presentations, Management Information Systems, Spreadsheet Applications, and Written Business Communication.

Skills

mcdougallzachery has not updated skills details yet.