Peter Koelbl Email & Phone Number

• Converted very large solution from using static classes to proper dependency injection.• Upgraded multi-project solution from .net core 2.2 to 5.0 to 6.0.• Created developer environment using Docker Desktop, Dev Containers and Bridge to Kubernetes.• Created multi-platform Docker images for use on regular 64-bit machines and M1 arm 64-bit machines.• Switched from App Services to Kubernetes.• Made numerous SQL optimizations.• Numerous features and bug fixes for event… Show more • Converted very large solution from using static classes to proper dependency injection.• Upgraded multi-project solution from .net core 2.2 to 5.0 to 6.0.• Created developer environment using Docker Desktop, Dev Containers and Bridge to Kubernetes.• Created multi-platform Docker images for use on regular 64-bit machines and M1 arm 64-bit machines.• Switched from App Services to Kubernetes.• Made numerous SQL optimizations.• Numerous features and bug fixes for event ticketing system. Show less

Garfield, Arkansas, United States

• Developed Chrome extension in React that captured audio and sent it to AWS Transcribe Medical for dictation into a website.• Developed check-in system for use on tablet in Xamarin.• Developed automated database maintenance application that backs up databases to Azure cloud storage, reorganizes/reindexes databases, and monitors drive space on the clients server.• Developed deployment application to push out product solutions and patches.• Created a kids check in station for a… Show more • Developed Chrome extension in React that captured audio and sent it to AWS Transcribe Medical for dictation into a website.• Developed check-in system for use on tablet in Xamarin.• Developed automated database maintenance application that backs up databases to Azure cloud storage, reorganizes/reindexes databases, and monitors drive space on the clients server.• Developed deployment application to push out product solutions and patches.• Created a kids check in station for a local church using MVC5 as a front end and Web API 2 and SQLite as a backend.• Develop custom add-ons for Microsoft RMS and other Point of Sale products. Show less

Dublin, Ohio

• Built iOS and Android Xamarin app for recording audio into FLAC format and uploading it to IBM Watson for transcoding and then identifying the speakers in the audio for Machine Learning analysis.• Built iOS, Android, UWP Xamarin app for analyzing energy and equipment usage, also synced files across devices.• Built admin site for managing users using .net core MVC6• Built multiple APIs using .net core for use with mobile apps and websites.

Sears Home & Business Franchises

• Implemented design and coding standards.• Put in place code review process.• Created centralized log viewing page in MVC5 and Bootstrap4 so that help desk could view/search error logs. Before logs were separate and spread out to different systems.• Upgraded TFS from 2015 to 2018.• Refactored various applications’ code and t-sql calls to fix long standing performance problems.• Created web api for use with new website.

Wendy'S

• Rewrote old vb.net automated administrator password update for non-domain restaurant systems with c#/WCF using Certificate Authentication and encryption.• Designed and built custom Windows Desktop UI in WPF/c# to replace explorer.exe to create a secure locked down environment for servers in restaurants.• Built updating framework in c# that pulled down updates to stores via SFTP and installed them• Replaced legacy VB6 apps with modern C# apps with a UI experience to match the new… Show more • Rewrote old vb.net automated administrator password update for non-domain restaurant systems with c#/WCF using Certificate Authentication and encryption.• Designed and built custom Windows Desktop UI in WPF/c# to replace explorer.exe to create a secure locked down environment for servers in restaurants.• Built updating framework in c# that pulled down updates to stores via SFTP and installed them• Replaced legacy VB6 apps with modern C# apps with a UI experience to match the new Desktop look and feel.• Miscellaneous maintenance and feature work on existing back office applications and utilities. Show less

State Medical Board Of Ohio

• Replaced a hand written form with a website.• Designed SQL database for storage of data from website.• Created Web API 2 service for receiving ajax calls from website.• Used HTML5, Knockoutjs and jquery for the web front end.

