SAS Developer

RALPH WINTERS

Maplewood, NJ *****

Work: 973-***-****

E-Mail: ************@*****.***

SUMMARY:

* Hands-On, detailed-oriented Data Analyst, SAS Developer, and Data Miner

* Expert in business analytics, Business Intelligence (BI), predictive modeling, data analytics, OLAP, data mining, statistical analysis, and SAS programming and development

* Strong implementations of Software Development Life Cycle (SDLC)

* Excellent Database skills (SQL SERVER, SSAS, SSIS, ORACLE, SYBASE, DB/2, TERADATA), especially with large databases

* Excellent communication, writing, and presentation skills

* Advanced SQL Query language, and query optimization

* Software Tools: SAS , Java, Business Objects/Crystal , BIDS, Cube Development, Cognos/Powerplay/Impromptu, Informatica, Stored Procedures, Transactional SQL, Dataflux, “R”,TOAD, Oracle Data Miner, S-PLUS, DB-Artisan, RapidSQL, Excel, Excel/Visual Basic, HTML/CSS

* Operating Systems/Databases: Windows,UNIX,ORACLE, SYBASE, DB/2, SQL SERVER 2000/2005, TSO/MVS/zOS

* Knowledge of Six-Sigma statistical techniques, root cause analysis, Pareto diagrams

* Text Mining, Web Log Analysis, Omniture, Webtrends, Google Analytics, SEO, and SEM

* SAS Certified Base Programmer: SAS Base, Macro, STAT, Access, GRAPH, Enterprise Miner, Enterprise Guide, Web Report Studio, SAS/Intrnet, SAS DI Studio, SAS Dashboard Development

Industry Experience: Financial, Pharmaceutical/Healthcare, Cellular, Direct Marketing, Consulting

WORK EXPERIENCE:

2010-Present CDI Corp (Consulting Statistician to Major Financial Client)

* Credit Card Customer Data Mining – Voice of the Customer Analysis and Reporting for Major Financial Client: Advanced SAS Programming of Customer Satisfaction integrating data from several in-house and external databases. Heavy use of macro’s, SAS/CONNECT, and BASE/SAS procedures. Incorporated statistical scoring modules using PROC Factor and PROC Cluster. Visualization of Data using Tableau Software.

2009 INDEPENDENT CONSULTANT

* Software Consulting Firm: SAS Dashboard and Portal Development for Government Agency – SAS BI Server, SAS Portal, SAS/GRAPH, SAS BI Dashboard Studio, Web Report Studio

* Major Bank: Business Analysis and SAS programming for Mortgage Loan, Risk and Repurchasing system. Environment: SAS for Windows v9, SAS under UNIX/AIX. SAS/CONNECT. Unix/Linux/AIX Shell Scripting, Perl Scripting, Oracle ETL

* Consulting Firm: Written evaluations and recommendations for 3 BI Platforms: COGNOS, SAP, and ORACLE

2007 - 2009 HUDSON INSURANCE GROUP / HUDSON HEALTHCARE – Sr. Analyst

* Project Lead for Data Analytics, Electronic Data Management, and Search Technology initiatives

* Definition and Development of Analytical Processes and Use Cases for IT property and Casualty department.

* Application of advanced Data Mining and Predictive Modeling techniques to Healthcare, Auto, and Fast Food business lines (Cluster analysis, Decision Trees, etc.)

* Documented and presented analytical results to Senior Management

* Comparative Evaluations of software: BI, External Access, and Query and Reporting Tools

* Worked with Data Warehouse Team, and Underwriters to acquired all necessary in-depth knowledge of business processes, ETL feeds, XML formats, and other systems required to produce meaningful analytical results.

* Performed ad-hoc query analysis of Insurance Data using Business Objects.

* Development of various metrics and KPI’s

* Forecasting of loan reserves using SAS and “R”

* ETL and Cube Building using Microsoft BI Stack (SSIS, SSAS, SSRS, MDX)

* Implemented SSIS Procedures to collect data from various sources including: External data feeds using FTP, XML, and CSV connectors, and internal tables and Excel spreadsheets. In addition to standard merging and joining of disparate data, utilized “fuzzy match”, and term extraction transforms for data mining.

* Implemented analytical cube structures using SSAS with up to 10 dimensions with partitions spanning 10 years of monthly data. The data was browsed via Excel Pivot tables which were connected to the SSAS server.

