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

Arran Mercer

Online Offline
I am a certified Microsoft Office Specialist who works as a data analyst, specialising in data migration, database creation and VBA automation. I currently work on schemes with millions of rows of data per table (upwards of 30 million for some tables), which requires auditing, migrating and cleansing via SQL. I always deliver the project within the allotted timeframe, and never increase my bid once I have accepted the project, and I can always throw in some changes free of charge!
$20 USD/hr
6 reviews
3.6
  • 100%Jobs Completed
  • 100%On Budget
  • 100%On Time
  • 10%Repeat Hire Rate

Portfolio

Recent Reviews

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

  • image of mrwilson357 Excel Presentation 2 $25.00 USD

    “Great job again...He is my favorite when it comes to EXCEL.”

  • image of mrwilson357 Do some Excel Work $25.00 USD

    “Outstanding freelancer. This guy is a true expert related to Excel spreadsheets. I would definitely use this guy again. Great work!!”

  • image of adam6023 Microsoft Access Database with Report Generation $111.00 USD

    “Great work. Great communication. Great solutions”

  • image of azzabajan Analyze some Data £10.00 GBP

    “Can't praise work enough, asked for some quick graphs to be made. He created some graphs which updated when I entered data, and they had some table with colours if the data was good! Will rehire if I need some excel magic!”

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%
  • US English Level 1
    88%
  • UK English 1
    75%

Verifications

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

My Top Skills

Browse Similar Freelancers