Paul Collier Email and Phone Number

In the Faculty of Science, Technology, Engineering and Mathematics, the role includes working with the Associate Deans for Student Experience, Curriculum and Tutorial Delivery to enable staff in the Faculty with responsibility for students to understand the current student success performance levels within the relevant curriculum and how they can make an impact on that performance in their current role.Working with faculty colleagues (and where appropriate wider university stakeholders), review and maintain key performance indicators (KPIs) and measures from institutional targets, ensuring that they are communicated appropriately, and that relevant colleagues are engaged with those measures. Work with colleagues across the OU, to champion and support improvements to student success. Work with Directors of Teaching, Associate Deans, senior faculty managers, SRSCs Operations Manager, Office of PVC Students, Academic Services and Information Management functions: a) to support effective initiatives, targeted interventions, pilots and tests etc. for each presentation to improve student success. b) to assist with the continuous embedding of best practice in Faculty and SRSC business processes. Support mechanisms for comprehensive monitoring of student progress and to provide reports and evaluations of actions and outcomes. To work alongside the Associate Dean, Student Experience to create an environment in which actions to support student success are encouraged and supported Have an awareness of institutional projects with a potential impact on student success and work with the Associate Dean, Student Experience to ensure that the faculty understand the implications of, and contribute to, these as appropriate.

