Menu

Julien DUPREZ

Paris

En résumé

Adaptable and hard working finance studies postgraduate with varied financial and IT work experience and strong interpersonal skills seeks a career as a reporting analyst or Excel/VBA developer.

Entreprises

  • BNP Paribas - Business Analyste- Reporting decisionnel

    Paris 2013 - maintenant Reporting Reglementaire (AMF, FCA, EMIR, ITTF)
    Reporting Decisionnel (cost per trade, coût FTE par business line)
    Reporting de Risque
    Reporting Volumetrique
    Requete SQL, Access, MDX, Visual Studio

  • CIBC Mellon - Business Analyst

    2012 - 2012 VBA Automation for Excel
    - Tools to check if all the expected files have been received
    - Tools to extract data from Back Office system
    - VBA Scripting
    - Load/Send data to systems
    - Support
    - Improving efficiency of existing tools
    - Creation of new tools for Migration (parallel runs)

  • Freelance - Excel/VBA developer in Freelance

    2012 - 2012 VBA projects – Feedback 5/5 on oDesk
    VBA for Excel - Format Automation (delete,insert,copy,paste,TextToColumns)otAutomating time-consuming tasks -Downloading URLs from a column into a specific folder
    VBA for Word - Add Bookmarks and Insert Text
    VBA for Outlook - Send email by Gmail,Yahoo,Outlook with attachments,Create Mailing Rules

  • Bank of Montreal - Client Support Service

    Montréal 2011 - 2012 Processing RSP QueriesOpening, Updating and Closing Accounts in RISInvestigating and forwarding account issues

  • MCAN Mortgage Corporation - Bi-lingual Term Deposit Administrator

    2011 - 2011 Processing GIC applications in PPlus (GIC system)Preparing cheque runs and bulk cheque runs for GIC maturitiesIdentifying and recommending opportunities to make the deposit administration process more efficientBalancing daily transaction activity Updating Term rates in Cannex

  • BNP Paribas Arbitrage - Activity Reporting

    Paris 2008 - 2011 Compiling and publishing daily/weekly/monthly reports on risk and volumes for all Back-Office managers (OTC, Stocks, Listed Derivatives, Transversal)

    VBA for Excel:Macro to compare 2 Excel files (Microsoft scripting runtime library)otFormatting reports before loading files

    VBA for Access: Insert files (csv,txt,xls) into different Access tables, Create and launch queries (Modify SQL code accordint to an input value), Test and clean datas before loading, Export queries to formated Excel reports, Create and Edit Forms to allow users to select a report to process, Manipulate existing data

    ETL (Extract, Transform, Load) from/into Access Databases -tIdentification, development and implementation of operational efficiencies (automation, monitoring)

    Extension of the reports’ scope to the Woldwide BackOffice
    Working on statement of requirements and development for Data Warehouse project

    Answering manager’s requests for additional data and reports

    Ensuring the timely communication of reports and requests

  • CAISSE D'EPARGNE - Stage en Modélisation et Base Décisionnelle Financière

    2008 - 2008 Creation and monitoring of an Access database to help sales people decide the credit rate by compiling reports on clients’assets (Access-VBA)

Formations

Réseau

Annuaire des membres :