Jason Farrar Email & Phone Number

Leeds, England, United Kingdom

* Leading a small team of business intelligence analysts* Developing dashboard and reporting solutions in Qlik & Tableau* Employing agile team workload practises using Jira sprints* Developing complex reporting applications to enable the measurement of research award impact* Designing databases to secure sensitive personal information for central submission and analysis

Leeds, England, United Kingdom

* Maintained and developed the NIHR Academy data warehouse* Developed new dashboard and reporting solutions in Qlikview and Qlik Sense, and enhanced existing reporting* Managed and developed ETL processes in SSIS, and improved reliability and resilience with dynamic T-SQL routines* Introduced source control using Redgate tools, Git, and Bit Bucket in order to increase the speed and accuracy of deploying new data warehouse developments

Milton Keynes, England, United Kingdom

• Created an SQL Server based framework for standardisation and analysis of key account pricing• Developed an automated SSRS reporting solution for the distribution of transactional and rebate date to large national accounts• Built an attendance analysis and management system to enable the rapid daily re-deployment of staff across the national network of 250 branches during the Covid-19 pandemic• Headed up a data-quality task force for the cleansing and standardisation of product data across a database of over 1 million SKU’s• Introduced intra-day early-warning system to alert suppliers and partners to activity spikes

Dewsbury, England, United Kingdom

• Designed and built an SQL Server Data Warehouse with SSIS ETL to consume data from InspHire ERP system, Microsoft Dynamics GP & Microsoft Dynamics CRM• Created a suite of performance management reports within the internal Board Business Intelligence system• Designed and built balanced scorecards for the performance measurement of the Mabey Hire Depot network, the Customer Account Managers and the Engineering team• Reviewed and refined existing key performance indicators, refining and improving existing KPIs while also introducing new on-hire metrics• Member of the pricing steering committee, proving commercial analysis and support for the decision-making process and the recommended operational changes

Bradford, United Kingdom

• Designed and developed the G-Source system for GROUPAUTO trading group price files. This projected included a .net console application, an SQL Server database, and a Qlikview end-user application. G-Source enables the analysis of price files including the impact of price changes; the cleansing, categorisation and standardising of price files; and the price-matching of these files against invoices raised.• Designed and built data warehouses for both the trading group and the subsidiary motor factors, enabling high quality reporting on many aspects of the business including sales, stock, purchasing, supplier returns, debtors & creditors etc.• Developed reporting and management information system using Excel, SQL Server Analysis Services and SQL Server 2008, before implementing Qlikview in early 2013.• Designed and developed a bespoke contact management system to allow business development managers to record contacts and escalate issues identified during garage visits. There have now been over 85,000 contacts logged with this system and it has made a significant difference to both the management of business development managers and their ability to help their customers• Created an application for the analysis and management of customer pricing, including the facility to perform ‘what if?’ analysis on proposed changes to the pricing structure

Leeds, United Kingdom

• Managed the performance analysis systems to calculate quarterly bonus payment for the majority of the employees in a 1000 head contact centre• Developed an attendance database to log absence records and produce peer averages and attendance calendars for use by management and the human resources department• Designed and built a database application to record and track individual skills progression of staff• Maintained systems for producing daily staff reports from the phone system, along with attrition reporting and quality measurements.

Bachelor Of Science (B.Sc.), Psychology

Graduated with Honors in Psychology (Bsc)

Education record