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
GainedTrained on basic lift / escalator operationTrained on in house systems including SAP / Call Out systemsDeveloped Internal Systems and trained key staffSupply Chain AnalystLigentia, LeedsNovember 2006 to March 2009Key AchievementsDesigned / developed the in –house web-based purchase order management system and ultimately released to external clientsProject PlanningInternal Database Development utilising MS AccessEstablished relationships with clients externally and used my Supply Chain skills to give clients advice on their imports and logisticsSupply Chain Analyst / Import OperationsWm Morrisons Head OfficeBradfordOctober 2004 – November 2006Freight negotiations including a 500Kpa saving on Wine ImportsDatabase installation for Supply Chain VisibilityHighlighted a 450kpa saving on Carrier Bag importsKey Skills GainedTrained on SQL programmingMicrosoft Business ObjectsCustomer Services Co-Ordinator – George Clothing AccountThe Elite GroupLeedsAugust 2000 - October 2004Initiated all KPI reporting structure for George ClothingPart of the development of bespoke purchase order management systemAssisted in Coordination of all stock from point of order to final deliveryReduced demurrage and quay rent by 50K pa through various reportsCrystal ReportingMS Access trainingMS Excel training to expert levelSupply Chain Import Co-Ordinator – Asda House – BWSAsda House (contractor)June 1997 – April 2000Optimised stock flowKPI reporting on all import suppliersDevelopment of bespoke tracking system for Asda ImportsReduced demurrage and quay rent by 100K paReduced lead times on imported beersNegotiation with suppliers1985 – 1997Employers werePanalpina – Desk Agent, Specialist Area Americas and CanadaServisair Cargo – Cargo Agent - Leeds/Bradford AirportFreightair Services – General Admin
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