WORK EXPERIENCE:

Confidential, Kansas City, Mo

Responsibilities:

• Maintained a financial desktop system written originally in VB.NET (2002) and recently converted to VB.NET (2012).
• Worked on an agile development team with the goal of redesigning the existing VB.NET system. This system is being designed using 3 tier architecture in ASP.NET(C# 2013).
• Designed and developed reports using SQL Services Reporting Services.
• Designed and developed installation packages using Installshield.

Confidential, Leawood, Kansas

Developer (C#, ASP.NET, VB.NET, SQL Server

Responsibilities:

• Designed and developed a web site using C# & ASP.NET. Used LINQ functionality to provide database functionality using a backend SQL Server database. Wrote various client side Java scripts.
• Used TFS & Serena VM for source control repository for .NET code.
• Designed and developed an application in .NET to take a stored procedure requisition out of a Microsoft Word document and build a stored procedure.
• Designed and developed functionality for a legacy financial application for the Federal Government.
• Designed and developed an application in .NET to dynamically build a format file based on a pipe delimited file which will then be imported into SQL Server.
• Designed and developed an ETL process using OLEDB for ODBC & SSIS. The data was moved as part of a conversion project from an Informix database to a SQL Server 2005 database.
• Designed and developed numerous SQL Server 2005 stored procedures and user defined functions.
• Designed and developed various VB.NET plug - ins for existing applications.
• Worked on an agile development team with the goal of redesigning the existing VB.NET.

Confidential, Lenexa, Kansas

Programmer/Analyst (c#.NET, VB6, VB.NET, SQL Server)

Responsibilities:

• Developed new functionality for a legacy life insurance application using VB6/SQL Server 2000.
• Converted a web site for our life insurance clients from classic ASP to ASP.NET.
• Developed support tools using VB.NET & SQL Server 2000.
• Developed support tools using C#.NET & SQL Server 2000.
• Developed support tools using ASP.NET & SQL Server 2000
• Developed reports using Crystal 8.5 and Reporting Services 1.0

Confidential, Lenexa, Kansas

Project Leader / DBA (VB 6 & SQL Server 7.0/2000)

Responsibilities:

• I designed and developed a system to handle the companies’ annual bonus system. This application was written in VB6 using a SQL Server 2000 database
• Designed & developed VB & Excel based systems for annual budgeting and forecasting.
• I designed and developed tools used for the companies existing project management system.
• Developed numerous database triggers and stored procedures in support of various projects.
• Designed & Developed numerous Stored Procedures, Triggers & DTS Packages.
• Performed miscellaneous DBA duties.
• Maintained a cost accounting system written in Dexterity
• Developed ActiveX Dll’s in VB 6.0 to be used by MTS/COM+ server.
• Developed ActiveX controls in VB6
• Developed an ActiveX OCX in VB6.
• Developed web pages using HTML & DHTML.
• Developed installation packages using WISE.
• Developed reports using Crystal Reports.

Confidential, Kansas City, Missouri

Database Administrator (SQL Server 6.5 & 7.0)

Responsibilities:

• Performed backup & restore procedures on databases on SQL Server databases
• Built new databases.
• Designed, developed & optimized numerous stored procedures for SQL Server 6.5.
• Handled user security.
• Designed new tables and databases.
• Designed and developed an application in VB 6.0 to handle file distribution.
• Performed various Source Safe administration.
• Designed and developed an application to assist in the process of application distribution. This application was written in VB 6.0.

Confidential, Kansas City, Missouri

Programmer/Analyst

Responsibilities:

• Designed and developed numerous queries and reports for the financial department, the project management department and the marketing department. These queries were written in SQL on a SQL Server platform. The reports were written using Microsoft Access 95
• Designed and developed a query tool for management, which would allow them track expenses. This application was developed in Visual Basic 5.0 & Excel using a SQL Server 6.0 database.
• Created an application that generated a report of any financial records, which were in conflict with internally set rules. This application was used in conjunction with a third party financial package that the company is using.
• Designed and developed an application, which allows users to dynamically, create mailing lists. The application was written in VB5.0 using a combination of MS Outlook and various MAPI API calls.
• Developed several applications, which would allow our financial users to perform functions other than those included in our 3rd party financial package.
• Developed Active-X combo box control using VB5
• Designed and created numerous tables for our SQL Server database. I have also created the required indexes for those tables.
• Created queries to be run against an Oracle database.
• Worked with various API functions.
• Designed and developed an application which loads the results of a SQL Server stored procedure and loads them into an Excel worksheet.
• Designed, developed & optimized numerous stored procedures for a SQL Server database.

Confidential, Overland Park, Kansas

Programmer/Analyst

Responsibilities:

• Designed, developed, and maintained printer drivers for the VAX using Fortran.
• Designed, developed and maintained modules for a computer cost accounting system. These modules were written in a combination of COBOL & FORTRAN.
• Converted a computer inventory system from Clipper to VB3.0 using an Ingres database.
• Developed and maintained several Ingres forms and modules for the project management system.
• Designed and developed Ingres forms and modules for a custom system which was related to a contract with the Environmental Protection Agency.
• Was responsible for maintaining the company’s custom plotter drivers.