Setting up a governance program for effective management of investment product master data – Part 10 – Move to Maturity

March 25, 2013

This is the last post in a series of blogs on setting up a governance program for the effective management of investment product data, in this blog I will wrap up the series with a discussion on how to move your governance program towards a mature model.

If you have followed the earlier 9 posts you will probably recognize many of the steps in the data governance evolution scale  I referred to in one of my previous blogs on maturity models for governance of investment product data (see image below).

Data Governance Evolution - from Chaotic to Predictive

The Data Governance Evolution Scale

As you embark on the instantiation of your program you will more than likely be working within a quite chaotic environment – one lacking in clear, top down driven policies and standards, and very much reactive.

As you start to take action and follow some of the steps that I have outlined in earlier posts you will start the journey towards maturity – initially you will need to go through the process of securing C-Level buy-in, and formulating terms of reference for the program, before embarking on the broader strategy definition.

Do not neglect the importance of the culture and organizational structure that will be needed to support and enable the governance program to succeed – in particular you have to think about the target operating model of stewardship that will be most effective for how your business is structured both now and into the future.

In order to move from the “chaotic” and “reactive” levels in the maturity model you must focus heavily on the following:

  • Ensure your strategy is clearly defined and communicated to all actors within the domain you are trying to apply governance too
  • Set out the policies and standards you want to promulgate, with clear alignment and reference to the strategic goals
  • Once you have the policies and standards down pat you will need to focus on ensuring you have a set of applicable processes and procedures that are aligned with the overall strategy – each process should be directly traceable back to a specific standard/policy
  • In parallel to the process of defining the policies, standards, processes and procedures (the how) you need to be working on building out your master data plan (the what)

If you have worked through the process above, you will have moved from a position of total vacuum, to a chaotic, to a reactive program of governance – in fact you have probably got further than many firms who claim to have governance will ever move past.

To move from “reactive” to “defined” you need to make sure that there is a clear understanding of the data within the terms of reference of the program – all participants have to use the same nomenclature when talking about data, as inappropriate usage, miscommunication and misunderstanding of what is being discussed is the most common root cause of data quality issues I see. To this end, the construction of  a data dictionary is a fundamental step in moving your program to state of ”defined”.

Other areas you will need to focus on before you can consider your program to have achieved the level of “defined” in our maturity model are as follows:

  • You need to start the process of measuring your program – don’t fall into the data quality denial trap – identify the key areas (KPI’s) where useful measurement can contribute to a balanced score card that reflects how well the program is being executed. Think about KPIs that can point to the quality of the data – focus on the standard facets of data quality – timeliness, consistency, completeness and accuracy
  • Examine the operating model you have in place for stewardship - to what extent can it be made more effective and efficient by driving the rights issues to the right experts – in my opinion the stewardship model needs to be n-tiered in line with the back to front alignment of traditionally asset management businesses
  • As you develop and hone the standards and policies, the underlying process and procedure will start to snow-ball and it will become increasingly difficult to achieve the oversight and accountability that all governance programs require to be successful – to that end you will need to consider how technology can help support and frame your program, but remember technology is not a panacea to the ills of data governance and quality
  • For every issue, exception and concern raised through the program start tracking the root cause – this really does require a good underlying collaboration tool

Moving from the level of “defined” and onto “pro-active” and “predicative” will seem at face value to be relatively easy, but is very rarely achieved, in my opinion this is generally culture related – some of the key elements in moving onwards and upwards is buying into the continuous improvement principle – if this is not a core value in your firm you will find it difficult to progress in any meaningful way

