Mike Rawstron Email & Phone Number

Leeds

Warrington

• Creating and developing
• Tableau Viz's and VBA driven Excel spreadsheets to provide meaningful and up to date MI reports from a wide variety of data sources.
• Consistent reporting for both internal management and external regulatory consumption during the transition of software systems.
• SharePoint Sites with relational links to collect and store valid and consistent data for Projects & minor works.Using databases and systems set up for the above to produce ad-hoc reporting as… Show more Creating and.
• SharePoint Sites with relational links to collect and store valid and consistent data for Projects & minor works.Using databases and systems set up for the above to produce ad-hoc reporting as required at short notice..

Warrington

Developing a set of Process Assurance tools using a combination of InfoPath formlibraries with SharePoint Web Databases connected to VBA driven Excel reporting systems.Building SharePoint sites to collect, store and publish useful Project and Management Information such as Lessons Learned and Career Progression.

Managing projects across Rail, Plant and Transport businesses to align and rationalise local systems for capture of operational data and produce key periodic and ad-hoc MI & reports. This included the following developments, combining SharePoint site development using InfoPath forms with SQL Server databases reporting to VBA coded Excel, Word and MS Project.

• Analysis of the life cycle stage of each strategic business unit, based on a strategy plane framework, to determine the value potential of operating units within each business and then for the overall PLC, including.
• Working with business process owners to validate business cases, undertaking detailed market studies and analysing bid pipelines to confirm/challenge projections of additional sales to existing customers, new markets.
• Working with business process owners to validate business cases, undertaking detailed market studies and analysing bid pipelines to confirm/challenge projections of additional sales to existing customers, new markets.
• Development of a database system to model the impact of proposed changes to the structure and monitor actual changes to ensure that departmental heads were meeting their individual targets.
• Analysis of the group and divisional overheads by function and cost category.
• Monitor achievement of cost reductions against targets including headcount and non-staff costs.

For 4 years as Executive Assistant to the MD of a £500m business I was responsible forcoordinating KPI information, using SQL Server, Visual Studio, Access, Excel & PowerPoint forthe monthly board reports and managing a number of business critical projects, including thedevelopment of a GIS asset condition monitoring tool - a first for our engineers.

As Asset Manager I dealt with information from all areas of the rail business, combining assetquality trends with activity and cost to provide realistic efficiency comparisons at depot level forperiodic operations reviews. My duties also included liaising with Railtrack’s team to monitorperformance of the maintenance contracts and ensure that their asset.

My main function was developing relational database applications to ensure that key track condition related data was stored in a format that was uniform, logical and easy to retrieve. Built in functions analysed trends and predicted deterioration. I then used information from these applications to set and monitor most of Jarvis’s Safety & Quality KPI’s and.

Investigating causes of track defects and developing systems to monitor occurrences and look for patterns. Responsible for monitoring the Track Quality Performance Scheme implemented as part of the privatisation contracts. In Feb 1996, shortly after privatisation, I was given board approval to develop a database system, known as Keeptrak, a relational.

Leeds, United Kingdom

Working in the Maintenance & Design department of the Leeds Area Civil Engineer. Primarilyinvolved in speed improvement schemes, structure gauging, drainage, slope stabilisation and trackdesign. Developed databases for recording rail flaws, rail stress management and level crossingmaintenance records.During this time I planned, surveyed, designed and.

Beng (Hons), Civil & Structural Engineering

Education record