Alexander Robertson
Falkirk,United Kingdom
Summary
A highly skilled data analyst proficient in Microsoft Excel and Power BI, adept at creating and maintaining dashboards that drive decision-making through effective visuals. Demonstrates strong analytical and problem-solving skills, with a proven ability to work with diverse data sources and programming software to produce accessible reports. Known for translating complex data into meaningful insights, ensuring high-quality outputs with attention to detail and error-checking. An effective communicator who can engage with both internal and external stakeholders, with a commitment to always finding the right solution for the customer. Confident in presenting findings, and effective in both individual and team settings. Career goals include further enhancing expertise in data analysis to support strategic business initiatives.
Overview
6
6
years of post-secondary education
9
9
years of professional experience
Work history
Analyst Researcher
Police Scotland
Stirling
2025.02 - Current
- Provided analytic insights that informed key decision making for Senior Officers.
- Collaborated across departments to develop cohesive reports, ensuring accuracy and reliability of data.
- Created comprehensive reports such as Problem Profiles & Snapshots on different crime types, aiding in strategic planning for Senior Officers in the Division.
- Utilised SQL programming tasks to manage large databases efficiently, and showed competency in Microsoft Excel and created and maintained dashboards using Power Bi to monitor crime trends within the division.
- Obtained a Diploma in Intelligence and Data Analysis – awarded in June 2026.
Administrative Assistant
Arinsdale Ltd
Grangemouth
2023.09 - 2025.02
- Processed customer and supplier payments, liaised with customers via telephone and email to resolve account issues and provide relevant solutions.
- Managed purchase ledger tasks, including entering supplier invoices and reconciling accounts.
- Performed month and year-end accounting tasks, including bank reconciliations and preparing data for year-end auditing.
- Employed business management software for efficient data tracking.
Customer Assistant
Tesco
2022.10 - 2023.08
- Assisted customers with shopping by managing checkouts, helping pack bags, and guiding them to required items.
- Trained in all aspects of store operations, including checkouts, trolley collection, and waste management.
- Improved customer relations by promptly addressing queries and concerns.
Warehouse Operative
Arinsdale Ltd
Grangemouth, Falkirk
2017.11 - 2022.09
- Use of counter-balance forklifts to load and unload goods outwards and inwards; licence obtained 2019.
- Picked and despatched customer orders to ensure timely delivery.
- Assisted team members in safely loading large items onto delivery trucks, enhancing team efficiency.
- Use of handheld terminals linked to bespoke warehouse management software.
- Collaborated with team members to maintain smooth warehouse operations.
Education
Diploma of Higher Education - Intelligence and Data Analysis
Police Scotland
Tulliallan 2025.05 - 2026.06
Master of Science - Criminology
University of Stirling
Stirling 2022.09 - 2023.11
Bachelor of Arts - Criminology and Social Policy
University of Stirling
Stirling 2018.09 - 2022.06
Skills
- Excel and Power BI dashboards
- Analytical and Problem-solving skills
- Data source integration
- Report generation
- Data visualisation
- Detail-oriented reporting
- Confident in Presenting
- Time management skills
References
- Martin Harvie, Analyst Co-ordinator, Martin.Harvie@scotland.police.uk
- Niall Hamilton-Smith, Programme Director of MSc Criminology, niall.hamilton-smith@stir.ac.uk, +441786466435, University of Stirling
- Clark Robertson, Director at Arinsdale Ltd, clark@arinsdale.com
Additional information
- Full clean driver’s licence held since November 2017.
- Other references available upon request.
Timeline
Diploma of Higher Education - Intelligence and Data Analysis
Police Scotland
2025.05 - 2026.06
Analyst Researcher
Police Scotland
2025.02 - Current
Administrative Assistant
Arinsdale Ltd
2023.09 - 2025.02
Customer Assistant
Tesco
2022.10 - 2023.08
Master of Science - Criminology
University of Stirling
2022.09 - 2023.11
Bachelor of Arts - Criminology and Social Policy
University of Stirling
2018.09 - 2022.06
Warehouse Operative
Arinsdale Ltd
2017.11 - 2022.09