About the Client
The client is a leading provider of digital wallet solutions designed for managing and distributing public funds in education and government. As an early innovator in the financial and government technology space, the organization partners with public sector agencies across multiple regions to ensure transparency and security in public funding. Their solution digitizes processes, enabling agencies, educational institutions, and similar organizations to automate workflows, financial analytics, and improve operational efficiency.
Challenges Faced by the Client
Our client faced a major challenge with siloed data across multiple systems and lacked a centralized data warehouse. This made it difficult to gain unified insights and optimize decision-making. To address this, they approached us to migrate their data to a modern Snowflake platform, enabling centralized analytics, while breaking down data silos.
Kasmo’s Solution
Unified Spend Analytics on Snowflake
- Delivered end-to-end Spend-related and financial analytics by centralizing all transaction data on Snowflake. Combined Spend summary visuals and views.
- Enabled export, alerts, and interactive analysis across historical trends, and drill-down from summary to transaction level.
- Interactive dashboards were delivered across Sigma, Tableau, and Streamlit with standardized filters, drill-through, alerts, and AI-driven insights.
- Snowflake served as the single governed data layer, enforcing data masking and security while supporting write-back, exports, and alerts.
Anonymous Activity and Fraud Detection
- Kasmo implemented anomaly and fraud detection across user, vendor, order, and marketplace activities, identifying high-risk relationships, unusual transaction patterns, velocity spikes, and potential collusion.
- Interactive dashboards and KPI views enabled teams to move from high-level risk indicators to transaction-level details. This is supported by threshold-based alerts, historical trend analysis, and proactive notifications.
- The solution was deployed across Sigma, Tableau, and Streamlit with role-based access, data masking, and write-back capabilities. This helps in enabling secure investigations, faster response, and operational follow-up.
Implemented Snowflake Intelligence
- Implemented Snowflake Intelligence to unify analysis across PDF documents and structured data within the Snowflake data warehouse.
- Configured natural language query capabilities to support better financial analytics, including Spend dashboards and anonymized activity.
- Designed the solution to extend traditional BI by enabling conversational analytics to both structured and unstructured data through a single platform.
Key Results Achieved
Implementation of a Snowflake-based solution enabled the client to transform how teams analyze spend data, detect risk, and access insights. Key outcomes include:
- Established Snowflake as a single, governed source for spend, eliminating data silos and manual reconciliation.
- Reduced spend analysis and reporting time by 50%-60% with unified Spend data.
- Improved fraud and anomaly detection effectiveness by ~ 40%
- Expanded self-service financial analytics by enabling natural-language access to both structured and unstructured data through Snowflake Intelligence.
- Strengthened data governance and compliance with 100% centralized security using Snowflake.
