Experience

TheFoodMarket.com

• United Kingdom
• Internet Publishing
• 1 - 100 Employee

• Catalogue Manager

  • Sep 2015 - Present



Rakuten.co.uk

• Luxembourg
• Information Technology & Services
• 100 - 200 Employee

• Business Services Analyst

  • Jun 2014 - Aug 2015

  • Preformed ad-hoc reporting to the business using custom SQL scripts written against Oracle or Teradata. It was mandatory for the scripts to run in a timely manner in order to retrieve the required information as fast as possible.• Population and maintenance of the daily KPI report. Extracting data from multiple sources (Teradata, Site Catalyst and other internal company reports) for distribution internally. The information has to be gathered and the report generated in accordance with strict daily deadlines. It is essential that the reporting is accurate as business decisions are based upon this information.• Population and maintenance of the weekly reporting pack. Information is combined from multiple sources (Teradata and Site Catalyst) then distributed internally.• Extraction of GMS data for company reports that are distributed globally. It is mandatory that the reports generated upon financial data are accurate and all figures can be explained if queried by all areas of the business. • Shared custom SQL queries and database structure with colleagues explaining any ambiguities that they may come across.• Extensive use of Microsoft Excel for report generation; this includes use of complex formulas and pivot tables.• Use of third party software (Pentaho) to create scheduled reports for consumption by the business.

• Catalogue Data Lead

  • Apr 2012 - Oct 2014

  • Business owner of a new catalogue creation process providing vital input regarding both existing and new processes.• Ensured catalogue data was relevant, accurate, eligible and legal to ensure consistency, customer engagement and compliance with laws and standards.• In house expert for all catalogue queries and expansion overseeing what should and shouldn’t be on site and which categories should and shouldn’t be present.• Used PL/SQL to query the catalogue data at the storage level (Oracle) which required a thorough understanding of the table structures and relationships. As data was reported to the business it had to be accurate and was therefore, reconciled.• Line management required the need to perform one-to-ones on a weekly basis of direct reports; this would ultimately lead to employer valuation and performance reviews.• Creation and maintenance of catalogue data input templates. These were provided to external third parties to populate and use when uploading product data into the system.

• Catalogue Data Specialist

  • Nov 2010 - Mar 2012

• Product Editor

  • Aug 2008 - Nov 2010