Jeremy - Data Analyst EXCEL

Ref : 191029M001
Photo de Jeremy, Data Analyst EXCEL
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.

Autres compétences
• Travel: Peru, Australia, Singapore, Mongolia, Tunisia, Cambodia – to name but a few destinations.
• Sports: Certified PADI Advanced Open Water diver.
• Interests: Science, Philosophy, History, Finance, Chess, Asian cultures.
Formation

Main skills:
Data modeling skills: I have used SQL, Power BI and Excel-VBA skills to create reporting dashboards for a
wide variety of clients, including government departments, a banking association, and other large
businesses.
Analytical skills: as an Economic Analyst for the French Embassy in New Zealand, I was responsible for
monitoring the New Zealand economy as well as specific sectors for the French Government (Environment,
Energy, Financial Services and Transport). These responsibilities honed my ability to research, compile
and present relevant information from which I could draw conclusions – skills I had previously
demonstrated as an Economic Journalist.

IT Skills:
• Advanced Excel user, macro developer through VBA.
• Intermediate SQL
• Intermediate Power BI

D'autres freelances
Data Analyst EXCEL

Ces profils pourraient vous intéresser !
CV Data Analyst Microsoft Power BI
Elie

Data Analyst Microsoft Power BI

  • VILLEURBANNE
Microsoft Power BI PYTHON EXCEL JIRA SCRUM DATA SQL MICROSOFT POWER AUTOMATE
CV Data Analyst SQL
Eva

Data Analyst SQL

  • LYON
SQL Microsoft Power BI EXCEL PYTHON JIRA
Bientôt disponible
CV PMO Bancaire
Axel

PMO Bancaire

  • STAINS
EXCEL Microsoft Power BI SAGE
Disponible
CV Data Analyst Microsoft Power BI
Samir

Data Analyst Microsoft Power BI

  • GRENOBLE
Microsoft Power BI SQL SERVER EXCEL TABLEAU SOFTWARE BUSINESS OBJECTS PYTHON TALEND
Disponible
CV Ingénieur IT Data/IA
Maël

Ingénieur IT Data/IA

  • BORDEAUX
SQL PYTHON DATA EXCEL Google Cloud Platform JAVASCRIPT
Disponible
CV Ingénieur en Data et IA
Joel

Ingénieur en Data et IA

  • CHAMPS-SUR-MARNE
PYTHON Microsoft Power BI SQL EXCEL AZURE PYSPARK JAVA C# PHP .NET
Disponible
CV Dataviz /Certified Data Analyst Associate, Power Bi/Excel
Hanene

Dataviz /Certified Data Analyst Associate, Power Bi/Excel

  • BUSSY-SAINT-GEORGES
EXCEL POWERPOINT Microsoft Power BI SQL VBA BUSINESS OBJECTS PYTHON
Disponible
CV Consultante Supply Chain
Emilie

Consultante Supply Chain

  • BESANÇON
EXCEL POWERPOINT SAP
Disponible
CV Développeur Full Stack
Déborah

Développeur Full Stack

  • AMANCY
EXCEL SQL Microsoft Power BI JAVASCRIPT NODE.JS Vue.js REACT.JS FIGMA JSON PYTHON
Disponible
CV Développeur EXCEL
Mathieu

Développeur EXCEL

  • SÉRIGNAN-DU-COMTAT
EXCEL PACK OFFICE Microsoft Power BI SQL
Disponible