Stuart Johnstone Email & Phone Number

London, GB

London, England, United Kingdom

London, United Kingdom

• Converted existing excel based systems into SQL. Reduced processing time from 3 days to under an hour.
• Built Sales dashboards in Power BI on customer activity, churn, pipeline, forecasts and product performance.

London, United Kingdom

• Developed dashboards with response times of less than two seconds for 3,500 users on 300+ million records. Prior versions had response times of 5+ minutes and contained 80% less data (measured with JMeter).
• Proved server capacity and poor dashboard design were the reasons for bad end user experience and engagement. Convinced senior leadership that capacity was only needing to be doubled, in order to deliver the next two.
• Ran multiple stakeholder workshops (60+ people) to identify requirements. Held follow up workshops as the dashboards were being built to ensure that requirements had been correctly elicited and would meet their.
• Saw a need within the client for quick easy access to data during key annual planning period. Reduced their time spent on processing financial data from hours to seconds which enabled much more thorough planning to.
• Wrote training materials and engaged with users through formal and informal training.

Stevenage, United Kingdom

• Responsible for Business Intelligence, Data Warehouse, Systems Development, Clinical Coding and Data Quality departments (50 staff and a £2million+ budget).
• Successfully lobbied for 50% uplift to department staff budget to meet business needs.
• Identified and led an income assurance project that improved and automated data flows between IM&T and Finance enabling the correct figures to be used for internal performance and external contract management. This.

Reading

• Brought in as an interim to improve the department by providing experienced Business Intelligence leadership and to turn around the internal and external reputation. Reviewed the organisation’s informatics maturity.
• Led Information, Clinical Coding and Data Quality departments (40 staff and a £1.5million budget).
• Restructured department to better reflect business needs and mentored staff to eliminate consistent mistakes that were causing substantial uncertainty within the organisation.
• Identified errors underpinning the client’s contract negotiations with their purchasers leading to a significant avoidance of financial penalties.

UK

• Scoped, designed and built a showcase executive dashboard for the client to market across their healthcare and insurance sector.
• Worked with the client to adapt their consultancy model to implement the new dashboard at two customer sites, training their staff to implement at other clients independently.
• Presented on “Big Data and how to prepare for it using an Information Maturity Model” at the client’s customer user group at the Tower of London, July 2013.

London, United Kingdom

• Project shortlisted twice for Health Service Journal (HSJ) awards.
• Ran workshops and change programmes leading to cost and income improvements being identified and implemented that generated in excess of 11% savings. This involved a repeatable eight week accelerated programme.
• Saw need in the organisation to have better access to data and so learnt QlikView before building multiple dashboards for small targeted user groups as well as organisation wide (3000+ users). Financial planning.
• Wrote presentations and workshops given to the HealthCare Finance Managers Association (HFMA – national conference) on measuring and reducing costs.
• Reduced reporting production times from quarterly to eighteen days.

London, United Kingdom

• Managed Data Analysts and Clinical Coding departments (30 staff and a £1million budget).
• Restructured department to reduce high staff turnover rate and dependency on agency staff. Stopped 50% overspend per year on using contractors to fill vacant posts whilst increasing staff satisfaction.
• Improved the data quality (externally audited by the Audit Commission) from the third worst in the country to upper quartile for Clinical Coding (27% error rate to 6.7%).

Kingston Upon Thames, United Kingdom

Information assurance role supporting the Chief Executive, Director of Planning and PCT stakeholders.Projected performance and highlighted areas for attention to deliver performance within targets set for achieving 90% admitted patient pathways finishing within 18 weeks by Sept 08 in line with contract.Developed business processes helping the Trust to.

London, United Kingdom

I managed a department of 6 analysts providing a centralised business intelligence service to the Trust.Advisory role in creation of a balanced scorecard for the Board, setting performance indicators to achieve national and local targets.Responsible for the development of an integrated capacity and demand forecasting system comprising finance, activity.