Automated ODK Data Integrity Engine (R pipeline for ODK export cleaning/validation)
Developed an automated R pipeline to clean and validate Open Data Kit (ODK) field exports used for downstream analysis. Implemented geospatial fence-checking to flag GPS drift in records to improve the reliability of collected field data. Automated string normalization and data quality logging to reduce manual cleaning workload for large beneficiary datasets.• Cleaned ODK form export fields prior to analysis.• Performed geospatial validation using sf-based fence-checking.• Logged data quality issues automatically to support auditing.• Reduced manual cleaning time by approximately 80%.