Scott Macpherson Email & Phone Number

Edinburgh, United Kingdom

Edinburgh, United Kingdom

Royal Bank Of Scotland Group, Younger Building, Edinburgh Uk

SAS Management Console, DI Studio, Enterprise Guide, SAS Add-In for Microsoft Office, SAS Information Delivery Portal, Information Map Studio, Web Report Studio, SAS Scalable Performance Data Server, Platform RTM, SAS Base, Macro, SQL, CONNECT, ACCESS, HPSA, Unix, Linux. Project Scope:Working within a delivery team of SAS Consultants, RBS IT, IBM and Infosys teams, plan and build a clone of the RBS SAS Grid Platform across the four W&G SAS Grid Platform regions. The migration of content included the movement, validation and synchronisation of:• User base consisting of analytical users and web users and associated user developed content and data. • Data from both Base and SPDS SAS libraries and a variety of other data types.• Batch processes.• Web based tools.• Infrastructure configuration and security settings.Specific Responsibilities included:• Administration of four SAS Regions.• Promotion of content between regions using a standard program approach.• Provide feedback on all design documentation.• Create standard data migration program templates for moving SAS content between different library types and regions.• Program migration analysis, code rewrites, planning and execution.• Storage space analysis and design. • System installation and configuration validation and testing.• System issue analysis and resolution.• Establish user and administration account creation processes and documentation.• System Security, Operating system, Metadata ACT’s, SPDS ACL’s, Portal, Base library security.• SAS Scalable Performance Data Server. Established and documented the standards and programs that are used to govern the SPDS ACL security used across the library structure. Creation of a suite of utility programs to simplify the maintenance.• User issues analysis and resolution • Knowledge transfer to developers and new administrator teams.

Royal Bank Of Scotland Group, Head Office, Edinburgh

SAS Management Console, Enterprise Guide, SAS Information Delivery Portal, SAS Base, Macro, SQL, CONNECT, ACCESS, DB2, Teradata, Linux, HTML and XMLProject Scope:Sole SAS Developer working in conjunction with teams within, RBS IT Department, AML and Sanctions, RBS Change Management, Third Party Case Manager team and Business system users. Delivery of a mechanism to take IT generated Customer Risk Assessment data and drive business decisions using this data as it changed on a daily basis. The refinement of Business needs and requirements changes resulted in two developments of which version 2 was implemented. Role Responsibilities included:• Version 1 – Creation of a series of daily batch SAS programs to categorise cases, add supporting information, exclude cases. Automatically generate case information as a series of XML files for addition to a workflow tool for processing by case officers.• Creation of Transaction Monitoring Programs and reports. • Creation of Know Your Customer analysis programs and reports.• Dealing with Ad-hoc requests for data analysis and reports. • Requirements Gathering.• Prototype a SAS based workflow tool.• Represent Business and Change Management in all technical discussions.• Version 2 - Creation of a series of daily batch SAS programs to categorise cases, add supporting information, exclude cases. Automatically generate case information as a series of Excel files delivered via SAS portal Stored Processes for processing by case officers.• Systems and UAT Testing.• Provide tools to allow users to update SAS tables in a secure manner.• Provision of a series of Assurance Reports to validate the data integrity.• Provision of Case Historic reports.• Establish and train a development support team.

Royal Bank Of Scotland Group, Head Office, Edinburgh

SAS Management Console, DI Studio, Enterprise Guide, SAS Add-In for Microsoft Office, SAS Information Delivery Portal, Information Map Studio, Web Report Studio, SAS Scalable Performance Data Server, Platform RTM, SAS Base, Macro, SQL, CONNECT, ACCESS, Microsoft Project, Test Director, Secure CRT, Secure FX, HPSA, Unix, Linux. Project Scope:Within a team of SAS UK Consultants, RBS IT, and Applabs Testers RBS and SAS planned and executed a migration of a single server 9.1 Unix SAS Platform to a 9.2 Linux SAS Platform, utilising SAS Grid on multiple servers. To date, the largest grid, data structure and migration SAS have undertaken. The migration covered the movement, validation and synchronisation of:• Large number of analytical and web users and associated user developed content & data. • Data from Base & SPDS libraries and other data types.• Batch processes & Web based tools.Responsibilities included:• Gain a detailed understanding of the existing 9.1 system and proposed 9.2 system in order to be able to represent the Administration team throughout the project and stand in for the project lead whenever required.• Review SAS design documentation.• Creation of project plan with SAS.• Data migration analysis plan & execute.• Program migration analysis, plan & execue.• Storage space analysis & design. • Test team software training & advice.• System install and configuration validation & testing.• System issue analysis & resolution.• Establish user and administration account creation procedures.• System Security, Operating system, Metadata ACT’s, SPDS ACL’s, Portal, Base library security.• Establish and document standards and programs used to govern the SPDS ACL security across the library structure. Create a suite of utility programs to simplify the maintenance of such a complex set of requirements. • Represent the Platform Administration team at user forums throughout the life of the project.• User issues analysis and resolution

