Experience

NEL

• United Kingdom
• Hospitals and Health Care
• 200 - 300 Employee

• Analytical Consultant

  • Jan 2021 - Present

  • Vaccination London regional reporting. Created an automated reporting process to handle the daily vaccination reporting deadlines. During this project I used Excel, Power Query and Microsoft Teams. • Greener NHS Project - Activity Modelling - Calculated NHS activity associated with carbon footprint. Fine-tuned the SQL scripts – converted R scripts into SQL. During this project I used R, SQL, NCDR databases such as SUS plus, MHSDS, IAPT. • CYP Project - Triangulate and analyse data linked to complex need among children in the Thames Valley area. I used ARC GIS to create geography reports, which involved creating custom maps to accommodate the change in NHS landscape, such as CCG mergers.• Personalised Care Dashboard – Data processing, manipulating and development of a Tableau dashboard, which will indicate the measurement of Personalised care in a national setting as part of the NHS long term plan. Liaised with clients regularly for any iterative development of the dashboard. During this project, I used SQL, Tableau, ARC GIS, Power Query and Excel. • Crisis Home Treatment - Calculate case load, targets, demographics of Mental Health data sets - specifically focusing on Home Treatment. Show less

• Senior Business Intelligence Analyst

  • Feb 2017 - Dec 2020

  • Developed a new dashboard for NHS England which incorporates all of our key reports into one easy to use resource for each acute provider• Managing majority of the reports sent to NHS England on a monthly basis• Developed SQL scripts, views and stored procedures to support business intelligence • Used SQL and Excel to create monthly reports which includes data quality, anomalies, patterns, duplication and reconciliation checks• Used Excel, VBA, Power BI and Tableau for visual reports• Used SSIS packages for ETL purpose for various dynamic datasets • Extracted and analysed datasets to help validate QIPP analysis• Led multiple meetings between commissioners, trusts and finance teams regarding business intelligence – presented technical information to non-technical audience• Collated and presented information with accuracy, within deadlines and ensured it is fit for purpose• Prepared analysis for contract negotiations with providers for their services• Actively interpreted complex health intelligence information from a variety of sources, including SLAM and SUS; and advised stakeholders on the implications of this data for specialised services.• Challenged providers to produce accurate and meaningful data in a timely and efficient manner, and negotiated for the provision of additional data where appropriate• Contributed to the work of the Business Intelligence Function, working within project teams and training other team members as required• Line manage and mentor/train members in the team Show less

• Information Analyst - Business Intelligence

  • Feb 2016 - Feb 2017

  • Manage various large data sets from multiple organisation across London • In charge of month on month performance report checks • Produce ad-hoc and monthly reports using SQL and Excel• Create Views on SQL to standardise the original data sets• Automate monthly activities using store procedures• Create various SSIS packages for ETL purpose • Collate and present information with accuracy, within deadlines and ensure it is fit for purpose• Prepare analysis for contract negotiations with providers for their services• Actively interpret complex health intelligence information from a variety of sources, including SLAM and SUS; and advise stakeholders on the implications of this data for specialised services.• Challenge providers to produce accurate and meaningful data in a timely and efficient manner, and negotiates for the provision of additional data where appropriate• Contribute to the work of the Business Intelligence Function, working within project teams and training other team members as required Show less



London Borough of Redbridge

• United Kingdom
• Government Administration
• 700 & Above Employee

• Data Quality Analyst

  • Jan 2016 - Feb 2016

  •Responsible for the collection, collation and importing of data required to update the Central Pupil Database and Children's Centre's Database and support the development of the databases •Managed the system for Children’s Services by ensuring that the data held within them is accurate and up to date •Used SQL Report Builder to produce standard and ad-hoc reports from the databases as required •Assisted colleagues across Children’s Services with the usage of database modules •Responsible for the collection, collation and importing of data required to update the Central Pupil Database and Children's Centre's Database and support the development of the databases •Managed the system for Children’s Services by ensuring that the data held within them is accurate and up to date •Used SQL Report Builder to produce standard and ad-hoc reports from the databases as required •Assisted colleagues across Children’s Services with the usage of database modules



Freshfields Bruckhaus Deringer

• United Kingdom
• Law Practice
• 700 & Above Employee

• Data Analyst

  • Nov 2015 - Dec 2015

  •Main purpose of this role is analyse data using the CONNECT CRM software. •Integration - I have matched, merged and linked data from a variety of disparate sources •Collation - I collected information from various sources for addition to systems •Quality - I have done data quality checks - corrected, standardised and verified data stored within custom built and Microsoft environments •Profiling – I inspected data for errors, inconsistencies, redundancies and incomplete information •Data augmentation/enhancing – I enhanced data using information from internal documents and external (web) data sources. •Data standards – I maintained existing controlled vocabulary/taxonomies. Updated and maintained lists and compared it with existing firm wide lists. •I have used various Excel functions and conditional formatting to efficiently analyse the data. Show less



