Scott Carmichael Email & Phone Number

Documented numerous Adobe Workfront scenarios for LBG. This task required me to comprehend thefunctionalities of Workfront and how Fusion was being used to automate the workflows. I presented theinformation clearly and concisely, allowing the client team to fully comprehend the functionality of eachscenario.

Business Analyst (Insurance Data Simplification), (Mar 2020 – Present).• Developed test approach for Insurance Pricing move to R Studio Data Science platform• Gathered requirements (incl NFRs) around production of Modelling Datasets for use with AI/ML pricing engine• Produced User Stories and Epics for build of Enterprise Data Model to support Insurance business• Held workshops on Op Model for Data Validation process on new cloud platform. Produced various artifacts for review as part of process• Produced packs for exec showing progress, next steps and benefit realisation• Helped produce delivery plans, alongside Project Manager• Created Business Case for Insurance Data Simplification, with input from Senior Stakeholders from Insurance business and also Technology colleagues• Facilitation of design workshops for creation of Dimensional Data Model• Captured requirements and produced User Stories for Commercial Insurance Dimensional Data Model and subsequent KPIs Business Analyst (Exadata Migration), (Jun 2022 - December 2022.• Developed strategy for testing SAS outputs impacted by Exadata migration • Developed and documented testing approach• Held workshops on testing approach to discuss and review “strawman” • Produced testing process for SITBusiness Analyst (Cloud Data Platform), (Dec 2019 – Mar 2020).• Produced User Stories and Epics for build of various parts of Cloud Data Platform • Developed test approach and test plan for proving of Data Science part of the platform using Jira• Held workshops to ensure cloud platform was meeting business requirements. Created Traceability Matrix to support this

Leeds, United Kingdom

Technical Business Analyst (Service Sustainability Program), (Jul 2019 – Present).• Mitigating risk across HSBC by ensuring key applications are on the supported infrastructure. • Documented ‘As Is’ position of applications, using tools such as EIMS and CMDB.• Produced an options paper for applications resulting in a ‘To Be’ position.• Produced a test strategy for applications and a run book for implementation.• Gathered Non-Functional requirements Digital Business Analyst (Digital Online Banking Program), (Jun 2017 - Jul 2019).• Scrum Master on daily stand-up Personal Loan Apply feature of FD’s native mobile app.• Compiled Service Acceptance Non-Functional Requirement documentation.• Produced Epics & User Stories for a Move Money feature • Identified & verified feature for FD’s online banking solution.• Ensured that the Move Money journey met expectations • Ensured HSBC group built microservices that was in line with FD developers’ expectations. Solutions Analyst/Project Manager (Digital Transformation Program), (Aug 2016 – May 2017).• Managed the completion of work for a Single Sign On (SSO) development for legacy FD’s call centre application, that included planning the data migration and implementation. Organised and ran discovery workshops for failover• Produced technical documentation for the data centre’s failover of the Telephone Support System• Produced a runbook for failover and co-ordinated its execution.• Produced requirements documentation to support the demise of the Telephone Support System.• Planned Proof-of-Concept events to test the failover process, as well as rehearsals and live events.• Produced packs that illustrated the progress of the failover process and highlighted key risks.

Service Management Toolset Transformation Program.• Requirement Gathering for the integration of ServiceNow (cloud-based) package.• Discovery workshops were run to determine requirements (functional and non-functional). • Analysed System Requirements for data migration and systems' integration.• Produced process models and functional specifications for interfaces between legacy systems and ServiceNow using User Stories, that ensured business requirements were correctly captured and signed-off by senior stakeholders. The specs were also used to support technical colleagues for development and build work, as well as testing colleagues to allow the creation of test scripts.• Produced User Access Management documentation • Supported the build of User, Roles and the Group’s software.• Analysed data using Excel (Index/Match, VLOOKUP, Pivot Tables), • Created extracts for Data Loads using Excel (Index/Match).

Edinburgh, United Kingdom

Reporting Infrastructure Program, (May 2013 – Jun 2015).• Analysed System Requirements for data feeds into the Strategic Risk Data Warehouse.• Produced Interface Specifications for data feeds including such detail as a transfer mechanism, timings, ‘Golden Source’, Source-to- Target data mappings that ensured clear lineage, support to the technical build of feeds into the warehouse, as well as allowing testers to build scripts for data feeds. They also allowed business stakeholders to ensure their requirements were being met.• Ran a workshop with a source platform SMEs • Determined data availability and if that data was Golden Source.• Determined efficiency and identified issues by analysing SQL (Teradata, SQL Server, Oracle). Integrated Credit Risk System Program (Aug 2011 – May 2013).• Analysed and designed new Source System feeds into the strategic Risk Data Warehouse.• Produced high-level design documents that illustrated how the new feeds land in a ‘Staging’ environment and how the data flows through to conformed subject areas (such as Party, Facility etc) and specific data marts.• Also produced: process models after discussions with Stakeholders, where applicable (‘As Is’ and ‘To Be’); Data Mapping documentation for Oracle and Datastage developers; specifications for SQL Server developers; and Impact Analysis documents for the decommission of feeds using Datastage Reports.

Halifax, United Kingdom

BUSINESS ANALYST Oct 2010 – Aug 2011Mortgage Platform Integration Project.• Analysed and functionally designed the completions process for the integration of mortgage platforms for LBG. • Produced process models and presented the ‘As Is’ process and helped determine the ‘To Be’• Produced Functional Design specifications using Use Case. • Compiled Data Mapping documentation for Datastage developers using Excel

Commercial Migration & Integration Project.

Analysed and designed software for the migration of telephony, Internet Banking and commercial customers’ data to the appropriate Lloyds Banking Group platform. • Produced technical design documents and program specifications based on ETL principles. • Designed and built reconciliation software.

Sainsbury’S Bank Migration Project.

Core member of build team responsible for analysis and design of new software as well as amendment of existing software, working with business analysts to drive out requirements. Technical design documents and programs specifications produced.• Co-ordinated 'Shakedown' testing • Worked with DBA, operation analysts and infrastructure technicians • Resolved the testing environmental issues to create a testing environment that is fit for purpose.• Support of System Testing – as Subject Matter Expert for the customer migration process I was tasked with supporting an offshore testing team who carried out system testing. Required analysis and resolution of defects, allocating build work to offshore team and release of fixes into the test environment.• Lead Technician on rehearsals and live migration events: led a small execution team responsible for ensuring the migration batch schedule for customers’ and account migration events ran to completion. Resolved failures, reported to Program Managers.

Edinburgh, United Kingdom

Member of build team that analysed, developed and implemented software on Customer Loyalty Program plus software for Hargreaves Lansdowne’s fund launch project.Supported system and user acceptance testing plus live implementation and post implementation support.

Edinburgh, United Kingdom

Support of System Testing of Bank of Scotland Ireland project and Faster Payments.

Edinburgh, United Kingdom

Systems Analyst on Core Banking System data migration projects and ToDDaSO project

Edinburgh, United Kingdom

Worked on various legacy projects and Core Banking customer and account migration program

Edinburgh, United Kingdom

Worked in Investment area and Remuneration and Commission programme

National Progression Award - Scqf Level 6, Data Science

Education record

AWS Certified Cloud Practitioner PG Dip. Post Graduate Diploma in Information Technology BSc. Planning Studies. Engineering & Construction.