Experience

HousingFirst Ltd

• Australia
• Non-profit Organizations
• 1 - 100 Employee

• Data Systems Support for a data migration to new CRM (dynamics)

  • Jan 2022 - Present



Catholic Homes - Western Australia

• Australia
• Hospitals and Health Care
• 1 - 100 Employee

• Database Developer

  • Nov 2021 - Present

  Temporary IT work (expanding ACOS audit database used by all Catholic Nursing Homes) Temporary IT work (expanding ACOS audit database used by all Catholic Nursing Homes)



Self-employed

• Greater Brisbane Area

• Temporary work Property Maintenance

  • Oct 2020 - Jan 2022

  With COVID on going and slump in the job market at end of 2020 I assisted a friend in his property maintenance business while still in Brisbane before moving to Melbourne permanently. Stayed on in this role longer than planned while recovering from an illness & trying a new treatment regime. With COVID on going and slump in the job market at end of 2020 I assisted a friend in his property maintenance business while still in Brisbane before moving to Melbourne permanently. Stayed on in this role longer than planned while recovering from an illness & trying a new treatment regime.



SBH Disability Services

• Australia
• Individual and Family Services
• 1 - 100 Employee

• Salesforce Administrator/Developer

  • Mar 2018 - Sep 2020

  Training UserGuides Training UserGuides



Cystic Fibrosis Queensland

• Australia
• Non-profit Organization Management
• 1 - 100 Employee

• Casual SalesForce Admin

  • Nov 2016 - Nov 2017

  Setup new CRM (Salesforce) database and and extract, transform & load data from an another Salesforce org + various spreadsheets. Did Salesforce Administration, and integated with Conga + MailChimp + Jitterbit, EveryDayHero and Grant Funding Excel model. Did reporting on old data for Community funding campaigns. Also assisted with smaller Grant Funding Applications and built prospective donor registers. Setup new CRM (Salesforce) database and and extract, transform & load data from an another Salesforce org + various spreadsheets. Did Salesforce Administration, and integated with Conga + MailChimp + Jitterbit, EveryDayHero and Grant Funding Excel model. Did reporting on old data for Community funding campaigns. Also assisted with smaller Grant Funding Applications and built prospective donor registers.



Summit Innovations

• Australia
• Information Technology & Services
• 1 - 100 Employee

• Remote tech support

  • Mar 2016 - Nov 2016

  Remote/VPN control of PC's in store whilst helping techs on site with recalibrations of POS software. Working along side techs on the field from a remote point to trouble shoot and get stores back onto the correct server & data reporting center. IP setting to bypassing firewalls to gain remote access. Also remote service work for small jobs in stores out of metro areas. Remote/VPN control of PC's in store whilst helping techs on site with recalibrations of POS software. Working along side techs on the field from a remote point to trouble shoot and get stores back onto the correct server & data reporting center. IP setting to bypassing firewalls to gain remote access. Also remote service work for small jobs in stores out of metro areas.



Florabundance, Inc.

• United States
• Wholesale
• 1 - 100 Employee

• Contract/casual applications development (MS Access + Barcoding software + MYOB)

  • Aug 2006 - Nov 2015

  This is a large wholesale nursery. Took on development of Access application that makes it easier for operators to process & fill work orders and print the product & packing labels. It also allowed the business to import customer orders, send out price lists, manage customer preferences & plant/potting attributes that was not possible with MYOB which it linked to (as well as Bunnings software). This is a large wholesale nursery. Took on development of Access application that makes it easier for operators to process & fill work orders and print the product & packing labels. It also allowed the business to import customer orders, send out price lists, manage customer preferences & plant/potting attributes that was not possible with MYOB which it linked to (as well as Bunnings software).



Santos Ltd

• Australia
• Oil and Gas
• 700 & Above Employee

• Contract developer

  • Apr 2013 - Aug 2013

  Casual work (MS Excel + MS Access with external data) Create a prototype reporting database for the full life-cycle of land access management and compensation for multiple gas exploration projects. Casual work (MS Excel + MS Access with external data) Create a prototype reporting database for the full life-cycle of land access management and compensation for multiple gas exploration projects.



Aurizon

• Australia
• Truck Transportation
• 700 & Above Employee

