Resume
Casey Hargarther
Programmer Analyst III
Healthcare IT professional focused on ETL engineering, data operations, reporting administration, and process automation across enterprise systems.
SSIS, ETL, Azure Data Factory, Databricks, Python
Designing and supporting data pipelines, file transfer automation, dashboard operations, and internal tools that improve reliability and delivery speed.
Professional Summary
Healthcare data and application operations with production discipline.
I build and support ETL pipelines, manage reporting platform operations, and automate file-based workflows for enterprise healthcare teams.
ETL & data pipelines
Develop and enhance SSIS/ETL packages using Microsoft Visual Studio and Azure Data Factory.
Power BI administration
Grant dashboard access and promote reports and dashboards from development to production.
Automation & platform support
Automate FTP vendor file transfers with Fortra Automate and validate/process files in Azure Databricks.
Core Competencies
Core competencies in data integration, reporting operations, and automation.
AI-assisted ETL engineering
Use AI-assisted workflows to design, optimize, and troubleshoot SSIS and Azure Data Factory ETL pipelines.
Intelligent data validation
Apply Python and Databricks-based validation patterns to detect file/data quality issues before downstream impact.
Automation with AI-enhanced scripting
Build process automation across file transfers and operations using Fortra Automate, Python, and AI-assisted scripting.
Metadata-driven pipeline design
Design reusable, parameterized ETL patterns that scale across data sources and reduce maintenance overhead.
Data quality monitoring
Implement rule-based checks, anomaly flags, and validation reporting to improve trust in downstream analytics.
AI-accelerated .NET development
Use Codex and C#/.NET to build internal tools that reduce manual effort and improve turnaround time.
Operational analytics and decision support
Support Power BI platform operations and use data-driven insights to improve production reliability and governance.
Change governance for AI/data workflows
Apply controlled release, ticket review, and production-change discipline for data and AI-adjacent workflows.
Incident response for data pipelines
Diagnose pipeline failures quickly, perform root-cause analysis, and restore service with controlled remediation.
Secure data operations
Apply access controls, environment separation, and production governance practices for healthcare data workflows.
Professional Experience
Professional experience at UT Southwestern and NTSP.
Programmer Analyst III - UT Southwestern Medical Center
Mar 2025 - Present
Lead design, enhancement, and support of SSIS/ETL workflows using Visual Studio and Azure Data Factory for enterprise healthcare data movement. Build and monitor vendor FTP automations with Fortra Automate, and implement Databricks/Python validation to catch data-quality issues before downstream reporting. Develop internal .NET/C# utilities with Codex assistance to reduce manual processing, improve turnaround time, and standardize operational workflows. Partner with stakeholders to scope intake requirements, troubleshoot failed pipelines, and deliver stable production releases.
Programmer Analyst II - UT Southwestern Medical Center
Dec 2021 - Mar 2025
Developed and maintained SSIS packages and Azure Data Factory orchestration pipelines for recurring data integration across clinical and operational domains. Administered Power BI access and supported report/dashboard promotion from development to production. Implemented and maintained automated vendor file-transfer jobs with Fortra Automate, improving consistency of inbound/outbound interfaces. Worked cross-functionally with analytics, ETL, and operations teams to resolve incidents, validate fixes, and document repeatable support procedures.
Programmer Analyst I - UT Southwestern Medical Center
Sep 2019 - Dec 2021
Supported NTSP-to-SWHR transition activities by maintaining Sisense/reporting operations, handling production support, and troubleshooting user-impacting issues. Executed QA for platform updates, maintained file-transfer workflows, and performed initial triage of ETL/reporting defects for escalation or resolution. Prepared and reviewed change tickets, coordinated change-control submissions, and helped ensure weekly releases met governance and production-readiness standards.
Technical Support Engineer - NTSP Holding Company
Oct 2017 - Aug 2019
At NTSP, I performed QA for Sisense platform releases, validated dashboards, and supported ElastiCube/reporting reliability for operational users. Investigated and resolved application and data issues in coordination with ETL, reporting, and application-development teams. Owned production-change oversight by preparing, reviewing, and submitting change-control items to governance stakeholders ahead of release windows.
Selected Projects
Representative work and impact.
SSIS/ADF Pipeline Enhancement
Developed and improved SSIS/ETL packages in Visual Studio and Azure Data Factory for reliable enterprise data movement.
Power BI Access and Promotion Workflow
Administered user access and promoted new/updated dashboards from development to production.
Vendor File Transfer and Validation
Implemented automated FTP transfer jobs in Fortra Automate and used Databricks for file validation and processing.
Education
Florida State University - Bachelor of Science in Information Technology
Graduated in 2015 with a Bachelor's degree in Information Technology with honors. Coursework included database management using MySQL, web development with PHP, and software/application development with C#. This training built the technical foundation for my ETL, automation, and enterprise data operations work.