$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Data Analyst with strong Excel, SQL, Power BI, and R skills.
Andrew Young
,
Scarborough, United Kingdom
Experience
Other titles
Skills
I'm offering
I have over 10 years of experience as a data analyst, gained from working in industries such as examinations, utilities, legal, banking and HR. I also have an academic background in GIS and database development. Throughout my career I have gained a reputation for outstanding data analysis and visualisation skills, as well as being a subject matter expert and trainer in Microsoft Excel. Passionate about data science and statistics.
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Industries
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2018 - ?
job
Data Analyst
Secure & Confidential Documents Ltd.
Responsibilities:
• Examination Results Management - Analysing and presenting exam performance data and statistics.
• SQL Server - Creation of stored procedures to extract insightful statistics for clients.
• Delivering Microsoft Excel training.
• Conducting internal audits in line with ISO requirements.
• Processing of customer supplied or requested data to suitable formats and sequences to be used on variable data production workflows to create print ready output.
• Designing the layout and merging of data on to final print ready format to customer requirement.
• Designing and running production workflows to create print ready outputs.
• Producing soft and hard copy proofs for customer approval where requested.
• Mail sortation to specified DSA providers and selected services.
Achievements:
• Research and development of a collusion detection solution for MCQ examinations, based on statistical insight.
• Examination Results Management - Analysing and presenting exam performance data and statistics.
• SQL Server - Creation of stored procedures to extract insightful statistics for clients.
• Delivering Microsoft Excel training.
• Conducting internal audits in line with ISO requirements.
• Processing of customer supplied or requested data to suitable formats and sequences to be used on variable data production workflows to create print ready output.
• Designing the layout and merging of data on to final print ready format to customer requirement.
• Designing and running production workflows to create print ready outputs.
• Producing soft and hard copy proofs for customer approval where requested.
• Mail sortation to specified DSA providers and selected services.
Achievements:
• Research and development of a collusion detection solution for MCQ examinations, based on statistical insight.
Sql, Excel, Layout, SQL Server, Research, Training, Management, Stored procedures, Statistics, Presenting, Analyst, Development, Production, Processing
2016 - 2018
job
Data Analyst
Dwr Cymru Welsh Water.
Responsibilities:
• Working with Tallyman Developers & Collections Management to ensure that data is
collected appropriately, in useable formats within the Tallyman treatment paths,
where possible anticipating future needs.
• Development and maintenance of a suite of reports to provide detailed portfolio and
individual performance reporting, using SQL Server Management Studio, SSRS, and Excel 2013.
• Development and deliverance of Exception reporting to provide information to enable
the prompt identification of issues and failure in service delivery.
• Providing ad hoc data analysis to support the identification and tracking of performance improvement opportunities.
• Working closely with the Collections team, Tallyman Developers and management to measure and demonstrate improvement in collections performance.
• Engagement with stakeholders, appropriately facilitating prioritisation and managing
expectations.
Achievements:
• Received a 'Diolch' Award in June 2017 for assistance given to the Debt Team Manager on a complex Excel spreadsheet for call assessments.
• Working with Tallyman Developers & Collections Management to ensure that data is
collected appropriately, in useable formats within the Tallyman treatment paths,
where possible anticipating future needs.
• Development and maintenance of a suite of reports to provide detailed portfolio and
individual performance reporting, using SQL Server Management Studio, SSRS, and Excel 2013.
• Development and deliverance of Exception reporting to provide information to enable
the prompt identification of issues and failure in service delivery.
• Providing ad hoc data analysis to support the identification and tracking of performance improvement opportunities.
• Working closely with the Collections team, Tallyman Developers and management to measure and demonstrate improvement in collections performance.
• Engagement with stakeholders, appropriately facilitating prioritisation and managing
expectations.
Achievements:
• Received a 'Diolch' Award in June 2017 for assistance given to the Debt Team Manager on a complex Excel spreadsheet for call assessments.
Sql, Excel, Data Analysis, SQL Server, Management, SSRS, Support, Analyst, Development
2012 - 2016
job
MI & Billing Coordinator
DAC Beachcroft Claims Ltd.
Responsibilities:
• Creating MI reports for key stakeholders and clients on matters including new instructions, billing performance, aged debt, costs, and other ad-hoc requests. This involved the use of pivot tables, charts, slicers, and functions such as VLOOKUP.
• Developing systems using Excel, Access and SQL to monitor billing performance, aged debt, and costs instructions, which have been used as a template across the CSG Motor division in the Newport, Birmingham, Bristol and Manchester offices.
• Chasing aged debt from clients and policyholders in compliance with the agreed processes and policies.
• Identifying, analysing and addressing client and office balances in compliance with SAR regulations.
• Raising general damages and costs bills (both fixed fee and hourly rate), disbursement bills, and internal bills for the fee earners in the team.
Achievements:
• During the 2013-14 and 2014-15 financial years, reduction of overall aged debt from £100k to £43k (57% decrease), and reduction of over-60 day debt from £60k to £23k (62% decrease), both against a target of a 25% decrease.
• Quality of reports and systems has led to positive feedback from clients and associates, and widespread recommendation across the group to adopt my data reporting systems as templates.
• Creating MI reports for key stakeholders and clients on matters including new instructions, billing performance, aged debt, costs, and other ad-hoc requests. This involved the use of pivot tables, charts, slicers, and functions such as VLOOKUP.
• Developing systems using Excel, Access and SQL to monitor billing performance, aged debt, and costs instructions, which have been used as a template across the CSG Motor division in the Newport, Birmingham, Bristol and Manchester offices.
• Chasing aged debt from clients and policyholders in compliance with the agreed processes and policies.
• Identifying, analysing and addressing client and office balances in compliance with SAR regulations.
• Raising general damages and costs bills (both fixed fee and hourly rate), disbursement bills, and internal bills for the fee earners in the team.
Achievements:
• During the 2013-14 and 2014-15 financial years, reduction of overall aged debt from £100k to £43k (57% decrease), and reduction of over-60 day debt from £60k to £23k (62% decrease), both against a target of a 25% decrease.
• Quality of reports and systems has led to positive feedback from clients and associates, and widespread recommendation across the group to adopt my data reporting systems as templates.
Sql, Excel, Compliance, Coordinator, Office, Processes
2008 - 2012
job
Internet Banking Advisor
Lloyds Banking Group.
Responsibilities:
• Providing assistance to customers having difficulties with the Internet Banking system.
• Accurate processing of International Money Transfers.
• Analysing MI relating to advisors, including average handling time, time off the phone, attendance and adherence.
Achievements:
• In 2012, have achieved call quality assessment score of Gold for Q1 and Q2, whilst also exceeding targets for average handling time (AHT), hold time and wrap time.
• Insight I provided into the team's average handling time for Q1 pinpointed individual development requirements. This resulted in the team's AHT going from 379 seconds in Q1 to 289 seconds in Q2, a decrease of 23.7%.
• Carried out team meetings and briefings in the absence of my line manager, and received excellent feedback.
• Providing assistance to customers having difficulties with the Internet Banking system.
• Accurate processing of International Money Transfers.
• Analysing MI relating to advisors, including average handling time, time off the phone, attendance and adherence.
Achievements:
• In 2012, have achieved call quality assessment score of Gold for Q1 and Q2, whilst also exceeding targets for average handling time (AHT), hold time and wrap time.
• Insight I provided into the team's average handling time for Q1 pinpointed individual development requirements. This resulted in the team's AHT going from 379 seconds in Q1 to 289 seconds in Q2, a decrease of 23.7%.
• Carried out team meetings and briefings in the absence of my line manager, and received excellent feedback.
Banking, Development, Internet, Processing, Customer service, DATA ANALYSIS AND VISUALIZATION
My education
2005
-
2009
University of Glamorgan
BSc (Hons) 2.1, Combined Studies
BSc (Hons) 2.1, Combined Studies
Andrew's reviews
Andrew has not received any reviews on Worksome.
Contact Andrew Young
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Andrew directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark