Sql Server Data

John Cannon

Cell: 630-***-****

Home: 630-***-****

e-mail: abicl9@r.postjobfree.com

SUMMARY

Experienced IT and business professional with a diverse programming

background in regression model scorings and database building/modification

of a team-designed database. Skilled in system design, programming, quality

control testing, conversion, implementation, and documentation. An

analytical problem solver who enjoys interesting obstacles to overcome and

working with a team. A consistent track record of efficiency and

reliability.

Programming Languages: SAS, T-SQL, XML, JCL, Assembler, Easytrieve,

COBOL, C, DB2,

CICS, Visual Basic, HTML, Javascript

Software Environment: IBM TSO/MVS, Z/OS (V01R09M00), Windows XP,

Windows 7

Microsoft SQL Server 2008 Skills: Development, Administration,

Business Intelligence -

Reporting, Integration, and Analysis (SSRS, SSIS, and SSAS)

Microsoft SQL Server 2008 Certifications:

- completed

MCTS: Microsoft SQL Server 2008, Database Development (70-433)

- pending

MCTS: Microsoft SQL Server 2008, Implementation and Maintenance

(70-432)

MCTS: SQL Server 2008, Business Intelligence Development and

Maintenance (70-448)

SAS Experience: v 8.2. SAS MACROS. SAS PROC FORMAT, FREQ, MEANS,

PRINT, SORT, SQL, SUMMARY. Extensive use of the DATA step

for both external and SAS files for

reports and data manipulation.

SAS Certifications:

SAS Certified Base Programmer for SAS 9

SAS Certified Advanced Programmer for SAS 9

PROFESSIONAL EXPERIENCE

Time Inc. (a branch of Time/Warner) 1996-2009

- mass media corporation

- founder of Time magazine, Sports Illustrated, People, and others

Programmer/Analyst (1999 - 2009)

Senior Programmer (1998 - 1999)

Programmer (1996 - 1998)

. Performed quality control on incoming data. Validated data (from various

sources) by running comparisons with the existing data to ensure

integrity. Some necessary actions included adding new database fields,

conditionally combining fields, changing field positions, and data

deletion.

> The Corporate Database (CDB) was updated eight times per year, with

over half a billion unique source records as input to each build.

> The database was designed to allow "test in production", with the

capability to add new data sources in auxiliary data segments, making

it possible to quickly assess the usefulness of alternate data within

the production environment.

> The last internal version of the CDB included 79 million households,

and contained over 2500 columns of detail, summary, and analytic

information, including 700+ columns of data supplied by external

vendors.

. Created and automated procedures for common tasks, and complex recurring

requests.

> Due to the historic nature of analytic data, it was necessary for us

to support multiple versions of the database; we eventually settled

upon retaining up to four years of database versions, all accessible

via our production systems.

> In order to support the frequency of change, a rigorous regression

test implementation was utilized. We also used sophisticated audit

reports on all of our input files, to assess whether delta variations

from prior versions were indications of data problems.

John Cannon Page 2

. Trained new employees in company's SAS scoring system.

. Coded post-production processing to output final records in desired

format.

. Executed scoring system to produce output files of potential customers

for several branches of Time/Warner and external companies based on

statistical analyses of their records for the probability of becoming new

customers.

> Efficient and flexible, allowed up to 50 discrete requests to be

processed against a single pass of the file.

> Designed to allow both the selection and simultaneous scoring of names

using regression models.

> Selection and scoring decisions were implemented using conditional

assembly macro code for run time efficiency.

> Integrated reporting of universe decisions, and profile of regression

model variables

> Modular design, allowing one to build up a request from separate

modules of universe, model, and cutoff criteria. Each could be

developed and tested independently, and then strung together to

accomplish complex combinations of universe and ranking decisions.

. Created and modified scoring system for testing and production.

> Production modules were coded in Assembler, often using macros.

> Parallel test runs were coded in SAS.

> Sample files were run against both the Assembler and SAS versions of

the selection and scoring code. Continued code modification and test

runs until output is identical.

> Designed to allow both the selection and simultaneous scoring of names

using regression models.

> Unique layout extracts for external companies were coded and tested in

COBOL.

EDUCATION

Directions Training Center, Oak Brook, Illinois

SQL 2008 Database Administrator and Business Intelligence training classes,

including:

- Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

- Maintaining a Microsoft SQL Server 2008 Database

- Implementing a Microsoft SQL Server 2008 Database

- Implementing and Maintaining Microsoft SQL Server 2008 Analysis

Services

- Implementing and Maintaining Microsoft SQL Server 2008 Integration

Services

- Implementing and Maintaining Microsoft SQL Server 2008 Reporting

Services

SAS Institute, Chicago, Illinois

SAS language training classes, including:

- SAS Programming 2: Data Manipulation Techniques

- SAS Programming 3: Advanced Techniques and Efficiencies

- SAS Macro Language 1: Essentials

- SAS Macro Programming: Advanced Topics

- Data Cleaning Techniques

DePaul University, Chicago, Illinois

Web Development program

. a postgraduate program for current computer programmers concentrating

on HTML, JavaScript, Perl, CGI, ASP, and Java. Apache and Windows NT

web servers, and Oracle and MS Access databases were included in our

final team project

Computer Career Program

. accelerated post graduate program concentrating on Structured Programming

and Systems Analysis, featuring use of COBOL, C, CICS, JCL, and DB2

Computer Programming Institute Northbrook, IL

Visual Basic 3.0 and Client/Server Environment

Loyola University Chicago, B.A. Philosophy, Minors: Psychology,

Mathematics, Music

Contact this candidate