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

Industry
Business Consulting & Services
Duration
5 months
Budget
200K - 999K
Start Date
1 February 2019
Team Size
1-5
Engagement Model
Offshore
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
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
ERP
Tech Stack
.NET
SQL
Client Endorsement
Overall Review Rating
4.75
5 out of 5 stars
Timeliness
Cost Rating
Willing to Refer
Quality of Deliverables
With the new databases and frameworks their team delivered, we're more efficient operationally and set up to succeed. Svitla Systems is a cost-effective choice that can supply nearshore people fast, and they stay focused on getting results with a helpful attitude.
Note: This endorsement is based on publicly available client feedback from external review sources.
More Projects by Svitla Systems
Endorsed
Completed
Financial Services
Claims Management Platform for Civil Insurance Company
Services Covered:
+1 more
Endorsed
Completed
Software Development
Staff Augmentation — React, Django, Python & AWS Hosting
Services Covered:
+3 more

