Jul 2020 - Nov 2020
Vertech
Large Defense Contractor
Defense, Aerospace
I designed a custom recipe management system in Microsoft SQL Server to the customer's specifications. A recipe management system consists of a recipe (or material), a series of operations for that recipe, and a series of steps for that operation. Some of the considerations I had to anticipate and take into account were the versioning/duplication of recipes, normalization of the schema tables, efficiency of the schema with potentially large volumes of data, and creating views and stored procedures. With the views, a configuration report (report of versioning and changes in each recipe, operation, step, and parameters associated with a step) and an execution report (report of step execution for each recipe that is ran at a certain date) are possible to create for users to visualize. The front-end application was Ignition SCADA by Inductive Automation, and was primarily designed by the client due to security reasons. I advised the client on system architecture and best practices, and provided python code to assist in connections to my SQL backend schema. Partial or full schema generator script available upon request if interested. :)
Python, MSSQL, MES, Ignition SCADA