Patrick Sneyd Email & Phone Number

Dublin Ireland

•Develop and maintain reports and data sources to maximize the sales of The Irish Times - document, schedule and maintain same.•Dashboard development using Xcelsius / SAP Crystal Dashboard Design/Tableau.•Development of a number of MySQL/PHP crud based web applications.•Development of a number of MSSQL OLAP cubes to enable long term sales analysis across all key metrics. This project included assessing data requirements, development of ETL routines, data cleansing and validation, cube development, reporting and scheduling.Key technologies used include Crystal Reports, Oracle, MSSQL Server ,MySQL , PostgreSQL & Sybase to include experience with monitoring, optimization, debugging and testing of SQL statements, ETL routines, warehouse development, data validation & cleansing, stored procedures, view generation and scheduling. SQL developer, Excel with particular emphasis on pivot tables, phpMyAdmin, apache, xamp stacks, PHP, AIR for android, Flash Builder ,Google analytics, Amazon vendor central, App Annie, j-query and all of the applications within Microsoft Office and the Adobe Creative Suites.

Dublin Ireland

•Maximising the advertising income obtained by The Irish Times through analyzing and interpreting all available data sources to provide sales reps with data for sales pitches.•Assist all departments within the company with their research needs and the commissioning of primary research projects.•Give presentations on all research related issues to all levels of the organization and external clients / advertising agencies.•Manage the research budget and assign of duties to the advertising research assistant.•Represent The Irish Times interest on the JNRS technical committee•Key sources used include The Joint National Readership Survey (JNRS), Target Group Index (TGI) , the European Business readership Survey (EBRS), CSO data, ESRI reports, AC Nielsen Ad-Dynamix and the RAM online add effectiveness measurement system.

Parkwest

Dublin

Montrose