Sql Server .Net Core

FRED CUNNINGHAM

Kansas City, KS ***** 913-***-**** ********@*****.***

Personal Summary

Dynamic Solutions Engineer with extensive experience at CNH Industries, specializing in Azure development and microservices architecture. Proven track record in designing REST APIs and managing SQL databases, enhancing operational efficiency. Adept at transforming complex data models into actionable insights while fostering collaborative team environments. Committed to driving innovation and excellence in cloud deployment.

Skills

Azure development

Microservices architecture

REST API design

SQL database management

Data modeling

Cloud deployment

Education

Some College (No Degree), Computer Science

University of Kansas Lawrence, KS

Web Master Diploma

National American University Kansas City, MO

Microsoft Certified Database Administrator

Kansas City, Kansas Community College Kansas City, KS

Certifications

AZ-204 Microsoft Certified Microsoft Azure Developer Associate

Experience

Solutions Engineer/Technical Lead Jul 2021 to Feb 2025

CNH Industries Burr Ridge, IL

Remote

I lead an area of transformation called the VMS BFF (Backed for Frontend)

The vehicle management system is a customer-facing, Angular 16, single-page application hosted as an Azure app service

It allows dealers to manage associated companies and their inventories of equipment and assigned devices

This application uses an Azure instance of Microsoft CRM as its primary data source

The primary goal of the transformation effort is to remove Microsoft CRM and distribute the data and relationships it contains into several domain areas

The technologies used are Microsoft .NET Core, Azure Kubernetes clusters, Azure API, and

Azure Key Vault, Azure Functions, Azure Service Bus Management, Azure Cosmos DB, and

Azure SQL Server

I also created internal utility applications using Blazor

One of those applications generated test data for developers

This application consisted of a Web Api backend created using .net core 8

This C# backend performed the actual creation of test data and stored it in a SQL Server database as a unique dataset

I also have development experience using TSQL for Azure SQL Server, Microsoft SQL Server SQL development for PostgreSQL

The Blazor application created a UI for selecting Customers, Farming equipment, and implements to be used in creating the test data.

Software Engineer III Apr 2019 to Jul 2021

Valorem Reply Kansas City, MO

I supported development and maintenance of custom applications and REST API development to support the automation of Office 365 migrations using PaaS applications, Azure Web Jobs, Azure Service Bus, SQL Server, Razor, JavaScript, .NET Core, and Entity Framework Core.

Sr. Software Engineer Mar 2018 to Apr 2019

General Electric Aviation Edmond, OK

I am currently involved in the transition of our public-facing commercial digital asset management system, Air Vault, to Microsoft Azure

The application architecture is being redesigned to use Azure services that benefit the re-architecture

My role has been to design and develop an application gateway API and design and develop .NET Core microservices within Docker containers

I am also responsible for deploying developed microservices within a Kubernetes cluster on Azure

I have also been responsible for the maintenance and new development of a public-facing commercial document management system, Air Vault, designed for the Airline industry

This is a mature product that consists of several applications that make up the core system and is extended via customization to meet a specific airline's needs

These applications are created using .NET Framework 2.0, .NET Framework 4.72, .NET Core, JavaScript, ASP .NET, ASP .NET MVC, C#, and Angular

The development environment used is Visual Studio 2012, 2013, 2015, 2017, and Microsoft Management Studio 2016

The data repository used is Microsoft SQL Server versions 2008 R2, Microsoft SQL Server versions 2012, and Microsoft SQL Server versions 2014

On a daily basis, I work with any of the technologies listed above.

Independent Computer Consultant Feb 2017 to Mar 2018

Soft Solutions Kansas City, KS

Provide training, Microsoft Dynamics CRM administration and development services, Network support services and custom application development services for individuals and business.

primary consultant Aug 2017 to Dec 2017

ALT, INC

Upgraded Windows server 2008 to Windows server 2012

Refreshed 100 workstations to windows 10

Provide training for end users on upgraded software, for the Neighborhood and Community Services department of the Kansas City, MO for their Information System project

I designed a client/server application in PowerBuilder 3.0 to store and manage inspection information collected from onsite property inspections

The client/server application was integrated with commercial 3rd party applications for inter-department messaging and time management

