Jeremy - Data Analyst EXCEL

Ref : 191029M001

Domicile

3200 HAMILTON (Australie)
Profil

Data Analyst (46 ans)
Mobilité

Télétravail uniquement
Statut

Bientôt freelance

Compétences

SQL

EXCEL

Expériences professionnelles

Data Analyst

Hamilton City Council (Permanent role
Jan 2019 - aujourd'hui
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.

Ministry of Justice)
Jan 2019 - aujourd'hui
Jan 2019 - aujourd'hui
position terminated due to lower than expected workload)
Using advanced Excel and VBA skills to build and amend dashboard reports for corporate clients.
Research and Reporting Assistant, First NZ Capital (Fixed term
Jan 2017 - Jan 2018
Using advanced Excel skills to rebuild and run periodic performance reports.
Writing the daily commentary on the New Zealand Financial Market.
Restaurant Owner & Operator, Orpheus Restaurant & Bar (Self-employed,
Jan 2016 - Jan 2018
Using advanced Excel skills to rebuild and run periodic performance reports.
Writing the daily commentary on the New Zealand Financial Market.
Restaurant Owner & Operator, Orpheus Restaurant & Bar (Self-employed,
Jan 2016 - Jan 2017
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,

Jan 2015 - Jan 2016
Key Energy Partner, EMP Ltd (Part-time
Jan 2015 - Jan 2015
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

Jan 2012 - Jan 2015
• 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

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

Études et formations

• Master’s degree in Finance/Portfolio Management –

University of Paris XII 2009
2009
• Degree from the Paris Institute of Political Studies (Sciences-Po Paris)

2003
• Graduate of the Japanese Exchange Program at Waseda University, Tokyo 2001

2001
• BA in Economics and Social Science (Licence AES),

Aix-Marseille II University 1999 Interests/Hobbies:
1999
• Former member of Capital Toastmasters Club & Mensa International.