ETL mechanism for risk-analysis feeder files

One of the top global fund and ETF data providers

  • 400+ Products
  • 20 Institutional investors or third party information providers

The client management team for the fund provider required a solution for providing periodic data-centric Request for Proposals (RfPs) for institutional investors.  A few clients required customized feeder files for a risk-analyses-mechanism with a short turnaround time after closure of the monthly books.

SG Analytics offshore team, comprising of fund reporting experts and technology specialists, discussed existing data structures and mechanisms with internal teams and the client management team of the fund provider. After reviewing the existing database management system:

  • The SG Analytics team designed customizable workflows for each RfP and feeder file. These work-flows comprised of basic Extract-Transform-Load (ETL) steps such as data extraction, transformation, clean-up and then loading for each requirement.
  • SG Analytics execution team processed the existing data requirements using the set up systems while reporting experts and technology specialists handled the ETL customization.
  • In case of new RfP or feeder files, SGA’s onboarding team designed the ETL mechanism such that the customization on inclusion of new fund products or data parameters can be seamlessly managed without any hassles.

SG Analytics Team has helped us regain the trust on our data by one of the leading institutional investors, which invests more than $2 billion in our fund products.

Director – Funds Data, during Quarterly Business Review meeting

  • Ensured distribution of accurate information to institutional investors and family offices.
  • Ensured timely delivery of the feeder files for risk-analyses mechanisms of the clients.
  • Improved data representation on third party information providers.
400+
Products
20
Institutional investors or third party information providers

Client

One of the top global fund and ETF data providers.

OPPORTUNITY

The client management team for the fund provider required a solution for providing periodic data-centric Request for Proposals (RfPs) for institutional investors. A few clients required customized feeder files for a risk-analyses mechanism with a short turnaround time after closure of the monthly books.

SOLUTION

SG Analytics offshore team, comprising of fund reporting experts and technology specialists, discussed existing data structures and mechanisms with internal teams and the client management team of the fund provider. After reviewing the existing database management system:
  • SG Analytics team designed customizable workflows for each RfP and feeder file. These work-flows comprised of basic Extract-Transform-Load (ETL) steps such as data extraction, transformation, clean-up and then loading for each requirement.
  • SG Analytics execution team processed the existing data requirements using the setup systems while reporting experts and technology specialists handled the ETL customization.
  • In case of new RfP or feeder files, SG Analytics onboarding team designed the ETL mechanism such that the customization on the inclusion of new fund products or data parameters can be seamlessly managed without any hassles.

VALUE DELIVERED

►
1
Ensured distribution of accurate information to institutional investors and family offices.
►
2
Ensured timely delivery of the feeder files for risk-analysis mechanisms of the clients.
►
3
Improved data representation on third party information providers.
 

DOWNLOAD WHITEPAPER



DOWNLOAD Case Study



GDPA
ISOISO