Recently, the Bank of England published its third concurrent stress test results of the UK’s banking system. Based on the Bank’s new approach, this stress test is perhaps the severest yet in examining the resilience of the banking system. Data plays a critical role in the complex process of stress testing, and most stress tests are conducted wholly or partially via spreadsheet-based models in banks and financial institutions. The issue is that the use of these spreadsheets and other end user computing (EUC) applications is uncontrolled, which potentially threatens the integrity of data used and therefore the accuracy of output from the stress test models.
Banks and financial institutions, who invest heavily in IT systems, are comparatively lax in the management of their spreadsheet and EUC landscape, even though it underpins their regulatory compliance and model governance initiatives. In particular, IT departments in banks prefer the use of enterprise business applications, so gaining their mind share for proper use of spreadsheets is often a challenge. Nevertheless, aware of the reasons of why users are drawn to EUCs, regulators are now demanding that banks demonstrate transparency around the ecosystems of tools that feed their stress test models.
Managing the spreadsheet landscape is a challenge
EUCs are a double-edged sword. They are quick and easy to deploy, facilitate agility and deliver flexibility in evolving market conditions and advancing regulations. At the same, they are extremely difficult to manually manage and control.Spreadsheets contain a vast amount of data, stored in multiple sheets, making discrepancies difficult to identify. This is further compounded by linkage of these applications to each other via formulae, creating an environment where changes and discrepancies are not visible, often occurring in data not intended to be viewed after initial data input. With banks depending on 100’s of spreadsheets to support their governance models, even a single data error in one file can proliferate across the organisation’s wider EUC landscape, feed inaccurate data into a model to produce incorrect outputs.
Furthermore, spreadsheets are often shared and transferred between users, resulting in multiple versions of the same documents, but only one of which is up to date. If they are not stored and labelled correctly, subsequent users are unable to identify which spreadsheet is the current version containing up to date data, potentially causing discrepancies from the use of old or incorrect data.
Why automating the EUC management process is essential?
A central aspect of data quality is transparency, and banks need EUC management to establish how data is created and where the transformations in the figures and stress test models are occurring. In doing so, they can verify the processes and controls to ensure good quality data.
Technology can facilitate the adoption of best practice processes to ensure data quality by embedding governance into the business operation, supporting everything from creation of new EUC applications through to eventual decommissioning of these files. Enabling banks to understand and control the entire data ecosystem that surrounds the stress test model can provide a means to establish what type of EUC the data is coming from – e.g. spreadsheets or access databases; whether it isa single spreadsheet or multiple spreadsheets that feed data into the model; and what the data linkages between the various data feeds are etc. This visibility comes from a process of discovery including scanning file shares and repositories; as well as analysing the overall EUC estate structure, properties and content. Banks are then able to rank the inventory of files by the level of risk(or materiality) they pose based on the risk appetite of the organisation, providing holistic view of the complex web of data flows, on an ongoing basis.
A technology-led approach to EUC data quality management eliminates the need for manual checking, which is extremely inefficient.Even though the adoption of EUCs for modelling delivers initial benefits to users such as speed, reliability and costs – compared to the absence of a technical solution for a new operational business requirement in the enterprise system – there are challenges. The use of EUCs require manual operational processes such as augmenting and aggregating data. These spreadsheet processes can require multiple people to update and review the contents and as such users spend a lot of time double checking the EUCs’ data integrity, negating some of its original advantages.
This manual effort is hiding a huge cost to organisations. Consider this: for arguments sake, there is a population of 100 operational EUCs with an average of 8 hours per month spent on each application at a fully costed employee rate of £50 per hour. This means that each EUC costs £400 per month or £4,800 per year to operate. For the full EUC population, this translates into £480,000 for the year.
Additionally, a technology-led approach to EUC data quality management helps credibly demonstrate the validity of stress test models and the accuracy of the corresponding outputs to satisfy the regulators. EUC management solutions enable banks to set up data change management processes and control mechanisms, supported by an audit trail to ensure that the integrity of the data is always maintained.
It’s important to note that even with automation of EUC management processes, users are able to add expert judgment by altering data sets in spreadsheets to improve the alignment between theoretical calculations and the real world. The automation offered by technology solutions also facilitates re-attestation of the models, and tools that feed them, so banks can periodically re-evaluate the models to ensure that they are indeed working as desired by the organisation.
Data quality and integrity underpins the success of all model governance, not just stress tests. Given that spreadsheets and other EUCs will continue to be used for model development in the foreseeable future, automating EUC management processes makes spreadsheet usage safe and in fact favourably contributes towards the larger risk management efforts of banks.
About the author
Henry Umney is Vice President of Sales at ClusterSeven and is responsible for the commercial operations of ClusterSeven, overseeing globally all Sales and Client activity as well as Partner engagements.Henry brings over 20 years of experience in sales and account management in financial services. Prior to ClusterSeven, he held the position of sales director in Microgen, London and various sales management positions in AFA Systems and DART, both in the UK and Asia.
What is loneliness and how can you manage it?
By Iris Schaden Your Business and Personal Coach
A mere century ago, almost no one lived alone. Today, many do and it is not unusual. The recent lockdowns and isolation periods have amplified feelings of loneliness. But why do we feel lonely? Why do our bodies experience social pain? Learn about what we can do to improve our situation, prevent chronic loneliness and minimise the tremendous impact it has on our health.
Solitude and choosing to be alone can be bliss. Over the last sixty years the number of people living alone has increased in developed countries by more than 50 percent. In countries such as Denmark, Sweden and Switzerland, it is very common for people to live alone. But this does not translate into higher levels of self–reported loneliness. Many people have friends or family they can interact with on a regular basis.
However, it is important to recognise that this choice is different to loneliness, which can be a state of profound distress. Loneliness is a purely subjective and individual experience that can be felt by anyone, no matter their social, educational, gender or age demographic. Humankind are social creatures by nature – we struggle without it – and social connections are important to our health and emotional wellbeing.
Loneliness is a problem when we feel that no place is home; when we are in a group and we still feel social separation; when we spend time with our family but we feel like we don’t belong; or when we lose a relationship and struggle to adjust. It is a growing phenomenon in modern times, a by-product of our individualism, long-distance study and career opportunities or time-consuming work commitments.
The pandemic, with its required isolation and social distancing, has added additional stress to many households, but feelings of loneliness or adverse effects of social isolation are particularly prevalent in one-person households and young people aged 12–25. According to a study by VicHealth, even before COVID-19 young adults and adolescents reported high levels of loneliness, social isolation, social anxiety and depressive symptoms. Additionally, it is men who tend to report higher levels of loneliness than women.
Reported loneliness is on the rise. In 2017 and 2018 former US Surgeon General Vivek H. Murthy declared ‘an epidemic of loneliness,’ and the UK appointed a Minister of Loneliness. In these two countries, one in five adults reported that they often or always feel alone; in Australia, it was one in four adults. And this was before COVID-19, which makes us realise the mental and emotional impact lockdown has on individuals.
What happens to our bodies when we experience loneliness?
Neuroscientists, such as John Cacioppo, identify loneliness as ‘a state of hypervigilance whose origins lie among our primate ancestors and in our own hunter-gatherer past’. Our ancestors needed to belong to an intimate social group to survive. Cacioppo explains that our bodies respond to being alone, or being with strangers, as though we were in a dangerous situation.
Separation from other people (the group) triggers a fight-flight-or-freeze response and we feel social pain. While physical pain is primarily a sensory experience, social pain is the emotional state that comes from the distress of being lonely. Like the bodily sensation of hunger, it alerts us to a need, but instead of food the need is social interaction.
Loneliness generates anxiety: our breathing quickens, our heart races, our blood pressure rises and we struggle to sleep or sleep well. If we don’t pay attention, over time we start to act more fearful, defensive and self-involved. All of these actions drive others away and tend to stop those experiencing loneliness from doing what would benefit them the most: reaching out to others. It is a vicious cycle and one that is especially challenging for older and younger individuals.
Tactics to help cope with feelings of loneliness.
To belong is to feel at home in a place or situation where you feel included, comfortable and connected with others. In his assessment, Vivek H. Murthy wrote, ‘To be at home is to be known … You can feel at home with friends, or at work, or in a college dining hall, or at church, or in Yankee Stadium, or at your neighbourhood bar. Loneliness is the feeling that no place is home.’ Having relocated to different cities and countries and re-establishing my life over and over again, I can certainly say that loneliness can be a challenge.
How can we combat the feelings of loneliness and the anxiety that comes with it, before it becomes chronic and we find ourselves even more isolated over time?
The first step in moving forward is acknowledging how you feel. Give those feelings a name with a specific timeframe; for example, today I feel alone or since I’ve been in lockdown, I have felt alone or since I lost my partner, I feel disconnected and lost. By doing this, we focus on the present and do not label our entire existence as lonely.
My personal strategy is to go outside if the loneliness gets too ‘heavy’; connect with other people through looks and smiles (even under a face mask our eyes can smile); call friends and family regularly; or schedule a brunch or glass of wine with friends (in person or video chat).
Practising random acts of kindness and gratitude, for others and ourselves, is another very effective and very positive way of bringing us back into the present moment and improving our overall wellbeing. Energy flows where our focus goes. It takes effort and sometimes it is indeed easier to just give in and watch a light-hearted movie on the couch. And that’s fine too!
If you are ever experiencing loneliness, I recommend exercising your social muscles and also seeking support. Remember that your feelings are normal as we are biologically fine-tuned to being with and interacting with others. However, you will need to make changes to avoid jeopardising your health. Once loneliness becomes chronic it becomes self-sustained and you will begin exhibiting defensive behaviour. As a defence mechanism, loneliness makes you assume the worst of others and you (your brain) become hypersensitive to social signals that might be interpreted as hostile towards you, when in reality people might just be trying to help you.
Large studies have shown that feeling lonely has a tremendous impact on your health: it can make you age quicker, cause dementia to advance faster, weaken your immune system and lead to anxiety and depression. Many people turn to substance abuse which only serves to numb the symptoms, rather than treat the source. And while you can find so much information online, knowing is not enough. Remember that reaching out for help is not a sign of weakness but one of strength. So please reach out to your network, talk to your health professional or get in contact with me.
There are different ways to improve your overall wellbeing. Let’s discuss.
Payments in a pandemic: UK consumer trends emerging from COVID-19
By Philip McHugh CEO at Paysafe
The outbreak of COVID-19 has been a global catalyst impacting many industries, including payments. It has forced consumers to adjust to different ways of purchasing goods and services; according to our latest Lost in Transaction research, a survey in which 8,000 consumers globally were asked about their payment habits, over half (54%) of UK consumers said they have used a payment method new to them since COVID-19 began.
This change in consumer behavior will serve as a tipping point for the payments industry. Consumers are demanding more choice, and more convenience in how they pay, with 84% of people we surveyed admitting to thinking about payments differently in 2020.
Here are four trends coming out of the COVID-19 pandemic we believe will permanently alter the global payments landscape.
- Major shifts to digital
This pandemic has not only been the impetus for change from consumers, but for businesses too. For cash consumers, particularly those who are unbanked, the short and long-term impact of only having to access to products and services digitally is going to be substantial. Providing a smooth transition from retail to online payments will be key. According to our research findings, COVID-19 has led 21% of UK consumers to try online shopping for the first time and 12% using a digital wallet for the first time to make an online payment.
Digital merchants must take this into strong consideration when thinking about the evolution of their checkout. There are many viable options, including incorporating an eCash solution to give the buyer the option to maintain cash as their primary payment method, or introducing a digital wallet that enables people to shop online without sharing their financial data with merchants and potentially compromising their financial security. By 2023, digital wallets are expected to become the most popular online payment method in the UK, accounting for 33% of the market.
Already, nearly half of UK consumers (43%) said they increased their online shopping habits because of restricted access to high street stores and this percentage is expected to grow further. It’s vital that businesses begin to diversify their payment offerings otherwise they’ll fail to meet consumer expectations and risk losing out to their competitors.
- The growth of contactless
Despite the World Health Organization not issuing an official warning against using cash, the psychological perception of the safety of handling cash has made an impact. Nearly two thirds (63%) of UK consumers surveyed said they will be using contactless more in the short term due to health and safety concerns, and 61% saying they are happier using contactless now than they were last year.
At the end of March, cash usage in Britain halved, according to Link , operator of the UK’s biggest network of ATMs. In addition, contactless card limits for in-store spending rose from £30 to £45 to cut the need for physical contact in shops. Increased adoption of mobile wallets like Apple Pay or Google Pay across all generations may be on the horizon, making payments more accessible to society. Restaurants and pubs are also encouraging the trend towards cashless as well, such as prompting people to use an order-ahead app to pay for drive-through orders or removing the need to press a “pay now” button before a contactless payment.
- The importance of remittances
With travel restrictions still in place around the world, sending money home quickly, seamlessly, and cost-effectively remains more vital than ever. Half of consumers have given money to family or friends since the crisis began, and nearly a quarter (20%) have done this at least three times. According to our research, 74% of consumers would use a digital payment method to send money abroad, either through a digital wallet, direct bank transfer, or online money transfer services. Effective remittance channels are needed to combat specific issues caused by this crisis, including being financially inclusive for those needing financial support for the first time and who may not have a bank account, or access to digital payment methods because of displacement and isolation.
- Embracing the power of technology
Our recent Lost in Transaction research shows that consumers are already adapting to challenges in purchasing, including getting to grips with alternative payment methods, and it is the industry’s job to make those methods even more accessible to society. Both payment providers and online retailers must adapt in line with the demands of consumers, and the requirements of the situation. Ultimately, the accelerated change and improvements made to digital commerce throughout this pandemic will pave the way for the future of both digital and in-store payments.
Once the world resumes ‘business as usual’, the payments industry, guided by changing consumer behavior, will develop further thanks to new technologies such as 5G technology, artificial intelligence and automation – all helping to speed up transactions, improve in-store payments, and enhance user experience. Online and mobile banking will become more ingrained in the mainstream and consumers will come to expect a fully-integrated, unified experience across all channels and touch points. We were already on this path, but the pandemic has served to accelerate consumer appetite for enhanced products and services.
FinTech Landscape: Synergy and Disruptive Innovation in Investment Banking
By Mr. Kunal Sawhney, CEO at Kalkine
While technological leaps seem to be defining brighter future for some businesses in the post-COVID era, FinTech continues to thrive and transform the landscape of financial services industry. It is about staying ahead of the curve in this race against grabbing a bigger chunk of market amidst shrinking consumer and business confidence – as adoption of advanced technology can be the secret sauce in attracting and retaining customers in the digital era.
Asset management, insurance and lending companies are some of the prominent segments in the broader financial segment that have very swiftly embraced the latest digital technologies. Looking at Investment Banking (IB) space, while COVID-19 pandemic initially brought the sector to its knees, latest trends in financial technology adoption seem to be getting them back on their feet, driven by advanced and streamlined offerings pertaining to M&A advisory, risk management and financial assets management.
In general, we have heard about versions – Fintech Version 1.0 & Fintech Version 2.0, but the modern theory around investment using financial technology does not end here. There is a multitude of factors that can push and prod the IB thematics while channelising the way technology can slither through and give a spin to each and every product and service in Investment Banking space. Tech-based end-to-end models appear to take things one notch up when it comes to dealing with risk profiling, lending, fraud analysis, payments etc. Let’s look at how this is made possible in today’s world:
AI Technology Penetration – The ‘New Normal’: Penetration of Fintech in IB models is charting out new growth prospects for the financial services industry, ensuring cost optimisation of due-diligence, enhancing value for M&A prospects, streamlining legal checks and advancing asset-reporting discrepancies in acquisition deals. Besides, AI-empowered actuarial software is providing a firm nudge to offering top-notch, faster and accurate risk advisory services.
Moreover, seamless utility and penetration of AI and ML in algorithm trading, stock market prediction, fraud detection and prevention, acquisition of new customers, risk profiling and network security deserve much applause. Amidst COVID-induced market volatility, technology-enabled valuation models play an important role in carving out future stock predictions and aiding sound investment decisions.
Big Data Analytics Driving Value-Based Offerings- IB players are increasingly adopting big data models in evolving and providing advanced offerings in terms of building customer-centric asset portfolio valuation models, offering trading and investment support, risk advisory and M&A support. Meanwhile, big data is also leveraged to optimize internal processes such as automated customer support, salary optimization, attrition modelling, fraud analysis, credit/operational risks, etc.
Besides, the concept of algorithm trading seems to be gaining wide acceptance across major IB players in ensuring efficient execution of financial trades and robust investment decisions without human intervention.
Empowering revolution in the IB space, adoption of unique predictive models, sophisticated statistical techniques and ensuring privacy and integrating of data is crucial here. Specific set of challenges needs to be carefully catered to, in order to ensure that big data boosts competitiveness and support deeper market penetration.
Robo Advisory – The Next-Gen Frontier: Robo Advisory engages high-tech algorithms and provides secure, faster and self-service functionality via online investment management platforms. As per market experts, asset under management using Robo Advisory is expected to grow multifold in the post COVID era.
With minimal manual efforts, Robo Advisory allows automatic adjustments and rebalancing of the portfolio allocation based on algorithms and pre-defined investment rules. The investments are entirely automated and have self-learning algorithms, while the cost of running a robotic automation tool is far less than doing the same work manually.
Cash Less Transactions – The Immediate Future: With increased comfort and safety associated with online cash-less transactions amidst current health crisis, IBs are able to improve and augment existing products and services, in addition to developing new business models. While social distancing is becoming a new normal in the coronavirus era, financial advisors appear to be harnessing the fruits of tech transformation and heightened cashless transactions.
Undoubtedly, banking giants that are fast in adopting digital technologies have an edge over their peers. However, the biggest challenge for FinTech is data privacy, as transactions that go digital are highly prone to cyberattacks. Nevertheless, digital transition may see emergence of a digital-first model in the near term, ensuring radical shift in the value proposition offered to clients, with an ever-increasing emphasis on digital toolkits and electronic market access. All in all, it’s how firms refine their transformation objectives, evolve from the lessons learned from the pandemic and review their broader strategic agenda.
Return to work: Flexibility, preparation and communication are key
By Matt Weston, Managing Director, Robert Half UK As lockdown restrictions ease for the foreseeable future, conversations across the business...
How sustainable AI improves the triple bottom line
An investment in green AI enables financial services firms to align people, profit, and planet By Nick Dale, EVP business...
The impact and implications of Covid-19 on financial reporting
By Mark Billington, Regional Director, Greater China & South-East Asia, ICAEW The economic consequences of Covid-19 have been unprecedented, affecting...
Contis enters RBS Capability and Innovation Fund bid seeking £35 million for disruptive SME growth strategy
Leading payments provider, Contis, has applied for two grants from the RBS & BCR Alternative Remedies Package, totalling £35 million. Unlike most applicants who...
Four years of digital transformation in four weeks: UK lockdown puts pressure on brands to digitally deliver
Nearly a third (32%) of consumers would switch providers if a brand’s website is unavailable for more than 24 hours...
Demonstrating the value of collaborative leadership during crises
By Jean Stephens, CEO, RSM International In 2000, a leading expert in behavioural science, Daniel Goleman, outlined the six key...
Empowerment Accelerates Continuous Improvement
By Larry Sternberg, JD, Fellow, Talent Plus, Inc. Empowerment First, let me clarify how I am using the word “empowerment”...
What is loneliness and how can you manage it?
By Iris Schaden Your Business and Personal Coach A mere century ago, almost no one lived alone. Today, many do...
How banks can build digital transformation into business continuity
By Andrew Warren, Head of Banking & Financial Services, UK&I, Cognizant Businesses around the world are falling victim to the...
Akerton Partners S.L. is a Spanish independent mid-market corporate finance advisor founded over a decade ago, in 2008, amid a...