Compliance & Data Officer

• May 2017 - Present

• HESA Alternative Provider Student Record Return, exported all data and uploaded to HESA Data Collection system, cleared all schemas errors, business rule errors, exception/continuity errors and most warnings. Responded to all Minerva queries, and signed off.• HESA Data Futures – project managing Data Futures, gone through all of the data items to determine which ones are relevant to SAE, worked with our database developers on creating new fields for data we don’t currently store, and amending the ones we currently have, worked with our Marketing, Admissions and Student Experience teams to ensure we collect the data required for the return, working with our database developers to create new exports to upload the data• HESA Graduate Outcomes – create the contact data, sourced contact details, upload to the Graduate Outcomes Portal, cleared errors, set for Approval• HESA UNISTATS – create the data, clear queries, upload the data to the HESA Data Collection system, clear the errors and warnings, and signed it off• HESA Provider Profile – create and submit the return, and arrange sign off• HESA Aggregate Offshore – submit a nil return• OfS NSS – obtained the data and completed the NSS spreadsheet and submitted it• OfS HESES – create and submit the workbook and provide responses to the OfS Verification process, and sign off• OfS PREVENT & HESA HE-BCI - co-ordinate and submit these returns that Senior Management complete• Regular internal data audits – create and distribute data issues to internal staff• SLC Course Designation – update SAEs course information on the SLC Course Management System to allow students to apply for funding• JISC Analytics Labs – part of the February 2018 Cohort as the first AP team, we created dashboards in Tableau, my team worked on students distance travelled, i.e. looking at entry qualifications compared to the exit award, by gender, ethnicity and disability

Analyst/Operations

• May 2016 - Dec 2016

• Redesigned Sales Report• Input forecast figures from Sales Team into Sales Report each month• Updated the Consolidated Report each month• Confirmed stock locations and input them onto SAP Business One• Reconciled the stock in Stores against what is on SAP • Identified items to be put in stock and updated SAP with locations and quantities• Created new items on SAP• Inactivated items on SAP• Identified duplicates on SAP and inactivated them• Participated in Stock Checks• Goods Receipt and Goods Issue on SAP• Wrote SOPs for the International Logistics Managers role; Picking/Packing/Shipping• Wrote procedures for using SAP; creating new records/goods receipt/goods issue/stock audit report• Wrote SOP for disassembling a machine

Reporting Analyst

• Nov 2008 - Apr 2016

• CMS (Case Management System) reporting using ODBCs• Report writing in Oracle• Reports created in Excel using VBA• Monthly Management Information reporting to external customers• Developing automated systems• Building databases in Microsoft Access• Headcount management for profit and loss purposes• Internal staff performance reporting• Ad-hoc reporting for internal and external customers• Supporting colleagues by setting up KPIs and providing Microsoft Excel support for less experienced users• Health and Safety Representation

Data Analyst

• Nov 2007 - Oct 2008

• SAP/BW reporting• Daily, Weekly and Monthly reporting• Implementing a system to report on business efficiency for a lead service for the business. Ensuring a weekly report is delivered accurately and timely to senior staff• Ad-hoc data analysis and reporting via an inbox system for internal customers• Completed Transact-SQL Server 2000, 2 day course • SAP/BW reporting• Daily, Weekly and Monthly reporting• Implementing a system to report on business efficiency for a lead service for the business. Ensuring a weekly report is delivered accurately and timely to senior staff• Ad-hoc data analysis and reporting via an inbox system for internal customers• Completed Transact-SQL Server 2000, 2 day course

Supporters Development Officer

• Oct 2000 - Nov 2007

• Maintenance of a Visual Alms Fox Pro database• Reporting and data analysis • Importing, exporting and complex querying to extract data, extensively using company database, access and excel, using advanced formulas, data validation and pivot tables, and different types of query and macros• Regular auditing of database to ensure data integrity• Outstanding knowledge of Microsoft Outlook, Excel, Word including mail merge. Good knowledge of Microsoft Project, PowerPoint and Publisher• Project managing approx 25-30 fundraising campaigns a year. Including complex scheduling. Setting up and running telephone fundraising campaigns, postal mailings, email bulletins and overseas trekking events• Construction of budgets and monitoring of expenditure vs Return on Investment• Proposal writing to obtain quotes from agencies• Detailed briefing of external agencies, mailing houses, printers, fulfilment houses• On-going communication with suppliers and agencies• Design and development of letters, donation forms and fulfilment materials for fundraising campaigns• Legacy Fundraising. Communication with solicitors and executors of estates. Estate account reading. Legacy promotion to encourage supporters to leave a cash legacy to the charity in their Will• Database training and supervision of school work experience placements, data entry staff, agency staff and community service placements

Seminars Administrator

• Aug 1996 - Aug 1998

Trainee Administrator

• Aug 1994 - Aug 1996