Hugh W. Shinn

***** **** ***** *** **.

Apt. 215

San Diego, CA 92130

***/***-**** *

***/***-**** *

abhplj@r.postjobfree.com

[pic]

SUMMARY:

Directed the development and deployment of enterprise-wide integrated data

warehouse and business intelligence systems. Proven ability to manage

professional staff, work in programming teams, and function independently.

Extensive management, lead developer, and SAS programming experience with

emphasis on application/program development and control.

Certified Base SAS9 programmer.

Employed in the following industries: Financial Services, Chemical,

Government, Manufacturing, Market Analysis/Research, Marketing, and Higher

Education.

Professional Highlights:

Created and deployed automated data load/validation and BI platform for

E*Trade Bank's loan portfolio.

Designed and deployed web-based loan modification identification,

reporting, and analysis system at Etrade Bank.

Redesigned ETL process and reduced monthly load times from 20 to 10 days at

Etrade Bank.

Established robust data warehouse (including schemas and ETL systems) for

E*Trade Bank.

Created web-based metadata reporting system for educational surveys at the

National Science Foundation.

Migrated automated underwriting system to new production environment at

Freddie Mac.

Publications and Presentations:

Parameter-driven Data Transformation and Validation - Southeast SAS Users

Group, 2008.

Parameter-driven Data Transformation and Validation, part 2 - Pacific

Northwest SAS Users Group, 2009.

PROFESSIONAL EXPERIENCE:

MODERN ANALYTICS -SAN DIEGO, CA 5/2010 -

2/2011

Sr. Consultant

. Performed data Integration for this early stage predictive modeling

automation company. Used SAS to prepare data for key automotive clients,

musical instrument catalog retailer and healthcare customer. Redesigned

structure of DataPipe product to streamline it and incorporate all client

data types.

. Integrated data from15 sources for healthcare education provider to let

them understand for the first time the characteristics of their

customers. This integrated data enabled the company statistician/modeler

to create models for primary care physicians who were likely to attend

the client's conferences as well as those likely not to show even though

they had registered for an event.

E*TRADE BANK - Washington, DC

Manager 6/2005 - 5/2010

. Directed development and deployment of enterprise-wide business

intelligence system to enhance data -driven decision making for Etrade's

loan portfolios.

. Designed and deployed web-based loan modification identification,

reporting, and analysis system for all modified loans owned by Etrade

Bank. Analysis includes performing vs. non-performing and re-default

rates.

. Redesigned ETL process and reduced monthly load times from 20 to 10 days.

. Increase data accuracy and availability by designing, building, and

deploying E*Trade's new loan tracking and business intelligence data

warehouse.

. Developed automated data reconciliation application to identify and

resolve data errors during the monthly load process.

. Develop and implement strategies to integrate data from over 70 loan-

servicing organizations into E*'Trade's data warehouse.

. Manage the Extraction, Transformation, and Load (ETL) team and the Data

Load team.

. Train Data Load team in load procedures and data error resolution.

. Develop technical requirements and logical data map templates for new

data marts that will be used for bank-wide reporting purposes.

. Create metadata definitions and tracking systems.

. Participate in the startup of the Credit Risk Analysis group and convince

other departments that the single-source data model will improve their

performance and operations.

. Develop data specifications for all vendor data files.

. Develop requirements for data validation rules, transformation

specifications, and load procedures for data from external vendors.

. Design and write ETL scripts using SAS Enterprise Guide, base SAS, and

SAS macros to extract, transform, and load data from loan-servicing

organizations into E*Trade Bank's data mart.

. Develop metadata reports that monitor the ETL process.

. Design error-handling systems to report, track, and resolve loan servicer

data errors.

. Train ETL staff in the development of loan-servicer-specific logical data

maps and the modification of ETL programs.

. Work with senior E*Trade management to coordinate multi-million and

billion dollar loan purchases from large banks and mortgage lenders.

. Assign staff to specific ETL projects.