So what are the key elements moving your program to the highest levels of maturity?

  • You need complete (firm level) buy-in to the concept of continuous improvement – with the appropriate feedback loops designed into your processes to ensure this becomes a core tenet in your program’s modus operandi
  • You need a specific set of activity centred on reviewing the root cause of issues being surfaced, such that they are being feed into the continuous improvement cycles for the relevant processes
  • Your master data plan and data dictionary will be seen as living breathing entities, that are constantly being updated and reviewed in line with the changes in your BAU operating models – these artefacts must never become stale. I often find this is the easiest way to demonstrate to a firm that their program is still in the “defined” stages of maturity, when they might argue otherwise
  • Your program will be making correct and efficient use of technology to empower and enable the data quality management process, supporting the people (stewards) to apply the governance
  • Your data architecture will be coherent and well designed for your organization and how it does business – I find discussion on architecture and the correct use (or not) of MDM, warehouses, marts, hubs, silos etc can be fraught with generalisms and so I will avoid pontificating on what I consider good architecture

When you are able to demonstrate that your program is constantly being tuned and refined, that you have demonstrable audit-trails, and your people, processes and technology are working in harmony, you are well on the way to achieving a highly predictive and mature governance program.

Before signing off of this 10 blog series, remember to keep your eye on the ball – think about the green grass on the other side of the river – the reason we focus so heavily on applying good governance to client facing investment product data is because data is the oil in the sales engine! Feed it with bad data and the engine will start to seize up…..and a business without sales has no future!


Setting up a governance program for effective management of investment product master data – Part 8 – Data Dictionary

March 6, 2013

This is part 8 of a series of blogs on setting up a governance program for the effective management of investment product data - in this blog I will explain why building and maintaining a data dictionary is probably one of the most important factors in the success of your program.

Like many business buzzwords, data dictionary means different things to different people. The common thread is that the dictionary is an inventory of the data items being consumed or produced within a specific defined business unit or process.

Why do we create them? Again, there are many reasons – but the most prevalent one is to bring a common understanding to play within a specific environment such that everyone is speaking the same language when it comes to data. Data management projects live and die by the quality of their data dictionaries because even within small teams you can have wildly different nomenclatures in existence for what seems at face value very simple, easily understood data items.

Before I get onto what makes up a data dictionary I would like to clear up a couple of misnomers I often come across:

- A data dictionary is not a document. Documents are two-dimensional, while data dictionaries work across many planes. They are best represented in a relational database, or if needs must, a set of interrelated Excel worksheets.

- A data dictionary is not a project resource – yes, every data management project needs a dictionary, but as a resource it has a life outside of the project. You do not create a dictionary to serve the needs of a project only – the dictionary is also required within the business-as-usual activities that come into play post a project delivery i.e. it is a resource that requires and demands constant attention, updating and refinement.

So what is commonly found in a data dictionary? As I mentioned earlier it is a centralised inventory of information on data items/fields that describes in detail the data items semantics, how the data relates to other data, where the data is consumed, where it is processed and from where it is sourced. The dictionary should also describe the correct format and syntax for each field.

So for each entry in the dictionary I would expect to find the following

- A specific unique name for the item

- A clear definition of the data items meaning, including references to other common/aka names for the item

- A list of all “consumer” entities and processes that consume/use this data item

- A list of all the “suppliers” or source systems that produce this data and deliver to processes downstream

- Specific mention of any master rules for choosing correct source system for specific situations

- A list of all business rules applied to the data item as part of any data quality management process that touches the data

- Reference to stewards or stewardship teams that are responsible for the management of the data

- Reference to subject matter expert(s) who can deal with questions about the data item

- Detailed syntax specification for the data item – including type, structure, format and example values

- Good dictionaries allow users enter and update specific notes and references à la a wiki

If you have constructed your data dictionary using a database then you can easily provide very helpful alternate views of the dictionary for example:

- Show all data items consumed by process X

- Show all business rules

- Show the data items touched by Rule Y

- For data item Z show all sources

- For data item R show all consumers

- and so on…

More advanced dictionary implementation have an integrated audit trail with the live system that can instantly show as-of  transactional views i.e. the dictionary and the real-world systems it relates to are integrated.

