offline
Last seen: Nov 09, 2013 4:00 PM EST
Hire Me!
Rate: $50.00 USD/hour
Follow Invite to Project
 

GriffinVBA

www.LondonSoftwareSolutions.com

Username: GriffinVBA

  • Has made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has verified their secure phone number.
  • Verified
  • Payment is verified.

Location: London, United Kingdom

Member since: July 2012

Reputation:

5.0/5

(1 reviews)

3.7
[see more]

No user has recommended this freelancer.

My skills:

  • $700 USD
    5.0
    Profile image for Seller stignatius

    stignatius

    Feb 28, 2013

    I have worked with dozens of contractors over the past 12-14 years and Roy is by far one of the most diligent and professional that I have ever worked with. The project that I had him work on was very complicated and honestly, I didn't think it was possible. He was able to accomplish things with Excel that were simply amazing. He explains everything that he is working on very well. If I had any questions he was able to explain things in great detail so that I was able to understand it. I look forward to working with him on future projects!

    Project Description:We have a list of several vendors with their product data in excel format. We need someone to create for us a set of macros to format the vendor excel file to be able to import into our own excel format with just one click...
    [more]
    GriffinVBA has not completed any projects.
    GriffinVBA does not have any work in progress.
  • $125000 CLP Oct 30, 2012

    This is very easy job for the right person.*We"re looking for someone who can look up a few hundred entries for us on a website - its just 3 or 4 clicks,then copy and paste the entry into excel.Skills required: Copy Typing, Data Entry, Data Processing, ExcelSee more: data entry data extraction copy paste going work, data mining copy urls paste excel data entry work, data entry excel internet par copy paste, data conversion copy paste work, copy paste data entry excel, work home data entry type.

    [more]
  • $250 USD Oct 26, 2012

    This is for mapping 2 sets of retail category information.We will provide a file with the required details.Need to run an Excel macro to open up the mapping screen and carry out the mapping manually.At times the best fit category has to be identified based on possible synonyms. Requirements include:1. Good English skills2. Good communications & learning skills3. Excellent Excel skills4. Fast internet connection & computerWe need to do this for a number of files (estimate at least 100) each with a number of category records (range from 100 to ~12000).Would like you to provide an estimate regarding duration of task (say, time required for mapping 100 records) and a quote for the work

    [more]
    GriffinVBA does not have any open projects.
    GriffinVBA does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Excel VBA Developer

Sep 2010 - Sep 2010 (1 month)

East of England PCT (NHS)

This was a very short contract with a 60 hour deadline. The project was to create a file conversion program in Excel VBA to solve an age old problem. You have a database that needs to receive information in a certain format. But you receive update files from various sources that are in different formats (e.g. column/field names and data in the input files are in the wrong format/order, the data in the columns/fields of the input file are named different things to what is needed by your database, etc.).

Business Development & Information Analyst

Aug 2009 - Present (4 years)

Barts PCT (NHS)

Achievements:<br />1.) I have just completed an online web portal project that provides offsite clinicians with access to a networked patient database (database replicated in html using php5.3 and SQL server 2008/Access as the back end).<br />2.) I developed a fully automated staff training database using Excel VBA. This produces individual reports showing what courses each employee needs to attend and when they need a refresher (depending on their employee staff group). <br />3.) I created many Access queries to

Excel & Access VBA Developer

Jul 2009 - Jul 2009 (1 month)

Department of Health

This was a very short contract with a one week deadline. The major project was to automate the validation, cleansing, error reporting and migration of Excel based 'Ward Survey Returns' data to an Access database ('Delivering Same Sex Accommodation' database). This involved:<br />1.) Setting up the Access database and tables to transfer the Excel data into.<br />2.) Writing code in Access VBA to validate and upload all Excel workbooks in a given directory (including subfolders).<br />3.) Creating

Education

BTEC Business Studies

1991-1993