Spreadsheet: 823682d1680090207-sumif-formula-to-calculate-cells-in-between-sheets-based-on-cell-dropdown-r-and-ft-template-2-
Sheet: Skillset List

Business Area | Skillset | Wider Team - for information (Internal use) | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANY
Group_IT_Service_Delivery | Access Management Consultancy | Service Delivery | IT system access/application access advice |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group_IT_Service_Delivery
Group_IT_Development | AIA | Life Apps | Development for AIA policy administration. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group_IT_Development
Group_IT_Technical_Operations | Application Packaging | Technical Operations | Provisioning of package applications to the desktop. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group_IT_Technical_Operations
Group_IT_Demand_Management | Automation test | Testing | Automated testing services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group_IT_Demand_Management
Group_IT_Development | Avon IT | Life Apps | Changes and support of existing non-advised personal accident products on behalf of banks, building societies, associations and other insurance companies for the [NAME] subsidiary business. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group_IT_Architecture
Group_IT_Demand_Management | BA Team Managers | Business Analysis | 1st point of engagement for business analysis and resource manager.
Group_IT_Development | BI Life | BI Life | Life BI including MEDUSA and WRAP.
Group_IT_Development | BillingCenter | GuideWire CoE & Solution Design | Development for Guidewire BillingCenter.
Group_IT_Demand_Management | Business Analysis | Business Analysis | Analysis, design and write-up of business requirements.
Group_IT_Demand_Management | Business Relationship Managers | BRM | Link between IT and the Business, helping to maintain a positive relationship, identifying the needs of both the business and IT, driving demand forward and ensuring that appropriate services are developed to meet business strategy.
Group_IT_Service_Delivery | Change Management | Service Delivery | Consultancy of changes (including CAB)
Group_IT_Development | ClaimCenter | GuideWire CoE & Solution Design | Development for Guidewire ClaimCenter.
Group_IT_Development | CLOAS | Life Apps | Development for CLOAS legacy policy administration.
Group_IT_Development | Cloud Analyst | Cloud Infrastructure Services | Senior workstream lead helping to support and deliver Cloud Infrastructure services. Responsible for Cloud Finance Operations including CloudOps Financial Reporting
Group_IT_Development | [NAME] (DBA) | Cloud Infrastructure Services | Manage and maintain Azure SQL database PaaS resources and integrated databases stored on Azure Virtual Machines.
Group_IT_Development | [NAME] | Cloud Infrastructure Services | The Cloud Designer will be responsible for architecting low-level designs across Azure whilst working with the business to ensure  . Own the creation of cloud adoption plans and technology roadmaps and working with customers to help them on the journey to [NAME].
Group_IT_Development | Cloud DevOps Engineer | Cloud Infrastructure Services | To configure, develop and integrate cloud components using Infrastructure as Code (IaC) for one or more applications and / or systems.
Group_IT_Development | [NAME] Engineer | Cloud Infrastructure Services | To maintain the Cloud Infrastructure, fulfil requests and assist in the resolution of technical issues relating to the cloud infrastructure to ensure that all infrastructure components within area of responsibility meet the agreed business and system support requirements.
Group_IT_Development | Cloud Support & Delivery Manager | Cloud Infrastructure Services | Overall responsibility and Team Management of the CIS team
Group_IT_Development | CRM | [NAME] | Microsoft Dynamics CRM
Group_IT_Development | Customer Applications | [NAME] | Development of Domino applications, for example Sonic.
Group_IT_Architecture | Cyber Operations | Security Services | Operational Cyber defence team.  If in doubt start with Security Architecture not cyber ops.
Group_IT_Development | Data Engineering - Azure | [NAME] | New Azure Technologies i.e. [NAME], ADF, [NAME], Function Apps etc
Group_IT_Development | Data Engineering - Integration | [NAME] | Development of Broker integration layer (typically based on IBM WebSphere solutions)
Group_IT_Development | Data Engineering - MI | [NAME] | Development of management of information and generic reporting
Group_IT_Development | Data Mapper | [NAME] | Mapping of NFUM data sources, in particular our GI and Corporate data sources, Customer data and other key data sources
Group_IT_Technical_Operations | Environment Management | Technical Operations | Management of software code across different environments (e.g. Development and Testing)
Group_IT_Development | GI Legacy Applications | Life Apps | Support & development for GI mainframe apps and functions
Group_IT_Development | GuideWire CoE DevOps | GuideWire CoE & Solution Design | Software development management (including tooling) and technical operations covering GuideWire suite.
Group_IT_Development | IFaces Core Dev | [NAME] | Development of IFaces core application changes
Group_IT_Development | IFaces Product Dev | [NAME] | IFaces new product development and/ or amendments to existing products. Also includes user updates, workgroup and sanction amendments, POS changes and other data changes.
Group_IT_Development | [NAME] | [NAME] | Technical iFaces support and changes.
Group_IT_Service_Delivery | Implementation and Configuration | Service Delivery | Implementation and Configuration Management of iFaces/iSeries and Life Applications.
Group_IT_Architecture | Information Architecture | Solution & Info Architecture | Ensuring any proposed change or solution has the data perspective fully scoped and considered at the outset.  This includes consideration of  data impact assessments and potential migration needs for technology transformations.  This also includes consideration for where data is collected, stored, arranged and integrated in line with IT organisational models, policies, rules and standards.
Group_IT_Architecture | Infrastructure Projects | Technology Adoption & Innovation | Delivery of technical infrastructure/architecture
Group_IT_Demand_Management | Innovation | Innovation | IT Innovation for the business and IT
Group_IT_Development | IT Development Manager | ANY | L5 managers across various development teams
Group_IT_Demand_Management | IT Test Professional | Testing | Testing for all system changes including infrastructure, functional testing and regression testing.
Group_IT_Architecture | IT Vendor Management | IT Vendor Management | Management of 3rd party vendors, asset and license management
Group_IT_Development | IT WSL | ANY | Co-ordination of IT delivery components for a project or initiative across multiple NFUM IT teams and third party suppliers.
Group_IT_Technical_Operations | ITSCM | Technical Operations | IT Service Continuity Manager (also known as Disaster Recovery - DR)
Group_IT_Development | Life Applications Other | Life Apps | Covers 3R, AAL, MSIS, Calculations engine, HPVQ, Workflow, Focus 360 and life support resource.
Group_IT_Development | MDM | [NAME] | Master Data Management - Enables single view of the customer.
Group_IT_Demand_Management | MI Tester | Testing | Use for ETL/migration or data/MI testing
Group_IT_Development | P8 | [NAME] | IBM P8 Content development (enterprise document storage)
Group_IT_Development | Package Apps | [NAME] | Support and change for numerous commercially available applications (e.g. Navision, QUBE)
Group_IT_Demand_Management | Performance Testing | Testing | System performance testing for new and existing systems
Group_IT_Development | PolicyCenter | GuideWire CoE & Solution Design | Development for Guidewire PolicyCenter.
Group_IT_Development | Print Exstream | [NAME] | Replacement documentation composition software for Life (New Print solution for all policy documentation)
Group_IT_Development | Print ISIS Papyrus | [NAME] | Development for changes to documentation carried out through Papyrus for Life or GI.
Group_IT_Development | Print Xpression | [NAME] | Development for changes to documentation carried out through Xpression for GI.
ANY | Project Manager | ANY | Day to day running of Project Delivery Team
Group_IT_Service_Delivery | Release Management | Service Delivery | Scheduling of releases and facilitating plans for implementation.
ANY | Scrum Master | ANY | Day to day running of Agile Project Delivery Team
Group_IT_Architecture | Security Architecture | Architecture & Design | Designing and defining security controls for a system to ensure confidentiality, integrity and availability.
Group_IT_Demand_Management | Senior IT Test Professional | Testing | Test professional includes coordination activity
Group_IT_Service_Delivery | Service Design & Transition | Service Delivery | Design and implement the service as proposed by the solution architect for transition of service into BAU.
Group_IT_Service_Delivery | Service Management Consultancy | Service Delivery | Designing, delivering, managing and improving IT service.
Group_IT_Service_Delivery | Service Operations Consultancy | Service Delivery | Incident, request and problem management process consultancy
Group_IT_Service_Delivery | Service Ops Early Life Support | Service Delivery | Post go-live support
Group_IT_Architecture | SharePoint & O365 | Technology Adoption & Innovation | Microsoft Productivity Suite including SharePoint development (Office 365 Applications).
Group_IT_Architecture | Software Asset Management | Vendor Management | Part of the Vendor Team oversees all software license activities
Group_IT_Architecture | Solution Architecture | Solution & Info Architecture | Definition and description of the architecture for a system/application prior to technical, data and security architecture work.
Group_IT_Development | Solution Design | GuideWire CoE & Solution Design | Produce end-to-end Solution Design(s) for large-scale integration projects based on architectural constraints and business requirements.
Group_IT_Technical_Operations | Tech Ops Engineer | Technical Operations | BAU time spent supporting our tier1 apps that is not part of a project
Group_IT_Technical_Operations | Tech Ops Monitoring | Technical Operations | BAU time spent building monitoring or carrying out monitoring that is not part of a project
Group_IT_Technical_Operations | Tech Ops Tooling and Automation | Technical Operations
Group_IT_Architecture | Technical Architecture | Technical Architecture | Building out the technical architecture (e.g. Networks, Servers, Telecoms)  of a system based on solution architecture requirements.
Group_IT_Architecture | Technical Security | Security Services | Part of Cyber. Technical management of  tools such [NAME], IAM (Identity) & Privileged Access.
Group_IT_Technical_Operations | Technical Service Owner | Technical Operations | Technical Service owner covers: DC Networks, Incident Support, Governance Activities, LAN/WAN Networks, Network Security, [NAME], Service Improvement, Technical Service Design, Technical Service Reviews, Telephony & Vendor Activities
Group_IT_Architecture | Technology Adoption | Technology Adoption & Innovation | Provides support for rollouts by building the IT standards and methodology for training.  For example, best use of technology to train
Group_IT_Demand_Management | Test Manager | Testing | Production of test strategy and test leadership
Group_IT_Demand_Management | Test WSL | Testing | General coordination of testing activities and execution
Group_IT_Architecture | Vulnerability Management | Security Services | Cyber Vulnerability and penetration testing