Sql Server Developer

**** ****** ******

Eagan, MN *****

Cell: 651-***-****

Home: 651-***-****

Email: *********@*****.***

Senior SQL Server database developer with many years of experience in all

phases of software and database creation, implementation, and support on

Internet/intranet, PC, and mainframe platforms. Ambitious self-motivator

with impressive leadership qualities and a capacity to effectively

interface with management as well as end users. Tremendous desire to learn

new technologies.

Able to analyze and convert complex user business requirements into high-

quality database architectures and software applications.

Maintained and enhanced the data warehouse ETL processes for Cardinal

Glass. Investigated, corrected and tuned complex data access issues for

Data Warehouse reporting. Lead developer for SSRS reporting.

Developed and supported dozens of SQL Server databases and data

import/transformation processes for the real estate industry. Wrote and

enhanced stored procedures and views for web-based OLTP database access.

Created and supported e-commerce systems using numerous technologies for

various clients. Wrote two intranet sites for a Fortune 500 company. In

each case, evaluated customer system requirements and provided consulting

services.

As a senior consultant at CAP Gemini, developed a system for the

Minnesota state housing department to maintain lending agency information.

Internal users were able update the database via web forms, and external

users could request and generate reports.

At Unisys, created a Visual Basic/Access system that used barcode

tracking for the transfer of tapes to and from off-site storage.

Within the Unisys Defense Systems Division, managed a programmer/analyst

group. In this role, performed workload distribution, salary planning, and

merit and performance reviews. Trained staff members in the use of internal

software and redesigned the department's software version control process.

Completed a Master's degree in Software Engineering at the University of

St. Thomas and a Bachelor of Science in Applied Mathematics at the

University of Wisconsin-Stout.

Experience

Senior SQL Server Database Developer, 2008 to Present

Cardinal Glass Incorporated, Eden Prairie, MN

Senior database developer responsible for data warehouse ETL

development and maintenance, SSRS report creation, and data

access tuning. Developed, enhanced, and supported processes

using Transact SQL, Ascential DataStage and SSIS which moved

data from the JD Edwards EnterpriseOne AS400 system and other

sources into the SQL Server warehouse. Assisted in conversion

of ETL processes from DataStage to SQL stored procedures.

Developed SSRS reports and complex stored procedures for

real-time benchmark and scoreboard display at the

manufacturing plants. These reports retrieved data from OLTP

SQL production databases and required extensive stored

procedure tuning for rapid display. Designed SSRS 2008

reporting system to share reports between plants eliminating

the need to support multiple versions. Reports were deployed

to SharePoint as well as remote reporting servers.

Investigated nightly ETL data integrity issues for business

intelligence reporting. Corrected job errors, data access

issues, and platform datatype conversion conflicts.

Lead SQL Server Database Developer/Administrator, 2001 to 2008

NRT Incorporated, Edina, MN

Lead database developer/administrator. Architected data

transformation processes of MLS property data to and from SQL

Server 2000/2005 web databases. Worked closely with end-users

to collect requirements and test processes. Analyzed data and

designed databases for importing data. Wrote and enhanced

stored procedures for web site database access. Mentored DBAs

and developers in stored procedure design and data access

techniques.

Created over 100 data transformations using both DTS/SSIS and

ETL software. Automated data imports and exports using SQL

jobs, WMI, DOS batch files and other automation software.

These DTS/SSIS packages required development of stored

procedures, views, and ActiveX scripts. Created complex DTS

flow logic. Wrote and maintained documentation for processes.

Department expert at tracking down problems in data

import/export processes. Trained DBAs in data transformation

and data issue investigation. Approved database changes and

moved into production systems. Analyzed and corrected SQL

bottlenecks and poorly performing logic using SQL Profiler and

query execution plans. Performed database administration

duties including backups and restorations.

Principal Consultant, 2000 to 2001

Norstan Consulting, Minnetonka, MN

Lead DBA and team member on the creation of a

business-to-business e-commerce web application using

Microsoft Site Server Commerce Edition 3.0. Designed and

created the SQL Server 7.0 database to support the system.

Produced stored procedures to retrieve and maintain data.

Created SQL DTS packages to update the database with nightly

interface files from the PeopleSoft ERP system.

Continued with the maintenance of the business-to-consumer

e-commerce web site from previous employer. Created data

