Software Engineer - ReMaP ds
*Please note: the service contract for this position will not be concluded with Henkel AG & Co. KGaA but with an external party”.
REMAP DS (Regulation Management Application and Process Digital Solution)
To create an audit-proof, digitally enabled regulatory compliance management system, the project REMAP DS is launched. it contains 5 workstreams: Supplier management, SHEQ (Safety Healthy Environment and Quality), PSRA (Product Safety and Regulatory Affairs) and SIS (Substance Information System) Data migration.
In the workstream SIS data migration, certain data clean-up and processing activities are the key factors to make the project successful.
The data clean-up will help to improve the quality and efficiency of the process. The legacy data needed to be migrated to the new system. For that, the data needs to be converted to fit to the new system data model and data structure.
Background to the assignment
As part of the project REMAP, we plan to migrate SIS record data from legacy system to the SAP BTP based system. This includes, among other things, the data clean up, conversion and mass processing of the legacy data for the purpose of migrating the data to the new system. The latter must be carried out in the programming language VBA/MS Macro in order to maintain compatibility with upload program. However, the programming language VBA/MS Macro has no relevance for the core products. Consequently, we do not have our own employees with sufficient expertise in connection with the programming language VBA/MS Macro and for this reason requires external expertise. The contractor used by us has extensive experience with projects that require development services in the programming language VBA/MS Macro, therefore the contractor has a unique position and provides significantly different services than the internal staff.
Concrete, detailed description of services
The services shall be provided within the framework of an agile development method. The concrete activities required in each case to implement the services commissioned shall be agreed iteratively between the parties within the framework of sprint meetings and implemented by the Contractor within the respective sprints following the sprint meetings. Prior to each sprint meeting, the contractor shall independently check, on the basis of its professional expertise, which individual services are reasonable and feasible within the scope of the assignment in the respective sprint. The sprints each have a duration of 1 week, so that the sprint meetings take place at intervals of 1 week. Within the individual sprints, the contracting parties shall coordinate the respective technical requirements for the services to be provided in daily meetings in order to achieve the compatibility of the individual components of the data process solution. The technical requirements for the services to be provided are assessed by the Contractor on the basis of its own technical assessment. After completion of a Sprint, the Parties shall conduct a "Sprint Review'' in which the Contractor reports on the feasibility and status of the services performed by it in the previous Sprint and makes a recommendation on how to proceed with regard to the services that proved to be unfeasible in the respective Sprint. All of the meetings and exchanges described above shall take place exclusively in the presence of a central contact person named by us, who shall coordinate the project on our internal side. The organisation and scheduling of the meetings described above in which the Contractor is involved shall be organised and carried out by the Contractor and coordinated with us.
- Building a technical solution which is able
- to split the data strings in CSV / Excel format based on the business rules, that will be provided in advance.
- to detect obsolete data records from the Henkel P03 and P92 system. Technical information about the systems will be provided in advance.
- do data analysis to point out data discrepancy and contradiction with the given data pool.
- The technical solution of data processing needs to be executable repetitively.
- No documentation is needed.
Possible timelines to be kept
From Jan 2022 to (including) April 2022