Skip to main content

ADA helped a global retailer create a modern unified data platform on Databricks to reduce operational costs and streamline data workflows

Case Study

ADA helped a global retailer create a modern unified data platform on Databricks to reduce operational costs and streamline data workflows

The Results
0 %
Costs reduction from streamlined workflows and optimized code
0 Dashboards
Medallion architecture on Databricks enabled faster dashboard refresh rates.
Data validation measures ensured data accuracy and integrity post migration.
The Challenge

The customer is a leading global sporting goods retailer with a footprint in 56 countries and selling products from over 20 brands.

The Solution

The customer built their existing data platform on disparate cloud services (Amazon Redshift for data storage, Python/SQL for data processing, and Jenkins for workflow automation). The existing platform introduced many integration challenges that led to increased costs and reduced operational efficiencies.

ADA helped design, implement, and migrate their existing data to a new unified data platform on Databricks. We successfully resolved many technical challenges including handling and migrating diverse data sources, overcome limited support for converting Python code to PySpark using innovative solutions, and ensuring data alignment between the old platform and the new Databricks platform.

The project was executed seamlessly, preserving data integrity and security while avoiding disruptions to ongoing operations.

The Approach

Our goal is to establish a gold layer within the Databricks system, utilizing data from the silver layer for business intelligence reporting. Our approach to achieve this involves:

  • Data Source Analysis: Understand current data sources and associated codes for a clear migration foundation.
  • Code Transformation with Optimization and Quality Checks: Convert Python/SQL to Pyspark/Spark SQL, adding data quality checks for reliable data integrity and optimize it for space and speed.
  • Data Validation and Comparison: Verify Databricks data against Redshift data, ensuring seamless alignment.
  • Data Orchestration: Schedule jobs using Databricks workflows, implementing monitoring and alerts for a reliable workflow.
  • Documentation and Knowledge Transfer: Document the migration process for reference and conduct knowledge transfer sessions for enhanced team adoption.
Content
Results
Challenge
Solution
Approach
Get in touch

Let’s turn your data and AI into measurable outcomes

How Boost Malaysia Achieved 3X Efficiency and 57% Higher Engagement with CRM Integration

Case Study

How Boost Malaysia Achieved 3X Efficiency and 57% Higher Engagement with CRM Integration

The Results
0 X
productivity boost: campaign setup and execution become faster and more efficient
0 %
higher open and click rates on WhatsApp compared to other channel like push notifications and email
0
reduced cost-per-acquisition through optimized campaign strategies, achieving parity with conversion campaigns through optimized campaign strategies, achieving parity with conversion campaigns
The Challenge

Boost Malaysia, Southeast Asia’s leading mobile wallet provider, encountered critical operational hurdles in their customer engagement strategy:

  1. Campaign Complexity: Their teams spent excessive time manually managing cross-channel campaigns, creating bottlenecks in customer outreach
  2. Engagement Deficit: Traditional channels yielded suboptimal engagement metrics, particularly in open and click-through rates
  3. Data Silos: The absence of WhatsApp campaign integration with their primary CRM created blind spots in customer journey analytics
The Strategy

Through comprehensive analysis, Boost recognized the need for a unified marketing ecosystem. The solution: integrating CleverTap’s capabilities with ADA Asia’s Business Messaging Platform (BMP) to create a seamless, data-driven engagement engine. Hence ADA Asia delivered a three-pronged solution

  1. Seamless Integration: Unified CleverTap CRM with ADA’s BMP, enabling end-to-end campaign automation
  2. Precision Marketing: Deployed targeted WhatsApp campaigns using advanced customer segmentation
  3. Interactive Engagement: Implemented CTWA campaigns with intelligent bot flows, backed by real-time analytics from CleverTap and Facebook Ad Manager
The Execution
  • Deployed AI-driven customer segmentation through CleverTap for precise WhatsApp targeting
  • Established real-time performance monitoring for comprehensive campaign insights
  • Implemented data-driven A/B testing to maximize CTWA campaign effectiveness
__wf_reserved_inherit
__wf_reserved_inherit
Content
Results
Challenge
Strategy
Execution
Get in touch

Let’s turn your data and AI into measurable outcomes!

ADA used AI and Tech to improve sales forecast, inventory management and marketing strategy for a client

Case Study

ADA used AI and Tech to improve sales forecast, inventory management and marketing strategy for a client

The Results
0 %
Sales forecast accuracy, with error deflection of less than 3.7% in model validation.
Improved sales forecasting leads to better inventory management to meet sales demand
Enhanced marketing campaigns and effectively allocate budgets based on sales forecast
The Execution

A Malaysian subsidiary of the global automotive giant saw an immediate need to solve the challenge of parts inventory management and allocating marketing budgets efficiently based on anticipated sales for each vehicle model per outlet. The current flaw has impacted the sales and marketing departments – hindering campaign performance and potentially missing sales targets.