The application was supported by a Novell local area network

The network consisted of a network server, database server, communications server and support for 75 user workstations and 25 special data processing workstations that handled input of inspection results

My tasks also included:

Setup of Server hardware and installation of Novell NetWare 3.12 for all 3 servers

Installation and setup of hardware/software for Novell NetWare SNA server

Installation and setup of hardware/software for Novell NetWare Connect 1.3 and Novell Communications server

Installation and setup of Sybase SQL Server for NetWare

Installation and setup of Microsoft Mail

Installation and setup of ArcServe for NetWare

Installation and setup of FaxServe for NetWare

Setup of hubs for network communications

Setup of user workstations and network connections

Installation of Microsoft Office

Assisted in the redesign of current business processes that were to change as a result of the implementation of the new system and the creation of new business processes

Created and directed a 10-member User development team designed to provide feedback on the application design and it's progress

Created and mentored 5-member support team designed to provide in house support for Novell NetWare, desktop applications software and the custom client/server application

Designed and implemented two projects for Animal Control of Kansas City, MO using Informix 4GL on a AT&T Star Server running UNIX system 5 and the Informix Standard Engine

The first project tracked the issuing of new, replacement and renewal of licenses for pets of residents in Kansas City, MO

The second application tracked the collection and refunding of fees collected when a pet is adopted from the Kansas City Animal Control

This application also handled the notification of owners who had not returned to collect refundable fees within a defined period of time.

Software Engineer Aug 2016 to Feb 2017

Companion Protect Merriam, KS

I was responsible for the new development of two public facing Web Portals that will provide entry points into the claims processing system for individual customers and veterinaries

The portals are created using Angular 1.3, ASP.NET MVC 5, Typescript, C#, Entity Frame work 6 and Microsoft SQL server 2016 as the backend repository

I was also responsible for the design and implementation of the backend database

All of the development work is created using Microsoft Visual Studio 2015 and Microsoft Management Studio 2016.

Programmer/Analyst Jun 2015 to Dec 2015

PNC BANK Overland Park, KS

I was responsible for the maintenance and new development of existing Web API for internal applications

I was responsible for the maintenance and new development of existing customer facing and internal ASP.NET Win Forms/MVC applications using, NET 2.0 – 4.6, VB.NET and C#

Java script, JQuery, Kockout.js and Signal R are used heavily in front end development of most projects

SQL Server 2008 R2 and SQL Server 2012 are used for the creation of T-SQL Stored Procedures and SSIS backend development

Visual Studio 2010, 2012 and 2013 along with TFS 2013 are used in our primary tools in the PNC development environment

The new development consisted of creating an application that allowed customers to select specific loan documents from portfolios stored in PNC's document management system and have placed in a shared folder to be transmitted to them via FTP and a scheduled time each day.

Programmer/Analyst As Nov 2014 to Jun 2015

Armed Forces Insurance Leavenworth, KS

As a Programmer/Analyst, I am responsible for the maintenance and implementation of new feature requests using .NET 2.0 – 4.6 of ASP.NET Win Forms, ASP.NET MVC, JavaScript, jQuery, Knockout.js, and SignalR applications, and SQL Server 2008 R2 Reporting Services developed in VB.NET and C#. I also support legacy applications written in VB6.

All of these applications use Microsoft SQL Server 2008 R2 and 2012 databases as their data repository and require the development of T-SQL stored procedures.

Programmer/Analyst Mar 2014 to Apr 2014

CVR Energy Inc Kansas City, KS

In this role I was the sole developer responsible for the creation of a DNN 7.1 web-based application

The application provided a resource for employee evaluations conducted by CVR Energy Human Resources

This application used SQL Server 2008 R2 as its data repository

I designed and developed the application database and stored procedures

The employee evaluation application UI was created using custom DNN 7 modules in C#.

SQL Server / ASP.NET Programmer Aug 2013 to Mar 2014

YRC Freight Overland Park, KS

My duties include support and maintenance of existing web and server-based applications within the sales operations group

This requires bug fixes and maintenance of Microsoft SQL Server 2005 and 2012 stored procedures, functions, views, SISS packages and process improvements on a daily basis

