I am a seasoned professional contractor with over 30 years of experience delivering solutions for a wide range of organisations in private and public sectors. I combine strong analytical thinking with practical problem-solving, designing systems that convert data into actionable managerial insights. My work spans from Excel macro-based automation to full MS SQL Server FMIS implementations, always focused on delivering robust, maintainable solutions that drive value. I excel at getting to the heart of a problem, selecting the right concepts and methodologies, and applying reflective, independent thinking to ensure thorough outcomes. I am a proactive communicator who translates complex technical detail into clear business options, and I enjoy transforming data into meaningful strategic guidance for management teams.

Paul Clarke

I am a seasoned professional contractor with over 30 years of experience delivering solutions for a wide range of organisations in private and public sectors. I combine strong analytical thinking with practical problem-solving, designing systems that convert data into actionable managerial insights. My work spans from Excel macro-based automation to full MS SQL Server FMIS implementations, always focused on delivering robust, maintainable solutions that drive value. I excel at getting to the heart of a problem, selecting the right concepts and methodologies, and applying reflective, independent thinking to ensure thorough outcomes. I am a proactive communicator who translates complex technical detail into clear business options, and I enjoy transforming data into meaningful strategic guidance for management teams.

Available to hire

I am a seasoned professional contractor with over 30 years of experience delivering solutions for a wide range of organisations in private and public sectors. I combine strong analytical thinking with practical problem-solving, designing systems that convert data into actionable managerial insights. My work spans from Excel macro-based automation to full MS SQL Server FMIS implementations, always focused on delivering robust, maintainable solutions that drive value.

I excel at getting to the heart of a problem, selecting the right concepts and methodologies, and applying reflective, independent thinking to ensure thorough outcomes. I am a proactive communicator who translates complex technical detail into clear business options, and I enjoy transforming data into meaningful strategic guidance for management teams.

See more

Experience Level

Expert
Expert
Expert
Intermediate
Intermediate
Intermediate

Language

English
Advanced

Work Experience

