Thomas Donahue
Thomas Donahue

Senior Data Analyst / Data Engineer

Open to offers · Member since 16 Sep 2026
Location
Danville, United States
Desired salary
Unspecified
Work preference
Remote Only / Contract
Experience level
Senior

About

Professional summary

I am a Senior Data Analyst and Data Engineer with more than 10 years of experience delivering SQL-based transformations, analytics-ready data models, ETL solutions, and business reporting across healthcare, insurance, finance, government, and technology environments.

I specialize in data migration, data conversion, source-to-target mapping, data validation, reconciliation, and reporting. I have worked extensively with EHR and EMR platforms including Cerner, MyAvatar, Epic, eClinicalWorks, GE Centricity, Athena, and Allscripts.

I use SQL, Python, VBA, Microsoft Access, Excel, SSIS, Snowflake, and cloud data tools to automate complex workflows and improve data quality. My automation work has substantially reduced manual processing and documentation effort across cross-functional teams.

I build curated data models and reporting datasets that enable self-service analytics and operational decision-making. I am experienced in translating business requirements into practical data solutions, reports, mappings, and governance processes.

I have consistently delivered measurable business value, including large cost savings through improved migration processes, automated reconciliations, data-center reporting, and legacy application archival. I communicate technical concepts effectively to both technical and non-technical stakeholders.

Skills

31 capabilities

Tech stack & tools

Working toolkit

Collaboration

Communications

Data Stores

Development

Libraries

Experience

Career history

Systems Analyst 3 Texas Health and Human Services

I led end-to-end data migration initiatives across Cerner and Netsmart MyAvatar EHR platforms, improving migration efficiency and generating approximately $800K in savings. I also architected analytics-ready datasets and curated data models for self-service reporting and downstream analytics.

I developed documentation and reconciliation automation using VBA and Python. These solutions reduced hospital-process documentation from three weeks to 15 minutes and a recurring four-day reconciliation task to five minutes.

Data Extraction Consultant Orlando Health Regional Medical Center

I led data migration for the GE Centricity EHR platform and helped reduce personnel costs by approximately $300K. I created custom mapping scripts and transformation logic to normalize structured and unstructured information between disparate EHR schemas.

I designed analytics-ready data models, developed Power BI reports, and automated workflows across Excel, Word, Outlook, Access, and PowerPoint using Python. The transformation process improved from approximately 2.5 days to 35 minutes.

Business Analyst Leidos

I managed the migration of archived legacy applications to a new platform, contributing approximately $600K in savings. I coordinated with multiple teams to archive applications, standardize documentation, and preserve record integrity.

I extracted, validated, and packaged application data for long-term retention. I also built Python automation connecting Microsoft Office applications to accelerate archival reporting and reduce documentation effort from two weeks to two hours.

Data Analyst LTCG

I built SQL transformations and database objects to create reporting solutions that improved efficiency and saved approximately $450K. I led migration work across Epic, eClinicalWorks, and Allscripts EHR platforms.

I extracted, transformed, and loaded patient records, appointments, clinical notes, lab results, and billing data, reducing processing time from four days to one hour. I also reverse engineered Visual Studio code for Snowflake use and automated Office workflows with Python.

Data Analyst Fiserv

I developed data solutions to track a data-center closure and the implementation of new servers, contributing approximately $1.5M in savings. I created SQL reports for server migration progress and decommissioning metrics.

I imported and parsed XML documents, mapped extracted data to database fields and Excel worksheets, and reduced processing time from three days to 15 minutes. I also built Python-based Office automation to standardize reporting.

Data Analyst State of New Hampshire, Department of Agriculture

I developed Microsoft Access databases and Excel VBA solutions to support business requirements. I reconfigured an Access database to meet client specifications and resolve complex business scenarios.

I analyzed stakeholder requirements and communicated technical concepts effectively to audiences with varying levels of technical knowledge.

SQL Developer Precisely

I converted and validated data as part of legacy-to-new system migrations. I reconciled source and target datasets to ensure accurate and reliable data conversion.

I developed SQL queries, views, and stored database objects to transform source data into reporting-ready datasets.

Data Strategy Analyst Captivate

I programmed ad hoc reports using SSIS and relational databases to support business performance. I built SQL transformations using queries and database objects to produce reporting outputs.

I applied Python scripting to connect Excel, Word, Outlook, Access, and PowerPoint, improving the speed of ad hoc report delivery.

Data Analyst Lincoln Financial Group

I developed and implemented data governance solutions and defined source-to-target mappings to support reporting and governance requirements. I worked with property and casualty insurance data.

I used Python automation across Microsoft Office applications to improve the efficiency of data-governance activities and recurring reporting work.

Data Analyst State Street Bank

I implemented data governance policies across functional groups and gathered requirements for new reports and repairs to existing reports. I worked across multiple business areas to align reporting solutions with stakeholder needs.

I collaborated with an India-based team to close sprints 40% faster through coordinated delivery and process improvement.

SQL Developer Boston Children's Hospital, PPOC

I integrated clinical data from 77 physician practices across six EMR systems into Epic. I engineered SQL transformation logic and database objects for clinical and operational reporting.

I performed ETL for patient, clinical, and billing records from eClinicalWorks, GE Centricity, Athena, and Allscripts during the Epic implementation.

Data Analyst Liberty Mutual

I improved quality assurance for a monthly SDLC process from more than two weeks to less than 30 minutes. I planned, led, supported, and improved business analysis and software development lifecycle processes.

I worked hands-on with property and casualty insurance data and products, including Personal Auto, Motorcycle, and Property rater products.

Data Analyst Comcast

I worked as a contract Data Analyst supporting data-related business activities.

Specific project responsibilities and achievements were not provided in the resume.

Senior Report Developer Advantedge Healthcare Solutions

I balanced monthly accounts receivable to zero for all clients and performed underpayment analysis. I investigated and resolved root causes for accounts that did not reconcile.

I supported financial reporting accuracy through detailed analysis, reconciliation, and issue resolution.

Education

Learning history

Clark University Computer Career Institute

Master's Certificate, Advanced Enterprise Development

Master's Certificate in Advanced Enterprise Development.

Merrimack College

Bachelor's Degree, Business Administration, Management

Bachelor's Degree in Business Administration and Management.

This professional hasn’t added portfolio projects yet.

This professional hasn’t listed any services yet.

People also viewed

All talent ›
Jobs Talent AI Tools Salaries
Menu