Database Engineer
Current- Designed database schema for storing structured vehicle incident reports.
- Coded part life analysis algorithm for calculating usage measurements on components at time of replacement or failure.
- Developed ETL pipeline to convert XML data into relationally structured information.
- Scripted cleansing scripts to correct errors in vehicle mileage accumulation readings.
- Developed database interface web application to query tables, export data, and import user edits.
- Created statistical reports and data visualizations on capabilities of ETL and cleansing processes.