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.
• 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:

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.
• 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.
• 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.

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.
• 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.

• 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.
• 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.

• 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.

• 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.

• 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.

Accounting

Business Studies