Sql Server Data

J. David Dayton

Address: *** ******** **., *******, ** 94590

Telephone: 707-***-**** Email: **********@**********.***

Education:

M.S. Statistics, University of Georgia, Athens, GA.

June 1992 - June 1994

B.A. Physics, Kansas State University, Manhattan, KS .

August 1987 - July 1991

Employment: (jobs on note*)

Cisco Systems, Milpitas CA

Hardware/Software: SAS Enterprise Guide, Tectia, Citrix, LINUX SERVERS, PC

Clients

* SAS Developer/Analyst

Oct 2010 - Present

Create, enhance, and ultimately automate quarterly dash board reports using

SAS macros and excel. Continuous ad-hoc list and report production in an

ever changing, fairly high pressure work environment. Process requests from

marketers of various descriptions and complexities to email, mail, and call

clients across Cisco's customer base. Most work done in SAS Enterprise

Guide using data from SAS, Sales Force.com, and EXCEL. Work requires

complex joining and adaptations to messy data and chaos inherent to

marketing environments.

Wells Fargo Bank, Wholesale Banking, San Francisco, CA 94105

Hardware/Software: SAS, SQL Server Management Studio, PC clients, UNIX

servers

* Returning SAS Application Developer (consultant): Jun

2011 - Nov 2011

Use SAS to generate print flags in SQL Server

that ultimately control whether or not records print in EXCEL. This

analysis is spatial in nature and is fully automated and flexible and built

into the SQL Server/SAS code referenced below in the (sep2010 - Jan2011)

work description. Uses advanced techniques such as retain statements,

first./last. SQL into: macro techniques, and the use of SAS meta data to

enable full automation. Expand the SAS code created in late 2010 to include

15 more time periods.

Hardware/Software: SAS, SQL Server Management Studio, PC clients, UNIX

servers

* SAS Developer/SAS Analyst (consultant):

Sep 2010 - Jan2011

Converted 200 plus pages of SQL Server code

and SAS code into a completely automated process that requires no editing.

Uses SAS metadata to automate the names of columns used in secondary

queries. Tracks and monitors errors automatically and produces execution

reports to easily monitor the success execution at run time. Also creates

QC data to be used to continually monitor the stability of input and output

data. Heavy usage of SAS MACROS and ODBC "pass throughs" to run SQL Server

code from within SAS. Projected project completion, Jan 2011.

Wells Fargo Bank, Home Equity Risk Management, Concord, CA 94108

Hardware/Software: PC clients, UNIX servers, SAS, Exceed, MS Office

* SAS Developer/SAS Analyst (consultant):

June 2008 - Dec 2009

Converted series of piecemeal development SAS

programs designed to generate behavioral risk scores into automated, self-

monitoring production processes. Developed analysis MACROS for monthly

reporting across various metrics and report styles including proc gplot,

proc report, proc means, and customized data step processes (all converted

into excel). Executed literally hundreds of ad-hoc analyses- touching all

data sources, types, and needs. Mentor and teach less experienced coders in

SAS techniques and methods.

Wells Fargo Bank, Distribution Strategies and Services, 525 Market Street,

San Francisco, CA 94108

Hardware/Software: PC clients, UNIX servers, SAS, Exceed, ORACLE, Microsoft

Office

Statistical Modeler: (consultant):

Aug 2007- March 2008

Developed and implemented statistical models

to identify attributes of teller transactions that significantly effect the

transaction time in bank branches. Ultimately developed a composite model

that incorporated all significant attributes so that staffing needs can be

better determined and identified. Project used data sets with 30 million+

observations.

Wells Fargo Bank, Business Banking Group, 525 Market Street,

San Francisco, CA 94108

Hardware/Software: PC clients, UNIX and LINUX servers, SAS, FirstLogic

(Dataright/ACE/Match-Consolidate). Exceed, ORACLE, Microsoft Office

SAS Developer (consultant):

October 2005- May 2007

Developed system of macros to automate data auditing for Marketing Data

Mart. Re-design and automate pre-existing QC macros and programs for data

mart. Execute ad-hoc requests that require special programming. Document

complex production processes.

* Wells Fargo Bank, Business Banking Group, 525 Market Street,

San Francisco, CA 94108

Hardware/Software: PC clients, UNIX and LINUX servers, SAS, FirstLogic

(Dataright/ACE/Match-Consolidate). Exceed, ORACLE, Microsoft Office

Application Engineer (consultant):

November 2002- April 2005

Designed, planned, coded, tested, and implemented massive householding

application. Application utilizes Firstlogic and SAS primarily to extract

approximately 80 Million business records from various data platforms

(ORACLE/ASCII/SAS/EXCEL) and origins, then performs data quality checks,

cleaning and standardization on all records before finally grouping records

into households and assigning numbers respectively. Application used for

cross referencing data across files. Final product consists of a large

relational data base in ORACLE and an automated process with built in QC

checks. Also trained Full Time Employee to execute the application after

development and testing. Overall saving to Wells Fargo in production costs

alone: approx 1 million dollars per year.

* Charles Schwab & Co., 120 Kearny St

