top of page

Greg Scott - Data Analyst

Work Experience

Oct 22 to Oct 23

2016 - 2022

2005 to 2016

  • A career break to allow me to dedicate my time towards helping my autistic son to prepare for his GCSEs and also to allow me to fine-tune the necessary technical skills in preparation for a career as a data scientist.

​​

  • Managed the administrative workflow for processing employment applications from medical staff, utilising Trac and ESR systems with meticulous attention to detail.

​

  • Leveraged MS Excel to generate comprehensive management reports, ensuring timely delivery of key insights while adhering to all GDPR guidelines.

​​

Key Achievements
  • Spearheaded the implementation of Excel Power Query across departmental teams, facilitating data validation procedures and promoting standardised practices for enhanced data integrity.

Head Of Computer Science

  • Led the Computer Science department across multiple secondary schools, supporting strategy development and data planning, instructional delivery, and staff management.

​​

  • Defined new data strategies and planning processes to capture essential data used in the production of Excel reports for data driven tactical decision making.

​​

  • Developed and implemented key analysis methodologies involving analytical and segmentation techniques using MS Excel, SQL, and Power BI reports designed to analyse results and inform on lesson planning, student recruitment and define data strategy.

​

Key Achievements

  • Successfully achieved increased success rates above national benchmarks in every school, with Ilford County High School Computer Science students receiving a 100% pass rate and 75% obtaining grade 9(A*).

​​

  • Led and managed teams of IT teachers by closely monitoring performance and setting SMART targets, managing their work experience and agreeing and monitoring their CPD

​​

  • Introduced new Computer Science courses such as Python Pandas, SQL Server, and database design to meet the evolving needs of students and industry demands.

​​

  • Defined data capture requirements for school staff to facilitate the production of informative departmental Excel dashboards designed to promote data-driven decision-making throughout the school based on demographic segmentation and analytical insights.

IT Lecturer - Enfield College

  • Prepared and delivered engaging and informative lectures, tutorials, seminars, and workshops for BTEC courses in Systems Analysis and Design, Relational Database Theory and SQL, and Web Design (including HTML and CSS).

​​

  • Utilised various instructional strategies, technologies, and resources to accommodate diverse learning styles and enhance student understanding.

​​

  • Managed UCAS applications and e-ILP software, including Moodle and Pro-Monitor, an integrated learning monitoring and support system.

 

Key Achievements

  • Achieved consistent success rates above national benchmarks by implementing effective teaching methods and providing personalised support.

  • Established and managed the successful ‘Computing Club’, providing students with opportunities for additional learning and enrichment using SQL, SSMS and use of Python.

​​​​

Compliance Officer

1993 to 2004

SoftwareDeveloper - Natwest, Logica(UK), CommerzBank

  • Developed and maintained software applications, systems, and solutions for leading financial institutions and IT consultancy firms, gaining exposure to all stages of the system development life cycle.

​​

  • Supervised teams of software developers and analysts by setting SMART targets, monitoring performance, conducting appraisals and also by providing technical training to new staff members.

​​​​

Key Achievements

  • Utilised programming languages, such as SQL and Visual Basic, and development frameworks and tools, to build scalable and robust applications.

  • Designed and implemented user interfaces and front-end components using web technologies such as HTML, CSS, and JavaScript.

  • Performed systems analysis and design specifications to translate business requirements into technical solutions. Developed and maintained database schemas, queries, and stored procedures using SSMS

2003 - 2004

Education

1992 - 1993

1982- 1985

PGCE (Post Graduate Cert. in Education

I completed my teacher training and obtained my QTS (Qualified Teacher Status) at Middlesex University.

MSc in Information Systems Design

I completed my post-graduate degree at the University of Westminster where I honed my skills in data every stage of the SDLC. My final year project involved the development of a windows-based application designed to cater for the registration, storage and search of military aircraft for the RAF museum in Hendon.

BSc (Hons) Biology and Chemistry

I completed my combined honours BSC(Hons) at the Polytechnic of North London. My final year project focused on the identification of Streptococcal infections in medical laboratories.

Skills & Expertise

Technical Skills

  • Database Design and SQL

  • SSMS and SSRS

  • Python and Pandas including Matplotlib, Jupyter Notebook

  • Excel, Pivot Tables and Dashboard development

  • Power BI (PL300 certified)

Soft Skills

  • Excellent communication and presentation skills

  • Experience in collaborating with diverse stakeholders and conveying complex concepts in a clear and engaging manner.

  • People management and training

  • Teamwork, problem-solving and adaptability

  • Time management 

bottom of page