Dennis Tharp Email and Phone Number

Design and develop parameterized workflow to process data for a large automobile manufacturer’s marketing vendor.Lead probative meetings to apprehend marketing campaign concepts, data and workflowsAnalyzed platform documentation to understand limitations, use-cases, and syntaxDetermined parameter inputs to drive workflow and outputsDocumented parameters, digdag workflows, presto queries, and python code in design documentLead project planning and small development team to deliver MVP on schedule.Produced detailed process runbook and other documentation in ConfluenceCurrently planning post MVP revisions and functionality for more complex campaign workflows.

Developed services (Python) and SQL queries to ingest, normalize and deliver patient data in varied formats.Improved ACO program algorithm which identifies qualified patient cohorts from varied data sources, Developed tools to streamline addition of program qualifications, and QA results with stakeholders to deliver quality results quickly. Reduced program development time from 3-6 months to 1-4 weeks.Identified and rectified data integrity and processing efficiency issues in legacy ingestions, improved post load processes, optimized many poorly written BI queries, automated legacy processes.Designed and proposed changes to universal patient matching REST API process to utilize messaging queues to process endpoint requests and responses to analyze local patient data.Develop CI/CD pipelines for Azure PaaS and data factory SaaS - Azure blob triggered python function extract Excel data from multiple files, normalize+ingest / powershell function to extract pwd protected zip files + ingestWorked with frontend developers to deliver json payloads for web application API

Designed and developed automated ingestion of large variable column flat files with AWs SQL Server RDS, linux docker image with SFTP and windows vm in AWS. Ingestion times reduced from 45 min to 45 sec. - processing up to 10 files asynchronously.Optimized queries in dozens of POS integrations, improving ETL times by 100-400%Collaborated with large corporate vendors and clients worldwide on new and existing projectsCleared 18 month backlog of cases in first 3 months at AveroResolved 2 year old ETL issue with significant changes to extraction application code base in my 3rd month, Much internal documentation (I write well)

Side jobs doing handyman repairs/remodels and IT related consulting for small businesses. Decided to try it full time after 2011 layoff. Many small repair and tiling jobs, bathroom remodels, roof repairs, etc.Small business technical consulting: router config, cable running, punchdowns, coding / database projects

Manage numerous graphic design projects in a fast paced environment to timely completion.

• Designed and developed enterprise level grant and accounting management software, after focused consultation with end users, to meet the needs of their mission.• Microsoft Application automation expertise. Automated emails, Word merge documents, Excel spreadsheets from database data.• Earned SQL chops during the 10 years developing database systems.• Advanced quickly - team lead of 3 support people, after a year or so, before promotion to Programmer Analyst.• Davis Productivity Award notable mention for work in developing database system to manage and track research grants and payments.• Employee of the Year for outstanding internal customer support scaling the above-mentioned database system was incorporated for use in all UF Research units after transition to PeopleSoft failed to capture accounts payable data for administrators.• Developed excellent communication skills with non-technical personnel.