LogoAlan Craig Data Science Portfolio Architecture


Career Projects: 2008 to 2023

R logo

I have been A Data Analyst since 2008, and below is a short summary of my career history and credentials. With a Master's degree in Data Science and Analytics and machine learning skills in Python and R, I can bring up-to-date skills and experience to your team or project. Recently In 2023, I completed a Data Science Bootcamp certification from the market-leading provider in Berlin. I seek permanent or contract Data Science or Data Analyst roles.

Project 1

Predict customer purchase propensity and segmentation models: JOHN LEWIS PARTNERSHIP, LONDON, AUG 2015 – JAN 2016

Completed a detailed data mining project with one of the UK's leading retailers to build models to predict customer purchase propensity and segmentation models and to investigate the role of browsing behavior on purchasing. The project involved building models SAS programming and using Enterprise Miner. This project was in partial fulfillment for the postgraduate master's degree award.

PDF Icon Download Project Thesis document
Project 1

Retail Food Tray Optimization Tool: Marks and Spencer's 2016

Delivered solutions for M&S supply chain crate and lorry packaging optimization problems for the whole UK network to maximize storage capacity in their food package trays for optimal sales.

PDF Icon Download the Tray size Optimization document

PDF Icon Download the Bar height Optimization document
Project 1

Intelligent Counting and Retail Waste units and optimisation: Marks and Spencers 2016

Developed analysis as part of the wider Intelligent Counting Project being conducted by the M&S Retail team .Identification of products within at store level where the product has been counted more within a 28 day period. The average Waste (units) and (£GBP) is then calculated between these count points for each of the 4 inaccuracy categories: Understated, Overstated, Critical, and Accurate. Identify opportunities the average waste (unit an GBP) for products that have counted more than once within a 28 day limit in order to explore the relationship between waste and inaccuracy.

PDF Icon Download the Intelligent Counting Overview

Read More

Project 1

Trustpilot Reviews Web Scraping tool: Homeserve 2017

For Homeserve Plc, I created a Web Scraping tool that extracted all the reviews from multiple web pages to create a basic text analysis report.

Read More

Project 1

Customer Segmentation of Cruise Passenger data

For a marketing Agency in 2016 I built Cluster segmentation model for their crusie-ship client Roal Caribbean and using an extract from their customer data customer database. The analysis was performed using SAS code and a Hierarchical cluster model was built.

Read More

Dashboard and Reporting Projects

python logo

I have been coding with Python for 5 years, and the list below contains a selection of more recent Python projects.

Project 1

Tableau dashboard on crime and poverty: 2014

What are the relationships between poverty and affluence versus crime in London between 2008 and 2011

PDF Icon Download Dashboard Powerpoint file

View Tableau Public Dashboard

Project 1

AUTOMATED CAMPAIGN SELECTION TOOL, BSKYB (SKYIQ) 2012

Built a marketing campaign selection tool using Visual Basic for Applications for our Molson Coors client using Sky data. The tool was used by visiting Salesforce staff on pub or restaurant visits to select suitable campaign based on the postcode location. After the selection, an automatic email was sent to our marketing team from the Excel tool saving time for the client.

PDF Icon View the Campaign Tool
Project 1

Prescription Data Trends dashboard: IMS Health 2011

Designed an automated Visual Basic for Applications tool to create a product level report for our Pharmaeutical clients on prescription data from UK panel pharmacies

PDF Icon View the Prescriptions Tool

SQL and Database Projects

python logo

I have been coding with Python for 5 years, and the list below contains a selection of more recent Python projects.

Project 1

Web enabled Database document system using PHP CSS and HTML and MySQL: 2015

Developed a fully functional web enables Document management system using PHP and MySQL. The Website enabled database was designed as a fully relational database with full referential integrity in place.

PDF Icon View a video of the final Application

Read More

Project 1

DATA QUALITY RFM SCORECARD DESIGN AND REPORTING, HCL WORKFORCE PLC 2012

Developed advanced SQL scripts to identify database data quality improvements. I conceived and developed the code for a data quality scorecard methodology and RFM analysis. This resulted in vast improvements in database searching methods leading to new sales opportunities. Developed business exception reports (SSRS 2008) to monitor future data quality.

PDF Icon View final Analysis Report

Read More

Project 1

MARKET SHARE VISUALISATION EXCEL DASHBOARD, DR FOSTER INTELLIGENCE: 2011

Designed and built a client market share dashboard. This was a SQL server back end tool with a visual Excel interface using vba programming and Transact-SQL for the database extracts. The tool allowed the client to view market share statistics for disease categories at PCT geographic healthcare entity.

Read More

Project 1

Dashboards using Postrges and AWS

In this project, I build an Amazon Metabase dashboard by construction the the Northwind Database inside Postgres. The data is about “Northwind Traders”, a fictional company. The database contains all sales transactions between the company and its customers as well as purchases from Northwinds suppliers.

Read More

Contact

Lets get in touch and talk about your next project.