Jeremy - Data Analyst EXCEL

Data Analyst

Develop dashboards with PowerBI and ad-hoc reports with SQL queries
Contribute to the monthly report with economic data analysis articles

Microsoft Excel - VBA Consultant, AbleOwl

Developing a resource model for MoJ’s Coronial Services.

position terminated due to lower than expected workload)
Using advanced Excel and VBA skills to build and amend dashboard reports for corporate clients.

Using advanced Excel skills to rebuild and run periodic performance reports.
Writing the daily commentary on the New Zealand Financial Market.

Using advanced Excel skills to rebuild and run periodic performance reports.
Writing the daily commentary on the New Zealand Financial Market.

After developing an application to provide the largest cocktail menu in the world (5000+ cocktails), I
opened a restaurant in Wellington. I was responsible for the operational management of the business:
payroll, ordering supplies, tracking of financial performance, front of house duties.

Reporting Analyst, Hyundai NZ Ltd (Part-time,

This role involved processing a backlog of invoices as well as setting up tools in Excel to track and
synchronize the work of multiple staff members Another component of the position was customer
relationship management.

Reporting Analyst, Commerce Commission (Fixed term, April - September 2012)
I produced a report on Australian airports’ regulation and contributed to Excel modelling work on the New
Zealand electricity market.

Reporting Analyst, Payments NZ (Permanent role

• Producing statistical monthly reports for New Zealand banks using PowerPivot in Excel, SQL
queries, and VBA macros. I also answered all statistical questions from the public.
• Documents Management Systems (DMS): I designed the internal file system and managed our
purpose-built online secure DMS in order to share documents with external stakeholders.
• Administrative support: I provided software support to other team members on ad-hoc tasks such
as generating distribution lists for event invitations and PowerPoint presentations.

Market Analyst, Coaltrac (Contract

I produced a report on Australian airports’ regulation and contributed to Excel modelling work on the New
Zealand electricity market.