Data & Analytics Consultant

• Jun 2021 - Present

Project Lead - Systems

• May 2021 - Jun 2021

Qlik Consultant

• Apr 2021 - May 2021

Short term contract covering employee on sick leave Short term contract covering employee on sick leave

Qlik Consultant

• Dec 2020 - Mar 2021

- Short term contract - working with a customer to initially extend their existing QlikView dashboards- then to convert dashboards into Qlik Sense - Short term contract - working with a customer to initially extend their existing QlikView dashboards- then to convert dashboards into Qlik Sense

QlikView Consultant

• Apr 2019 - Dec 2020

Taylor Wimpey are one of the UK's biggest house builders. Based in Birmingham (near Solihull) I am working in the BI Department on a number of new QlikView projects for the Commercial and Production Teams, as well as for Senior Management. The main focus is on simplifying the interface as much as possible to encourage user buy-in.Projects undertaken so far include:• Template design on which all projects will be based• Business Focus - summarises many data sources for C Level• Operational Focus - summarises many data sources for Management Level• Materials Pricing - allows price and usage analysis of resources such as bricks, tiles, etc by supplier• Supplier Resolution - allows analysis of feedback by supplier to help assess SLA performance• Build Duration - allows analysis by Business Unit/Region etc of build performance• CVR Early Warning - helps Internal Audit assess how well Business Units are adhering to business processes and provides risk assessment of contracts• NHBC Surveys - allows customer questionnaires to be analysed• mSite Usage - provides a simple check on which Business Units are scanning completed stages• BOQ Data - benchmark and compare costs from budgets located in the ERP system• Issue Tracker - allows analysis of customer issues and their resolution• Logistics - first stage of a full Logistics Dashboard (only includes OTIF in this release• Feedback - allows analysis of customer feedback• Help To Buy - provides details on risk associated with Help To Buy builds• Stamp Duty - provides details on risk associated with builds likely to be affected by Stamp Duty• Supplier Task Analysis - allows analysis of suppliers - how well they are performing

Qlik Consultant

• Feb 2019 - Apr 2019

Working for Marshall Aerospace (Cambridge) on their Aircraft Performance application – which tracks the progress of aircraft maintenance and build. Also working for the Managed Services Department who handle support calls (fixes and enhancements) for all of Differentia’s customers. Also converting QlikView JDE Templates into Qlik Sense. Working for Marshall Aerospace (Cambridge) on their Aircraft Performance application – which tracks the progress of aircraft maintenance and build. Also working for the Managed Services Department who handle support calls (fixes and enhancements) for all of Differentia’s customers. Also converting QlikView JDE Templates into Qlik Sense.

QlikView Consultant

• Jul 2018 - Feb 2019

Taylor Wimpey are one of the UK’s biggest house builders. Based in Birmingham (near NEC) I’m working in the BI Department on a number of new QlikView projects for the Sales and Purchasing Teams, as well as for Senior Management. The main focus is on simplifying the interface as much as possible to encourage user buy-in. Taylor Wimpey are one of the UK’s biggest house builders. Based in Birmingham (near NEC) I’m working in the BI Department on a number of new QlikView projects for the Sales and Purchasing Teams, as well as for Senior Management. The main focus is on simplifying the interface as much as possible to encourage user buy-in.

QlikView Consultant

• Apr 2018 - Jul 2018

Working on a short-term contract at home using QlikView and Qlik Sense to develop dashboards for a couple of Quick2Discover customers. Quick2Discover is a registered partner with Qlik and our team are specialists in setting up, implementing and developing visual dashboards (Business Intelligence) using the QlikView Business Discovery platform. Working on a short-term contract at home using QlikView and Qlik Sense to develop dashboards for a couple of Quick2Discover customers. Quick2Discover is a registered partner with Qlik and our team are specialists in setting up, implementing and developing visual dashboards (Business Intelligence) using the QlikView Business Discovery platform.

QlikView Consultant

• May 2017 - Nov 2017

Abbott Nutrition is a leader in nutrition science, research and development. They make specialist products that help support unique nutritional and therapeutic needs of babies and adults. Based in Maidenhead and part of the UK based operation. I was brought in to develop a QlikView “template” that would give a consistent look & feel for all new dashboards. I was also asked to assist with the redevelopment of the many existing QlikView and Excel spreadsheet dashboards. The QlikView projects are primarily driven by the Sales and Marketing teams. However, Finance have recently discovered the benefits of BI and are now demanding dashboards. 8 dashboards have been successfully implemented using the new template with many more in the pipeline.

QlikView Consultant

• Sep 2016 - Mar 2017

Royal Mail is recognised as the UK’s most trusted letters and parcels delivery company. Based in Chesterfield I was a member of the Group Business Intelligence team. We were working on the Finance Transformation Project. This was looking to replace all the Finance Team’s current reporting applications with new QlikView applications. Royal Mail is recognised as the UK’s most trusted letters and parcels delivery company. Based in Chesterfield I was a member of the Group Business Intelligence team. We were working on the Finance Transformation Project. This was looking to replace all the Finance Team’s current reporting applications with new QlikView applications.

QlikView Consultant

• Jan 2015 - Aug 2016

