Quality Assurance Sql Server

Jeff Harrison

Summary

JEFF HAS TAUGHT PROGRAMMING IN VB, VBA IN MS ACCESS 97 / 2000 SEMINAR

CLASSES, C, AND C++ AT THE EVERETT COMMUNITY COLLEGE AND ADVANCED

TECHNOLOGY TRAINING CENTER IN EVERETT. JEFF HAS IMPLEMENTED BOTH FORMULA

AND SCRIPTING FUNCTION UTILITIES TO MAKE DATA GATHERING EASY FOR

ADMINISTRATORS, IS WELL VERSED IN QA AND TEST AUTOMATION, AND HAS

ADMINISTERED NETWORKS FROM WINDOWS 95 TO ACTIVE DIRECTORY, INCLUDING

NETWORK HARDWARE AND SOFTWARE SERVICES. JEFF HAS INSTALLED AND

ADMINISTERED SUSE, TURBOLINUX, DEBIAN, AND UBUNTU LINUX, INCLUDING FOCUSING

ON MYSQL, POSTGRESQL, APACHE, AND SOME PHP SCRIPTING. JEFF CREATED THE

COST BENEFIT DOCUMENTATION THAT JUSTIFIED THE PURCHASING COST OF THE VMWARE

WORKSTATION PRODUCT AT KEANE. JEFF IS VERY FAMILIAR WITH RDBMS USE,

ADMINISTRATION, SQL PROGRAMMING, AND THEORY, BOTH ON THE MICROSOFT AND

LINUX PLATFORMS. JEFF IS FAMILIAR WITH DATABASE REPORTING AND NEEDS, BOTH

VIA WEB SCRIPTING AND THE CRYSTAL REPORTS / BUSINESS OBJECTS REPORTING

TOOLS.

Technical Summary

MS EXCEL MS ACCESS MS SQL SERVER

ORACLE TURBO BASIC

VISUAL BASIC

HTML / DHTML SUSE, Debian Linux

JavaScript AutoHotKey VM Ware

MS Windows

DHCP MySQL, PostgreSQL C/C++

Crystal Reports / Business Objects Exchange / Domain Admin

WMI Scripting

Professional Summary

PUD#1 of Snohomish County

April 2008- July 2008 on Contract via CIBER Inc.

Analyst

. Executing VBScript for profile and file management using Windows

Management instrumentation

. Creating VBScript and batch files for utility and application

installation

. Using VBScript for remote process execution and information gathering

. Using VBScript for data gathering, presentation and process

documentation

. Developing design and test documentation for more complex utilities

including flowcharts and test case scenarios

. Building Hyper-Text applications & VBScript utilities / tools

. Improved the client's internal time reporting tool, using Visual Basic

for applications, and automating a solution to a problem within it

. Implementing Altiris return codes for ease of administrative use, and

limiting the burden of knowledge retention

. Building and documenting a process to create data gathering tools

. Contributing to design discussions and test planning meetings

. Teaching some of the principles of software testing to the team, to

increase their success

. Leading and participating in code reviews

Keane Care Inc., Redmond, WA

2006- April 2008

Quality Assurance Technical Analyst

. Responsible for functional and performance software quality testing

. Performed automation using scripting and system tools

. Experienced with MS Act, AutoHotKey, and TestComplete automation

. Self directed SQL Server Data type / Join validation as a side project

. Assisted customer service with database related issues at customer

sites

. Used SQL Server and MS Access for backend data verification, including

writing ANSI compatible inner and outer join Queries, Stored

Procedures and Views

. Used Microsoft SQL Tools to administer, troubleshoot, create and

maintain databases

Keane Care Inc., Redmond, WA (continued)

. Created and evaluated maintenance plans, database diagrams, and data

structures

. Evaluated testing tools via scripting for automated testing

. Extensive use of VMWare virtualization technology to speed environment

implementation

. Maintained and administered the Quality assurance test lab, including

domain and domain services maintenance on a windows 2000 / 2003

domain.

Iron Mountain Quarry, Granite Falls, WA

2004-2005

Heavy Equipment Operator

. Mine operator

Martin Marietta Materials, Granite Falls, WA

2001-2004

Network Administrator / Information Technology Technician

. Implemented the Martin Marietta Materials Local and Wide area network