With ADA’s expertise in data management and predictive modelling, we implemented a data-driven solution by first unifying all sources of data in a Customer Data Platform (CDP), developing a forecasting model and building a dashboard for analysis and monitoring.

The automation has greatly improved sales forecasting accuracy, reduce parts inventory shortage, and ultimately,  empowering the client to invest resources to areas where they can generate the highest impact.

Content
Results
Execution
Get in touch

Let’s turn your data and AI into measurable outcomes!

ADA helped a leading ecommerce brand increase order value and customer retention rate

ADA helped a leading ecommerce brand increase order value and customer retention rate

The Results
0 %
Reduction in the time allocated for the task
Introduced an effective fraud detection approach. All team members involved in this task now consistently rely on the tool for their daily work. 
The Challenge

Our client is a global leader in consumer electronics, home appliances, and mobile communications. One of its subsidiaries, Hi-Care Solutions, specialises in providing maintenance services to customers who have contracted rental services of various LG electronics products, such as air purifiers, water purifiers, and more. Periodic customer management and routine visits are conducted to ensure the seamless operation of all related services following the rental contract agreement.

Recently, a challenge surfaced as several sales representatives unintentionally received bonuses through the contractual process. This has resulted in financial discrepancies and losses for our client.

The Solution

ADA developed a three-phased solution to effectively address the identified challenges.

In the initial phase, ADA aided in the transformation by constructing custom dashboards and transitioning fraud detection from a manual to an automated process. These dashboards were seamlessly integrated with the client’s base system data, utilising the existing detection logic.

Next, the detection logic underwent expansion, addressing complexities and volumes of data processing that were beyond the capabilities of human intervention.

In the final and ongoing phase, ADA introduced specialised artificial intelligence (AI) to enhance fraud detection, leveraging the insights derived from the collected data. This approach ensures a robust and adaptive solution to counteract potentially fraudulent activities.

Following that, the PDCA (Plan – Do – Check – Analyse) cycle was initiated. A series of interviews and workshops were held to optimise the solution. This proactive approach allowed for the rapid collection of feedback, facilitating the continuous improvement of both the detection logic and dashboards. The iterative process ensured that adjustments were made swiftly, leading to an increasingly accurate and effective solution.

The Execution

Upon conducting a thorough review to identify instances of fraud, it became evident that the manual process was too time-consuming and could not efficiently cover all cases. There was a pressing need for automation to effectively detect fraudulent activities within the workplace.

ADA automated the fraud detection process by building specialised dashboards and implementing AI, resulting in a reduction of fraud incidents.

Results
Challenge
Solution
Execution
Get in touch

Let’s turn your data and AI into measurable outcomes!

How Lotte Rental Achieved 21% Conversion Lift in 3 Months with Customer 360

How Lotte Rental Achieved 21% Conversion Lift in 3 Months with Customer 360

The Results

21% conversion increases | 10 distinct customer personas identified

0 %
conversion increases
0
distinct customer personas identified
The Challenge

Lotte Rental, a leading vehicle rental company in South Korea, had a sales effectiveness problem. Contact centre salespeople had almost no information when customers called, just a phone number and a name. No rental history, no preferences, no context about what the customer might need.

Meanwhile, IoT data from rental vehicles sat unused. Every rental generated driving behaviour data refuelling patterns, locations, driving styles that could have informed customer understanding. But this data was siloed and invisible to sales teams.

The Solution

ADA implemented Treasure Data CDP to build Customer 360 profiles with preferences, usage patterns, and purchase considerations. These profiles integrated directly with the contact centre, giving salespeople real-time customer context during every conversation.

Custom analytics on driving behaviour revealed 10 personas that had been invisible before. The personas enabled dynamic pricing based on driving risk. Within 3 months, conversion rate increased 21%.

Results
Challenge
Solution
Get in touch

Let’s turn your data and AI into measurable outcomes!

How an Indonesian Real Estate Developer Achieved 5.5X Appointment Increase with CDP

How an Indonesian Real Estate Developer Achieved 5.5X Appointment Increase with CDP

The Results

5.5X increase in appointments per month | 18% increase in booking deposits | 30% increase in total deposit value

0 x
increase in appointments per month
0 %
increase in booking deposits
0 %
increase in total deposit value
The Challenge

A leading Indonesian real estate developer with 76+ projects across 33 cities needed to improve digital marketing for new development launches. Generic ads reached broad audiences without personalization, prospects interested in luxury condos received the same messaging as those interested in affordable housing.

Without unified customer data, there was no way to personalize targeting. Each campaign started from scratch with no ability to leverage insights from previous interactions.

The Solution

ADA implemented Treasure Data CDP with personalised targeting for Facebook and Google campaigns. The CDP unified data from website visits, past inquiries, and property preferences into profiles that could drive segmentation.

Instead of broad audiences, campaigns reached segments defined by demonstrated preferences: project type, budget range, location preference, and purchase timeline signals. Appointments increased 5.5X per month. Booking deposits increased 18%. Total deposit value increased 30%.

