Developer - MS SQL Server, ASP.NET

SUMMARY

Web application developer with over ** years of experience in web application and database programming, report development. Working primarily with the Microsoft stack of web application technologies, Asp.Net, MVC, Web API, DotNet 6.0, C#, T-SQL, and JavaScript frameworks, in a broad range of business sectors.

Professional Experience

Programmer Analyst

U.S. District Court – District of Minnesota

May 2022 – present

Support District Court applications and databases

Case Management/Electronic Case Filing (CM/ECF)

Quality Electronic System Testing QC tool

Recusal and conflict checking and reporting

DotNet core MVC Jury selection application

DotNet Core WebAPI Probation reporting app

Perl/HSGS, PHP, Cold Fusion, ASP.NET, ASP Classic

IBM Informix 12.10 database - CM/ECF database

MS SQL Server 2016. 2022, T-SQL

Linux and Windows servers, Apache and IIS

Visual Studio 2022, VS Code, VIM, Git SSMS 2019

Jud Inform Tech Spec IV, ITD

Minnesota Judicial Branch (Fulltime Temporary)

Dec 2020 – May 2022

Development support for Minnesota Court Records Online (MCRO) project. Phase II, and Phase III

Developed stored procedures and functions for Case, Hearing, and Judgment Searches.

Development tools and technologies: Visual Studio 2019, TFS, SSMS, T-SQL.

Contributed to Agile ceremonies, daily standups, grooming, sprint planning, retrospectives, product demos.

Jul 2020 – Dec 2020

Development support for Minnesota Court Records Online (MCRO) project.

Phase I development - UI views, scripts, and controller functions for admin site messaging management.

Development tools and technologies: Visual Studio 2019, TFS, SSMS, .NET Core, C#, Auto-Mapper,

Entity Framework Core, MVC, Partial views, Bootstrap, JavaScript, JSON.

Contributed to Agile ceremonies, daily standups, grooming, sprint planning, retrospectives, product demos.

Programmer/Analyst

Old Republic Title (FTE)

Nov 2018 – May 2020

Supported Agency Database application and reports in title insurance application.

Development of Integration Services package ETL process for financial data.

Enhancements and break-fixes in Reporting Services reports and SQL stored procedures.

Wrote SQL scripts for data migrations, updates, deletion, insertions, and schema updates

Conducted code reviews for in-house and offshore team members.

Contributed to daily standups, sprint planning, grooming, and retrospectives.

Applications developed using Visual Studio versions 2015- 2017, C#, MVC, WCF, jQuery, AngularJS.

TFS source control, Service Now, Octopus manifests, SQL scripts, deployment guides.

Software Developer Specialist

Accenture Mortgage Cadence (FTE)

May 2016 – Feb 2018

Developed enhancements of web-based Loan Origination Software.

Contributed in daily standups, sprint planning, story pointing, grooming, and tasking, sprint retrospectives.

Worked on team implementing a REST API for customer mobile access to loan application data.

Used C# for page class and class library code development, SQL Server 2014 for database development.

Visual Studio 2015 and 2017 for solution management and TFS for source code and task management.

Additional frameworks and technologies used included ASP.NET Web Forms; Web API; ASMX Web services.

Classic ASP; jQuery; JavaScript, CSS; T-SQL; LINQ; Entity Framework; ADO.NET.

VMware workstation on Windows 10 Host; XML; XSLT; CruiseControl.NET; and ReSharper

Distributed Application Developer

Quality Systems Integrators, Inc. (Contractor) - Piper Jaffray

November 2014 – February 2016

Contract role to update ASP.NET Web Form pages, business and data logic, and stored procedures for trade activity pages and reporting to remove Infragistics Web Data Grids and replace with ASP.Net data grid controls.

Re-factored page class methods, implemented class libraries, replaced in-line SQL statements with stored procedures and packages in Oracle 11g, and procedures, and functions in SQL Server 2008R2.

Used C# language, Visual Studio 2012; TFS; SQL Server 2008R2; Oracle 11g; Toad; Transact-SQL and PL/SQL; JavaScript, jQuery and CSS, Beyond Compare.

Developer

Randstad Technologies (Contractor) - Patterson Companies

March 2014 – September 2014

Support and enhance Patterson Companies’ Medical, Dental; and Veterinary supplies ecommerce web sites.

Contributed to daily stand-up; user story reviews; sprint planning and retrospectives.

Used C# for page class and class library code development; Visual Studio 2012 and 2010 for solution management; SQL Server 2008R2 database management; Tortoise SVN/Visual SVN, LINQ-to-SQL queries; MVC; MVP; WCF; ASMX; NUnit unit test framework; Rhino Mocks;

Castle Windsor Dependency Injection; Re-Sharper; JavaScript; jQuery; AJAX; JSON; HTML; CSS; CruiseControl.NET integration; Surround SCM

*Note: Corp-to-Corp support contracts ran concurrently with overlapping time spans.

Web Application Developer

Machine Tool Supply (Corp-to-Corp contract)

December 2013 – January 2014

Converted and updated Machine Tools Supply’s classic ASP site for compliance and hosting in NetSuite® CRM.

Updated web pages and to XHTML standard, added custom login for authenticated user access to NetSuite®

Tools included Visual Studio 2012, IIS 7.5, HTML, CSS, jQuery, jQuery-UI, WS_FTP 12; Net Suite® Cloud ERP.

Web Application Developer

