Nicolas B.
Finance Process Optimisation Analyst, Constellium France
Nicolas is an analytical and market-savvy graduate, with a strong passion for the financial markets. He worked for four banks in France in retail, commercial, private and investment banking(equities and derivatives desks) and has international experience in France, Australia and China.
Skills & Attributes
-Numerate and analytical: strong mathematical and quantitative abilities. Proficient in dealing with large amount of information and delivering the keys information.
-Financial and risk modelling: able to build models using Excel and VBA.
-Self-learner and adaptable: quickly grasp new concepts and adapt to changing and fast paced-environments and tasks.
-communication skills: Able to explain and communicate clearly. Experience dealing with IT, front offices, clients and regulatory.
Speaks fluently French, English and Spanish(conversational fluently).
Currently working on back testing and modelling(Excel VBA) of technical analysis trading strategies.
Specialties
Financial Modelling in Excel.
Risk assessment. Risk Modelling.
VBA. Excel(functions, Vlookup, pivot table, analysis toolpak...).
Financial instruments.
Organisation, strategy and processes.
48 contacts2011 - 2011The market intelligence team provides data and support to the marketing and management teams to develop the international strategies (Short and medium terms).
Tasks:
Market segment studies: statistical analysis on International students.
Provided data and reports to the Marketing team and Vice Dean.
Developed tools in VBA in order to improve reporting by 40% of time.
Achievements: Quantitative analysis of the top 10 universities in Australia. The data served to develop medium term strategies.
2008 - 2009I worked on different projects for Societe Generale. I was involved in the modelling and review of the processes after the rogue trader scandal(loss of 5billions euros).
This review decreased the number of processes from more than 250 to about 160. This diminution was done by grouping some processes together and developing the processes in STP(Straight to Process) vision. Doing so, the processes were to be done by the correct departments with the correct tools.
For this project, I developed two programs on VBA/Excel that decreases the time of review of the managers by 40%.
I also worked on controlling the trader's assistants tasks on daily basis.
Finally, I was involved in risk projects for collecting operational losses and searching for action plans to avoid any further losses.
2007 - 2007Assisted portfolio managers in their day-to-day tasks.
Followed and reported weekly performance.
Analysed the compliance on settlement for the accounts.
Analysed daily data from the markets and databases.
Achievements: Set up reporting and Key Performance Indicators in order to analyse daily returns in relation to the risk of the portfolios. Provided gains in efficiency and presentation of the results.
2003 - 2010Followed more than 50 students in 7 years.
Created my own courses and exercises.
Prepared students to Business School tests.