Power BI - Led project to move company reporting over from IBM Cognos TM1 to Microsoft Power BI enabling more impactful presentation of company data and access to insights company-wide. This also represented significant time savings in the day to day workings of key departments including Sales and Finance.Business Analysis - Carried out a full company audit on reporting needs and built a bespoke suite of reports, dashboards and apps.Presentation and training - Presented these reports company-wide on launch of the tool and provided training across the business. Carry out regular training and development cycles.Maintenance of Data integrity - Work closely with the IT team to resolve bugs, identify and fix data anomalies and ensure the smooth flow of data between systems and tools (central scheduling system, data warehouses and Power BI). Carry out cleansing of data where necessarySQL - Query the ODS and Power BI Warehouses using SQLCommunication and teamwork - Regularly communicate in Sales meeting to ensure strong understanding between input into Sales booking system and output in reports so that the Sales and Ops/IT teams can work seamlessly togetherReporting to highest level - Continue to work closely with the CFO on regular board reporting. These reports are more automated and accessible than previous but still require maintenance and checking and more detailed analysis in key areas than can be achieved from self-service reporting.

Reporting - Providing regular company-wide performance and trend reporting, used to track progress on a variety of measures and aid key company decisions. This includes weekly revenue reporting to the Management Team and monthly key metrics reporting to the Board. This also involves acting as the sole builder and maintainer of company reports within TM1 Perspectives (having migrated to the Cognos system in Q3 2014). These reports required building from scratch having previously relied on a manual excel-based system.Systems Development and Testing - Carrying out regular development cycles within the Cognos system, involving the writing of detailed specs and the creation and execution of thorough regression test scripts.Systems admin and training - Maintaining the back end of the Cognos system and using controls to protect the accuracy of the data. Running regular training sessions with the sales team to ensure they are constantly up to date with new functionalities. This has included the writing and maintenance of a detailed user guide.Inventory Management - Monitoring expected supply of cinema admissions against advertiser demand in order to highlight any potential inventory issues and/or opportunities and communicating these to the sales team on a regular basis.Data Science - Completed General Assembly Data Science evening course winning an award for best presentation of my final project. This was a Time Series analysis to forecast cinema admissions considering factors such as historical admissions trends, weather, school holidays and google trend data.

Performance Analysis - Worked as part of a team responsible for providing information to all aspects of the business including specific requests for Press, Investor Relations and Sales as well as general performance reporting on ITV and competitors to be used throughout the company. This involved extracting relevant data from systems including TNS Infosys, DDS, Ratings Analyser and NMR Monitor and interpreting and presenting this data in an insightful and impactful way in the form of both regular reports and ad hoc requests.Liaising with Press - Appointed as key Press contact within my team which involved running a weekly meeting to collate any key performance points we had recognised and meeting with the Press team to discuss potential stories to pitch to trade and public press to enhance the company’s reputation.Training and Development - Trained new Assistants so that they were able to take on their own regular reports and projects and develop into valuable and confident team members.Sharing of Information within the team - Presented to fellow team members in regular meetings on recent projects and developments in my areas of expertise.