Data Analyst
CurrentActive Public Trust PositionCollaborated with the Department of Transportation (DoT) and Federal Transit Administration (FTA) to gather, input, corroborate, and verify information for the National Transit Database (NTD). Collaborated with 150+ DoT agencies nationwide to compile incident data covering emergencies such as crises, medical emergencies, maintenance delays, and collisions. Ensured database security and efficiency by conducting analysis checks on uploaded NTD data.Established and maintained ongoing communication with DoT agencies and supervisors, providing assistance for data uploading and addressing inquiries, and providing both technical and non-technical support, while serving as an intermediary between the FTA and reporters.Utilized Excel, SPSS, and Python tools to streamline the process of reconciling, cleaning, and analyzing large datasets. Produced regular reports that showcased trends in analysis outcomes.Compiled findings into comprehensive reports predicting future incidents and providing recommendations for resolving ongoing issues.Created user documentation for various materials and developed how-to guides and instruction manuals.Reviewed and edited technical documents for accuracy, clarity, consistency, and compliance with established standards. Edited text for grammar, punctuation, spelling, syntax, and other errors in accordance with company guidelines.