EndorsedendorsedOngoing

Serverless Data Lake, Data Warehouse & System Integration for Nonprofit

Services Covered:

Big Data Analytics and Business IntelligenceCloud Consulting and ServicesCustom Software DevelopmentManaged IT ServicesStaff Augmentation
Project hero — replace with case study imagery
Industry
Industry

Non-profit Organizations

Duration
Durationinfo-circle

48 months

Budget
Budget

200K - 999K

Start Date
Start Date

1 September 2019

Team Size
Team Size

6-10

Engagement Model
Engagement Model

Nearshore

Project Capability Score (PCS)

gauge meter
73/100
Good

Project Capability Score (PCS) estimates how capable Bluesoft is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS


Client

Confidential

map Switzerland

Project Summary

BlueSoft Sp. z o.o. was hired by a nonprofit organization to design and implement a serverless data lake on AWS, build a data warehouse and business data marts, and integrate systems such as Salesforce and Workday using MuleSoft. The engagement included delivering Tableau visualizations and multiple system integrations. The work reduced maintenance costs, improved scalability, reduced manual data-integration work, and delivered crucial reports to senior management. The client praised BlueSoft's project management, transparency, and proactive, skilled team.

Key Challenges

  • Data warehouse development and maintenance.
  • Data lake design and implementation on AWS (serverless).
  • System integration based on MuleSoft.

Project Deliverables

  • System integration including CDM build on Mule and interfaces between Salesforce, Workday, and other systems.
  • Data warehouse development and business data marts with Tableau visualizations.
  • Serverless data lake design and implementation on AWS (Redshift, S3, Kubernetes).

Project Solution

BlueSoft designed and built a serverless data lake on AWS and implemented a data warehouse and business data marts. They delivered system integrations (CDM on Mule) connecting Salesforce, Workday, and other systems and produced Tableau visualizations from the datamarts. The vendor participated in requirements gathering, implemented business data marts, and executed cloud architecture using AWS services (Redshift, S3) and container/orchestration tools referenced in the engagement.

Project Outcome

  • Replacing existing project with a data lake, reducing maintenance costs and enabling scaling.
  • Delivering crucial reports to higher management.
  • Connecting different data marts in the data warehouse.
  • Reducing the amount of manual work related to data integration and MDM.

Platforms

  • CloudCloud
  • API/Integration PlatformAPI/Integration Platform

Tech Stack

  • Amazon Web Services (AWS)Amazon Web Services (AWS)
  • Amazon RedShiftAmazon RedShift
  • S3S3

Client Endorsement

Overall Review Rating

4.88star5 out of 5 stars

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

Thanks to BlueSoft Sp. z o.o., the client has scaled their business and delivered crucial reports to higher management. The team has excellent project management skills and is very transparent. Overall, they're efficient, professional, and proactive; they stand out for their capable team members.

Arkadiusz Garbacz

Business Intelligence Solution Manager

Note: This endorsement is based on publicly available client feedback from external review sources.

More Projects by Bluesoft