So how does one build the dictionary? In MoneyMate we build them out using a SIPOC process in reverse [COPIS]

- So we start off identifying all of the consumers of information

- From here working out what outputs are consumed by each consumer#

- From here working out which processes deliver the outputs

- From here working out which inputs are used in each of the processes

- Before finally identifying the source/supplier systems producing the inputs

A critical element of the COPIS/SIPOC analysis is identifying where certain data items have multiple source systems – in these cases we need to carefully specify the master data rules that indicate which source is correct for the variety of situations that dictate different usage of the data.

Examples of this problem would be:

- You could have multiple back-office providers which means your daily NAV could be flowing from multiple parties/systems

- You could also have different legal structures in play that have different statements of record for different data types e.g. for holdings you maybe using the accounting book of record for your mutual funds but for managed accounts you are taking data from your investment records.

- You could have standard source of performance for all in-house funds, but for sub-advised you take data from the sub-advisor

Clearly the dictionary needs to capture all of this information in a well structured manner and allow for specific notation of the master rules for each item which has more than one source.

So hopefully you have a better understanding of what a data dictionary is, what it contains and why it is needed.  If you have anything to add yourself – send me a PM or comment below.

Next up in the series is a review of the role technology should play….


Webcast available for on-demand playback…

August 10, 2012

For those of you who missed the recent webcast on regulation and its impact on data management strategies in the investment fund world, it is available for playback here


Webcast: The impact of upcoming regulation on data management

July 18, 2012

I am hosting a webcast on “The Impact of Upcoming Regulation on Data Management” on Wednesday 25th July 2012, 3pm BST, 10am EST.

Regulation is a key challenge in the industry and in an unprecedented age of openness and transparency continues to be the no. 1 driver for asset managers investing in data and reporting initiatives. Companies want to mitigate the risk of inaccurate information being in the public domain and many are embarking on data management projects – which will save time, reduce errors and automate processes. The key themes we see center on capability to deliver a systematic, repeatable and auditable data publication process for client-facing data.

This webcast will be presented by myself, and will focus on how upcoming regulations will impact the industry and how asset managers need to prepare to ensure they stay ahead in a highly competitive market. Specific topics to be covered include: the latest version of AIFMD, the final throes of the Retail Distribution Review, the latest on KIID for PRIPS, UCITS V, how being important or “SIFI” is no longer so desirable, Volcker, FATCA and last but certainly not least Pillar III of Solvency II.

Finally, I will touch on what is around the corner and run through some recommendations with respect to preparing for the swathe of upcoming regulatory change.

To register for this webcast please click here.

I look forward to welcoming you online on July 25th.


Making the most of your data

April 10, 2012

We all talk about how important data quality has become, how important it is to deliver transparent, high quality information to our customers, and how that’s been driven by regulation and by changing investors. However, I’ve been at a number of events recently, and talking to customers and prospects about data management and I think that the stakeholders in data management projects have changed – it used to be technology, now it’s predominantly the business.

The drivers for these initiatives have moved beyond improving operational efficiencies – now it’s about improving your client service and your customer experience by sending out high quality data, and it’s about how you use that data to promote your messages as well.

It used to be all about getting the data in one place and it was all manual processes – in many organizations the processes are now automated, they can get the data faster and they have time to analyze it and use it for marketing. Wouldn’t it be great to link your sales data to your fund data so when you have news about one of your funds, you can push it out to the sales force so they have immediate access to that information for their customers … or you can push it out to your marketing department so they can immediately execute a targeted campaign to a particular group of prospects. You could really add value to your organization’s sales processes by leveraging the information in your product data…and connecting it to your advisor and customer data …and then tying it all back together with your books and records data flowing from TA.

Many asset managers have empowered their sales teams with iPads so that they have access to all the latest product information … anywhere, anytime. At NICSA’s recent conference in Miami, it was revealed that 76% of advisers share content online (up from 67% in 2010). This includes performance information, white papers, commentaries etc…. it underlines the importance of being able to provide that information, ensuring that it is always accurate.

