Executive Summary

Cloverly made it easier to neutralize your carbon footprint and go green with a variety of Renewable Energy Credits and offset projects, such as reforestation, solar and wind farms, greenhouse gas capture, and more. Cloverly is proud to partner with reputable suppliers to connect carbon offset projects with the people and organizations looking to neutralize their carbon impact.

Customer challenge

Customer was already using AWS services like RDS Postgres for the scalability, cost effectiveness and availability offered by AWS. However, BI teams accessing the transactional database for reporting and analytical purposes was impacting the performance of the database.

Partner Solution

Solution is to separate Analytics workload from Cloverly webapp application. ITTStar, has implemented configuration driven Glue jobs to create a Data Lake in s3. Customer can update configuration files to define which objects are imported into Data Lake and define how incremental and change data is identified. CloudWatch and SNS were used to provide monitoring for the Glue jobs.

Why AWS?

Customer was already using AWS services like RDS Postgres for the scalability, cost effectiveness and availability offered by AWS. Solution provided used serverless components like AWS Glue and was configuration driven. Configuration files allow customer to include/exclude objects in Data Lake without having to modify the code. Security, cost, and performance were focused on in deciding all services, file formats, partitions etc.

Why customer chose ITTStar?

To solve this business challenge, ITTStar engaged with Cloverly on a workshop to walk them through the process we are going to follow and the perks the client accessing the transactional database for reporting and analytical purposes will now be able to see boost in the performance of the database after we separate Analytics workload from Cloverly webapp application.

Results & Benefits

  • Automated the end-to-end process of Data warehousing and Analytics
  • Increase in customer experience by reducing production database downtime
  • Elevated the overall analytics experience for the customers
  • Created an end-to-end serverless architecture
  • High data security trough IAM policies and permissions
  • Added data archival for data warehouse.
  • Metrics captured from Quicksight Dashboard for better business decisions.
  • Decrease in incident response times through log and event monitoring and alert generation.

About the Customer

Cloverly helps organizations go carbon neutral or carbon negative. Cloverly has built powerful API that calculates carbon emissions and purchases offsets and Renewable Energy Credits in real time to mitigate the environmental impacts of everyday activities.


Customer Testimonial

I just wanted to say thanks for the excellent work the ITTStar team did for us on the data lake project. We really appreciate the high-quality work and professionalism. I appreciate the flexibility of the ITT team with the QuickSight POC. That was very helpful to us to visualize the next steps.

/* */