David Jeffries B.Sc

British freelance SAS/SPSS software consultant seeking opportunities Worldwide.

David has extensive knowledge of the SAS product suite including BASE, MACRO, SQL, STAT, ENTERPRISE MINER, ENTERPRISE GUIDE, SAS ETL / DI STUDIO, gained from over 10 years experience as an independent SAS software consultant working with financial companies in the UK and overseas in areas such as data warehouse development, data quality and integration, management reporting, statistical analysis and propensity model building within credit risk and marketing areas. Prior to this he worked for 5 years in database marketing, marketing analytics, propensity modelling and business intelligence with Lloyd's TSB, GE Capital and CACI.

 

Marketing Experience

 

Principality Building Society

 

Development of SAS routines for list selection and analysis, customer cleaning, merge, purge (name and address cleaning, gone away, deceased, MPS/TPS indicators etc), product holding and cross-sell analysis, post campaign respone and value analysis KPI reports.

 

Eagle Star Insurance

 

Provision of analytical and strategic consultancy services. Advising on data analysis and modelling issues, selection of appropriate software tools etc. CHAID and logistic model development and interpretation.

 

Ogilvy & Mather Dataconsult

 

Development of a CHAID customer segmentation and product targeting model for British Telecom. Pan-European data audit for IBM to review current data availability and quality. Reporting and interpreting the results.

 

CACI

 

Pre-sales strategy and needs analysis studies.

Provision of data analysis and propensity modelling services to clients including linear/logistic regression, cluster analysis , chaid and neural networks using SAS Enterprise Miner and SPSS Clementine in the areas of customer profiling, data visualisation, propensity models. GIS analysis.

 

GE Capital

 

Acting as a key interface between Marketing, IT and risk areas to develop MI solutions from simple analysis and reporting procedures (univariate statistics, tabulations, reports etc) to complex CHAID, linear/logistic regression models for customer segmentation, response models etc.

Managing list creation process from selection to mailing house production covering areas such as selection criteria, legal and marketing restrictions, marketing mix allocation, mailing tape delivery and returns.

Post campaign analysis, reporting and interpreting the results.

Risk Management Experience

 

Lloyd's TSB Group

 

Working alongside the Group Credit Risk Manager to build the SAS tools and analytical frame-work that would help management determine if and how best to effect risk transfer & capital relief under Basel II.

Specific tasks included data intergration, ETL and statistical analyse of the current portfolio in order to develop risk orientated segmentations for further analysis.

 

Halifax Bank of Scotland Group

 

Construction of standardised SAS sample datasets for Basel II model development this involved, data cleansing, data merges and data profiling of several mortgage brand prortfolios held in a variety of formats across different platforms in various UK locations.

 

Ulster Bank

 

Working with the credit scoring analysts to redesign, develop and implement Basel compliant scoring models from a spreadsheet PC environment to a SAS server environment with the aim of producing an automated scoring platform from data input to management reports.

 

Bristol & West Building Society

 

Development of drill-down Basel 2 KPI reporting suite for portfolio monitoring(EAD), rating model review(Model stability, predictive content, risk differention, grade migration), Limit setting and overrides.

 

Nationwide Building Society

 

Large scale implementation of Basel II LGD, PD, EAD and Economic Capital risk models and integration of data feeds. Development of standard procedures and best practices for SAS program development, analysis and reporting. Development support to retail risk management teams. Working with IT and business teams to ensure data and system integration met business and technical requirements.

 

SAS Technical knowledge

 

SAS Base

 

David has worked on a number of assignments (HBOS, Nationwide Building Society, Business & Decisions, Logic CMG) in which he has been involved with data quality, data cleansing and data integration issues in addition to developing ETL and scheduling routines for large scale data warehousing applications. The work was carried out using SAS Base macro components.

 

SAS STAT

 

David is fully conversant with univariate and multivariate procedures within SAS STAT including analysis of variance, regression, categorical data analysis, cluster analysis etc and has used them extensively for statistical analysis and reporting, customer segmentation and propensity model development within marketing and risk environments (Lloyd's TSB, Business & Decisions, Ogilvy & Mather Dataconsult, CACI, Eagle Star, GE Capital, Nationwide)

SAS Enterprise Guide

 

David has a good knowledge of using SAS Enterprise Guide both as a RAD tool and as a reporting tool and has used it extensively with Lloyds TSB, Nationwide and Bristol & West Building Societies to develop user reporting and analysis suites. He has also provided user training in the use of Enterprise Guide.

 

SAS Enterprise Miner

 

David has a background in economics and statistics and is fully conversant with all the procedures used within SAS Enterprise Miner and has used it for customer segmentation, profiling and scorecard development within the banking sector (Misr International Bank, National Bank of Kuwait, Eagle Star) He has also provided user training in the use of Enterprise Miner.

 

SAS ETL/DI Studio

 

David has used SAS ETL and SAS DWA to create metadata, define sources, targets and the processes that connect them (Business & Decisions, Logic CMG, National Bank of Kuwait) He is currently following SAS training courses to update his knowledge to the current version of SAS DI Studio.

Business Skills

 

As a established freelance consultant David has proved himself as a highly competent, customer focused results orientated individual able to work in a variety of environments and locations. He is equally capable of operating with minimal supervision or as an effective team member. He ensures effective relationships are built and maintained with peers and their teams, to add value to the client organisation and as a manger he is able to engage and empower teams through skilled people management. These factors can be seen in the fact that despite not having a background in medical science he is able to work successfully in the pharmaceutical and biotechnology environment interacting with multi disciplined and multi cultural teams of scientists and non scientists to develop technical solutions. A recent contract with Eli Lilly was obtained after an absence of six years from the pharmaceutical sector while his ability to think 'outside the box' enabled him to rapidly streamline the clients process flow to deliver the end result of a maintainable and adaptable SAS technical solution.

 

 

 

LookupPage - Brand Yourself Online