There is no point having all these silos of business intelligence in the distribution front-office if you cannot leverage it – make the most of your data!


Thoughts from TSAM (Part 2)

March 26, 2012

Following my most recent blog on the panel discussion held at TSAM in London recently, I thought I would add some further notes on the discussion. We had talked about buzzwords used and then about data governance… The theme of the discussion then switched to the risks you’re exposed to from miscommunication of information or data – the commentary is really as you would expect:

• Fines from regulators

• …which can lead to brand damage

• …which can lead to loss of clients and mandates

• …which does lead to outflows

• …which does directly impact your bottom line

Of course, the point was made that you do not need be fined by the regulator to incur the spectre of spectacular outflows – poor data quality in client communications is enough to trigger this alone.

I related a specific story I had been told by a director of institutional sales at a prospect I met in not too distant past, who earlier that month had got through the RFP process for a serious eleven figure mandate, which would generate many tens of millions in fees. So having got through the RFP process, this manager clearly had the right risk/performance figures to meet the minimum hurdle for inclusion in the beauty parade process. The deal was lost though on one critical point – the data presented at the beauty parade on the sales deck was completely at odds with the strategy performance as listed in the RFP response, and yes, they did not win the mandate. If you are handing someone billions and billions to manage you need to build a relationship based on trust and transparency and having inconsistent/inaccurate data leads to total breakdown in trust.

The topic switched again at this point to how can we get IT and business working together more effectively on data management projects. This topic generated lots of interesting viewpoints, which I have summarized here in bullet form:

• Business often gets involved too late – something specific to IT led projects

• There is general consensus that business-led projects are more successful mainly as the requirements are understood earlier in the process

• The project analysts and the project manager need to have strong business domain expertise with a really good understanding of technology to bridge the gaps between two teams

• It is not easy to find analysts with good understanding of IT and business – panelists agreed that the more successful people are those who start in IT and move over to business side.

At this point the discussion started to wrap up after a few questions from the audience and each panelist gave their final thoughts on overcoming the challenges. My own thoughts were that the driver of data management projects is changing, it is no longer fear of fines, it is sales and distribution demanding timely and accurate data. Another viewpoint was that we have to do a better job to remove artificial differences between IT knowledge and business knowledge, greater effort is required to try and get people to understand each other’s point of view. As data management projects are getting more complex, clear objectives and accountability are key success factors, we have to get the right stakeholders involved and use the right language. Finally, one of the panelists said we should not see data governance as a cost!

It was a great session, and I really enjoyed sharing views with the other participants on the panel. I look forward to the next one in New York on May 16th.


Tribal conflict on the investment plains

February 20, 2012

One of the key trends now with the global asset management community is the redistribution of products from one region into another – take for example, the popularity of BRIC and emerging markets funds in the US and Europe. Similarly, in Asia you have very high demand for equity funds from the G7 regions, and investment grade bond funds from those countries lucky enough to retain their AAA ratings. Global firms are increasingly co-locating their investment management teams in the regions where the investment is being placed. The middle office support for these teams is also increasingly being co-located with the same teams.

The problems start when the fund is sold in another region, quite often the local sales/distribution team takes the core investment product data from the local team and applies their own slant to the information – this application of regional slants to data coming from the region of investment can lead to very serious consequences, which can often erupt in tribal conflict between the regional division producing the product and the regional division selling the product.

Simple things like re-classifying terms such as ‘Real Estate’ (US lingua) to ‘Property’ (UK lingua) can seem straightforward, but when you have one region that takes a security classified as ‘Asset Backed Security’  and changes this to ‘Cash or Cash Equivalent’, problems can emerge. This is a simple example of course and one that very few firms will make again, but there is unlimited scope for misunderstanding and resulting misclassification of data when you have one team trying to interpret what another team means.

