Are you a spreadsheet ninja?
$10-30 USD
Paid on delivery
ACDN
The Aged Care Development Network (ACDN) is part of the aged care industry. We are a member association supporting people who work in aged care. Our focus is attracting and retaining quality people to the aged care industry by supporting them in three key areas: career, education and reward.
ACDN operates an ecosystem of products and services that support both the workers and the employers.
Gap Analysis Review
As part of this service, ACDN conducts audits of the personnel records of aged care facilities. We list all of the data (name, DOB, employee start date, citizen or visa, current qualification & graduation date, etc) on a spreadsheet. We look for gaps in the data - missing or incorrect information.
From this raw data we create a Gap Analysis Report. The report covers many different areas, giving the managers a clear view of all of the people: different roles inside the nursing home, ages, qualifications, etc as well as the missing data. The admin staff in the facility use the report to contact everyone with missing data and get an update on whatever is missing.
Creating the Gap Analysis Report
We are looking for a small details focused team member who loves spreadsheets - both MS Excel and Google Docs. You must be able to:
- pick up on small details and see what is missing
- be good at maths
- be excellent at getting the most out of spreadsheets - graphs, what ifs, etc
Student reconciliation in Vettrak
Vettrak is the student management system that ACDN uses to track all students studying a course through ACDN; as well as tracking our income per student. We are a broker of students to training providers (Registered Training Organisations - RTO) and we get paid each month for courses that may take 12-14 months to complete. So we need to track each payment as they come in to make sure that we are getting paid the full amount.
Vettrak is hosted by its owner, OzSoft, and we Remote Desktop into their system. So the successful candidate needs to be able to use MS Remote Desktop software. The key strengths are:
- small details focus. Lots of small numbers that need to be data entered correctly and checked
- be able to spot when something is wrong. If we are getting paid for 5 students when there are 6 students in the class, you need to ask why are we missing a student’s payments
- understand that you have access to private company records and act appropriately
# You must be within my time zone or close to it (within 3 hours)
Project ID: #8019830
About the project
Awarded to:
yes i am spreadsheet ninja, I am doing this kink of work for [login to view URL] the long term implications can be disastrous for your website and in turn your business. I am very experienced with dataentry and few of my More
6 freelancers are bidding on average $23 for this job
Modern languages graduate, native in english and spanish, advanced speaker in french and intermediate speaker in german. Experienced in marketing, translation, social media and teaching. If you want to contact me di More