Software Used: SAS, Power BI, Tableau, Excel, VisioI am working in the Data and Student Analytics team as part of the BI Team. I am responsible for maintaining our existing offering of support for the University whilst also transforming University's reporting from older legacy software into Power BI. The scope of the work includes the following reporting areas and projects.Acting as the lead analyst and author for the Subject and Provider level TEF activities. This involves briefing and providing support to academic colleagues on data relating to the TEF. Further, I am required to author the University's response to the TEF metrics. This is achieved by using existing analysis and developing arguments to provide counterpoints and supporting evidence to the position presented in the TEF metric workbooks.Survey Analytics for the NSS (National Student Survey), SEaM (Student Experience on a Module), PTES (Postgraduate Taught Experience Survey) and PRES (Postgraduate Research Experience Survey. These surveys help with our quality monitoring and enhancement processes. My involvement focuses on generating samples, processing response data and then generating the reporting based on stakeholder requirements.Curriculum Sustainability Dashboard. This project involves understand the economic viability and sustainability of products that are offered by the University. This year long project will combine University performance data of retention, progression and satisfaction with basic financial information of income and cost combined with time and effort to sustain product offerings.Recruitment and Management. To support the work that we do I have been involved in several rounds of recruitment to bring new analysts to the team. I also manage a team of analysts in order to deliver our priorities within the BI team including ad-hoc queries, sample selections, incremental changes to existing reporting and small BI projects.

Software used in this role includes, SAS Enterprise Guide, SAS Base, Putty, Tableau, Excel, VisioFollowing a successful period acting up as a Data Analysis Manager I have returned to my role of Data Analyst in the Marketing department. In this role I have worked on the following projects.Student Number performance reporting. My Tableau report is used to monitor student numbers against target for Marketing, the Senior Leadership team and the summation of it is received by VCE. This report is interactive and provides clear visualisations to aggregate data or drill into the detail. Complementing this is my "phased target" model that takes targets for the year and distributes them across the year so that we can judge our performance in flight.Student Progression. Marketing have been working with Academic Services to assist them in the delivery of student progression targets. I have provided a technical solution to deliver email campaigns by taking data supplied to me and transforming and uploading it to Marketing's email delivery system, Communicator. To get to this point I had meetings with technical/non-technical stakeholders in Marketing and Academic Services to translate requirements and understand the desired goals.

Software used in this role includes, SAS Enterprise Guide, SAS Base, Putty, Tableau, Excel, VisioI worked for 12 months as the maternity cover for the Data Analysis Manager in the Data and Analytics team in Marketing. This meant that I completed the following projects.Server Migration. This was a 2 month project to migrate programs and data from old to new SAS servers. Over 40 distinct programs identified for migration and documentation. This work was migrated, tested and made live whilst continuing to produce our daily outputs of data. I managed a team of 4 analysts in order to successfully deliver this on time.Process streamlining. An ongoing scheme of activity to consolidate and improve the programs and process used for data transformation. This was achieved by identifying current processes that shared similar data sources and bringing them into one unified approach. The Data and Analytics team now uses only data from this source in order to ensure our consistency in approach and output.Data Mart Builds. I have built Data Marts for Student MI, Applicant Campaign Selection, Access MI, IT Purge Process, Student Fee Payment. These marts are built with a clear and specific purpose in mind using a consistent methodology to make updating as easy as possible.Report Writing. I have continued to deliver reporting for the Marketing department in areas of Applicant and Student MI, Progression Profiling, Purge processing, Access MI and a Module Details report. These outputs are delivered in Tableau. These reports are demoed and presented to appropriate audiences. This could be through a summary described by email, PowerPoint presentations to large or small audiences or an interactive learning session in order to help stakeholders use a resource I have created.Management. As well as managing and supporting a team of three Analysts I have contributed to the Data and Analytics management team structure by helping to shape and deliver our strategic direction.

Software used in this role includes, SAS Enterprise Guide, SAS Base, Putty, Tableau, Excel, Visio Working within the Marketing Department my role was to produce MI regarding student number performance against target and Prospect and Applicant numbers. Again the requirement could be in the form of engaging interactive reports (using MI tools such as Tableau) or more static outputs in pdf/excel. I would understand and help to shape the requirements by collaborating with the client before presenting and discussing the consequences of the findings. Topics covered include tactical reporting of volumes versus target against a variety of module related variables, tracking registration/reservation activity over time, modelling target volumes at each stage of the student journey to understand progression and pinpoint faults in the pipeline, internal performance against the wider education market and student profiling.I also worked on data transformation activities specifically creating a data mart for Prospect and Applicant Campaign Selections. Based on the prescribed Segmentation and campaign plan I constructed a mart that would consistently and accurately make individuals available for communication at the right time.

This role was based in the Student Recruitment and Finance team. This area is responsible for providing support to students as they decide on a qualification to study and also assisting students in their registration process. My role was to provide performance information on inbound and outbound call handling and also analysis on the processing of diverse queries coming into different teams within the unit. Beyond this I also worked on models in order to better understand the students who come to us with queries that will affect the performance levels and numbers of staff required within the team.Within this role I continued to use SAS and Tableau as a means to process and present data. This information was communicated to colleagues, managers, team leaders and centre co-ordinators over the three locations in the UK that the team is spread across.This role also required co-ordination with other units within the University and external companies. This can range from our own IT department to Marketing and the Strategy & Information Office. This can be to receive or disseminate data or consult on different projects that will impact on critical systems that the University uses.During my time with the University I have been required and able to work as part of a wider team but also given the responsibility to manage my own workload. I was the main point of contact for particular projects due to my expertise and knowledge of the data held within the University and wider data/information usage and issues.

My primary focus, working within the Marketing Department, was to produce MI regarding student numbers which is critical for measuring performance within the department. This could be in the form of engaging interactive reports (using MI tools such as Tableau) or more static outputs in pdf/excel. I would understand and help to shape the requirements by collaborating with the client before presenting and discussing the consequences of the findings. Topics covered include tactical reporting of volumes versus target against a variety of module related variables; tracking registration/reservation activity over time; modelling target volumes at each stage of the student journey to understand progression and pinpoint faults in the pipeline; internal performance against the wider education market and student profiling.Another aspect of the role was to produce data selections for marketing campaigns or research projects. This involved discussing a brief with Marketing Communications colleagues to ensure that it met the objectives of the campaign. This required having a deep understanding of the variety of data sources available to call upon and the technical skill to access and combine them. The output produced could be used to satisfy a direct mail, email, telephone or sms campaign. This activity was concluded by analysing the outcomes from the campaigns to see if the objectives are met and so that learnings can be taken and applied in the next round of activity.

The role primarily involved the analysis and dissemination of information from the School’s main corporate database to a variety of internal and external clients. The reports were in a summary or detailed form and were presented electronically, in hard copy or through verbal presentation. Typical report information included marketing campaign analysis, faculty and course performance, client co-ordinator review, customer profiling and database administration and maintenance reports.I was also involved in the planning of data maintenance and helped to carry out cleansing and enhancement exercises. This work required co-ordinating with internal and external resources to ensure data quantity and integrity.I worked with Faculty members to create campaigns to promote a management forum for UK wide directors. This initiative had very little budget behind it and relied on close collaboration between myself and the faculty to target the right individuals in the right way with a tailored message.Given the nature of the position I was required to co-ordinate, communicate with and present information to senior and middle management, peers, members of faculty and students/delegates.Involved writing SQL and using Cognos Impromptu along with Excel for data analysis and manipulation