The only way to solve this is for global firms to have global governance and stewardship for their investment product data. The distributed / decentralized model for governance which exists in many global firms today will only lead to continued conflicts between their regional centres, and in turn expose their firm to specific reputational, regulatory and financial risks.


Data at your Service

February 2, 2012

Ever wondered how you can improve client services? I would argue that easy access to timely, accurate and ultimately reliable information about your products i.e. their investments, being delivered through an effective data governance programme, is a key enabler to service excellence. Arguably, the main differentiators for investors in terms of client services are the timeliness and quality of Investment Reporting coupled with a responsive and assured service that they can rely on if they wish to enquire about their investments. In the age of transparency, there is no room left for complacency in these areas.

Timely and Reliable Investment Reports

Strong data governance coupled with effective stewardship enables shorter reporting cycles therefore providing your clients with their investment reports earlier and exceeding their expectations for up-to-date information on their investment portfolio. However, timeliness of delivery will not do it alone. It has to go in pair with reliable data. The validation process in a data governance programme ensures that you get it right the first time; which in turn will save time by removing the iterative process of checking, correcting and rechecking reports. Clients do not only expect to receive reporting on time. The content has to be complete, accurate and consistent for it to deliver value.

Finalising reports earlier also provides your client service team with more time to focus on adding value when delivering the information by analysing the data and preparing to review the investment report with or pre-empt questions from their client.

Assured and Responsive Client Service

In the current environment and under increased regulatory scrutiny, asset management firms are adopting a fiduciary mind-set and strive to be as transparent to their clients as possible. Therefore, your customer service team’s ability to navigate your product data and have timely and accurate information at their finger tips is critical to your success. The changing regulatory landscape requires customer service staff to ensure they are prepared to address any question or concern that an investor may raise in a responsive and knowledgeable manner. Therefore, conveying confidence, building trust and making the investor feel that they are in good hands.

A strong data governance system will empower client services to achieve these high standards by building their own confidence in the information that they source internally, by providing them with the most up-to-date data and by allowing them to quickly identify the owner of specific data points to route investor enquiries to the right source of expertise within your organisation.  Therefore, helping them to get the answer right the first time.


Improving reliability and trustworthiness of investment product data will deliver returns

November 1, 2011
More than ever before, investors are demanding that asset managers up their game with regard to the quality of information they are presented with at point-of-sale or indeed in post-sale statements and reports.

This in turn is leading the heads of distributions and sales in asset management firms to demand more reliable and trustworthy data from operations. They have recognised that high quality information about their products can be used as a differentiator in winning new business, and that it positions them to deliver best in class client service which leads to higher levels of customer retention.

This data is directly used in the monthly and quarterly production cycles that serve their clients with regular updates on investments and power up the sales engines and related materials in the go-to-market side of the business.

But, surely investors are only interested in the risk-adjusted performance? Why would the quality of information in point-of-sale documentation or reporting influence an investor?

The reality is that investors do not, and should not, use past performance as the sole criteria in their decision process any more  – so many other factors are important. The same applies to distribution channels for funds -  fund providers need to differentiate themselves from the pack.

So clearly the distribution channels want good products to sell, but they need good materials (and good information) to help them make their products stand out from the crowd.

They not only want good sales support materials though, they want them on time, and ideally, they want them before their competitors have theirs. They want to wow the investor with the breadth, depth, and timeliness of the information. They want to ensure that whatever they present matches 100% what the investor will find on the web.They want to use the latest technologies to deliver the information to the client – support for a touch screen tablet is the new must-have request from  the field sales teams.

So, having a good product is a given. Having smart and exciting ways of delivering point-of-sale information to the potential investor is a given. The best product in the world, and the sexiest of sexiest tablets will be useless if the content you are delivering is late, limited or just plain bad.

Investment decisions are built on trust, trust in the advisor, trust in the brand of the provider, and trust in the material being presented.

