CV/Mission de Consultant sql server analysis services freelance

Exemple de missions de Michel,
Consultant sql server analysis services habitant Paris (75)

Summary of work experience

Equity Clear COO office 07/2020 – 11/2020
LCH Paris SA.
I was brought in to perform a feasibility study on a LSEG wide initiative that would have LCH SA migrate their
Equity Cash and Equity Derivatives core clearing systems to existing LCH London processes and IT systems.
The final business case demonstrated that the 50M € project would take 6 years to break even but would
deliver substantial business growth opportunities that the existing equity core clearing systems could not. The
business case was approved however strong dependancies and limited capacity meant that the Equity clearing
business line would be the last of business line to be migrated pushing the start of the project to the end of
2021 at the very earliest. Main deliverables included:
• Coordinating analysis work with IT and business teams, drafting of functional requirement specific for
Cash and Derivatives products including all related business processes, incoming / outgoing flows and
technical schemas
• Provide high-level effort breakdown by resource profile and team based in Paris, London and Mumbai
• Draft high level delivery plan with dependancies and critical paths for Equity Cash clearing and Equity
Derivatives clearing businesses
• and set up regular progress update meeting with main business and IT stakeholders in Paris and
London

2 year sabbatical 11/2018 – 07/2020
After 15 years of uninterrupted work I have decided to take time off to spend quality time with family and
friends

Global Equities COO office 04/2013 – 10/2018
HSBC UK London office
Brexit (01/2018 – 10/2018)
The Brexit referendum in the summer of 2016 and the subsequent years of uncertainty presented unique
challenges to HSBC and would require substantial changes to its business model centred on the city of
London. I managed numerous cross-function working groups with themes such as UK vs EU client
segmentation, front office booking model, Operations and Risk functions, Compliance and trade surveillance,
IT system transformation, etc.
We need to review all existing and upcoming financial regulations for both our London office and our
European entities working closely with other asset classes with a front to back approach
• Work closely with local Compliance teams to design and develop communication, education and
guidance material to support and 1st and 2nd line risk practitioners across different business areas
including sales and trading. Review Market conduct and suspicious transaction reporting (STRs)
requirements
• Review strategic Business decisions with regards to relocating trading desks, activities and resources
• Review of all existing regulations from a Front Office, Compliance, Operations, Finance, Risk & IT
perspective
• Drafting functional specifications detailing necessary changes and working with IT to secure resources
and budget
• Applying impacts to Current Operating Models and help document TOM
• Working with compliance, legal and relevant business stakeholders within Wealth Management and other
business functions to ensure the business needs are correctly recognised and understood throughout the
lifecycle of the regulatory initiative.
• Conduct workshops / interviews with Compliance, Legal, client on boarding, credit teams to understand
the current ISDA / CSA create / amend procedures, legal entity on boarding and credit hierarchy of the
legal entities.

Review regulatory papers Ba-Fin, BOE, ESMA, AMF, etc. and participate in weekly or monthly market
forums

