Andrew Francis

Andrew Francis

Data Analyst
United Kingdom
English

About Me

An enthusiastic Mathematics Graduate who applies a methodical and logical approach to work. Skilled working with data and figures to provide an analytical problem-solving approach and experienced working in analytical ro…

Experience

Sessional Math Tutor

YMCA Key College
Sep 2024 - May 2025 · 8 months

Delivering lessons to students
Communicating their workloads
Helping them overcome their challenges
Developing their problem-solving skills
Followed established lesson plans to detail to ensure student progress stayed on track

Sessional Math Tutor

YMCA Key College
Sep 2024 - May 2025 · 7 months

Delivering lessons to students, communicating their workloads and helping them overcome their challenges and develop their problem-solving skills. Followed established lesson plans to detail to ensure student progress stayed on track.

Data Analyst

Derbyshire Community Transport
Aug 2022 - Sep 2024 · 2 years 1 month

Inputting payroll and overtime data accurately
Updating company social value calculations to measure community impact
Calculating driver mileage and fuel expenditure for local business
Working out KPIs
Troubleshooting errors within data on the operator CTX
Formatting data into the Bus Service Operators Grant (BSOG) spreadsheet

Data Analyst

Derbyshire Community Transport
Aug 2022 - Sep 2024 · 2 years 1 month

Inputting payroll and overtime data accurately alongside updating company social value calculations to measure community impact. Calculating driver mileage and fuel expenditure for local business and working out KPIs. Troubleshooting errors within data on the operator CTX and formatting data into the Bus Service Operators Grant (BSOG) spreadsheet.

FC Associate

Amazon
Oct 2021 - Jan 2022 · 3 months

Moving boxes from conveyor to containers to be loaded by trucks safely
Paying close attention to detail of items to ensure they are in correct locations ready for delivery

FC Associate

Amazon
Oct 2021 - Jan 2022 · 3 months

Moving boxes from conveyor to containers to be loaded by trucks safely. Paying close attention to detail of items to ensure they are in correct locations ready for delivery.

Data Analyst Apprentice

Pendragon
Mar 2018 - Feb 2020 · 1 year 11 months

Data collection and monitoring of vehicle movement requests, productivity and vehicle costs
Reporting discrepancies in data
Identifying unnecessary expenditure of the company
Troubleshooting issues within the transport data
Developed a system to calculate and identify methods to reduce operating costs resulting in estimated savings of £7000 per month
Developed and implemented a formular used within the company to calculate distance travel resulting in a time saving strategy
Data analysis to support the monitoring of driver expenditure resulting in the identification of a fuel card fraudulently being accessed for personal use

Data Analyst Apprentice

Pendragon
Mar 2018 - Feb 2020 · 1 year 11 months

Data collection and monitoring of vehicle movement requests, productivity and vehicle costs and reporting discrepancies in data. Identifying unnecessary expenditure of the company and troubleshooting issues within the transport data. Developed a system to calculate and identify methods to reduce operating costs resulting in estimated savings of £7000 per month. Developed and implemented a formular used within the company to calculate distance travel resulting in a time saving strategy. Data analysis to support the monitoring of driver expenditure resulting in the identification of a fuel card fraudulently being accessed for personal use.

Data entry and administration

Healthwatch
Feb 2016 - Jan 2017 · 11 months

Creating excel spreadsheets to support the capture of volunteer contact details
Collected Equality Diversity and Inclusion statistics in compliance with confidentiality and GDPR regulations

Scanning documents onto the computer

Derbyshire Community Bank
Mar 2016 - Nov 2016 · 8 months

Scanning documents onto the computer in line with compliance and confidentiality policies

Role

British Red Cross
Sep 2011

Provided a high level of customer service and support
Provided training to other staff members with digital equipment
Accurately pricing stock
Inputting customer details onto the system compliant with General Data Protection Regulation (GDPR)

Skills

Experience data analyst with experience implementing new procedures within workplaces Have experience working with and picking up analysis software including R Tableau and SQL Proficient with all Microsoft Office software Logical and methodical Problem-solving skills and organisational skills Excellent attention to detail Always professional when communicating with customers and colleagues and has experience teaching colleagues digital skills Tableau SQL Microsoft Office Problem-solving Organisational skills Attention to detail Customer communication Teaching Data analysis Data entry Administration Excel
Report this Profile?