Trust in the product is built by providing clear, deep, transparent information on the product at point of sale – so one or two page fact sheets that are two months old do not cut the mustard.

Trust in the information being communicated is the foundation on which the investor will build their impressions – it is their window on to the organisations they are doing business with (or considering doing business with).

The investor wants an appropriate mix of qualitative and quantitative information – too much text and not enough stats make it look like you’re hiding something, too much stats and not enough text make it look like you have a lightweight analysis team.

The investor wants first-class, qualitative analysis of the market segment / strategy that the fund is targeting – they want to understand the product and market risks at play. They want quantitative and technical analysis that open the lid on where the performance and risk of the fund is being generated, and they want to understand how this breaks down when compared to peer-groups, external category averages and the stated benchmark.

Something which very few asset managers have embarked upon is providing advice on which products from the same provider (currently) have a correlation co-efficient that would lower the overall risk of a portfolio while maintaining overall target performance – think about how Amazon.com markets books that are related to each other.

Finally, clear unambiguous presentation of the fees/charges for the product, build confidence and support the trustworthiness of the advisor, provider and product alike.

To summarise, by sorting out the “plumbing” i.e. the flows and quality controls around product information from various internal and external sources, sales and distribution can leverage this reliable and trusted data to accelerate new customer acquisition and increase customer retention rates.


Convergence of retail and institutional

October 20, 2011

I have noticed a definite trend over the last number of years with respect to the convergence of the retail and institutional worlds within asset management firms.

It is not simply just a convergence of the product and service offerings, but also the internal alignment of the teams responsible for each business line.

The operating models that were at play 2-3 years ago had these teams run on separate lines, now firms are aligning their internal structures along functional roles as opposed to business lines, in turn blurring the line between retail and institutional.

 So what is happening out there? What are the drivers? What is causal? What are the symptoms?

There are several key drivers that I see in play:

1. There is board and shareholder pressure to build leaner operating models that scale better and deal with financial market changes in a more flexible and predictable manner. This is borne out of the major flux we have seen in the financial markets since the end of 2008 and the renewed focus on operating costs.

2. There is a growing level of investment savviness amongst retail investors, in particular with the key market segment that has a high level of disposable income. These investors are demanding greater depth and breadth of information on their portfolios, thus driving the retail (product- focussed) reporting model ever closer to the client-focussed reporting model of the institutional market.

3. Institutional clients are demanding glossier client reporting artefacts – something which the retail side of the business are generally more adept at producing. This combined with the demands from the institutional sales teams and channels for product-like factsheet documentation for the various strategies and composites being marketed, is a key driver in getting the output production teams internally more closely aligned.

The results of these drivers are that internally the business lines are being remodelled and combined such that the retail (product) reporting structures are a by-product of the more bespoke client-focussed institutional lines.

The retail investor is also being offered increasingly complex products; synthetic ETFs, Absolute Return funds, Long/Short strategies and SMA/WRAPs.

In turn, retail investors are demanding increasingly complex statements and monthly factsheets – note the increase in retail asset managers offering detailed equity and fixed income attribution reports, both at product and account level.

Asset management firms have been quick to grasp the obvious efficiencies available by viewing the product side of the company as just another institutional client – thus enabling them to unleash the power of their considerable investments in client reporting solutions to tailor them for the retail line of business.

Another driver in the area which is driving consolidation of the systems that service both lines of business is the focus on building an investment product master to deliver a formal data quality management framework to support the considerable desire to produce better quality data and content in a more timely and efficient manner.

So in the future, we should expect to see more, not less, convergence of the business lines. Clearly, the two lines of business will always have clear demarcation lines in terms of level of service, reporting, fee structures and distribution, but the back- and middle- office teams and services that serve the business lines will see continued consolidation to leverage the obvious efficiencies and quality improvements being demanded by investors and shareholders alike.


Follow

Get every new post delivered to your Inbox.

Join 26 other followers