Anthony Kress

ad22i4@r.postjobfree.com

715-***-****

Summary

30+ years of IT experience which includes over 20 years of experience in Development and Design experience with MS SQL Servers 2019, 2017, 2016, 2012, 2008, 2005, 2000 and 7.0 in Production, QA, and Development environments.

17 plus years of Web development using a variety of environments,

19 plus years in ASAP .NET environment.

Extensive Knowledge of Ajax, HTML, XML, JSON, jQuery, JavaScript, and VB Script.

27 years of Client/Server development using a variety of environments.

Extensive knowledge of C#, Visual Basic in .NET environment.

Overall database design, such as creating normalized databases, tune queries, assigning proper indexes, creation of triggers and stored procedures.

Flexible and versatile to adapt to any new environment and work on multiple projects.

Excellent knowledge in RDBMS concepts and constructs.

Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS and SSIS Packages, Integration using .NET Bulk Copy

Experience in working with version controlling tools for managing SQL scripts and changes that are going to production. Github, Bitbucket, Microsoft Team Foundation Server (TFS), Visual Source Safe, TOAD

Transformed data from one server to other servers using Bulk Copy Program (BCP) and Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Extensive knowledge of Relational Database Management Systems.

Expertise in planning and implementing MS SQL server security and database permissions.

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity.

Hands on experience in trouble shooting database issues.

Experience in writing and debugging stored procedures and triggers.

Extensive knowledge in Data Modeling using ERWIN and TOAD tools and normalization of tables.

Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.

Experience in working with Reporting tools like SQL Server Reporting Services (SSRS), Crystal Reports, Microsoft Access

Good team player, strong interpersonal and communication skills combined with self-motivation, initiative, and the ability to think outside the box.

.

Technical Skills

Operating Systems Microsoft Window NT, 2000, 2003, XP, Vista, Windows 7, Windows 10

Languages C#, VB.NET, Visual Basic 3.0 – 6.0, C++, XML, T-SQL, JavaScript, VB Scripts, Pascal, COBOL

RDBMS MS SQL Server 6.5 – 2019, Sybase 10, 11, 12, MS-Access, MYSQL

Front End .NET 2003-2022, MS Visual Basic, Dreamweaver, Delphi

Internet Technologies Ajax, ASP, ASP.NET, JavaScript, JQuery, VB Script, HTML, XHTML

Version Control Tools Visual Source Safe, Microsoft Team Foundation Source Control, Toad, GitHub/Bitbucket, Vault Professional Source Control

Other Tools ERWIN & Toad Data Modeling, Crystal Reports, SQL Backup, Infragistics grids (client server and web)

Hardware Microsoft Environment

SQL Server Tools Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS, SSIS), Reporting (SSRS), Visio, Database Connectivity

Specialty Trizetto Facets

Work Experience

Atticus Administration – Remote Oct 2023 – Dec 2023

SQL Server Developer/Consultant, VB.Net Developer

Responsibilities:

Enhancement and maintenance of two existing VB.Net applications.

SQL Server development (queries, stored procedures, tables) and performance tuning for the above applications.

Environment: Windows 10, MS SQL 2019, .Net 2017, Vault Professional Source Control

Boston Scientific– Remote Apr 2022 – Sep 2023

SQL Server Developer/Consultant, .Net Developer

Responsibilities:

Project to support database to send information to EUDAMED (European Union) database for medical devices.

Enhancement to existing .Net Visual Basic application for building and approving data to be sent out.

Creation of multiple XSD validated XMLs to be sent out via machine to machine process.

Development of SQL Server process to send these XMLs to EUDAMED using machine to machine process using Bizmanager/Soap protocol.

SQL process to interpret response XMLs and update database accordingly.

Environment: Windows 10, MS SQL 2019, .Net 2022, Github/Bitbucket, Azure, Bizmanager/Soap

Department of Veterans Affairs – Remote Aug 2021 – Mar 2022

SQL Server Developer/Consultant

Responsibilities:

Modifications and enhancements to existing EDI processes.

Design of SQL Database and tables, stored procedures, and function to support above processes.

Work with team on creation and implantation of new financial database. Work to include table design, stored procedures, functions, and other database objects.

Environment: Windows 10, MS SQL 2017, Github, Azure

CIM Software Corporation – Remote Mar 2021 – Aug 2021

SQL Server Developer/Consultant

Responsibilities:

ETL processes to import multiple files into SQL Server with subsequent reporting.

Design of SQL Database and tables, stored procedures, and function to support data imports.

Complex data transformations for imports.

Excel (VBA for Applications) for series of reports to view data created.

Environment: Windows 10, MS SQL 2014, MS SQL SSIS, .NET Data Tools 2013, Microsoft Excel

