Back to search results
Post a job
image description

Interfacing legacy system and database implimentation and design

Location:Cape Town, South Africa (From home)

Education level: College/University
Education field: Computer Sciences
Years of experience: more than 5
Attributes that best describes:
Independent worker
Strong analytical skills
Good communicator
Pragmatic
Curious

Skills:
I AM AN EXPERT IN EXCEL, ACCESS, VB AND MACROS
I have many years working with databases this includes design queries forma reports and importing and cleaning data from external sources.
Please send me a message so that we can have a dialogue SKYPE = kapekmonho
Below is an example of previous project ----- interfacing equipment to database then Reporting -
Receive raw data from an instrument usually csv, tab, ore some obscure thing. This could be a table format or just long list. I would then convert it to a spread sheet, the data in a table format.
Data was highlighted on this spread sheet exported in very specific csv format. This data was imported into our “Lab information system”. From there I extracted information from the database using SQL and created a report consisting of tables. These were then checked and automatically emailed to the client. Some of these spread sheets are still in use 10 years later.
See two examples of my work in drop box link, Copy line below and paste into the browser
https://www.dropbox.com/s/vtkeym2snrduyjv/LAB%2013%20b%20SARM%2012%20CRM449AXRF.xls?dl=0
https://www.dropbox.com/s/sbhqv8wq1zhibhv/gy%20pierre%20%284%29.xlsm?dl=0
Regards
Stuart

 
 
Contact by email View CV
 

Reviews

No reviews yet.

Top companies trust Workhoppers

  • Kognitive Marketing
  • Pharma Sciences
  • Le Chateau
  • Promo-Staff
  • Mega-Brands
  • Advantage Sales and Marketing