G2 Global Solutions (Corp-to-Corp contract)

October 2013 – March 2014

Supported development of the K-12 Ceramics Exhibition Foundation web site functions including user registration, payment processing, presentation, and reporting.

Implemented features for user interface, business, and data access logic.

Used VBScript for classic asp pages, C# for ASP.NET MVC application; Visual Studio 2012, MVC 4, JavaScript; Knockout JS, jQuery, AJAX; SQL Server 2008R2; LINQ; Entity Framework; ADODB; ADO.NET, Bootstrap; classic ASP; SVN; IIS 7.5; WS_FTP.

Web Application Developer

On Target Professionals (Corp-to-Corp contract)

October 2013 – March 2014

Provided application support and development of stored procedures and functions for logistics application and commissions reporting. Enhanced billing reports, and updated database schema, and stored procedures.

Used classic ASP; VBScript, JavaScript; Visual Studio 2012; Transact-SQL; MS SQL 2008R2; Tortoise SVN; WS_FTP.

Web Application Developer

Castle Software, Inc. (Corp-to-Corp Contract)

Mar 2013 – August 2013

Supported, enhanced, and worked on break-fixes for Castle Online Learning K-12 public schools web application.

Used C#; Visual Studio 2012; ASP.NET 4.5; AJAX, jQuery, JavaScript, LINQ, Entity Framework, LINQ-to-SQL. AJAX, JSON, ASMX web services, SQL 2012 Database, Tortoise SVN code repository.

Developer

Inergize Digital, Inc. (FTE)

Jan 2013 – Feb 2013

Developed enhancements for CMS for National Network News websites, developed xml sports feed processor.

Program enhancements for the Sports Monitor program, News Synergy, and CMS Content Rotator applications.

Performance enhancements for SQL view query definitions and stored procedures.

Assisted with web site deployment using mRemote and ROBO Copy scripts.

Used C# for page class and class library code development; Visual Studio 2010 for solution management.

Used TortoiseHg, VisualHg and Fog Creek Kiln code repository, Hudson build monitor

MS SQL Server 2008R2; MySQL 5.2; Linux; PuTTY SSH Client.

Software Engineer

TEKsystems, Inc. (Contractor) - Amano McGann

June 2012 - November 2012

Developed Web API Web services for automated parking facility ticket dispensers, in-lane and central pay stations, and fee computers, device registration, and heart-beat monitoring.

Used C# for Web API service class and repository development, Visual Studio 2012 for solution management, ASP.NET, MVC 4; MS SQL Server 2008R2, Entity Framework, LINQ-to-Entities for select, update and delete queries, jQuery, JavaScript, JSON, AJAX, WPF, TFS, MS Test.

Application Developer

Mackin Educational Resources (FTE)

March 2007 – May 2012

Assisted in conversion, support and enhancement of K-12 Library book sales and funds management application.

Assisted in the conversion of classic ASP Library management application to ASP.NET.

Created Fundraiser application, CMS, database schema and stored procedures for library book purchase donations.

Created donation reports for the fundraiser website. Implemented Authorize.NET payment gateway.

Developed process for image uploading to hosting site using Cook Computing XML-RPC.

Supported order processing and report development using SpreadsheetGear™.

Used C# for page classes and class library development; ASP.NET Web Forms for page design.

Used Visual Studio 2010 for solution management; MS SQL 2005 for tables, procedures, functions, triggers.

Transact-SQL, LINQ-to-XML; Visual SourceSafe 2005; AJAX for ASMX web services, jQuery, JavaScript.

Intranet Developer, Database Developer

CIBER Government Systems USARC – 88th Regional Support Command

Feb 2000 – AUG 2006

Developed and maintained 88th Regional Support Intranet web site.

Maintained and upgraded SQL Server databases (SQL v7, 2000, 2005).

Developed conference registration system for Bi-annual commanders conferences.

Developed DocuQuest application for submitting document reproduction requests to onsite Xerox print services.

Developed Command ISTS – Involuntary Separation Tracking System.

Developed Script for downloading compressed military pay files from remote servers, extracting and distribution.

Developed script for downloading remote access log files from RAS servers for reporting.

Education

Hennepin Technical College - Computer Integrated Manufacturing (CIM) September 1996 - February 1997

Hennepin Technical College - Electronics Engineering Technology September 1982 - February 1983

Hennepin Technical College - Solid State Circuits I, Logic Circuits I September 1979 - November 1979

Hennepin Technical College - Solid State Circuits II, Logic Circuits II January 1980 - April 1980

Languages, Technologies and Frameworks

C#; .NET Core, MVC; ASP.NET; WCF; Web Forms; Web API; ASMX Web services; Unity DI; Classic ASP

HTML; AJAX; JSON; CSS; Bootstrap; SSL; XML; XLST; JavaScript; VBScript; jQuery

MS SQL Server; DTS; SSIS; Transact-SQL; PL/SQL; LINQ; ADO.NET; ADODB

Entity Framework; Enterprise Library; Authorize.NET; SpreadsheetGear

Visual Studio 2003 - 2019; Visual Interdev 6.0; SQL Server 7.0 - 2016; Oracle 11g; TFS, TortoiseHg; Kiln; SVN

Certifications

Continuing Education Resources

CIW Associate - ID# 0165495

PluralSight.com; w3schools.com

MCP – ID# 1719684

c-sharpcorner.com

dzone.com; stackoverflow.com

Contact this candidate