Molina Healthcare – Remote Jun 2020 – Oct 2020

Sr. .Net/SQL Server Developer/Consultant

Responsibilities:

Work with existing applications to enhance/modify SQL code.

Additions to existing SSIS packages

Creation of multiple stored procedures and tables

Creation of new SSIS package and procedures for cross server movement and manipulation of data

Maintenance on existing c# code for security changes.

Environment: Windows 10, MS SQL 2017, MS SQL SSIS, .Net 2017, Azure.

Long Term Care Group - Remote Nov 2019 – April 2020

Sr. SQL Server Developer/Consultant

Responsibilities:

Work with enhancement of existing stored procedures

Creation of new stored procedures

Unit Testing of all new/updated processes

Environment: Windows 10, MS SQL Server 2016, Microsoft Unit Testing.

Wells Fargo – Remote May 2019 – Sep 2019

Sr. Developer/Consultant

Responsibilities:

Senior Analyst/Developer

Programming for maintenance/enhancement of 3rd party software (includes SQL Server work)

C# and SQL Server development for new application.

Environment; Windows 10, SQL Server 2016, .Net 2015

Medtronic – Mounds View, MN Jan 2018 – Oct 2018

Sr. Developer/Consultant

Responsibilities:

Senior Analyst/Developer

Program built around C# object-oriented design features. Forms included MDI parent window, 10 MDI child forms, and 20 misc. support to update existing Powerbuilder/SQL Anywhere MDI application to C# (2015-4.6.2)/SQL Server 2016

orms

Additional enhancements included building of C# interactive (CSI) user interface.

Extensive use of C# screen to screen drag and drop functionality.

Backend database work involved modeling of additional tables and 60-70 stored procedures for action queries.

Web Services/SOAP for some database transfer.

Reporting using MS SQL Server Reporting Services (local) and Built-in C# classes for Excel.

Environment: Windows 10, MS SQL Server 2016, MS SQL Server SSRS Reporting Services, .NET 2015 (4.6.2), Microsoft Access, Tortoise Source Code Management

US Bank - Minneapolis, MN Aug 2016 – Nov 2017

Sr. Developer/Consultant

Responsibilities:

Senior Analyst – Corporate Treasury Systems

