Stuart Swarbrick Email & Phone Number

Chester, United Kingdom

• SAS Developer to design and develop solutions to facilitate the migration and integration of data from MBNA Data Warehouse into multiple Lloyds environments.Roles include:
• Design and develop processes for migration of SAS Warehouse into Lloyds SAS, SPD Server and HADOOP environments and ensuring full data consistency and integrity.
• Design and develop reconciliation processes to ensure no loss of information throughout each stage of data migration and ingestion phases.
• Maintain and update UNIX and Python scripts supporting SAS migration code.
• Design solution to meet requirements of Credit Risk and Marketing team to meet their requirements.
• Scope out timescales and deliverables to deliver solutions.

Sheffield, United Kingdom

• Responsible for development of “enhanced” Big Data Global Wholesale Credit Risk and Traded Risk solution to support ongoing Basel model development and stress testing.
• Develop solution for delivery of Wholesale database in DI Studio using cutting edge technology such as HADOOP and LASR.
• Developed reconciliation processes and audit trails in line with regulatory requirements.
• Identify appropriate data sources for history and data going forward to meet data requirements.
• Build relationships within IT, Systems owners and regulatory analyst communities to facilitate development of database solution.
• Engagement with stakeholders across HSBC to ensure data is interpreted correctly and fit for regulatory purposes

Manchester, United Kingdom

Technical Lead for Development and Management of Retail Database.Assist design and development of relational database adhering to Financial Services Data Model to allow all Information and Finance systems to be brought together into a single repository to facilitate delivery of all the bank's Retail Regulatory returns and reconcile against General.

Northampton, United Kingdom

SAS Lead Consultant for a key strategic and highly confidential project at Barclaycard.Support data modelling and design of Marketing database solution for a major bankScoping of project and development of project plan.Technical lead for team of 5 SAS developers.Design, development & implementation of Star Schema database and Mart layer.Optimisation of.

Leeds, United Kingdom

• SAS Technical team lead for 3 year customer project providing support and advising on best practice for delivery of solution in new Leeds Solution Delivery Centre.
• Provided technical consultancy expertise to advise on best practice for delivery of quality analysis of customer data whilst optimising profitability of project and minimising project overheads.
• Liaised with Customer to understand business processes to enable the business to identify potential holes in their business model resulting in non-invoice of services and deliverables.
• Delivered data analysis identifying potential sources of loss of monies due to shortfalls in the customer database.
• Obtained SC level Security clearance.
• Leverage SAS Analytics capability to help the customer better understand their data and provide professional advice for the improvement of their Order & Billing systems to prevent loss of future revenue.

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.

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.

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.

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.

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.

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

Coordinated completion of statutory annual returns to the Regional Health AuthorityDeveloped 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.