Database Developer Electrical Engineer
Resume:
Matthew Borgers
Senior Programmer/Database Developer
****@*******.**
Education
B.S. University of Tennessee, Electrical Engineering, 1985
Emphasis Microprocessor Design and Digital Logic
Skills
Technologies and tools
C#; VB.Net; MS Visual Studio; SSMS; JavaScript; Fortify; SQL; SQL Server; Oracle; Microsoft Office
Standards and best practices
Agile; DevOps; RMF; CMMI;
Other relevant skillsets
configuration management; cloud migration; tier 3 help desk; regulatory analysis
Work Summary
35+ years as a software developer including:
o25+ years of experience working with every version of MS SQL Server. Over 15 years of database development on deliberate planning systems for the department of defense.
oWork with Microsoft Development environments from VB3 to VS2019 on various systems as a programmer and database developer mostly in the Microsoft Environment for a wide variety of functional areas including point of sales systems, banking financial decision support, health care, security, and factory automation.
Security Clearance
DoD Secret
Experience
DPRA, Inc. – Knoxville, TN
Microsoft Visual Studio, C#, ASP.Net, MVC, Oracle, SQL Server, SSMS, TFS, GIT, Apache SVN, Fortify, JIRA
2019 – 2022: Developer for Consolidated Air Mobility Planning System (CAMPS)
A system used to provide a complete, integrated view of mobility requirements, resources, and commitments; a status of air mobility planning and scheduling activities at each stage from concept initiation through mission closure; and alternative resource options to permit more efficient use of available assets. Mapping out the conceptual design for planned databases.
Perform change management processes and deployment of ASP.Net and C# code using SVN and JIRA for task tracking.
Remediated any identified software issues in existing CAMPS ASP.Net MVC system using Visual Studio 2019.
Designed and Implemented ASP.Net MVC and Oracle solutions to meet new requirements.
2013 – 2019: Senior Database Developer for Joint Flow and Analysis System for Transportation (JFAST)
A system used to determine transportation requirements, perform course of action analysis, and project delivery profiles of troops and equipment by air, land, and sea.
Mapping out the conceptual design for planned MS SQL Server databases.
Perform change management processes and deployment scripts for MS SQL Server objects, including tables, indices, stored procedures and user defined functions.
Monitoring performance of the SQL Server DB and managing parameters to provide fast procedures and other logic for the developers to utilize.
Ensuring that SQL Server storage and archiving procedures are developed and functioning correctly.
Communicating regularly with technical, applications, and operational staff to ensure database integrity and security.
Cellular Sales of Knoxville – Knoxville, TN
Microsoft Visual Studio, C#, SQL Server, SSMS, GIT
2012 – 2013: Senior Database Developer for Sales and Back Office System for Large Wireless Phone Company
Design and development of database system for the sales and back office of a large (over $1 billion in annual sales) wireless phone sales company. The system managed inventories, tracked sales, personnel, offered point of sales capabilities, and provided decision support capabilities to company management.
Developed the overall process flow for the sql data in the newly optimized SQL Server SALES system.
Developed specifications for the SQL Server database server hardware that met the sales system requirements.
Managed the “live” (no downtime) transition of the SQL Server database from an older small, outdated server to a very large modern server with the latest versions of hardware and Windows software.
Designed disaster recovery plans for remote site failover capabilities of the SQL Server Systems.
Provided on call data support for sales team accommodating for the deficiencies of the older existing system.
-
Avanade - Remote
Microsoft Visual Studio, C#, SQL Server, SSMS
2011 – 2012: Programmer Consultant for large consulting and software development company that develops business software for Microsoft products and platforms.
Completed assignment with a very large global financial services firm in the Houston, TX area, designing and architecting the conversion of an old client-server system that was written in Delphi to a new N-tier system (developed in C# using Visual Studio 2010) having a WPF front end (developed using a mild variant of the MVVM model) communicating through WCF data services to the business logic that connects to the existing SQL Server DB.
Completed an assignment for a “fortune 50” client in Chicago enhancing an existing sales support system using Microsoft Visual Studio 2010, C#, and Microsoft Visual Studio Tools for Office.
DPRA, Inc. – Knoxville, TN
Microsoft Visual Studio, C#, F#, SQL Server, SSMS
2009-2010: Senior Database Developer for TET
Developed a system using C#, SQL Server, and F# to help optimize the use of “Opportune Lift” for the transportation of military supplies. Saved the DoD over $1M in the first year of operations.
Wrote a routing object in SQL Server Stored Procedures and F# to find possible transportation solutions for movement requests across a network of thousands of nodes.
Improved performance of previous version or routing algorithm from 1 minute 30 seconds in C# to less than one second using F#.
2009-2010: Senior Database Developer for JP2
Provided SQL Server database development support for a system that provided collaborative planning capabilities for the military using SQL Server programming objects (SPs, UDFs, etc.)
ImagePoint – Knoxville, TN
Microsoft Visual Studio, VB.Net, SQL Server, SSMS, AutoCAD
2008-2009: Consultant/Senior Programmer for Support System Modernization
Provided programming support on a project that involves upgrading an existing critical system to integrate with new third-party software. The existing system was written in VB6. New functionality was being written in VB.Net and ASP.Net.
Developed interface for AutoCAD drawing repository using Visual Studio and VB.Net
DPRA, Inc. – Knoxville, TN
Microsoft Visual Studio, C#, SQL Server, SSMS, TFS
2002-2008: Senior Programmer/Middle-Tier Team Leader for CFAST
Designed and implemented the SQL Server database and associated DB Objects for a new DoD logistics planning system (CFAST) as part of the database team. Each CFAST node was composed of over 40 servers running on a secure network. Have worked to build CFAST from the concept phase to a vital strategic system that is now taught to officers in many of the military war colleges. At one point the CFAST system contained over 80% of the nations deliberate war plans.
Responsible for SQL Server database programming (TSQL and CLR stored procedures and user defined functions) in support of the WinForms application developers.
Provide experience and guidance to newer programmers as team leader for the Middle-Tier Team.
Image Entry – London, KY
Microsoft Visual Studio, VB.Net, SQL Server, SSMS
2000-2002: Senior Systems Programmer on multiple systems
Implemented a proprietary scanning system that processed PDF bar-coded state income tax returns in support of contracts for multiple states. The TaxScan system was developed and implemented using MS Visual Basic and MS SQL Server. The system was used to process almost one million tax returns for these states at a significant labor and cost savings.
Supported various contracts providing analysis, design, programming, database development, and support as needed.
Part of a team that implemented a high-volume order processing (OLTP) system using SQL Server and VB.Net for a multi-million-dollar contract. The system was designed and implemented within a 3-month time and performed successfully during the following year. The system was a proprietary architecture running across multiple Windows servers that utilized VB Script for business rules and MS SQL Server as a data repository.
Headway Corporation – New York, New York
Borland Delphi, SQL Server, SSMS
1998-2000: Senior Systems Manager for StaffServ project
Senior Technical Lead/Developer for development project. Assisted in the development and implementation of a payroll system "from the ground up." The new Payroll system imported data from a DOS based legacy staffing system into a Microsoft SQL Server database. The new payroll system was responsible for printing checks, generating invoices and handling A/R for all branches. The system was developed using Delphi 4 and MS SQL Server 7.0.
Covenant Healthcare Systems – Knoxville, TN
Microsoft Visual Studio, VB.Net, SQL Server, SSMS
1997-1998: Senior Programmer Analyst for HIPAA compliance project
-Provided technical guidance in the development of standards for the desktop and design environments ensuring the use of best security practices.
SAIC – Oak Ridge, TN
Microsoft VB3 – VB6, SQL Server, SSMS, ORACLE, Novell Netware, Novell Btrieve
1992-1997: Systems Engineer for multiple projects
Technical Lead on a project to design and implement Advanced Traveler Information System developed for a state department of transportation. System was developed in Visual Basic and MS SQL Server and consisted of about 200 traveler information kiosks distributed throughout that state receiving traffic, weather, tourist, and other traveler information from a centralized MS SQL Server database.
Senior technical on Automated Claims Processing System for a Large Health Claims provider. System included scanning HCFA-1500 and UB-95 claim forms and extracting and verifying data from the forms and electronically submitting to claims processing. System was developed using Microsoft Visual Basic to integrate off the shelf software running on NT servers with a large MS SQL Server database on a Microsoft Network.
Senior technical on Environmental Restoration Information System (ERIS), a large imaging system developed for a government agency to allow public access to government produced environmental information documents. System was developed using Microsoft Visual Basic on a distributed PC environment accessing an Optical Jukebox and Centralized Database residing on a Novell server.
Programmer on team that designed and implemented SQL*Forms for the Air Lift Services Industrial Fund Integrated Computer System (ASIFICS) for TRANSCOM. Also, maintained and enhanced the SQL*Forms and SQL*Menu systems and developed, maintained, and enhanced SQL script files for the ASIFICS ORACLE V6.0 database.
Computer Engineering – Oak Ridge, TN
DEC VAX, ORACLE, ISAM Files, MODCOMP computers, Allen-Bradley PLCs
1985-1992: Systems Engineer/Electrical Engineering Support for multiple projects
Project lead for a multiyear statistical process/quality control project for a chemical company that used ORACLE V6.0 on a DEC VAX 4000.
Technical lead on a project to develop chemical manufacturing control schemes (recipes) for a chemical company. Recipes were developed on PCs and ported to MODCOMP computers for process control.
Programmer on team implementing an ultrasonic weld inspection system for a nuclear fuel rod manufacturing system. Work was performed on a DEC VAX.
Electrical Engineer on a project for a robotics manufacturing firm providing engineering support for a new product line.
Part of a team of programmers working on a large, automated material handling system for a non-ferrous metals processing company. Work was performed on a DEC VAX.
References
(Available Upon Request)
Contact this candidate