McKenzie, Chris
Data Architect - IT Administrative Programming
Mail Code:
Last Updated: 9/30/15 -


Data Architect –
Administrative Programming Services




Utah Valley University, Orem, UT

     Bachelor of Science in Information Systems
           Major Concentration: Healthcare Information Systems; 2014

     Associate of Science in University Studies: 2013

Provo High School, Provo, UT 2002




Utah Valley University, Orem, UT Jan. 2009 – present

Data Architect (April 2014 - Present)

  • Perform analyses that ensure established requirements are met
  • Design and construct data structures that meet project requirements and that comply with EDW design standards and principles
  • Develop Extraction, Transformation and Loading (ETL) applications
  • Understand and implement client, project, and security requirements
  • Manage client projects and provide technical oversight; ensure assigned projects are executed efficiently and according to project requirements.
  • Ensure project deliverables comply with team and organizational standards and principles
  • Participate in development of data marts in-house using a sample data set


Programmer Analyst (Jan. 2013 – April 2014)

  • Plan, develop, test, and document computer programs, applying knowledge of programming techniques and computer systems
  • Use database principles, processes, technologies and tools
  • Analyzes, modify Extract, Transform, and Load (ETL) applications
  • Consult with user to identify current operating procedures and clarify program objectives.
  • Design computer terminal screen displays to accomplish goals of user request.
  • Replace, delete, or modify codes to correct errors.
  • Analyzes, reviews, and alters program to increase operating efficiency or adapt to new requirements.


Business Intelligence Developer- Student Employee (Aug. 2009 – Jan. 2013)

  • Composed weekly reports translating progress on testing and development.
  • Continually monitor and report progress.
  • Help manage a project called Multiple PIDM.
  • Administrator for the Banner Priority Request System (BPRS)
  • Work with the SSID System.




  • Information Builders - FocalPoint

  • CoHEsion

  • U Banner User Group (UBUG)

  • Utah Chapter of the Healthcare Information Management Systems Society (UHIMSS) - Student Liaison Committee

  • Higher Education Data Warehousing Forum (HEDW)








CHIRP-Notification System (

The CHIRP- Notification System is designed to help get the information needed to the EMS responders that respond to a CHIRP registered child. We am currently working on analyzing there current database so that we can make it more efficient, also we are redesigning the current website and giving it more functionality. The biggest improvement is going to be the push notifications to all the Utah dispatching agencies so that they can update their systems that they have a CHIRP child in their area. I am the project manager over this project.