Sql Server C# .NET

Skip is a Senior Developer, with over ** years of experience, in the design and development of web applications. He is a versatile software development professional, adept at leveraging Web/intranet, client/server, and N-Tier architecture technologies to produce high-quality products and systems for customers in variety of industries. He prides himself on his leadership ability and process efficiency, through mentoring junior developers. Skip’s solid understanding and experience with .NET, C#, MVC, jQuery, SQL Server, and LINQ to SQL, contribute to his adaptability as a Senior Developer.

TECHNICAL SKILLS

C#, .NET Core 8, ASP.NET, MVC, AJAX, Web Services, JSON, OOD, MS SQL Server 2000-2019, MS Entity Framework, LINQ to SQL, SQL Stored Procedures, Triggers, JavaScript, jQuery, AngularJS, Bootstrap CSS, HTML, CSS, ADO.NET, VB.NET, PDQ Data, PDQ MVC, XML, XSLT, SSRS, SSIS, Oracle PL-SQL, IIS 5.0, 7.0, MS Visual Studio 2003-2022, Crystal Reports 11, WPF, WCF

EDUCATION/CERTIFICATIONS

University of Missouri, Columbia

●Bachelor of Science in Electrical Engineering

PROFESSIONAL EXPERIENCE

Washington University in St. Louis (WashU)

April 2023 - current

Applications Developer

WashU is a private research facility with around 16 thousand students. With technology changing so quickly, WashU has engaged in an aggressive move to upgrade their technology and its applications to continue providing research and education.

Environment: Visual Studio 2022 ASP.NET Core 6-8, REST APIs,.NET Framework, C#, GIT (GitHub), Blazor, MS SQL Server 2016, Entity Framework, TSQL, Views, Stored Procedures, Triggers

●Primary responsibility is creating ETL applications, internally named DRA, an acronym for Data-Relay-Application, to assist in required data-processing and data-movement.

While there, I developed the following:

●a web PowerFAIDS Admin app, using .NET Core 8, SQL Server for the back-end, and MS Blazor for the front end, and Web API for access.

●multiple SQL scripts for testing the results of the DRA processing

●Test Plans and other supporting documentation for creating, testing, and deployment prep

●Jira was used for tracking work, and Confluence was the primary document source.

●Helped move the team to more functional coding.

Great Plains Lab

February 2021 - February 2023

Applications Developer

GPL is a pharmaceutical laboratory, testing for wellness and disease, as well as employment screening.

Environment: Visual Studio 2022, 2019, 2017, 2015, ASP.NET, C#, TFS (GIT flavor), ASP.NET Core 5-7, .NET Framework, MS SQL Server 2008-2016, Entity Framework, TSQL, Views, Stored Procedures, Triggers

●My primary responsibility was to enhance/maintain their customer website (in .Net 4.7 and web forms, then later upgraded to .NET 7 and Blazor).

While there, I developed the following:

●a Web API using .NET Core 5 (since upgraded to 7), to replace the previous WCF web service for all of our applications’ data access.

●a payment client with Stripe payment provider, to handle all payments from customers

●a payment client using .NET 5 for Waystar payment provider, to replace Stripe

●a Web API using .NET Core 7 for handling payments from all of our applications, using the client created for Waystar provider

●several SQL server scripts to handle various processing tasks.

●a chat application, using .NET Core 7 Blazor Server, for our customer service to use with customers

Riverpoint

March 2020 - June 2020

Applications Developer

On contract to Symplr, which provides services for clients to better manage provider data, credentialing services, patient safety, workforce management and vendor management. My time here assists their backlog of work while they navigate new concerns related to the coronavirus pandemic.

Environment: Visual Studio 2019, 2017, 2015, ASP.NET, C#, .NET Framework, MS SQL Server 2008-2016, Entity Framework, TSQL, Views, Stored Procedures, Triggers

●Primary responsibility is creating custom imports and business rules for clients into their proprietary “Cactus” app.

NIC

August 2019 - November 2019

Web Developer

NIC is the originator of a transaction-based approach to delivering digital government services; primarily charging a fee per transaction, leaving the government entity a no-cost solution for providing services to the community, while providing a convenience to the customer that chooses one of these options.