interfaces to their back-end inventory system using SQL Server

data replication. Upgraded the system to interface to a new

product fulfillment firm.

Senior E-Commerce Consultant/Developer, 1997 to 2000

Integrated Network Technologies, Eagan, MN

Enhanced and supported an e-commerce web site developed in

Microsoft Site Server Commerce Edition 3.0. Created and

implemented a Site Server e-commerce site for a local client.

Wrote two intranet sites for a Fortune 500 company. These

systems used IIS, MTS, ASP, VBScript, Jscript, J++ and VB COM

components, CyberCash, ColdFusion, and SQL Server. Evaluated

customer system requirements and provided consulting services

and recommendations. Wrote specifications and documentation.

Senior Consultant, 1997

CAP Gemini Consulting, Minneapolis, MN

Developed a Microsoft InterDev/Access database system for the

State of Minnesota Dept. of Housing to maintain lending agency

information. Internal users updated the database via web forms

and external users were able to request and generate reports.

Created a website for the local branch office. Evaluated

Internet software for database access and HTML generation.

Information Systems Group, 1994 to 1997

Unisys, Eagan, MN

Senior IS Specialist - Distributed Application Services

Created a Visual Basic/Access software system that used

barcode to track the transfer of tapes to and from off-site

storage. Developed a plan for monitoring the enterprise

client/server software within the organization. Designed

Visual Basic/Access module and modified in-house UNIX process

to monitor performance of email post offices. Developed MS

Word and Excel macros to create metric reports from UNIX

program logs. Supported and enhanced mainframe file transfer

systems.

Defense Systems Division, 1981 to 1994

Unisys, Eagan, MN

Senior IS Specialist - Information Technology

Produced client/server systems to fax purchase orders and

print purchase orders to network laser printers from the

mainframe. Designed, programmed, and maintained a

client/server system to upload labor transactions and files to

a mainframe from the PC. Assisted in the evaluation and

selection of department software development tools.

Supervisor of Programmer/Analyst Organization

Performed workload distribution, salary planning, and merit

and performance reviews for seven programmer/analysts in the

manufacturing systems group. Evaluated, selected, and

installed department PC and network software. Trained staff in

the use of Microsoft Windows and Windows software. Taught a

course in C programming. Redesigned department software

version control process.

Programmer/Analyst

Designed and programmed a new manufacturing parts inspection

system. Modified an outdated non-updateable manufacturing

requirements real-time system to allow real-time updating.

Interacted extensively with end users while performing system

support.

Supervisor of Programming Organization

Oversaw the workload distribution, salary planning, and merit

and performance reviews for nine programmers in the

manufacturing systems group. Conducted interviews and

completed hiring for open developer positions. Trained new

employees in software development and department methodology.

Lead Systems Programmer

Served as programming project leader for new purchasing system

installation. Project involved development of many

site-dependent programs and data conversion from an indexed

database to a hierarchical database with minimal lead time.

Planned the programmer resources and scheduling of workload,

system testing, and implementation.

Systems Programmer/Analyst

Constructed a client/server system to read, validate, and

upload labor transactions from barcode readers to the

mainframe via a microcomputer. Developed and supported

mainframe COBOL manufacturing programs.

Background

1. Lead SQL Server Database Developer

2. Software development, implementation, and support

specialties

3. Microsoft SQL Server 2000/2005/2008/2012

4. SSRS Report Development

5. Stored procedures

6. Performance tuning

7. ETL and data transformation

8. Job automation

9. Customer interface

Experience

10. Cardinal Glass Incorporated - Senior SQL Server Developer

11. NRT Incorporated - Lead SQL Server Database Developer/Administrator

12. Norstan Consulting - Principal Consultant

13. Integrated Network Technologies - Senior E-Commerce Consultant /

Developer

14. CAP Gemini Consulting - Senior Consultant

15. Unisys IS Group - Senior IS Specialist

16. Unisys Defense Systems Division - Senior IS Specialist, Supervisor of

Programmer/Analyst Organization, Programmer/Analyst, Supervisor of

Programming Organization, Lead Systems Programmer, Systems

Programmer/Analyst

Education

Master's of Software Engineering

University of St. Thomas

St. Paul, MN

Bachelor of Science

Applied Mathematics

University of Wisconsin-Stout

Menomonie, WI

Contact this candidate