Käyttäjän arranmercer profiilikuva
@arranmercer
Jäsen alkaen 17. marraskuuta 2014
1 Suositukset

arranmercer

Online-tilassa Offline-tilassa
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.
dollaria20 dollaria / tunti
11 arvostelua
4.1
  • 100%Suoritetut työtehtävät
  • 100%Budjetin mukaisesti
  • 100%Ajallaan
  • 13%Uudelleenpalkkaamisaste

Portfolio

Viimeaikaiset arvostelut

  • käyttäjän jstncrft kuva 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.”

  • käyttäjän jasoncollectorc kuva 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.”

  • käyttäjän df3000 kuva 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.”

  • käyttäjän bgilpatrick kuva 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.”

  • käyttäjän chris186h kuva 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.”

  • käyttäjän cjdavis kuva 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.”

Kokemus

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

Koulutus

Mathematics & Computer Science

2015 - 2016 (1 year)

Todistukset

  • 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%

Varmennukset

  • Facebook yhdistetty
  • Suositeltu freelancer
  • Maksutapa varmennettu
  • Puhelin varmennettu
  • Henkilöllisyys varmennettu
  • Sähköposti varmennettu

Omat vahvimmat taitoni

Selaa samanlaisia freelancereita