Global Equity, MiFID II programme director (10/2015 – 04/2018)
MiFID II Programme director for Global Equities coving all European sites as well as our NY and HK hubs.
Management of senior business BAs and IT leads covering all aspects of the regulation including research
unbundling, systematic internalisers, cost & charges and product manufacturing.
• Coordination of the annual budget exercises covering funding for the Business and IT for Cash Equities,
Structured Equity Derivatives, Equity Finance and Electronic Traded Derivatives.
• Work with HSBC retail and private banking teams on distinct procedures for EU vs non-EU client
• Involved in the e-trading review including new testing requirements, MiFID II kill switch, exception
monitoring tool and additional testing obligations
• Working closely with our sales and independent research teams to adapt MiFID II research unbundling
requirements
• Effectively managing 10 different streams whilst coordinating between senior stakeholders in Sales &
Trading, Compliance, Operations, Finance, Legal, Audit and IT.
• Worked with IT to cover more IT centric changes such as clock sync, ISIN utility and trade and
transaction reporting with field by field mapping exercise from out OMS / PTS downstream to our
centralised reporting utility
• Work with surveillance team in order to enhance FO trading surveillance models including setting up
official governance forums
• Engaged with the structured product desk to implement product manufacturing guidelines including client
feed-back loop
• Participate in industry forums & engage with our external legal advisor on specific legal / compliance
topics
• Review KYC document and process and due diligence checks for onboarding purposes and supporting
migration of clients to new document controls systems
• Liaise with legal team and refer to the ISDA document to understand the fund structure (type of
relationship wit the bank – agency vs principal for MiFID II reportable funds. Validate the findings with the
relationship manager
• Conduct workshops / interviews with Compliance, Legal, client on boarding, credit teams to understand
the current ISDA / CSA create / amend procedures, legal entity on boarding and credit hierarchy of the
legal entities.
• Involved in internal audits regarding electronic trading platforms and algorithmic strategies.
• Attending industry & vendor forums, socialising & communicating for industry forums the requirements to
understand impacts, risks & issues

Global Equity, Regulatory Change manager (04/2013 – 10/2015)
Global front office regulatory change lead reporting to the Global COO based in London coordinating all
regulatory change projects across jurisdictions including Margin Requirements for Uncleared Derivatives
(MRUD), EMIR, Dodd Frank, 871m, Italian transaction tax, etc.
The role involved managing key stakeholders (Front, Middle and Back Office) to ensure accuracy of issues
that have either been self reported or highlighted by GTR / regulators, delivering BRD / functional
specifications and test cases
• Established governance framework including engaging with executive sponsors, identifying key
stakeholders, chairing steering committees, etc
• Involved in a regulatory and cross border project ensuring business activities are conducted both in
accordance with current regulations and the risk appetite of senior management
• Conduct interviews and workshops with stakeholders involving compliance, trade management, legal,
client onboarding and collateral management teams to understand business rules and document current
data flow

Review and improve control levels as outlines by group Compliance as stipulated by regulatory
framework such as EMIR and MIFID I, MAD/ MAR, Volcker and DFA
• Improve systems / reports showing trade surveillance, market abuse, trader mandate details, trade mark
up alerting, order entry , suspicious behaviour, cancel correct & amends, etc.
• Secured funding, produced project charter, business strategy with a phased delivery based on IT
capacity and system delivery limitations
• Implementation of new booking methodology for the DFA Swap Execution Facility (SEFs)
• Successfully helped implement a per-trade reference tool allowing sales & traders to identify the
regulatory implications by product and by client-type
• MRUD / BCBS 239 margin requirements for non-centrally cleared OTC derivative by sept 1 2016. The
collateral desk should be able to meet all margin calls in compliance with the new regulations post go
live. Maintain a dashboard to provide visibility to top management and stakeholders in regards to project
status, RAID items, bottlenecks and margins.
• MiFID II portfolio compression requirements : conduct a review of the MiFIR and draft level 2 directive for
portfolio compression together with gap analysis with regards to other regulations. This included
designing process flows for the existing procedure undertaken.
• Acted as contact for the Bank within industry working group for Portfolio Compression. Liaised with
Compliance to produce a list of open clarification points to submit to the working group for EU
confirmation following publications for final act.

Equity COO office, Business management 10/2010 – 04/2013
HSBC Bank plc ( 10/2015 Hong Kong - PRESENT & London )
Equity Business Management working on a Front to Back transformational project in Hong Kong before
taking up a roll of Equity Sales Business Management in London. Review of our controls with improved
monitoring of our Business KPI. The Front to Back Harmonization project had as objective to align
processes across Equity products and across our hubs (NY, HK, London and Paris). 75% of procedures for
Front Office trading, booking, P&L reconciliations and Middle Office trade confirmation were standardised
resulting a substantial decrease in breaks, mismatches and manual interventions. The overall IT
infrastructure was simplified with the replacement of tactical applications & workflows by global applications
resulting in the decommissioning of hundreds of excel macros & 4 legacy platforms. These improvements
allowed for the reallocations of 6 FTEs to business critical tasks
• Involved in the implementation of new controls and strengthening of existing controls / procedures with
the objective of reducing operation losses YoY
• Invo...