About the Client

One of the largest banks in Singapore with presence in 19 countries across the Asia Pacific, Europe, and North America.

The Challenges:

Banking and financial business processes involve an overabundance of repetitive tasks, causing our client to seek our expertise on banking automation technology, intending to gain greater accuracy, trust, and efficiency.

Solution:

Accelerated Automation Program

This Program envisions to enhance, optimize, and automate existing infrastructure and its associated monitoring services.

It focuses on gathering appropriate information to comprehend relevant IT infrastructure and subsequently design, structure, and implement Automation focused operational workflow. Where feasible, existing tools and systems shall be leveraged.

Scope:

Covers selected applications and infrastructure on three critical focus areas such as (nothing wrong with viz., but the simpler the better) Retail, Wholesale and Anti-Money Laundering (AML).

Two key focus areas for Automation – application focused monitoring (Observability), and Performance & Capacity.

Key Benefits:

Shift away from manual procedures of running tasks, into  improved, script based Automated way of performing tasks, , thus boosting efficiency and reducing errors to near zero.

Client

A Shanghai-based commercial bank focusing on meeting private banking clients’ comprehensive financial services needs.​

Challenges

Financial institutions are facing the problem of recommending stocks that cater to the investors’ trading behavior and strategies. Faced with a huge range of stocks, investors in the stock market may also be overwhelmed and daunted by the number of choices available on their plates. In order to provide a better trading experience for the investors, our client seeks our expertise in implementing AI and Machine Learning to power the financial market’s Digital Twin.

Services

• Data ingestion service that collects various bond market data and economy data from different sources​.
• Training of machine learning model to perform market price prediction​.
• Training of classification model to generate buy/sell recommendation to individual traders.​
• Web application to allow traders to interact with the recommendations and track performance. ​

Benefits

• Automatic buy and sell recommendations will be made to individual traders, based on market prediction as well as individual traders’ behavior.​
• Expandability on the recommendation, discovery of traders’ behavior, for better decision making as well as for junior traders’ references.​
• Recommended portfolio tracking against benchmark.

THE CHALLENGE

Our client needed help modernizing their digital marketing technology stack and shifting towards a culture driven by actionable insights. Their Adobe Analytics implementation had not been maintained for the past seven years, negatively impacting data integrity. Problems ranged from missing data to incorrect values.

Their digital marketing team needed help revamping their entire analytics program, so they could produce accurate data insights and make better business decisions.

THE SOLUTION

Beyondsoft conducted a deep assessment of their current implementation to understand gaps and issues. Based on our findings, we updated and improved their analytics program as follows:

• Established KPIs to build measurement models around acquisition, behavior, and outcomes.
• Re-designed their tag implementation approach to transition from hard coding to dynamic context variables.
• Established a set of standardized reports for C-level, management, and operations stakeholders.

THE RESULTS

Thanks to the Beyondsoft agile analytics solution, our client has confidence in their data integrity. The streamlined solution enables them to quickly configure and update data values to the right Adobe Analytics variables as needed. By advancing data analytics maturity, the organization can make better decisions and evolve its business.

TECHNOLOGIES USED

Adobe Analytics, Ensighten Manage, JIRA

THE CHALLENGE

Our customer had been using the Business Intelligence Platform on Teradata to host sensitive data that was regularly accessed and updated by third-party vendors. But the platform’s limited monitoring capabilities were difficult to manage and did not meet the bank’s growing needs. Meanwhile, the solution had become cost prohibitive. To save money and meet their business requirements, the customer needed to migrate from the legacy platform to a modern unified data platform.

THE SOLUTION

In addition to migrating more than 1,000 highly sensitive datasets, Beyondsoft migrated 23 regulatory reporting functions onto the modern unified data platform. To expedite project delivery and validate data accuracy, Beyondsoft built an automated tool that compared the datasets moved from the legacy platform to the target platform. The Beyondsoft team chose a third-party tool to convert Teradata SQL to Sparkola SQL, further expediting the project. To enable secure user access on the new platform, Beyondsoft designed a custom access control system based on a proprietary tool our customer had built on top of Spark.

Due to the sensitive, business-critical nature of the data and systems as well as regulatory guidelines, Beyondsoft followed strict protocols for the deployment and developed plans to manage capacity, data involvement, and other conflicts. Additionally, the team developed systematic plans for migrating data that was heavily dependent upon other systems while contending with a continuously evolving system during the migration. Finally, Beyondsoft sanitized the customer’s environment, resolving 120 critical issues.

Modern unified data platform architecture

THE RESULTS

The migration to a modern unified data platform provided multiple benefits for our customer:

• Reduced costs by 80%.
• Boosted efficiency of their entire system by 40%.
• Increased control over management of third-party rights.
• Gained the flexibility to add changes as needed.
• Expanded data visibility and monitoring capabilities.

“Fantastic effort and teamwork to get this done. It has been a challenging task, especially in this COVID period, but your diligence and collaboration have pulled it off. Really appreciated.”

– Banking customer

TECHNOLOGIES USED

Sparkola, Superset, Alluxio, Apache Airflow, Grafana, AWS S3 bucket as a data store, and Presto, Deep Monkey, and Compiler Works.

THE CHALLENGE

Our customer needed an automated DMaaS solution to secure and safely move massive volumes of highly sensitive data from on-premises servers to a cloud storage solution. They also wanted to ensure they could tokenize sensitive data and share it between different environments.

But their existing manual processes were insecure and time-consuming and put them at high risk for human error. Furthermore, they needed a solution that would comply with rigorous government regulations as well as company policies.

THE SOLUTION

Beyondsoft implemented a full data movement as a service (DMaaS) solution for the customer. As part of the DMaaS solution, Beyondsoft secured sensitive data using tokenization and automated processes to quickly and securely move data to the cloud and different environments such as user acceptance testing, production, and quality assurance.

To ensure a highly secure and compliant solution that could handle massive data volumes, Beyondsoft first conducted an in-depth analysis of the customers’ business needs and existing environment and chose technologies that could fully meet project requirements.  

Beyondsoft then designed a tokenization tool that requires only a handful of inputs, such as the data to be copied and the data destination. Once the inputs are specified, the tokenized data is automatically moved to its destination with a single click.

To further improve the security of the entire process, once the data is tokenized, it is scanned and sent to a manager for review and approval before the actual transfer. This approval process adds an extra layer of security and provides our customer with greater control over the data transfer process.

Diagram of the DMaaS solution

THE RESULTS

Thanks to the highly secure and automated DMaaS solution from Beyondsoft, our customer was able to reap multiple benefits. Benefits include:

• Ability to handle massive volumes of data quickly and efficiently.
• Secure end-to-end data transfer and management processes.
• Compliance with government regulations and company policies.
• Fewer hours required to manage the process.
• Headcount reduction from twelve to six.
• Elimination of manual processes and risk of human error.

TECHNOLOGIES USED

The solution uses the following technologies:

• Spring Boot Microservices
• React for the front-end design
• JWT for authorization, CBH, Pyspark and Scala for data processing
• Protegrity for tokenization
• Distcp for copying the data