After discovering a software glitch that led to certain data points being systematically overwritten in a survey, I wrote a script in R to identify observations where data were lost and calculate the extent of the problem. As a result, we were able to fix the software before more data were lost, and revisit study participants for whom we had missing data.
As the person primarily responsible for keeping projects in compliance with federal and University regulations, I devised a system to track expiration dates, protocol amendments, and updates from project personnel.