• Optimized sql full text search setting and queries so web site search results were returned in 1 second where before they were returning uncached results in 30-60 seconds.• Reduced sql timeouts on numerous internal applications by optimizing stored procedure queries.• Added features and performed maintenance on asp.net intranet site.• Added features and performed maintenance on numerous services that the external website and intranet connected to.• Optimized sql database… Show more • Optimized sql full text search setting and queries so web site search results were returned in 1 second where before they were returning uncached results in 30-60 seconds.• Reduced sql timeouts on numerous internal applications by optimizing stored procedure queries.• Added features and performed maintenance on asp.net intranet site.• Added features and performed maintenance on numerous services that the external website and intranet connected to.• Optimized sql database indices to increase sql performance and reduce timeouts.• Researched new ORM solutions to replace the current clunky and aging library. • Changed application pools and services to use windows authentication from using sql authentication with passwords stored in configs to increase security.• Changed a great many inline sql calls to the database to use stored procedures.• Devised strategy to migrate to VS & TFS 2013 from VS & TFS 2010 and update solutions/projects to .net 4.5.2• Participated in many design meetings for new features to help determine scope and hours required. Show less

Diocese Of Columbus

• Convert static data for the Catholic Directory into a SQL Database with Reports in SSRS.• Created data entry app for entering contact info for use in the Directory. Using WPF, C# and entity framework.• Design and Develop module for DotNetNuke(DNN) for managing and maintaining Diocesan Directory Information.• Update Code base to .net 4.5.1, using Visual Studio 2013 and the latest version of DNN(7.2.2).

Ohio History Connection

• Converted MS Access database application to a SQL Server 2014 backend. Used for tracking historical documents that is sent out to correspondents that pay for a copy of the document.• Created new front end replacing the Access app in WPF using C#. Utilized a unified searching function for pulling up old records.• Imported historical data from the Access database into the new SQL database using an SSIS package to transform the data into a relational database utilizing keys and indices.

• Worked with team to develop methodology for reliably building and deploying Microsoft Dynamics AX customizations.• Developed WPF app for deploying MS solution customizations. Included a versioning and tagging system so releases could be tracked. Utilized C#, SQL and PowerShell.• Developed Integration Framework for exporting Data from to a MS solution to various fixed width/delimited formats. Included WPF app for generating an XML based format mapping and automatic code generation for… Show more • Worked with team to develop methodology for reliably building and deploying Microsoft Dynamics AX customizations.• Developed WPF app for deploying MS solution customizations. Included a versioning and tagging system so releases could be tracked. Utilized C#, SQL and PowerShell.• Developed Integration Framework for exporting Data from to a MS solution to various fixed width/delimited formats. Included WPF app for generating an XML based format mapping and automatic code generation for an MS solution. Built using C# with a SQL backend. Show less

Columbus, Ohio Area

• Key developer for government contract involving supply stores on Marine bases.• Developed an ETL SSIS package for loading items from a vendor supplied file to Microsoft Retail Management System. Replaced a semi functioning slow VB6 application. Resulted in a process that pushed 600k items out to store databases in minutes as opposed to days with the previous application.• Responsible for feature addition and maintenance of cloud based multi-channel integration solution for ERP, POS… Show more • Key developer for government contract involving supply stores on Marine bases.• Developed an ETL SSIS package for loading items from a vendor supplied file to Microsoft Retail Management System. Replaced a semi functioning slow VB6 application. Resulted in a process that pushed 600k items out to store databases in minutes as opposed to days with the previous application.• Responsible for feature addition and maintenance of cloud based multi-channel integration solution for ERP, POS and Accounting systems. Leveraged C#, XSLT and REST web services. Show less

Hilliard, Ohio

• Responsible for feature addition and maintenance of integration/automation application between absence management software and a legacy system. Used WCF and a messaging system called Sonic for passing XML messages between the systems.• Development and maintenance of absence management software written in C# and WinForms with a SQL backend.• Developed web questionnaire template for automated creation of absence cases

Columbus, Ohio

• Development and Maintenance of Life Insurance website for use by Independent Insurance Agents using .net 3.5 with a SQL 2005 database. Changed a lot of hard coded data to be database and config driven.• Responsible for Server migration from old Windows 2000/ SQL 2000 to Windows 2008 and SQL 2005 in multiple environments Dev/QA/Production.• Conversion of Life Insurance Illustration System from .net 2.0 to .net 4.0

