$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Turning data into insight
Stuart Kirkup
,
Bampton, United Kingdom
Experience
Other titles
Skills
I'm offering
Starting my career analysing customer behaviour and presenting insight to clients, I have developed my IT skills as a highly technical analysts with the skills to automate and streamline the process.
90% of the effort in analytics is wrangling the data, but often the people with the skills to do this are developers but not analysts.
With 25 years of experience I have the skills to present insight from vast quantities of raw data, and then build self serve content that business users can use to monitor ongoing trends
90% of the effort in analytics is wrangling the data, but often the people with the skills to do this are developers but not analysts.
With 25 years of experience I have the skills to present insight from vast quantities of raw data, and then build self serve content that business users can use to monitor ongoing trends
Markets
United Kingdom
Industries
Language
English
Fluently
Ready for
Full time contractor
Available
My experience
2020 - ?
freelance
Limited Company Contractor - Projects delivered while a director
Digi2al/Royal Navy.
Data Consultancy (SECURITY CLEARED)
Engaged by the Navy as part of Project Nelson, a Digital Transformation, aimed at developing digital applications to support the Navy
• Discovery projects to review and evaluated backend Oracle SQL databases for legacy applications. Advising on whether they we fit for purpose, and carrying out design work to propose alternative approaches
• Tech Spikes to review and recommend open source data integration software tools. Testing viability using Docker containers to replicate existing legacy infrastructure and operating systems.
• Gathering requirements for common reference data integral to the development of new applications
Engaged by the Navy as part of Project Nelson, a Digital Transformation, aimed at developing digital applications to support the Navy
• Discovery projects to review and evaluated backend Oracle SQL databases for legacy applications. Advising on whether they we fit for purpose, and carrying out design work to propose alternative approaches
• Tech Spikes to review and recommend open source data integration software tools. Testing viability using Docker containers to replicate existing legacy infrastructure and operating systems.
• Gathering requirements for common reference data integral to the development of new applications
Open source, Backend, Software, Development, Testing, Infrastructure, Support, Transformation, Oracle sql, Design, Security, Integration, Digital transformation, Oracle, Docker, Backend, Sql
2015 - 2018
freelance
Data Management Consultant
unknown.
Projects using SAS, Python, Oracle and Netezza SQL to design and build tables required by a team of 10 - including Data scientists, Analysts and Campaign managers
Leadership
• Day-to-day support, mentoring and training of 4 permanent analysts ranging from graduates to experienced staff, during a period when permanent manager was on maternity leave
• Introduced new concepts to the teams such as macro library for common tasks, process logging to improve data quality, better test and release processes for new code, and documentation standards
PAYG Datamart
• Designed and developed a series of over 30 tables and views using Netezza SQL, delivering near real time actionable behavioural data with 1 hour latency, required to deliver over 10 million targeted communications per week, as part of a Customer Lifetime Management project to drive £25m revenue
PAYG Usage segmentation
• Developed and presented behavioural segmentation to senior stakeholders, describing and quantifying the value of key behavioural groups within the base
• Segmentation was applied both within targeting of promotional campaigns so customers ensuring relevant communications for products they were interested in, as well as completely transform the value of promotional offers sent to customers ensuring more appropriate spend thresholds were used
Live streaming web data
• Setup a Google Compute Engine virtual machine to live stream web data Adobe Firehose API, using Python to collect and process JSON data
• Merged online data with customer warehouse data using Google Big Query highlighting the difference in web journeys of customers based upon their contract life stage
Leadership
• Day-to-day support, mentoring and training of 4 permanent analysts ranging from graduates to experienced staff, during a period when permanent manager was on maternity leave
• Introduced new concepts to the teams such as macro library for common tasks, process logging to improve data quality, better test and release processes for new code, and documentation standards
PAYG Datamart
• Designed and developed a series of over 30 tables and views using Netezza SQL, delivering near real time actionable behavioural data with 1 hour latency, required to deliver over 10 million targeted communications per week, as part of a Customer Lifetime Management project to drive £25m revenue
PAYG Usage segmentation
• Developed and presented behavioural segmentation to senior stakeholders, describing and quantifying the value of key behavioural groups within the base
• Segmentation was applied both within targeting of promotional campaigns so customers ensuring relevant communications for products they were interested in, as well as completely transform the value of promotional offers sent to customers ensuring more appropriate spend thresholds were used
Live streaming web data
• Setup a Google Compute Engine virtual machine to live stream web data Adobe Firehose API, using Python to collect and process JSON data
• Merged online data with customer warehouse data using Google Big Query highlighting the difference in web journeys of customers based upon their contract life stage
Test, Manager, Processes, Online, Campaign, Google, Web, Live Stream, Streaming, Management Consultant, Adobe, Support, Data quality, Design, SAS, Management, Leadership, Mentoring, Data management, Training, JSON, Oracle, API, Python, Sql
2013 - 2014
job
Campaign Insight Analyst
unknown.
Using SAS Enterprise Guide and Netezza SQL to carry out Target vs. Control analysis of marketing campaigns
• Advised campaign managers on targeting, based upon the results of previous campaigns
• Built processes to measure campaign ROI performance and check statistical significance
• Presented results and recommendations to brand and marketing teams
• Designed and implemented a Recency/Frequency segmentation of PAYG Top-up
• Performance reviewed for two supplier trials, provided KPIs that influenced the decision making process and quantified the sales uplift delivered
• Advised campaign managers on targeting, based upon the results of previous campaigns
• Built processes to measure campaign ROI performance and check statistical significance
• Presented results and recommendations to brand and marketing teams
• Designed and implemented a Recency/Frequency segmentation of PAYG Top-up
• Performance reviewed for two supplier trials, provided KPIs that influenced the decision making process and quantified the sales uplift delivered
Marketing, Sql, ROI, SAS, Sales, Analyst, Campaign, Guide, Enterprise, Processes, UP
2011 - 2013
job
Reporting Analyst
Virgin Media.
Undertook project based work to develop data management solutions using MS SQL Server, Excel VBA, Essbase, Qlikview and Oracle SQL
Finance Projects - Designed and developed 2 SQL database reporting systems to migrate complex Excel reports into server based systems with front ends, that allowed non-technical users to update processing rules
• Property Cost Management - Tracked forecasting, prepayment and accrual of £140m property costs (rates, rent, utilities, etc.) for a portfolio of over 3,000 individual sites
• Product Profitability - Financial models to allocate over 1,000 cost centres in Profit and Loss reports to specific products in order to calculate profitability.
Business Intelligence Projects - Worked as part of a project team delivering web based reporting system
• Database meta-data management tool - Created an Excel add-in that allowed DBAs to update the SQL server tables using a drag and drop interface. The interface ran stored procedures required to: manage user access rights, build new reports, add new metrics, change the publish status of reports.
• Database load tool - Created ETL load process and extensive DQ checks required to load almost 2000 KPIs from 13 large formatted multi-sheet Excel reports into SQL Server tables that delivered weekly Board Reports. Flagging values that varied significantly (2 standard deviations) from previous values seen ensured reliable data received by close of play Friday was available for 10am reporting on Monday.
Finance Projects - Designed and developed 2 SQL database reporting systems to migrate complex Excel reports into server based systems with front ends, that allowed non-technical users to update processing rules
• Property Cost Management - Tracked forecasting, prepayment and accrual of £140m property costs (rates, rent, utilities, etc.) for a portfolio of over 3,000 individual sites
• Product Profitability - Financial models to allocate over 1,000 cost centres in Profit and Loss reports to specific products in order to calculate profitability.
Business Intelligence Projects - Worked as part of a project team delivering web based reporting system
• Database meta-data management tool - Created an Excel add-in that allowed DBAs to update the SQL server tables using a drag and drop interface. The interface ran stored procedures required to: manage user access rights, build new reports, add new metrics, change the publish status of reports.
• Database load tool - Created ETL load process and extensive DQ checks required to load almost 2000 KPIs from 13 large formatted multi-sheet Excel reports into SQL Server tables that delivered weekly Board Reports. Flagging values that varied significantly (2 standard deviations) from previous values seen ensured reliable data received by close of play Friday was available for 10am reporting on Monday.
Database, Processing, Utilities, Server, Web, Analyst, Oracle sql, Stored procedures, Finance, Management, Sql, VBA, ETL, Data management, Forecasting, SQL Server, Oracle, Business Intelligence, Excel
2008 - 2011
job
Principal Analyst
Vodafone.
B2B marketing insight analyst, built propensity models to identify customer opportunities, and ad-hoc insight to support product propositions.
Developed Excel browser style reports enabling 120 Account Managers to identify churn risks and sales opportunities within their account base. Sole responsibility for end-to-end project delivery, of a solution that was presented and accepted at board level.
• Developed the initial concept, designed report layouts and gathered requirements
• Wrote the SAS scripts and Teradata SQL queries to extract and transform the data
• Built Excel reports and VBA scripts to create drill down capability
• Trained users across 6 different office locations
Developed Excel browser style reports enabling 120 Account Managers to identify churn risks and sales opportunities within their account base. Sole responsibility for end-to-end project delivery, of a solution that was presented and accepted at board level.
• Developed the initial concept, designed report layouts and gathered requirements
• Wrote the SAS scripts and Teradata SQL queries to extract and transform the data
• Built Excel reports and VBA scripts to create drill down capability
• Trained users across 6 different office locations
Marketing, Sql, Excel, B2B, B2B Marketing, VBA, SAS, Sales, Support, Teradata, Analyst, Office
2006 - 2008
job
Technical Account Director
Blueberry Wave.
Worked closely with company directors on new sales opportunities, I was responsible for taking a slice of customer data and demonstrating marketing opportunities and the potential for a marketing database.
• P&O cruises - Developed a passenger forecasting model which enabled them to create detailed marketing budget projections for the next 5 years, using base on nights on board and passenger volumes to calculate the costs of each element of their loyalty program
• Carphone Warehouse - Applied the findings of a qualitative research project to their customer database in order to quantify the size of each segment
• PC World - Ranging and merchandising project, identified product categories with the best profile for specific groups of stores
• Travel City Direct - Analysed booking database and presented back key trends, RFV segments
• P&O cruises - Developed a passenger forecasting model which enabled them to create detailed marketing budget projections for the next 5 years, using base on nights on board and passenger volumes to calculate the costs of each element of their loyalty program
• Carphone Warehouse - Applied the findings of a qualitative research project to their customer database in order to quantify the size of each segment
• PC World - Ranging and merchandising project, identified product categories with the best profile for specific groups of stores
• Travel City Direct - Analysed booking database and presented back key trends, RFV segments
Marketing, Budget, Forecasting, Research, Qualitative research, Database, Sales, Booking, PC
1999 - 2006
job
Campaign & Insight Director
Catalina Marketing.
US corporation who operate a network of printers linked to supermarket tills which triggered discount coupons, based on either the current basket or historical purchasing behavior captured from loyalty cards.
• Recruited and managed a team of 2 junior analysts and 1 programmer. Supervised the design of processes required to deliver and analyse over 70 million targeted coupons per year from a variety of campaign strategies.
• Designed, managed and coded an in-house SQL Server and VB application which was used by the client service team to manage all aspects of the coupon delivery process
• Worked alongside the MD to successfully secure a Loyalty Card pilot with Somerfield. Provided loyalty marketing consultancy, data warehouse and coupon printing services during a 2-year pilot and subsequent national roll-out. Successfully negotiated (as part of a team of 3) a £2 million/year contract to provide data and targeted marketing.
• Recruited and managed a team of 2 junior analysts and 1 programmer. Supervised the design of processes required to deliver and analyse over 70 million targeted coupons per year from a variety of campaign strategies.
• Designed, managed and coded an in-house SQL Server and VB application which was used by the client service team to manage all aspects of the coupon delivery process
• Worked alongside the MD to successfully secure a Loyalty Card pilot with Somerfield. Provided loyalty marketing consultancy, data warehouse and coupon printing services during a 2-year pilot and subsequent national roll-out. Successfully negotiated (as part of a team of 3) a £2 million/year contract to provide data and targeted marketing.
Marketing, Design, Sql, SQL Server, Data Warehouse, Service, Printers, Network, Server, Campaign, Vb, Processes
1995 - 1999
job
Account Manager
Taylor Nelson Sofres (SuperPanel).
Responsible for delivering brand performance analysis to clients; taking briefs, running reports, presenting findings. Promoted consistently and worked on many of the largest accounts, such as Lever Brothers, Elida Faberge, Coca Cola, United Biscuits, Heinz. Analysis consisted of brand performance tracking, customer profiling, macro market trends, brand switching
Account Manager, Presenting, Manager
Stuart's reviews
Stuart has not received any reviews on Worksome.
Contact Stuart Kirkup
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Stuart directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark