Jonathan Anderson Email & Phone Number

Horsforth, England, Gb

Helping clients improve their content, marketing, and communication workflows by streamlining processes, ensuring smooth collaboration and maximizing the value of work management solutions across the content supply chain.Implementation of Adobe Workfront & Fusion are central to delivery as well as the expanding integration of content platforms providing synergy and automation to the clients marketing and business processes.

Leeds, United Kingdom

Senior Associate working on a number of different projects for various clients. These includeApr 2022 - Present - Implementation of Workfront and Fusion software for 2 major FS companies. Initially within Marketing and expanding to group services.Jan 2020 - Mar 2022 - SSE/OVO Group Implementation of Workfront MRM software for a major energy services clients marketing team. Process mapping and automation of key tasks in their work management solution and key user support and training required.Jan - Dec 2019 - Lloyds Banking Group: Marketing Analytics and Executive reporting build, enhancement and maintenance using SQL, Tableau and Excel for production of KPI's across a broad range of product & service metricsJul - Dec 2018 - Lloyds Banking Group: Analysis of complaint handling strategy using multiple data sets and FRESCO segmentation data to enhance reporting and root cause analysis capability

Leeds, England, United Kingdom

Independent Marketing Operations consultant and Business Analyst. Specialist knowledge of Workfront, Aprimo and other MRM solutions, Process Optimisation, Data Analytics & Insight, and Marketing.

Remote

Configured 10+ marketing processes into Aprimo MRM, including additional process optimisation and reporting. Worked with internal system admins and subject matter experts to deliver detailed workflows and subflows along with required system attribute configuration to support.

Halifax, United Kingdom

SQL Server Data feed processing and SQL Views setup:Following the delivery of Tableau server and desktop we worked on continuing to enhance our data capability. The dashboards in Tableau server were run on manually updated data sets, and locally hosted files in excel or access format. We sought to automate this process by using a secure file gateway (SFG) to import our external suppliers data files, then SQL agent jobs and integration services packages (SSIS) were programmed to perform an ETL (extract>transform>load) process to append and update new data into a set of SQL server database tables.To begin with, I scoped data requirements and created documentation including data dictionaries & models, and business, functional and technical specs for the data feed(s) we required from each supplier. I managed the external stakeholders at each supplier (Google, Hitwise, Nielsen and IPSOS) to ensure they produced design documentation which matched our briefing, and a data feed or number of feeds which satisfied the requirements of our specified data model. With requirements satisfied, I engaged with internal and external technical teams to set up a data feed connection between the supplier side SFTP and our secure file gateway. After successful testing, live files were received as per their specified delivery schedule, and SSIS packages were built to handle the import of these data files into the SQL server database tables. Using SQL Server management studio, I then tested the integrity of the received data by comparison to our previous (manual) feeds using SQL queries, and set up SQL views to allow our tableau dashboards to read the data from the same source structure as it's previous data source (excel/access), as well as going through a data clean up process across multiple sources in order to bring consistency to key fields in reference data sets.

Halifax, United Kingdom

Implementation and embedding of Tableau analytics software:Worked as business analyst in a project team to implement Tableau server as the strategic analytics tool in group brands & marketing, and tableau desktop as the dashboard creation and data processing tool in marketing performance.A phased rollout approach for multiple business areas within marketing (performance, strategy, planning, and communications primarily) was undertaken, I identified key individuals that would benefit from usage of the analysis software in the first instance, forecast license costs accordingly, co-ordinated with the supplier and IT department to distribute these to the individuals in question and set up the appropriate training for each user type [classroom developer training for Tableau Desktop, and webex training for Tableau Server users (i.e.:analysis consumer)].Additionally I identified and established a core user group of developers to be ambassadors for the new software within the performance teams, who were quickly upskilled with advanced training in order to better support the wider user group. I also created a network hub within the LBG intranet using sharepoint and jive software for technical resources to have a universally accessible repository, and give the developers a workspace for creative discussion and problem solving, while going through the transition of moving excel reports to tableau.

Halifax, United Kingdom

Big Data Analytics proof of concept:Representing Group Marketing on the delivery of a proof of concept project, in collaboration with Retail Chief Operating Office and Group Digital divisions, to test the capability of a big data analytics tool. Projects focussed on 3 broad use cases to understand the end to end customer journey across all channels and brands in more detail. Benefits to Marketing include enhanced multi-channel attribution modelling, probabalistic event based modelling capabilities, highly improved text analytics and npath analysis.

Halifax, United Kingdom

Responsible for the mapping, management, optimisation and automation of marketing processes across all divisions of Lloyds Banking Group.Currently managing the configuration and implementation of Marketing Resource Management software supplied by Aprimo across all divisions of LBG. I have become an advanced user of several modules within the Aprimo offering, including Workflow configuration & admin, Analysis and reporting configuration, scheduling and admin, Activity, Project and Digital Asset Management, and all aspects of Aprimo tools

Halifax, United Kingdom

Managed the monthly direct mail campaigns for the customer acquisition portfolio, which consisted of 6-10 different mail packs comprising multiple offers and pricing.

Chester, United Kingdom

Completed a number of placements in areas within the Personal Loans product business, including Sales, Pricing, Risk, Marketing Analytics, and Marketing.

Bsc Mathematics & Computer Science, Applied Maths, Combinatorics, Chaos Theory, Algorithms, Object Oriented Programming, A.I, 2:1

Activities and Societies: LU Kung Fu Club member & secretary 2005 - 2007

Cim Professional Diploma In Marketing

Activities and Societies: I self funded and completed the qualification via distance learning in parallel with my full time role Marketing.