endorsedOngoing

ERP Data Consolidation & Reporting for Harvest/Sherwood (Staff Augmentation)

Services Covered:

Staff Augmentation • API Development • Big Data Analytics and Business Intelligence

Industry

Business Consulting & Services

Duration

90 months

Budget

200K - 999K

Start Date

1 February 2019

Team Size

1-5 Employees

Engagement Model

Onshore

Project Capability Score (PCS)

72/100

Good

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

Harvest/Sherwood

Detroit, United States of America

Project Summary

Svitla Systems augmented Harvest/Sherwood’s IT team with .NET and SQL expertise to consolidate data across four legacy ERP systems and standardize reporting. The vendor built a central SSIS-based repository, a .NET data-management framework, an API integration layer, and Power BI/SSRS reporting templates. Their nearshore resources (Mexico) and responsive staffing improved operational efficiency and enabled standardized KPI reporting.

Key Challenges

Four disparate, unsupported ERP systems causing reporting and data consistency issues.
Need to create APIs and overlay interfaces to consolidate data into a single source of truth.
Requirement for modern .NET/SQL expertise to build a repository, API integrations, and standardized reporting.

Project Deliverables

Central data repository (SSIS)
.NET-based data management/transaction tool
API framework for ERP integrations
Power BI dashboarding interface
Standard reporting package using Power BI and SSRS

Project Solution

Svitla augmented the client's in-house team with .NET/SQL developers and formed a separate Scrum team. They built a central data repository (SSIS), developed a .NET-based transaction/data-management tool, created an API framework to integrate with four ERP systems, and implemented Power BI and SSRS dashboards and reporting templates to standardize reporting.

Project Outcome

Built a .NET-based framework for data management, a Power BI interface, a reporting database, and an API integration framework.
Deployed operational KPI reports that helped the operations team better manage shifts.
Advanced financial reporting efforts through work on rebate reporting solutions.

Platforms

Tech Stack

.NET
SQL

Client Endorsement

Overall Review Rating

4.75

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Their team’s deliverables have set the company up for success with the new databases and frameworks that boost operational efficiency. Svitla Systems is a cost-effective option that’s able to provide nearshore resources quickly, focusing on producing results with their helpful approach.”
John Vander Wagen
CIO
Date: 07/24/2019