Connor Fryer
Melbourne
Summary
A self-motivated and ambitious individual with a wealth of analytical and project experience within both the public and private sector. I have a proven track record of developing strong professional relationships, in addition to a vast understanding of statistics and data. My most recent role as Customer Service Officer at the Department of Transport and Planning has ensured emphasis on having analytical and reporting skills in addition to effective communication with stakeholders.
Strategic and analytical professional with [Number] years of success in financial analysis and reporting. Talented in delivering advanced Excel and SQL reporting to plan, design, execute and evaluate report results. Highly adept in analyzing business needs using technical skills to provide data and information analysis to achieve continuous improvement. Proficient in advanced MS Excel formulas and functions to produce data-driven reports. Expert in creating reports writing SQL queries and analyzing SQL data.
Overview
4
4
years of professional experience
Work History
People and Reporting Analyst
Department of Transport and Planning
01.2025 - Current
- Collaborated closely with Human Resources and Analytics teams to support data-driven decision-making
- Generated a wide range of reports for the department, including Gender & Inclusivity metrics and People & Position reports, providing actionable insights
- Utilized advanced programs and tools such as Power BI, Power Query, and Excel (including VLOOKUP and VBA Macros) to streamline data analysis and reporting processes
- Developed and delivered comprehensive reports on key HR metrics and trends, ensuring alignment with business objectives
- Led the automation of recurring reports (e.g., using Power Automate/SQL/other tools), enabling seamless data delivery to stakeholders, with a focus on New Hires and Terminations
- Extracted, analyzed, and distributed data daily from the SAP SuccessFactors system, ensuring timely reporting for both internal teams and external clients
- Specialized in data visualization through Power BI, presenting complex data in an easily interpretable format to Business Partners and key stakeholders
Customer Service Officer
Department of Transport and Planning
05.2023 - 01.2025
- Part of the People, Reporting and Analytics team that oversaw the testing and implementation of the SAP SuccessFactors VicGov People system across the Department of Transport and Planning and Transport Partner Entities to over 8000 employees
- Effectively communicated with internal stakeholders across the Department and Transport Partner Entities, including assisting with their enquiries related to the SuccessFactors System via both phone and email
- Extracting data of enquiries received via phone and email, assisting in converting raw data on employee enquiries into presentable information, utilising a range of software programmes including Excel
- Continuous testing of the SuccessFactors system in the D2 testing environment, utilised yopmail, necessity to scrutinise data, as well as identifying any issues within the system
- Led to an overwhelming smooth rollout of updated versions of the VGP System
- Communicating with Human Resource, Reporting and Payroll teams, able to develop broader knowledge of the SuccessFactors system, improving customer satisfaction levels to over 95%, as well using critical thinking for issues to help reduce the turnaround time to responses to less than 3 days
Financial Administrator
Aware Super
09.2022 - 05.2023
- Analysing superannuation trends as well as keeping track of volumes using a range of analytical programmes such as SQL and Excel, utilising Pivot Tables and Conditional Formatting to help present publishable information in the system
- Conducting a thorough audit of members applications, scrutinising the details and checking to make sure the paperwork received matches what is on our internal system of Sonata Alta
- Publishing interactive reports using raw data statistics using Power BI, helping to visualise data on superannuation claims volumes, assisted in contributing to a 5% growth in superannuation applications between 2021/22 and 2022/23 with close-collaboration with the Marketing and Sales team
Project Support Officer
TAFE NSW
10.2021 - 05.2022
- Seconded into the Project Support team to help oversee data analysis for TAFE NSW
- Role involved gathering quantitative data on student enrolment trends state-wide, and converting the raw information received into publishable reports for the sales team who would then contact prospective students
- Key feature of role was undertaking reports, would generate daily reports via internal software programmes such as Power BI, collating high volumes of information
- Utilised a range of software features to convert the large volume of quantitative data, including Excel PivotTables, and Conditional Formatting
- Would also use Adobe PDF to help graphically summarise enrolment trends and make them easy to interpret
- Weekly meetings to discuss any changes, and if areas needed improvement
- Use of Microsoft Project to break down action plans, and utilising forecast calendars setting deadlines to aim for
Student Advisor
TAFE NSW
07.2021 - 10.2021
- Duties included communicating with prospective students via phone and online web chat and handling both inbound and outbound enquiries
- Assisting in enrolling students into TAFE NSW Courses, as well as offering concise advise to students related to any queries or concerns
- Demonstrated a thorough knowledge of the courses offered at TAFE as well as an awareness of the TAFE guidelines and policy details
- Submitting reports pertaining to the type of enquiry received by a student via use of data software in Excel
- Reports would be sent across to the marketing department to see how best the enrolment process could be improved
- Communication with internal and external stakeholders related to student enquiries, would frequently have to contact specific colleges for course information and relay information to students in a timely manner
- Scanned and inputted student files into TRIM electronic document management database
Education
BA Hons - Politics and International Relations
The University of Reading
Reading, United Kingdom 07-2016
Skills
- Project-Support
- Communication Skills
- Data Analysis
- Software Skills
- Critical Thinking
- Data analysis
- Quantitative analysis
- Power BI experience
Websites
Interests And Achievements
Extended period of overseas travel, 2018-2024 I travelled solo to New Zealand and Australia with the primary purpose of developing my interpersonal skills and gaining as much international work experience as possible, with a focus on insight into the public sector of New Zealand and Australia.
Timeline
People and Reporting Analyst
Department of Transport and Planning
01.2025 - Current
Customer Service Officer
Department of Transport and Planning
05.2023 - 01.2025
Financial Administrator
Aware Super
09.2022 - 05.2023
Project Support Officer
TAFE NSW
10.2021 - 05.2022
Student Advisor
TAFE NSW
07.2021 - 10.2021
BA Hons - Politics and International Relations
The University of Reading
Similar Profiles
Abhinav PradhanAbhinav Pradhan
Senior Road Investment Planner at Transport Assets, Department of Transport and PlanningSenior Road Investment Planner at Transport Assets, Department of Transport and Planning
Simon Di FilippoSimon Di Filippo
Operational Duty Officer at Department of Transport and Planning (DTP)Operational Duty Officer at Department of Transport and Planning (DTP)
DANIELLE CAMILLERIDANIELLE CAMILLERI
Talent Team Leader at Department Of Transport And PlanningTalent Team Leader at Department Of Transport And Planning