Proven hard worker and quick learner that is enthusiastic, with the ability to adapt well to set tasks. Able to accept responsibility, whilst working alone or as part of a team. Highly competent at problem solving
Overview
12
12
years of professional experience
Work History
Finance Business Analyst / Internal Developer
Alwyndor Aged Care
11.2023 - Current
Company Overview: alwyndor.org.au
Power BI reporting, API Integration, Data Warehouse
Working with the CFO to develop various Power BI reports: Financial Power BI reports, including P&Ls, Trial Balance, Invoice reconciliation, payroll, AR & AP
People & Culture Power BI reports including workforce planning, Aged Care visits, Rostering, phone call history, HR data
API Integrations to get data from external sites for reporting, and upload data
Design & build of an internal budgeting & rostering app
Database design & data warehouse development
Alwyndor.org.au
Software & BI Developer
Australian Grain Export
02.2023 - 11.2023
Company Overview: australiangrainexport.com.au
Continuation of development of core trading platform
Development of reports using Power BI including P&Ls and Position reports
Building data pipelines & integrations between various systems
Engaging with stakeholders to ascertain system & reporting requirements
Mobile App development using Xamarin & MAUI with .NET Core APIs
Web development using ASP.NET - MVC
Australiangrainexport.com.au
BI Consultant (Analyst, Developer, Consultant)
Advance Business Consulting
02.2019 - 02.2023
Company Overview: advance.net.au
Design & build of web portal solutions using Intrexx (unitedplanet.com)
Business intelligence consulting and development of reports using Power BI / Qlik
Consulting with major stakeholders to build dashboards and reports
Integration of various data sources, data cleansing and pipeline development
Build and integration of .NET Core APIs
RESTful API integration using .NET and Groovy (via Intrexx)
Frontend web development - HTML/CSS/JavaScript
Backend web development - MSSQL/PostGreSQL/Groovy/Java
Advance.net.au
Founder
GrainFusion Pty Ltd
07.2015 - Current
Company Overview: grainfusion.com.au
Design and build of application solutions in Excel and Access, with MS SQL backends.
Database administration, schema creation, and design.
Design of a data warehouse, with a star schema (facts and dimensions).
Performance of User Acceptance Testing and change protocols.
Liaising with clients to gather software requirements.
Evaluation of business processes and finding areas for improvement.
Conducting meetings to share findings and propose solutions.
UX analysis and UI design.
Documentation of solutions and systems architecture.
Project management, monitoring performance
Contract negotiation
Budget planning & company financials
Ensuring timely completion of projects
Grainfusion.com.au
Key Clients & Major projects
COFCO International - Reporting to the CFO & Trading Manager August 2016 - 2019
Supply of new software systems for improved daily efficiencies, reporting and risk management
Data-warehouse & reporting system
ETL from existing software using SSIS
Microsoft Power BI Pro dashboards
For overall business analysis
Financial tracking, GL record analysis
Position reporting & tracking of key trades
Core trading platform: MS Access front end with SQL backend
Contract entry, management & administration
Trade profitability analysis
Daily bid entry & publication
Robinson Grain Trading - Reporting to Operations Manager & GM August 2017
MS Excel Application for the import of grain loads - 'Universal Translator'
Base file loading and transformation to destination file format
Data integrity checking
Upload process to base contracting system
Elders Rural Services Australia Limited - Reporting to the GM September 2015 - July 2017
Supply & implementation of complete Daily Accumulation portal & GrainSMART database in less than 3 months
Web based architecture, .Net, SQL Azure
Front end web design, backend database creation
Project management of IT subcontractor
National business, 100 users
For daily grain contract entry & administration
Software development & freelance design
ET Designs
10.2014 - 10.2015
Operations assistant & software developer
Australian Grain Growers Co-operative
11.2012 - 09.2014
Operations assistant across grain handling company, and developer of new software solutions
Business serving over 2000 growers with 500 members
Daily grain trading portal built in MS Access with SQL Server backend
Macro enabled excel applications
Report building, using SQL databases
Contract administration and creation
Grower (customer) services
Participating in weekly management meetings
Conducting demonstrations of software solutions
SMS campaigns
Marketing fact sheets & reports for publication of trade earnings
Graphic design of marketing brochures
Education
Grade K-6 -
Moree Public School
7-12 - ATAR 96.8
Pembroke Middle School
B. Design - Product Design & Innovation
UNISA
Skills
Power BI
Tableau
ASPNET Core
NET MVC
Blazor
Xamarin
NET MAUI
RESTful APIs
MSSQL
PostgreSQL
Azure SQL
MS Excel
MS Access
VBA
SQL Server
SSIS
Talend
ETL
Web Development
HTML
CSS
JavaScript
Groovy
Database administration
Schema creation
Queries
Stored procedures
Data-warehouses
Star schemas
Mobile app UI design
Mobile app UX design
Employmentoverview
Alwyndor Aged Care, alwyndor.org.au, Finance Business Analyst / Internal Developer, 11/01/23, Present
Australian Grain Export, australiangrainexport.com.au, Software & BI Developer, 02/01/23, 11/01/23
Advance Business Consulting, advance.net.au, BI Consultant (Analyst, Developer, Consultant), 02/01/19, 02/01/23