|
|
|
|
|
|
|
| Jobs |
| Site Map |
|
|
|
|
|
Sr. Freelance SAS/SPSS Software Consultant (Gwent, UK)
I am a British freelance SAS/SPSS software consultant operating through my own company, Leawell Solutions Ltd. I am seeking long or short term contracts/projects worldwide on a contract basis. I have over 10 years international development experience with financial, marketing and pharmaceutical clients in the UK, Europe and Middle East. I am degree educated and my core SAS skills include: BASE, MACRO, AF/FSP , SCL, ASSIST, INSIGHT, STAT, ENTERPRISE MINER, GUIDE, DI STUDIO. Additional skills include: ORACLE, SPSS Base, SPSS CLEMENTINE, GIS, COBOL.
Oct’ 1982 - Jun’ 1985 Cardiff Business School - University of Wales
Sep’ 1986 - Aug’ 1987 North Staffordshire University
Programming and analysis experience using SAS V5.01 to V9.1.2 under DOS, Windows, MVS UNIX and VMS including: BASE File-handling, dataset manipulation, reporting, descriptive and utilities procedures (including Report and SQL procedures) MACRO macro development, sub-routine development and external Calls. AF/FSP SCL Data entry and editing routines. Front-end menu development. ASSIST Prototyping and code generation. Graphics customisation. INSIGHT Data mining and analysis eg., point identification, distribution analysis, curve fitting and transformations. STAT Statistical analysis and reporting using multivariate, regression, categorical, clustering and scoring procedures. Macro development and parameter passing. CONNECT Development of simple analysis and reporting procedures (univariate statistics, tabulations, reports etc) for client/server applications ACCESS interface to Oracle and IBM databases for updates ENTERPRISE MINER V5.2 Development of profiling and scoring models. Data mining and data analysis. ENTERPRISE GUIDE V4.1 Data exploration and model development. DATA INTEGRATION STUDIO V3.4 Data cleansing and enrichment. ETL development.
ADDITIONAL SKILLS Oracle 8 Developer/2000 Release 2: Currently completing Oracle Certified Professional Program. SQL, PL/SQL, FORMS 5, REPORTS 3. SPSS(v.12) statistical package: 4 years application model development for Windows using Base, Professional, Tables, Applications Developer and CHAID modules of SPSS. Development of reporting procedures using SPSS and INGRES. COBOL: 18 months IBM and HP-Cobol programming experience using structured techniques. PC: Excel to macro level. MS-Word. PowerPoint. MS-Access. Lotus Notes.
May' 2007 – Jul' 2007 HBOS Plc Halifax U.K.
SAS BASE, MACRO, CONNECT, Unix Construction of SAS sample datasets for Basel II Self-Cert Mortgage model development this involves, data quality issues, data cleansing and data integration.
SAS V9.1.2 BASE, MACRO, SQL, ENTERPRISE GUIDE Working alongside the Group Credit Risk Manager to build the SAS tools and analytical frame-work that will help management determine if and how best to effect risk transfer & capital relief under Basel II. Specific tasks include data intergration, ETL and statistical analyse of the current portfolio in order to develop risk orientated segmentations for further analysis.
SAS V9.1.2 BASE, MACRO, SQL, CONNECT, ENTERPRISE GUIDE, Microsoft Access Implementation of Basle 2 LGD, PD, EAD and Economic Capital risk models and intergration of data feeds. Development of standardised procedures and best practices for SAS program development, analysis and reporting. Development support to retail risk management teams.
Jan' 2006 – Feb' 2006 Esure Insurance Reigate U.K.
SAS V9.1.2 BASE, MACRO Provision of SAS technical support in correcting errors identified in data warehouse UAT stage of development/implementation process.
SAS V9.1.2 BASE, MACRO 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.
SAS V9.1.2 BASE, MACRO, SQL, CONNECT, Microsoft Access CRM pilot study. Analysis, development, testing and implementation of ETL routines for external data feeds. Development of key fields for name and address matching and deduplication with in house data files. Creation of mailing and control cells.
SAS Enterprise Miner, SAS Credit Scoring, Microsoft Excel, Windows Generic application scorecard development for emerging markets. Data analysis and mining, advising on potential scoring variables to be captured. Data fusion and extrapolation for sparse variables. Exploring reject inference. Model development using CHAID, logistic regression and MLP modules within SAS Enterprise Miner. Integration of scoring models within existing banking systems. Training in the use of SAS Base and Enterprise Miner/Credit Scoring toolset.
Jun' 2004 – Dec' 2004 Ulster Bank Belfast N.I.
SAS V9.1.2 BASE, MACRO, SQL, STAT, Enterprise Guide, Microsoft Access, Excel, Windows Design, development, validation, calibration and implementation of LGD, DCF regression based forecasting model to meet Basel IRB requirements.
SAS V9.1.2 BASE, MACRO, SQL, CONNECT, Unix Development of SAS procedures and warehouse ETL process code to transform data between Staging Layers and Foundation/Datamarts.
Feb' 2004 – Apr' 2004 LogicaCMG Swindon U.K.
SAS V9.1.2 DWA, DQ, BASE, MACRO, SQL, CONNECT, Linux Development of SAS procedures and warehouse ETL process code to transform 3rd party data between Staging Layers and Foundation/Datamarts.
Dec' 2003 – Jan' 2004 Learning & Skills Council Coventy U.K.
SPSS Generating SPSS production syntax scripts to produce summary statistics relating to European Social Funding project closure reports.
Jun' 2003 - Sep' 2003 HBOS Card Services Cardiff U.K.
SAS BASE, MACRO, STAT, AF, Connect, Oracle, SPSS, Microsoft Access Building Propensity Models for Acquisition and Cross-selling purposes. Undertaking ad-hoc analysis to provide input into marketing and risk metric reports. Automation of KPI risk reports.
SAS BASE, MACRO User acceptance testing of a yield management system. Generating data and statistically testing the accuracy of price-sensitive forecasts and price elasticity parameters produced by the system.
Jun’ 2002 - Oct’ 2002 Pfizer GMBH Karlsruhe Germany
SAS BASE, dBASE-4, CDARS Generation of data cleansing and mapping programs to create datasets of core variables to company standards from data provided by CRO’s and loading of datasets to the CDARS system. Quality control reviews of generated data mapping programs. Reconcile encoded data (Adverse Events, SAEs and Medications etc) with source data, CDARS datasets against CRF entries, dBase data against CRF entries. SAE reconciliation between project and AEM databases to highlight data discrepancies. Development of a program to generate a data clarification dataset and data clarification request forms.
SAS BASE, STAT, MACRO Microsoft Access Quality control audits of generated tables and listings. Coding and amending table and listing programs as required.
SAS BASE, STAT, MACRO Microsoft Access Programming summary tables for statistical analysis using SAS reporting procedures. Programming statistical analytical models using Means, Univariate, and GLM SAS procedures in co-operation with the project biometrician. Construction of Microsoft Access database structures for supply to CRO’s - field definitions, formats, range and date constraints etc. Quality control review of incoming datasets.
Jan’ 2000 - Nov’ 2000 National Bank Of Kuwait Kuwait
SAS BASE, MACRO, CONNECT, ACCESS, DWA, MVS, DB2 Responsible for all SAS technical related issues within the Data Warehouse environment. DASD strategy - Creation of a DASD capacity and forecasting strategy for Data Warehouse information. Architecture - Creation and management of backup and recovery procedures. Standards and procedures - Specification and production of all Data Warehouse operational procedures including hardware and software environment, SAS guidelines and standards. Reporting - Creation and implementation of reporting infrastructure. Application maintenance and development - CRM, Data Mining, Customer segmentation, scoring and profitability. Linear and logistic regression. Development and implementation of process and quality improvement programs and procedures.
Jun’ 1999 - Oct’ 1999 Pfizer Central Research Ltd Sandwich UK
VAX VMS, UNIX, WIN NT, SAS BASE, MACRO Design, development and implementation of an analysis and reporting package for population pharmacokinetic studies. Multi-way merges of demographic, labs, medication datasets using SAS BASE and MACRO.
VAX VMS, UNIX, SAS BASE, MACRO, ORACLE SQL Designing and developing quality control procedures and validation routines within Biometric analysis and reporting using SAS BASE, report/tabulate procedures, macros, SAS SQL and Oracle SQL
Apr’ 1998 - Jun’ 1998 KLM Royal Dutch Airlines Amsterdam, Netherlands
IBM MVS/TSO, SAS BASE, AF/SCL Maintenance of Flight Revenue Management systems using SAS BASE and MACRO. Specification and implementation of Y2K test plans. Client training.
IBM MVS/TSO, SAS BASE, COBOL Modification of actuarial analysis system. Consolidating multiple data input channels and program modules into a single system using SAS BASE and MACRO. Testing and modification of COBOL programs.
Windows 95, SAS BASE, SPSS Base, Tables, CHAID Development of a Marketing Management Information System for a major retail stockbroker.
Use of SAS BASE to construct a summary dataset from Customer/Transaction data. Development of market segmentation models using SPSS CHAID.
Windows NT, SAS BASE, STAT, INSIGHT, GIS, NNA, SPSS CHAID, Base, Neural Connection, Professional, Mapinfo, Model 1 Provision of analytical and strategic consultancy services to the international Life insurance companies. This includes: Data audits and data exploration using SAS BASE and INSIGHT.
Development and implementation of statistical models in areas such as: Market Segmentation, Attrition/Retention, Media Selection, Claims Analysis, and Product Development. Advising on marketing strategy: Campaign types, Media/Product types, Performance appraisal, New business opportunities.
VAX VMS, SAS BASE, ORACLE SQL Maintenance and development of clinical trial reporting procedures. Extensive use of Macros, tabulate and put statements to generate reports for FDA submission.
Jul’ 1996 - Dec’ 1996 Glaxo Wellcome Plc Ware UK
VAX VMS, SAS BASE, STAT, AF/SCL, SQL, ORACLE SQL Development of a interactive statistical analysis and reporting module for pre-clinical toxicology studies. The application consisted of a number of AF program entries and extended tables to manipulate Oracle data extracts. Statistical analysis made use of the FREQ and MTTEST procedures within SAS STATISTICS.
Mar’1996 - Apr’ 1996 Welsh Health Common Services Authority Cardiff UK
UNIX, INGRES/SQL, SPSS Development of management information and statistical reporting procedures using SPSS(V6.1/4.0) and INGRES, for use by central government departments, health service administrators and clinical personnel.
Sep’ 1995 - Dec’ 1995 Ogilvy & Mather Dataconsult Limited London UK
UNIX, SAS, SPSS, MAPINFO, EXCEL/VISUAL BASIC Development of a product targeting model for British Telecom. Preliminary data analysis using the descriptive and multivariate procedures of SAS BASE and STATISTICS. Model development using SPSS CHAID and the logistic regression procedure. Pan-European data audit for IBM to review current data availability and quality. This involved the creation of multiple large-scale datasets from client tapes and the use of SAS BASE reporting, descriptive and utility procedures to analyse the data by country, product, etc. Development of end-user ‘packaged’ solutions for analysis and reporting purposes using SAS BASE, STATISTICS, AF modules and spreadsheet OLE/DDE. Software package development using EXCEL/VISUAL BASIC macros. GIS development using MAPINFO.
Previous Employment Sep’ 1994 - Jun’ 1995 CACI Limited Direct Marketing Division London UK
WINDOWS, UNIX, VMS, SAS, EXCEL, MAPINFO, NEURAL NETWORKS Pre-sales strategy and needs analysis studies. Project management. Provision of data analysis and modelling services to various clients including Gallaher Tobacco and Reader’s Digest. Analysis would use traditional techniques as well as Neural Networks. A typical project would make use of SAS BASE utility procedures for merging and extracting datasets, SAS INSIGHT for exploratory analysis, the clustering procedures of SAS STATISTICS to identify market groupings, multivariate and regression procedures to formulate a prospect targeting model and scoring procedures to rank the database. Development of simple analysis and reporting procedures (univariate statistics, tabulations, reports etc) for client/server applications using SAS CONNECT and Base procedures.
Aug’ 1991 - Aug’ 1994 GE Capital Global Consumer Finance Ltd Bristol UK
WINDOWS, MVS/TSO, SAS, COBOL, EXCEL, MAPINFO Provision of database marketing and analytical support to the Burton Group Plc. Extensive use of SAS BASE, STATISTICS, FSP, AF and COBOL for: Market Segmentation And Profiling Development of customer segmentation routines and scoring models. This involved the creation and manipulation of multiple large scale datasets sourced from cartridge and tape and the generation of analysis reports using BASE, STATISTICS and FSP procedures. Model development used Logistic regression and CHAID techniques. Marketing Analysis And Business Support: Development of EIS modules using the SAS macro facility and AF/FSP front-ends for use by marketing and credit departments. Development of address matching and cleaning routines, generation of mailing tapes and address labels using BASE functions. Development of Macro-based batch reporting utilities using Print, Frequency and Tabulate procedures. Project management and end-user training.
Nov’ 1989 - Jul’ 1990 TSB Marketing & Credit Services Brighton UK
WINDOWS, MVS/TSO, SAS, COBOL Development and support of application and performance scoring models. This included: The creation and manipulation of datasets from a variety of source systems using SAS file handling and dataset control statements and data step functions. The development, testing and implementation of multivariate scoring models using SAS BASE and STATISTICS. Development of credit tracking reports to provide summary statistics using the descriptive and reporting procedures of SAS Base.
WINDOWS, MVS/TSO, SAS, MAPPER Responsibilities included: Branch Business Development: Development of a multivariate business forecasting model based on geodemographic, lifestyle and catchment area data. Implementation of the model using UNISYS MAPPER, SAS BASE, STATISTICS and AF front-ends. Development of GIS systems for catchment area analysis.
Contact: Contact information available to DataShaping clients. URL: www.datashaping.com/resumes16135r.shtml |
