{"id":29,"date":"2015-10-24T21:16:06","date_gmt":"2015-10-24T20:16:06","guid":{"rendered":"http:\/\/www.aaronhatton.co.uk\/blog\/?p=29"},"modified":"2015-10-24T21:17:54","modified_gmt":"2015-10-24T20:17:54","slug":"a-programmer-in-an-administrators-role","status":"publish","type":"post","link":"https:\/\/www.aaronhatton.co.uk\/blog\/index.php\/2015\/10\/24\/a-programmer-in-an-administrators-role\/","title":{"rendered":"A programmer in an administrators role"},"content":{"rendered":"

\"348_Time_Management_Doodle_Concept\"<\/a><\/p>\n

Since I was young, I held a keen\u00a0interest in computers. I always wanted to understand as to how they work and sought to customise them as much as possible. It was at the age of 13 that I began\u00a0to publicly share my interest in computers by founding a website design company with the ambition to improve the internet’s quality of content. I wanted to bring it out of the 90’s and to the new millennium (this was in 2009 but even then few small businesses had websites).<\/span><\/p>\n

As I got older, my coding and programming knowledge increased and I went from coding HTML\/CSS to PHP while editing other languages for fun or small projects such as LUA, C#, C++, .NET, JAVA etc. My working career however took a very different track as I went into IT Support, wanting to understand more about corporate infrastructures, the problems they face, supporting them, and how to build\/design them. Thankfully, I was very lucky with the companies who employed me and received the exposure I looked for very quickly,\u00a0<\/span>managing\u00a0to grow into the roles and progress my career rapidly.<\/span><\/p>\n

It wasn’t until having started a new job in March of 2015 (a\u00a0<\/span>new role at a previous employer), where my career took a massive turn from being in a re-active role to pro-active role. I had taken an office\/administration job in an IT Company. The role consisted of a wide range of features involving spreadsheets of data and reports, long processes and lots of\u00a0<\/span>onus\u00a0weekly tasks.<\/span><\/p>\n

From the first week, I noticed how much time was being wasted and so started to streamline the processes; creating complex excel formulae in order to achieve the same results as 5-10 minutes worth of copy and pasting, creating PHP scripts which would grab publicly available information and add it to spreadsheets, saving days of work. As time went on, the level of time spent creating the spreadsheet templates increased,\u00a0<\/span>but\u00a0the time wasted\u00a0<\/span>copying and manually manipulating\u00a0data reduced to almost nothing.<\/span><\/p>\n

When starting a major project of migrating thousands of products between two servers, the gloves came off and the real fun began. The original expectation was that this was going to have to be done manually, taking months to complete. Every product would have to be moved manually, data copied and pasted into the new format, and time waiting for the servers to respond. Not if I had anything to do with it…<\/span><\/p>\n

Creating multiple PHP scripts using API calls, CSV data imports and Excel spreadsheets for data formatting,\u00a0I\u00a0had created a library of tools at my disposal to which I had turned the months of work into hours. A few clicks of the mouse and it was done. Thousands of products moved across and all while I went to lunch!<\/span><\/p>\n

Hiring someone who has an understanding of programming for an administrator role isn’t always the best use of resources. However, if they are a hobbyist programmer like myself and\u00a0<\/span>enjoyed\u00a0a challenge, then it can save hours, days and even months of time. This is time they can spend helping grow your business and focusing on completing other more important tasks.<\/span><\/p>\n\n

Tweet<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"

Since I was young, I held a keen\u00a0interest in computers. I always wanted to understand as to how they work and sought to customise them as much as possible. It was at the age of 13 that I began\u00a0to publicly […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[12,3,16,4,15],"class_list":["post-29","post","type-post","status-publish","format-standard","hentry","category-meet-the-author","tag-api","tag-author","tag-excel","tag-quote","tag-scripts","dwtl normal"],"_links":{"self":[{"href":"https:\/\/www.aaronhatton.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/29","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aaronhatton.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aaronhatton.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aaronhatton.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aaronhatton.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=29"}],"version-history":[{"count":2,"href":"https:\/\/www.aaronhatton.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/29\/revisions"}],"predecessor-version":[{"id":32,"href":"https:\/\/www.aaronhatton.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/posts\/29\/revisions\/32"}],"wp:attachment":[{"href":"https:\/\/www.aaronhatton.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=29"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aaronhatton.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=29"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aaronhatton.co.uk\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}