Continually reverse engineering 4 main customer facing products; two comparative rater software packages, one agency management tool, and one analytics data collection and distribution tool. Also continually reverse engineer internal tools for operations and development support and plan modernization paths to increase efficiency. Identified configuration and release management risks in current processes. Implemented standardized automated build and deployment management, where possible, using TeamCity and Git to increase product release reliability. Reduced number of help desk staff required as product releases stabilized.
Designed and developed a flexible ASP.NET WebAPI as the main engine to exchange data between this company’s comparative rater software and over 30 small to large insurance companies using the ACORD XML message standard. Digested applicable sections of the 3,000 page ACORD messaging standard for auto and home property and casualty insurance quoting. Isolated common data structures into reusable components as well as implementation layers that allowed personalization of messaging to meet the needs of over 30 companies whose own implementations varied. Decreased time to field an interface to a company from 4+ months to less than 1 month. Trained junior developers on how to implement the API for insurance companies as contracts are reached to add more companies the rating software.
Participated in the design and development of updated analytics data collection, reporting, and distribution to subscribing companies allowing them to perform competitive analysis of insurance program performance in the independent insurance agent market. Developed an ASP.NET WebAPI to process the analytics data submissions for auto, property (home), motorhome, motorcycle, and watercraft lines of business from company comparative rater software. Improved client access to analytics data via a custom web application that allows subscribers to access and download analytics data files according to their contract terms.
Designed and implemented an integration strategy for a third party vehicle VIN decoding API used in the comparative rater software. Designed and implementing a caching strategy to meet contractual limitations on data caching to enable the VIN data to expire and refresh on demand. Retrofitted both the VB.NET web client as well as the VB6 desktop client to utilize the new API.
Pursued and received a contract to reverse engineer a 2000 vintage existing ASP.NET document configuration management system that had not been maintained for three years for the U.S. Air Force and deliver needed software fixes in four months. Successfully achieved the contract goals within time and budget.
Pursued and received a contract to redesign the mission essential Process Order Design and Display (PODDS) document management system using current technology with WebDAV support for Microsoft Office integration to emulate SharePoint functionality and incorporate a sophisticated custom workflow structure for document review, approval, and publishing to support depot repair operations worth millions of dollars a day in workload. Led a team that developed and fielded the candidate system through acceptance testing. Used ASP.NET MVC and WebAPI architecture as well as several third party library integration to achieve the requested functionality.
Pursued and received a small business innovative research contract to design a new product, the Decision Support Tool (DST), to enable users to perform predictive analytics on small amounts of data to support lifecycle management of the U.S. Air Force Intercontinental Ballistic Missile (ICBM) fleet. The design was contractually required to be extremely flexible for dual use by the U.S. Department of Defense and private industry to allow parsing and collation of an unpredictable number of disparate data sources and data formats. The architecture was designed to facilitate integration of third party statistical analysis tools such as R, Reliability Workbench, and JMP as well as custom programmed predictive analytics algorithms. A flexible workflow system was integrated to enable data and findings to be routed for review and approval through unpredictable organization hierarchies. The product was successfully demonstrated, but failed to land commercialization funding within the DOD and private industry.
Provided software engineering support to the 309th Software Maintenance Group (SMXG), F-16 aircraft mission planning software support as well as technical publication configuration management and distribution for the 416th Supply Chain Management Squadron (SCMS) of the 748th Supply Chain Management Group (SCMG).
Worked as a member of the SMXG team sustaining F-16 mission planning software using CMMI Level 5 software development processes. Responded to change requests and defects by updating existing C# code. Modified existing NSIS install builder scripts. Used the Unified Code Counter software from the USC Center for Systems and Software Engineering to assess software source code size and complexity for existing and future workloads.
Worked as the a full stack developer for the 416th SCMS maintaining a technical document distribution web application and content used worldwide by F-16 aircraft units to sustain operations. Maintained servers, application software,
and user access. Maintained all DIACAP paperwork needed to renew system approval to operate on the DOD network.
Worked as full stack developer for the 415th Supply Chain Management Squadron of the 748th SCMG maintaining their Business Objects reporting server and report distribution web application using ASP.NET and C#. Responded to requests for desk side support and changes to the reports and web application. Maintained all DIACAP paperwork needed to renew system approval to operate on the DOD network. Assisted in data center movement planning to save $1 million per year. Assumed responsibility for administering legacy IBM Lotus Notes servers and client software across the organization saving them $100K annually. Provided desk side support to Lotus Notes users.
Designed and developed a new web based backorder tracking system for the 415th SCMS Space/C3I supply chain managers that aggregated backorder information from legacy U.S. Air Force systems to enable managers to effectively monitor and respond to changes in back order status to shorten acquisition lead times as well as perform roll up of status information for executive decision making. The system was developed using ASP.NET and C# along with SQL Server and Oracle database queries. The system was demonstrated by the commander of the 748th SCMG to the entire group as an example of innovative technology used to facilitate positive process change.