Sql Server Project

Scott Holland

***** ****** **** . **** *****, Virginia 23060-3020

Phone 804-***-**** . E-mail *********@*****.***

Summary of qualifications

Detailed oriented Information Systems Specialist with strong

analytical and leadership skills. Expertise in creative

solutions, project managing, and a wide range of instructional

skills. Experienced in providing technical support for Fortune

500 companies. A proven performer with a successful track

record of conveying information to technical and non-technical

persons at all levels within an organization.

Skill Set

OS/ENVIRONMENTS: Windows XP, Windows 2000, Windows NT, Windows 98, Windows

95, Pocket PC 2002, PC-DOS, Unix

DEVELOPMENT APPLICATIONS: SQL, PL/SQL, Korn Shell, SAS, T-SQL.

NETWORKING: LAN: Ethernet, Token Ring, Remote Access; WAN: CSU/DSUs,

switches, PROTOCOLS: TCP/IP, IPX/SPX, NetBIOS

HARDWARE: PC Workstations, PDAs, HP printers, scanners and other peripherals.

SOFTWARE: MS SQL Server 2000, DTS, Enterprise Manager, SSIS, MS SQL Server

2005, SSRS, Visual Basic, Sybase, Kronos, MS Office (Word, Excel, Access,

PowerPoint), Ms Project

Work experience

May 2010 - July 2010 ComSys

Richmond, Virginia

Payroll Production Support (Assigned to Carmax)

Maintain payroll systems on a daily operation. Supporting in

house applications that track sales commission and billed

hours. Writing SQL queries for Sybase and SQL Server

environments to validate data being supplied to Payroll for

payroll corrections.

Supporting Windows server applications.

Supporting Kronos work force application, and maintaining the

remote clock systems at remote locations, and resolving work

force issues.

Contract work completed.

June 2009 - August 2009 Technisource

Richmond, Virginia

SSIS Developer (Assigned to Markel)

Develop SSIS packages for AMS systems to automate reporting of

data extraction to Excel, and publish results through e-mail.

Automated creation of the Excel documents and distribution

through e-mail using Microsoft SSIS packages and VB.Net

development. The VB development was used to assign variables

with-in SSIS packages, verify files, and loop statements for

assigning variables with-in loop statements in the SSIS

package.

Create documentation on the SSIS packages and how the data

pulled and steps through the SSIS package on what each step

does. Also, document trouble shooting steps for the package

and how to resolve issues.

Contract work completed.

March 2008 - June 2009 CRT Inc.

Richmond, Virginia

SQL Programmer / Application Development (Assigned to PFG)

Application Development duties included creation of new

reports using Microsoft Reporting Services (SSRS), and seeing

them through the SDLC process of planning, system design,

programming, testing, installation, and maintenance. Duties

performed in this role are SQL programming, report writing,

project work, SQL performance tuning, creation of stored

procedures, tester, and support.

Worked on fiscal year project to change the fiscal year date

in the data warehouse. By coming up with a solution for the

fiscal year change, and working with DBA to test and implement

changes.

Using VB functions with-in SSRS to assign variables.

Creation of several reports for upper management on sales

comparisons.

(I.E. Year of Year comparison)

Creation of warehouse throughput reports for managers to gauge

workers performances.

Create documentation on the processes of reports data mapping

model to the report and how the data was pulled.

May 2004 - March 2008 Health Management

Corporation

Richmond, Virginia

Data Administrator II / Team Lead / Technical Lead

Processing Membership and Caseload data through an ETL process

using SSIS and DTS packages. Also working with clients, and

their data to establish good and accurate support to the needs

of the client.

Responsible for projects with clients to implement new data

sources and target mapping their data to the Data warehouse

and transactional system.

Manage project processes of requirements gathering,

programming, testing, implementing, and maintaining.

The use of VB.net to assign file validations with-in SSIS

packages.

