MS Access developer/Consultant

Job type:
on-site
Start date:
07/08/2017
Duration:
n.a
From:
TALENT - IT
Location:
Brussel
Published at:
07/27/2017
Country:
flag_no Belgium
Project ID:
1387923

Warning
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Consultant position description

MS Access Developer/Consultant

Job description

Our client is implementing Meridium, a new tool to report production losses. Previously this was done using the application UPbase. As the client wants to have historical data in Meridium, the data in UPbase of the past 5 years must be transferred to Meridium. However, the data in UPbase cannot be mapped 1-to-1 with the data in Meridium, as different fields are used by Meridium vs. UPbase.

An MS Access database needs to be built in order to transform the data from UPbase into sheets which can be uploaded in Meridium. For this task, the client needs support of an MS Access Developer/Consultant.

The tool needs to support the following capabilities:

  • Step 1: Import csv files in an MS Acess database and execute a limited clean-up
  • Step 2: Transform the data in a specific format and export result to excel
  • Step 3: Upload of excel back to Access tool
  • Step 4: Generate excel load files (other format)