Edward Hatt-Lipscomb

Experience

• 

  Pearl Music Europe

  Jun 2008 - Jun 2008

  Work Experince

  2 weeks work experience, shadowing departments such as marketing, product design, finance, customer service and logistics.

• 

  Toybox

  Sept 2008 - Jan 2009

  Volunteer

  I volunteer at this charity as part of extra curricular activities whilst at school.

• 

  Oxfam

  Jan 2009 - Jun 2009

  Volunteer

  I volunteer at this charity as part of extra curricular activities whilst at school.

• 

  Greensand Trust

  Sept 2012 - Jun 2013

  Voulunteer

  Skills used Customer service Cash Handling Food Preparation Waitering Health and Hygiene Teamwork Cleaning the premises and washing up Top line summary I volunteered at a local charity in between my studies. My duties were to serve the customer and keep the cafeteria clean and tidy.

• 

  Homebase

  Aug 2014 - Jan 2015

  Cleaner

  Between University studies, in the summer (Aug-Oct) and in the Christmas beak (Dec-Jan)I worked as a cleaner cleaning the Homebase store in Leighton buzzard

• 

  Leicester Deaf Action Group

  Sept 2015 - Apr 2016

  Marketing Consultant

  Skills used Microsoft Office (Word, Excel and PowerPoint) Market Research Teamwork Communication Social Media Top line summary As part of university module, I was a consultant to the LDAG, where I proposed they use social media to increase their brand awareness, as my previous marketing research had found they lacked brand awareness in their catchment area. I also advised to set up a Facebook selling page as this would further entice customers to visit the charity and create a source of revenue. I also advised LDAG on how to capturing customer details to produce a database of customers. I then suggested how the LDAG can utilise their database, by creating (direct mail) marketing communications. However before I could suggest the LDAG on how to create and maintain a database I had to study the law on data protection (1998). Show less

• 

  GI Insight

  Jun 2016 - Mar 2017

  Marketing Analyst

  Skills used Microsoft Office (Word, Excel and Access) SQL server Teamwork Communication Top line summary • • The role was to assist in the management of the Pets at Home marketing communications. This involved finding the right customers, to send the various communications, using data interrogation on an SQL server database.• The output was specified by the client, but were mainly customer hunting, farming or harvesting briefs.• Preparation of PowerPoint presentations, used by senior management of Pets at Home, for internal use and monthly client meetings. The presentations included charts, graphs and pivot tables, made in Excel.• Analysis of customer purchase baskets to capture potential secondary lines (new products) for sales expansion. This additionally involved customer profiling, age, gender and other demographic information.• Analysed customers using the FRAC framework.• Specific Ad-hoc reports would include charts showing client store performance, turnover, segmental analysis, product line and customer behaviour patterns including loyalty card usage. • Analysis of previous promotion and targeted activity evaluation, was to assist in the marketing campaign to send targeted personalised vouchers to customers encouraging repeat business. • The skill set required for the above requires organisation and a methodical mind set together with a grasp of relational data and information management. Show less

• 

  Argos

  Sept 2017 - Aug 2018

  Central Operations Planner

  Skills usedIn-depth level of Excel (Index formulas and Excel Macros)Good level of Access (Macro, advanced queries and formulas)Teamwork CommunicationTop line summary •The role encompassed working in Central Operations, the Department which monitors and controls the internal stock regulation between the UK Argos warehouses.Accurate and timely reporting is required, with the allied skills of good personal administration and orderly working practices.• To analyse, control and monitor the real time online system, across all different Argos product categories and ranges. •The reports that I was responsible for I converted into an Excel macro. This not only speeded up the process but made the report more accurate and time efficient.• I additionally reviewed other reporting and processes, and undertook, of my own initiative, modifications so they too became more streamlined and operationally efficient. Show less

• 

  Leadership Skills Foundation

  Sept 2018 - May 2021

  Data and Insight Analyst

  Skills used Microsoft ExcelSQL server Crystal ReportsSSRSTeamwork Communication Top line summary • The role was a 2nd/3rd line support analyst. Supporting the functions of the relationship management team by providing several reports and insights.KPI reports and Sales reports (both using Excel Power Query and several pivot tables). Additionally to modernize exiting reports and to develop new reports on the database to be more suitable for the end user. Show less

• 

  Geomatrix Ltd

  May 2021 - now

  Office Systems Analyst

  Wide raging duties form Profit & Loss Reporting, logistics including commercial invoices and OPR's to three types of invoicing.