Duncan Cook
Edinburgh,United Kingdom
Summary
Analytical and driven individual ready to leverage strong problem-solving abilities and keen eye for detail. Background in financial services auditing, skilled in data visualisation and statistical analysis, combined with proficiency in SQL and Excel. Committed to delivering actionable insights and driving data-driven decisions in a Data Analyst role.
Overview
14
14
years of post-secondary education
11
11
years of professional experience
Work history
Audit Assistant
Johnston Carmichael
Edinburgh
01.2024 - Current
- Performing audit testing on entities' financial statements, extracting raw data from data sets and reports provided by clients and extracting the relevant information needed to test the accuracy of financial statement balances.
- Maintained and improved testing templates to automate processes within testing practices used within the team.
- Employed data analysis techniques to interpret complex financial information efficiently.
- Identified discrepancies in financial statements, resulting in error correction and prevention of future mistakes.
Senior Bar Staff
Kirklands Hotel
Kinross
02.2022 - 12.2024
- Promoted to senior staff introducing new responsibilities such as stock-taking and ordering from suppliers to maintain appropriate levels of inventory.
- Trusted to liaise with supplier sales representatives to inform how current products are selling as well as order samples of new products to test.
Bar Staff
Kirklands Hotel
Kinross, Scotland
05.2018 - 02.2022
- Worked in every role in the hotel including secretory roles, waiting tables, and drink making.
- Responsible for creating and designing cocktails and drinks menu as well as coming up with new innovative recipes.
- Excellent customer service skills and a commitment to customer satisfaction.
Intern
British Chamber of Commerce Qatar
Doha
12.2017 - 02.2018
- Helped plan and carry out a social media marketing campaign to establish a strong social media presence as well as attract new customers for the business.
- Refreshed and kept the company website up to date with more relevant news to the economic climate at the time.
Bar & Kitchen Associate
J.D.Wetherspoon - The Crossed Peels
Stirling
11.2015 - 12.2017
Education
HND - Business
Perth College UHI
Perth 08.2019 - 06.2021
BSc - Applied Biological Sciences
University of Stirling
Stirling 08.2015 - 02.2017
A-Levels -
Strathallan School
Forgandenny, Perth 08.2006 - 06.2015
BA (Hons) - Business Management with Marketing
Edinburgh Napier University
Edinburgh 09.2021 - 06.2023
Skills
-
Forensic accounting basics
-
Excel database maintenance
-
Microsoft Word, Excel and Project
-
Financial database analysis
-
Customer Service
-
Social Media Marketing
-
Marketing Analytics
-
Inventory Management & Procurement
-
Visual Basic programming
REFERENCES
References available upon request
LINKS
LinkedIn
Timeline
Audit Assistant
Johnston Carmichael
01.2024 - Current
Senior Bar Staff
Kirklands Hotel
02.2022 - 12.2024
BA (Hons) - Business Management with Marketing
Edinburgh Napier University
09.2021 - 06.2023
HND - Business
Perth College UHI
08.2019 - 06.2021
Bar Staff
Kirklands Hotel
05.2018 - 02.2022
Intern
British Chamber of Commerce Qatar
12.2017 - 02.2018
Bar & Kitchen Associate
J.D.Wetherspoon - The Crossed Peels
11.2015 - 12.2017
BSc - Applied Biological Sciences
University of Stirling
08.2015 - 02.2017
A-Levels -
Strathallan School
08.2006 - 06.2015