Transitioned Cognos reports to stored procedures to be used by

DTS packages.

Create documentation on the process of target mapping the

client's data to our system. The documentation would include

field definitions, target mapping, field specifications, and

processes required in the ETL process.

Projects to automate the ETL processes from doing a manual

process in Access to DTS and SSIS packages programming in SQL

and .Net.

Responsible for creation of SQL stored procedures for

reporting membership and caseload processes, and validate and

test processes before implementing.

Responsible for adhoc request using SQL, Access, and other

reporting tools to pull the information need for reporting

team and management.

Manage a team of 3 to insure that data integrity and projects

are managed in a proficient manner in a production

environment.

Develop SSIS, DTS packages and validating SQL code changes by

testing and verify data before implementing code changes.

Tests changes to SSIS packages to load the data into a test

environment to validate the process.

Maintain SSIS and DTS packages for external clients for code

changes and data integrity issues.

March 2004 - May 2004 Kelly

Services

Richmond, Virginia

SQL Programmer (Assigned to Health Management Corporation)

Contracting project to develop and implement a data warehouse

inventory for claims and membership summary tables.

The project was completed 5 months in advance and was hired on

full time by Health Management Corporation.

January 2003 - March 2004 Wolfsvein

Consulting

Richmond, Virginia

Owner

Consulting support to clients needs that included small

network design and implementations, server administration,

database administration on SQL server 2000.

Installed Microsoft SQL standard servers to maintain medical

and business records for small businesses.

Backing up of clients databases and maintain server updates.

Create system documentation for business.

October 2003 - February 2004 G3

Technologies

Richmond, Virginia

Systems Engineer Specialist (Part Time)

Systems support (Windows 2000 servers, workstations, and

networking).

Supported issues for third party applications connecting to

SQL server.

Installation of SQL server standard for client to track

patient billing.

July 2001 - October 2003 Capital

One

Glen Allen, Virginia

Unix Production Support Specialist

Unix support for an application called Capstone (credit card

decision software). Coordinated the efforts of multiple

support groups within and outside of Capital One in the

restoration of batch and real time services.

Used UNIX on daily bases to query using PL/SQL to find trouble

areas in databases and logs to report to appropriate

personnel.

Developed monitoring scripts (Korn Shell/SQL) that identified

production problems and reduced company down time by 5% in a

batch environment.

Created reports utilized to determine most profitable

production volumes for new product implementation.

Worked on variety of Capstone projects that improved

production by 30%.

May 2000 - July 2001 Quantum Resources

Richmond, Virginia

Network Support Specialist (Assigned to Wyeth Pharmaceutical)

Desktop Support interfacing on all levels within the

organization of 750 users. Supported a Novell network

environment with Microsoft suite products, and software

proprietary to the pharmaceutical industry.

Created tape backup database for recording and tracking of

backup tapes. Enabled the company to track their tape

inventory, and yearly cost estimate.

Implemented project that "rolled out" 250 new computers to

users, thus enabling the company to reinvest inventory savings

of $50,000.

April 1999 - May 2000 Scott & Stringfellow,

Inc.

Richmond, Virginia

Support Analyst

Multi-level support role that encompassed wide-ranging tasks,

including help desk, site ops, and Microsoft Exchange/Network

administration to 800 end-users. Consisted of over the phone,

desktop, and networking support. Additional projects included

the creation of business standards in software, hardware, and

documentation.

Introduced and implemented new banking Citrix client software

to 30 users. Software reduced processing time by 10%.

Developed instructional booklets to train new support analysts

enabling new associates to perform to job standards 30% faster

than with former training process.

Education and training

Advanced Concepts Training Richmond, Virginia

Oracle 8/8i, Unix, SQL / SQL Plus

J Sargeant Reynolds Richmond,

Virginia

Associate of Science /Business Construction Management

Certifications

Comptia A+ Certified

Comptia Network + Certified

Contact this candidate