Production Software Designer
Plymouth, Mn Usa
Developed and managed Microsoft SQL Server databases, creating customized stored procedures, queries, and functions for data mining in conjunction with custom designed graphical user interface (GUI).Reworked company's custom production software application, transitioning architecture as necessary to keep application up to industry standards. Various applications used: Microsoft Visual Basic 6, C#.Net. Worked in a team development setting during company's latest production planning software development initiative, collecting specific design criteria requirements based on management and user input. Software was front end user interface for creation of customizable configurator design of specific prosthetic, orthotic, and seating devices. The software also allowed full visibility to production work flow processes during fabrication from receiving to shipping. Developed / maintained C#.Net based job status website for customers, sales reps, and managers. Created custom software to allow technicians to design/create customized CNC router programs for drilling hole patterns in cushion attachment boards for wheelchair mounting, saving technician time, eliminating alignment and spacing errors, and increasing overall department efficiency. Developed reporting templates using Visual Basic for Applications (VBA) within Microsoft Excel / Word / Access, by which administrative staff could continue to deliver a high level of quality reports with very minimal initial trainingProvided training of SAP reporting to assist management in business decisions. Provided marketing department assistance through development of interactive PDF forms and reporting to assist in strategic marketing strategies.Designed cataloging software system for over 10,000 custom prosthetic liner models in order to alleviate production down time during a planned 1,300 mile warehouse relocation, ultimately allowing for a more systematic physical model management strategy at the new location.