Dublin, Ohio

Computer Programmer• Designed and developed Silverlight site for loading calling leads into a SQL 2008 database. WCF backend for communicating to SQL and pulling FoxPro 6 database files to the server for bulk loading.• Conversion of FoxPro 6 reporting system to .net 4.0 based solution with MS SQL 2008 on the back end. Includes an asp.net website for generating reports on demand by account managers, a WPF desktop application used by the operations team for generating daily reports and a… Show more Computer Programmer• Designed and developed Silverlight site for loading calling leads into a SQL 2008 database. WCF backend for communicating to SQL and pulling FoxPro 6 database files to the server for bulk loading.• Conversion of FoxPro 6 reporting system to .net 4.0 based solution with MS SQL 2008 on the back end. Includes an asp.net website for generating reports on demand by account managers, a WPF desktop application used by the operations team for generating daily reports and a console application for scripting of automated daily reports.• Development and maintenance of backend tools for supporting a telemarketing system including leads importing, maintaining metadata used for the reporting interface and an internal portal site used by all aspects of the business. Show less

Hilliard, Ohio

• Complete redesign of legacy credit card processing system. The new design consists of a self-hosted WCF service that communicated to multiple credit card processing companies using the ISO 8583 message formatting standard. Written using the latest parallelization features in C# 4.0 so it can handle a large volume of credit card authorizations at once. Java based Point of Sale clients make the calls to the WCF service over an SSL connection.• Successfully implemented a business object… Show more • Complete redesign of legacy credit card processing system. The new design consists of a self-hosted WCF service that communicated to multiple credit card processing companies using the ISO 8583 message formatting standard. Written using the latest parallelization features in C# 4.0 so it can handle a large volume of credit card authorizations at once. Java based Point of Sale clients make the calls to the WCF service over an SSL connection.• Successfully implemented a business object library for use as a framework for all business logic used by the .net team. Handled checking of business rules in a uniform manner. Initially written in C# 2.0 but later converted to 4.0• Designed security framework for use in all company intranet sites. Written in C # 4.0 with a SQL 2005 database for storing of individual asp.net page permissions.• Designed workflow processing application for processing of overnight jobs such as ETL loads, FTPs to 3rd party companies and refreshing of search engine data on company website. Used multiple WCF clients to communicate between servers and update statuses of jobs back to a central WCF client that handled the firing off of jobs and updating of job status back to a ASP.net site used by the operations team • Developed SSIS package for loading service system with products and inventory. Data was pulled from a SQL 2005 database and sent to the service systems proprietary web service via a scripting task.• Maintained ETL SSIS packages that loaded a data warehouse for the BI software Microstrategy. Used a scripting task to pull flat files from a UNIX server over and a ssh connection. Then loaded tables in a SQL 2005 database• Designed and implemented an integration service for the purpose of loading a 3rd party software package for the Service department with the legacy point of sale system. Written in C# 2.0 with a MS SQL 2005 database backend. Application designed using multithreading so that the data load stays near real time. Show less

Columbus, Ohio Area

• Successfully designed and implemented a standalone accounting integration application for multiple clients. Handled exporting GL, AP and AR entries from MS Retail Management System to several accounting packages such as QuickBooks, Peachtree, Great Plains and MAS200. Written in VB.net 2.0 and using 3rd party SDKs for connections to accounting packages.• Integration of Legacy Applications with MS Retail Management System• MS SQL Relational Database Design• Working with new and… Show more • Successfully designed and implemented a standalone accounting integration application for multiple clients. Handled exporting GL, AP and AR entries from MS Retail Management System to several accounting packages such as QuickBooks, Peachtree, Great Plains and MAS200. Written in VB.net 2.0 and using 3rd party SDKs for connections to accounting packages.• Integration of Legacy Applications with MS Retail Management System• MS SQL Relational Database Design• Working with new and upcoming technologies to find solutions for customers• Maintenance of existing applications• Level 3 tech support• System Administration (Windows/Exchange/MS-SQL2000/2005)• Windows Server Deployment• Deployment for MS Retail Management System Show less