Experience

King Edward VI College

• United Kingdom
• Education Administration Programs
• 1 - 100 Employee

• Data Analyst

  • Jun 2023 - Present

  Learning Power BI Learning Power Automate Utilising Confluence to map and document database tables, views and schema's as well as provide useful documentation on processes, thoughts and plans Working across multiple datasets of multiple colleges and amalgamating into one location via a Data Warehouse Updating processes to be more efficient and run more smoothly Writing and maintaining SSRS reports Solving data issues Learning Power BI Learning Power Automate Utilising Confluence to map and document database tables, views and schema's as well as provide useful documentation on processes, thoughts and plans Working across multiple datasets of multiple colleges and amalgamating into one location via a Data Warehouse Updating processes to be more efficient and run more smoothly Writing and maintaining SSRS reports Solving data issues



West Suffolk College

• United Kingdom
• Education Management
• 300 - 400 Employee

• MI Systems Report Writer

  • Jun 2022 - Jun 2023

  - Learning Unit-E - Learning Power BI - Writing SQL Server queries to insert/update/delete or otherwise select information for users - Writing & maintaining SSRS reports - Maintaining & Updating Compass software (ProMonitor, ProPortal) - Providing ad-hoc data exports upon request - Learning Unit-E - Learning Power BI - Writing SQL Server queries to insert/update/delete or otherwise select information for users - Writing & maintaining SSRS reports - Maintaining & Updating Compass software (ProMonitor, ProPortal) - Providing ad-hoc data exports upon request



The Bedford College Group

• United Kingdom
• Higher Education
• 400 - 500 Employee

• MIS Developer

  • Nov 2018 - May 2022

  • Maintaining EBS4 Software and Compass Software (ProMonitor, ProPortal, ProAchieve, ProMetrix, ProSar) • Writing SQL Server queries to insert/update/delete or otherwise select information for users • Creating and maintaining SSRS Reports • Learning and understanding the funding rules for the FE sector • Helping to solve ILR errors • Learning Powershell scripting • Running the helpdesk and being first/second line support depending on the nature of the query • Learning and improving knowledge of Web languages (HTML, Javascript, ASP.Net) • Cross database query writing (Compass products, EBS & Lenel) • Debugging and testing upgrades of various software • Integrating SSRS Report Builder into a C# built Report Viewer to enable users to find a report they wish to edit then clicking on a button to load that report, rather than having to find the location then go to it in the Report Builder • Writing simple and technical documentation of various software to enable users to be more self-sufficient • Writing simple and technical help guides for problem solving for staff of different levels of the organisation • Teaching SQL Server to another member of the team. • Development of Badge Tracking application • This app allowed users to be able to log any students who have a temporary or permanent replacement badge, when they had the badge and how long for, if they handed it in, if they paid or not and how much they may owe, as well as whether or not they were actually enrolled on a course at the college. • It enables front line staff a quick and easy method of logging details very quickly into a SQL database from which reports can be made • Development of Server Control application • Combines C#, SQL and Powershell scripts to grab technical information and data from a server, display to a HTML file, allow users to view the status of specific services and stop/start them also • Utilizes a simple colour method to indicate if the server is on or offline Show less



Barnfield College

• Luton

• Report Writer & Developer

  • Feb 2018 - Oct 2018

  • Maintaining and upgrading EBS4 Software, ProSolution Software (ProMonitor, ProPortal, ProAchieve) • Writing SQL Server queries to insert/update/delete or otherwise select information for users • Creating and maintaining SSRS Reports • Learning and understanding the funding rules for the FE sector • Helping to solve ILR errors • Cross database query writing (ProSolution products, EBS & Paxton) • Development of Group Profile app ◦ This app allowed users to be able to put together information on a student or group of students in a class, to quickly identify attendance, BKSB results, prior attainment, smart targets, target grades and a teaching, learning and assessment toolkit ◦ System linked in EBS and ProMonitor data ◦ Allowed users to enter data and pull together in an Excel report via SSRS • Development of Prior Attainment app ◦ This app allowed the Maths and English teams at main enrolment to quickly capture and record learners qualifications on entry ◦ It allowed users to be able to record the examining body and allow an informed choice on what level a learner should go onto for Maths and English to then be handed to the main curriculum areas ◦ Because it was in the system already, allowed for a much faster and more efficient process during main enrolment. ◦ This was then matched to, and uploaded to EBS overnight. • Development of a Barrier Comparison app ◦ This app would connect EBS and Paxton Net2 and display all relevant information regarding the user entered. ◦ Would allow users to view and modify data in both systems to quickly rectify any problems getting through barriers, view event logs to see where problems may lie, enabled front line staff and both technical/non-technical staff alike to be able to solve issues without having to wait. Show less



