THE CHALLENGE
Processing data from millions of retailers
SMEs play a vital role in the Brazilian economy. The sector covers more than 56 million jobs and was responsible for 72% of all jobs created in the first half of 2022. It is, however, not without its challenges.
The Central Bank of Brazil recognized an opportunity to rethink access to financing for SMEs. By changing the rules governing how SMEs access loans, it could provide an additional boost to the national economy.
Previously, if an SME had taken out a loan with one financial institution, the company was unable to apply for a second loan from a different lender, locking them into dealing with one company even if there were better deals with lower interest rates on the market. They could also only use banked finance as collateral, which didn’t include pending credit card payments – amounts that could comprise a significant percentage of the companies’ future revenues.
To make it easier for SMEs to apply for loans, the Central Bank launched an initiative to create a central registry of credit card receivables — i.e. pending transactions — to create better visibility of the company’s true cash flow. In addition, it wanted to speed up credit card processing times from months to days to ensure merchants receive any money owed to them faster.
In 2019, TAG was one of four companies authorized to act as a registrar, and to develop a solution to support a massive workload of 20% share of credit card receivables data by a fixed deadline. The registrars act as an intermediary between merchants and credit institutions, receiving payment data with permission from the merchant and making accurate reports available to the lender.
“Under the new model, SMEs can use their future credit card receivables as guarantees for their loans, which makes finance more accessible and democratic,” explains Felippe Ferreira, Head of Infrastructure, TAG. “Our role was to create a cloud-based credit card receivables registration platform capable of processing huge volumes of data from multiple sources, ensuring enterprise level security in line with the Central Bank’s strict requirements.”
As well as making financing more accessible, registrars are responsible for ensuring SMEs don’t use the same receivables to take out multiple loans, protecting both sides from getting into financial difficulties in the future.
With its very existence at stake, TAG needed a highly available platform that could process data from up to 1 million retailers in a short amount of time. The platform would also need to scale in line with demand during peak times, and provide rich analytics to track performance and enable ongoing optimization.
THE SOLUTION
Scalable and optimized database services
TAG selected Google Cloud Platform to implement their MongoDB Atlas—a modern, multi-cloud database platform—environments that allow for high availability, scalability, and security.
“The MongoDB team supported us from day one. In addition to offering high performance, flexibility, and multi-cloud capabilities, MongoDB Atlas brings great functionality such as diagnostic tools and infrastructure abstraction capabilities,” comments Ygor Moretti, TAG’s Head of Cloud Services. “That enables my team to quickly identify and resolve any issues, and to ensure that data is always accessible, meaning we have more time to focus on more strategic activities.”
For example, the team uses Atlas Performance Advisor to automatically monitor queries that are considered slow and suggest new indexes to improve query performance. “The dashboard is really useful for scaling storage up or down. It automatically suggests how we can optimize the environment based on which resources are heavily- or under-used,” says Ferreira. “It’s also really easy to perform backups and point-in-time restores.”