• Contract/casual applications development (MS Access + SQLserver)

  • Aug 2011 - Aug 2013

  This rail transport company was split off from Qld Rail and inherited many of the IT systems used by Qld Rail. I supported a number of the databases I had developed. Minor maintenance work on ad-hoc basis. Also assisted with the incorporating of a MS Access/SQLserver reporting DB with their changeover to SAP by writing some SQL jobs. This rail transport company was split off from Qld Rail and inherited many of the IT systems used by Qld Rail. I supported a number of the databases I had developed. Minor maintenance work on ad-hoc basis. Also assisted with the incorporating of a MS Access/SQLserver reporting DB with their changeover to SAP by writing some SQL jobs.



Queensland Rail

• Australia
• Truck Transportation
• 700 & Above Employee

• Contract Applications Development (MS Access + VBA + SQLserver + MapInfo)

  • May 2002 - Jun 2013

  Worked for the QR Property Division* Build and maintain a suite of databases (MS Access front end on SQLserver backend) to manage the Property Division’s reporting requirements. These were for Outdoor Advertising Signage, Projects, Land Tax, Cultural Heritage, Business Group Referrals, Land Disposals, Valuations, Acquisitions, Heritage, Housing, Native Title, Planning/Projects, Property Administration, Legal, Third Party Access assets and a management overview reporting DB (pseudo data warehouse) that amalgamated data from these plus also data from a number of other data sources (ie Govt GIS and UCV data, Fixed Assets, Leases, Environmental, Primavera).Designed features such as custom pivot table reports , drill down reporting and automating letters with MS Word.* The Outdoor Advertising DB linked to GIS data and was used in conjunction with custom app built on handheld devices for data input and viewing out in the field.* Automate the overnight update of GIS data layers in relation to QR property edits from the main Property DB (MS Access with Mapinfo). Build a number of SQL Visual jobs to automate overnight processes in relation to Property Division data.* Build a Land Disposals dashboard reporting for use in major multi-year Disposal Project in order to capitalise on Qld Rails vast land holdings.*.I was also involved in the Land Tax Reconciliation Project in which I had to analyse Qld Rail land holdings (also past holdings & sub divisions) for determining the payment of land tax going back over a 10 years period* I was Involved as a subject expert for Property related IT systems in the concept development & detailed design phase of the switch over to SAP. Advised on existing systems and the linkages to future asset management solutions ensuring data integrity which included data cleansing, reviewing data structures for mapping and distinguish the change in reporting capabilities. Show less

• Contract Applications Development (MS Access/SQLserver + Systems Documentation)

  • Feb 2012 - Jul 2012

  Worked in the IT division.* Documented all databases and Property Division Systems processes for IT Div. (tech guides). I also wrote User Guides and conducted user training sessions for most of the applications that I developed.* I was Involved in a significant IT separation project for Government owned corporation in order to form a Government entity and private sector business (Aurizon). The project included working in line with an established IT transitional solution addressing business needs, system stability, data integrity and IT governance. A modified duplicate set of database models were built for Aurizon which linked to their data server. Show less

• Contract Applications Development (MS Access)

  • Jun 2011 - Jun 2012

  Worked for the QR Training Division* Finish off and enhance Timesheet / Project cost allocation models.* Build a database to track & monitor compliance training of audit assessors

• Contract Applications Development (MS Access + MS Excel + VBA + SAP)

  • Jan 2007 - Feb 2010

  Worked for the QR Finance Division* Build a Rolling Budget application which was used by cost center managers. The application provides for high level overview of cost center performance with drill down facility and variance reporting. The application interfaced with the data warehouse, and SAP.* Developed a Forecasting application for the Finance Dept. that consolidated 100s of CostCenter spreadsheets and provided Capital, Cash Flow & Profit Loss reporting for management and allowed for easier multiple budget revisions.* Assisted with the clean-up of Fixed Asset Register data in relation to land tenure which included in excess of over 20000 properties.*Build a database application that allowed for Capital Expenditure reporting and for forecasting of future fixed asset balances and expected depreciation and amortization charges across the various cost centers Show less



A.R.T. Air Conditioning

• Mount Isa

• Contact application developer

  • Jan 2013 - Mar 2013

  Casual work assignment - (MS Access linked to QuickBooks, GoogleDocs upload for remote access) Application was to provide a job data entry model that would populate the accounting system. A drag and drop job / employee scheduling feature was also added to replace pen & paper system. Casual work assignment - (MS Access linked to QuickBooks, GoogleDocs upload for remote access) Application was to provide a job data entry model that would populate the accounting system. A drag and drop job / employee scheduling feature was also added to replace pen & paper system.