I am also responsible for updates and bug fixes for all ASP.Net WebForm applications that support sales operations functions for internal and external employees.

NET Developer Mar 2013 to Jun 2013

Computer Science Corporation Overland Park, KS

In this role I was part of a development team that supports the Early Intervention Program which is administered by the state and partially funded by the federal government

This program provides services to children who are developmentally challenged from birth to 3 years of age

As a developer on this team I am responsible from maintenance and new development of ASP.NET Win Forms ASP.NET MVC applications and SQL Server 2008 R2 Reporting Services developed in VB.NET

I also support legacy application written in VB6

All of these applications use Microsoft SQL Server 2000/2005/2008 or 2008 R2 Database as there data repository and requires the development of T-SQL Stored Procedures

All reports are developed using Microsoft Report Services 2008.

NET/C# Developer Oct 2012 to Dec 2012

Shoutz Inc Austin, Texas

I developed a web-based administration application and designed its database to managed information associated with their mobile and web base game Play and Win, which can be found at Shoutz.com

This application was written in ASP.NET/C# and used Microsoft SQL Server 2008 R2 database as its data repository.

ASP .NET Application Developer May 2012 to Oct 2012

Penton Media Overland Park, KS

I currently work as an ASP.Net Application Developer

I am responsible for the regular maintenance, bug fixes and new development for any one of over 50 ASP .NET magazine publication websites

I also perform any SQL development on Windows SQL Server 2008 R2 databases and SQL Server 2008 R2 Reporting Services supporting the publication websites.

Database Administrator, SQL Server DBA\Application Developer Apr 2011 to Apr 2012

Elecsys Corporation Olathe, KS

As the, I was responsible for the design, implementation, maintenance and repair of the organization's databases

Our current production installation consist of a single instance of SQL Server 2008 R2 Professional supported by a dual socket system containing quad core Zeon processors, 1200 GB of local storage partitioned into four 300 GB logical drives and 24 GB of RAM running under Windows Server 2008 R2

Our Test and Development system uses SQL Server 2008 R2 Professional running under Windows 2008 R2 with a single quad core processor and 16 GB of RAM

As a developer I am responsible for the implementation of new applications, office integration and automation projects

These projects are web base applications written in ASP.NET MVC 3/C# 4.0/jQuery 1.6 utilizing Microsoft SQL Server 2008 R2 Professional as the repository

Report development is created using SQL Server 2008 R2 Reporting Services and end user ad hoc reporting is created using Crystal Report 7.0 and 8.5

EstimationPRO, I am the lead developer for the company's development efforts to convert their commercial Microsoft Excel Spread Sheet product into a Windows forms desktop application

This application is written in VB.NET using Visual Studio 2010 and .NET 4.0

Microsoft SQL Server 2008 R2 is being used as the data repository Microsoft SQL Server Management Studio used as the main SQL development and management tool

My role as the Database Administrator includes database design, maintaining the integrity the database and its application data and providing a resource for other developers as it relates to the database issues

Entities Framework 4.0 used as primary data access technology.

ASP.NET/C# Developer Jan 2012 to Apr 2012

Adcuda Kansas City, MO

I was used as a resource to complete an online web application designed to collect information for the installation and maintenance of equipment used to monitor grain elevator bins

This information was then used to create a final contract for the customer

This application was written in ASP.NET/C# and used a MySQL 5.5 database as its data repository.

DBA/Application Developer Apr 2011 to Apr 2012

Elecsys Corporation

As the Database Administrator I was responsible for the design, implementation, maintenance and repair of the organization's databases.

Our current production installation consists of a single instance of SQL Server 2008 R2

Professional supported by a dual socket system containing quad core Zeon processors,

1200 GB of local storage partitioned into four 300 GB logical drives and 24 GB of RAM

running under Windows Server 2008 R2.

Our Test and Development system uses SQL Server 2008 R2 Professional running under

Windows 2008 R2 with a single quad core processor and 16 GB of RAM.

As a developer I am responsible for the implementation of new applications office

integration and automation projects. These projects are web base applications written in

ASP.NET MVC 3/C# 4.0/jQuery 1.6 utilizing Microsoft SQL Server 2008 R2

