Scott Somerville Email & Phone Number

Edinburgh, Gb

Edinburgh, Scotland, United Kingdom

June to October 2023🎯 Worked with NatWest on their Customer Engagement Platform Project✔Provided Testing Approach Best Practice Documentation✔Created UAT Keystroke Test ScriptsNovember 2023 to April 2024🎯 Worked with Metro Bank✔Supported the Product Owner in coordinating the DataPower Upgrade✔Worked with many Feature Teams to ensure they performed SIT, NFT and Pre-Production testingMay 2024 to date🎯 Working with Metro Bank✔NetReveal Project

Prague, Czechia

✔Created and reviewed requirements documentation, for Deutsche Post DHL, introducing 30+ worldwide process improvements via their online internal ordering tool (Request IT – ServiceNow).✔Developed Agile User Story templates to facilitate a move towards Agile methodology.✔Tested process improvements to existing Classic and Next Generation versions of Request IT.

Prague, Czechia

✔Worked with DPDHL to support their Request IT (internal ordering tool) ServiceNow Platform✔Created and reviewed business requirements✔Engaged with system architects, developers, and stakeholders to assist them through the development process✔Supported user acceptance testing✔Tested Request IT Next Generation platform

Czech Republic

💻 NEORIS is a Digital Business Accelerator and partner of some of the largest companies in the world.🎯 I worked on the evolution of CEMEX Go, the world leading building materials ordering tool.✔ Worked with CEMEX Go Product Owners to create, estimate and implement User Stories to enhance the customer experience for 22 countries around the world✔ Facilitated Development Team Scrum Ceremonies: Grooming, White Boarding, Refinement and Planning✔ Documented CEMEX Go functionality within Confluence

Edinburgh, United Kingdom

💰 Sainsbury's Bank is a UK bank with approximately 2 million customers and £7.7 billion worth of assets, as of Feb 2018. 🎯 Spearheaded a team, of business and project personnel, to produce the processes to facilitate stand up of the bank's new Credit Card Payment Team.✔ Delivered 50 Microsoft Visio process maps one month ahead of schedule✔ Facilitated approximately 70 process design workshops✔ Acted as Payments workstream process Subject Matter Expert✔ Proactively interacted with other project workstreams to ensure an end to end process integrity✔ Conducted process documentation quality control✔ Provided Microsoft Visio training to the Credit Card Payments Team✔ Worked closely with Testers to ensure their User Acceptance Test scripts were accurate (95% first-time test pass rate)✔ Provided weekly progress report to Project Management and Payments workstream

Edinburgh, United Kingdom

💰 Royal Bank of Scotland is a UK bank with approximately 19 million customers and £723 billion worth of assets, as of December 2019.🎯 I documented Payment Services (Credit Documentation, Reconciliation & Investigation, and Treasury) processes to help facilitate the divestment of 308 RBS branches in England and 6 NatWest branches in Scotland into a stand-alone business, Williams & Glyn.✔ Facilitated 1 to 1 Subject Matter Expert process gathering workshops✔ Created approximately 60 Payment Services IBM Blueworks Live 'As Is' process maps✔ Provided guidance and potential solutions in creating Payment Services 'To Be' processes✔ Presented process maps for Head of Function sign off✔ Provided keystroke level quality control of 2,500 Payment Services process maps✔ Proactively provided standards for the creation of Level 4 process documentation

Edinburgh, United Kingdom

📈 Fidelity National Information Services (FIS) is an American company on the Fortune 500 list which offers a variety of financial products and services, including financial software support and outsourcing of banking operations.🎯 I worked on the Sainsbury's Bank Project to ensure the implementation of Anti-Money Laundering (AML) software.✔ Produced source system to AML Enterprise Interface Design Requirements Documentation for the customer's savings products✔ Liaised with FIS AML experts to ensure appropriate AML rule coverage for the client✔ Supported Unit Test and System Integration Testing✔ Implemented AML Enterprise software for the client

