Data Sales

Gregg P. Snell

**** ****** ****, *******, ** ****6

913-***-**** • ******@********************.***

SUMMARY OF QUALIFICATIONS

I have over 30 years of data management and application development experience with the SAS Software

System on mainframes, Unix systems, and PCs most within user departments rather than in IT. My

favorite challenge is when someone says “It can’t be done.”

SAS Certified Advanced Programmer for SAS9

(Issued Sep 2007, http://tinyurl.com/brw7rcf)

An invited speaker in Advanced Tutorials at SUGI in 2006, 2003, and 2002

(http://www.datasavantconsulting.com/about.html#papers)

A Member of the SAS Alliance 2000 2008 (http://www.sas.com/partners)

TECHNICAL SKILLS

Expertise with:

WPS v3 (including migration from SAS to WPS)

SAS Base (including Macro Facility, ODS, Hashing)

SAS/Access (Oracle, Teradata, SQL Server, PC) and SAS/Connect

SAS Enterprise Guide and Management Console (Metadata and Server Administration)

Web application development (JavaScript, CSS, PHP, HTML, SAS Stored Processes/RWI)

Unix Shell Scripting (AIX, Solaris, HPUX, shell scripts), MVS (TSO/ISPF/JCL)

Very large table processing (billion + records)

Experience with:

SAS BI Suite (installation and configuration)

SAS Add in for MS Office

SAS Web Report Studio, Information Map Studio, and BI Portal

SAS ETL, Data Cleansing/Warehousing/Marts

PROFESSIONAL EXPERIENCE

DATA SAVANT CONSULTING May 2000 – Present

Independent SAS Software Consultant

Quest Diagnostics (Lenexa, KS) Mar. 2013 – Dec. 2013

Gregg P. Snell

Expansion of the Rich Internet Application originally developed 3 years ago utilizing stored

processes and the report writing interface (adding À la carte components, administrator

functionality for user/report access as well as SGPANEL graphs).

Willowbrook Partners LLC (Westwood, KS) May 2010 – Feb. 2013

Develop and maintain an analytics datamart from multiple sources of financial data.

Develop automated Excel and HTML reports (including interactive Dygraphs javascript charts) of

weekly and monthly financial performance.

Develop univariate prescreening criteria to improve portfolio performance.

Develop methods for detecting weaknesses and failures in existing underwriting along with

recommendations for improvements.

Develop methods for identifying and subsequently preventing fraud.

PROFESSIONAL EXPERIENCE (continued)

Quest Diagnostics (Lenexa, KS) Feb. 2009 – Mar. 2010

Diagnosed and resolved issues with a SAS9 BI install.

Developed custom PDF reports utilizing the data step ODS Report Writing Interface via stored

processes. These reports include full page color cover sheets and data driven pages interweaving

text with charts and tables.

Designed a Rich Internet Application utilizing stored processes for interactive querying and

charting of laboratory data. This RIA includes drag n drop column selection, streaming reports to

PDF, Excel, and ActiveX graphics. (sample:

http://www.DataSavantConsulting.com/Company_ABC_EWR2009.pdf)

Embarq (Overland Park, KS) Jul. 2008 – Jan. 2009

Team lead to implement a SAS9 BI install including configuration changes and initial report

development utilizing Web Report Studio, Stored Process Web Application and SAS Add In for

Microsoft Office.

Developed a web application to simulate Excel Pivot Table functionality including true drag n drop

parameter selection.

Designed conversion of campaign history database to SPDE Server.

Provided UAT testing of a new business customer house holding warehouse being developed by

off shore staff.

Hallmark (Kansas City, MO) Mar. 2008 – May 2008

Migrated a series of jobs to clean and manipulate consumer data from V6 on a mainframe to V9

as an Enterprise Guide Project.

Gregg P. Snell

Sprint (Overland Park, KS) 2001 – Jan. 2008

Developed code utilizing hashing to update a subscriber data mart in excess of one billion rows.

Developed code to automate monthly reporting that integrates data from Unix systems and 3rd Party

Excel reports. Created reports for BI portal.

Developed a plan (with code tools) to migrate existing data and programs from V6 to V9. Code

included Unix scripts to automate 95% of required modifications.

Developed a warehouse of web performance data using AppDev reporting frontend with automatic

updates to spreadsheets.

Developed a custom Campaign Analysis Tool utilizing AppDev (JSP and JavaScript) for a truly

Windows look and feel. Optimized several programs for campaign analysis and modeling.

Identified and diagnosed performance issues with SAS on an AIX system.

CapitalOne (Richmond, VA) Jun. 2003 – Jun. 2005

SAS Lead of a team that developed an intranet forecasting application.

Developed stored processes to interact with a Java front end and Teradata warehouse, extreme

use of macros for production quality control.

Successfully duplicated some Excel functionality (row column cascading formulas) in a SAS

application.

Gregg P. Snell

PROFESSIONAL EXPERIENCE (continued)

LabOne (Lenexa, KS) 2000 – 2002

Migration of an OpenVMS legacy system in V6 to V8 on Solaris Unix in less than three months.

This included over 3700 programs and 100 scripts.

Redesigned their batch update process using Warehouse Administrator and reduced run times by

over 60%.

Converted a cookie based SAS/Intrnet site to a secure session variable based JSP site.

BEST SOLUTIONS, INC., Kansas City, MO

Jan. 2000 – Apr. 2000

Director, Data Management and Analytical Services

Responsible for the division’s budget, specifying the hardware and software requirements, and co

managing a staff of 10 with the Manager of Analytical Services.

July 1998 – Dec. 1999

Technical Team Leader, SAS Team

At H&R Block World Headquarters, Decision Support Group of Database Marketing: redesigned

the SAS data mart for optimal reporting efficiencies; developed numerous processes for

incorporating 3rd party data; developed a prototype SAS/GIS application for viewing/selecting

various statistics from direct mail activities; developed the first functional reporting hierarchy for

their complex geographic distribution of offices.

July 1995 – June 1998

Senior SAS Programmer

At Yellow Freight: redesigned a complex process for distributing mainframe based account data to

inside and outside sales representatives. The new process included a mainframe based SAS/AF

user menu for maintaining and modifying team based sales assignments, and procedures for

automating the upload/download of customer data to an MS Access database.

At Santa Fe Contract Services Division, using Base SAS and SAS/AF, custom designed user

interface screens for personnel managing contracts.

ENVIRONMENTAL SEARCH, INC., Shawnee, KS

1990 – 1997

President and Co Founder

Responsible for every aspect of business operations, sales, marketing, and data analysis.

Using SAS in conjunction with WordPerfect, PowerMacs, and Tactician, geocoded latitude and

longitude to sites in federal and state environmental databases, displayed these sites on a

mapping system, and produced a street detailed report for clients.

Developed a system for extracting, normalizing, and updating data from all 50 states as well as

the Federal Government (over 200 different data sources).

Developed an automated system for generating reports using geocoding software, SAS programs,

and WordPerfect Macros.

DPRA, INC., Washington, DC and Kansas City, KS 1985 – 1991

CONOCO, INC., Ponca City, OK 1981 – 1985

Gregg P. Snell

EDUCATION

Associate of Science Degree – Computer Science May 1981

Kansas State University College of Technology Salina, KS

GPA 4.0/4.0

Contact this candidate