Working Men's College

• London, United Kingdom

• DBA, Report Writer & Developer

  • Sep 2016 - Feb 2018

  Maintaining and upgrading EBS4 Software Writing SQL Server queries to insert/update/delete or otherwise select information for users Creating and maintaining SSRS Reports Writing help guides aimed at all levels of staff ability for EBS4, reports & C# applications. Learning and understanding the funding rules for the FE sector Submitting ULNs to the SFA & resolving errors Helping to solve ILR errors General problem solving Maintaining and upgrading EBS4 Software Writing SQL Server queries to insert/update/delete or otherwise select information for users Creating and maintaining SSRS Reports Writing help guides aimed at all levels of staff ability for EBS4, reports & C# applications. Learning and understanding the funding rules for the FE sector Submitting ULNs to the SFA & resolving errors Helping to solve ILR errors General problem solving



The Bedford College Group

• United Kingdom
• Higher Education
• 400 - 500 Employee

• System Developer

  • Dec 2012 - Sep 2016

  Maintaining EBS4 software. Writing SQL Server SQL database queries. Converting Oracle SQL to SQL Server. Writing Access queries and maintaining Access applications. Working with and creating forms in Infopath 2010 Creating and maintaining SSRS Reports. Providing software support to the College. Writing technical reports and specifications. Creation and upkeep of new systems via Visual Studio C# - Exams Booking System - Allows users to register students for Registration, Test Entries and Certifications. - Functional Skills tracking linking to learner attainments, PLR and Quals on Entry - Reports System - Gives users a windows-based application to find SSRS reports useful to them and their area, without having to go to a URL-based reports list. - Users will be taken to a page customised to their reporting needs. - Patch log to allow users to track differences between versions - Easy ability to contact support for feedback or bug reporting - 24+ Loans - Allows users to import CSV information from the SLC into a table, which is then displayed alongside current data held in-house to allow comparisons and tracking. - Overnight process populates main datagrid to ensure all data is kept up-to date. - Curriculum Planning - Allows for better synchronization between departments in the planning and creation stages - Enables Academic staff to enter in desired planned hours and curriculum information which is then stored in background tables for Support staff to scrutinize before being inserted into live tables. - All information is processed via the application, no spreadsheets, thus allowing for more efficient time-management. Minor coding in C#/ASP for web applications. Understanding and expanding knowledge of funding models and LARA. Writing how-to guides on reports, SSRS functionality, and day-to-day problem solving within the College. General problem solving. Show less



Driver Hire Milton Keynes

• Office Junior

  • Jun 2012 - Sep 2012

  Filing and ordering client paperwork. Printing office documents. Talking to clients through phone calls and emails. Updating database records. Filing and ordering client paperwork. Printing office documents. Talking to clients through phone calls and emails. Updating database records.



Embrace Life (Charity)

• Luton, United Kingdom

• Software Developer (volunteer)

  • Jun 2010 - Jan 2012

  I volunteered at a charity called Embrace Life. There i worked on the following: General problem solving and IT support. General upkeep of the computer: - Anti-Virus scanning - Anti-Malware scanning - Registry checking - System optimisation - Defragging Creating a database interface via C# that would: - Connect to an Access database - Enable users to update client information. - Enable users to browse through and search for clients. - Allow notes to be put against client records. - Ensure database integrity through security checks and passwords. - Ensure no record could be edited by two different users at the same time. - Map to a network drive. - Future upgrade would have included an in-built browser for searching information. Show less