Peter Laws Email & Phone Number

United Kingdom

London, United Kingdom

• Development and maintenance of Power BI reporting suite covering wide range of cyber data including Incidents, Vulnerabilities, Training & Colleague awareness, Pen Testing, PMO/ Financials, Data Loss Prevention & Audit; worked closely with ICS leadership team and data and control owners to build a wide range of new reports from the ground up• Responsible and able to deliver on full end-to end lifecycle right from report inception, testing through to deployment of live reporting; working closely with data owners to build clear visualisations and efficient back-end data handling processes• Build out of Phishing campaign reporting to give deep insight into behaviours across the organisation using data from HR to build views across key variables such as Length of Service or Employee Grade together with Repeat Clicker analysis – this is used to drive actionable insight and targeted training• Comfortable building complex data models and using data manipulation techniques including DAX measures and calculated columns - automating data refreshes from a wide range of sources including Excel, SQL and Azure SQL databases & SharePoint sites/ lists• Build of PowerPoint slide packs and commentary to feed into wide range of WTW committee packs for discussion at board level• Managing admin for Power BI Premium workspaces, App creation, setting up scheduled refreshes and Row Level Security on reports• Automation of key data flows using Power Automate e.g. taking emailed data and posting to a SharePoint site and automating Power BI report refreshes and Teams messages with key metrics in a HTML table

London, United Kingdom

• Hybrid business analyst/ data analyst role working for the head of Service Management and Continuous Improvement – role focussed on defining metrics, sourcing data and building out service performance dashboards for major global transformation programme• Responsible for setting up the data processes to calculate a range of key metrics including P2P, O2C, T&E and R2R using data from a number of sources, including SAP ECC, Hyperion, Ariba and SAP Concur.• Responsible for production of Excel based tracker which was presented each month and published globally and distributed to director level - reporting processes to take over 1m data records, calculate the metrics and present in one place• Data lead for migration from Excel reporting to Power BI platform - responsible for data definitions, testing, design and development of new reporting• Data integration with acquired Shire business to provide single view of combined business performance

London, United Kingdom

• Hybrid business analyst/ data analyst role working in a fast paced, highly political environment• Reported on Evergreening compliance for the bank - providing insight to HSBC board level of risks presented by running on out of support hardware and software• Designed and build of service support dashboards to give a clear snapshot by division of the bank’s exposure which are used to prioritise remediation work across the bank• Key input into demand capture process working with stakeholders to capture and estimate funding requirements for the next Fiscal Year used to drive prioritisation • Production and automation of key reports including financial variance reports, exceptions reports and from key systems including Clarity and GPDM and service reports from bank inventory system and Cognos• Automation and development included Access, Excel and PowerPoint including automatic updating of PowerPoint slides using VBA scripts to pull data from Excel into PowerPoint• Self- served with data from PPM owned SQL server to run Clarity and GPDM reports, including build and development of SQL script

• Improved month end data reporting process through use of Excel templates and VBA code to speed up and automate key tasks including consolidation of over 40 workstream files into one file and reconciliations between previous versions• Redesign of Work Order creation process to cut financial data into client ready packs via introduction of advanced Excel formulae and VBA script• Worked closely with Finance Business Partners and Programme Management to define the scope and roll out a Quality Assurance process to ensure data integrity of underlying workstream Excel trackers; saved time for FBP and Data teams to reduce scope for errors in reporting and conflicts in the underlying data prior to preparing client data• Build of bespoke VBA script to make bulk updates to files quickly and accurately, including adding in new formulas and drop-down validation lists to fields to ensure consistency across all files

