Ian Brownlie Email and Phone Number

• Working in the Data Processing Group, cleaning raw survey and test data from a wide variety of sources using SPSS and Excel• Matching cleaned data to other information sources in order to provide complete and accurate datasets• Working with a great attention to detail in order to eliminate any data anomalies, while still keeping to tight deadlines• Using SPSS to draw random samples of schools to match detailed specifications• Design and maintenance of online surveys using Questback and Bellview systems• Using Dapresy system to create dynamic data presentations

• Working in the Revenue Department, producing complex statistical reports from an array of internal data sources• Using Excel and Access skills to design and produce standard and ad-hoc reports for Revenue Analysts, enabling them to set room rates for 300 hotels across 7 business sectors• Creating a standardised set of procedures for all reports produced in the Revenue Department• Liaising with staff in Marketing and Sales departments to produce reports to aid their decision making processes• Designing an automated report to track the performance of Revenue Analysts across a range of targets every month

• Producing standard and ad-hoc reports for senior internal and external clients using Proclarity (an SQL OLAP database) and Excel• Liaising with sales managers over the telephone, e-mail and in person to ensure the accuracy and usefulness of information