Caleb Nilson Email & Phone Number

Sterling Heights, Michigan, United States

• 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.

St Paul, Minnesota, United States

President of the Data Science and Analytics club, with responsibility for strategizing club activities, managing club budget, inviting guest speakers, organizing and advertising events, delegating to club officers, and working with university faculty and administrators.

St Paul, Minnesota, United States

• Developed database visualization toolchain for shared documentation and schema presentation. • Configured IaaS resources to receive and process vehicle telemetry data into time-series database.• Analyzed MySQL tables to identify needed foreign key relationships and create necessary database migrations.

Anoka, Minnesota, United States

Bloomington, Minnesota, United States

Developed as part of a team a database and financial analysis GUI by which the user could update cashflow information and view projections.