endorsedOngoing

AWS ETL Migration and Centralized CRM for International Franchise

Services Covered:

Custom Software Development

Industry

Information Technology

Duration

111 months

Budget

Confidential

Start Date

1 May 2017

Team Size

11-15 Employees

Engagement Model

Offshore

Project Capability Score (PCS)

77/100

Good

Project Capability Score (PCS) estimates how capable Inwizards Software Technology 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

Gaithersburg, United States of America

Project Summary

Inwizards built an AWS-based ETL application in C# (.NET) to consolidate 100+ disparate custom CRMs into a centralized, cloud-hosted CRM for an international franchise. The system supports cross-time-zone operations and was developed iteratively with customer involvement. The solution is in daily use and supports over 750 active CRM/App users, and the vendor integrated into the client's project management and Scrum processes.

Key Challenges

Migrate disparate local offices to a centralized cloud-based solution
Consolidate 100+ custom CRMs into a reimagined central CRM while supporting cross-time-zone operations

Project Deliverables

ETL application to migrate disparate CRM data into a centralized system
Centralized cloud-based CRM to consolidate local office systems
AWS-hosted system supporting cross-time-zone operations

Project Solution

The vendor designed and built an AWS-hosted ETL application in C# (.NET) to extract data from 100+ disparate custom CRMs and load it into a newly imagined centralized CRM. Work followed an iterative design paradigm with frequent customer involvement; the vendor ramped staffing as needed to support changing focus and requirements.

Project Outcome

Project turned over and is in daily use with more than 750 active CRM/App users
Vendor integrated into the client's project management processes and actively participated in Scrum and retrospectives

Platforms

Tech Stack

.NET
Amazon Web Services (AWS)

Client Endorsement

Overall Review Rating

4.88

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Inwizards Software Technology's work boasts over 750 active users at any given time, ensuring the project's success. The team utilizes various tools to lead a seamless, productive workflow. The team's personable approach, flexibility, and extensive technical capabilities are their highlights.”
Duane Epperly
President
Date: 10/03/2022