1997 – 2007 INDEPENDENT CONSULTANT specializing in SAS Software

Clients included JP Morgan Chase, Morgan Stanley, Berlex Labs, PriceWaterhouseCoopers, ATT Wireless, Verizon Wireless, Pfizer

Financial/Banking

* Development of Home Price Indexing Database system IT procedures which extracted estimates of home values from external vendors files and integrated the data into internal mortgage and home equity data. Defined necessary data feeds, and data transformations.

* Extraction of data from ORACLE based upon ad-hoc user requests. Standardization of property, and mailing address based upon business rules. Authored program and system documentation.

* Analyzed Mortgage and Home Equity from DB/2 and ORACLE datawarehouse extracts, and performed checks for data validity

* Predicted Credit Default Risk using Oracle Data Miner

* Conversion of an external vendor Marketing Campaign Tracking System to a new In-House SAS based tracking system saving the company approximately $15,000 per month in vendor fees.

* Performed database analysis for many in-house databases, including loan servicing, mortgage and home equity applications, loan payoff , recapture, and credit scoring

* Produced Ad-hoc reports for management, e.g. reports measuring customer refinancing and payoff rates.

* Developed program methodology to track credit line increases

* Implemented data monitoring procedures for an enterprise level

* Anti-Money-Laundering (AML) project for the legal IT department of a major NYC financial institution. Detection of unusual wire transfer activity, transaction history not consistent with prior history, etc. Modified various ETL procedures to achieve results.

Direct Marketing

* Developed SQL queries to extract data from Marketing and Sales ORACLE warehouse, based upon user adhoc requests. Presented and documented results to Senior Management.

* Performed data analysis of historical customer files to identify predictive models. These models included prediction of repeat buyers, and incremental sales generated by email promotions. Segmentation projects included segmentation of Internet vs. Non-Internet catalog buyers, and responders vs. non-responders. Resolution of data integrity issues, and integration of data with over 50 complex internal Excel files. Profiled high, mid, and low value customers.

* Time Series forecasting of product demand

Pharmaceutical/Healthcare

* Developed IT procedures to migrate version 8 clinical trial databases to version 9 under WINDOWS.

* Performed Validation Testing to insure correct migration of program code and data.

* Preparation of Validation Procedures and documentation for the conversion

* Coded validation programs verifying correctness of conversions

* Researched technical aspects of converting clinical Database to SAS UTF-8 Double Byte Character set format

* SAS 9 Planning and Installation

* Defined initiatives for Utilized SAS/Dataflux data cleansing software to profile and segment customers for a global pharmaceutical manufacturing company. Some of the issues involved were standardized of names and address along the various product lines, and matching records utilizing keys contained within multi-value fields. Documented results.

* Worked with vendors and internal management to develop a benefits eligibility database. This database was used to generate daily transaction files to the various PPO's and HMO's which informed them of any changes in employee benefits status.

* Worked with benefits administration managers to translate benefits eligibility rules into actionable IT systems

* Programming and production support for a major Medical Care Utilization and Expenditure Survey

Cellular Industry

* Developed reports which helped management evaluate the effectiveness of various marketing campaigns. Tests of significance of treatments vs. control groups, sample size determination, and reporting.

* Utilitized SAS modeling tools to project data base growth, capacity, and utilization needs for 5 years forward.

* Interfaced SAS Programs with Business Objects and Unica Model One Data Mining Tools

* Analysis of data to detect cellular fraud

* Developed Decision Support Systems which provided OLAP tools for the analysis of revenue, usage, subscriber growth and retention (churn) of cellular subscribers. Development of specialized datamarts

* Create COGNOS Powerplay Cubes using data summarized from Data warehouse

* Developed ETL processes extracted data daily from Mainframe DB2 and ORACLE Databases, and loaded data into a SAS based Decision Support Warehouse

* Development of a sales commission system using SAS which allowed implementation of various customizable commission plans, & allowed data entry & sales report tracking by various categories

EDUCATION AND CERTIFICATIONS:

CITY UNIVERSITY OF NEW YORK AT BARUCH COLLEGE

Masters Statistics Program

CITY UNIVERSITY OF NEW YORK AT HUNTER COLLEGE

B.A, Music

PUBLICATIONS:

* Excellent Alternatives for Moving data from SAS(r) to Excel, NESUG 2004 Proceedings

* Drill Down Till You Drop: OLAP Without Windows, NESUG 1997 Proceedings

Contact this candidate