Management Accountant at Porirua City Council
August 31, 2024 - October 21, 2025
Assisted with the development of the financial Long Term Plan including capital spending forecasting and modelling. Built financial models to identify the financial impact of different rating and spending decisions. Developed rating policy for different types of buildings and land. Configured the new IBIS Breeze financial reporting system.
Data Warehouse Developer at Ministry of Education
May 31, 2023 - October 21, 2025
Developing BIML scripts to import data into their data warehouse. Development of T-SQL reports off their data warehouse.
Data Analyst at Ministry of Education
October 31, 2022 - October 21, 2025
Examining the Oracle based Teacher’s payroll system to understand how the data in it worked. Documenting and presenting findings to management.
Systems Tester at Dental Council New Zealand
April 30, 2022 - October 21, 2025
Involved in testing reports on their oDoo accounting system and the improving PostgreSQL queries and reporting on their registration statistics.
Systems Accountant at Te Puni Kokiri
December 31, 2021 - October 21, 2025
Systems accountant for the day to day running of the Technology One Accounting system.
Business Analyst at Quest Integrity NZ
October 31, 2021 - October 21, 2025
Documentation of accounting and payroll systems to support the transfer of this functionality overseas.
Systems Developer at ANZ Bank
August 31, 2021 - October 21, 2025
Development of a very complex Excel VBA Treasury reporting system. Replaced tens of thousands of spreadsheet formulas with a user-friendly business logic page to control results.
Systems Developer at Teaching Council New Zealand
March 31, 2020 - October 21, 2025
Maintenance and enhancement of the MS SQL Server database used to maintain all registered teachers in NZ. Development of complex reports; T-SQL cleaning scripts; automation of Salesforce transactions into Great Plains; documentation.
Systems Accountant at Horizon Energy Group Wellington
August 31, 2018 - October 21, 2025
Preparation of month end GL and AR uploads; automation of processes to significantly reduce manual processing time.
Excel Macro Developer at Evaluation Associates
May 31, 2018 - October 21, 2025
Developed an Excel macro driven system to provide performance statistics to the Ministry of Education; enabled data input and automated reporting.
Data Analyst and Developer at Department of Conservation, Wellington
October 31, 2017 - October 21, 2025
Reviewed management reporting for permit applications; developed an Excel macro driven system to pull data from Excel and SQL Server; produced reporting with IT collaboration.
Excel Macro Developer at Neteffext Limited
August 31, 2017 - October 21, 2025
Developed an Excel macro driven system to read payroll data and generate over 63,000 PDF reports detailing holiday pay shortfalls.
MS Access Developer at Healthcare NZ
June 30, 2017 - October 21, 2025
Developed an MS Access database to import data from multiple payroll systems to identify mismatches and produce payroll statistics.
Reconciliations Analyst at Z Energy
May 31, 2017 - October 21, 2025
Reviewed Diesel Truck Stop reconciliations; aligned sales and payments data with the JDE Edwards accounting system.
Excel Macro Developer at Key Commercial Interiors
December 31, 2016 - October 21, 2025
Automated project reporting and automated invoice uploading into Xero.
FMIS System Developer at CablePrice
December 31, 2015 - October 21, 2025
Developed an FMIS forecasting and budgeting system in MS SQL Server; used MS Access as disconnected GUI; authored all T-SQL and VBA code; improved reporting and YTD actuals.
Excel Macro Developer at KiwiBank
April 30, 2013 - October 21, 2025
Developed an Excel macro to improve agency monthly reporting.
MS Access Developer at Department of Conservation, Wellington
January 31, 2013 - October 21, 2025
Built an MS Access database to match employee skills against new positions.
FMIS System Developer at CablePrice
December 31, 2013 - October 21, 2025
Budgeting database improvements; automation of overhead allocations; data collation of millions of records.
FMIS System Developer at Cable Price
December 31, 2012 - October 21, 2025
Budgeting and reporting improvements; normalisation recommendations.
Management Accountant at Victoria University
December 31, 2011 - October 21, 2025
Reviewed Banner Student enrolment system issues; reported to CFO.
SQL Developer at ANZ Bank
May 31, 2011 - October 21, 2025
Wrote reports for the MS SQL Server bad debts system; complex reconciliations; improved reporting; used MS Access as GUI.
Financial Modeller / Analyst at Ministry of Education
September 30, 2011 - October 21, 2025
Reviewed and improved monthly property reporting; inserted T-SQL into property management; developed an Excel interface and SSRS reporting; improved budgeting and reporting; significant staff time savings.
Project System Developer at Westpac Bank
December 31, 2010 - October 21, 2025
Enhanced the Capital Expenditure monitoring system; previously built; improved IT project expenditure reporting via Excel templates and MS Access.
Management Accountant at New Zealand Meteorological Service
August 31, 2010 - October 21, 2025
Improved fixed asset reconciliations to the GL; evaluated potential FMIS system replacements; produced performance reports.
FMIS System Developer at CablePrice
December 31, 2009 - October 21, 2025
FMIS budgeting and reporting enhancements; automated data processing.
Project System Developer at Westpac Bank
November 30, 2008 - October 21, 2025
Improved IT project expenditure monitoring; consolidation via Excel and Access templates.
Management Accountant at Porirua City Council
August 1, 2024 - October 21, 2025
Assisted with the development of the financial Long Term Plan including capital spending forecasting and modelling. Built financial models to identify the financial impact of rating and spending decisions. Development of rating policy for different types of buildings and land. Configuration of their new IBIS Breeze financial reporting system.
Data Warehouse Developer at Ministry of Education
May 1, 2023 - October 21, 2025
Developing BIML scripts to import data into their data warehouse. Development of T-SQL reports off their data warehouse.
Data Analyst at Ministry of Education
October 1, 2022 - October 21, 2025
Examining the Oracle based Teacher’s payroll system to understand how the data in it worked. Documenting and presenting findings to management.
System Tester at Dental Council New Zealand
April 1, 2022 - October 21, 2025
Involved in testing reports on their Odoo accounting system and the improving PostgreSQL queries and reporting on their registration statistics.
Systems Accountant at Te Puni Kokiri
December 1, 2021 - October 21, 2025
Systems accountant for the day to day running of the Technology One Accounting system.
Business Analyst at Quest Integrity NZ
October 1, 2021 - October 21, 2025
Documentation of accounting and payroll systems to support the transfer of this functionality overseas.
System Developer at ANZ Bank
August 1, 2021 - October 21, 2025
Development of a very complex Excel VBA Treasury reporting system. The system I proposed, designed and developed used an input worksheet to capture business logic; the logic was then applied by VBA to generate reports, allowing tens of thousands of spreadsheet formulas to be replaced with a user-friendly business-logic page.
Systems Developer at Teaching Council New Zealand
March 1, 2020 - October 21, 2025
Maintenance and enhancement of the MS SQL Server database used to maintain all registered teachers in NZ. Development of complex reports, T-SQL cleaning scripts, enhancement of reporting with T-SQL and Excel macros. Development of the financial processing system to take Salesforce financial transactions and process them into the Great Plains accounting system. Development of an Excel macro system to drive and reconcile Salesforce and Paymark (Bank) files to Great Plains. Documentation using Help+Manual for the entire Salesforce–to–Great Plains processes. Implemented automated extraction of bank account numbers from Outlook emails to feed the Great Plains system.
Systems Accountant at Horizon Energy Group
August 1, 2018 - October 21, 2025
Preparation of month end GL and AR uploads between the SimPro job management system and Pronto accounting. Automated the process of handling the SimPro file downloads to create GL journals and AR upload files using an Excel macro, reducing the job time dramatically.
Excel Developer at Evaluation Associates
May 1, 2018 - October 21, 2025
Developed an Excel macro driven system to capture performance statistics for MoE; created a suite of Excel files and a menu-driven reporting approach leveraging data from SharePoint.
Data Analyst and Developer at Department of Conservation
October 1, 2017 - October 21, 2025
Reviewed their management reporting system for permission applications; created an Excel macro driven system to pull data from Excel and an MS SQL Server database to produce reports. Required political navigation to implement DB modifications; outcome delivered significantly improved reporting across branches.
Excel Macro Developer at Neteffext Limited
August 1, 2017 - October 21, 2025
Developed an Excel macro driven system to read million-plus line payroll data from multiple files to produce over 63,000 PDF reports detailing holiday pay shortfalls following the Holidays Act interpretation.
MS Access Developer at Healthcare NZ
June 1, 2017 - October 21, 2025
Developed an MS Access database to import data from multiple payroll systems to identify mismatches and produce payroll statistics reports.
Reconciliations Analyst at Z Energy
May 1, 2017 - October 21, 2025
Reviewed diesel truck stop reconciliations; ran system reports and reconciled sales and payments data to the JDE Edwards accounting system.
Excel Macro Developer at Key Commercial Interiors
March 1, 2016 - Present
Improved project reporting and automated invoice processing.
FMIS System Developer at Cable Price
January 1, 2015 - October 21, 2025
Developed a budgeting and forecasting FMIS in MS SQL Server with an MS Access GUI; improved reporting of YTD actuals against budgets and identified reconciliation issues between GL and Stock ledgers.
Excel Macro Developer at KiwiBank
January 1, 2013 - October 21, 2025
Developed an Excel macro to improve monthly reporting for the agency channel.
MS Access Developer at Department of Conservation
January 1, 2013 - October 21, 2025
Built an MS Access database to match employee skills to new positions.
FMIS System Developer at CablePrice
January 1, 2012 - October 21, 2025
FMIS enhancements to budgeting database and spare parts pricing system.
Management Accountant at Victoria University
January 1, 2011 - October 21, 2025
Reviewed Banner Student enrolment issues; reported findings to CFO.
SQL Developer at ANZ Bank
January 1, 2011 - October 21, 2025
Wrote reports for their MS SQL Server bad debts system using T-SQL; MS Access used as GUI; delivered complex reconciliations.
FMIS System Developer at CablePrice
January 1, 2010 - October 21, 2025
Improvements to budgeting database system and spare parts pricing.
Project System Developer at Westpac Bank
January 1, 2010 - October 21, 2025
Enhanced Capital Expenditure monitoring system; users entered information into Excel templates which fed an Access-based consolidation for reporting.
Management Accountant at New Zealand Meteorological Service
January 1, 2009 - October 21, 2025
Management accounting responsibilities; cost control and reporting.
FMIS System Developer at CablePrice
January 1, 2009 - October 21, 2025
FMIS system development and reporting enhancements.
Project System Developer at Westpac Bank
January 1, 2008 - October 21, 2025
Continued enhancements to IT project expenditure monitoring; Excel-based input templates consolidated into reporting.
Management Accountant at Porirua City Council
August 31, 2024 - October 21, 2025
Assisted with Long Term Plan development, capital expenditure forecasting, and rating/spending scenario modelling. Built rating policy for different buildings and land and configured a new IBIS Breeze financial reporting system.
Data Warehouse Developer at Ministry of Education
May 31, 2023 - October 21, 2025
Developed BIML scripts to import data into the data warehouse and created T-SQL reports to support management reporting.
Data Analyst at Ministry of Education
October 31, 2022 - October 21, 2025
Examined the Oracle-based Teacher payroll system understanding data structure and documented findings for management.
Systems Tester at Dental Council New Zealand
April 30, 2022 - October 21, 2025
Involved in testing reports on the oDoo accounting system and improved PostgreSQL queries and reporting on registration statistics.
Systems Accountant at Te Puni Kokiri
December 31, 2021 - October 21, 2025
Systems accountant for day-to-day running of the Technology One Accounting system; supported reporting and data quality.
Business Analyst at Quest Integrity NZ
October 31, 2021 - October 21, 2025
Documented accounting and payroll systems to support transfer of functionality overseas.
Systems Developer at ANZ Bank
August 31, 2021 - October 21, 2025
Developed a complex Excel VBA Treasury reporting system with a user-friendly business logic page replacing thousands of formulas.
Systems Developer at Teaching Council of New Zealand
March 31, 2020 - October 21, 2025
Maintenance and enhancement of the MS SQL Server database for teacher registrations; built complex reports and T-SQL scripts for data cleanup and reporting; integrated Salesforce with Great Plains; automated reconciliation between Salesforce and banking files; produced full system documentation.
Systems Accountant at Horizon Energy Group
August 31, 2018 - October 21, 2025
Prepared month-end GL and AR uploads; automated the download and posting process to reduce manual effort.
Excel Macro Developer at Evaluation Associates
May 31, 2018 - October 21, 2025
Developed an Excel macro-driven system to collect and analyze performance statistics for Ministry of Education funding decisions.
Data Analyst and Developer at Department of Conservation
October 31, 2017 - October 21, 2025
Reviewed reporting system for land-use permissions and developed an Excel macro-driven system to pull data from Excel and MS SQL Server for reporting.
Excel Macro Developer at Neteffext Limited
August 31, 2017 - October 21, 2025
Developed an Excel macro-driven system to process payroll data and generate thousands of reports addressing Holidays Act compliance.
MS Access Developer at Healthcare NZ
June 30, 2017 - October 21, 2025
Built an MS Access database to import data from multiple payroll systems and identify mismatches and statistics.
Reconciliations Analyst at Z Energy
May 31, 2017 - October 21, 2025
Reviewed diesel truck stop reconciliations; validated sales and payments against JDE Edwards accounting data.
Excel Macro Developer at Key Commercial Interiors
December 31, 2016 - October 21, 2025
Automated project reporting and invoice uploading into Xero, improving efficiency.
FMIS System Developer at CablePrice
March 31, 2015 - October 21, 2025
Developed an FMIS forecasting and budgeting system in MS SQL Server with a disconnected MS Access GUI; included budgeting, reporting, and reconciliation improvements.
Excel Macro Developer at KiwiBank
April 30, 2013 - October 21, 2025
Created an Excel macro to streamline monthly reporting for agency business.
FMIS System Developer at CablePrice
December 31, 2012 - October 21, 2025
Enhanced budgeting database and spare parts pricing system; automated data collation for ~2.5 million records.
Management Accountant at Ministry of Education
December 31, 2011 - October 21, 2025
Reviewed monthly property reporting, improved budgeting and reporting processes.
Management Accountant at Victoria University
December 31, 2011 - October 21, 2025
Reviewed issues around Banner Student enrolment system and reported findings to CFO/auditors.
SQL Developer at ANZ National Bank
January 1, 2011 - October 21, 2025
Part of a team to develop reports for a bad debts system; complex reconciliations and improved reporting from the database.
FMIS System Developer at CablePrice
December 31, 2010 - October 21, 2025
Provided improvements to the budgeting system and FMIS reporting.
Project System Developer at Westpac Bank
December 31, 2010 - October 21, 2025
Enhanced capital expenditure monitoring system by consolidating project proposals via Excel templates into an Access-based reporting solution.
Management Accountant at New Zealand Meteorological Service
December 31, 2009 - October 21, 2025
Managed fixed asset reconciliations to GL; reviewed potential FMIS replacements.
FMIS System Developer at CablePrice
December 31, 2009 - October 21, 2025
Fixed major reporting problems and enhanced budget database reporting.
Project System Developer at Westpac Bank
January 1, 2009 - October 21, 2025
Enhanced IT project expenditure monitoring; integrated Excel templates with a central reporting system.

Education

Add your educational history here.

Qualifications

Chartered Accountant (CA)
January 11, 2030 - October 21, 2025
Bachelor of Commerce (B.COM)
January 11, 2030 - October 21, 2025
Chartered Accountant (CA)
January 11, 2030 - October 21, 2025
Bachelor of Commerce (B.COM)
January 11, 2030 - October 21, 2025
Bachelor of Commerce (B.Com)
January 11, 2030 - October 21, 2025
Chartered Accountant (CA)
January 11, 2030 - October 21, 2025
Chartered Accountant (CA)
January 11, 2030 - October 21, 2025
Bachelor of Commerce (B.Com)
January 11, 2030 - October 21, 2025
Chartered Accountant (CA)
January 11, 2030 - October 21, 2025
B.Com
January 11, 2030 - October 21, 2025
Chartered Accountant (CA)
January 11, 2030 - October 21, 2025
Chartered Accountant (CA) - Verification
January 11, 2030 - October 21, 2025

Industry Experience

Government, Financial Services, Education, Healthcare, Professional Services, Other