Senior Software Engineer
CurrentFor an aerospace subcontractor I joined an Agile team collecting, homogenizing, and reporting manufacturing work-in-process for numerous dissimilar product lines and production sites.• Implemented ETLs via SSIS w/ C# components, extracting data from Oracle, Teradata, SQL Server, flat files, FTP, and web services.• Developed forecasting app to better predict tool and machine load times.• Traced and tuned production SQL Server databases.For a designer lighting manufacturer I automated an LED color mixing process that combines fixture choices, LED component specs, proprietary color matching algorithms, and cost-conscious inventories to produce circuit board order instructions.• Developed with C# and Razor, utilizing RazorEngine to produce highly portable HTML+CSS documents.• Injectable DLLs define interfaces, storage, proprietary mixing logic, report generation, user interface, and automated unit tests.For a public utility:• Upgraded storage components of an occasionally-connected-application (OCA) used by field service engineers to locate underground gas and electric. Performance improved as much as 10x on slower hardware.• Developed ETLs to integrate data from SQL Server, Oracle, FTP, flat files, and Microsoft’s System Center Configuration Manager (SCCM).• Developed Windows services with C# to facilitate ETL of maps and associated data from SAP and other sources into ImageSite DMS and Tensing GIS.• Migrated datacenter SQL databases from 2008 to 2012.For a renewable energy equipment manufacturer I helped design and lead the development of an IOT system to monitor and control renewable energy systems.• It monitors individual system performance and manages networks of larger systems.• It bridges communication between modern business systems and older ModBus devices.• The cloud-based solution included C#, ASP.NET MVC, hosted on Azure.• I co-authored device-to-cloud communication & security protocol, and implemented the server side code.