Domaines de compétence

VBA

Excel (2000,2003,2007)

Access

SQL

Word

 

Connaissance en : VB.net, python, java 

Expérience professionnelle

From Jan 12              oDesk (Online): Freelance for VBA/Excel/Access projects

§  Public profile = www.odesk.com/users/~~10e588a90250d8ca

 

Oct 11- Jan 12          BMO (Toronto): Client Documentation Department – Contract

§  Processing RSP Queries

§  Opening, Updating and Closing Accounts in RIS

§  Investigating and forwarding account issues

 

July 11 - Oct 11   MCAN Mortgage Corporation (Toronto): Bi-lingual Deposit Administrator - Contract

§  Processing GIC applications in PPlus (SIT system)

§  Preparing cheque runs for the GIC maturities

§  Identifying and recommending opportunities to make the deposit administration process more efficient (Excel Charts automatically generated by VBA)

§  Balancing daily transaction activity

§  Updating the Interest Rates in Cannex and checking competitors’ rates changes

§  Processing T2033 Transfer

§  Calling agent to verify information

§  Preparing ICS courrier package to deliver to the agents

§  Assisting managers on project clean ups

 

2008 – 2011             BNP PARIBAS ARBITRAGE (France): Back Office Activity Reporting

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

§  Creation new reports (statement of requirements with data providers and clients, development in VBA for Microsift Access and Excel)

§  Identification, development and implementation of operational efficiencies (automation, monitoring)

§  Extension of the reports’ scope to the Woldwide BackOffice

§  Data manipulation and analysis in some Access Databases

§  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

 

 

      2008                   BPCE ex-CNCE, French Bank (France): Financial modeling

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

 

      2007                   FAPIL, Social Housing Federation (France):

§  Creation of a website with Joomla tools

§  Creation of members database using Excel

Etudes

2007-2008 University Paris Dauphine, Master 104 in Financial Research

Corporate Finance, Financial Analysis and Engineering, Accounting, International Finance and Commodity Derivatives Markets, Econometrics, Computer Science

Master's thesis: « Effects on profitability and volumes when a composition modification occurs in CAC40 »

2005-2007 University Paris Dauphine, Degree in Economics applied to Finance

Microeconomic, Macroeconomic, Portfolio Management, Financial Engineering

4 month Exchange program at the University of Strathclyde, Scotland

2003 - 2004 University Lille 3, a 2-year degree in Mathematics and Economics