United States Army Human Resources CommandWeb Application Developer
Nov. 2010 - Sep. 2014Ft. Knox, KYDeveloped and maintained SSIS and legacy DTS packages for periodically moving mass quantities of data from the US Army’s mainframe to SQL Server.
Developed, maintained and modernized VB.NET / ADO.NET web apps used to oversee the careers of all 410,000+ enlisted members of the U.S. Army from individual servicemembers to large populations. Served as lead developer of the Enlisted Personnel Management Directorate (EPMD) “toolkit”, a web app portal, as well as 20+ toolkit apps many of which were converted from MS Access.
Optimized SQL queries using table indexes and other means. Used SSMS to inspect SQL queries to find the best optimizations.