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
2024.01 - 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
2022.02 - 2024.12
- 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
2018.05 - 2022.02
- 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
2017.12 - 2018.02
- 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
2015.11 - 2017.12
Education
HND - Business
Perth College UHI
Perth 2019.08 - 2021.06
BSc - Applied Biological Sciences
University of Stirling
Stirling 2015.08 - 2017.02
A-Levels -
Strathallan School
Forgandenny, Perth 2006.08 - 2015.06
BA (Hons) - Business Management with Marketing
Edinburgh Napier University
Edinburgh 2021.09 - 2023.06
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
2024.01 - Current
Senior Bar Staff
Kirklands Hotel
2022.02 - 2024.12
BA (Hons) - Business Management with Marketing
Edinburgh Napier University
2021.09 - 2023.06
HND - Business
Perth College UHI
2019.08 - 2021.06
Bar Staff
Kirklands Hotel
2018.05 - 2022.02
Intern
British Chamber of Commerce Qatar
2017.12 - 2018.02
Bar & Kitchen Associate
J.D.Wetherspoon - The Crossed Peels
2015.11 - 2017.12
BSc - Applied Biological Sciences
University of Stirling
2015.08 - 2017.02
A-Levels -
Strathallan School
2006.08 - 2015.06