MS Access developer/Consultant

Job type:
on-site
Start:
07/08/2017
Duration:
n.a
From:
TALENT - IT
Place:
Brussel
Date:
07/27/2017
Country:
flag_no Belgium
project ID:
1387923

Warning
This project is archived and not active any more.
You will find vacant projects in our project database.

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)