Platforms / Systems

  • PowerBI
  • PowerAutomate
  • SSRS
  • MS Access
  • Excel / PowerQuery
  • Raw SQL / RDBMS
  • Salesforce.com
  • JSON / XML / CSV

Requirements Gathering

  • Liaising with users to gather requirements
  • Identifying suitable reporting platforms, visualisations


Systems Integration

  • Workato
  • Identifying requirements for disparate systems to communicate / integrate
  • Document requirements for integrations
  • Build integrations, manage data transformations

Software Development Languages / Platforms

  • C#
  • SQL
  • PHP / HTML / CSS
  • Python
  • Salesforce.com
  • CodeIgniter / Bootstrap
  • Procura
  • Access / VBA
  • JSON / XML / CSV
  • Integration of Systems

Operating Systems

  • Windows - All Systems
  • Linux
  • Embedded Operating Systems
    • This site is actually running in a Docker container on my home NAS


Documentation

  • Detailed user guides
    • One of my Uni / TAFE lecturers actually kept one of my assignments to demonstrate how a user guide should be written
  • Work instructions

Strategic Planning

  • Balanced Scorecard
  • KPI Identification and Development
  • Audit tool development
  • Internal Auditing

Project Management

  • Traditional Waterfall Management
  • Agile Project Management
  • Hybrid Project Management (Waterfall + Agile)

Support

  • Support end-users on multiple platforms
    • Computer
    • Mobile
    • Printer
  • Deliver support via multiple channels
    • Face-to-face
    • Group
    • Phone
    • Email / Other Remote

Training

  • Designing training packages
  • Developing course materials
  • Delivering training face-to-face or remotely
  • Assessing training outcomes

Hardware

  • Printer setup, configuration, diagnosis and repair
  • Diagnosis and repair of desktops, servers, laptops

Networks

  • OSI Model
  • IP Addressing / Subnets
  • Network design and installation
  • Network Diagnostics

About

In late 2022 I reduced my hours with myHomecare Group to 4 days a week and started working one day a week as a contractor delivering services to a select group of 3 clients.


Clients & Roles

  • A Family Office where I primarily provide IT support for the office and homes of the owners
  • A retirement village operator rolling out high quality villages in the Hunter region. This role encompasses strategic planning, project management, Salesforce design and development as well as various IT support functions. I am currently working with another team member to design and bulid a datawarehouse pulling data from the various system via Python scripts. These systems include Xero, Salesforce, SmartSheet, Village Master and my own ticketing system where I record the usual IT-related requests for the businesses.
  • A family-owned pastoral company that runs a small stock farm in Central Western NSW. This is primarily BA and project management work

