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:
Strong analytical 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
No reviews yet.