Summary
Overview
Work history
Education
Skills
Languages
Languages
Timeline
Generic

Jack Saward

East Harling,Norfolk

Summary

Experienced ERP QAD Super User with extensive expertise in cloud-based ERP systems, specialising in data integration, cleaning, and validation. Demonstrates proficiency in ERP data analysis and process implementation, driving process automation deployment and effective data migration planning. Skilled in transforming large data extracts and imports, utilising Excel, Power Query, and Xlookups for monthly KPI reporting. Committed to enhancing operational efficiency through strategic data transformation and migration initiatives.

Organised Data Administrator skilled in managing large datasets and ensuring data integrity. Streamlined data entry processes, significantly reducing errors and improving accuracy. Known for delivering timely reports and enhancing database efficiency, contributing to smoother operations and better decision-making.

Overview

5
5
years of professional experience
2018
2018
years of post-secondary education

Work history

ERP Data Administrator

DwyerOmega,PST,Michell Instruments
Ely, Cambridgeshire
09.2023 - Current
  • Responsible and managed item creation process for the QAD group with over 300 users and maintenance of large volumes of part numbers.
  • Created automation workflows in ERP system to ensure smooth and accurate item creation for all involved stakeholders such as finance, planning, engineering and purchasing.
  • Monthly reporting on key performance metrics to ensure our SLAs are being adhered and improve lead times.
  • Data analysis & Data cleansing
  • Managed Pricelist process for the QAD user group and updated and maintained pricelist data in the system
  • Oversaw key item descriptor process for customer facing documentation for the QAD user group.
  • Key member in group wide projects in terms of Data with the following: Upgrade to QAD ERP system, transformation of historical configured items to single, flat level items in 2024,2025, and 2026. Centralised item data creation process for the QAD group.
  • Addressed data discrepancies and validated data integrity to ensure accurate reporting.
  • Improved data quality by implementing stringent data validation procedures.
  • Corrected data entry errors to prevent duplication or data degradation.
  • Assisted in data migration tasks, ensuring data integrity and accuracy.
  • Resolving data queries using ticket systems such as: FreshService, HelpDesk and Plumsail
  • Assisted in moving core PST/Michell item data onto different ERP systems such as Syteline and SAP.
  • Worked closely with external contractors on solving core data processes in the ERP system
  • Worked close with product managers on item data related queries and part numbering identification for their products.

Order processing and customer care assistant

Carl Zeiss Ltd
Cambridge, Cambridgeshire
11.2022 - 06.2023
  • Troubleshot glitches and provided techniques to smooth workflow for customers.
  • SAP ERM management for the Consumer optics business group, including managing the following processes:
  • Processing orders, over 2300 placed and a value of £2,4 million.
  • Full returns process, raised credits, returned for credit for the customer.
  • Invoice queries which included the following: incorrect pricing adjusting, re-raise invoice with correct value. Raising and invoicing our 160+ dealers.
  • Credit management - Raising credits, keeping up date to list of accounts on stop and liaising with the accounts department.
  • Processing purchase orders for Carl Zeiss vision for our dealers.
  • Cross company orders.
  • Full use of Microsoft packages, Excel, Word, OneNote, Powerpoint, Outlook and Teams.
  • Used Zeiss based SharePoint and working documents on our local platform Igrafix
  • Try-Zeiss website which was launched as an innovative trade-in promotion campaign.
  • Worked with our ambassadors to promote the Zeiss brand with the following: Creating loan agreements for the ambassadors and influencers, assisting with the loan stock and keeping it up to date, sending out and collecting the loaned product and promoted try-Zeiss with the ambassadors.
  • Assisted with the build and organizing of events for the business group, such as global birdfair 2022 and 2023
  • Large part of logistics management with the following responsibilities
  • Regular stock audits of internal product and marketing materials and also warehouse audits. Worked alongside the supply chain inventory manager to assign correct location for the goods.
  • Goods in/out for all product for the Consumer optics business group
  • Commercial invoices for overseas shipment. Including taking repairs from customers and shipping to Germany for service.
  • Creating dispatch forms for UK and overseas shipments.
  • Account responsibilities which included the following: Working on sharepoint/Masterdata, writing processes for SAP systems, creating new accounts/vendors and editing existing accounts/vendors.