. Develop timelines for all ETL tasks.

. Develop timeline and benchmarks for entire data mart project.

. The data mart reporting system has resulted in the saving of 100 man-

hours per month, and a significant increase in reporting accuracy.

. Write job specifications for new ETL, analysis, and reporting positions.

. Develop cases for interviewee testing.

. Interview and hire candidates for ETL and Reporting staff positions.

. Nominated for President's Award for Customer Service.

. Won Peer Award for Customer Service

. Establish procedures for the secure transmission of vendor data to

E*Trade.

National Science Foundation - Washington, DC 11/2004 -

4/2005

SOFTWARE ENGINEER

. Developed web-based metadata retrieval application using SAS/IntrNet,

base SAS, and HTML for the National Science Foundation (NSF).

. Wrote SAS programs to load data to Oracle database tables using PROC

DBLOAD.

. Participated in planning and development of data repository containing

survey information.

. Specified requirements for metadata section of NSF data repository.

Freddie Mac - Washington, DC 5/2004 - 11/2004

CONSULTANT

. Migrated end-user computing programs and applications to Unix production

environment, ensuring compliance with the Sarbanes-Oxley Act.

. Monitored end-user data manipulation activities in ensure inclusion in

production programs.

. Developed extensive and complex reports using SAS PROC REPORT and SAS

Output Delivery System (ODS).

. Wrote Specifications for migration of end-user controlled programs to

client's production environment.

. Wrote training document for users of Freddie Mac's Mainframe Change

Management system.

. Identified and migrated mission-critical programs from end-user areas to

centralized production locations on Freddie Mac's mainframe.

. Developed system interface document in preparation for migration of

mission-critical applications from mainframe to UNIX system.

Bayer, Inc.- Pittsburgh, PA 12/2003 -

4/2004

CONSULTANT

. Developed macro-based SAS programs to generate reports from legacy

systems on IBM mainframes for the Bayer Corporation Tax Department.

. Developed department selection program that allows users to easily

specify which departments to include in tax reports. This procedure was

included in the Federal tax reporting programs.

. Modified the existing tax data retrieval system to allow for customized

reporting.

. Completed ad hoc programming tasks as requested.

. Created complex JCL-based programs to read and write multiple data sets.

Fannie Mae - Washington, DC 12/2002 - 11/2003

CONSULTANT

. Wrote SAS programs that read Oracle tables and produce automated reports

for the Database Systems Development department of Fannie Mae.

. Completed ad hoc programming requests from users.

. Wrote SAS production programs that report on activity for approximately

14-16 million loans per month.

. Wrote specific programs to compare variable values across multiple

systems (Mainframe and UNIX).

. Created macros to automate programming tasks and reporting parameters.

. Researched existing programs to determine the source of all variables.

. Compared existing applications to identify common variables and determine

if they are created in the same way.

. Migrated programs/applications from mainframe (TSO/MVS) to UNIX systems.

Walt Disney World Parks and Resorts - Orlando, FL 7/2002 -

11/2002

CONSULTANT

. Wrote SAS programs on PC and UNIX systems to support model development

for Walt Disney World Company marketing department.

. Extracted data from Informix database tables using SQL and PROC SQL.

. Extracted data directly from specific Excel spreadsheets into SAS data

sets.

. Wrote data from SAS data sets directly into specific Excel spreadsheets.

. Prepared data for external vendors.

. Automated data reporting operations through the use of SAS macros.

J&L Specialty Steel, INC. - Pittsburgh, PA 8/2001

- 1/2002

SOFTWARE ENGINEER

. Wrote SAS programs to report on manufacturing operations for J&L

Specialty Steel Inc.

. Participated in the development and creation of a SAS data warehouse to

allow for rapid access to data. Created ASCII versions of SAS data sets

for access by Microsoft Excel and Access.

. Created automated HTML reports for the J&L web site.

PNC FINANCIAL SERVICES GROUP - Pittsburgh, PA 9/2000

- 4/2001

