Transforming Financial Operations Through Technology

Introduction:

Today, business and technology are inextricably linked. And keeping pace with the emerging technology landscape can be difficult for even the most tech-savvy leaders. This case study dives deep into the challenges faced by the client in terms of manual and time-consuming financial processes, lack of data insights, and increased risk of errors followed by describing the solutions provided by Cognine that enhanced the overall functional efficiency of the client.

About Client:

Client is an American financial technology company that creates and provides financial advisors with wealth management tools and products. Their flagship product is an advisory platform that integrates the services and software used by financial advisors in wealth management.​

• Cognine analyzed the business requirements for their analytical needs, designed data models and developed reports. Implemented CI/CD functionality for auto deployment processes.

Technology Stack Used:

Implementation:

Benefits/Results:

Improved data accuracy and increased productivity: Cognine successfully automated Normalization files through UI. With the help of React UI the user can upload file metadata information and download the Normalizer file. Previously, each Normalizer file required manual development. Post automation, using the new UI, users can develop up to 20 Normalizer files at one time which saved user’s time largely and boosted efficiency.

Problem Statement:

• Client received data in various formats from different customers which made it difficult to analyze, understand and reuse it.
• The incoming incremental data was as large as 100 GB which was being received on to their on-prem servers which had computing challenges on a day-to-day basis.
• Decision making capabilities were being hampered due to lack of efficient reporting formats making it almost impossible to extract enough insights.
• Ensuring data quality of the large sets of incremental data had become cumbersome and was affecting downstream systems.
• There were architectural issues causing latency in the conversion of raw data into customer consumable data.

Solutions Provided by Cognine:

• Cognine provided a highly scalable and robust architecture that supports various file formats with different sizes & data volumes which automated and improved client’s financial workflows, real-time data visibility.
• The new multi-layer (staging, standardized, curated) and multi-tenant architecture which supports ETL operations to run different teams as well as help different teams access data at different layers based on their needs.
• An event driven micro services architecture ensured the data load into targets without delay. This impacted the implementation and configurations at environment and object level, such that very minimal changes are needed during the deployment.
• Embedded Collibra DQ to monitor the DWH jobs and notify users based on the requirement.

Reduced Processing time:

By creating a standard logging format, we introduced a centralized library for standard logging where we implemented logging format for different steps and saved them into CloudWatch.

Quantitative Data Management:

There was a huge scale-down on manual intervention on client-specific data extraction. Quick decision making: Data insights fostered the client to take quick decisions and improve their overall financial performance.

Conclusion:

• • Data insights are helping the business to take quick decisions based on the highly sophisticated visuals.
  • Manual intervention on client specific data extraction came down extensively as we were able to automate the functionalities.
  • Automating the on-boarding & processing of new client requests was made as easy as just a click and go. This is helping to scale up client’s operations. The marketing team can utilize this to grab the attention of new prospects.
  • Latency of accessing data from Analytical system has been reduced tremendously, it was scaled down to multi-folded level.
  • The cost of the DWH layer has been reduced nearly half per month. This gave financial freedom to the business.