Work with support staff in a variety of issues including maintenance and development of 10 .Net Client Server Windows Forms applications (C# and VB.Net)

Worked with a variety of SQL Server issues including design of new tables, creation and enhancement of stored procedures (including testing), views, logins, users, and roles

Extensive creation and enhancement of data migration using Microsoft SQL Server Integration Services (SSIS)

Enhancement of existing reports using Microsoft SQL Server Reporting Services (SSRS)

Maintenance of 5 Microsoft Access applications

Environment: Windows 7, Windows 10, MS SQL Server 2008 & 2012, .NET 2008 - 2015, .NET 3.5 – 4.7 environment (C# and VB.NET), Microsoft Access 2010 – 2015, TFS Source Code Management

US Bank - St. Paul, MN Mar 2016 – June 2016

Sr. Developer/Consultant

Responsibilities:

Worked with documentation of 9 C#/ASP.NET web applications in anticipation of major rewrites.

Work included giving recommendations as to possible enhancements for the new applications

Environment: Windows 7, MS SQL Server 2008 & 2012, .NET 2008 - 2015, .NET 3.5 (C# and VB.NET), Microsoft Access 2010

MorphoTrust USA - Bloomington, MN May 2015 – Dec 2015

.NET Developer/Consultant

Responsibilities:

C# support development for several existing biometric applications incorporated into .NET Client Server applications

Development of custom Client Server software for analysis of user ids (Drivers licenses, Passport, etc)

Environment: Windows 7, .NET 2012, .NET 3.5 – 4.0 (C#), TOAD Source Code Management

Wells Fargo - St Louis Park, MN Nov 2014 – Feb 2015

Developer/Consultant

Responsibilities:

Assigned to contract for codind testing support of data center migration. The contract was originally scheduled for 12 month minimum.

Contract afforded me the opportunity to acquaint myself with MVC pattern and Bootstrap.

Due to budgetary issues, project and contract were cancelled.

MCG Consulting Group - Minneapolis, MN July 2010 – June 2014

.NET Developer

Responsibilities:

Redesign of client web application to manage credentialing of energy system operator, including maintenance of provider courses and operator transcripts. Application was developed in .NET 2010 C# 3.5 framework with asp.NET, Microsoft AJAX and JavaScript/JQuery with Microsoft SQL Server backend. Web application made extensive use of user control design technique. Clustered environment.

Development of new software to manage marketing of energy across the Energy Grid.

Enhancement and maintenance of current Energy Accounting System per customer needs (Client Server Windows application).

Enhancement and maintenance of current Control Area Scheduling System (Client Server Windows application) per customer needs

Custom reporting using Microsoft SSRS reporting and Crystal reports.

ETL data transformations using Microsoft SSIS packages and SQ: jobs.

Environment: Windows XP, Windows 7, MS SQL Server 2008 & 2005, T-SQL, C#, Custom built frameworks. .NET 2010 with 3.5 environment

Harmon Solutions Group – Eau Claire, WI Nov 2005 – July 2010

.NET Programmer/Analyst, Web Development

Responsibilities:

Design and development of various Client/Server and Web Applications for call center (property and auto glass).

Work included several custom web interfaces (ASP.NET and C#. NET). All applications were designed using object-oriented design and incorporated a large variety of the C# classes, as well as JavaScript for web pages. Application work included database design (modeling, stored procedures, testing, Microsoft SQL Server). JavaScript and style sheets.

Custom DTS & SSIS Packages and batch processes.

Interface structures for client/server to Unisys mainframe.

Design and Development of custom on-line customer billing application (C# .NET 2005, SQL Server 2000)

Design and development of Ecommerce web site. Tools included C#, ASP.NET and Microsoft SQL Server. Extensive use of JavaScript and style sheets.

Conversion of Applications .NET 2003 to .NET 2005

Currently updating applications to .NET 2008

Environment: Windows XP, MS SQL Server 2008 & 2005, C#, ASP.NET.

Amerigroup, Virginia Beach, VA Jan 2007 – Apr 2007

Developer/Consultant

Responsibilities:

Conversion of Microsoft Access database to SQL server stored procedures and database. DTS packages uses to extract data from a variety of sources.

Process to merge data from a variety of sources (SQL, Oracle, Excel) into a single user SQL Server database using a combination of DTS packages and stored procedures

Performance tuning for existing stored procedures.

Environment: MS SQL Server 2005, Windows XP.

Marshall & Swift/Boeck - New Berlin, WI June 2005 – Sep 2005

Developer/Consultant

Responsibilities:

Microsoft SQL Server Development to enhance existing Property and Casualty insurance program (web app C#).

Task involved the addition of new stored procedures as well as changes to existing procedures to move from single user to multi-user environment. In addition, many other enhancements were added to the program, requiring updated or new stored procedures.

Environment: MS SQL Server 2005, .NET 2005

Professional Inventor Alliance - Washington DC Mar 2005 – Sep 2005

Developer/Consultant

Responsibilities:

Telecommuting position - design and implementation of custom Web application using EZPublish web content management system. (Partial overlap with M&S/B Project). PHP and MYSQL database.

Environment: Windows, SQL Server 2005.

Fort McCoy – Sparta, WI Aug 2004 – Mar 2005

Developer/Consultant

Development of specialized database for incoming Army Reserve and National Guard Units.

Process required design and development of SQL Server database with approximately 50 tables and 70 stored procedures.

Design and implementation of Web interface, using ASP pages, with extensive use of VB Scripting and Dynamic HTML.

Reporting capabilities were included.

Environment: SQL Server 2000, Visual Basic.

Davis Audio-Visual, Denver, CO Feb 2004 – July 2005

Consultant (telecommute)

Responsibilities:

Telecommuting position - Access development. Position required updates to existing Microsoft Access program, including enhancements to existing screens and reports, as well as development of new screens and reports.

Position required additional work done on the back-end Access database including additional fields and new tables

Environment: Windows, Access.

Providence Healthcare - Portland OR Jan 2003 – June 2003

Developer/Consultant (telecommute)

Responsibilities:

Development of SQL Server backend stored procedures to service Crystal reports Facets reporting data warehouse.

Project involved mainframe conversion to Facets Client-Server involving approximately 120 reports and stored procedures.

Work was performed completely telecommute via a VPN connection (Virtual Private Network) to the client-site.

Creation of user-defined data types and functions. Stored procedure tuning (speed & indexing) was the responsibility of the programmers.

Millennium Marketing - Overland Park, KS June 2002 – Sep 2003

Consultant/DBA

Responsibilities:

Design and development of custom database, including specifications and data modeling, SQL Server 2000, along with VB 6.0 front-end for access and edit of data. Database comprised of 160+ tables and 200+ stored procedures, and user-defined functions. Worked also included design of reports (VB Print object and Microsoft Access) and custom letters (Microsoft Word and Access). As the sole programmer on-site, work also included DBA role, including stored procedure tuning, table indexing, triggers, database backups, DTS and Job Scheduling packages

Custom applications to gather information from United States Patent Office web site, in order to develop company database for marketing.

Environment: SQL Server 2000, Windows.

Blue Cross/Blue Shield of Kansas City - Kansas City MO Aug 2001 – June 2002

Consultant/Programmer

Responsibilities:

Development of additional batch processes to work done in prior consulting role at the company. Additions included the auto loading of benefit and provider rows to Facets proprietary database. Process included the full analysis, table design and data modeling (indexes, foreign key and triggers), development, all stored procedures, as well as enhancement of previous Visual Basic front-end application to handle maintenance of the auto loads. Work required extensive knowledge of both the benefit and provider subsystems within facets. Work included the communication with front-end users

Worked with internal employees in a consulting role relative to issues on stored procedure implementation (query analysis, writing, and tuning for performance).

Environment: SQL Server 2000, Visual Basic 6.0.

Armed Forces Insurance - Leavenworth KS Aug 2001 – June 2002

SQL Developer/Consultant

Responsibilities:

Backend database work in Microsoft SQL Server 7.0 to support Multi-Tier, OOP Visual Basic application used in conjunction with larger system-wide application. Work involved design of relational database, including approximately 150 tables, user-defined data types and functions, using Erwin database modeler, coding of 200+ stored procedures, including several batch processes to handle conversion of information from file to database tables. Project also included automated processes, using SQL Server Job Scheduler, through system-stored procedures. Process included extensive work with company DBA.

Environment: SQL Server 7.0, Visual Basic.

Intertec Publishing - Overland Park, KS Nov 2000 – Apr 2001

Developer/Consultant

Responsibilities:

The conversion of Microsoft Access databases into a single SQL server 2000 database. Redesigned Access databases as interim step. Process involved development of database tables to handle a variety of topic matter covering 60+ magazines, in addition to a Visual Basic front end for data access/ input, and all stored procedures for data access and update. Program used ADO data access and stored procedures exclusively for access to the database (20 screens).

Environment: SQL Server 2000, Visual Basic, Access.

Traders Insurance - Kansas City, MO Aug 2000 – Nov 2000

Developer/Consultant

Responsibilities:

The Design and development of Visual Basic application to handle a variety of inquiries for Automobile insurance company, against NT SQL Server database. Process included design and development of VB front-end application, using ADO data access, and extensive use of Microsoft flex-grid control, and writing of all stored procedures against existing database. Process included some refinement to back-end database to support front-end application,

Design and Development of a variety of Company reports using both Crystal Reports and Visual Basic Print object. Work involved conversion of data and front end application from Fox Pro program.

Environment: SQL Server 2000, Visual Basic.

Blue Cross/Blue Shield of Kansas City - Kansas City MO Jun 1998 – Jul 2000

Consultant/Programmer

Responsibilities:

Design and development of broker commission batch process to replace Legacy system program. Extensive work on developing data model in conjunction with data analyst and DBA. Process included the addition of 30+ tables and stored procedures to handle the batch processes.

Design and development of VB 6.0 front-end application to handle specific Blue-Cross data relative to the above process. Included table design, stored procedure analysis and writing, and ADO database access for the front-end.

Design and development of VB 6.0 front-end application to handle specific Blue-Cross data relative to the above process. Included table design, stored procedure analysis and writing, and ADO database access for the front-end. Life Cycle (design, development, and implementation) Visual Basic program to allow broker and provider access to database information. (Group, claim, membership, and provider) used with Citrix remote access. Visual Basic 6.0, ADO data access, TrueGrid data control (18 screens). Design of back-end database structures. Sybase stored procedures used in conjunction with Internet access.

Sybase stored procedures used with system-wide phone inquiry system.

Developed stored procedures used with company batch processes, including commission, customer explanation of benefits, provider remits reports, provider capitation, claims, subscribers and membership, membership benefit, product plan, customer service, and utilization management for Facets proprietary database. Process required modeling of new database (tables, indexes, foreign keys, triggers etc.)

Designed and developed, in conjunction with Business analysts, DBAs, and end-users, custom batch processes to auto load benefit and provider rows to Facets database. Process included the design and development of new database, database tables and stored procedures, as well as Visual Basic front-end application to handle maintenance of the auto loads. Task included 5 provider batches (network, out-of network, and covering provider, provider groups, and capitation) and 4 benefit batches (products, limits, variable components, and service prefixes)..

Work with internal employees in a consulting role relative to issues on stored procedure (query analysis, writing, and tuning for performance).

The contract allowed for extensive use of tables across a variety of Facets subsystems, including the XP database, claims, customer service, finance, commission, benefit, providers, subscribers, and members.

Environment: SQL Server 7.0, 2000, Visual Basic 6.0.

Educational Qualifications

Computer Science - University of Wisconsin – Lacrosse

University of Wisconsin – Oshkosh

Drake University – Des Moines, Iowa

Contact this candidate