Results
Challenge
Solution
Get in touch

Let’s turn your data and AI into measurable outcomes!

How a Top 5 Auto Manufacturer Generated $500M in Sales with CDP-Powered Intent Segmentation

How a Top 5 Auto Manufacturer Generated $500M in Sales with CDP-Powered Intent Segmentation

The Results

11% conversion rate | $500M sales generated

0 %
conversion rate
0 $
million in sales generated
The Challenge

A Top 5 global auto manufacturer in Malaysia had an 800K customer base but was treating them all the same. Marketing campaigns used broad targeting with generic messaging. Without the ability to distinguish high-intent customers from general audience, advertising costs were high relative to results.

Customer data sat in multiple systems, CRM, dealer management, website analytics, service records with no unified view. There was no way to identify purchase signals or score intent.

The Solution

ADA unified customer data using CDP, integrating showroom visits, website behaviour, service history, and previous purchases into single profiles. Identity resolution matched the same customer across systems.

Propensity scoring identified high purchase intent customers based on behavioural signals: website visits to specific models, service appointments suggesting vehicle aging, digital engagement patterns correlating with purchase timing. High-intent segments activated through app push, dealer personal selling, and Facebook Lookalike. The result: 11% conversion rate and $500M in sales.

Results
Challenge
Solution
Get in touch

Let’s turn your data and AI into measurable outcomes!

How a Global Hospitality Group Unified Data Across 400+ Properties

How a Global Hospitality Group Unified Data Across 400+ Properties

The Results

400+ Hotels | 6 Data-Sources Consolidated 

0 +
hotels unified
0
data sources consolidated
The Challenge

A global hospitality group’s APAC operations had reporting scattered across Redshift, Salesforce, CSAT platforms, Eloqua, CSVs, and BigQuery. Each source had its own schema and its own definition of what “occupancy” or “revenue” meant.

When regional leadership needed performance insights, analysts spent days pulling data from six systems and reconciling conflicts manually. Different teams ran the same query and got different answers. With 400+ hotels, leadership couldn’t trust any number they saw.

The Solution

ADA designed an enterprise reporting ecosystem using Alteryx for ETL automation, pulling from all sources into a consistent schema in an MS SQL Data Mart. Power BI dashboards with role-based access ensured everyone worked from the same underlying numbers.

Automated pipelines replaced days of manual consolidation. Regional leadership could compare properties, track trends, and make decisions based on numbers that finally matched.

 

Results
Challenge
Solution
Get in touch

Let’s turn your data and AI into measurable outcomes!

We helped a leading ecommerce retailer migrate their existing data warehouse from AWS to MS Azure while ensuring seamless business continuity​

Solution type

We helped a leading ecommerce retailer migrate their existing data warehouse from AWS to MS Azure while ensuring seamless business continuity​

The Results

100% migration accuracy | 400+ tables migrated | 200+ stored procedures migrated

0 %
migration accuracy
0 +
tables migrated
0 +
stored procedures migrated
The Challenge

A leading fashion ecommerce company needed to migrate their data warehouse from AWS Redshift to Microsoft Azure. The migration had to happen without disrupting business operations, dashboards, reports, and analytics all needed to keep running while the underlying infrastructure changed.
Any data loss or inconsistency would break downstream reporting and erode trust in the platform. The company needed migration that was fast, accurate, and seamless.

The Solution

ADA replicated AWS Redshift structures to Azure Synapse, automating the migration using shell scripts and Azkaban orchestration. The approach ensured business continuity throughout, parallel running validated accuracy before cutover.

400+ tables and 200+ stored procedures were migrated in 3 months with 100% accuracy across 90% of datasets. No data loss, no business disruption.

Results
Challenge
Solution
Get in touch

Let’s turn your data and AI into measurable outcomes!

How ADA Built 500+ Data Connectors for a Leading Data Integration Platform 

Industry type

How ADA Built 500+ Data Connectors for a Leading Data Integration Platform 

Where every touchpoint earns trust, every interaction creates value, and every decision is powered by realtime insight.
The Results

500+ Connectors | Custom Development | Global Platform 

0 +
Data Connectors
0 +
Customer base growth
0 x
revenue growth
The Challenge

Fivetran needed connectors for sources without standard integrations, regional platforms specific to Asian markets, legacy systems that predated modern APIs, and niche applications with proprietary formats. Enterprise deals were stalling because customers couldn’t connect the sources they needed.
Building connectors at scale required diverse API expertise — REST, SOAP, GraphQL, custom protocols, plus regional ecosystem knowledge that US-based teams didn’t have.

The Solution

ADA became an extension of Fivetran’s engineering capacity, building custom connectors using a hybrid Clojure and Java pipeline. Every connector met production-grade standards for reliability and security.

Over two years, ADA delivered 250 connectors covering regional platforms, legacy systems, and niche applications, unlocking enterprise deals that had previously been blocked.

 

Results
Challenge
Solution
Get in touch

Let’s turn your data and AI into measurable outcomes!