Richard Smith
Lead Data Analyst
Bradford
Summary
- PERSONAL STATEMENT I am a highly analytical person with strong interpersonal skills, which has resulted in the successful implementation of various Systems and Process Management tools. I have thoroughly enjoyed the challenges in my career, improving efficiency and profitability across businesses I have worked for. This has included. o Development of reporting systems to monitor and analyse efficiency, highlighting areas of opportunities for better return on Investment – MD level to Admin colleagues. o Client Management – developing bespoke reporting systems for key accounts including training and development for account managers and support on client relationships. o Experience in Capacity Planning Improvements based on Engineers activities resulting in recommendations for efficiencies on workload management. o With my in-depth knowledge of Office365, and being a people person, I can provide in-house consultancy, training, and implementation support for all employees, becoming a point of contact at all levels. o Having worked in analytical roles for over 25 years, across several industries, I have the knowledge and experience to provide strategic recommendations. These recommendations have ultimately optimised business processes, performances, and profitability. o I have also successfully trained and motivated teams during implementation of processes ensuring a smooth transition and acceptance across the business.
- PERSONAL SKILLS
- MS Access and Excel to expert level.
- VB Coding in MS Access & Excel
- Power Bi
- Analytical and Problem-Solving approach
- Expert report writing skills.
- Business aware at all levels from frontline to Director level.
- Good communication skills.
- Team player
- Project Management skills
- Institute of Export parts 1 & 2
- City & Guilds Award Business Studies
Overview
14
14
years of professional experience
Work History
Lead Data Analyst
ALAMY Ltd
Milton, Didcot
06.2022 - Current
- Business Analytics Team Leader controlling workflow between UK & India
- Power BI Lead Analyst – Responsible for Daily/Monthly Financial Reporting to Directors / Company Wide
- Main Projects
- Secondary Rights - £2m Annual Income – efficient online solution / semi-automated
- This project was to safeguard the £2m risk to the company while keeping the process as smooth & simple as possible
- We also had to make this transparent across the business
- Finance & Credit Control KPI’s – Automated from a manual excel process
- Aged Debt Management & Group Summary Reports
- Main contact for all company users requiring report data / Power Bi assistance.
Business Operations Data Technician
Precision Lifts, Lucklyn
Basildon, Essex
06.2019 - 06.2022
- Remotely)
- Key Achievements, Responsibilities:
- Implemented new Company Operations System
- O Main Point of Contact between Software House and Internal departments
- O Designed and project managed through to full implementation
- O All Users Trained from field engineers through to Admin & Finance
- O All Customer Reporting designed and implemented
- O Two Year project commenced 2019 and managed through to full launch Nov 2021
- SharePoint and Office365 implementation, centralised reporting
- O Full User Training o Efficiencies gained in automated daily reporting internally & externally
- O Lift Off & full LOLER Reporting installation training & implementation
- O Ability to now run KPI Reporting (Internal & External) o Monthly/Weekly Maintenance Reporting issued gaining insight into critical areas of improvement and thus improving overall efficiencies
- Development of Finance Reporting o Purchase Order Control System – approvals up to MD level o Repair Work in Progress Report – full visibility of all financial implications of repair work in progress
- Mileage Reporting on field engineers establishing areas of improvement on areas covered.
UK Operations Data Support Technician
Schindler Ltd
Weybridge
02.2018 - 06.2019
- LOLER Insurance Process & Tracking System Installed
- O Scope, design, build, training, and delivery through to final Customer Reporting o UK wide access for all regional teams using SharePoint
- O Front End System for Schindler Insurance Team o Automated Emails & Letters to Customers depending on status activity
- Weekly / Monthly Operational reports distribution to Senior Team and Regional Teams o Automated Reporting from a manual process to full automation o Operational & Financial
- Portfolio Reporting o Risk Management Reporting
- Customer Dashboard Reporting on Operational Activity o Bespoke Design for specific Customers meeting their exact requirements
- O Automated to improve efficiency & accuracy
- Utilisation of MS SharePoint and Office 365 OneDrive products o Cloud File Sharing for Automated Reporting o Training End Users
- Various Ad Hoc reports on Time Analysis – Engineers Field link Device
Data Application
KONE Plc
Keighley
05.2011 - 01.2018
- Specialist / Software & Systems Development Implementation
- Scheduling Tool System – concept / design / implementation
- O Now a KONE Process used to manage the delivery of maintenance to all customers
- Capacity Planning Tool – concept / design / implementation o Used to determine peaks in workload in frontline operations
- Created more efficiency, reduced overtime and use of sub- contracted work
- First Time Fix – concept / logic / design / implementation o Now a KONE process used across Europe
- Office 365 implementation o Creation of new Off365 websites and systems, including phone apps for managers and frontline personnel
- Bespoke Reporting System - covering all levels using MS Access
- National Accounts Reporting– concept / design / implementation
- Monthly Business Review Reporting – SMT level
- Mapping & Capacity Planning of all engineers & routes
- Support ASM’s & other departments in analysis
- SharePoint installation for all departments to enable cloud data storage and reporting
- Automated and streamlined data processes to improve efficiency
- Field Letter & Express Letter monitoring & reporting– concept / design / implementation o Enables accurate monitoring and tracking of field letter completions for all customers.
Area Controller / Customer Services
KONE Plc
Keighley
05.2009 - 05.2011
- Ensure engineers have completed lift/escalator repairs to customer satisfaction
- Monthly reporting of lift call outs / maintenance to key clients
- Development & Installation of bespoke reporting solutions to certain key clients including Manchester University &
- Leeds University
- Area of responsibility covering Yorkshire and Scotland
- Responsible for answering customer queries on service and accounts.
Skills
Gainedundefined
Timeline
Lead Data Analyst
ALAMY Ltd
06.2022 - Current
Business Operations Data Technician
Precision Lifts, Lucklyn
06.2019 - 06.2022
UK Operations Data Support Technician
Schindler Ltd
02.2018 - 06.2019
Data Application
KONE Plc
05.2011 - 01.2018
Area Controller / Customer Services
KONE Plc
05.2009 - 05.2011
Similar Profiles
Rainier FerrellRainier Ferrell
Business Development Manager at AlamyBusiness Development Manager at Alamy
Lakshmi PalakotLakshmi Palakot
Data Analyst at Alamy Pvt LtdData Analyst at Alamy Pvt Ltd
ANEESH KUMARANEESH KUMAR
Senior Executive-Account Services at Alamy ImagesSenior Executive-Account Services at Alamy Images
Khalid NasirKhalid Nasir
Sub agent at Kier Group (EKFB JV HS2)Sub agent at Kier Group (EKFB JV HS2)
Ahdam RanaAhdam Rana
Helpdesk Administrator at Decision FirstHelpdesk Administrator at Decision First