hinchingbrooke hospital

• Medical Practices
• 1 - 100 Employee

• Information Analyst

  • Apr 2015 - Sep 2015

  • Validate patient pathways, in relation to the admitted and non-admitted patients’ performance, interpreting the weekly RTT patient tracking list. • Checked the integrity and accuracy of large volumes of data that is essential to the Trust’s delivery of 18 Weeks. Tracking of patients through 18-week process to ensure they are treated in a timely fashion. Escalate or deal with potential issues/problems in relation to RTT weeks to management team and other relevant operational teams. • Investigated missing pathways in the RTT pathways using Excel and SQL. Once I have identified the missing pathway, I would create an appropriate new RTT pathway to keep track of patient progress. • I have used PAS, E-camis, Excel and SQL as tools to efficiently validate Inpatient and Outpatient data which lead to the successful opening and closing of RTT pathways. Used Microsoft SQL Server 2008 to investigate pathways, execute store procedures, run updates, and edit tables on design mode. • Used SSRS portal to import information for KPI monthly data which is then validated for final report. Dealt with any ad hoc requests by the team through the usage of SQL server or Excel to ensure smooth running of operational activities. • Communicated with booking, validation clerks and clinical coding to maintain accurate record of patient pathways Show less



Wanstead High School

• Wanstead High School

• Maths Teacher

  • Oct 2011 - Apr 2015

  • Teacher of KS3/KS4 students • Helped students achieve above their expected grade • Helped create SOW for KS3 using excel and word • Used Excel to analyse student data • Successfully represented the NQT trainee of the borough • Created many kinaesthetic lessons to enhance students learning • Successfully took over exam groups few months before final exams • Analysed student data from online ICT tasks • Teacher of KS3/KS4 students • Helped students achieve above their expected grade • Helped create SOW for KS3 using excel and word • Used Excel to analyse student data • Successfully represented the NQT trainee of the borough • Created many kinaesthetic lessons to enhance students learning • Successfully took over exam groups few months before final exams • Analysed student data from online ICT tasks



Stratford School

• London

• Maths Teacher - Part Time Weekend

  • Sep 2011 - Jan 2012

  • Taught maths through the usage of ICT • Prepared maths projects every week • Designed activities that will help with KS2-KS3 transition • Used ICT to help increase student’s level of understanding • Created AFL for each student • Taught maths through the usage of ICT • Prepared maths projects every week • Designed activities that will help with KS2-KS3 transition • Used ICT to help increase student’s level of understanding • Created AFL for each student



Rokeby School

• London, United Kingdom

• Maths Teacher

  • Nov 2010 - Apr 2011

  • Planned, implemented and evaluated lessons to raise achievement • Helped create school scheme of work for Year 7-9 using word • Marked/set class work/homework on daily/weekly basis • Lead P4C lessons • Created AFL data sheet for entire maths department • Applied different teaching techniques to suit lessons • Conducted parents meetings and assessment review days • Invigilated exams • Planned, implemented and evaluated lessons to raise achievement • Helped create school scheme of work for Year 7-9 using word • Marked/set class work/homework on daily/weekly basis • Lead P4C lessons • Created AFL data sheet for entire maths department • Applied different teaching techniques to suit lessons • Conducted parents meetings and assessment review days • Invigilated exams



Chafford School

• Essex

• Trainee Teacher

  • Feb 2010 - May 2010

  • Adapted own scheme of work to suit the ability of the student • Challenged students with higher level of work • Worked part of Multi-age form class • Worked collaboratively with other trainees to do a presentation on knife crime • Used different assessment techniques to record student achievement • Adapted own scheme of work to suit the ability of the student • Challenged students with higher level of work • Worked part of Multi-age form class • Worked collaboratively with other trainees to do a presentation on knife crime • Used different assessment techniques to record student achievement



Eastlea Community School

• London, United Kingdom

• Trainee Maths Teacher

  • Nov 2009 - Feb 2010

  • Taught KS3/KS4 students • Gained experience with EAL and SEN students. • Integrated ICT into teaching and learning practice • Implemented effective classroom management • Utilised assessment for learning • Gained skills to better interact with students • Taught KS3/KS4 students • Gained experience with EAL and SEN students. • Integrated ICT into teaching and learning practice • Implemented effective classroom management • Utilised assessment for learning • Gained skills to better interact with students