Edinburgh, United Kingdom

📈 Scottish Widows is a UK life insurance and pensions company located in Edinburgh and is a subsidiary of Lloyds Banking Group.🎯 I worked within the Solvency II Programme in order to document the client's Profit & Loss Attribution processes.✔ Facilitated 1 to 1 workshops with client's actuaries✔ Produced Interim Profit & Loss Attribution Process Map✔ Produced End State Profit & Loss Attribution Process Map✔ Created End User Computer Tool (EUC) IMAP documentation template to facilitate efficient and consistent delivery of documentation to Internal Audit✔ Produced and delivered End User Computing Tool compliance documentation

Edinburgh, United Kingdom

💰 Royal Bank of Scotland is a UK bank with approximately 19 million customers and £723 billion worth of assets, as of December 2019.🎯 I worked on the project that undertook to transition the banks legacy systems onto Oracle E-Business Suite, with specific responsibility for the Project Module.✔ Worked with Oracle Project Module consultants to ensure that the target system was configured to meet the business requirements for world-wide implementation✔ Participated in cross company workshops ensuring the stakeholder's requirements were accurately captured✔ Responsible for the creation and agreement of a cross module document that defined the End to End flow of how each Catalogue and Non-Catalogue item flowed through Commodity Items into the Project Module and forward into the Asset Register, along with identifying how each transaction should interact with the new Chart of Accounts.

Edinburgh, United Kingdom

📈 Standard Life PLC was a UK pensions company, based in Edinburgh, which is now part of Standard Life Aberdeen (as at 14 August 2017).🎯 I consolidated a multitude of legacy Fund Databases onto one target Funds Database as well as automating additional updates from the legacy FINEX feed.✔ Engaged with stakeholders via 1:1 workshops in order to create the business requirement documentation in respect of the consolidation of Funds Database information✔ Responsible for ensuring the legacy Financial Express daily data feed (FINEX) was developed to incorporate additional data item updates✔ Created 'As Is' and "To Be' process maps in respect of legacy FINEX feed✔ Created test data packs and files to facilitate testing of new FINEX feed

Edinburgh, United Kingdom

🎯 I identified and implemented process improvements to the existing General Ledger Reconciliations following the client's Six Sigma and Lean methodology.✔ Created 'As Is' and 'To Be' process maps in respect of existing General Ledger Reconciliations via 1:1 consultations with Subject Matter Experts✔ Analysed General Ledger Reconciliation Data in order to identify time savings✔ Recommended process improvements✔ Created business requirement documentation in respect of 'Quick Win' and 'Long Term' improvements✔ Implemented quick win improvements - equivalent to 2 full time employees

Edinburgh, United Kingdom

💰 Royal Bank of Scotland is a UK bank with approximately 19 million customers and £723 billion worth of assets, as of December 2019.🎯 I organised and coordinated User Acceptance Testing for Basel II Reporting team, as part of Ulster Integration Programme.✔ Wrote test scope documentation✔ Engaged with nine stakeholder groups around the country (London, Dublin, Edinburgh and Belfast) via daily audio meetings to drive the project forward✔ I successfully coordinated the test environments, test scripts and test plan for the Basel II team, as part of the Ulster Bank Integration Programme (UIP)✔ I was responsible for reporting test progress and defect management into the UIP

Edinburgh, United Kingdom