SAS Management Console, DI Studio, Enterprise Guide, Information Map Studio, Web Report Studio, SAS Base, Macro, SQL, CONNECT, ACCESS, AF/SCL, SAS/Intrnet, SAS/ODBC, TSO, OPC, MVS-OS/390, MVS-z/OS, ISPF, DB2, Datacom, Linux. ● Lead the AEGON Solvency II SAS development team. ● Migration of AEGON SAS user base from a PC SAS/Mainframe SAS structure to a SAS Intelligence Platform 9.2 Linux based structure. ● Lead the design, delivery, and installation stream of work, for the SAS Intelligence Platform 9.2 as it was installed across 3 regions. This also entailed resolving a range of configuration issues. ● Development of SAS Security structure for the AEGON SAS Platform.● Creation of standard methodologies used company wide for developments in DI Studio, SAS Enterprise Guide, Stored Process development. ● Creation and administration of SAS Portal structure.● Creation of SAS portal based applications, several of these were former SAS IntrNet applications or SAS/AF applications along with several new applications.● Develop and enhance the Financial and Actuarial systems.● Management of the development queue and provide feedback to customers on priorities and progress.● Management of team of developers, administrators and contractors.

SAS Base, Macro, SQL, CONNECT, ACCESS, AF/SCL, SAS/Intrnet, TSO, OPC, MVS-OS/390, MVS-z/OS, ISPF, DB2, Datacom. ● Management of team of developers.● Support and development of the Finance Box Management System.● Develop and enhance the Financial and Actuarial systems.● Creation of a series of user applications for uses such as Fund Price analysis, Fund movement investigations. ● Development of AEGON SAS development standards. ● Provision of technical leadership to support BAU activities.● Mentoring junior developers in SAS best practices.● Consultant for all design aspects for Finance and Actuarial systems

SAS Base, Macro, SQL, CONNECT, ACCESS, AF/SCL, SAS/Intrnet, TSO, OPC, MVS-OS/390, MVS-z/OS, ISPF, DB2, Datacom. ● Redevelopment and enhancements to Actuarial systems. Major rewrite of systems to facilitate tighter data modelling timescales and ensure systems reliability and stability. ● Development of a wide range of new Actuarial systems.● Review development work and provide feedback based upon the reviews.● Providing technical leadership to support the ongoing BAU activities.● Mentoring junior developers in SAS best practices.● Consultant for all design aspects for Actuarial systems.

SAS Base, Macro, SQL, CONNECT, ACCESS, SAS/AF, SAS/Intrnet, TSO, OPC, MVS-OS/390, MVS-z/OS, ISPF, DB2, Datacom. ● Development of a series of SAS IntrNet Applications. Example Applications : Renewal Arrears Tracking and automatic mailing system, SEBO customised statements system, Policy data listings system used company wide. ● Support and enhancement of SAS/AF Frame applications.● SAS Mainframe upgrade from Version 6 to Version 8. Full environment upgrade affecting company wide SAS Users and existing suite of SAS batch applications.● Integration of new Policy systems into existing suite of SAS data feeds and reports.● Providing a variety of ad-hoc developments as per customer demand, using a range of SAS modules to provide BI results in required forms of output. ● Development of batch applications using various SAS modules to produce flexible, documented applications to suit the needs of a wide customer base both internally and externally. ● Support and mentoring of both IT and Non-IT SAS User base.

Accounting

Business Studies