Portfolio and Projects

Data architect, ETL designer and Analyst. PostgreSQL, MSSQL, MySQL, MariaDB, Oracle, BSD Base, Custom In Memory Heaps. Yes I’ve written loads of ETL processes. Maybe a hundred, maybe more. I’ve never drawn a line between the process of assessing the business flows and modelling it in data – yes I do both – yes I can use Erwin or Visio or LucidChart if you want UML and ERD and other architectural artifacts. Yes I do know TOGAF.

Specialised in Retail Data Science but everybody has customers; that do things, on a time basis; for a volume; generating a baseline; and normalised divergences and outliers; and opportunities for engagement, relationship building, and transactions. My knowledge of statistics is functional, bachelor level but very practiced given 15 years of analytics and business intelligence.

Because I have years of marketing I will constantly be asking but: Why did they? What is the motivator? Is it a segmentable trait? How can we persuade them to do it more? What causes people to do that less? What would make them loyal? How do we create trust? Where are volumes weak? What is a good combination bundle? Was the pricing for us or for the market? What is the objective performance of the promotion? How can we trade that up? How can we trade it across?

Simple counting and incidence observation has value – but it is hardly going to contribute to business leadership – we need less obvious interrogation, behavioural consideration, fuzzy aggregation, dirty data resilience and we all ultimately want ACTIONABLE INSIGHTS.

I’ve done custom reports for daily operational use. Cognos reports. PowerBI. Some Dynamics NAV C/AL, and frameworks that look for strategic content alongside operational needs.

Technology for differentiation, not imitating, making anew, leaders not followers, making dreams electric.

Anybody and their dog can ask customers to fill in a survey on a tablet – but nobody goes home and tells their friends about that. We need to dig deeper to make the right choices around technology. Some low hanging fruit, some audacious goals, not the blinkered thinking insanity of paper converted to a screen – a new vision that is achievable and mind blowing.

Making the ideas real, building the foundations, the processes, the services, the finishes, the elegance and efficiency. As happy running the team as writing the code.

I know a lot about governance, and process, and accounting, and marketing, and management, and law – all things that make my architecture sit right with businesses in different stages of their success. Nimble and innovative, leaders on the block, powerhouses of volume, diversified specialists – I’m good at asking the right questions to orient our developments to being agile and effective, our teams enthusiastic, and our skills transfer sustainable.