Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
AgrimetricaSenior Software Engineer
Apr. 2014 Maintenance and enhancement of Windows (VB6), WinForms (C#), and websites (Classic ASP/ASP.NET MVC) that allow users to collect and track key dairy industry metrics Many of these applications were migrated from legacy VB6/Classic ASP to a newer C#/ASP.NET MVC platform improving the user experience, resulting in increased sales and subscriber retention. The following tasks were completed during the migration: o Entity Framework replaced the legacy ADO.NET in the data layer
o Telerik Controls were added to reduce the need for custom controls, adding greater functionality in the process
o The client-side HTML/CSS was updated to HTML5/CSS3 with AJAX, jQuery, AngularJS, Telerik Kendo UI, and SASS o Multithreading was introduced to optimize runtimes and increase uptime
o Additional features were introduced including a custom ASP.NET WEB API control used to retrieve real-time dairy data, parsed using JSON.NET and stored for later analysis
Created a suite of iOS (Objective-C/Swift) and Android (Java) mobile applications. Dairy farmers use these applications to enter cattle health and milk production information real-time into their mobile devices while working remotely o All mobile development was later switched to Telerik AppBuilder consolidating multiple environments into a single IDE simplifying both development and deployment
Microsoft Azure is used for testing and hosting 5PM is used for project management TFS is used for source control SQL Server 2008 R2/2014 development:
o Stored procedures (written in CLR or T-SQL), triggers, UDFs, views, and queries/scripts were created, maintained, and enhanced to support various functionality in the applications and stand-alone SQL jobs
Colorado Engineering Experiment Station Inc. (CEESI)Senior Software Engineer
Mar. 2012 - Mar. 2014 Maintenance and enhancement of Windows (VB6), WPF (C#) and web-based (C#/ASP.NET) calibration software for meteorological instruments Many of the legacy Windows (VB6) and WPF (C#) applications were ported to C#/ASP.NET web-based intranet applications to mitigate the functional limitations of the older technologies. The following tasks were completed during the migration: o Entity Framework replaced the legacy ADO.NET in the data layer
o Multithreading of the calibration routines due to the CPU-intensive calibration algorithms. This decreased runtime by almost 100% increasing end-user productivity company-wide o The client-side was updated moving the HTML/CSS to HTML5/CSS3 with AJAX, jQuery, Telerik Kendo UI, and BootStrap
Multiple legacy Excel reports had previously been written using suboptimal VBA code-behind looping row by row through multiple nested dynamic SQL queries making return trips to the database during each loop. This was expensive and extremely slow causing a backlog for this and other nightly jobs. To remedy, a DLL was created and referenced by the VBA code (COM Interop/OLE Automation) using a .NET Library class. All suboptimal VBA code was moved into this DLL. Using a series of arrays, multithreaded routines, and SQL Bulk Insert command in batch update mode (now requiring only one round trip to database), runtimes were decreased by over 300%. The nightly bottleneck disappeared and all jobs completed on time
Internal desktop applications required a custom installation package to be written. InstallShield and InstallAware were both used for this purpose. Extensive customization in their proprietary scripting language was necessary in some cases as needed functionality was not handled out of the box Agile/Scrum methodology used within a small collaborative development team
Jira was used for project management tracking tasks, feature enhancements, and bugs Subversion (SVN) was used for source control
QuarterMaster Inventory Management Systems for Law EnforcementSenior Software Engineer
Jun. 2009 - Dec. 2012 Maintenance and development of a WinForms (VB.NET) inventory management application geared towards the law enforcement sector whose existing clientele included Air Force, DoD, DEA, CDC, FBI, and many smaller state and local agencies The application was migrated from FoxPro to WinForms (VB.NET) and SQL Server Express. The following tasks were completed during the migration: o Re-architected into an N-Tier framework as the legacy code had no distinct layering or separation of concerns
o Telerik OpenAccess was used as the ORM in the data layer
o Multithreading was added to various routines to reduce the number of round-trips to the database. This decreased runtime by over 35% enhancing end-user productivity while reducing the number of queued database locks
o Telerik WinForms Controls were used extensively in both the code-behind and the GUI reducing the need for creating custom and/or extending existing controls to gain required functionality
o Google and Yahoo Map API calls were added for locale and geo-restriction further securing the application as is always important to government entities
o RFID barcode scanning functionality was added to automate the data entry process, greatly improving the speed and ease of use while simultaneously reducing errors
InstallShield was used to build the deployment package requiring extensive customization in their proprietary scripting language to add functionality that was not handled out of the box. SQL Server Express back-end used by the application was added to the deployment package to be installed along with the application. SQL scripts were executed within InstallShield for creation of the database, user logins with proper permissions and configurations, table creation with data load, triggers, UDFs, views, and stored procedures. The result being an application that was easily installed by the end-user and automatically patched itself to the latest version
Intch is a Professional Networking App for the Future of WorkSee more people like John on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
489368 people
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
18
Senior Software Engineer @ EarnIn
38549 people
24
Data Scientist Intern @ Newell Brands
42
Senior Mining Engineer @ Riot blockchain
16
CEO/Data Engineer and Consultant @ Propeltech Services LLC