Profile image of arranmercer
Member since November 18, 2014
1 Recommendations


Online Offline
I am a certified Microsoft Office Specialist who works as a Data Consultant, specialising in data migration, data cleansing and VBA automation. I use SQL, SSIS, VBA, Excel and Access primarily within my role, however I can also use C# & Python for automation.
$20 USD/hr
10 reviews
  • 100%Jobs Completed
  • 100%On Budget
  • 100%On Time
  • 14%Repeat Hire Rate


Recent Reviews

  • image of jasoncollectorc Data handling - removing duplicates $5.00 USD

    “Great job! Very nice individual to work with. Arran was patient and understood the requirements quickly and delivered on time. It was also easy to communicate. This was a complex project but Arran worked hard to make sure it was done correctly. Would absolutely hire again and again.”

  • image of df3000 Excel Tool to delete rows of data that do not include our inputted text £85.00 GBP

    “Great guy, easy to work with. Delivered exactly what was required and went above and beyond to help me with whatever I needed. Will definetely use again.”

  • image of bgilpatrick Excel Graph Program $300.00 USD

    “It was a great experience and he worked with me until the report was just what I was looking to use.”

  • image of chris186h Passthrough Query filtering £30.00 GBP

    “Arran was very understanding and worked well delivering several modified versions to help achieve the correct outcome. Will definitely call upon again.”

  • image of cjdavis Create automatic email reminders from excel spreadsheet £107.00 GBP

    “It was a pleasure to work with Arran. He understood all of my project needs and executed on them efficiently and accurately. He delivered the project as I had requested, ahead of the agreed due date and for a fair price. He has extensive knowledge of Visual Basic and I would happily work with him again on future projects.”

  • image of seo1com Database Cleansing $130.00 USD

    “Arran did a great job of sorting and cleansing my database files. He merged approximately six separate databases, which were themselves amalgamations of one and other, then removed all duplicated instances and other records to my preferences. Great work Arran 5 Stars all the way!”


Data Analyst

May 2016

I’m currently employed by BeProtected Insurance ltd. I’m currently overhauling all the reporting techniques used by the company and introducing more advanced analytics for management. Other responsibilities include: • Desktop support • Automation (VBA, basic python) • Power BI reports • Amazon Web Services • Google Analytics • Creating SQL/MySQL Databases

Data Analyst

Feb 2015 - May 2016 (1 year)

I create the internal reporting systems and databases for the company. I use SQL, VBA and Access to create the internal data structure for the large corporate team within our business. I use T-SQL to query my data, and then output this in dashboards for management using pivot-graphs and tables. Other duties include: • Excel automation • Project work • Communicating with stakeholders • Desktop support • Training staff members • Networking • IT Training • Project work


Mathematics & Computer Science

2015 - 2016 (1 year)


  • Numeracy 1
  • SQL Level 1
  • US English Level 1
  • Preferred Freelancer Program SLA
  • SQL Level 2
  • UK English 1
  • VB6 1


  • Facebook Connected
  • Preferred Freelancer
  • Payment Verified
  • Phone Verified
  • Identity Verified
  • Email Verified

My Top Skills

Browse Similar Freelancers