Hamish Mcgregor Email & Phone Number

London, Gb

London, England, United Kingdom

London

Operating as a Trading Manager for the Havas Programmatic Hub supporting Havas Entertainment (Target Media) clients, leading programmatic campaign execution whilst operating as a data driven reporting specialist using Datorama to provide in-depth dashboarding, analysis and insights. Working within the entertainment vertical of Havas Programmatic Hub across key clients which include: Hasbro, Square Enix, Azure, and Studio Canal to provide industry leading performance in UK and Global markets.

London, United Kingdom

Programmatic Account Manager working across a variety of entertainment clients such as; Azure, Square Enix, Bethesda, and Studio Canal. Worked as part of a 3-man team managing creative and complex programmatic media campaigns through all phases of activity from planning to post-campaign analysis. Additionally, responsible for the adoption and management of Datorama, the internal data and analytics platform to all tier 1 client teams and development of in-depth and automated reporting dashboards.

London, United Kingdom

Trained as a Junior Media Trader for Target Media’s internal trading desk, The Audience Platform. Worked with a variety of Gaming, Film and Arts/Live events clients across the Entertainment sector delivering high quality programmatic campaigns across multiple DSP’s such as MediaMath, DV360, and Amazon. Datorama reporting expert responsible for developing and managing the agency's online reporting dashboards for internal teams and clients

St Andrews, Fife, United Kingdom

Employed as a data analyst interrogating the charities two large databases to compile monthly reports, conduct research and provide monthly insight into trends and patterns to assist the marketing, IT and fundraising departments whilst providing administrative support to other areas of the charity. • Data entry, data auditing & monitoring all data for accuracy in generating Weekly, Monthly and yearly reports • Manipulate, cleanse and process data using Advanced Microsoft Excel techniques such as Vlookups, Pivot Tables and Formulas • Calculated and presented forecasts using Tableau and R for new and existing campaigns whilst reducing expenditure for future campaigns. • Actively participated in meetings with other charities and agencies to plan new and adapt existing campaigns, increasing donations from targeted markets • Utilised data visualisation software such as Tableau and Spotfire to present data in a clear and concise format in order to assist the marketing and fundrasing departments • Stay up-to-date with changes to data protection to support with the charities compliance, implementing an “Opt-In Only“ policy to reduce the number of complaints • Prepare and conducted training across the charity to new employees and senior members.

Bachelor'S Degree, Digital Forensics, 2.1

Activities and Societies: Dundee University Ski and Snowboard Club The course incorporates a variety of different disciplines such.

Higher Awards, Various Fields, A'S & B'S

Activities and Societies: Football Team, Basketball Team, Botswana Relief - Volunteer teaching and learning.