Ryan Merritt Email and Phone Number

Acted as a data manager for the UF Diabetes Institute. • Designed, developed, and managed six database systems in REDCap and MS SQL Server.• Automated ETL processes in Python utilizing primarily the Pandas and NumPy libraries. Ingested,cleaned, and transformed data in multiple formats (.xlsx, comma/tab/pipe delimited, .CEL, .vcf) fromover 10 different sources.• Analyzed genetic data using the university’s high-performance computer. Used tools including Linuxand Windows command lines, Slurm, and plink to clean and extract genetic data for reporting.Troubleshot bash and R scripts by scraping log files.• Designed and implemented data governance policies and procedures for managing over 80 TB of data.Data cleaning and consolidation efforts reduced storage utilization by 20%.• Developed three Python desktop applications using tkinter and the REDCap API to automate retrieval ofinventory locations and bulk-copy desired files to a user-specified location.

Created and managed dashboards on the Google Looker platform. Highlighted and summarized KPIs,including clinic intake, insurance claims, and medication inventory, to upper management. Offered consulting services for IT software implementation and policies.

• Managed day-to-day workflow for creation of digital records for one of the largest collections ofbutterflies and moths in the world. Imaged and managed metadata for over 5,000 unique specimens.• Trained and managed three student volunteers and employees.• Ran Python and Rust scripts for image analysis via command line and Terminal.