avatar

Business analyst

Score
100%
Experience:
15 y
Score
100%
Experience:
15 y
Location:
8002 Zürich
Last update:
20.04.2021
Register to Contact Freelancer
Available
Onsite hourly: N/A
Remote hourly: N/A
Spanish: Native
German: Near native
French: Native
English: Near native
SKILLS
Stephane ANDRIEUX
Mutschellenstr. 39
8002 Zürich
Tel. : +41 (0) 763 44 92 91
Email: andrieuxs@gmail.com
Age: 34
Nationality: French pass
CH residency permit C
 
 
 
 
 
 
 
 
 
Business Analyst
 
 
 
Through my 9 years+ experience in the financial industry (Private Banking and Fund Administration), I have learnt to tackle the issues with a professional attitude.
I invest the necessary time to understand the root of a problem before I start fixing it. This approach allows me to provide efficient solutions.
My progress of work can be tracked and the key elements of my topics are properly documented.
I am curious about process and system changes and remain analytical and calm when I need to face new challenges. This helps me to be self-motivated, proactive and a good problem solver.
 
 
 

 
Languages
  • French : Native
  • Spanish : Fluent
  • English : Professional proficiency
  • German: Medium
  • Schweizer Deutsch (40%)
  • Italian: Basic
 
Skills
Bank:
 
  • Private banking – Fund administration
  • Capital and Market transactions
  • Portfolio valuation (Pricing)
  • FX contracts
  • Multi-currencies portfolios
  • Corporate actions
  • Taxes (Swiss TIS, European TIS, Withholding Tax)
  • Reconciliation (Cash and Portfolios)
  • Precious metals
 
Specialities
 
  • MiFID II level 2 regulation (ex-post client reporting)
  • Swiss equalization (Quellensteuer)
Data base Static data Sql Data Warehouses VBA Jira SAP Business raw data
01.06.2015 — 31.01.2016
Julius Bär
Business Analyst
* Responsible for the client reporting ex-post (post trading) regulatory amendments * Analysis of the regulatory pages (around 100 requirements) * Talks with lawyers to align the understanding of the directive * Definition of the gaps (back office reporting team, ITs, business owners) * Cost estimations (3 MCHF +) * Definition of the requirements (JIRA)
01.12.2014 — 31.05.2015
Royal bank of Canada Investor & Treasury services - RBCIS
Business analyst
* Development of a VBA macro that allows to book automatically future transactions * Revised a VBA macro that allows to book automatically dividend reinvestment transactions * Review of fund managers' signature list and update of a VBA signature tool (Transaction management)
01.10.2014 — 30.11.2014
Julius Bär Zürich
Business Analyst (GDRP project)
* MIC codes equivalence table as per the ESMA requirement * Add reporting fields for OTC products * New format requirement for Unique identifier code
01.11.2010 — 30.09.2014
Royal bank of Canada Investor & Treasury services - RBCIS
Business Analyst
* Review the automated withholding tax on income and capital gain automated accrual on BR, CH, TH securities * Review of the tax mapping (45,000 set up possibilities) which allowed to automatically calculate the Swiss, German and European equalization at capital transaction time. This was done in collaboration with static data and tax experts * Reporting specifications of tax figures to the auditors, FINMA and SNB * Review the static data of the links within the legal entities sub-accounts * Reorganize the stale price due diligence verification process with the pricing teams, security master teams, fund managers, portfolios owners
01.01.2010 — 31.10.2010
BNP Paribas
Consultant
* Write 250,000 rows of flat .csv file for complex legal entities & securities static data creation, for a scenario of common trade activity and pricing. Structure to be replicated to make a stress test on a new server * Write specification to create new exception price report (stale prices)
01.01.2007 — 31.05.2009
Igefi - Multifonds
Consultant
* Supporting different global leading investment banks: * Static data set up (legal entities, securities, counterparties, pricing methodologies, equivalence tables with the 3rd parties, reporting......) * Flat files interfaces (for static data creation, trade loading, portfolio - equities, bonds, futures, options, FX and FS contractspricing, exchange rate updates...) * Swift messages (Cash and portfolio reconciliation...) * Data base queries * Requirement engineer: * Receive Business requirement documents from the client. * Analyze the existing possibilities on the system and/or raise specification to the development team for development and implementation with definition of costs * Consultant: * Experience of 5 months at ING den Haag premises for the implementation of a Pricing module for Asian equities (Market and quality codes specific)
01.01.2006 — 31.12.2006
State Street Bank
Account controller
* Complete fund cycle evaluation control (transactions, Pricing, custody and FA reconciliation, taxe calculations, Reporting, Bloomberg checks)

