Colin Williamson Email and Phone Number

Contract: Senior Business/Data Analyst (14 Contract Extensions)MoSAIC Project: Replacement of the existing LBG Anti-Money Laundering Transaction Monitoring system with a new Big Data solution. Colin led a large team to deliver the data strategy, design, and analysis, ensuring data moved efficiently from source to target. Colin’s input was instrumental to the delivery of the standard Transaction Monitoring capability and he also played a key role in the Correspondent Banking domain analysis.Initially built on the Hadoop platform, the entire solution is now transitioning onto the Google Cloud Platform. The project was delivered to Agile principles, first using Scrum and later Kanban and made extensive use of both Jira and Confluence.Specific Project Responsibilities: • Data strategy development• Logical data model creation• Data design for business functions• Data mapping strategy• Error handling strategy• Swift MT and ISO20022 message strategies• Stakeholder management• Creation of the logical data model which underpins the ETL process• Data analysis within the more complex data domains• Detailed data mapping for the more complex data domains• Liaising with the product vendor to resolve defects and ambiguities in their offering• Creation and detailed requirements to create a Swift MT parser• Creation of a data mapping strategy to ingest Swift MT messages into the solution• Creation of a data mapping strategy to ingest ISO20022 messages into the solution• Mentoring and up-skilling a team of 10 business analysts to allow them to work as data analysts• Performing qualitative reviews of the test results from engineering• Creating test scenarios and assisting in defect resolution for user acceptance testing• Assisting in defect resolution post implementation• Provision of subject matter expertise for Correspondent Banking

Contract: Senior Business and Data Analyst / Change Manager (2 Contract Extensions)Williams & Glynn Delivery Project: Stand-alone challenger bank creation. Colin managed Corporate Internet Banking system integration, data mapping, data analysis, and stakeholder management.Specific Project Responsibilities: • Data mapping• Data analysis• Business Requirements• Process Models• Solution design• Risk management• Stakeholder management• Full project life-cycle from analysis to user acceptance testing• Data mapping of existing RBS data to the new challenger bank database• Substantial data analysis of existing data to validate data requirements, identify data discrepancies and to build a new data repository to drive both external customer communications and internal colleague communications• Documentation, Management and Testing of changes to data requirements driven by data analysis outcomes• Establish Business Requirements for Corporate Internet Banking Smartcard replacement• Establish Process Models for temporary business processes to facilitate data cutover• Establish solution design and functional specifications for Corporate Internet Banking in conjunction with Technology solutions architects and application developers• Comprehensive operational and regulatory risk management throughout the project lifecycle• Provision of subject matter expertise for Payments and Corporate Internet Banking• Establish test scenarios and plans for user acceptance testing• Significant stakeholder management (Business Product Owner, Data Services, Management Information, Technology, Security, Risk & Compliance, 3rd Party Suppliers and Communications)

Contract: Senior Business/Data Analyst (1 Contract Extension)Futures Project: CAP payment system delivery. Colin handled Business Requirements, data modelling, process models, solution design, and stakeholder management.Specific Project Responsibilities: • Business Requirements• Data modeling• Process Models• Solution design• Stakeholder management• Full project life-cycle from analysis to implementation• Establish Business Requirements for payments• Establish Logical and Physical data model for payments• Establish Process Models for full payments functionality• Establish solution design for payments in conjunction with solutions architects and application developers• Significant stakeholder management (Business Product Owner, Data Services, Finance and Technology)

Contract: Senior Business and Data Analyst / Change Manager (8 Contract Extensions)Teller Remediation Project: Regulatory refund program. Colin managed database strategy, data analysis, data mapping, Business Requirements, and risk management.Specific Project Responsibilities: • Full project life-cycle from analysis to implementation• Specify, develop and maintain a database and data management strategy to facilitate remediation of complex customer base• Data analysis and data mapping of transactional data to create smart extracts for a local database specific to the complex customer base• Data analysis, cross-checking and testing of data extracts• Management, tracking and reconciliation of remediation activity• Establish Proposition, Business Case and Business Requirements for remediation of customer base• Establish and mobilise new Business Operations Model and Process Models• Comprehensive operational and regulatory risk management throughout the project lifecycle with particular emphasis on ensuring AML regulations were applied• Marketing & Communications Planning (Internal / External / Media Relations) across Group• Significant stakeholder management (Business Divisions, Data Services, Product Management, Security, Risk & Compliance, Legal, Marketing & Communications, Operations, FSA and Irish Regulator Central Bank of Ireland)

• Program to deliver the Bankline product, RBS’s Corporate Internet Banking package. • Provision of high-level and detailed requirements for Payments, Administration and Billing releases• Provision of high-level and detailed designs for Payments, Administration and Billing releases• Provision of project planning, management and governance within the scope of the above releases• Full project life-cycle from analysis to implementation• Stakeholder management (Business Divisions, Product Management, Strategy & Architecture, Technology)