Ian Colquhoun Email & Phone Number

Cincinnati, OH, US

Cincinnati Metropolitan Area

Columbus, Ohio, United States

• Designed, 3D printed, and organized lab equipment
• Cleaned and set up lab facilities

Cincinnati, Ohio, United States

• Completed End-to-end project piping data from source to tableau visualization
• Automated daily task of pulling raw CSV data into DB2 database
• Aided in migration from Hadoop to Snowflake by offloading data and creating a new DB2 database to store it

Marysville, Ohio, United States

• Developed and automated processes to reduce office manpower
• Communicated with the client directly to organize data-driven solutions
• Working knowledge of VBA in Excel, Python, & SQL

United States

• Independently developed vehicle defect tracking software used by assembly line associates
• Conducted time studies and process improvements
• Programmed solutions in Python and VBA in Excel to automate process

Dayton, Ohio Area

• Launched project that reduced maintenance cost for pneumatic tube carriers by 70% using 3D printed parts I designed
• Saved the department $7,000 repairing pneumatic station computer chips
• Improved fire inspection process

Dayton, Ohio Area

Helped Drivers sort, transfer, and deliver packages during peak season.

Dayton, Ohio Area

• Demolition, placed & tied rebar, set forms, poured concrete, blocking, set grade.
• Operated Heavy machinery (i.e. JLG, Law, and Bobcat.)
• Shadowed Project manager

Dayton, Ohio Area

• School maintenance, mowing, painting, running cable, cleaning carpets, service lawn equipment, landscaping.
• Managed other workers
• Work part-time during the school year and full-time during the summer.