Summary
Overview
Work History
Education
Skills
Timeline
Generic

Mackenzie Mathews

Castle Rock

Summary

Data analysis professional prepared to deliver impactful insights and drive business decisions. Adept in data visualization, statistical analysis, and database management, with strong focus on teamwork and adaptability. Known for reliability, analytical thinking, and results-driven approach. Skilled in SSIS, SQL, SSRS, and Excel, ensuring robust data solutions and strategic recommendations.

Overview

11
11
years of professional experience

Work History

Data Analyst/ETL Developer

Verita (Formerly Computershare)
07.2020 - Current
  • Produced monthly reports using advanced SSRS tools and data queries
  • Improved decision-making processes with accurate data analysis and visualization techniques.
  • Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
  • Enhanced business efficiency by identifying trends and patterns in complex datasets.
  • Managed large-scale databases to ensure timely access to critical information for key stakeholders.
  • Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.

Data Warehouse Developer

Computershare
08.2014 - 07.2020
  • Generated reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse.
  • Assisted with the migration of legacy systems to modern platforms, ensuring minimal disruption to business operations during the transition process.
  • Incorporated data validation procedures to catch errors early in the ETL process, reducing the risk of incorrect information being propagated throughout the system.
  • Mentored junior developers in best practices for data warehousing design, development, and maintenance.
  • Identified opportunities for process improvements in existing workflows leading to increased productivity and cost savings.
  • Ensured data accuracy and integrity by conducting thorough audits of source systems, validating transformation logic, and monitoring ongoing data quality.

Education

Computer Information Systems

Metropolitan State University of Denver
Denver, CO
05-2017

Skills

  • Data visualization and presentations
  • Data analysis
  • SQL/SSIS/SSRS
  • Excel functions
  • Customer Service
  • Strong work ethic

Timeline

Data Analyst/ETL Developer

Verita (Formerly Computershare)
07.2020 - Current

Data Warehouse Developer

Computershare
08.2014 - 07.2020

Computer Information Systems

Metropolitan State University of Denver
Mackenzie Mathews