Jun 16, 2021
No image
Ongoing

SOLD.com

$100,000+
more 1 year
United States, Irvine
2-5
view project
Service categories
Service type
Custom Software Development
Web Development
Domain focus
Real Estate
Solution type
Business Software
Programming language
Java
JavaScript
Frameworks
Node.js
React.js
Spring

Challenge

It was necessary to use MongoDB with setup backups, scaling and managing. The platform had limited calls to Salesforce per minute, so there was a need to increase it. The client wished to be able to view analytic reports. Needed to reach stable server working in a period of high customers activity (Tom Ferry summit etc.).

Solution

We decided to choose MongoDB Atlas cloud database service, which covers the mentioned demands. We chose Amazon SQS for the purpose to stretch in time all calls to Salesforce from all microservices. Used Stitch to setup ingesting data every 30 minutes to Redshift database from MongoDB, Salesforce and PostgreSQL. Then we used Looker to create charts from Redshift tables. Made a decision to set-up autoscaling instances in case if CPU utilization is over 80% during 3 minutes.

Results

Received Inman Innovator Awards in 2019. After we implemented the idea of ​​selling slots in Zip - in the first month, it delivered company $50k. We are currently working to reduce costs on AWS: In September, they paid $8400. Forecast for November - $7000. And we also plan to reduce it to $6600 this week. Implemented a tool for salespeople to help identify agents. The service "guaranteed display" will be useful to them.