SR. PRODUCT MARKETING ANALYST (LEAD SAS PROGRAMMER)

. Managed money market data retrieval project that included several of the

bank's departments, resulting in a simpler, more efficient procedure.

. Managed contract employees involved with money market project.

. Wrote SAS data step programs to identify, track, and categorize newly

opened money market accounts. These programs dealt with multiple records

for each account and 2-3 million records per month.

. Worked closely with statisticians to produce statistical models that

predict consumer behavior.

. Converted multi-platform data retrieval programs to single platform

processes, which improved their efficiency and reduced their complexity.

. Supervised contract programmer in achieving project objectives.

. Redesigned Oracle database tables. Resulting in a 90% reduction in

storage requirements.

. Wrote SAS programs to extract data from Oracle database, contributing to

the achievement of departmental goals.

. Created programs and processes to meet the needs of users and internal

customers.

AK Steel, INC. - Pittsburgh, PA 5/1999 -

9/2000

CONSULTANT

. Automated and streamlined distribution of output to executives and

department heads using different printers. Simplifying system

maintenance.

. Developed SAS applications using the data step and base procedures that

allowed non-programmers to track bars of steel during the manufacturing

and delivery processes.

. Developed quality control procedures to monitor migration of programs

from mainframe (MVS/TSO) system to VAX/VMS platform. These procedures

compared Oracle and DB2 database tables, 24 SAS data sets, and over 100

SAS programs. All programs were successfully migrated.

. Improved performance of intern at AK Steel Corporation through

supervision and training.

. Provided training in SAS (data step, base procedures), VMS, and SQL for

novice users at customer site. Improved user efficiency.

MANAGEMENT SCIENCE ASSOCIATES - Pittsburgh, PA 3/1998 -

5/1999

SAS PROGRAMMER

. Prepared data and wrote SAS programs to implement complex statistical

response models for the pre-packaged consumer goods industry and fulfill

customer needs.

. Created, tested, and modified SAS programs that ran on client's computer.

Improving system performance.

. Redesigned existing SAS programs to improve performance, resulting in

shorter running times.

. Participated in MIS/user team that defined the requirements for

relational data base storage.

. Performed technical evaluation of programming/analyst candidates to

determine if qualified to hire.

CARNEGIE MELLON UNIVERSITY - THE HEINZ SCHOOL 2/1993

- 3/1998

RESEARCH COMPUTING CONSULTANT

. Supervised graduate students in various research projects.

. Worked as System Administrator for three multi-user UNIX (Hewlett Packard

9000) computers.

. Designed and taught formal basic and intermediate classes in SAS and the

UNIX operating system.

. Developed and implemented procedures for data storage.

. Made recommendations for hardware and software purchases.

. Wrote numerous and diverse SAS programs for wide range of users,

furthering their education.

NEW YORK STATE ARCHIVES & RECORDS ADMINISTRATION 3/1990 -

2/1993

SENIOR ARCHIVIST - CENTER FOR ELECTRONIC RECORDS

. Created/updated documentation of State electronic records to make them

available to the public.

. Developed and implemented procedures to preserve significant State

records. Determined appropriate format to ensure future access to these

records.

. Prepared synopsis of and data dictionary for State records.

UNIVERSITY OF PITTSBURGH - Pittsburgh, PA 8/1988

- 3/1990

DATA ARCHIVIST

. Provided instruction in basic statistics as requested by students.

. Developed and implemented relational database for tape-tracking system,

resulting in easy retrieval of data.

. Managed work-study staff.

COMPUTER SKILLS:

SAS, STATA, SPSS, MS OFFICE, ORACLE, DB2, SQL, UNIX (HP-UX, SUNOS), MVS,

DEC VAX/VMS, IBM MAINFRAME, IBM PC, HP 9000, UNISYS

EDUCATION:

M.S. - Public Administration Pennsylvania State University

1985

B.S. - Public Service Pennsylvania State University

1984

Contact this candidate