Stuart Swarbrick

• Designed and developed enterprise wide Database solution to enable modelling of Behaviour Score to assess the customer risk based upon a strategy based model and meet OCC requirements. • Developed strategic approach to customer retention, acquisition & customer marketing based upon strategy based Behaviour score. • Reduce exposure to bad debt through risk-based credit line management. • Designed and developed new Risk Database to provide a simpler and more robust architecture using SAS9 technologies.

• Developed project & cost/benefit analysis documentation for implementation of Secure SAS connectivity to remote servers. • Provide SAS support for Basel project. • Performance monitoring and capacity planning. • Provide technical expertise in support of projects to implement SAS Version9 & SPD Server 4.2.

• Technical lead in delivery of consultancy projects to implement BI solutions. • Provided project support in scoping BI solutions. • Identification of potential future consultancy opportunities through discussions with customer. • Develop & Manipulate complex data using advanced programming techniques and SAS software products.

• Technical lead for large scale projects to delivery enterprise-wide solutions from proof of concept to delivery. • Development of Needs Assessment, Scoping, Project Plan, Technical & User documentation. • Design, development, testing and implementation of Business Intelligence solutions to meet customer requirements. • Development of SAS solutions including the use of SAS Base, Macro, SPD Server, Connect (to RDBMS including terradata, Oracle, DB2, Websphere, etc.. & MP Connect), DI Studio, SAS/SQL, etc...

• Developed Mainframe and PC-based solutions to enhance SAS-based Financial Management & Planning solution employed by Rolls-Royce Aerospace. • Realise cost savings to Rolls-Royce through analysis of customer ordering practices and supply chain management. • Provide SAS support & expertise to Rolls-Royce Aerospace SAS User community. • SAS Installation Support • Provided development & support expertise in the development of SAS applications using following SAS technologies: BASE, MACRO, STAT, AF, FSP, FRAME

• Oracle Database management, reporting, analysis of Health Authority data. • Forecasting of primary care data to assist contract management & monitoring using SAS. • Carried out statistical analysis on behalf of the health authority. • Implemented a programme to merge database systems of the 2 merged health authorities and improve data quality. • Investigation and analysis using SAS Base, STAT, MACRO, ACCESS, GRAPH, SQL

• Managed Database Management team. • Produced detailed activity analyses and reports using SAS (BASE, MACRO) to facilitate GP Fundholding budget setting. • Developed SAS application (AF, FSP) to provide a simple menu driven solution to contract monitoring and the completion of statutory returns. • Developed ORACLE load routines for loading Inpatient & Outpatient patient records into ORACLE database. • Temporary role during merging of health authorities.

• Coordinated completion of statutory annual returns to the Regional Health Authority • Developed SQL programs to facilitate contract monitoring. • Provided analysis to support contractual requirements during merging of health authorities.

• Provided performance monitoring and identification in trends in health related data in the region. • Learned SAS including the following modules: BASE, STAT, MACRO, GRAPH, MAP, AF, FSP, ACCESS. • Provided statistical analysis service to the region. • Constructed menu driven SAS application (AF, FSP) on behalf of Drug Advisory Service to meet contractual and statutory information requirements, and carry out basic validation of data. • Developed and maintained number of other SAS applications