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

arranmercer

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
12 reviews
4.1
  • 93%Jobs Completed
  • 100%On Budget
  • 100%On Time
  • 13%Repeat Hire Rate

Portfolio

Recent Reviews

  • image of jstncrft Script or converter to rearange and strip some columns from excel file and convert to csv txt $90.00 USD

    “I was overwhelmed with this project until Arran sent me a message. He immediately understood what I was trying to accomplish and recommended the best way to get it done. He was knowledge and pleasant to work with. I made a couple changes to the original request mid project and Arran was flexible and helpful the whole time.”

  • 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 chris186h Microsoft Access Function based on time £15.00 GBP

    “The project is not completed according to the dispute”

  • 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.”

Experience

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

Education

Mathematics & Computer Science

2015 - 2016 (1 year)

Certifications

  • Numeracy 1
    96%
  • SQL Level 1
    90%
  • US English Level 1
    88%
  • Preferred Freelancer Program SLA
    82%
  • SQL Level 2
    75%
  • UK English 1
    75%
  • VB6 1
    75%

Verifications

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

My Top Skills

Browse Similar Freelancers