FMCG DATA ANALYTICS SOLUTIONS ADOPTS SCALABLE ARCHITECTURE

Cloud FMCG Analytics software provider adopts aws cloud for scalability- case study
Cloud FMCG Analytics software provider adopts aws cloud for scalability- case study

5 October 2020

About The Client

SnapBizz CloudTech (popularly known as SnapBizz) focuses on developing cloud-based solutions for the FMCG ecosystem (brands, retailers, consumers, and distributors) in large/medium “Kirana” stores. The company offers retailers and brands a disruptive cloud solution that enables their customers to find and order products and services online.
The solution provides smart store management and contextual visibility to retailers to improve profitability. It also connects stores with its consumers, facilitating the last mile connection.
The solution comprises a tablet, barcode scanner, thermal printer, and an intelligent external 22” consumer-facing LED display for visual consumer engagement.

The Business Need

According to Nielsen, India has more than 6.65 million Kirana stores, contributing to nearly 90% of its total trade. The global pandemic has reinforced the importance of local Kirana stores and changed how these Kirana stores function.
With the surge in demand, various demand and supply-related challenges have emerged. Social distancing and hygiene norms have made e-payment the new normal. Research suggests that the customers these stores won during the pandemic can only be retained if they offer services such as home delivery, credit, hyper-local apps, and hyper-local merchandising.
SnapBizz has been working to organize and digitize these Kirana stores to improve their profitability. However, the need to digitize everything from stocks to payments has led to an unexpected surge in traffic, affecting the solution’s performance.

The client wanted a solution that would address the following needs:

  • Focus on business innovation
  • Automate scaling of the application to handle traffic
  • Lower their infrastructure cost
  • Improve application performance

The Solution

The Cloud Consultants at Rapyder designed a scalable architecture on AWS to address the over-provisioning of resources. The solution had the following features:

  • Considered AWS Mumbai to host applications, since the user base in India
  • Hosted all servers behind the load balancer in private subnets across different availability zones (AZ) to reduce latency
  • Terminated all incoming traffic on the application load balancer, and routed them to appropriate servers in the backend to ensure a single-entry point and avoid internet exposure
  • Deployed app servers in autoscaling groups for scalability and high availability
  • Applied AWS Certificate Manager on load balancers to securely manage SSL certificates
  • Used load balancers to offload SSL certificates and send traffic to the appropriate instance
  • Used RDS MySQL in multi-AZ to ensure high availability of the global database
  • Used MS SQL standard on EC2 for reporting purposes
  • Migrated from Azure CosmosDB to Amazon DynamoDBe
  • Used AWS Data Pipeline to replicate data from DynamoDB to SQL Server
  • Used AWS ElastiCache for Redis caching

Industry: Retail

Best-in-industry POS solution for FMCG brands and retailers, POS machine, billing machine, and retail billing machine

Challenges

  • Over-provisioning of resources
  • Non-scalable architecture

Solution highlights

  • Scalable and highly available architecture
  • Used serverless NoSQL DB DynamoDB
  • Reduced operational overhead with managed service

Business benefits

  • 20% cost reduction
  • Improved application performance
  • Reduced latency
  • High availability on AWS with auto-scaling
cloud ecommerce services- serverless