Jeremy - Data Analyst EXCEL

Ref : 191029M001
Photo de Jeremy, Data Analyst EXCEL
Compétences
Expériences professionnelles
  • Expérience professionnelle

    Employment History:
    Data Analyst, Hamilton City Council (Permanent role, July 2019 - ongoing)
    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

    (January - April 2019, position terminated due to lower than expected workload)
    Using advanced Excel and VBA skills to build and amend dashboard reports for corporate clients.

    (Contract until end of June 2019, Ministry of Justice)
    Developing a resource model for MoJ’s Coronial Services.

    Research and Reporting Assistant, First NZ Capital (Fixed term, October 2017 – December 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, January 2016 – April 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, Payments NZ (Permanent role, October 2012 - December 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.

    Reporting Analyst, Hyundai NZ Ltd (Part-time, October 2015 - March 2016)
    I would extract monthly sales data to update statistical reports. I would then use these reports to comment
    on trends. I also created VBA macros to automate parts of the reporting process.

    Key Energy Partner, EMP Ltd (Part-time, January 2015 – June 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.

    Market Analyst, Coaltrac (Contract, September 2011 - December 2011)
    I produced a report on the global steel market.
    Financial Officer, Department of Internal Affairs (Contract, January - September 2011)
    I processed invoices and developed tools in Excel using VBA macros to track monthly activity.
    Assistant Product Specialist, BNP Paribas Asset Management (Internship, Oct 2008 - September 2009)
    I updated monthly PowerPoint presentations for ETFs using Excel, VBA and Bloomberg. I also carried out
    research on specific issues such as competitors’ products, legal matters and economic sectors.

    Economic Analyst, French Embassy in New Zealand (Fixed term, August 2006 - June 2008)
    I was responsible for reporting on the New Zealand economy for the French Government: writing regular
    reports on GDP growth, foreign trade and investment, monetary policy etc.
    I also provided assistance to French companies seeking business opportunities in New Zealand: sector
    studies, research on New Zealand suppliers and client contacts, set-up of meetings with these companies.

    Economic Analyst, French Embassy in Taiwan (Fixed term, January 2006 - June 2006)
    I produced a market study of the Taiwanese financial system (102 p.), for the investment bank Calyon.
    Business Liaison Officer, Harbin Development Zone (Harbin, China, April 2005 - Sept 2005 – internship)
    I wrote reports on industries and businesses for potential investors in the zone.

    Economic Journalist, TechnoChroniqueurs Associes (Paris, 2003 – 2008 on a casual basis)
    I wrote articles for various French economic publications.

Études et formations
  • 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

    Education:
    • Master’s degree in Finance/Portfolio Management – University of Paris XII 2009
    • Degree from the Paris Institute of Political Studies (Sciences-Po Paris) 2003
    • Graduate of the Japanese Exchange Program at Waseda University, Tokyo 2001
    • BA in Economics and Social Science (Licence AES), Aix-Marseille II University 1999
    Interests/Hobbies:
    • Former member of Capital Toastmasters Club & Mensa International.
    • 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.

D'autres freelances
Data Analyst EXCEL

Ces profils pourraient vous intéresser !
CV Data Manager
Anastasiia

Data Manager

  • SEYNOD
Microsoft Power BI SQL EXCEL PYTHON
Disponible
CV Business Analyst SQL
Julien

Business Analyst SQL

  • SAINT-PIERRE
TOLAS EXCEL QLIKVIEW SQL JAVA DRUPAL DATA PHP HTML
Disponible
CV Data Analyst / data Science
Marie

Data Analyst / data Science

  • PARIS
PYTHON SQL DATA EXCEL Microsoft Power BI R SAS SQL SERVER
Disponible
CV Business Analyst SQL
Marc

Business Analyst SQL

  • MONTJOI
SQL EXCEL MS PROJECT ACCESS EBP PRESTASHOP MAITRISE D OUVRAGE ACTIVE DIRECTORY VBA SIEBEL
Disponible
CV Data Scientist SAS/SQL/R
Mablé

Data Scientist SAS/SQL/R

  • MONTPELLIER
EXCEL WORD POWERPOINT SQL SAS R Data science DATA JAVA
Disponible
CV Data Analyst AMOA, test et recette
Mohamed

Data Analyst AMOA, test et recette

  • ARGENTEUIL
DATA SQL JIRA MAITRISE D OUVRAGE EXCEL LIFERAY MOODYS ANALYTICS EVOLAN MOA (MAITRISE D OUVRAGE)
Disponible
CV Data Analyst EXCEL
Massilia

Data Analyst EXCEL

  • CHEVILLY-LARUE
DATA EXCEL SQL Microsoft Power BI PYTHON APACHE SPARK AZURE
Disponible
CV Data Analyst
Bouchra

Data Analyst

  • ANTONY
Microsoft Power BI SQL PYTHON DATA EXCEL AGILE BI JIRA MATLAB
CV Data Analyst R
Olivier

Data Analyst R

  • PARIS
R BASH PYTHON EXCEL SQL
Disponible
CV Développeur Oracle Apex - PL/SQL
Thierry

Développeur Oracle Apex - PL/SQL

  • ROUJAN
ACCESS SQL PL SQL VBA EXCEL ORACLE APPLICATIONS
Disponible