Data Customer Service
Resume:
Hugh W. Shinn
Apt. 215
San Diego, CA 92130
*********@*****.***
[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