Differentia Consulting are a Premier QlikView Reseller. I initially spoke to them in August 2010 regarding JDEdwards roles. However, they suggested I retrain as a QlikView developer. They were keen for me to cross train into QlikView so that I could help to both support their existing JDE customer base and encourage them to use QlikView.Since then I have become a certified QlikView Designer/Developer. Differentia act as an agency supplying me with work both on an adhoc and a longer term basis. My roles normally involve designing and developing dashboards but also include mentoring and training in-house QlikView developers.Worked on many QlikView projects, including:-+ Aggregate Industries (Leicester)+ Bakkavor Group (Lincolnshire)+ British Sugar (Peterborough)+ Carillion Telent (Lancashire)+ CEL Group (Warrington)+ Certas (Fife)+ David Lloyd Leisure (Hatfield)+ DTZ (London)+ DX Group (Nuneaton)+ Health Lottery (London)+ Interface (Halifax)+ Limagrain (Lincolnshire)+ Miller Group (Edinburgh)+ Moorhouse Insurance (Caerphilly)+ National Nuclear (Warrington)+ Paragon Group (Castleford)+ Pepsico (Leicester)+ Recology (San Francisco, USA)+ Sanctuary Personnel (Ipswich)+ Sure Group (Liverpool)+ Tanimura & Antle (California, USA)+ Trident Seafoods (Seattle, USA)+ UK Oracle User Group (London)+ York Minster (York)A full list of customers is available at www.alanjwatt.com.

QlikView Consultant

• Aug 2010 - Aug 2015

QlikView Consultant

• Sep 2015 - Dec 2015

AstraZeneca is a British-Swedish multinational pharmaceutical and biologics company headquartered in London. It is the world's seventh largest pharmaceutical company. I joined the team in September 2015 to assist in the global implementation of their various QlikView systems.There are 4 applications in the “family” known as Manufacture Me (MMe). I am responsible for:• Inventory Stock Tolerance – which assists AZ companies around the globe to plan their stock holdings. We currently have around 200 users per month in 32 different countries• Plan Adherence – which helps global planners check how AZ companies are performing against their plans. This is a new application and has around 30 users in 10 different countries but the intention is to roll it out globally.The team works in an “agile environment” and consists of a Project Manager, database people and QlikView people. There are around 20 in the team: SAP experts, Oracle DBAs, testers, QlikView designers and developers. Each month tickets on the “Backlog” are pulled together into a “Sprint”. The KPI owners are consulted and the Sprint is agreed. The team then works together to ensure delivery of those fixes, changes and enhancements.

ERP Analyst Developer

• Apr 2010 - Jul 2010

20:20 Mobile are the UK’s number one distributor of mobile phones.Member of the JDEdwards Project Team – assisting in the implementation of JDEdwards EnterpriseOne (Release 9.0) ERP software throughout the group.Attended the Oracle BI Publisher course and developed several documents, including Despatch Note, Invoice, Order Acknowledgement, Remittance, Statement and Pick Lists (which include barcodes).Roles include: systems analysis; design; development (both interactive and batch applications).Due to a downturn in the company's business I took voluntary redundancy rather than wait to be pushed!

IT Consultant

• Mar 2005 - Apr 2010

Silentnight Group are the largest bed manufacturer in the UK.Member of the JDEdwards Project Team – assisting in the implementation of JDEdwards EnterpriseOne (Release 8.9) ERP software throughout the group: Silentnight Beds, Sealy, Rest Assured, Pocket Spring.Roles include: systems analysis; design; development (both interactive and batch applications); data migration. Silentnight Group are the largest bed manufacturer in the UK.Member of the JDEdwards Project Team – assisting in the implementation of JDEdwards EnterpriseOne (Release 8.9) ERP software throughout the group: Silentnight Beds, Sealy, Rest Assured, Pocket Spring.Roles include: systems analysis; design; development (both interactive and batch applications); data migration.

IT Consultant

• Apr 2003 - Feb 2006

Designing, developing, marketing and selling software to integrate PDAs and other handheld devices with JDEdwards ERP software. Also general JDEdwards consultancy.Also designed and developed a warehouse management system to be sold as a packaged solution to small businesses.As one of the two directors of the company I was responsible for the day-to-day running of the company, marketing and pre-sales activities, as well as project managing and co-ordinating the developments.The company stopped selling software with the merger of our two biggest rivals in the JDEdwards space. They became the JDEdwards preferred partner and meant that there was no future market for the software. The other director now supports the existing customer base himself.

IT Consultant

• Mar 1998 - Apr 2003

Jade is focused on organisations with £20-£150m turnover in the Consumer Packaged Goods and General Distribution sectors in the UK.My job description covered managing all technical aspects of customer implementations from contract agreement to completion, including project resource control, education, training and consultancy. To assist in the sales cycle from initial contact through to contract delivery. To develop customer specific solutions using the OneWorld Toolset.Responsible for all things technical within Jade, covering:-+ Management and mentoring the Jade Technical Team+ Pre-sales technology demonstrations and presentations of all technical aspects of OneWorld CNC, Toolset, data warehousing, and e-business+ Pre-sales applications demonstrations and presentations in the areas of Sales, Procurement, + Human Resources, Customer Service and Plant Maintenance+ Post-sales contract negotiations, specifications and agreements+ Post-sales installation and implementation of OneWorld, including customisation of, and extensions to, OneWorld using the Toolset and other third party tools (inc VB, SQLServer, Access, Excel, etc)+ Leading the Technical Team in terms of application specification, and development+ New product developments, i.e. vision, management, development, marketing, and sales for add-on products+ Designing and developing bespoke systems in OneWorld+ Management, planning and administration of development / technical deliverables.+ Quality assurance of program objects, application of standards, interfaces and procedures.+ CNC Consulting and planning, stress testing, volume testing, upgrades and service packs.+ Analysis and Design of integrated custom solutions with the One World toolset and enterprise functionality.