Michael Lanham Email & Phone Number

London, England, United Kingdom

London, United Kingdom

London, United Kingdom

I own data management, data analysis and visualization in the Marketing department. • Designing and developing data infrastructure to improve effectiveness of marketing operations, CRM and analytics• Managing, querying and auditing our product, customer and transactional databases • Managing data flows, data quality and security across our direct marketing channel operations• Opening up new data streams to exploit new marketing opportunities, e.g. in audience targeting and personalisation• Owning data collection and analysis in market research surveys• Drawing commercial insights from our data sources to promote data driven decision making throughout the business. I produce a wide range of automated and bespoke reporting solutions:o Reporting includes monthly marketing board reports, marketing performance forecast models, weekly channel performance health checks, geo-spatial expansion insights, customer cohort analyses and product performance analysis• Presenting key marketing performance metrics to the wider business weekly Regular use of BI platforms including Qlik, DynamicAction, Web analytics and channel specific operations platforms. Expertise in SQL, MS Excel and VBA. Proficiency in HTML, and currently training in Python.

London, United Kingdom

• Responsibility for end-to-end scripting and data processing of Market Research surveys• Technical lead, specialised in the automation of scripts and data tabulation; promoting the generation of script and analysis outputs without manual input• Contributed to the technical development of the department by coaching new starters and providing technical training in practices such as script automation.• Collaborate with colleagues not involved in operations, evaluating work required, providing advice and proposing cost effective solutions to improve process efficiency, Able to translate technical details to a non-technical audience.• Champion the MRS data quality and information security standards the department adheres to.• Project portfolio spans a diverse range of scripting specifications and methodologies, for a wide range of international clients (e.g. Visa, IKEA, Coke, Costa, HSBC, Disney, TFL). Projects are managed simultaneously whilst ensuring that timing, quality and budget requirements are met. Advanced usage of scripting languages (primarily SPSS Dimensions, also SQL, VBA and JavaScript), as well as proficiency in database management (Access and Excel)

London, United Kingdom

Joined as a Trainee Data Processing Executive and promoted in December 2012. Internal transfer to TNS in October 2013. Job description as above.Clients worked with at Millward Brown included Visa, IKEA, Coke, Pepsico and Google.

Romford, United Kingdom

• Responsibility for producing fuel audit reports (in Excel), submitted to retrieve £23million in duty rebate, for a 1370 bus fleet operating across 10 depots. The role included fuel ordering for all depots and also fuel usage data collation, entry, analysis, management and submission of fuel related data and issues for all vehicles. Implemented audit report automation by overseeing rollout of fuel monitoring technology in depots. Recalled in August 2008 to train new staff.

London, United Kingdom

• Client facing role, responsible for receiving and processing UK fuel orders, creating fuel receipts and updating the order database.

Bsc Geography With Economics, Human Geography, Economics

Activities and Societies: LSE Choir, LSE Acappella Group2.1 Achieved Modules: 1st Year: Economics; Mathematical Methods; Environment.

Education record

3 A levels (All Grade A); Mathematics, Geography, Biology 1 AS level (Grade B); German GCSEs; 5A*s, 2As and 2Bs