Alexander Ware Email & Phone Number

In addition to the below, responsibility for the development of Tableau dashboards for use by departments and individuals across the business. This involves meeting with relevant parties and taking responsibility for scoping requirements, investigating questions surrounding the data that may arise, and managing deadlines. It also includes the development and management of underlying data sources, views and queries, maintaining existing dashboards and sheets, and managing users and access rights in Tableau online.

Oxford, England, United Kingdom

Key Duties & Responsibilities:- Build, test and continually develop an SQL database to specifications aligned with business needs, combined with the use of Python, Databricks, Flask and Azure Data Factory;- Work closely with R&D and Clinical Service team to understand current and future needs;- Develop internal assets (documentation, presentations and other artefacts);- Address the differing data management system needs within the business, including commercial customer data and research data associated with clinical trials;- Ensure that database curation is managed effectively;- Ensure all database programs meet company and performance requirements;- Any other duties through discussion with line manager.

Oxford, United Kingdom

Preparing the weekly room audits and ensuring they can be carried out by the Room Auditors, identifying their routes around campus, and collecting multiple room audit surveys once completed. Organising results from multiple daily room audit surveys into a single spreadsheet, cleansing the data into a format that enables easy analysis. Merging data from room audit summary with data provided from the University Timetabling and Room Booking Team to compare actual use against what was booked. Working with the Space Planning Manager, University Timetabling Manager and Head of the Academic Office to produce weekly and monthly analysis reports of room-bookings and usage data to be shared with Deans and Directors. Working with colleagues across the University to drill down data to compare against different criteria including but not limited to; room size, group size, booked by Faculty, booked but not used, average module size, etc. Identifying events that can be removed from this year’s timetabling dataset and maintaining a record of those that can be removed from the following year’s dataset. Comparing module contact time listed in the student record system to module contact time booked through CMIS and identifying discrepancies. Identifying revenue potentially lost through ineffective space usage. Producing processes to enable future analysis to be consistent. Assisting in reviewing the data to produce more detailed analysis of specific areas of interest. Advising the Space Planning Team in any improvements that can be made to the audit process. Supporting the Heads of Exams and Data Modelling with data retrieval and analysis, as required. Adhering to the University's value of dignity at work; supporting all the teams in contact to achieve the University's key objectives.

London, United Kingdom

Working with production, development and campaigns teams, I was responsible for producing the figures for simple and complex email and mailing campaigns, undertaking investigations, and automating procedures on mailings for which I was responsible.This all required working closely with campaigns, development and quality assurance teams to ensure timely results and the smooth operation of mailings and databases. I also had the opportunity to pursue development projects in this time, and further develop my SQL skills.

Rochester, United Kingdom

Reporting directly to the Customer Support manager and Company directors, I was responsible for establishing and maintaining instances of data mining applications for clients, creating modifying and updating SSRS reports, tagging and updating databases, and creating and updating advanced SQL queries. I was required to learn both SQL and the internal structure of the company quickly. The role required that I work closely with members of the support, database and marketing teams, along with the clients to ensure that tasks were completed on time and to the highest standard.

Faversham

Reporting to the Research and Development co-ordinator as well as the company directors, my responsibilities included data management, events research, and technical and customer support.I became proficient with Google Docs,and data scraping tools. and implemented a system for scraping, managing, validating and uploading data on thousands of events, liasing with external data suppliers and using data scraping tools.

Master Of Arts - Ma, Publishing Media

This course combines relevant theory with practice and enhances students' employment prospects in the publishing and related media.

Distance Learning Short Course, Start Writing Fiction

The course looks at how characters might be drawn and how setting is established. It works on the different levels of characterisation.

Bachelor Of Science (Bsc), Computer And Information Security

Btec National Diploma, It