Pentair

• United Kingdom
• Industrial Machinery Manufacturing
• 700 & Above Employee

• Contract applications development (MS Access + MS Excel + VBA + SQLserver + Cognos)

  • Oct 2001 - Dec 2012

  Originally Tycowater (steel pipe & fittings manufacturer) then Pentair after takeover. * Develop Production Scheduling models (MS Access) for various factory sites. These download & Upload various data sets from BPCS mainframe. It also uploads data to SQL Server where it is consolidated for reporting purposes and site balancing. * Reconfigure costing/estimation DB to provide for the adoption of standard item codes & costing codes and the change in Bill of Materials in the Fittings businesses. Development of Cognos Forecasting application for the Water Division. The application which resides on SQL Server and interacts with the Accounting and Manufacturing systems, and links to their Cognos Bus. Intelligence reporting. I am still involved with this project when it comes to enhancements and maintenance. * Development of Access application for the factory mgrs, that records job labour costing and automates upload to payroll. The app also caters for production forecasting and job scheduling with numerous charts and reports. It also serves the purpose as a repository of information on which historical analysis can be conducted, ie efficiency calculations, indirect labor, section performance, activities by job, capital works costing, capacity utilization, etc. * Developed a job quoting / estimation application that the estimators use to compile and cost, job estimates, and work orders, and automating the upload of these to the mainframe. Also provides for document tracking, an estimate register, KPI reporting, production analysis, etc. * Developed a series of job-time recording applications that are used at various sites, plus a room/equipment reservation application. Show less



PRIMO MORAITIS FRESH PTY LIMITED

• Australia
• Food and Beverage Manufacturing
• 1 - 100 Employee

• Casual contract systems developer

  • May 2011 - Aug 2012

  Casual work desktop reporting development (MS Excel + SQL) for what was then Salad Fresh P/L Create MS Excel models that use SQL/ODBC to interact live with BPCS mainframe to transfer data to make it easier for users to work outside of text based mainframe accounting/production system. Projects were for - Uploading sales forecast. Downloading series of KPIs for management reporting (summary with dril down details on one model based on criteria selected) Casual work desktop reporting development (MS Excel + SQL) for what was then Salad Fresh P/L Create MS Excel models that use SQL/ODBC to interact live with BPCS mainframe to transfer data to make it easier for users to work outside of text based mainframe accounting/production system. Projects were for - Uploading sales forecast. Downloading series of KPIs for management reporting (summary with dril down details on one model based on criteria selected)



Criscon Pty Ltd (Property Developer)

• Kedron

• Contract/casual applications development (MS Access + MYOB)

  • Jun 2008 - Nov 2010

  Create an MS Access application which links to MYOB accounting to provide better project management reporting than could from an accounting package. Build a mobile laptop database that on site supervisor records details in then FTPs data back to head office which updates the main reporting database. The company is a property developer. Emphasis was on custom reporting and dealing with project variations. Create an MS Access application which links to MYOB accounting to provide better project management reporting than could from an accounting package. Build a mobile laptop database that on site supervisor records details in then FTPs data back to head office which updates the main reporting database. The company is a property developer. Emphasis was on custom reporting and dealing with project variations.



LEIGHTON HOLDINGS LIMITED

• United Kingdom

• Contract applications development (MS Access + MS Office + VBA)

  • May 2009 - Jul 2009

  Worked for Joint Venture (road infrastructure projects) operation Build a couple of MS Access/Excel models. One for payroll (process times & upload from joint venture project to SAP). One for Equipment usage/hire scheduling for the various site foreman and for and forecasting costs for HO. Assignment was through Robert Walters Recruitment Worked for Joint Venture (road infrastructure projects) operation Build a couple of MS Access/Excel models. One for payroll (process times & upload from joint venture project to SAP). One for Equipment usage/hire scheduling for the various site foreman and for and forecasting costs for HO. Assignment was through Robert Walters Recruitment



Department of Environment and Science

• Australia
• Government Administration
• 700 & Above Employee

• Contract applications development (MS Access + MapInfo + GBM + SQL Server)

  • Jan 2009 - Jul 2009

  I worked in the Land Management unit Continue development of MS Access/SQL/MapInfo/GBM systems that helped the state valuers perform their job. One system created PDF docs of property valuations and saved them back to SQL Server for sharing around the state by other valuers for guidance in their valuations. Various other DBs were customized for clients that provided images of properties + assets + calculations. These also linked to GIS server and to GIS mobile devices which downloaded the data for valuers in the field then uploaded the results back to the master DB and to SQL server. Show less



