Paul Dutton Email & Phone Number

London Area, United Kingdom

Designed and Implemented the SAS GDPR Solution on Legacy SAS 9.1 PlatformDesigned and Implemented full migration of Legacy SAS 9.1 platform over to SAS Viya on AWS CloudAssisted with Data Center migration to AWS CloudAssisted with Desktop migration to Azure CloudDesigned and Implemented AWS Neptune Graph Database for Platform Lineage tracking and visualiation via Graph Explorer

Ware, England, United Kingdom

• Provide professional SAS consultancy across many sectors.• Solutions architect.• Senior SAS programmer.• Computer Vision and Image Processing.• Machine Learning and Artificial Intelligence Solutions.• Create professional technical documentation.• Application development using the full software development life-cycle.• Infrastructure provisioning and application installations.• Training and support.• Limited company administration and accounting.

Ware, England, United Kingdom

Architect, Design and Implementation of a new Production Computer Vision system using SAS Viya across multiple sites and continents.Including: Sizing activities, Hardware and Application Design Specifications, Environment Provisioning, Security, Model and Scoring code development, system interfacing, UI development, full end to end deployment.Implementation of SAS Viya 3.4 Computer Vision System to enable Computer Vision through the use of deep learning models, image matching on image… Show more Architect, Design and Implementation of a new Production Computer Vision system using SAS Viya across multiple sites and continents.Including: Sizing activities, Hardware and Application Design Specifications, Environment Provisioning, Security, Model and Scoring code development, system interfacing, UI development, full end to end deployment.Implementation of SAS Viya 3.4 Computer Vision System to enable Computer Vision through the use of deep learning models, image matching on image data direct from the manufacturing liens, to reduce waste.Working as part of NLD Consultants Limited to migrate their current Solaris SAS 9.3 implementation over to Red Hat Linux SAS 9.4.• The system covers 27 sites worldwide.• Work with user groups to ensure a smooth transaction.• Write sync scripts.• Migrate metadata.• Configure batch runs.• Perform reconciliation and testing on the outputs from the batch.• Minimise the impact on the business during cut-over.• Decommission unused reports, data and code lineage bases. Show less

Ware, England, United Kingdom

Working as part of NLD Consultants Limited on the Full-lifecycle solution delivery for end-to-end process and control monitoring for drug manufacture using SAS 9.4 Visual Analytics.• Solution Design Documentation.• Data Architecture Definition.• Physical Infrastructure Design, Sizing and Specification (Multi-Continent, 15 node, 178 cores, 2TB RAM).• SAS 9.4 Installation and Configuration.• Detail Data Flow and ETL Design.• Supervision and Control of SAS provided… Show more Working as part of NLD Consultants Limited on the Full-lifecycle solution delivery for end-to-end process and control monitoring for drug manufacture using SAS 9.4 Visual Analytics.• Solution Design Documentation.• Data Architecture Definition.• Physical Infrastructure Design, Sizing and Specification (Multi-Continent, 15 node, 178 cores, 2TB RAM).• SAS 9.4 Installation and Configuration.• Detail Data Flow and ETL Design.• Supervision and Control of SAS provided developers for development activities.• Support for handover to BAU and User Training.• Successful ‘go-live’ for UK and France in September 2015. Planned widespread rollout for all appropriate GSK sites (15 sites/countries). Show less

London Area, United Kingdom

December 2017 – December 2019Architected, Designed and Implemented the new SAS 9.4 platform ready for multiple SAS 9.2 migrations.Designed the SAS GDPR SolutionDecember 2016 – December 2017Designed, Built and Implemented Avaya Telephony extracts in SAS 9.2 using SAS Access to Informix and ODBC to obtain data that fed foundation structures ready for mart and report consumption.August 2014 – December 2016Acted as primary DLG SAS experts from planning through to… Show more December 2017 – December 2019Architected, Designed and Implemented the new SAS 9.4 platform ready for multiple SAS 9.2 migrations.Designed the SAS GDPR SolutionDecember 2016 – December 2017Designed, Built and Implemented Avaya Telephony extracts in SAS 9.2 using SAS Access to Informix and ODBC to obtain data that fed foundation structures ready for mart and report consumption.August 2014 – December 2016Acted as primary DLG SAS experts from planning through to delivery for the migration of the core Claims MI SAS EBI platforms (9.2/9.3) from RBS datacentres into Cap Gemini datacentres. Key contributors for: • Migration Strategy and Approach.• Planning and Business Communications.• Interface Considerations and Testing.• SOE/Run book Contributions.Additionally, we were also the hands-on, implementation resource for cutover rehearsals, cutover ‘live’ and any technical pre-requisite activities.November 2013 - August 2014SAS BI Developer (Base / Enterprise Guide / Web Report Studio / Information Maps / BI Dashboard / OLAP Cube Studio) - SAS Analyst / Programmer currently for a new role within a large Bromley based Insurance Company on a contract basis.Work with a team of SAS Analyst Programmers providing a service to various areas of the business by creating and maintaining robust, reliable, accurate and timely data resources and MI reporting processes to support business decision making and risk management.Using following Business Intelligence applications:• SAS Base• SAS Enterprise Guide• SAS Information Maps• SAS BI Dashboard• OLAP Cube Studio• SAS Management Console• LSF Platform Scheduler Show less

