• Supported the editorial staff across Commodity Insights worldwide offices (Europe, Americas, and Asia) using editorial systems to produce price assessments, market news and commentaries for Commodity Insights real-time services and publications. • Led discussions and technical implementation of methodology changes for Benchmark price assessments. • Worked with price reporters, observing how they use workflows, Price Assessment platforms & templates and suggesting areas of improvements to increase productivity and data quality • Creative solutions sought for new workflows for emerging markets in collaboration with editorial leadership • Liaised with local Benchmark price Assessment leadership to understand upcoming markets and projects and plan with rest of the editorial operations team to ensure we launched these markets in a timely and smooth fashion. • Worked closely with local price reporters to gather requirements, perform analysis, write clear and concise user stories and acceptance criteria for benchmark methodology and non-methodology projects. • Managed backlogs through Azure DevOps resolving issues with quality and delivery with the development team • Effectively communicated with stakeholders for smooth project execution and facilitation of the Scrum team and related processes. • Worked with the development team to design and develop and QA the solutions to meet the business requirements and ensure that workflows are designed as per need of price reporters. • Worked on data lineage, performed data mapping to identify data gaps and work with business users to source the additional information required. • Led ‘User Acceptance testing’ with Price Reporters and supported UAT activities by providing insights on test cases and data to test the new changes. • Evaluated changes to provide feedback loop to accommodate future requirements / changes in business process and solicit stakeholders’ feedback on delivery to identify areas of improvement.

- Automation of key Excel spreadsheet and processes- System testing (Business Objects)

- Ownership of the technical aspects of the complex Excel Management / Practice accounts spreadsheets- Final production and distribution of monthly Management accounts- Sun maintenance / administration - Participation in MIS projects; user requirements and final error-testing stages- Numerous data-analysis projects in Excel for different parts of the business

- Development of complex automated excel spreadsheets to maintain and analyse pipeline and other business MI functions including forecasting and trending- Commercial modelling of new and existing clients to satisfy often competing requirements of maintaining/increasing margin and SLA’s- Client profitability reporting using Business Objects- Regular provider of external client MI- Regular analysis of internal functions of the company to reduce inefficiencies and ensure correct procedure is followed- Commercial representative in discussions about amendments to database schema/reports- Commercial support for organisational structural changes- Development of new company rate-card’s- Management of the commercial aspects of tenders / retenders- Excel support for the business

• Analysis of competitor price/range information from various sources, including Tesco’s data warehouse, using SQL • Data validation / sense-checking of Price basket data from external collection agencies and internet scraping agencies • Preliminary reporting of likely final indices/line count figures vs. competitors for senior management consumption • Insight into drivers of week-on-week change in indices/line count, highlighting where there needs to be an escalation due to major impacts/data quality issues • Writing of weekly Price reports including detailed overall/category-by-category analysis of price position and week-on-week change for senior management consumption • The construction of complex spreadsheets/databases to process, clean and analyse price data, to aid efficiency and accuracy of reporting, and to maximise the marketing potential of Tesco’s price position • Some automation of key Excel reports using macros/VBA, database queries and SQL • Responsibility for supporting/uploading all price comparison related Tesco.com features including Price Check and Price Watch pages • Ad-hoc Price projects/analysis of Tesco/Competitor price position both strategically and as a snapshot e.g Tool developed in Excel analysing competitor price cutting/promotions over time to give insight into competitor price strategy • Price-point tool developed using Pivot tables to graphically illustrate the distribution of Price points for product subgroup areas to highlight range gaps vs. customer segmentation • What-if analysis/modelling of Price cutting strategies, on margin etc. • Ad-hoc research into Tesco’s competitors • Management of cross-functional spreadsheets for price projects i.e. major price-cutting initiatives, including management of key stages of projects