. Supported end user desktop and network issues via telephone and onsite

support

. Supported Windows 9x, Windows NT4, Windows2K, and Windows XP

. Provided front line support for company applications: Lawson, JWS, and

Ceridian

. Gained experience in ISDN, Frame Relay, Fiber and dial up Network

technologies

. Administered Microsoft Exchange as well as the Microsoft NT4 domain

. Used DHCP, WINS, Server Manager, User Manager, RAS Manager, Task Pad,

and other Network Administration Tools

Everett Community College and the Applied Technology Training Center,

Everett, WA

1999-2001

Computer Programming Instructor

. Taught beginning through advanced levels of Visual Basic Programming

. Taught both beginning and intermediate levels of C/C++ Programming

. Taught 5-day seminar class, mastering Access 97 Programming (MOC#

1200A)

Captura Software Inc., Bothell / Kirkland, WA

1996-2000

Associate Software Engineer / Software Engineer

. Responsible for Crystal Reports

. Awarded bonus stock options for work on DCOM development team

. Awarded employee of the month for work on Oracle Database team

. Awarded "QA Man of the Month" award for thorough documentation and

team effort

. Familiar with VB4, VB5, and VB6

. Administered databases with SQL Server 6, 6.5, and 7

. Wrote table scripts, stored procedures, views, and triggers in SQL

Server

. Designed views and stored procedures for Oracle 7.3 and Oracle 8i

. Administered and created Sybase SQL anywhere and MS Access 2, 95, and

97 databases and front ends

. Created VB front ends for multiple databases using ODBC, DAO and ADO

database connectivity

. Owned the Captura Crystal Reporting engine, including the baseline

reports

. Used API level print engine calls to provide crystal reports in

Seagate Crystal Reports 5, 6, and 7

. Designed, prototyped, and demonstrated the next generation print

engine, using ActiveX out of process technology

. Found methods to work around many of the limitations of the Crystal

Report Product

. Implemented the Seagate web report server and smart viewers for

intranet report distribution.

. Designed and created active server page report solutions

. Troubleshoot and correct application 'bugs'

. Responsible for bug fix estimations and documentation

Computer Tutor, Marysville, WA

1996-Present

Sole Proprietor

. Computer support both in-home and telephone.

. Responsible for telephone troubleshooting of Windows issues directly

with customers

. Linux for personal use, including MySQL, Apache, OpenOffice and

Anjuta.

. KDE and Gnome desktop and programming use.

Keane, Inc., Seattle, WA

1995-1997

Windows 95 Support Technician/Telesolve Technician

. Successfully completed the Microsoft designed support training for

Windows 95

. Responsible for telephone troubleshooting of Windows 95 issues

directly with customers

. Responsible for DOS batch files and boot processing troubleshooting

. Responsible for network administration and troubleshooting

. Made extensive use of the Microsoft knowledge base and tools

. Completed advanced problem solving skills course

. Provided frontline support for many applications, including: MSOffice,

CCMail, Lotus Notes, MS multimedia titles, MS Games, AutoCAD LT, and

others

. Support for Windows 3.11 as well as Win95 and NT

. Designed, developed, and implemented a call tracking system with one

of our customers

. Used a VB front end, and an MS Access backend to provide client server

functionality

Education

NEW HORIZONS, SEATTLE / BELLEVUE, WA

2001-2002

. Windows 2000: Network and operating system Essentials

. Implementing Microsoft Windows 2000 Professional and Server

. Implementing a Microsoft Windows 2000 Network Infrastructure

. Implementing and administering Microsoft Windows 2000 Directory

. Implementing and supporting Microsoft Internet Information Services

5.0

. Administering a Microsoft SQL Server Database

. Programming a Microsoft SQL Server Database

. Designing a Secure Microsoft Windows 2000 Network

ARIS Education, Bellevue, WA

2000

. Introduction to PL / SQL for Oracle7

. Oracle7 Foundation

Everett Community College

1985- (Part-Time, while working)

. Excelled at VB Intermediate and Advanced. Skipped Introduction with

instructor's recommendation due to self-study

. Professor recommended me to the position at Captura.

. A top student in Database Design and Administration using MS Access

. Excelled in introduction to C programming

. Internet Studies

. Core Curriculum

PO Box 1939

Marysville WA 98270

*****@*****.***

Contact this candidate