London Area, United Kingdom

• Engage with business through the requirements gathering phase to design wireframe prototypes.• Documenting the business requirements in line with established processes.• Managing internal stakeholder expectations in relation to business requirements.• Undertake iterative development of report wireframes.• Develop dashboards, reports, OLAP cubes, analytic models in line with business requirements.• Provide guidance and direction to business users in information presentation… Show more • Engage with business through the requirements gathering phase to design wireframe prototypes.• Documenting the business requirements in line with established processes.• Managing internal stakeholder expectations in relation to business requirements.• Undertake iterative development of report wireframes.• Develop dashboards, reports, OLAP cubes, analytic models in line with business requirements.• Provide guidance and direction to business users in information presentation techniques to maximise ease of interpretation & understanding.• Develop reports in line with established style guides.• Working closely with data modellers and mart development resources to maximise report performance.• Facilitate the integration of BI deliverables into BAU through training.• Provide input into the business intelligence design standards.• Drafting test strategies, scenarios and implementation of testing and quality assurance processes.• Update metadata repositories and manage data governance change control processes.• Provide operational support to end users of the BI products.• Facilitating transfer of key analysis and BI development skills to core business personnel.• Contribute to the delivery of the Business Intelligence Strategy and provide insight to shape the business intelligence direction of the organisation. Show less

Ware, England, United Kingdom

Provide professional SAS consultancy across Financial, Marketing, Pharmaceutical and Public sectors.

Ware, England, United Kingdom

• SAS 9.3 Enterprise BI installation (Sandpit, Dev, Test and Production environments).• Migration of the current 9.1.3 SAS Data Warehouse system (originally designed and implemented by myself) to the new SAS 9.3 architecture (Users, Jobs, Schedules, Stored Processes, SAS code, Security, Libraries and Data).• Documentation of Technical Installation Plans, Reports, Test Cases and Training material.• Liaising with GSK IT to ensure the new server hardware is configured… Show more • SAS 9.3 Enterprise BI installation (Sandpit, Dev, Test and Production environments).• Migration of the current 9.1.3 SAS Data Warehouse system (originally designed and implemented by myself) to the new SAS 9.3 architecture (Users, Jobs, Schedules, Stored Processes, SAS code, Security, Libraries and Data).• Documentation of Technical Installation Plans, Reports, Test Cases and Training material.• Liaising with GSK IT to ensure the new server hardware is configured correctly.• Working with SAS and the GSK teams to ensure the migration is delivered on time and to budget.• Parallel running of the SAS 9.1.3 and 9.3 systems to ensure successful migration.• External system interface setup and testing (Oracle, SQL Server, Simca P+, Mounts and File Shares). Show less

Halifax, England, United Kingdom

• Lead developer on the Phase 1 project for the SAS Detailed Data Store for Banking Delivery project – Loans.• Design, document and develop SAS DI Studio data load, mapping and recovery jobs.• Lead a team of developers within tight project time lines.• Amalgamate data from SAS, SAS SPD Server, Teradata and various flat file formats.• Ensuring the DI Studio Jobs and Job Schedule make full use of the LBG SAS Grid implementation.• Supporting all testing, including User… Show more • Lead developer on the Phase 1 project for the SAS Detailed Data Store for Banking Delivery project – Loans.• Design, document and develop SAS DI Studio data load, mapping and recovery jobs.• Lead a team of developers within tight project time lines.• Amalgamate data from SAS, SAS SPD Server, Teradata and various flat file formats.• Ensuring the DI Studio Jobs and Job Schedule make full use of the LBG SAS Grid implementation.• Supporting all testing, including User Acceptance Testing.• Release management and issue resolution. Show less

London Area, United Kingdom

• Improving the customer data processes which combine multiple sources of customer data together. This data is then analysed in order to build deeper and more effective customer relationships and improve strategic decision making, ultimately to build Customer Intelligence (CI).• Own, design & architect development projects for the Data warehouse developers.• Hands on base SAS coding to improve efficiency in terms of required processing disk space and time.• Gain deep business… Show more • Improving the customer data processes which combine multiple sources of customer data together. This data is then analysed in order to build deeper and more effective customer relationships and improve strategic decision making, ultimately to build Customer Intelligence (CI).• Own, design & architect development projects for the Data warehouse developers.• Hands on base SAS coding to improve efficiency in terms of required processing disk space and time.• Gain deep business expertise on client data to inform all technical decisions.• Establish close working relationships with the business and/or client to ensure any decisions that might involve data are well-informed.• Take full responsibility for the quality and success of the Data warehouse.• Mentor others to ensure knowledge transfer and quality of deliverables.• Pro-actively identify opportunities for data improvements.• Identify, design and drive technical or process solutions to data or business problems in such a way that they can be used across many or all of the data warehouses.• Document complex processes and train them out to the rest of the team. Show less

London Area, United Kingdom

