Client Overview
Our client – a leading SaaS provider, offers a cloud-based finance automation platform for businesses with complex revenue models. They provide recurring billing software that automates billing, receivables, revenue recognition and investor reporting. The client aims at providing innovative solutions to businesses who are using traditional, one-time purchase transactions to recurring revenue “as-a-Service” models. They specialize in providing their online billing software to SaaS, cloud, and fintech platforms.
Challenges Faced by the Client
The client approached Kasmo, as it was facing certain challenges with their existing data infrastructure. Let’s take a further look at the challenges:
Performance Issues
The client was facing performance issues, as reporting queries took a long time to execute, often exceeding 10 minutes. This severely impacted operational efficiency and also decision-making.
Resource Contention
The client integrated OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) on the same system, creating resource bottlenecks. This further deteriorated the query performance.
Limited Support for Advanced Aggregation
The client’s current state of the data architecture lacked robust support for advanced data aggregation functions, creating challenges in data analysis.
Complexity in Reporting
The client relied on Looker as their BI tool for report generation. However, as their data volume grew, Looker’s limitations became apparent. It struggled to efficiently handle the large datasets, resulting in inconsistent data and unacceptably long query runtimes. This directly impacted on their operational efficiency, hindering timely and accurate reporting.
Kasmo’s Solutions
Kasmo helped the client eliminate the challenges by leveraging Snowflake’s cloud data platform. Here’s how our experts helped the SaaS provider enhance their recurring billing software further:
Seamless Query Conversion
Our experts converted three critical queries from PostgreSQL to Snowflake SQL syntax. This conversion improved query performance, particularly for revenue, account balance, and deferred revenue reports.
Optimized Query Performance
Kasmo optimized the queries for the client to run in 5-10 seconds, achieving a significant improvement in response times. Our experts accomplished this by utilizing Snowflake’s Dynamic Tables and enabled Query Acceleration & Search Optimization on the ingested data.
Benefits Achieved by the SaaS Provider
With Kasmo’s expertise, the client further optimized their recurring billing software. But that’s not all! These are some more benefits achieved by the client with Kasmo’s solutions:
Improved Query Performance
The optimized queries reduced execution times by over 25x. Critical reporting queries, which previously took over 10 minutes, now ran in 5-10 seconds. The client can now make faster decisions, leading to smoother business operations.
Enhanced Scalability
With Kasmo’s solutions, the client can now scale storage independently.
Simplified Data Management
With our solution, the client removed manual tuning and configuration. This allowed them to focus their shift on data analysis and business insights.
Optimized Security and Governance
Since our experts used most of Snowflake’s robust security features, including RBAC (Role-Based Access Control), dynamic data masking, and time travel, our client could enhance their security and data governance structure.
