Ryan Kerschner Email & Phone Number

Cleveland, Ohio, United States

- Implemented the restful ASP.NET service I created for the automation group into a SaaS environment for proof of concept- Helped author an entire SaaS delivery process for the Transportation division using the above concept to help solve a manual process for implementers.- Created and maintained multiple azure resources to help secure the SaaS process (Service Bus, Key Vaults, etc).- Created and distributed work items to fellow co-workers based on the need of the project via JIRA.

- Help develop and maintain a homegrown CI environment- Helped architect and build a Blazor based front end WASM using MudBlazor, and a restful backend to completely replace a PHP website and backend.- Created a JIRA integration within the website to help QA testers report maintenance issues more efficiently.- Created prototype frameworks for both Cypress and Playwright Web UI to show pros and cons of each.- Created a restful ASP.NET Core Web API with OpenAPI spec that acts as a replacement to the current CI environment-based service. The API was designed to run as a service to not be dependent on any web server software\design.- Implemented a docker based container system for automatic setup and teardown of API endpoints for scaled testing.- Created an asp.net electron app as a "helper" for other automation staff and QA staff- Created SQL extended events and triggers to help track fatal events in CI environment- Helped implement another sector of our transportation business within our CI environment to help them meet OKRs.- Integrated postman\newman tests in a CI environment using PHP and generated javascript- Created a PHP html page that can consume reports and display them in an easy to read and viewable way.- Review pull requests from the whole team and help design our framework on a higher level moving forward- Run meetings weekly with the QA staff to help figure out coverage over entire functionality sets within the product base.- Meet with fellow Automation reps to help guide them on how to create our Automation to make it user-friendly and displayable for the QA reps.- Run classes constantly on anything new that we have created or anything new that we are designing to fit into our CI farm.

- Create automated test scripts using Ranorex- Design an Automation Framework using OOPS concept. Attempt to create only re-usable code within the framework,- Develop these test scripts using c# and VB.net.- Ran a class on the basics of CSS- Helped develop our Team's learning website using HTML, CSS, and JAVA- Constantly conduct reviews of code from peers- Helped redesign data creation before every test suite executed.- Work with each respective scrum team to find out best methods of testing for each product base

• Work escalated cases from all of support• Main Tier 3 rep for all web support escalations• Wrote a wcf health test application to test our website based product in C#• Work with custom API’s to invoke Business Logic• Work with IIS to diagnose web issues like re-directs, authentication, etc.• Use XML files through SOAPUI to diagnose customer’s custom API issues• Use WireShark, MNN, or Fidler to find issues with customer’s firewalls to see why API’s may not be available to invoke.• Create diagnostic SQL triggers to find what is causing issues• Debug stored procedures to find where data is skewed.• Constantly work through vb code and C#• Debug the main TMS applications through Visual Studio to find where business logic is broken. • Able to work and diagnose issues with little to no detail• Able to work through large queues efficiently within SLA requirements• Able to write PowerBuilder 'if' functions and Field Level Validations

• Support SQL integrated software for customers• Run basic SQL queries on almost every call• Update views and sometimes stored procedures• Run backups and test issues in house constantly• Answer calls and work on critical cases often.• Work on cases through email as well as through the phones.• Work with IIS and web based applications• Run SQL traces to find out what is causing certain issues.

• Support customers for Nuclear Pharmaceutical ordering, which includes software, hardware, and configurations. • Migrated customers from FTP to SFTP servers for secure transfers of data.• Hardware includes Printers, Scanners, PC’s, etc.• Install and support SQL on customer’s computers to connect to our software• Install new databases on existing setups for customers.• Either setup a local database to one computer, or setup SQL for a server environment and get other PC’s connected• Run Queries to make sure all users are setup correctly within SQL• Setup PC’s to allow for remote support administration• Familiar with WebEx and other remote software’s• Familiar with Service Now for entering tickets• Customized application interfaces for pharmaceutical customers• Support EDI ordering for medical and pharmaceutical customers• Installed software on Citrix servers for shared application binaries• Preformed General Password resets for customers• Receive inbound calls to support the above issues