• In-house application documentation, design, development implementation and testing.• Using Base SAS, SAS Macro, SAS Integration Technologies and Microsoft Excel VBA to build a user friendly credit risk model definition and execution system that guides the analyst through model development whist adhering to the standards set out by LBG.• Project was delivered to plan and within agreed timeframes.• Integration of the tool into existing SAS 9.1 and 9.2 systems.• This newly… Show more • In-house application documentation, design, development implementation and testing.• Using Base SAS, SAS Macro, SAS Integration Technologies and Microsoft Excel VBA to build a user friendly credit risk model definition and execution system that guides the analyst through model development whist adhering to the standards set out by LBG.• Project was delivered to plan and within agreed timeframes.• Integration of the tool into existing SAS 9.1 and 9.2 systems.• This newly developed solution (MAP) has been adopted across the function and provides a core foundation to support and build on Decision Science modelling and monitoring capabilities.• The credit risk data modelled within the MAP tool takes customer data and produces Customer Intelligence (CI) in the form of models. These models are used to score customer to aid the lending decision processes. Show less

London Area, United Kingdom

• SAS Platform Administration. Application Design, Development, Testing and Deployment.• Creation of batch job scripts. Creation of stored processes.• Supporting HMRC during their cut over from a Pilot BASE SAS system to a new SAS Enterprise BI solution with the full BI toolset.• Definition of SAS Enterprise Guide development standards for use when migrating from the BASE SAS pilot to the new ACE environment.• Review of all SAS Enterprise Guide projects against the defined… Show more • SAS Platform Administration. Application Design, Development, Testing and Deployment.• Creation of batch job scripts. Creation of stored processes.• Supporting HMRC during their cut over from a Pilot BASE SAS system to a new SAS Enterprise BI solution with the full BI toolset.• Definition of SAS Enterprise Guide development standards for use when migrating from the BASE SAS pilot to the new ACE environment.• Review of all SAS Enterprise Guide projects against the defined development standards.• Creation of training material for the new ACE environment.• Development and documentation of SAS macros to simplify complex tasks for the end users. Design, development and delivery of data entry spreadsheets using Excel and VBA.• Full support to all developers on the project advising on the Enterprise Guide development best practices and solving data a full range of processing problems. Show less

Ware, England, United Kingdom

• Worked with various MI Systems and projects at GSK, obtaining data feeds, populating data warehouses, developing new data marts and reports, and integrating data using the intranet Information Delivery Portal (IDP) to streamline information delivery to business, senior management, and stakeholders.• Technical BI lead and solutions architect for GSK global data management, Managing Information (MI), operational data store, and internal projects.• Designed, implemented, and delivered… Show more • Worked with various MI Systems and projects at GSK, obtaining data feeds, populating data warehouses, developing new data marts and reports, and integrating data using the intranet Information Delivery Portal (IDP) to streamline information delivery to business, senior management, and stakeholders.• Technical BI lead and solutions architect for GSK global data management, Managing Information (MI), operational data store, and internal projects.• Designed, implemented, and delivered the GSK MI System, including a SAS data warehouse, business intelligence systems, and tools such as DI Studio, OLAP cubes, BI, and SAS Enterprise Guide. Transferred this system into ongoing support through the complete system life cycle.• Data integration lead for the electronic batch records project, helping design the global data management target architectural standards and preferred direction.• Designed, documented, and delivered a resource management system with an SQL server backend and an Access (ADP) front end using SQL and VBA.• Knowledge of laboratory information management systems, SAP ERP systems, lab and in-process instruments, S88, S95 and ITIL.• Defined and implemented strategies for application lifecycle management of business applications, ensuring applications were maintained appropriately to avoid compromising vendor support or GlaxoSmithKline host security compliance.• Design authority on system design issues arising from business requirements to support the delivery of new and enhanced systems.• Supported new product introductions, manufacturing operations, data quality, data integration, data management, data warehousing, and business intelligence systems. Designed an Excel-based data entry tool with secure review and approval processes using VBA.• Defined and delivered training to the business, working with and advising the business user community to define and develop new requirements for supported systems. Show less

Ware, England, United Kingdom

• Provided high quality data software solutions.• Identified requirements for various database systems.• Ensured all documentation was written in accordance with the company quality management systems and processes.• Provide training for supported systems on a one to one and class room basis.• Designed and developed systems.• Designed and executed test plans for these systems.• Provided ongoing support to users for current and new systems.• Continuous improvement.

Ware, England, United Kingdom

• Managed and developed an access database.• Implemented the procedures for control (including version and change control) of the database and its method of delivery to users.• Documented user guides for the database.• Ensure that users on the company’s SAP system have the correct access for their documented training record.• Building new SAP user profiles.• Design a backup strategy and apply to ensure all data is protected.

Sas® Certified Business Intelligence Content Developer For Sas®9

Sas® Certified Data Integration Developer For Sas®9

Sas® Certified Platform Administrator For Sas®9

Sas® Certified Advanced Programming For Sas®9

Sas® Certified Base Programmer For Sas®9

Computer Science, A

Mathematics, B

10 G.C.S.E'S