KRISTI D SWANSON
Health Data Analyst
**************@*****.***
https://www.linkedin.com/in/kristi-swanson-57645013b/
Lexington, KY
EXPERIENCE
Data Operations Specialist Apex Systems- R1
Apex Systems- R1/CloudMed
02/2024- Current
•Designed, developed, and maintained data integration workflows for 36 Physician and Hospital Sites
•Conducted data quality analysis and quantitative analysis on large datasets containing healthcare claims and financials totaling over 5 million per month
•Improved data ingestion efficiency by 30% through the creation of standard and custom ETL scripts in Visual Studio
•Completion falling under the projected timeframe by 30%
Senior Health Data Analyst
Lucina/Trinity Analytics
03/2022 - 02/2024 Lexington, KY
•Built and supported reporting requirements for assigned clients using datasets containing payer claims, care management data, pharmacy claims, ICD-10 codes, procedure codes, and other claim details
•Developed Power BI dashboard for the Care Management team, achieving a 97% Client Satisfaction score
•Enhanced UI for existing Power BI dashboard with 9 KPI visualizations measuring Infant and Maternal Mortality Rate, Preterm Birth Rate and Low Birth Weight to improve maternal and neonatal outcomes
•Embedded 5 Power BI reports on a portal page detailing Pregnancy and Complication Cost, Utilization Metrics and Disparity Metrics
•Managed access for over 1K users
Health Data Analyst II
Bluegrass Care Navigators
03/2020 - 03/2022 Lexington, KY
•Increased report reliability with biweekly maintenance and development of bug fixes for 15 Power BI reports
•Enhanced data access for the Memory Care team by implementing a Power BI dashboard detailing Quality of Care, Operational Efficiency, Financial and Regulatory Compliance to assist care providers benefiting 30+ team members
•Led development of 25+ Ad HOC reports in Power BI to address limitations of current EMR software impacting over 100 employees
Patient Access/Patient Experience
Patient Experience Baptist Health Lexington
10/2015 - 02/2020 Lexington, KY
EDUCATION
Bachelor's Degree - Marketing/Public Relations
Morehead State University
Morehead, KY
MHA - Health Care Administration Management
Walden University
Minneapolis, MN
SUMMARY
Dynamic and detail-oriented Health Data Analyst with extensive experience in healthcare analytics, data integration workflows, and business intelligence solutions. Adept at developing and deploying Power BI dashboards, and Apache Superset Dashboards conducting quantitative analyses, and ensuring data quality in diverse healthcare and financial datasets.
Proven ability to streamline processes, solve complex data challenges, and deliver actionable insights to improve organizational outcomes. Strong expertise in SQL, Python, DAX, and ETL processes, complemented by a deep knowledge of Azure services and containerized applications. Dedicated to leveraging data to drive impactful decisions and enhance operational efficiency.
KEY ACHIEVEMENTS
Data Integration Streamlining
Improved data integration for 36 sites, reducing
errors by 30%.
High Client Satisfaction
Achieved 97% client satisfaction with Power BI
dashboard.
Enhanced Maternal Health Dashboard
Built dashboard with 9 KPI visualizations for
maternal health.
Innovative Data Access
Increased data access by creating dashboard for
Memory Care team.
SKILLS
Agile Methodology Apache Superset
Azure Azure DevOps Databricks DAX EMR ETL Kubernetes Microsoft Power BI Microsoft SQL Server PostgreSQL Python SQL SSIS Tableau Visual Studio
SQL Server Management Studio MySQL