Moray Barclay

WORK HISTORY

EDUCATION

SKILLS

ABOUT MORAY BARCLAY

My projects really start when I type a few lines of code. Then a table starts to appear on the screen. It looks OK, so I grab a coffee. When I return the table is complete, typically showing a few dozen columns and millions of rows which always gives me a fleeting sense of fascination - then the real work can begin. The assignment would have been triggered earlier with a conversation which started something like this: “We can solve this problem using data that we already have.”I am an experienced Data Analyst with two strings to my bow. Firstly, I have data analytics skills in hands-on coding, big data and cloud computing, enabling me to deliver software applications and data-driven recommendations derived from complex operational and financial data sources. Secondly, I have consulting skills enabling me to deliver complete data solutions from concept to technical delivery, including documentation and stakeholder management at all levels and across all functions including c-suite leaders, business owners and operational managers.An FMCG wholesaler had a problem as they could not assign their overhead and therefore they had no detailed knowledge of the net profitability of individual products or customers: they knew the details of each order line but not the overhead activities required to fulfil that order line. From scratch, I built an application to determine Cost-To-Serve at their order line level based on Activity-Based Costing principles, enabling re-negotiation of SKU costs and customer pricing. I enjoy assignments where I am pathfinding in this way, because it requires me to conceptualise solutions and sell ideas to a range of stakeholders, as well as implementing them in code. I find this comes naturally to me; I have previously driven technology innovation in the public transport and telecommunications industries, for example pioneering on-board public transport media. Data Analyst & Business Insights Skills Coding complex models/ python & SQL Deploying cloud solutions / Azure Integrating business insights / Power BI Data analytic platforms / Alteryx Unstructured data / MongoDBConsulting & Leadership Skills Gathering stakeholder requirements Creating data artefacts Programme & stakeholder management Coaching & mentoring Leading team delivery / Jira