Professional as the repository.

Report development is created using SQL Server 2008 R2 Reporting Services and

end user ad hoc reporting is created using Crystal Report 7.0 and 8.5.

Programmer/Analyst Feb 2010 to Dec 2010

Riverside Transport Inc Kansas City, KS

I was the primary developer for companies report automation efforts

All reports that existed in Excel, Access or other 3rd party applications were converted to Microsoft SQL Server 2005 Reporting Services running in a Windows Server 2003 R2 environment

Microsoft SQL Server Management Studio used as the main SQL development and management tool

I also developed ETL packages using SQL Server 2005 SQL Server Integration Services to automate the processing of raw data entering the reporting systems.

Programmer/Analyst Jan 2010 to Dec 2010

Awasom Medical Billing & Coding LLC Kansas City, KS

Was the primary Designer/Developer of the Awasom Medical Billing & Coding LLC website (http://awasommedicalbilling.com).This is a ASP.NET/C# site developed using Visual Studio 2008 and SQL Server 2005 has been used as the data repository

I am filling the role as Webmaster for the website handling issues such as problem resolution with the Web Hosting Provider, Configuration of Hosting environment and installation of website's application files on the hosting server

I am also provided development resources for any application maintenance or enhancements.

Programmer/Analyst Mar 2010 to May 2010

Premier Tech Inc Overland Park, KS

I was the primary resource for enhancements and maintenance of an existing ASP.NET/C#/JQUERY commercial web site using a MySQL database as it data repository

This site provides industry compensation data to the companies customers

Microsoft SQL Server Management Studio used as the main SQL development and management tool.

Programmer/Analyst Oct 2007 to Dec 2009

ALT, INC Oak Grove, MO

I have been the primary Designer / Developer for the creation of a web application designed to manage project information for this communication services company

This application uses ASP.net/C#/JQUERY with 3.5 .net framework

The development environment used is Visual Studio 2008

This IDE has been used to create the web client interface and SQL Server 2008 has been used as the data repository

Other technologies in this project are AjaxControlToolkit-Framework3.5SP1, Microsoft Chart Controls for Microsoft .Net Framework 3.5 and Microsoft SQL Server Reporting Services

SQL Server 2008 Reporting Services was integral part of the solution that I am provided for my client

The reports are created using Visual Studio 2008 Report Designer

User access reports from the from within the application by selecting the report a list

The report is then displayed within the application

The report listing was created using an asp.net data grid which was populated using the reporting services web service

The report is displayed within the application using the Microsoft Report Viewer control.

Network Administrator Oct 2006 to Dec 2009

ALT, INC Oak Grove, MO

Windows 2003 Small Business Server Administration and Support services

Network Management

Asset Management

Server Backup Monitoring and Administration

Windows XP Workstation Administration and Support services

Application Administrator Jul 2007 to Jan 2008

Datacore Marketing Kansas City, KS

Administer internal and third-party software development and tracking tools including Data Entry System, Check Writing System, Data Hygiene System, USPS Integration, etc

Provide technical support, troubleshooting, and resolution for issues with the above systems

Frameworks include .NET, C#, SSIS, SQL Objects, Python Script, HTML, and Java Script

Identify technical components, standards, processes, and procedures needed to gain efficiencies and effective delivery of aspects utilizing the above systems.

Programmer/Analyst Aug 2006 to Dec 2006

StarData Kansas City, KS

My responsibilities included providing maintenance and enhancements for the client/server Case Management application

The main purpose of this engagement was to upgrade the application to PowerBuilder 10.5 and convert the data repository from Sybase System 11 to Microsoft SQL Server 2008.

Programmer/Analyst Mar 2006 to Dec 2006

GRS Enterprises

Athens, Attica in Greece

I transitioned a Microsoft Access 97 application to SQL Server 2000

This involved recreating the access database and it's tables in SQL Server 2000, changing Access Forum table references and VBA code table references to there correct table objects in SQL Server 2000 and redesigned the application security access methods.

Programmer/Analyst May 2006 to Jul 2006

Diamondhead LLP Screven, Georgia

Converted VB6/Access database application to a Web application using PHP 4.x, C and MySql 4.x

The existing application used the windows version of the Swiss Ephemeris DLL

The target platform for the converted application is Linux which also required me to recompile the C source code for the Swiss Ephemeris library using GNU C compiler under SUSE Linux 10.2 and create a wrapper to access the required functionality from PHP.

Programmer/Analyst Aug 2005 to Jan 2006

Financial Business Systems, Fargo North Dakota

This project required our team review 540,000 lines of code in an web application that connects to an IBM DB2 database back-end and modify the code to allow the application to concurrently function using a PostgreSQL database back-end.

Programmer/Analyst Feb 2005 to Jul 2005

StarData Kansas City, KS

Designed and created Web Site for customer in the music industry to allow his organization to display and manage information about available products, allow potential customers to listen to samples of available recordings and create an interface to PayPal to allow customer to purchase products on the web site

This client pages for this web site was created using JSP, HTML, Tomcat and JavaScript

MySQL was use as the data repository for the application.

Programmer/Analyst Oct 2004 to Dec 2004

StarData Kansas City, KS

My responsibilities included providing support on new development and enhancements for a client/server Case Management application

The client application was developed in PowerBuilder 9.0, Erwin Tools and used Sybase System 11 as its data repository

All of the applications’ business functionality was implemented as Sybase stored procedures and triggers.

Programmer/Analyst Jan 2004 to Aug 2004

StarData Kansas City, KS

I was the primary Designer / Developer for the creation of a desktop application designed to manage transactional information for towing services

This application used Java and NetBeans to create the client interface and Pervasive Postgres as the data repository

Pervasive Postgres is a windows version of PostgreSQL, an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2.

Educational Resource Assistant Jan 2003 to Aug 2003

NAU Kansas City, MO

Blue Ridge Campus

I provided educational assistance and one on one tutorial session for students taking classes in SQL, Visual Basic, Access and Java.

Programmer/Network Administrator Sep 2001 to May 2002

Gray Automotive Products St. Joseph, MO

My duties include providing PC hardware and software support for all end users, administration of our Novell 5.1 network and backup administrator for the engineering department’s Windows 2000 network

I am also the administrator for the AS/400

Development tools currently used are RPG AS/400 and Visual Basic for Applications.

Independent Computer Consultant Feb 1999 to Jun 2001

Soft Solutions Kansas City, KS

Provide training, support services and custom application development services for individuals and business.

Programmer/Analyst Sep 1998 to Mar 1999

NAIC Kansas City, MO

Support and maintenance of PowerBuilder applications and Stored Procedures on Sybase and Oracle database systems.

Programmer/Analyst Jul 1997 to Jan 1998

Hillyard Inc St. Joseph, MO

My responsibilities included writing design specs for a new order entry system that replaced an existing Cobol application, creation of development standards, design of the application using Cornerstone 5.0 and PFC as the code framework and mentoring Hillyard IS developers in using PowerBuilder 5.0, Erwin Tools and Microsoft SQL Server 6.5.

Team Leader Jan 1997 to Jul 1997

American Angus Society St. Joseph, MO

For this year 2000 project the client decided to replace its existing Honeywell/Bull mainframe and it's Cobol applications with Client/Server technology

The backend consisted of Microsoft NT 4.0 and Microsoft SQL Server 6.5

The GUI was developed using PowerBuilder 5.0

My responsibilities included writing specs for new applications that replaced COBOL applications, creation of development standards, design of the application framework using PFC as the application foundation and mentoring American Angus Society IS developers.

Programmer/Analyst Sep 1996 to Jan 1997

LDDS/ WorldCom Tulsa, OK

My responsibilities included new development and enhancements to existing line of business applications using PowerBuilder 4.x, Sybase System 10 and Tandem for two tier client/server projects and report development for billing applications

Tandem development involved the use and maintenance of C++ routines to access Tandem Database Group - Nonstop SQL

These routines were then referenced through an ODBC interface by client-side PowerBuilder applications.

Programmer/Analyst Dec 1995 to Sep 1996

USA Administration Services Inc Overland Park, KS

My responsibilities included programming and design tasks as a senior member of the development team, which supported new development and enhancements for a client/server Annuity Administration application named, “ENABLER”

The client application was developed in PowerBuilder 4.0, Erwin Tools and used Sybase System 10 as its data repository

All of the applications business functionality was implemented as Sybase stored procedures and triggers.

Programmer/Analyst Aug 1995 to Dec 1995

Koch Industries Wichita, KS

I was the application manager for a production application named IMIS

IMIS is an enterprise application that allows internal customers and suppliers on-line access to both current and historical information concerning internal market transactions, both in summary detail views

Internal Market suppliers could manually or electronically feed internal markets transactions into IMIS

Because their customers have access to this information, suppliers do not generate and distribute hard copy invoices

Customers and suppliers have on-line IMIS access for the purpose of monitoring and analyzing their internal purchases and sales

The architecture of IMIS is implemented as a two-tier application with a light client, developed in Powerbuilder, and a heavy back end implemented in Sybase System 10 running under UNIX System V on a Sun Sparc 2000

Batch processes are implemented to process large transaction files and perform a monthly generation of general ledger entries, which are uploaded to the mainframe general ledger system

The batch applications consist of a collection of UNIX c shell scripts and c applications accessing Sybase stored procedures via Sybase dblib API

All of the business functionality is implemented as Sybase stored procedures and triggers

My responsibilities as the application manager consisted of providing technical support for the daily on-line batch operations recommend future changes in the direction of the application architecture and assume the role as the project manager/developer during the implementation of major enhancements and maintenance projects.

Technical Specialist Jan 1995 to Aug 1995

Ferrellgas Liberty, MO

Included:

Installation of Microsoft Windows NT Advanced Server 3.5 on a Compaq Proliant 2000 server

Serve as the Decision Support Systems NT Advanced Server administrator

Installation of Microsoft SQL Server 4.2 on a Compaq Proliant 2000 server

Serve as the Decision Support Systems database administrator

Installation of NT Advanced Server RAS services for remote NTAS and SQL Server access via TCP/IP and NetBUEI

As a member of the Decision Support system team I was the primary PowerBuilder developer for the Corporate Datawarehouse project

I created and assisted in the design and implementation of the Datawarehouse database design and the design of business processes created or changed as a result of the change of data location or method of data access

I created Microsoft SQL stored procedures and triggers using Transact-SQL and designed and implemented business applications that used the data warehouse as there data source.

Programmer/Analyst Nov 1994 to Jan 1995

Computer Task Group Overland Park, KS

I was a member of a development team assembled to complete an update to the Sprint Conference Line Scheduling and Billing application

The application was developed in PowerBuilder 3.0 with Oracle 6.0 as its data repository

My task was to design and implement time adjustment functions for the application to allow the system to adjust scheduled conference times and dates to the customer's time zone and not the geographical location of the switch that the conference would be scheduled to use.

Programmer/Analyst Nov 1993 to Oct 1994

Technology Service Group Lenexa, KS

I was a member of a development team assembled to complete an update to the Sprint Conference Line Scheduling and Billing application. The application was developed in PowerBuilder 3.0 with Oracle 6.0 as its data repository. My task was to design and implement time adjustment functions for the application to allow the system to adjust scheduled conference times and dates to the customer's time zone, and not the geographical location of the switch that the conference would be scheduled to use.

Independent Computer Consultant Aug 1992 to Nov 1993

Soft Solutions Kansas City, KS

Custom Programming in SmartWare, Wingz, Access and xBase tools in DOS and Windows environments

SmartWare and SmartWare II are Innovative Software products that are no longer supported by Informix Software

This provided an opportunity for me to offer training, support and custom programming for those who continued to use these products in their daily business operations

Created application using Microsoft Access for a government agency to collect and maintain information on Heart of American volunteers

Translated application for a provider of Nursing Home Administration software from FoxBASE DOS to FoxPro for windows running under Pen Windows on a Grid pen system

The user interface for was rewritten to take advantage of a graphical user interface and the Pen operating environment

The rewrite provided the company with a basis for an updated application in FoxPro 2.5 for DOS and Windows

Member of a development team assembled to create an application for the marketing department of a major corporation

The goal was to create a user interface to assist marketing personnel in finding and selecting data from the corporate mainframe

The user interface was written in

Contact this candidate