David Pickup Email & Phone Number

Nottingham, England, Gb

Nottinghamshire, England, United Kingdom

Manage the Asset & Network Data Teams in Operations to derive intelligence from National Highways network and asset data, driving informed decision making for regional investment, planning and needs assessment. Lead the team in the successful management of the asset databases and business solutions, delivering data accuracy and improvements across the Midlands.Using my experience and knowledge of asset management and data and information principles to drive data requirements, provide analysis and deliver insight to the business for needs prioritisation, asset lifecycle costing and value optimisation across Operations and the wider business.Lead the data team in implementing innovative business solutions through business intelligence systems and visualisation tools across digital data platforms.

Nottinghamshire, England, United Kingdom

Within the Asset Data Analysis & Intelligence Team I provided critical analysis and insight into asset data and operations to drive intelligent business decisions and improvements. Utilising my knowledge and experience of asset management, National Highways asset network and asset management system to provide intelligent asset data for asset life cycle and deterioration modelling, improve data quality, develop business productivity tools for increased efficiency, create value-added reports for improved operations and carry out data analysis to highlight issues and promote solutions. Key achievements:o National defect report - Identified an issue with defect reporting inconsistencies, developed a solution and implemented a new report for accurate defect rectification performance. I approached colleagues from around the country and implemented the new report across all regions for reporting back to the Operations Performance Team, and ultimately the Office of Road and Rail, for National Highways overall performance against defectso Operational Excellence 2025 (Cyclical Maintenance) - I delivered a national suite of dashboards to enable comparison of cross regional cyclical performance – the first of its kind across Operationso Maintenance Requirements Plan (MRP) – Through collaboration with Asset Needs colleagues and our M&R contractor I created, developed and delivered the MRP for the EM allowing for, clear planning/programming, performance monitoring, and the delivery of our cyclical programme and obligations to maintain the network to a safe standard

Working within the Asset Data and Future Needs Team provided critical analysis and insight into asset data to drive intelligent business improvements. Utilising my knowledge and understanding of Highways England’s (HE) asset network and asset management system to; provide intelligent asset data for asset life cycle and deterioration modelling, improve data quality, develop business productivity tools for increased efficiency, create value-added reports for improved operations and carry out data analysis to highlight issues and promote solutions. An innovative approach to problem solving and identification of performance metrics are a necessity to ensure Asset Delivery are maintaining efficient operations and delivering a safe network to the public.Key Activities:• Provided insight into assets on the network, interrogating the asset management system to; identify assets, routes and risk hot spots• Utilising analytical and systems skills (SQL) to develop reports, dashboards and business productivity tools to support other areas of Asset Delivery and provide insight across the network in terms of asset management and commercial performance• Acted as a system expert and advocate across Asset Delivery, assisting/supporting colleagues with the asset management system to overcome issues and unlock asset data held within the database• A variety of ad-hoc reports and analysis, ranging from FOI requests, defects on the network (cost and frequency), customer service performance metrics and overall Area 7 performance reports for board and CEO queries

Nottingham, United Kingdom

Provide the Hillarys business with key information on Sales, Customer behaviour, trends and buying patterns. Utilise and interrogate the Marketing Database to provide in depth analysis on a range of ad-hoc requests and projects, identify targeted marketing selections for campaigns and report on the performance of all aspects of marketing activity within the company to ensure ROI.Key Achievements:• Created a Customer Metrics Dashboard for SLT and media managers. A monthly snap shot providing; insight into customer behaviour, commercial performance across media channels, MoM and YoY variance across customer groups and media channels• Produced a single Advisor Service Score model. Developed a weighted scoring algorithm using a variety of advisor customer service metrics from multiple sources and built an automated model giving advisors a single Customer Service score

Shardlow - Nottingham / Derby

Working with various companies in a range of industries to help them achieve their desired goals and beyond, through a range of analytical processes and development of systems to produce value added results.Specialising in HR analytics with an excellent understanding of people metrics, reward processes/implementation and the creation and development of KPI's and Dashboards.Working with a wide range of clients I provided accurate and efficient services, analysing complex data and turning it into meaningful, easy to understand, information for improved HR operations.Key Achievement:Built a dynamic bonus model for a long standing client. Met with client to understand requirements and developed additional functionality to ensure a value added product. Bonus model demonstrated financial implications on various bonus scenarios to ensure new bonus scheme fell within budget.

Deliver comprehensive people metrics, analysis and reward implementation, from a variety of different systems and data formats, on a workforce of circa 10,500 employees and 3,000 contractors within a shared service environment.Key Achievements:• Involved with the cyclical reward process, calculating and implementing merit and bonus payments for employees, using large and complex data sets and advanced excel skills to create a logical and robust framework whilst maintaining high accuracy rates – 99.4% across 10,000 employees• Lead on various elements of pay award in last 6 months of role: > Bonus, Feb 2015 for 1200 employees - accuracy rate of 99.6% > Salary re-alignment rundown, tracking movements and existing re-alignment against current positions and secondments > Review of employee allowances for 1100 employees• Complex analysis of a variety of ad hoc data requests ranging from performance management, company labour costs, resourcing statistics, diversity statistics and people movements to support major projects and government submissions• Project work: > Cost Analysis – Holiday Pay/Overtime (OT) government legislation change > Expenses database – Creation and development of Expenses DB (Access 2010) increasing efficiency by 50% > Referencing database (Access) for employee reference requests – now one step process > Reconciliation model (Excel) for monthly payroll tax accounting – increased efficiency and accuracy > Various Excel/VBA templates for statistics, formatting and MI Pack/dashboard creation

Provided financial services to E.ON Group subsidiaries and external customers within a shared service environment. High level of responsibility for the accurate and timely processing of multimillion sterling and foreign currency payments to suppliers and customers, across 20+ accounts, liaising with Treasury and the business to ensure smooth and continuous business operations.Highlights:• Daily/monthly reconciliation of E.ON cashbooks/accounts on behalf of Treasury, ensuring credit limits and holding accounts were within agreed terms and conditions• Undertook a variety of payment processes including cheque disbursement, CHAPS (multicurrency), BACS transactions and the processing of bank statements for parts of the E.ON Group