SUMMARY:

• Over 20 years of experience as an application developer creating custom applications for Web Applications, Microsoft Form Interfaces and ESRI ArcMap Tools in support of the petroleum industry, Department of Defense, Department of Energy, Public Education, Department of Transportation as well as Hydrology and Survey Applications.
• Proven experience in application planning, leading, software development, database management, business analysis, and quality assurance
• Developing Stand - alone and web-based applications.
• Leading all stages of software development lifecycle, including: requirements gathering, design, architecture, development, testing, implementation, and support.
• Leading/Managing small teams in traditional waterfall methodology and agile methodology.
• Creating application documentation including technical requirements, functional requirements, user manuals, and application tutorials.
• Maintaining existing systems and applying needed patches or fixes to ensure security to servers
• Guiding relational database architecture, administration, and programming of a RDBMS in Microsoft SQL Server
• Foundation in multiple programming languages including Python, SQL, VBA, C#, VB.NET, and many others.

PROFESSIONAL EXPERIENCE:

Confidential

Acting CEO

Responsibilities:

• Authoring series of books for implementing Agile Scrum for IT Projects
• Creating companion books for Agile Scrum for IT Projects using VBA for Excel and C# and Xamarin to create mobile apps
• Developing GIS Application to be used to create maps for daily road trips

Confidential

GIS Programmer and Database Analyst

Responsibilities:

• Developed automated system to reconcile and post SDE data for the Broken Arrow Fire Department on a nightly basis
• Authored scripts to reconcile and post daily input for the Tulsa Storm Water Database
• Primary architect for use of configuration files and non-intervention tools for updating database objects
• Responsible for updating database tables using programmatic methods that can be modified based on the user requirements
• Daily use of ESRI ArcMap and ArcCatalog Enterprise and Server
• Creation of Python Scripts to enhance ArcTools and create new tools to automate tasks for analysts
• Develop Python Scripts to automate manual tasks to schedule daily run times.
• Create applications using VBA to automate clerical tasks to expedite financial form creation

Confidential

GIS Analyst/Developer/Specialist/Administrator

Responsibilities:

• Created Road Inventory Program Feature Classes for multiple Cycles of National Park Service data stored in an Oracle ArcSDE database using SQL and Python
• Authored scripts to convert point and line data for roads into a surface condition rating layer
• Spatial data management using ArcGIS Desktop to create Crash Data and WIP/GIP data
• Developed linear referencing systems using Esri ArcMap 10.3 for WIP/GIP effort
• Designed and created Geodatabases for use with the WIP/GIP effort
• Performed cartographic mapping to visualize WIP/GIP data
• Analyzed and edited WIP/GIP data using ArcMap 10.3
• Developed NPS Navigator website using ArcGiS API for JavaScript
• Familiar with tools in ArcToolbox
• Maintained existing ArcGIS Server applications through use of IIS and updating Security Certificates and fixing security patches identified by Cyber Security Division
• Experience with ArcGIS Server management when maintaining NPS Navigator application
• Supported existing Python scripts for spatial data management using ArcToolbox
• Created and modified Python scripts using ModelBuilder to streamline processing
• Created web application prototypes using Codepen
• Developed NPS Navigator web application in a team environment using GitHub
• Maintained C# Add-in for ArcGIS Desktop 10 known as Crash Locator
• Maintained Silverlight application Park Call Tracker
• Installed ArcGIS for Desktop on client computer
• Developed Macro/VBA applications using Microsoft Excel in support of projects
• Developed and maintain applications using Microsoft Visual Studio 2015 and use Team Foundation Server as Source Control and Project Management
• Used JavaScript and jQuery during development of NPS Navigator and prototypes using Codepen
• Maintained RIP Database using Oracle SQL Developer

Confidential

IT Software Developer

Responsibilities:

• Lead a team of three to create a 508 compliant HTML5 web application using Microsoft Visual Studio, including a database tier, business layer, and graphical user interface that was available on phones, tablets, laptops, and workstations.
• Gather and document technical requirements and user requirements
• Developed web applications in ASP.NET using C# and VB.NET using a three-tiered design pattern based on MVVM and MVC
• Designed user interface to drive display through the use of HTML5 and CSS
• Developing MS Excel Macros using Visual Basic for Applications (VBA) for enhancing Excel workbooks to automate the migration of data and assist in compiling statistics for project sponsor
• Used Microsoft Team Foundation Server as Software Source Control
• Conducted Quality Assurance on the web applications, database, and documentation.
• Acted as Web Master by publishing web applications, managing application pools and firewall settings
• Documented applications by creating user manuals, tutorials, and test plans
• Lead project using Team Foundation Server
• Supported Nutrition system which used WCF as the service oriented IIS for the application
• Used ESRI ArcGIS Desktop 10.3 to create zip code and public school boundaries and integrated with Tableau

Confidential

Senior Programmer

Responsibilities:

• Used WPF to create multi-tiered application using XAML to develop the GUI
• Developed projects using C# and Microsoft SQL Server for logistics and financial application.
• Maintained desktop and ASP.NET applications using C# and VB.NET.
• Develop Microsoft Office Excel support applications using Visual Basic for Applications
• Installed and maintained ArcGIS Server and licensing in support of GIS application
• Design procedure for maintaining applications in support of DOE financial applications.
• Design and implement requirements gathering process
• Responsible for developing Project Plans and coordinating with others to plan and execute the Project Plans.
• Created a transfer process to migrate data from MS Access to SQL Server to use SQL Server as the database for MS Access GUI interaction with data

Confidential

Application Developer/Task Area Lead

Responsibilities:

• Developed Windows desktop applications using C# and web sites using Visual Basic.
• Developed applications in Visual Basic for Applications using Microsoft Excel to manage Financial Data stored in a SQL Server database.
• Maintained legacy applications using Microsoft SQL Server, Windows and Web interfaces.
• Designed, implemented, and maintained SharePoint customizations and web pages in support of offices and teams for dissemination and collaboration as a SharePoint site collection administrator.
• Monitor help desk requests and provide assistance as requested.
• Supervised a team that included a Web Master, two Senior Application Developers, a System Design and Application Developer, two Application Developers, and a Quality Assurance Engineer.

Confidential

Geographic Information Systems Specialist

Responsibilities:

• Built software applications using Arc Macro Language (AML) for internal use to extract, project, and convert into required format of proprietary data to be delivered to clients.
• Developed nation-wide 100K Culture dataset from available data by creating mosaic of outlines, then analyzing and editing the data by automating the snapping of lines between coverages.
• Created AML that produced a 2km fishnet coverage that displayed the location of proprietary well data for the contiguous United States
• Produced internal software to be used as standalone applications to evaluate, create, or manipulate proprietary datasets stored in an Oracle database using AWK, AML, and SQL.
• Designed and developed projects, including a Hard Copy Index application, a User Interface for accessing information through a point and click method, nationwide Field Outline Determination using ESRI Avenue and AML.
• Developed new systems and techniques to create, analyze and verify geographic data through the use of AML and Python.
• Created a parsing application using Python that evaluated geographic data and created new coverages
• Responsible for overseeing and maintaining customized software products.
• Provided general AML, AWK, and SQL support to GIS Technicians and GIS Analyst I.
• Actively participated in QA/QC services for the Map Data and GIS Solutions Departments.
• Documented programs using UML that were written or revised by others to facilitate future revisions.
• Provided programming support to the Maintenance and Distribution Departments.
• Developed C# application to support creation and maintenance of metadata using XML format
• Responsible for maintaining QA/QC program written in C++