I work as an independent consultant for several clients, providing knowledge, training and skills for specialised projects outside of day to day needs. I frequently work with sensitive data, and I am involved with most aspects of management information, reporting and business analysis. My usual services involve consulting on data modelling, KPI design and how to structure complex data sets for rapid interpretation where the end user does not have a technical background.Designing, specifying and drafting reports and visualisations, using Visokio Omniscope, D3.js, javascript & HTML5Evaluating visualisation APIs and writing training materials for client staffWriting key SQL extracts to generate management reports and decision support toolsDesigning and building back end databases, using Vectorwise and MySQL, interfacing with SQL Server & OracleCost structuring and supplier analysis in preparation for RFPsAnalysis and evaluation of RFP returnsBrand portfolio strategy - evaluating a large portfolio of brands for a global manufacturer with a view to rationalising the portfolio to create a select group of more valuable brandsOlympic sponsorship - modelling the financial impact of London 2012 involvement for a major sponsorAdvertising mix optimisation - benchmarking of advertising spend mix for a company looking to improve conversion rates and build stronger customer relationshipsBrand valuation - assisting Millward Brown with the analysis which builds into the BrandZ annual top 100 brands report

Primarily responsible for a sourcing project for a regional retailer which involved writing an RFP and building a cost model to evaluate returns- Frequent client contact to manage data requests and generate buy-inConducted fuel and temporary labour benchmarking for a distribution contract, including drawing conclusions and writing the presentation

Brought in on a team of five to help write the corporate strategy for a large travel management companyResearch work focused on analytical and qualitative understanding of industry profit pools and cost structuresQuantified the future impact of inter-player and macro-economic pressures on cost structure, revenues and industry structure

Extensive VDD and CDD work covering retail, manufacturing and service industries across EuropeParticular focus on understanding sales by channel and type to understand the distribution of value within a companyVaried analytical work, requiring spreadsheet design, pivot tables, macros to enable financial projections, database analysis and risk modelingPerformed sales analysis on $17k of IMS Health dataConstructed a historical London bus contract databaseQC of spreadsheets to a standard suitable for client handoverTaught Excel to junior staff and prepared a VB web-query guideDeveloped time management skills as a result of 50-50 allocation, long working hours, the need to meet deadlines and work undertaken for non-UK officesPhone interview experience with clients, customers and competitors in many industriesManaged and ran European interviews of senior physicians paying €200 each in France and Germany

Helped a friend set up and run an import and distribution company specialising in high end car audio equipment from the USA. I produced the system which worked out prices, profits etc. for each product based upon the current exchange rate.