• Worked with key business leads across the group, covering areas such as Marketing, Finance, Digital & Customer Operations to define Acceptance and Readiness criteria to inform go/ no go decision making at key programme milestones• Once defined, Readiness criteria were logged on an Excel “readiness tracker” for each function which the functions own and use to report back to the programme. I optimised the design of these to have a standard template to ensure consistency• Built and tested a process to collate and convert tracker submissions uploaded to a SharePoint site into a multi-layered dashboard to report across functional readiness at every programme checkpoint to key programme stakeholders• Built an automated tool to extract over 20 discrete Microsoft Project plans from a SharePoint site into Excel using VBA to minimise manual effort to save significant effort, and then replicate MS Project views and perform quality checks using Microsoft Access with the results being pulled back into Excel to quickly hone in on errors• Built a process to quickly reconcile differences between Microsoft Project plans and readiness trackers• Ran additional analysis on headcount tracking and incorrect time sheet booking to our project cost centres to ensure team financials were accurate

London

• Supported data migration of Risk and Control Self Assessments (RCSA) data from Excel spreadsheets into a new online system to ensure business declarations were correct prior to submission to UK and US regulators• Acted as "Super User" of new software package; included system testing and MI and reporting development• Reconciled data between existing data capture spreadsheets and new system output prior to submission to UK and US regulators• Managed two projects to understand reporting capability and improvements out of the new system and potential system improvements to help streamline the 2016 RCSA process, included using process mapping in Visio to model existing touch points and streamline processes• Represented the Investment Bank when working with Group Operation Risk team to discuss future system improvements - included review of Business Requirement Documents (BRDs) and submission of Change Requests to modify functionality• Handed over to Front Office teams with preparation and verbal delivery of training materials and workshops prior to 2016 process commencing

London

• Designed, built and ran Excel forecasting model to predict impact on new department set up to deal with applications from over 50k firms over a two-year period and to assess the effect of schedule changes• Once a schedule was finalised, I allocated all firms to a defined "application period" with bespoke direct comms sent to each firm • Introduced a robust process for building email/ letter lists to remind firms to apply at various stages of the application process with over 30k pieces of direct comms being sent out each month across various campaigns• Responsible for data extraction and reporting from a number of discrete complex data sources to give a single overview of application progress using one central database I built and optimised• Developed and produced MI pack covering applications and key trends under the new regime; involved defining metrics and key areas of focus with the business; I verbally presented this pack to senior management as part of a steering group• Created bespoke Excel templates/ Access databases for a number of specific tasks including reconciliations of data, ad-hoc analysis of large data sets and a lapse process for firms who had not applied by their application deadline to terminate their credit licence, with a process for making amends to Salesforce systems to adjust data on the external facing credit licence register

London

• Produced and developed monthly Management MI PowerPoint pack and Dashboards delivering improvements in production process through design of Excel templates• Standardised key reports including Vacancy and Recruitment trackers and Budget vs. Forecast reports to ensure consistent look and feel• Set up Access databases to perform regular reconciliations between team data and central HR information quickly and accurately• Tracked project financials to ensure portfolio targets are achieved and variances understood including forecasting year end positions and scenario analysis in Excel• Acted as main point of contact with finance and sourcing for Accruals and forecasts including 2014 budget preparation of third party spend and managed spend request process across FX and Commodities included Vendor liaison and PO and invoice tracking

London, United Kingdom

• Provided daily MI to various stakeholder groups including Regions and Programme management on Branch and Colleague readiness for go-live including progress dashboards and Daily exceptions reports• End to end design and delivery of bespoke Excel based reports to support various phases of the programme• Designed a Training reporting solution using an Access Database with full Excel integration to match up various data to give visibility of colleague Progress through complex colleague training packages – this was then presented in PowerPoint• Designed SharePoint trackers including full back-end reporting from Access and Excel

London, United Kingdom

• Production of a range of reports giving accurate view of current headcount across all job types and by Business Area within Group IT• Managed weekly MI reporting cycle involved data production and explaining variances in FTE numbers to senior management• Improved reporting methodology through application of advanced formulas and VBA• Month end reporting involved working closely with stakeholder teams across the business including Finance, to gather requirements and ensure that our reporting was accurate and fit for purpose

London, United Kingdom

