A global plumbing products manufacturer builds a single source of truth for employee data on SAP BTP

Employee data at this manufacturer was spread across multiple source systems, each with different field names, naming conventions, and levels of completeness. Reconciling records across those systems was a manual job, and the inconsistencies made it hard to trust what any single system was telling you.

At the same time, the company's SAP BTP environment had grown without consistent governance. Platform costs were not tracked centrally, unused services were running, and administrative roles had not been reviewed against least-privilege principles. The combination of a data quality problem and a platform governance gap made it a natural candidate for a combined initiative.

Mindset ran the engagement in two tracks delivered in parallel over 14 weeks using two-week Scrum sprints.

The data harmonization track started with a field-by-field definition of employee data standards, worked out with business and IT stakeholders across the first three weeks. From there, the team built reusable transformation logic in SAP Integration Suite on Cloud Foundry to cleanse and normalize both current and historical employee records. Harmonized data was landed in standardized SAP HANA tables as the single source of truth. Automated sync pipelines with validation, reconciliation, and error-handling were built on top, and the HRDATA application was re-developed to the new field standards. Migration from the legacy NEO tenant to Integration Suite on Cloud Foundry was executed as a phased cut-over with minimal downtime.

The BTP governance track ran alongside. Mindset created a Shared Services subaccount in the BTP landscape, migrated the HDB and IAS platform services into it, tightened subaccount administrator roles to reduce unnecessary access, and de-activated unused services to reduce cost. Mindset's Resource Consumption Tracking Tool was installed to give the team ongoing visibility into platform spend.

Delivery used daily stand-ups, weekly cadence calls, and monthly leadership reviews, tracked in Jira with documentation in Confluence and SharePoint.

The company finished the engagement with a single, trusted employee data repository in SAP HANA. Cross-system inconsistencies that had required manual reconciliation were resolved by the transformation logic, and automated pipelines now keep records current without human intervention.

The migration from legacy NEO to Integration Suite on Cloud Foundry completed with minimal to zero downtime. Downstream integrations that previously had to navigate inconsistent source data can now point at the standardized HANA tables, reducing the complexity of future integration work.

On the platform side, the BTP landscape is more tightly governed: unused services are off, administrative access is tighter, and the team has cost tracking in place from the Mindset tooling installed during the engagement.