Achievements

  • Currently working closely with the AU teams to migrate the myHomecare Procura instances to the new solution being built by Australian Unity
  • As part of the migration from MHC systems to AU systems, we have changed phone systems. THe exiting provided quoted a substantial amount of money to provide the call recordings for archival purposes. I wrote a Python script that calls the providers API and downloads all call recordings to a secure location, avoiding the need to spend large amounts of money for the same result.
  • Using Workato, integrated our new HRIS platforms, together with our existing sytems reducing a significant amount of manual data transcribing between systems
  • Alongside two other data specialists, redeveloped the Data Warehouse from previous versions which were not suiteable for our reporting needs. Also unlike the original warehouse, which was not involved with, this warehouse had the data validated against source and was fully documented
  • I was responsible for a full end-to-end development where I was responsible for gathering user requirements, development of the data structure, web app, C# CLI for notifications, configuring the ETL to pull data to the data warehouse, building report tables, building the PowerBI report and finally documentation and training users. The system is used for annual "Care Conversations" (performance reviews) of field staff by their managers and required working closely with the HR team to gather requirements and determine how the system was going to work.
  • Manage the transition from in-house developed client database to an industry standard client management database on time, under budget and with no downtime for staff, employees or government claiming
  • Ongoing design, development, implementation and support of plug-in modules (C#, PHP and Access DB) to extend the functionality of the industry solution, providing a "point of difference" for the organisation
  • Oversee the transition from on-premise IT solution to Infrastructure-as-a-Service with no down-time for employees or clients mitigating risk and allowing for advanced disaster recovery planning
  • Design, develop and certify Medicare online claiming system for a Department of Veterans Affairs program
  • Design and develop integration between Salesforce and the industry client management system, reducing manual data entry between the two systems
  • Working as part of the integration team, successfully integrate acquired businesses using different systems, policies and processes in to a single consolidated organisation with common systems.


Roles & Responsibilities

  • Quality Manager
    • Audits. Design, plan and implement internal audit program. Prepare for and attend all audits with external agencies / bodies as a subject matter expert
    • Committees. Secretary of Internal Continuous Improvement Committee for 8+ years. Preparing for meetings with the executive, gathering and collating KPI data. Recording, preparing and distributing minutes of meetings. Preparing yearly meeting schedules to suit executive calendars
    • Document Control. Reviewing documents, including the contents of policies. Applying corporate document control to new documents
    • Continuous Improvement (CI). Design, develop maintain and enhance the CI Register. This is a web-based register of all feedback to the organisation, synchronised with Salesforce to take advantage of the advanced reporting available.
  • Business Analyst
    • Ad-Hoc Reporting. Prepare report data on an ad-hoc basis as requested. Work with the various business units to determine the reason for reporting, intended audience and the format required. I am starting to integrate Python in to my reporting toolkit as I become more familiar with it.
    • Formalised Reporting. Design, develop and maintain various reporting tools in consultation with end users. Recently I have assumed responsibility for managing the PowerBI reporting suite. Using my knowledge of the backend data structure and business rules, I am required to develop new dashboards and reports, correct errors and make improvements on existing reports / dashboards. Much of this work is preparing the data in the data mart and building user-friendly dashboards and reports in close consultation with the end users.
    • Tender Writing. Prepare, review and submit tenders for government funding. This role incorporates the identification of data sources (both internal and external), extraction and manipulation of data from those sources to provide meaningful information for inclusion in tenders.
  • Information Technology
    • IT Manager. Maintain corporate network infrastructure, plan for future capacity, manage the IT Team, liaise with external IT vendors and suppliers, keep abreast of changing industry best-practice and identify where this would fit with the business, implementing as necessary
    • IT Support. Deliver training for new employees at orientation on the various systems, provide support on mobiles, desktops, printers and network to staff in the field, remote offices and the main office
  • Database Manager / Developer
    • Internal CRM. Working closely with the initial developer, continued the development of the internal client management system. This system managed all business functions except payroll. This required a deep understanding of how the business functioned and the requirements of various funding agreements, legislation and best practice.
    • CRM Migration. Once the organisation outgrew the in-house solution, an “off the shelf†solution was sought. I was part of the team that evaluated other solutions for suitability. Once a decision was made I was responsible for the project management, and a lot of the technical work, to get the system implemented on time and under budget. To provide a point of difference from all other providers using the same system, I designed a series of external modules that plug-in to the database were designed and developed. Some which the software vendor expressed an interest in purchasing the rights for.
    • Integration. Build integration between external modules, Salesforce, payroll and the client management solution
    • Reporting. Build and maintain data sources for the various reporting tools and business applications.

Achievements

  • I started with Comptech in the same role I held previously - Printer / Hardware Technician. Over the 4 years I was with Comptech, I worked my way up to Network Engineer and spent the last 12 months as Senior Network Engineer
  • One of our main routine tasks was running maintenance on computers at sites we maintained. This was a manual process of running Windows Updates, disk checks, reviewing event logs and so forth. Recognising the repetitive and time-intensive nature I designed, developed and built a comprehensive maintenance utility, in my own time, to expedite and automate monthly computer maintenance. This resulted in reduced costs to Comptech as the maintenance utility reduced the time required to maintain each computer. It also reduced the chance of an engineer missing a step of the process, improving the outcome for clients.


Roles & Responsibilities

  • Liaise with clients to understand their system needs. Based on the outcome, design a solution that will meet their needs
  • Install, maintain and upgrade network equipment, computer and printer hardware and software
  • Design, install and maintain the network and systems for a national chemist outlet chain. Working closely with the specialist software vendors of pharmacy software to ensure the proposed solution met their requirements

Achievements

  • Completed my university degree while working an almost fulltime load
  • For one of my University projects, I designed, developed and implemented a “Fault Database†(knowledgebase) to record faults with printers and the associated fix. Users could enter keywords (tags), upload samples of print errors, the cause of the fault and the associated fix to the database. This was then searchable in the for future occurrences of the fault, with the uploaded print sample (if applicable). The outcome of this utility was reduced time to diagnose faults, reduced misdiagnosis, reduction in repeat repairs and higher client satisfaction.
  • Developed a strong background in hardware maintenance and repair. Soldering, building computers, designing and installing networks and advanced diagnosis techniques.
  • It was in this role I developed the skill to explain complex hardware / IT concepts to people in terms they are more comfortable and familiar with[


Roles & Responsibilities

  • Specialised in the repair and maintenance of printers, from small home inkjets through to large plotters and colour laser printers
  • Network design, installation (incl. cabling) and diagnosis of networking faults

Experienced Business Analyst with a demonstrated history of working in the community aged care industry. Skilled in Salesforce.com Development, PHP, Technical Documentation, Databases, as well as hardware support and networking. Having experience with hardware, networking, software design and development, reporting and IT support I can provide insight across an entire solution.

Macquarie University
PG Cert Digital Forensics
2010-2012

I started this course out of interest. And it was interesting!

Course Outline
University of Newcastle
Bachelor of Information Science
1999-2004

A generalist degree targeting people looking to become project managers. Topics included in the degree ranged from software engineering, project management, data science, corporate accounting and human resources.
I also studied astronomy, electrical engineering, network engineering and AI as electives.


Other
Cert IV Frontline Management
TBA

Delivered through Central Coast Group Training, this was completed while employed at Sue Mann Nursing & Community Care.

Course Outline
Other
Cert IV Network Engineering
2005 - Incomplete

After completing my degree I was looking for more practical experience and, at the recommendation of my university lecturers who delivered some of my degree courses, I enrolled in a TAFE Cert IV course. Due to my performance in my degree courses and work experience, I was able to enrol directly in Cert IV. I successfully completed the first semester before obtaining a network engineer role, with training on the job (Comptech Engineering Services).

Course Outline
Other
Misc. Certificates / Training Completed

The following training courses have been completed over the years. Most of these were 1 or 2 day courses.

  • Salesforce Developer (Delivered by Salesforce)
  • Balanced Scorecard Professional
  • Internal Auditor (Delivered by SAI Global)
  • ISO 9001 Standard (Delivered by SAI Global)
  • Agile Project Management (Delivered by PM Partners)
  • Project Management (Delivered by PM Partners)

Games
Board & Computer

I enjoy playing board and computer games. I play "heavy" boardgames as I find these stimulate my mind and usually require a high degree of strategic and tactical planning, keeping my mind active. I play computer games as this encourages good hand-eye coordination, quick-thinking and problem solving.

Aviation
Qualified Private Pilot
Not Current

I am a fully qualified private pilot, with a few endorsements allowing me to fly aircraft with retractable undercarriage and constant-speed-unit propellers. While I was flying I participated in various flyouts organised by the local Aero club and have been lucky enough to travel over most of western NSW on these trips. Sadly, flying is very expensive and is something I can no longer afford to do.


Motorsports
Motorcycle License

I have an unrestricted motorcycle license. I had always wanted to get my license, and we needed a second mode of transport. So rather than get a second car, I got my bike license instead. It also makes up somewhat for being no longer able to fly. Riding is still rather expensive when you take all the riding gear into account, but not as expensive as flying.

Development
Software Development

I enjoy writing software in my spare time (crazy, I know). My most recent achievement was writing an API in Python that runs in a Docker container on my home server. This API controls my Blood Bike availability (See Volunteering section below). It is hooked into my home automation system (HASS) so I can update my availability from any screen with the automation displayed. This avoids the need to log in to the Blood Bikes website every time. I also have an automation running that marks me as unavailable at 2030 every night in case I forget to adjust it myself.
My next goal is to consolidate the three buttons to a single button that toggles the availability status.

Current
Blood Bikes Australia

I am a volunteer for Blood Bikes Australia on the Central Coast, a national group of people who volunteer their time and motorbikes for the purpose of transporting blood and medical supplies to and from anywhere they are required.

Blood Bikes Australia
Previous
Australian Air League

In my youth and in to early adult life, I was a member of the Australian Air League (AAL) for 15 years. The AAL is a group for boys and girls aged 8 to 18 years, modelled closely on Air Cadets. I started as a junior, working my way up through the ranks until I was second-in-command of Gosford Squadron.

Australian Air League