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

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

• 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.
• Produced User Access Management documentation

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

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

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.