Description

SKILLS
Stephane ANDRIEUX
Mutschellenstr. 39
8002 Zürich
Tel. : +41 (0) 763 44 92 91
Email: andrieuxs@gmail.com
Age: 34
Nationality: French pass
CH residency permit C
 
 
 
 
 
 
 
 
 
Business Analyst
 
 
 
Through my 9 years+ experience in the financial industry (Private Banking and Fund Administration), I have learnt to tackle the issues with a professional attitude.
I invest the necessary time to understand the root of a problem before I start fixing it. This approach allows me to provide efficient solutions.
My progress of work can be tracked and the key elements of my topics are properly documented.
I am curious about process and system changes and remain analytical and calm when I need to face new challenges. This helps me to be self-motivated, proactive and a good problem solver.
 
 
 

 
Languages
  • French : Native
  • Spanish : Fluent
  • English : Professional proficiency
  • German: Medium
  • Schweizer Deutsch (40%)
  • Italian: Basic
 
Skills
Bank:
 
  • Private banking – Fund administration
  • Capital and Market transactions
  • Portfolio valuation (Pricing)
  • FX contracts
  • Multi-currencies portfolios
  • Corporate actions
  • Taxes (Swiss TIS, European TIS, Withholding Tax)
  • Reconciliation (Cash and Portfolios)
  • Precious metals
 
Specialities
 
  • MiFID II level 2 regulation (ex-post client reporting)
  • Swiss equalization (Quellensteuer)

Main Skills

Other Skills

Data base Static data Sql Data Warehouses VBA Jira SAP Business raw data

Work & Experience

01.06.2015 — 31.01.2016
Julius Bär
Business Analyst
* Responsible for the client reporting ex-post (post trading) regulatory amendments * Analysis of the regulatory pages (around 100 requirements) * Talks with lawyers to align the understanding of the directive * Definition of the gaps (back office reporting team, ITs, business owners) * Cost estimations (3 MCHF +) * Definition of the requirements (JIRA)
01.12.2014 — 31.05.2015
Royal bank of Canada Investor & Treasury services - RBCIS
Business analyst
* Development of a VBA macro that allows to book automatically future transactions * Revised a VBA macro that allows to book automatically dividend reinvestment transactions * Review of fund managers' signature list and update of a VBA signature tool (Transaction management)
01.10.2014 — 30.11.2014
Julius Bär Zürich
Business Analyst (GDRP project)
* MIC codes equivalence table as per the ESMA requirement * Add reporting fields for OTC products * New format requirement for Unique identifier code
01.11.2010 — 30.09.2014
Royal bank of Canada Investor & Treasury services - RBCIS
Business Analyst
* Review the automated withholding tax on income and capital gain automated accrual on BR, CH, TH securities * Review of the tax mapping (45,000 set up possibilities) which allowed to automatically calculate the Swiss, German and European equalization at capital transaction time. This was done in collaboration with static data and tax experts * Reporting specifications of tax figures to the auditors, FINMA and SNB * Review the static data of the links within the legal entities sub-accounts * Reorganize the stale price due diligence verification process with the pricing teams, security master teams, fund managers, portfolios owners
01.01.2010 — 31.10.2010
BNP Paribas
Consultant
* Write 250,000 rows of flat .csv file for complex legal entities & securities static data creation, for a scenario of common trade activity and pricing. Structure to be replicated to make a stress test on a new server * Write specification to create new exception price report (stale prices)
01.01.2007 — 31.05.2009
Igefi - Multifonds
Consultant
* Supporting different global leading investment banks: * Static data set up (legal entities, securities, counterparties, pricing methodologies, equivalence tables with the 3rd parties, reporting......) * Flat files interfaces (for static data creation, trade loading, portfolio - equities, bonds, futures, options, FX and FS contractspricing, exchange rate updates...) * Swift messages (Cash and portfolio reconciliation...) * Data base queries * Requirement engineer: * Receive Business requirement documents from the client. * Analyze the existing possibilities on the system and/or raise specification to the development team for development and implementation with definition of costs * Consultant: * Experience of 5 months at ING den Haag premises for the implementation of a Pricing module for Asian equities (Market and quality codes specific)
01.01.2006 — 31.12.2006
State Street Bank
Account controller
* Complete fund cycle evaluation control (transactions, Pricing, custody and FA reconciliation, taxe calculations, Reporting, Bloomberg checks)

Attachments