Mark O'Neill Email and Phone Number

• Part of Automation team responsible for automating manual HR processes• Agile working environment using Jira (including JQL), Confluence and other collaborative tools to aid daily kanbans, sprint planning/retrospective sessions and backlog refinement.• Engagement with manual process owners and subject matter experts in order to gather requirements and effectively define solutions. • Extensive use of Power Automate, including Power Automate for desktop for RPA functionality. • Creation of Visual Basic Scripts for scripting in SAP GUI as part of RPA solutions.• Experience with both Canvas and Model-Driven Power Apps.• JavaScript and PCF implementation as part of model-driven app solutions.• Use of SharePoint and Dataverse as data/file management solutions.• Usage of Power BI to create dashboards that allow stakeholders to visualise process data.• Involved in the governance and implementation of Power Platform components in the organisation, including Power Apps, Power Automate for Desktop and Dataverse implementation. This includes the formation of an environment strategy and input into general platform behaviours and principles.• Created a systems diagram through Microsoft Visio depicting all IT system integrations within the HR division. Presented this output to senior management, which was then used in the process of selecting a new core HR system for the organisation.• Main developer of HR service portal for colleague queries/requests using Ivanti Service Manager. This involved end-to-end automated solutions for all colleagues, as well as differentiated offerings for HR staff members to efficiently manage workload. Varying from request design to user access management (UAM), single sign-on (SSO) configuration through Azure Active Directory, back-end logic and more.• Use of InfoPath prior to introduction of Power Apps. Maintenance of existing InfoPath forms.

- Part of Data Profiling team responsible for profiling the data of all bank source systems- Working closely with data/system owners to identify any data issues or focus points- Use of tools such as Informatica Developer, Analyst & Axon, Teradata Studio/Assistant- Analytical and problem-solving skills to identify data issues and inconsistencies in the system- Use of SQL to identify and investigate issues and trends in the data. Create views and profiles based on this analysis- Working collaboratively with the broader team in data profiling, data lineage and beyond- Agile environment using Jira, Confluence and other collaborative tools to aid daily stand-ups, sprint planning/review sessions and backlog refinement of tasks

- Involved in the onboarding of new cloud service providers to the organisation- Responsible for analysing reports and approval of patching of the cloud infrastructure- Jointly responsible for rightsizing push within Amazon Web Services (AWS) as a cost-saving measure for the organisation. This included the use of AWS Cost Explorer, AWS Billing, AWS Cost Management - Monitoring of AWS usage and identification of opportunities for rightsizing, leading to substantial financial savings for the team and organisation as a whole- Solely responsible for the extensive use of Microsoft Power Automate in automating the cloud service provider onboarding process for the team. This included implementation of OneDrive, SharePoint, Microsoft Forms, Email/Outlook and other services used to fulfil the solution- Collaboration with colleagues previously responsible for the manual onboarding solution and deriving the best implementation from their input and my own knowledge/experience

- Part of a team responsible for data migration from multiple and outdated bank source systems to one new single source for customer information - Prepare test cases based on project requirements- Carry out test cases on-site, as well as quality assuring tests run by offshore team- Use of multiple programmes/software for recording test cases/test execution/defects/project plans/documentation storage etc. These include Jira, Confluence, HP ALM, internal systems- Extensive writing and use of SQL queries and Teradata in carrying out tests, querying data-Contributing to and infrequently leading planning/remediation meetings and calls- Creation and updating of Runbook used for QA testing during project deployment and all previous dry runs/dress rehearsals- Adaptability to problems needing quick solutions, particularly during the deployment period- Also involved in User Acceptance Testing of the bank's mobile app