For Your Interest…

A blog about software, technology and efficiency

Setting Up Data Integration for Asset Management Firms

Having a centralized data repository (CDR) fitted with a data quality business rules engine sets asset management firms on the path to better data management. The next step is to integrate the data between the source and target systems via the CDR. This step would result in time and money savings, reduction in user tickets and faster issue resolution (if any).

For asset management firms, the source and target systems primarily include the:

  • Third-party data feeds
  • Order management system
  • Customer relationship management (CRM) system
  • Accounting system
  • Compliance solutions
  • Reporting systems
Read More

Topics: Data Integration, finance

Your Guide to Choosing the Right Version of SQL Server


Time to read – 3 minutes

This blog post will help you determine the best version of SQL Server for your organization’s needs.
 

Continuous Improvement

Data management gets a little easier with the release of each version of SQL Server.

With each new version, the performance gets enhanced through the introduction of new functions that previously required complex coding. Security features and analytics capabilities generally also get a nice tune-up.

With each new version you may think, “it can’t get any better than this”, but alas, the thought only prevails until the release of the next version!

Read More

Topics: SQL Server, Technology, Database Management

GIPS 2020 Standards - One Size Doesn’t Fit All

The background

It’s been almost a decade since the CFA Institute unleashed the 2010 Global Investment Performance Standards (GIPS) to homogenize the way asset management firms calculate and report performance to investors. As we head into 2019, the powers that be are attempting to tie up some loose ends.

The weakness of GIPS 2010? In three words — ‘lack of scope’. The guidelines as originally written were not broad enough to cover alternative assets in the capital markets like private equity, real estate, private wealth and so on. All of this resulted in a lack of buy-in from firms who wanted to comply with the standard but whose portfolio management activities didn’t fit neatly into the categories described in the framework.

GIPS compliance has always been more of a gentlemen’s agreement than a regulatory requirement — and its success depends on voluntarily adoption. And so, the GIPS Executive Committee learned the hard way that one size doesn’t fit all.

Read More

Topics: GIPS 2020, finance

Data Quality Framework for Asset Management Firms

The Centralized Data Repository (CDR) setup for asset management firms acts as the foundation for the data management initiatives. This is the first step towards achieving a single source of truth and eliminating siloed operations.

The next step is to ensure the quality of the data (that will be stored and managed in the CDR) meets the desired standards. For this purpose, data profiling is critical. Data is profiled in terms of its attributes, patterns, and functional dependencies, which in turn is analysed to create the business rules engine.

Read More

Topics: data quality framework, finance

Foundation of data management in asset management firms

Data serves as the nerve center for asset management firms. The securities pricing data, ratings, corporate actions data, NAV etc. are mission critical for asset managers to make the right investment decisions. The compliance team, on the other hand is in need of effective data management to file compliance on time, and avoid penalties.

Most asset management firms incur costs by purchasing data from third-party vendors like Bloomberg, Factset, Rimes, Fitch etc. However, they find it extremely challenging to manage this data, and often fail to leverage it, as this data is unstructured from a holistic perspective.

In the end, asset managers are forced to analyze this unstructured (or semi-structured, in some cases) data and make investment decisions with great difficulty, while the compliance team is forced to file compliance in the nick of time.

Read More

Topics: Centralized Data Repository, finance

Are robots taking over asset management?

Don’t believe the hype. Asset managers aren’t under the control of artificial intelligence (yet). But many shops currently engaged in "data science" programs are motivated by the same fear; that every other manager out there is secretly building the next-generation of robot, capable of making faster, more accurate predictions about the market than any human.

Read More

Topics: Automated investments, Data Science for alpha generation, finance

The Quest for Real-Time Data from Aerospace Suppliers

Aerospace firms would benefit enormously if their suppliers shared process capability data from their lines. But first, you will have to overcome a supplier’s reluctance to share data from their equipment. The key to doing so is conveying the benefits for both parties, such as an enhanced relationship and being able to identify issues as early in the process as possible, which reduces costs for all parties.

Read More

Topics: Change Management, Supply Chain Transparency, Aerospace SQC, Process Measures, Aerospace ToolsQA, Cost of Quality, Aerospace Supplier Performance

Better Data Governance for Aerospace and Defense Firms

Aerospace and defense firms generate an overwhelming amount of data, which is stored both internally and externally. With the sheer volume of data only increasing, the procurement and supply chain function is no exception in looking toward advanced analytics and business intelligence to better leverage their mountain of data. 

Read More

Topics: aerospace

Aerospace Supplier Audits:  Striving for Zero Defects

Supplier Audits.jpg

The late Philip Crosby argued that the performance standard that defines total quality is zero defects, which he defined as conformance to requirements.  Taguchi further argues that any deviation from a target value carries with it some level of opportunity loss due to scrap, rework, and dissatisfied customers.  We can operationalize the pursuit of zero defects, however defined, in several important ways.  Each recognizes the importance of eliminating product and process variability.

Read More

Topics: aerospace, Improve supply chain visibility, Supplier Certification

Aerospace Supplier Certification

Supplier Certification.jpg

 In the aerospace industry, nothing is more important than product quality and compliance to FAA regulations.   To ensure all parts meet the strict specifications of OEM’s like Boeing and Airbus, not to mention the Federal Aviation Authority, quality begins early in the supply chain with a concept known as Supplier Certification.

Read More

Topics: aerospace, Supply Chain Visibility, Supplier Certification