Sales BI

Posted Dec 1, 2020
Project ID: 2641126
40 hrs/week
3 months
Starts: Jan 1, 2021
Ends: Mar 31, 2021
Payrate range

*Please note: the service contract for this position will not be concluded with Henkel AG & Co. KGaA but with an external party”.

Project Name: Sales BI


Project Description

The service is requested as part of the project Sales BI. The project has the purpose to provide reporting on daily sales information based upon SAP COPA and manual flat file data for the business units A / B / L worldwide.

The project is working in an agile methodology. Sprint duration is two weeks. Further assigned changes for smaller project integration requests are running in classical waterfall mode. The expertise of the external Consultant is needed for the changes, as internal expertise is not available.

Concretely, detailed task description without personal reference, which reveals the independency of the service provision

The scope of services includes the following tasks, which are independently performed by the external contractor:

The contractor will work on the subcomponents (Features) “Sales in Excecution”. Purpose of this subcomponent is to allow business users to report on open orders, open deliveries and open invoices which not yet have been invoiced. 


  • Functional and technical consulting of business analysis and facilitate documentation of business requirements that will be validated and approved by Henkel.
  • Independently implement the needed business functions (as described in the task above) in the application’s business core layer including the related deployment activities. 
  • Implement the required functionality (according to the above-mentioned business requirements) in Sales BI tabular model. Basis for the sign-off are the overall Definition of Done (e.g. “documentation done”, “functional test passed”, acceptance criteria refined for each underlying item as well as provided test cases). 
  • Establish and align data quality KPIs for the subcomponents (features) as mentioned above according to the business requirements (mentioned above)
  • Perform functional unit testing; in case of business requirements (mentioned above) are not working, fix to be applied, starting at point 1 again.
  • Conduct guiding of user testing (business acceptance testing), referring documentation mentioned below, by introducing the new subcomponents.
  • Functional consulting of documentation of business logics and procedures that will be validated and approved by Henkel.
  • Handover of implementation to internal and external maintenance organizations according to above mentioned documentation.


Used tool stack: Azure Cloud services, team foundation server (Azure Dev Ops), Microsoft Azure DWH Microsoft Azure Analysis services tabular model



Possible timelines to be kept:

The following timelines are to be adhered to by the contractor during the performance of the service:

All activities are part of the overall application roadmap. The functional component have to be ready to use end of April 2021. 

90 % remote, 10 % onsite. German & English must have

Similar projects

+ Search all projects