RLMS - Resource and Land Management Services

• Australia
• Environmental Services

• Contract/casual applications development (MS Access + SQL server)

  • May 2006 - May 2009

  This company provides Geographical services for the mining industry. Development of various client databases that tracked property leases & access rights along with the associated documentation for mining & energy companies. GIS data was imported from MapInfo data-sets. I also created similar DB in conjunction with staff at the Department of Coordinator General which was used to manage land acquisition for state infrastructure projects. This company provides Geographical services for the mining industry. Development of various client databases that tracked property leases & access rights along with the associated documentation for mining & energy companies. GIS data was imported from MapInfo data-sets. I also created similar DB in conjunction with staff at the Department of Coordinator General which was used to manage land acquisition for state infrastructure projects.



WorkCover Queensland

• Australia
• Insurance
• 700 & Above Employee

• Contract applications development (MS Access + MS Office + VBA)

  • Jun 2001 - Nov 2001

  Developed Access application that tracks software development bugs and system requests for use by business analysts & software testers prior to roll-out of new IT system (basically a help desk application). Assisted with systems testing of mapping rules for data migration project (VMS to Oracle). This involved building the test scripts in SQL (used MS Access) and running them on sample data to compare resulting records with expected outcomes. Developed Access application that tracks software development bugs and system requests for use by business analysts & software testers prior to roll-out of new IT system (basically a help desk application). Assisted with systems testing of mapping rules for data migration project (VMS to Oracle). This involved building the test scripts in SQL (used MS Access) and running them on sample data to compare resulting records with expected outcomes.



Energex

• Australia
• Utilities
• 700 & Above Employee

• Contract applications development (MS Access + MS Office + VBA)

  • Jun 2000 - Dec 2000

  Developed multi-site Access application that tracks customer complaints and provides for performance, investigative and pro-active reporting for various user groups (Board, Regulatory Auth. Quality Control Dept, and Distributors). Developed multi-site Access application that tracks customer complaints and provides for performance, investigative and pro-active reporting for various user groups (Board, Regulatory Auth. Quality Control Dept, and Distributors).



CSR Limited

• Australia
• Wholesale Building Materials
• 700 & Above Employee

• Systems Accountant / Financial Accountant

  • Mar 1997 - Nov 2000

  * Development of various reports on the financial databases. * Maintenance of fringe benefits accounting and reporting. * Development of software applications to facilitate month end processing. * Documentation of developed applications (technical and user). * General Ledger reconciliations – across different ledgers and accounting systems. * Vehicle administration and also fixed assets ledger maintenance, capex reporting. * Uploading of electronic invoices into GL, rolling up ledgers and clearing edit checks at month end. * Office support for software trouble shooting / configuration * Maintenance of application that provides for employee cost reporting Develop application that automates the process of reconciling the accounts receivable sub ledger to the general ledger. Previously very time consuming due to the thousands of transactions involved and non integrated systems. Build an Access/Crystal/Promix application that draws in data from a number of sources (ie Visa) to provide management with the ability to view employee’s costs. It also posted expense journals to the ledger. Used for fringe benefits on group certificates Build application to automate the process of checking that each of the company’s businesses have sufficient FBT tax provision for its expenditure & the payment of the correct payroll tax Build application to automate the process of identifying errors in the G.Ledger in relation to fixed assets and their allocation across the different businesses and taxation classification. Reconciles the GL to the asset register which was not integrated Develop application that provides management with the ability to monitor Work In Progress across the businesses Build application that matches all the inter-company account balances across the Building Div and highlights imbalances, and automates reconciliation Build bank reconciliation applications that assists in matching transactions from the electronic bank statements to the entries in the GL Show less



Central Plumbing & Electrical P/L (property maintenance services)

• Footscray

• Accountant

  • Jun 1993 - Nov 1996

  * Preparation of monthly financial reports (P+L BS), general ledger reconciliations * Trading analysis reporting (by division, by project category, cashflow) * Job costing and progress billing * Job operations management – labour & materials scheduling * Accounts payable and accounts receivable. * Payroll administration (P.P.S.) and superannuation, workcare entitlements. * Client liaison, debt chasing. * Tender preparation., Purchasing, Petty cash, Banking, Office administration. Show less