Welch Data Consulting has been my vehicle to help SMEs do more with their data.Key aspects: entrepreneurship | data strategy | data advocacy | product development | sales | data analysis | data science | training | researchSome of the projects I’ve worked on recently:Data Advocacy Product--------------------------------I have used the knowledge from 15 years working with data to build a product to help solve a key business problem: bridging the gap between… Show more Welch Data Consulting has been my vehicle to help SMEs do more with their data.Key aspects: entrepreneurship | data strategy | data advocacy | product development | sales | data analysis | data science | training | researchSome of the projects I’ve worked on recently:Data Advocacy Product--------------------------------I have used the knowledge from 15 years working with data to build a product to help solve a key business problem: bridging the gap between technical and non-technical teams to improve data leverage.To do this I have used Unity and C# to build a game-like application that reduces the barrier to use that some product/project management tools experience. I used my web application experience to create a web app to host this “data scene” and secured it using Auth0’s SDK. The backend is supported by a node.js server that I built that facilitates secure communication between the game and the MongoDB database through API calls. I created nearly every aspect of this product to test out the limits of this stack.I have also used my product development experience to test the product with potential clients and test my theories of where the market gap is.Other projects:ML recommendation engine for a fintech – using python for data analysis and model training and then either a Flask server or AWS lambda functions to serve the model.Geolocation relevance project – using python to conduct a website scrape and some ETL, with Uber’s H3 and lots of geoJSON plus Google and Mapbox APIs, I created a webapp to recommend locations for sporting venues.Bespoke CRM – using VBA, SQL and electron.js to build various Office based and native applications to help make client data more available for a client in the finance world. Show less

Brismo (aka AltFi Data) was a great start-up focussing on the peer-2-peer market, trying to bring clarity to a sometime opaque section of finance. The mainstay product was an index of market performance which was dependent upon processing vast amounts of lending data.Key aspects: Product Development | Product Owner | Data Analysis | Onboarding | TrainingKey skills: SQL | Python | ExcelMy tasks at Brismo included:- Quality Assurance of mainstay product- Quality… Show more Brismo (aka AltFi Data) was a great start-up focussing on the peer-2-peer market, trying to bring clarity to a sometime opaque section of finance. The mainstay product was an index of market performance which was dependent upon processing vast amounts of lending data.Key aspects: Product Development | Product Owner | Data Analysis | Onboarding | TrainingKey skills: SQL | Python | ExcelMy tasks at Brismo included:- Quality Assurance of mainstay product- Quality Checking data sources to feed to main products- Product Development:o New real estate product that required re-factoring set of main metrics for analysing indexed returns to help aid comparison of different types of lenders.o PDF-based reporting – this was a great project I undertook to meet more specific needs of clients. Through needs elicitation I identified that some clients would prefer a simplified, static report, which could be supplied as a PDF as an alternative to our Looker dashboard. I developed python and SQL scripts to pull down data and create charts for bespoke report needs which could be run as an automated process. This led to better engagement with our clients and reduced some cost burden compared to creating new Looker dashboards.o Index impact product – to unlock value of the index I developed a tool to explain the driving factors behind the index. With a simplified excel-based tool I could show to clients how and why their index values would change and we could use that to carry out spot checks. We could also forecast index impacts of current lending and conduct some stress testing. I included this in the automated PDF reporting tool that I created and this gave us a Quality Assurance product that we could share with clients before pushing their latest metrics to a live dashboard.To carry out my daily work there was a lot of excel and python-based data analysis and charting as well as a lot of SQL data querying to get to raw data for analysis. Show less

My role as a Mining Analyst was essentially excel at 30,000 feet. The jobs that I did while in this role included:- Ingesting vast amounts of technical information & data about mining projects (geological, geotechnical, metallurgical, environmental, social and political information) and then incorporating this into a financial model combined with a succinct report on the importance of the project or company and the relative value of it compared to potential peers in such a way as to… Show more My role as a Mining Analyst was essentially excel at 30,000 feet. The jobs that I did while in this role included:- Ingesting vast amounts of technical information & data about mining projects (geological, geotechnical, metallurgical, environmental, social and political information) and then incorporating this into a financial model combined with a succinct report on the importance of the project or company and the relative value of it compared to potential peers in such a way as to interest a potential client.- financial analysis of companies.- financial modelling of companies (bottom up and top down).- commodity analysis – my strong suit was copper.- building strong stakeholder relationships.- sales.- Travelling to sites to conduct inspections of assets. This could be anywhere from the northern tip of Norway to a sandy hill in 35 degree heat of Senegal.- Presenting to investor clients, sales teams, mining clients, conferences. Audiences ranging in size from 3 board members to 500 conference attendees.- Writing daily market reports about trends and shifts in valuation.While at this role I took my coverage of companies from AIM listed stocks at ~£10m market cap up to covering FTSE100 companies valued at ~£10bn. Show less