Michael Grey
Data Analyst
Burton-On-Trent
Summary
A motivated and results-driven Data Analyst with a background in Mathematics and Statistics, offering strong analytical, problem-solving, and process optimisation skills. Proficient in SQL, Python, Excel, Power BI, and Database Management, with hands-on experience applying technical expertise to improve business processes. Passionate about leveraging data and technology to deliver innovative solutions that drive efficiency and continuous improvement.
Overview
9
9
years of professional experience
6
6
years of post-secondary education
Work History
Data Analyst
National Grid
02.2023 - 05.2024
- Designed, developed, and implemented a database tracking solution for Primary Network Design schemes using Oracle APEX and SQL, improving data accuracy and accessibility across teams.
- Led a team of two data entry staff, overseeing task allocation, quality control, and ensuring timely and accurate population of the new database.
- Automated monthly and ad-hoc reporting processes using SQL queries and Power BI reducing manual workload and improving reporting efficiency.
- Provided training and documentation, ensuring a smooth transition to the new system and empowering stakeholders to utilise the database effectively.
- Built and delivered a proof-of-concept database application using SQL in Oracle APEX, which was adopted and scaled by the IT development team through phased implementation.
- Successfully managed a large-scale data migration project, improving data integrity and reducing errors by implementing automated validation checks.
Data Entry Administrator
National Grid
11.2022 - 02.2023
- Managed and streamlined the DBS check process for all employees across the East and West Midlands, collaborating with an intermediary company to ensure compliance and data accuracy.
- Identified inefficiencies and automated key stages of the process, reducing manual input and improving tracking and reporting accuracy.
- Automated and digitised a significant portion of the DBS check process, leading to the highest number of completed checks in a single week since the project's inception.
- Improved operational efficiency, reducing the backlog of pending DBS checks and accelerating turnaround times through process optimisation and automation.
Technical Reporter
Woodward Group
11.2021 - 09.2022
- Managed the transfer, validation, and distribution of technical reports to clients within strict timeframes, ensuring accuracy and compliance with internal standards.
- Tracked and monitored engineer performance on report submission times, implementing strategies to optimize workflows and meet deadlines.
- Led the business-wide integration of a new CRM system, overseeing database migrations, process implementation, and providing training to staff for a smooth transition.
- Managed purchasing operations, including negotiating with suppliers for more competitive pricing and ensuring timely procurement of necessary goods.
- Administered the company fleet, coordinating the management of vehicles and related administrative duties.
- Automated the data entry process for technical reports using Python, extracting data from PDFs and transferring it to the latest reporting software, saving approximately 200 hours of manual input time annually.
- Developed a Python script to automate the processing of purchase orders, reducing the manual input time required and improving accuracy in procurement tracking.
- Successfully integrated new CRM software across the business, enhancing data accuracy and streamlining internal workflows, contributing to improved operational efficiency.
Fleet Analyst
SOCOTEC UK
09.2020 - 05.2021
- Oversaw large-scale databases, ensuring data accuracy, consistency, and integrity.
- Spearheaded the creation and enhancement of fleet management systems, streamlining data processes and improving overall efficiency.
- Developed automated reporting solutions for monthly mileage, fuel consumption, and other fleet-related metrics. Integrated Excel macros and complex formulas (e.g., nested VLOOKUPs, IF statements, INDEXing) to optimize data processing.
- Managed the fleet data control process, ensuring effective tracking, maintenance, and retrieval of data on vehicles, mileage, and associated costs.
- Created and implemented email macros for processing fleet fines, reducing processing time by 5 minutes per fine, saving the department around 10 hours monthly.
- Refined the fleet performance dashboard, enhancing the clarity and efficiency of weekly and monthly reports, saving an additional 20 minutes per report.
- Redesigned a fleet mileage spreadsheet using advanced Excel features, which increased accuracy and efficiency, reducing manual effort and error.
- Developed and managed the department's intranet page, consolidating resources such as documentation and order forms, reducing inbound queries and increasing productivity.
- Automated various reporting processes and data handling tasks, leading to significant time savings and more accurate reports, improving overall department efficiency.
Health and Safety, Environment and Quality coordinator
SOCOTEC UK
04.2020 - 09.2020
- Managed the company-wide incident reporting line, logging and investigating health and safety hazards, and ensuring prompt action and resolution.
- Streamlined monthly reporting on health, safety, and quality metrics, leveraging automation to reduce manual entry and improve data accuracy.
- Maintained and updated the supplier database of over 3500 suppliers, ensuring compliance with all internal and external standards.
- Developed Python scripts that automatically extracted hazard information from PDFs and emails and populated web forms, reducing manual processing time by over 90%.
- Improved the documentation and reporting systems, creating efficiencies across various departments through enhanced data handling.
- Automated manual input tasks, saving approximately 14-20 hours each month and improving reporting accuracy using Excel and Python-based solutions.
- Designed a Python solution that transformed manual hazard reporting (140 instances per month) into an automated, error-free process, saving 10-12 hours monthly.
- Automated board and health and safety reports, reducing report generation time by 4-8 hours per month, improving accuracy, and ensuring faster decision-making.
Stock and admin clerk
Tradeteam DHL: Drinks Logistics
08.2015 - 08.2016
- Performed daily stock counts, ensuring inventory data was accurately reconciled using Excel and in-house database software.
- Investigated discrepancies in stock by tracing warehouse movements and collaborating with goods-in departments to resolve missing stock issues.
- Managed communication with suppliers via email and phone, addressing stock discrepancies and ensuring timely resolution of issues.
- Updated and maintained KPI systems, performing basic statistical analysis and compiling weekly reports to track stock levels and performance metrics.
- Developed an emailing macro to automate the process of sending filtered stock reports via email, saving 1 hour per day and increasing operational efficiency.
- Streamlined the daily stock shortage process by developing Excel macros and formulas, cutting processing time by 2-3 hours and improving reporting accuracy.
Education
BSc Hons - Mathematics with Statistics
The University of Plymouth
09.2016 - 06.2019
A level - Mathematics, ICT, Psychology
Burton South Derbyshire College
09.2012 - 06.2014
GCSE - 10 GCSEs A-C (Including Mathematics and English)
John Port School
09.2009 - 06.2011
Skills
- Microsoft Excel: Advanced proficiency in data analysis, including Pivot Tables, VLOOKUPs, nested formulas, macros, automation tasks, and data modelling for complex datasets
- Power BI: Created dashboards and visualisations for business reporting
- Microsoft Office Suite: Skilled in Word, Access, and PowerPoint for project documentation and presentations
- MATLAB, Maple, SIMUL8, LaTeX: Familiar with using these tools for technical and data-heavy projects
Interests
Football: Regular participant in a weekly league, promoting teamwork and physical fitness
Guitar & Photography: Enjoy exploring creativity through playing guitar and capturing moments with a film camera
Solo Travelling: Passionate about solo travel, immersing myself in new cultures and gaining diverse perspectives
Investing & Markets: Keen interest in the stock and cryptocurrency markets, with a focus on creating and managing investment portfolios
Chess: Enthusiast of chess, which hones my strategic thinking and problem-solving abilities
Timeline
Data Analyst
National Grid
02.2023 - 05.2024
Data Entry Administrator
National Grid
11.2022 - 02.2023
Technical Reporter
Woodward Group
11.2021 - 09.2022
Fleet Analyst
SOCOTEC UK
09.2020 - 05.2021
Health and Safety, Environment and Quality coordinator
SOCOTEC UK
04.2020 - 09.2020
BSc Hons - Mathematics with Statistics
The University of Plymouth
09.2016 - 06.2019
Stock and admin clerk
Tradeteam DHL: Drinks Logistics
08.2015 - 08.2016
A level - Mathematics, ICT, Psychology
Burton South Derbyshire College
09.2012 - 06.2014
GCSE - 10 GCSEs A-C (Including Mathematics and English)
John Port School
09.2009 - 06.2011
Similar Profiles
Kevin GovoniKevin Govoni
Principal Project Manager – Project Development & Resource Planning at National GridPrincipal Project Manager – Project Development & Resource Planning at National Grid
ALEXA WAECHTERALEXA WAECHTER
Mechanic B at National GridMechanic B at National Grid
Erik KrizErik Kriz
Cyber Security Analyst at National GridCyber Security Analyst at National Grid
ABDULAZIZ ALQAHTANIABDULAZIZ ALQAHTANI
Maintenance Planning Section Head at National GridMaintenance Planning Section Head at National Grid
Daniel FeredayDaniel Fereday
Tutor at John Taylor High SchoolTutor at John Taylor High School