Environment: Visual Studio 2019, ASP.NET, C#, GIT (GitHub), Entity Code First, ASP.NET Core, .NET Standard, PostgreSQL, MS SQL Server 2008-2016, Entity Framework

●Primary responsibility is working on a team to deliver an enterprise MVC application for primarily State-level DNR(“Department of Natural Resources” and similar) solution to administer their services.

DXC

November 2017 - August 2019

Applications Developer

DXC Technology is the world’s leading independent, comprehensive IT services company, helping clients harness the power of innovation to thrive on change. The group I am in designs and supports software for our customers (our customers are State entities; North Carolina, Virginia, West Virginia, Washington, Rhode Island) administrations of their WIC and SNAP programs and related services.

Environment: Visual Studio 2017, ASP.NET, ADO.NET, VB.NET, WPF, WCF, OOD,

TFS for source-control, N-Tier Architecture, MS SQL Server 2008-2016,

Entity Framework, TSQL, Views, Stored Procedures, Triggers

●Support/maintain existing application functionality that helps facilitate several state WIC programs

●Providing enhancements to improve application functionality.

●Incorporate HIPAA X12 standards for data exchange between entities and third parties

●Integrating our base software to new customers and their specific needs.

National Flood Services

September 2016 – September 2017

Web Developer

NFS specializes in flood insurance administration. They assist flood insurance providers (All State, FEMA, etc.) with implementation and management of benefit programs.

Environment: Visual Studio 2015, ASP.NET, ADO.NET, Oracle SQL, C#.NET, HTML5,

CSS3 and Bootstrap, VB6, AngularJS 1.6, OOD N-Tier Architecture,

AJAX, JSON, JavaScript, jQuery 3.1, RESTful web services

●Converted legacy ASP and VB6 application to ASP.NET MVC, utilizing C# and AngularJS with an Oracle datastore.

●Assisted the development team in learning to maintain and develop applications in MVC and AngularJS.

●Created a .NET Web API to communicate with 3rd party vendors.

GBW Rail Services

May 2015 - August 2016

Applications Developer

GBW is a joint venture between Greenbriar and Watco, both with large presence in the US Rail industry. They provide maintenance, inspections, and certifications of operating rail cars..

Environment: Visual Studio 2013/2015, SQL Server 2014, ASP.NET Web Services, TFS,

SQL Stored Procedures, Entity Framework, TSQL, Views, Triggers, HTML/CSS,

ASP.NET, C#, .NET, AngularJS, OOD, N-Tier Architecture, JavaScript,

Bootstrap CSS, IIS 7.0, AJAX/JSON, ADO.NET

●Primary support for internal web application that supports arrivals, inspections, work orders, estimating, and billing; as well as coordinating with AR/AP software, and multiple third party vendors.

●Architected and created a Reconciliation web application for the Accounts Payable department, using Angular front end, in a C# MVC application using Entity against a MS SQL database.

Faith Technologies

April 2014 - May 2015

Applications Developer

Faith Technologies is the 19th largest electrical and specialty contracting firm in the US. They provide Automation and Process Controls, Design-Build, Electrical Risk Management, Energy Efficiency Auditing, Pre-construction, and Telecommunications/Wireless.

Environment: Visual Studio 2010, SQL Server 2005, ASP.NET Web Services, SQL Stored Procedures,

HTML/CSS, ASP.NET, C#, TFS, .NET, AngularJS, OOD, N-Tier Architecture, JavaScript,

jQuery, Bootstrap CSS, IIS 7.0, AJAX/JSON, ADO.NET

●Primary support for internal Purchase Order web application.

●Wrote and supported a Windows service used by HR for new applicants.

●Support all existing Crystal Reports and responsible for new reports.

FMH CoreSource

May 2013 – March 2014

Applications Developer/Consultant

CoreSource specializes in personal employee benefits administration. They assist employers with implementation and management of benefit programs. Their primary goal is to continually develop and refine our process to assure satisfaction and ease of use.

Environment: Visual Studio 2012, SQL Server 2012, MS Entity Framework, TSQL, Views, Stored Procedures, Triggers, C#, .NET, HTML/CSS, OOD N-Tier Architecture, AJAX, JSON, ADO.NET, JavaScript, jQuery, IIS 7.0

