Recent projects include:

- Propensity model for international charity. Monthly mailing volumes reduced from 65k to 45k per month, with an increase in net income of about 12%.

- Sales forecasting and econometric modelling for large car manufacturer.

- Benchmarking report for Global Expense on business expense expenditure by the UK workforce. This involved the analysis of over 3.5million expense claims GlobalExpense had processed from over 60,000 employees, with the highlights contained in a 24-page report – Employee Expenses Benchmark Report 2007 (available at http://www.globalexpense.com/contact/report.php).

- Bespoke database development for Jay Training Services: JTS provide training services for ex-offenders referred to them by the Probation Office. The first stage of this project involved identifying all the stakeholders and understanding their requirements from the database. I then wrote the functional specification. Once this was signed off by the client, I developed an Access database to help with data collection, monitoring and reporting. This project has considerably reduce administration time for JTS, giving them more time to focus on the excellent service they provide.

Provide CRM Consultancy e.g. how to develop a Customer Contact Strategy, using email and SMS as marketing channels

Data Analysis (see Broadsystem below)

Database Development and Enhancement:-
•How to ensure database meets the requirements of the Data Protection Act.
•Data cleansing – deduplication, PAF (Address updates), reformatting etc
•Using Industry Suppression files eg Deceased, Gone-aways, MPS etc
•Writing briefs/functional specifications for database and web development.
•Addition of lifestyle variables, geodemographic data, Acorn/Mosaic

Work closely with sales teams to develop any opportunities for data analysis and database development

DEVELOPED DATA ANALYSIS FUNCTION WITHIN BROADSYSTEM:
•Developed presentation and held internal roadshows to explain the benefits of data analysis. Also developed proposal template to help account managers identify the types of analysis that might benefit their clients
•Worked closely with New Business and Account Management teams to identify opportunities for data analysis.
•Built and managed relationships with data suppliers e.g. Experian, CACI, Blue Sheep, Census data etc

DATA ANALYSIS:
•Audit client business in order to clarify business and marketing objectives.
•Write proposal identifying objectives, methodology, anticipated output and benefits of analyses recommended.
•Conduct analysis. Data preparation and enhancement where required.
•Techniques used include factor analysis, cluster analysis, regression, discriminant analysis, timer series, CHAID and mapping.
• Report findings and make recommendations on using the results to enhance marketing and business programmes.

Helped Broadsystem to win the Best Customer Management Programme award at the European Call Centre of the Year Awards 2003 for work with the RAF.

Data analysis / market planning: vertical sectors, specific product analysis, marketing campaigns, segmentation and profiling, customer acquisition, retention, churn analysis, identifying opportunities for cross and up selling

Database management
•Development and implementation of CRM system (SalesLogix)
•Full systems analysis – user requirements, long term requirements etc
•Managing implementation across 5 locations, including the integration of existing data from 5 different databases and user training (approx. 70 users)
•Creating strategy for long term use and development

Provision of marketing information for Circulation/Publishers/Sales & Mktg:-
•promotional effectiveness
•distribution and price tests
•competitor information (including the development and implementation of a Market Intelligence Database)
•sales modelling and forecasting (developed EpoS database for forecasting)

Management, training and development of junior staff