Jeremy - Data Analyst EXCEL

Ref : 191029M001
Photo de Jeremy, Data Analyst EXCEL
Compétences
Expériences professionnelles
CV plus récent en cours de mise à jour
  • 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
CV plus récent en cours de mise à jour
  • • 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
CV plus récent en cours de mise à jour
• 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
Amal

Data Analyst

  • L'ÎLE-SAINT-DENIS
Microsoft Power BI EXCEL SQL BI TABLEAU SOFTWARE MICROSTRATEGY Qlik Sense
Disponible
CV Business Analyst/ Data Analyst
Babette

Business Analyst/ Data Analyst

  • YERRES
SQL SAS EXCEL JIRA AGILE DATA BIG DATA BI PYTHON Microsoft Power BI
Disponible
CV Data Analyst
Zénédine

Data Analyst

  • PARIS
EXCEL Microsoft Power BI SQL PYTHON DATA
Disponible
CV Data Analyst
Mehdi

Data Analyst

  • L'ÉTANG-LA-VILLE
Microsoft Power BI EXCEL DATA PYTHON SQL TALEND Cybersécurité
Disponible
CV Data Analyst Microsoft Power BI
Adrien

Data Analyst Microsoft Power BI

  • NANTES
DATA EXCEL BI Microsoft Power BI SQL PYTHON
Bientôt disponible
CV Data Analyst Microsoft Power BI
Corentin

Data Analyst Microsoft Power BI

  • COMMENTRY
Microsoft Power BI EXCEL SQL AZURE
Disponible
CV Data Analyst PYTHON
Alexis

Data Analyst PYTHON

  • COURRENSAN
PYTHON SQL Microsoft Power BI EXCEL Google Cloud Platform TALEND BI DATA
Disponible
CV Data Analyst Microsoft Power BI
Clement

Data Analyst Microsoft Power BI

  • EYSINES
Microsoft Power BI ACTIVE DIRECTORY EXCEL MICROSOFT POWER QUERY SQL BUSINESS OBJECTS SAP SQL SERVER ORACLE
Bientôt disponible
CV Business Analyst & Consultant Power BI
Ruben

Business Analyst & Consultant Power BI

  • LYON
BI DATAVIZ Microsoft Power BI EXCEL AGILE REDMINE SQL VBA JIRA DAX
Disponible
CV Data Scientist
Emilie

Data Scientist

  • SAINT-SAUVEUR-LE-VICOMTE
DATA R Microsoft Power BI EXCEL BIG DATA PYTHON SQL SAS Alteryx SAP
Bientôt disponible