●Built reports based on requirements of business agents using SQL Server.

●Assisted .NET Development team in problem resolution when necessary.

●Educated team members on proper use of Link to SQL.

●Educated and assisted team members with TSQL dynamic queries.

HCA Healthcare

March 2013 – May 2013

Web Developer/Consultant

HCA is the nation's leading provider of healthcare services, a company comprised of locally managed facilities that includes about 165 hospitals and 115 freestanding surgery centers in 20 states and England and employing approximately 204,000 people.

Environment: Visual Studio 2012, SQL Server 2012, Stored Procedures, Views, MS Entity Framework,

C#, .NET, HTML/CSS, ASP.NET, OOD N-Tier Architecture, AJAX, JSON, ADO.NET,

JavaScript, jQuery, IIS 7.0

●Built an intranet website for the Neurology Department for data-gathering and reporting.

●This allowed the Department to track procedures and outcomes for patient care.

Cyberclick Marketing

September 2012 – January 2013

Applications Developer

Cyberclick markets the Payday Loan industry by generating leads, re-selling or purchasing leads, and supplying loans.

Environment: Visual Studio 2010, SQL Server 2008, ASP.NET Web Services, SQL Stored Procedures

HTML/CSS, ASP.NET, C#, .NET, PDQ Data, OOD, N-Tier Architecture, PDQ MVC, XML,

XSLT, IIS 7.0, JavaScript, jQuery, ADO.NET, AJAX, JSON

●Supported the online presence of Cyberclick’s activities.

●Responsible for the set-up new partner websites.

●Responsible for the set-up new partner web services.

●Fixed issues.

●Addressed bugs found by customers.

●Investigated solution to avoid duplicate applications.

●Increased functionality of existing products.

●Enhanced client-side validation on pages lacking.

●Improved visual interaction during customer post-back.

●Received Orchard CMS exposure in this role.

Penton Business Media

February 2007 – September 2012

Applications Developer

Penton Media, Inc. is a publisher of authoritative trade magazines, producer of trade show/conference events, provider of electronic media and communication tools, a source for direct mail lists and research services, and creators of custom publications.

Environment: Visual Studio 2005/2008/2010, MS SQL Server 2005, MS LINQ to SQL, SQL Stored

Procedures, Triggers, Stored Procedures, Views, ASP.NET Entity Framework, VB.NET,

SP.NET, MVC, Web Services, AJAX, C#, .NET, HTML/CSS, SSRS, SSIS,

Oracle PL-SQL, N-Tier Architecture, OOD, JavaScript, jQuery, Automate 7.1, ADO.NET

●Maintained and enhanced existing public websites, and development of new websites and web services.

●Promoted in 2009 to Enterprise Business Integration Developer, within the IT department.

●Built an internal website in C# for the Production Department, integrating third-party software into the workflow.

●Fully utilized LINQ-to-SQL for data modeling and SQL queries.

●Utilized AJAX to enhance the user experience.

●Built a custom Content Management System for our external products, using C#.NET, Entity Framework and SQL Server.

●This CMS allowed editors to control their static content.

Cornerstones of Care

March 2006 – February 2007

Applications Developer

Cornerstones of Care is an organization that provides therapeutic treatment services for children and families.

Environment: Visual Studio 2003/2005, SQL Server 2000/2005, SQL Stored Procedures, SQL Cursors, Triggers,

Transactions, C#, .NET, HTML/CSS, JavaScript, ASP.NET, AJAX, OOD, N-Tier Architecture,

VB Script, C# Script, ADO.NET, IIS 5.0, Crystal Reports 11

●Built a web application from scratch for the Human Resources Department.

●Used C#.NET and ASP.NET in a Visual Studio 2005 environment (2.0 framework).

●Used SQL Server 2005 Express for the database.

●Responsible for troubleshooting, fixing, and enhancing an existing web application called ManageCare.

●ManageCare was written in C# and ASP.NET, in a Visual Studio 2003 environment (1.1 framework).

●Used the SQL Server 2000 database.

●ManageCare application is used by approximately 30 people in the company, and upwards of 500 service and placement providers.

Contact this candidate