CV/Mission de Consultant sql server analysis services freelance

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

• Equity Clear COO office LCH Paris SA.
  Jan 2020 - Jan 2020

  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

• sabbatical
  Jan 2018 - Jan 2020

  After 15 years of uninterrupted work I have decided to take time off to spend quality time with family and
  friends

• MiFID II programme director

  Global Equity,
  Jan 2015 - Jan 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 Equities COO office HSBC UK London office Brexit
  Jan 2013 - Jan 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

• Regulatory Change manager

  Global Equity,
  Jan 2013 - Jan 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 managementHSBC Bank plc
  Jan 2010 - Jan 2013

  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...