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. I also build internal .NET/C# tools and support change-control processes for stable production releases. Education: Florida State University (2015).
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 development and enhancement of SSIS/ETL packages using Visual Studio and Azure Data Factory for enterprise healthcare data workflows. Build and monitor vendor FTP automations in Fortra Automate and use Databricks/Python validation to improve data integrity before downstream consumption. Develop internal .NET/C# tools with Codex assistance to reduce manual operational effort and speed delivery.
Programmer Analyst II - UT Southwestern Medical Center
Dec 2021 - Mar 2025
Developed and maintained SSIS/ETL packages and Azure Data Factory orchestration for recurring data integration processes. Managed Power BI operational tasks including user access provisioning, report promotion, and release support across environments. Implemented and supported automated vendor file-transfer workflows with Fortra Automate, improving reliability and turnaround for inbound/outbound data exchanges.
Programmer Analyst I - UT Southwestern Medical Center
Sep 2019 - Dec 2021
Supported continuity of NTSP reporting/data operations after acquisition, including Sisense QA, troubleshooting, and production support. Maintained automated file-transfer processes and assisted with issue triage and resolution for business-critical data flows. Reviewed and prepared change tickets, and submitted change-control requests for weekly governance review to support safe production releases.
Technical Support Engineer - NTSP Holding Company
Oct 2017 - Aug 2019
Performed QA of Sisense releases, supported ElastiCube/reporting operations, and resolved application issues for internal users. Maintained production reporting reliability and coordinated operational support across ETL, reporting, and application-development teams. Managed production-change oversight by reviewing and submitting change-control requests to governance stakeholders.
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. Coursework and applied work focused on systems analysis, database concepts, application support, data workflows, and enterprise technology operations, which established the foundation for my ETL, reporting, and automation career path.