🎯 Project to implement the Committee of European Banking Supervisors (CEBS) changes, with respect to Common Reporting Framework for the new solvency ratio for credit institutions and investment firms (COREP) and Financial Reporting (FINREP). These changes impacted the regulatory reporting capabilities of Ulster Bank and First Active to IFSRA (Irish Financial Regulatory Authority).✔ Wrote business requirement documentation✔ Engaged with stakeholders via daily audio meetings (London, Dublin and Edinburgh)✔ Designed and built the Chart of Accounts for the main stakeholder (Group Chief Accountants)✔ Designed, built, system tested and user acceptance tested mechanism for uploading Market Risk, Credit Risk, Operational Risk and Capital Adequacy data into the Hyperion Consolidation System (i.e. Supplementary Data Packs)✔ Provided training in the new loading mechanism to stakeholder business areas (SSF Regulatory Reporting and GCA)✔ Met with Irish Regulator (IFRSA) to quiz them on their online submission system✔ Supported the main stakeholder's reporting during parallel run (submission date 31 January 2008)✔ Supported the main stakeholder's reporting of the first live submission (date 21 April 2008)✔ Successfully oversaw the reduction from the existing 43 and 20 working day timelines to 15 working days✔ We had feedback from the regulator that Ulster Bank and First Active were the only banks, out of thirty at the regulator meeting, to successfully submit data during the parallel run

Edinburgh, United Kingdom

🎯 Worked on Project to provide a Strategic Reporting System to meet mandatory Mortgage Lending Administration Return, Retail Mediation Activities Return and Post Data, requirements, to the Financial Services Association.✔ Facilitated workshops with Group Technology and Business Data Providers to drive out data analysis and data gaps✔ Wrote test scripts to test the three separate ETL's (Extract Transform Load) that fed the strategic solution database✔ Following Group Technology's inability to deliver strategic Business Objects Reports, I successfully developed, tested and implemented 'tactical' contingency reports

Edinburgh, United Kingdom

💰 Citigroup is an American multinational investment bank and financial services corporation.🎯 I assisted in migrating client's Fund Administration onto Citigroups's internal fund management system (Multifonds).✔ Developed test scripts for each of my Fund's financial instruments e.g. Deposits, Foreign Exchange transactions✔ Successfully implemented the scripts as part of live migration of funds✔ Provided reconciliation of data throughout parallel daily testing

Edinburgh, United Kingdom

💻 Mossco Internet Cafe was an internet cafe based in Edinburgh. 🎯 Created an Internet Cafe from concept, through planning into daily operations.✔ Produced business plan✔ Undertook negotiations with bank, landlords and lawyers✔ Negotiated supplier contracts✔ Recruited staff✔ Provided training on in cafe operations✔ Developed financial reporting system in order to report to shareholders

Edinburgh, United Kingdom

📈 Scottish Widows Investment Partnership (now part of Aberdeen Standard Life) was an asset management company based in Edinburgh.🎯 This role required me to provide Trade Support to Fund Managers and other Investment Support staff as well as identifying, testing and implementing improvements to the Merrin trading platform.✔ Provided analytical support to Fund Managers, Traders and Investment Support Staff with their use of the Merrin Financial Trading Platform and Bloomberg systems✔ Provided on call service to analyse and resolve problems with trades being passed into stock exchanges around the world✔ Tested and implemented improvements to the Merrin Financial Trading Platform

Thailand, Malaysia, Australia, New Zealand, Chile And Peru.

Sabbatical - world travel

Edinburgh, United Kingdom

📈 Royal London is the largest mutual life, pensions and investment company in the UK.🎯 Worked as a member of Administration Department team and was responsible for working on improvements to existing documentation and business processes.✔ Reviewed existing business processes with subject matter experts✔ Created ABC Flowchart 'As Is' and 'To Be' process maps✔ Provided cost benefit analysis of new technology as part of strategic improvement✔ Implemented bar code technology within the mailroom to improve the existing online Automatic Workflow Distribution system✔ Worked with Marketing and Actuarial Team to re-develop the Pre-renewal documentation in order to gain new business

Edinburgh, Scotland, United Kingdom

📈 Scottish Life Assurance Company was a mutual life and pensions company (now part of Royal London Group).🎯 I was a pensions analyst working within a variety of pensions departments, Executive Pension Plan, Personal Pension Plan, Free Standing AVC and Life Administration.✔ I dealt with customer written and phone enquiries✔ I dealt with agent written and phone enquiries

Bachelor Of Arts - Ba, Accounting

Education record