Sql Server Manager .Net Analyst Data Service Development

Kent S. Swenson

*** ****** ** ? Omaha, NE ***** ? 402-***-**** ? ****.*******@***.***

Summary

An experienced IT Analyst with over 14 years in the field. Works well in a

team environment with account managers, clients and other programmers to

ensure smooth startups of client promotions and ongoing support of reports.

Proven track record of increasing responsibility on detail-oriented tasks.

Demonstrated ability to work independently and complete tasks in a timely

manner. Good oral and written skills. Quickly learns and adapts to new

software programs.

Work History

December 1994 - January 2009 West Corporation

Production Support Programmer Analyst II May 1998 - January 2009

. Developed and tested stored procedures written in MS SQL 2005 and data

gathered from relational data bases.

. Developed, tested and documented reports for internal and client use

using MS Reporting Services (SSRS) and the stored procedures listed

above.

. Reports were analyzed with ad hoc queries to verify accuracy of data.

. Analyzed and loaded client supplied data files into SQL Server tables

using DTS packages in MS SQL 2000 or SSIS packages in MS SQL 2005.

Most times the data needed to be parsed, delimited or otherwise

separated before loading.

. Worked with existing programs to create new VB.Net web services.

These services allowed a client, on the other side of our corporate

firewall, to write data to our internal database for use in a daily

report. The service would then confirm receipt of the transmission.

. Created in house VB.Net web pages for data entry and retrieval from

local databases. This allowed us to upgrade from a manual table

housed on the mainframe to a dynamic table housed on an SQL server.

. Developed and maintained reporting programs written in COBOL.

. Developed and maintained encryption programs written in COBOL.

. Monitored and corrected incidents during nightly cycle processing.

. Met with end users to determine the project scope, providing technical

support and instruction throughout project stages.

. Assisted with other teams' tasks when time permitted.

IS Manager May 1997 - May 1998

. Managed the activities of assigned technical staff and delegated

tasks.

. Partnered with other divisions to develop processes, programs and/or

systems that are aligned with business needs.

. Participated in researching new products and development tools.

. Provided quality customer and client service by overseeing all

activities of staff.

IS Analyst I December 1994 - May 1997

. Oversaw the development, implementation, and maintenance of online and

batch programs.

. Implemented solutions to client-specific reporting requirements.

. Coded and tested in-house programming applications written in COBOL.

. Trained and mentored new employees in the use of proprietary

applications.

Education

University of Nebraska Kearney

Sioux Falls University

Institute of Computer Science

Metropolitan Community College

. Included course work in computer logic, Visual Basic, and software

development.

. Currently enrolled in a VB.net 2008 class developing applications.

Projects include tying an application to a database, displaying parts

of the database, and updating the database.

Other Information

Proficient in Microsoft Office Suite, Non-Stop SQL, SQL Server 2000 and

2005, MS-DOS, COBOL, TACL, Aware Reporting and MS Reporting Services 2000

and 2005 on Windows Operating Systems and Tandem mainframe.

Coded using COBOL, VBscript, VB.NET and HTML languages.

Completed Microsoft Approved course on Microsoft VB.net.

Contact this candidate