Jeremy - Data Analyst EXCEL
Ref : 191029M001-
Domicile
3200 HAMILTON (Australie)
-
Profil
Data Analyst (46 ans)
-
MobilitéTélétravail uniquement
-
StatutBientôt freelance
-
Tarif Journalier MoyenVoir le tarif
-
Data Analyst
Hamilton City Council (Permanent roleJan 2019 - aujourd'huiDevelop 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 termJan 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-timeJan 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 2012I produced a report on Australian airports’ regulation and contributed to Excel modelling work on the New
Zealand electricity market.
-
• Master’s degree in Finance/Portfolio Management –
University of Paris XII 20092009 -
• 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.