Chalo partnered with Quantiphi and Snowflake to modernize its data infrastructure, enhancing scalability and efficiency. Using the Gen AI accelerator Codeaira, Quantiphi facilitated a seamless migration from AWS Redshift to Snowflake delivering the project two weeks ahead of schedule and saving opportunity costs.

About the Client

Chalo is a leading mobility solutions provider committed to transforming public transportation systems through digitisation, making daily commutes more efficient, accessible, and reliable for millions.

Problem Statement

Their platform integrates data, operations, and decision-making processes to improve the experience for operators and commuters alike. As they expanded to newer geographies, with massive volumes of real-time data flowing in from diverse sources such as buses, GPS devices, and payment systems, their operations became highly data-hungry. The need to exponentially scale their infrastructure was imperative.

Challenges

“Our biggest challenge was migrating 3000+ queries from AWS Redshift to Snowflake while ensuring minimal disruption.”
Atmesh Mishra, AVP, Platforms Chalo

Lack of a Unified Data Strategy: Disparate tools slowed decision-making and increased operational costs.
Resource Contention: Infrastructure limitations hindered scalability and operational efficiency.
Scalability Issues: Performance bottlenecks emerged due to the inability to handle growing data volumes.
High Operational Costs: Long query runtimes led to unnecessary expenses and inefficiencies.

The Solution

Quantiphi set up a Snowflake data platform on AWS cloud for unified data management and carried out seamless data ingestion.

The key elements of the solution included:

Unified Data Platform: Setting up Snowflake for consolidated data storage and processing, enabling workload isolation and supporting both structured and semi-structured data.
Accelerated Query Migration: Leveraging Quantiphi’s Gen AI code conversion accelerators to expedite the query migration process, ensuring seamless integration.
Enhanced Data Consumption: Enabling data analysis and reporting through Metabase and Periscope, improving accessibility for business users.

“By combining our expertise with Snowflake’s powerful data platform, we collaborated with Chalo to build a scalable and efficient data ecosystem. This showcases how strategic partnerships can drive innovation, optimize operations, and create smarter businesses for the future.”
Bhaskar Kalita, Executive Sponsor, Snowflake Alliance and Global Head of Financial Services and Insurance at Quantiphi

Impacts

3000+

queries converted

40-50%

faster conversion with Codeaira

Unified data platform for faster decision-making
Improved query performance with streamlined architecture
50% increase in query conversion using Codeaira
3000+ queries were converted and consumed via Metabase
Built future-proof and scalable infrastructure capable of handling diverse and growing data sources

Technology Used

Snowflake

codeaira

periscope

Metabase