San Francisco, CA 94108

Hardware/Software: Unix, MVS, SAS v.8, Postal Soft, Microsoft Office

Contract programmer/developer/analyst June 2000-

September 2002

* Maintain and further develop a system of complex SAS macros that

automates the selection process for retail marketing. Use SAS Internet

technology (HSQL and Internet Broker) to create dynamic web pages that

query and execute reports from and to SAS data sets. Work with name and

address standardization software to optimize matching outside lists with

customer base. Maintain system of reports and mainframe jobs until phased

out and converted to SAS/UNIX. Create weekly reports in SAS and publish

to the web. Provide support and technical expertise to other analysts.

* Prepare and deliver presentations to other analysts and managers on the

use of SAS applications.

Wells Fargo Bank, Business Banking Group, 120 Kearny, Suite 2350

San Francisco, CA 94108

Hardware/Software: PC clients, UNIX server, Exceed, SAS 6.12, ORACLE,

Microsoft Office

Assistant Vice President/Senior Programmer Analyst:

June 1999 - May 2000

* Manage group of six SAS programmers. Oversee programming and

communication between the marketing and technical programming groups.

Apply predictive models to large data sets to optimize response rates for

marketing efforts. Mentor junior programmers in extracting large data

sets with SQL and SAS, merging and joining, advanced data step processing

(first., last., transposing, do loops, output statements, etc.), and

macro processing.

* Help design and expand large integrated relational database with outside

vender.

Contract Programmer:

Feb 1997 - June 1999

* Write SAS code to produce large (1 million +) business direct mail file

by extracting data from different sources and formats and merging and

manipulating data. Work with marketing group to design a system of

communication to quickly and clearly deliver specifications for each

month's mailing. Also produce ongoing Ad-hoc reports and lists.

* Support the Business Banking group in their direct marketing campaigns by

producing ad hoc reports and data queries from various Oracle databases

using SAS and SQL.

Environmental Risk Analysis Inc., 1670 South Amphlett Blvd. Suite 115

San Mateo, CA 94402-2512

Hardware/Software: Pentium PCs, SAS 6.11, SUDAAN, Word, Excel

Scientist:

June 1996- Feb 1997

* Intensive SAS programming (statistical and base) and report production

(mostly in Excel) in a high-pressure work environment. Analyses of

epidemiological and environmental data involving linear and logistic

models. Complex data management and manipulation of large data files

(i.e. The 1987 National Medical Expenditure Survey).

* Replication of published scientific analyses for the purpose of

scientific scrutiny and litigation support.

Institute for Health Care Research, American Institutes for Research

P.O. Box 1113, Palo Alto, CA 94302-1113

Hardware/software: Pentium PCs, OS/2 Warp, SAS 6.10, SUDAAN 6.33, HTML,

SPF/2, DBMS Copy, WordPerfect, Word, Excel, FTP, Telnet, Netscape

Senior Research Associate

September 1994 - June 1996

* Performed statistical analyses for health research projects, including: t-

tests, chi-square, ANOVA, MANOVA, multiple regression, logistic

regression, multiple comparisons, factor analysis.

* Continuous data management and SAS data step programming across all

projects, including establishing and maintaining the data and file

management system for a large rolling enrollment smoking cessation study

at the Palo Alto VA hospital.

Department of Statistics

University of Georgia, Athens Georgia

Hardware/software: Sun SPARC, PC, UNIX, DOS, X-11 Windows, SAS, Fortran,

LaTeX, WordPerfect, ftp, telnet

Graduate Teaching Assistant

September 1992 - June 1994

* Taught two lab sections per quarter of a large lecture format statistics

course.

* Responsible for preparing small lectures, providing assistance out of

class, and all grading.

Journal articles:

Anderson, Jon E., Dayton J. David (1995). Instructional Regression Models

Using XLISP-STAT. Journal of Statistics Education, v3, n.1

Conference presentations:

Seidner, A. L., Gaither, D. E., Burling, T. A., Dayton, J.D. (1995

November). Intrinsic and Extrinsic Motivations for Smoking Cessation among

Drug/Alcohol Dependent Inpatients.

Brown, N. L., Forrest, K. A., Dayton, J. D., Flaherty, M. Y., Swanson, J.

M., & Latini, D.M.(1995October).HIV knowledge, attitudes, and behavior of

Spanish media users. Presented at the annual meeting of the American Public

Health Association, San Diego, CA.

Instructional experience:

Lab Instructor, Man's Physical World, Department of Physics, Kansas State

University, Manhattan, KS, 9/89-2/90.

Instructor, Introduction to Statistics, Department of Statistics,

University of Georgia, Athens, GA, 9/96 - 9/94.

Honors and awards:

John Cardwell Physics scholarship, 1989-1990

Basil Curnuit Physics Scholarship, 1990-1991

Relevant courses:

Statistical Methods, Multivariate Analysis, Advanced Regression Analysis,

Design and Analysis of Experiments, Mathematical Statistics I and II,

Linear Models, Survival Analysis, Consulting I and II. Analysis of Messy

Data, Advanced Programming Techniques and Efficiencies

Contact this candidate