Summary
Overview
Work History
Education
Skills
Professional Development
Publications
Affiliations
Timeline
Generic

Heidi Lynn Haltson

Crystal,MN

Summary

  • Proven Senior Data Analyst seeking an opportunity to leverage my proficiency in data analysis using SQL, SAS, Excel, Alteryx Designer, R, and statistical methods.
  • With my team, I analyzed healthcare claims data and programmed SQL and SAS code that created the UnitedHealth Premium Designation Program, saving clients up to 15% for their healthcare claims payments.
  • I'm seeking to employ my passion for healthcare data analysis, affinity for challenging work, and dedication to data driven decision making.

Overview

15
15
years of professional experience

Work History

Career Break

Caregiver
Robbinsdale, MN
2023 - 2024

Took time away from job search to assist elderly Mother during and after hospital stay and rehabilitation.

Sr. Clinical Data Analyst/Sr. Data Engineer

United Healthcare
Telecommuter
2016 - 2023
  • Performed descriptive, diagnostic, and predictive data analysis; data mining and data modeling using SAS, SQL, Alteryx Designer, and Excel.
  • Created and automated reports, analyzed and interpreted results.
  • Prepared, and presented findings to stakeholders at all levels.
  • Ensured the accuracy and quality of data for users throughout the company by performing quarterly data validation of and research of anomalies of Symmetry Suite output data under tight deadlines.
  • Worked with and combined data from many sources and formats: medical and pharmacy claims, clinical data, state immunization registries, provider and member data; from databases (SQL, DB2, Oracle, Teradata), data lakes, and flat files including denormalized data.
  • Researched and performed analyses to assist clinician team in developing physician quality measures for United Healthcare Premium Designation program.
  • As DBA for team’s SQL Server databases, configured, monitored, oversaw ETL of data from sources, authenticating data all while preserving data integrity and ethically handling patient data and following HIPAA company standards.
  • Increased Alteryx Designer workflow efficiency by installing, maintaining, and managing my team’s Alteryx Server including permissions, managing users, new user onboarding, software upgrades, workflow troubleshooting, and beta testing upgrades.
  • Created data analysis visualizations and presentations using Alteryx, SAS, Tableau, and Excel.
  • Collaborated on a project to retrieve clinical data from faxes scanned into PDFs that were in different formats using Alteryx and Regex.
  • Planned and led weekly Alteryx User Group meetings, giving presentations to pass on important upgrade information, Q&A, and troubleshooting Alteryx workflows.

Sr. Clinical Data Manager

Optum
Eden Prairie, MN
01.2004 - 01.2016
  • Worked with clinicians to assemble business requirements, analyzed, coded, tested, debugged, and documented SQL, SAS, and SSIS programs as a developer on the United Healthcare Premium Designation Program, resulting in significant cost savings for the company and clients.
  • Validated data and researched data anomalies under tight deadlines.
  • Gathered requirements and create documentation including technical specifications.
  • Analyzed data from and acted as subject matter expert for Symmetry Suite claims data groupers and assisted in research and development of Symmetry Procedure Episode Grouper.
  • Conducted SQL and SAS code review for accuracy and efficiency.
  • Performed ad-hoc data analysis and documented and presented results to the team and upper management.

Programmer/Analyst II

NCS Pearson
Bloomington, MN
07.2001 - 08.2004
  • Assembled business requirements, analyzed, coded, tested, debugged, and documented programs with end users, subject matter experts, and team members.
  • Created an internal data driven web site as part of the design and development team using SQL and Coldfusion.
  • Analyzed, programmed, tested, and documented code changes for Oracle Forms and Oracle Reports upgrade.
  • Learned Discoverer and Noetix system administrator tasks and served as back-up during ERP releases, to increase flexibility and efficiency of the Discoverer System administrator.

Education

Bachelor of Mathematics - Actuarial Science Specialization

University of Minnesota

Skills

  • SQL Expertise
  • Base SAS and SAS Enterprise Guide
  • Advanced Excel
  • Statistical analysis including regression, categorical data analysis, and ANOVA
  • Data Mining
  • MS Office
  • Data quality assurance and validation
  • ETL
  • Technical specifications and documentation
  • Requirements analysis
  • MS Access
  • R programming
  • Predictive and descriptive data analysis
  • Data visualization
  • Alteryx Designer and Server
  • Python
  • MS SQL Server DBA
  • Power BI
  • Presenting analysis results and making recommendations
  • Symmetry Suite claims data groupers (ETG, EBM, PEG, ERG)
  • Healthcare claims and clinical data

Professional Development

  • Alteryx Core Certification - 2019
  • UNIX, C, C++ Certification - University of Minnesota, 1999
  • Data Science using Python - United Healthcare 2022

Publications

The Annals of Family Medicine 13 (3) (2015) “Measuring Physician Quality and Efficiency in an Era of Practice Transformation: PCMH as a Case Study”, Lewis G. Sandy, Heidi Haltson, et. al., https://doi.org/10.1370/afm.1784

Affiliations

  • MinneAnalytics, member/presenter
  • Twin Cities Alteryx User Group
  • MinnSUG - Minnesota SAS User Group
  • PyMNtos - Twin Cities Python User Group

Timeline

Sr. Clinical Data Manager

Optum
01.2004 - 01.2016

Programmer/Analyst II

NCS Pearson
07.2001 - 08.2004

Career Break

Caregiver
2023 - 2024

Sr. Clinical Data Analyst/Sr. Data Engineer

United Healthcare
2016 - 2023

Bachelor of Mathematics - Actuarial Science Specialization

University of Minnesota
Heidi Lynn Haltson