Proplanner.NETSenior Database Developer
May. 2014 - Oct. 2022Ames, Iowa, United StatesSenior Database Developer (2018 – 2022)
• Designed and developed custom C#.net and Javascript / Angular web applications to manage shop floor manufacturing processes such as signing on to a unit, consuming parts from inventory, and filing roadblocks. Used CI/CD to manage version control.
• Singlehandedly transitioned a client (Amazon Robotics) from manual paper based manufacturing processes to fully automated, database-driven web and mobile application shop floor systems using ASP.NET C#, Javascript (React and Angular) and SQL Server. At the time we were short-staffed and I took on the project to ensure success.
• Another one of my favorite projects was helping Oshkosh standup manufacturing assembly of the new model mail trucks. This involved a lot of data loads and data quality assurance.
• Migrated numerous clients data and databases from on prem SQL Server to Azure. Database Developer (2014 – 2018)
• Served as primary liaison between Proplanner databases, clients, and external systems. Developed SSIS interfaces to extract, translate, and load order, bill of material, routing, and item data from various file formats and data sources. Wrote T-SQL queries, stored procedures and C# scripts to load or export various data sets, or interact with web services, for over 30 clients having different informational needs.