Andrew Pearson Email & Phone Number

- Developed intuitive PowerBI dashboards to provide key insights crucial for strategic decision-making.- Coached and mentored junior team members, fostering a culture of continuous upskilling.- Conducted quality control audits, ensuring data accuracy and integrity.

Saudi Arabia

- Utilised PowerBI to conduct comprehensive trend analysis, optimising marketing spend and enhancing the admissions funnel.- Implemented data transformation pipelines to integrate recruitment systems seamlessly.- Led digital advertising initiatives, managing budgets and collaborating with external agencies on web development projects.- Managed digital advertising budget & web development projects through external agencies.- Conducted comprehensive UX, SEO & technical audit of university websites.

Canberra, Australia

- Developed CRM using PowerApps and student application process to improve control and efficiency of placing students in supervised sites during COVID-19 lockdown.- Developed consumption layer semantic models in Azure Analysis Services, to support analysis with PowerBI.- Supported the development of Azure DevOps pipelines for CI/CD, enhancing deployment efficiency and reliability across multiple projects.- Designed and developed front end of a new school application processing system.- Wrote detailed requirements for database API to support school application processing system.- Performed data analysis and developed dashboards to allow the Directorate to make informed decisions during COVID-19 pandemic.- Developed product roadmap for development, ongoing evaluation and enhancement of self-service visitor kiosks.- Conducted UX audits, requirements gathering workshops and co-design sessions to inform improvements to the enterprise school administration system.- Worked closely with stakeholders to develop detailed design documents for the enterprise school administration system.

Canberra, Australian Capital Territory, Australia

- Designed web, mobile and exhibition products using wireframes, mockups and prototypes to support the development of web, mobile and exhibition products.- Managed relationship & product enhancements with external web development agencies.- Restructured analytics platform to provide a reliable baseline for website reporting.

Canberra, Australia

- Developed brand and content strategy.- Production of undergraduate and postgraduate student guides. - Integrated an evidence based approach to support continuous service improvement through the collection of qualitative and quantitative data across websites, marketing campaigns and events.- Managed external design agencies and led team of 9 containing content producers, graphic designers with the production of digital products and print collateral.

Canberra

- Developed landing pages with up to 50% conversion rate to support student recruitment, industry outreach and internal student engagement campaigns.- Lead the design and coordinated development with an external provider for the College virtual tour (http://visit.cbe.anu.edu.au)- Coordinated the universities first Virtual Open Day, integrating live streamed presentations, campus tours and other activities. - Designed web, mobile, digital signage, print and online advertising products.- Coordinated a digital scavenger hunt for the ANU Open Day 2015 & 2016 domestic student recruitment events.- Integrated tracking links into all print and digital marketing collateral to trigger remarketing adverts improving the performance of advertising 10x.- Balanced the needs of 8 different target audiences in the development of the College website (https://www.cbe.anu.edu.au).- Responsible for requirements gathering, development and coordination of new website features.