• Responsible for the provision of regular and ad-hoc analytics to senior management covering savings, spend and contract reporting• Manipulated large data sets in Access and Excel to analyse data from BarCap and Group SAP systems and e-Sourcing systems• As part of secondment into Department finance role, I was responsible for the bottom-up build, tracking and reporting of the £20m departmental Budget• Designed a workflow dashboard to track information from Approval through to Sourcing Activity and on to PO; This report links up 5 discrete data sources and my improvements in reporting include developing an Access database with full tracking via Excel; this delivered tangible resource savings across both UK and Singapore Finance and Sourcing teams

York, United Kingdom

• Owned financial reporting of Third-Party Agreement (TPA) with HBOS with a combined annual budget of over £24m; involved regular discussions with HBOS finance counterparts to discuss variances and future forecasts• Responsible for full annual budget cycle for the TPA including quarterly re-forecasts; involved negotiation with Finance Business Partners and other internal stakeholders to ensure correct levels of overheads were fully recharged to 3rd party• Migrated invoicing process from paper/ post to electronic invoicing through negotiation with HBOS; this significantly reduced the payment cycle and the need for duplicates to be issued.• Managed complex annual FCA submission (Form 43) to ensure Aviva costs were split accurately to funds; process improvements saved over 10-man days of effort per cycle on this return and successfully off-shored the production of the report to Sri Lanka based workforce, freeing up UK based staff to manage the final delivery

Leeds, United Kingdom

• Supported buying team with provision of accurate price data including financial impacts of key contracts• Performed financial audits of buyers’ negotiations to give finance seal of approval• Used product price variance reporting to give management a view of performance by product category and risks to Cost of Sales number; this involved taking data from SAP and manipulating in Excel and presenting via PowerPoint• Presented to divisional finance controllers on price point variances and forecasts for financial year• Worked within production facilities on key projects including process improvements and the decision on whether to outsource particular production processes or to continue to produce in house (make or buy) through process mapping and costing• Part of project team involved in the outsourcing the factories’ engineering stores to a third party – my role involved forecasting and tracking the benefits of this initiative. This also involved auditing the processes and procedures of the third party on their premises on a regular basis to ensure compliance with contractual obligations• I built and owned a ‘commodity report’ using 3rd party software to link underlying market impacts to final prices paid across ingredient categories to give senior management an early view of cost impacts of market price rises

Bradford, England, United Kingdom

• Planned factory production based on orders, forecasts and capacities to maximise efficiency and reduce costs• Worked with the sales allocation, procurement and factory teams to take account of promotional activity, material availability and production capacity to ensure orders were met• Worked closely with factory finance team to improve the throughput of the factory and internal profitability• Improve the reporting systems. This included planning and performance analysis.

Bradford, England, United Kingdom

• Working as the second in command in one of the production departments in the factory to manage production of daily orders• Involved ensuring the department had ingredients, packaging, personnel in order to hit production targets• Worked closely with Engineering and Planning teams to prioritise production when there were machine breakdowns – required strong communication skills and quick thinking• Supervision of team of over 30 staff including induction, disciplinary procedures and shift de-brief – included full management of department on several occasions• Overhauled shift planning reports using Excel skills to build materials requirement forecasts

Bradford, United Kingdom

• Management training scheme to give a strong understanding of the operations of the entire Morrison’s Group and in particular the manufacturing facility• Involved shadowing and hands on work across a number of functions including Production Planning (3 months) and Production Management (8 months)

Skelmersdale

• Produced daily reports using information from databases to senior management across the business to show store performance, average basket sizes and other key metrics• Worked closely with the marketing team to define target markets and then analyse sales impacts of marketing campaigns on in-store ranges by tracking individual product lines before, during and after a direct mail shot• Produced customer profile reports through matching EPOS data to demographic data from external sources.• These were mapped using GIS software in order to produce visual ‘heat maps’ of the country to show the optimal locations for new stores– this information was presented to the Estates team on a regular basis and I was involved in the production and presentation of this information• Worked with Store and Area managers to improve the uptake of the customer card via new registrations and to ensure that as much data was captured during each visit