endorsedOngoing

Data Exchange Platform and Web API for German Work-Council Education Institute

Services Covered:

Website Development • API Development • Cloud Consulting and Services

Industry

Legal

Duration

103 months

Budget

50K - 199K

Start Date

1 January 2018

Team Size

6-10 Employees

Engagement Model

Nearshore

Project Capability Score (PCS)

70/100

Good

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

Munich, Germany

Project Summary

Intellias designed and developed a data exchange platform and web APIs to integrate ERP, CRM, and third-party systems, and supported a step-by-step migration of data from MS SQL to Azure. The engagement focused on building ASP.NET Web API endpoints, OData controllers, and Entity Framework-backed SQL Server integrations. The project reached the testing phase with proof-of-concept deliverables completed and the client expressed satisfaction with progress. The client is a German work-council education institute providing seminars and related services.

Key Challenges

Develop and support an internal CRM system and data exchange between ERP, CRM, and third-party systems
Deliver new features from product-owner-defined backlogs while guaranteeing stable execution of current services
Migrate and modernize data transfer from MS SQL to Azure and replace legacy integration methods
Manage translation/localization challenges due to German wording and some client-side process/organization issues

Project Deliverables

Web API (consumer endpoints for website and app)
ASP.NET Web API backend implemented in C#
OData controllers for flexible data querying
SQL Server database integration using Entity Framework
Data migration from MS SQL to the Azure cloud platform

Project Solution

Intellias developed a backend ASP.NET Web API using C# with SQL Server accessed via Entity Framework, and implemented OData controllers to support flexible querying for consumer endpoints (website and app). They analyzed and reworked legacy integration services, implemented APIs for data transfer, and supported the stepwise migration of MS SQL-based data to the Azure cloud. The team worked in an Agile manner and collaborated closely with the client, providing a dedicated developer and project management support as needed.

Project Outcome

Reached the testing phase and completed several proof-of-concept deliverables
Endpoints created by Intellias are ready for website testing with performance reviews of the Azure setup; the client reported satisfaction with progress
Maintained an ongoing engagement with Intellias since initial work began (client cited continued relationship and satisfactory collaboration)

Platforms

Web
Cloud

Tech Stack

ASP.NET Web API
C#
Entity Framework
SQL
Azure

Client Endorsement

Overall Review Rating

4.75

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“The teams reached the testing phase — a good milestone according to the client. They have been content with the progress. Intellias cared about the company and did as much as possible to satisfy them. Their german language skills were cited as an area for improvement.”
Anonymous
IT
Date: 01/16/2017