Marketing Assistant

Carl Zeiss Ltd
Cambridge, Cambridgeshire
06.2022 - 02.2023
  • Created innovative social media posts and schedules to drive engagement.
  • Coordinated meetings between project members and clients to develop ideas, discuss progress and set goals.
  • Built partnerships with influencers and brand ambassadors to expand brand awareness.
  • Conducted market research to refine digital advertising campaigns.
  • Collaborated with marketing managers, clients and partners to support marketing strategy development.
  • Learned strategic methods for social media ad creation, management and optimization.
  • Used Google Analytics to evaluate content performance and gage interaction from digital posts on linked in and Adobe Marketo.
  • Organized events around the UK for the different business groups, RMS, IQS, MED and COP.
  • Helped with the setup and procedure of AGMs and staff xmas party
  • Sourcing and purchasing of marketing materials
  • Managed the events Smartsheet for the four different business groups, also worked on the campaign and budget Smartsheet.
  • Booked events for the business groups.
  • Use various digital marketing tools such as, Intergrate, sharepoint, SAP CRM, Google analytics, salesforce, powerBI and marketo.

Social media content creator

Capikooa
Cambridge, Cambridgeshire
04.2021 - 10.2021

● Wrote content and uploaded it to the company wide drive content
management system.
● Applied current editing and photography tools to tell great stories.
Develop original content through social listening and independent sources.
● Created and posted product photos on Capikooa's website. Posted daily on the company's social media sites such as Instagram, YouTube and tiktok.
●Produced various pieces of relevant and highly-engaging video and photography content, heightening opportunity for increased
user interaction.
●Developed a high-performing social media strategy, tangibly boosting company visibility, engagement and profile. Social media strategy plans created for each months that I was employed for various types of content. Strategy plans for, Instagram, Youtube, Instagram reels and tiktok
●Worked closely with our Graphic designer and content leader to improve brand guidelines, ensuring content consistency across platform.
●Closely observed current content trends and created timely articles to meet reader demands and harness opportunities for traffic growth.
●Utilized Photoshop and Affinity designer to create engaging content across our social channels to increase engagement and diverse content, whilst also editing and shooting new product for the company website.

Education

Bachelor of Arts - Media Studies

Anglia Ruskin University
Cambridge
09.2016 - 08.2019

A-Levels - Media, Sociology and History

Impington Village College
Cambridge, CAM
02.2013 - 07.2015

GCSEs -

Nordregaard Skolen
Copenhagen

Skills

  • Cloud-Based and client based ERP systems knowledge
  • ERP QAD Super User
  • Data integrating
  • Data cleaning and Data validation
  • ERP Data analysis
  • Process implementation
  • Process automation deployment
  • Data migration planning
  • Data Migration
  • Data transformation
  • Monthly KPI Reporting
  • Excel, power query, data validation, Xlookups,
  • Large Data extracts and imports

Languages

Danish

Languages

Fluent In Danish

Timeline

ERP Data Administrator

DwyerOmega,PST,Michell Instruments
09.2023 - Current

Order processing and customer care assistant

Carl Zeiss Ltd
11.2022 - 06.2023

Marketing Assistant

Carl Zeiss Ltd
06.2022 - 02.2023

Social media content creator

Capikooa
04.2021 - 10.2021

Bachelor of Arts - Media Studies

Anglia Ruskin University
09.2016 - 08.2019

A-Levels - Media, Sociology and History

Impington Village College
02.2013 - 07.2015

GCSEs -

Nordregaard Skolen
Jack Saward