Sql Server Quality Assurance

Andrew Sehr

**** ***** **. ************, ** ***60 . 317-***-**** . ******@*****.***

OBJECTIVE

To obtain a position where the company can use my knowledge in networking

and application development to make an easier transition to new technology

EDUCATION

ITT Technical Institute Greenwood, IN March 2007 - March 2009

Associate of Applied Science in Computer Network Systems

Pursuing B.S. in Information System Security.

SKILLS

MS-DOS, and Microsoft Office 97/2000/XP/2003/2007

PC setup and installation, as well as various peripherals, data entry, and

file updating

Provide end-user technical support

Quality Assurance/Quality Control

System-operations training and collections

Mac OS X and functionality

Program with SUSE/Red Hat/Fedora Linux both GUI and terminal based

Writing Oracle Forms and Reports from scratch

Mainframe to Oracle migration tactics

Write using C++, Visual Basic, C#, and SQL programming languages

Microsoft Windows 95/98/98SE/ME/2000/XP/Vista/7

Communicate with PC manufacturers concerning parts, warranty and technical

questions

Database desgin and implementation

WORK EXPERIENCE

TeleservicesDirect Indianapolis, IN

Application Developer/Database Analyst August 2010 - October 2010

. Develop Applications using C#

. Crafted tables to work with C#

. Wrote scripts for data conversion from old systems to new systems in

SQL Server 2008

. Created stored procedures in SQL Server 2008

. Made logging tables to track database conversion statuses in SQL

Server 2008

. Created views to use with Linked Servers

State of Indiana, Judicial Technology and Automation Committee

Indianapolis, IN

Application Developer/Analyst September 2009 - August 2010

. Develop Applications using C#, ASP.NET, and Javascript

. Crafted tables to work with C# and ASP.NET Applications

. Wrote scripts for data conversion from old systems to new systems in

SQL Server 2008

. Created stored procedures in SQL Server 2008

. Made logging tables to track database conversion statuses in SQL

Server 2008

. Created views to use with Linked Servers

State of Indiana, Department of Corretion Indianapolis, IN

Intermediate Developer December 2007 - September 2009

Creating, Maintaining, and documenting oracle forms and reports

Fixing data from user errors in an Oracle 10g environment

. Created stored procedures to easily manipulate data

. Developed functions to help with highly needed tasks

. Used PL/SQL to maintain database integrity

. Experience using TOAD software for Oracle Database Management

. Created sequences to automatically assign primary key ID numbers

. Wrote triggers to run sequences when a row is added to the database

. Developed cursors to return large amounts of data

Technical Lead on a Mainframe system migration

Set-up first website to CCTV system for offenders (First in the nation)

Create stored procedures and functions from scratch for DBMS_Jobs

Sharepoint Server 2007 Site Set-up and Administration

Indiana University, Chemistry Department Bloomington, IN

Computer Technician February 2006 - November 2007

End-user support

Workstation building

Data recovery

Linux workstation support

ACCOMPLISHMENTS/ACHIEVEMENTS

Created first website to CCTV for offenders. This project is the first in

the nation, and is being implemented by the Federal Bureau of Prisons. It

will be used in all Federal Prisons across the nation.

Contact this candidate