David Simons

I was taken on at the DMO to design the migration on the trading data from their current SS&C TradeThru system to the FIS Quantum Trading platform. I have been responsible for: · Gathering requirements for the trading migration. · Designing the extract of the trading data from the current platform, the transformation into the format required for the new platform and the load into the new platform. · Designing configuration of Fixed Income, Repo, Currency, Commercial Loans and Commercial Deposit trades in new Quantum system. · Designing mapping of reference data including Counterparty, Profit Centre and Instrument static in new Quantum system · Designing central database to maintain combined history of existing TradeThru and new Quantum trades

At Aldermore Bank I have been responsible for a variety of business analysis projects. These include · Gathering requirements for a migration of their compliance and governance applications to a new Target Operating Model (TOM). · Gathering requirement for a bankwide single customer view database · Analysing various bankwide Know Your Customer (KYC) approaches and recommending a standardised approach to KYC · Analysis GDPR implications on use of Experian credit checks for clients

I joined Santander working on their Liquidity regulatory reporting for their wholesale, commercial and retail business: The overall objective of the project was to complete the necessary liquidity reports to meet the European Banking Authority (EBA) requirements. I have been responsible for the following: · Designing a new Target Operating Model (TOM) to capture the liquidity data from multiple parts of the Santander business. · Designing a decision tree process to determine whether products meet the EBA's High Quality Liquid Asset (HQLA) standards · Designing a haircut process to accurately reflect a realistic value for equity & fixed income product positions within Santander · Designing a number of Additional Liquidity Monitoring Metrics (ALMM) reports for equities, fixed income and derivatives · Designing a number of Liquidity Coverage Ratio (LCR) reports for equities and fixed income · Designing solutions to data quality issues to enable full liquidly reporting to be possible · Designing the ETL processes to extract data from existing Santander systems, transform it as required, and then load it into the liquidity TOM · Mapping Equity, Fixed Income, FX Swap and Interest Rate Derivative data from existing systems to new liquidity database

Having previously worked for Merrill Lynch I returned to the new group as a Business Analyst working in their Wholesale Banking division on the replacement of their commercial client deposits system. BAML have reviewed the market and are currently carrying out an extended study of the Oracle product Flexcube to see if it meets their requirements for a replacement system. I have been responsible for the following: Analysing the functionality of the Flexcube product to identify any gaps between its capabilities and the requirements of BAML. Analysing how the Flexcube product can integrate with existing BAML systems that carry out account pooling. Analysing how the Flexcube product fits into the BAML liquidity structure. Mapping the BAML and Flexcube data to an IFW canonical model. Enhancing the customer data model to support FATCA compliance requirements. Designing data and process models in IBM WebSphere to analyse existing and to be environments Designing the data migration strategy to migrate the various BAML branches onto the Flexcube system

I was at Lloyds on a FATCA regulatory reporting project. FATCA is US legislation requiring foreign financial institutions to report the holdings of all US citizens to the IRS. I have been working as a business analyst designing the target operating model (TOM) that will allow Lloyds to monitor and track the status of US clients. The project has been run in an Agile/SCRUM methodology on a variety of different platforms. I have been responsible for the following: · Analysing and designing mechanisms to look for US Indicia (address, phone, standing order, etc.) in customer details. The mechanisms designed need to integrate with a variety of Lloyd's systems and handle sending requests for information and receiving and processing responses. · Analysing and specifying changes to existing Lloyd's systems to handle collecting additional regulatory information required when on boarding and maintaining commercial customers. · Analysing and specifying a system to follow IRS regulatory rules and carry out automatic classification (according to the IRS defined classification system) of Lloyd's commercial clients.

I returned to Credit Suisse as a business analyst responsible for the bank’s Equity Derivatives flow and risk calculations. Credit Suisse have a derivatives database that collects details of all the bank’s derivatives trades, including financial details such as risk exposure, profit and loss attribution, capital adequacy requirements etc. I have been responsible for the following: Analysing and designing Derivatives P&L Attribution Data regulatory and financial reporting for the FSA CAD II Solvency rules. Analysing and designing Derivatives Approximate Booking regulatory reporting for the FSA CAD II Solvency rules. Analysing and developing (in Excel VBA) a variety of statistical analysis tools to enable Product Control to better understand the derivatives flow within the organisation.

I was taken on by RBS to work in their Equity Derivatives area. RBS have a complex Equity Derivatives suite which they inherited from their acquisition of ABN Amro. They are working on integrating that suite with other existing RBS systems and also making changes to ensure the new system is more robust. My responsibility has been to carry out detailed analysis of the process and data flows between the various RBS systems. The aim of the analysis being to provide a greater understanding of the existing system and present RBS with a more stable target operating model (TOM) for future developments and enhancements.

In my second contract at Deutsche they are delivering a platform to monitor counterparty and trade risk and exposure across a wide variety of their systems. Deutsche already have a risk engine in place but the new system is required to consolidate feeds and information from a variety of new sources. The actual development and analysis for this project is being based in India. Deutsche brought me on board to design and write the guideline documents for this project. The documents I produced detail the overall project vision as to how the feeds will work and the documentation standards that will need to be followed to ensure all requirements are met.

At Credit Suisse I was a business analyst responsible for a major data migration of Private Banking trading data from London to Guernsey. Credit Suisse have different versions of Globus systems in both locations and want to migrate the London equity and fixed income business to the Guernsey system so they can decommission the London system. My role has involved me analysing both existing and target operating models and designing migrations for reference data such as client, account, portfolios, securities etc., and dynamic data such as trades, corporate actions, positions, position transfers etc. I then designed the ETL (Extract, Transform, Load) for the migration. I also worked on planning the actual migration of data and decommissioning of the London system. The actual ETL migration was developed using Microsoft Access so I also had to develop the necessary SQL and VBA to manage the migration and data conversions.

I was taken on by Merrill Lynch as the lead business analyst on a MiFID compliance regulatory reporting project for their Equity Linked Products area. My responsibility has been to design the trade and transaction reporting to the FSA and Irish Regulator for all equity linked products. This includes both cash equities and equity derivative products. The areas I dealt with here include: Transaction reporting to the FSA and Irish Regulator via SWIFT and other messaging Trade Reporting to BOAT Equity Derivatives, Portfolio, Non-Portfolio Swaps, Baskets and Superbaskets FIX messaging between internal systems Designing data migrations to transfer equity derivatives trade flow between systems to allow reporting to occur Running system testing using SQL to compare actual and expected results

I was employed by Golden Source to develop data migration for a client of theirs, the Asset Management House Pioneer Investments. Pioneer Investments will be using the Golden Source to act as a central data repository for trade, positions and reference data. I was responsible for mapping a variety of SQL, XML and fpML data streams from Pioneer Investments systems to the target operating model and designing the ETL (Extract, Transform, Load) for the migration into the Golden Source database. The Types of data I’ve been working with are: Trades, particularly derivatives including Credit Swaps, Interest Rate Swaps and Inflation Swaps. I’ve also dealt with more “vanilla” trades such as Bond, Equity and FX buys and sells. Positions. The positions for all trades needs to be stored in the Golden Source system. I’ve been involved with mapping instrument, derivative and fund positions.

I've been working at Euroclear as a business analyst as part of the team overhauling the SWIFT 15022 (also included some analysis of 20022) based straight through processing message systems at Euroclear. During my time here I've been involved with two specific projects. These are: BRN messaging. These SWIFT MT500 series messages allow counterparties to register changes in security ownership with issuers. The existing system is designed for the French marketplace and I've been responsible for redesigning it to deal with additional requirements from the Dutch and Belgian marketplaces. Corporate Actions. The entire corporate actions messaging mainly using MT560 range messages within Euroclear is being restructured and I've been working on designing the structures necessary to support Entitlement and Announcement messages.

I have been responsible for working with the front office sales community at Barclays Capital as part of a major project to completely re-engineer their systems to develop a new target operating model to support their investment portfolio marketing strategies, and interface the system with the bank’s internal Client Relationship Manager system (CRM). This has involved identifying and working with a number of potential software vendors who could supply part of the solution, and also working with internal teams who are developing the remainder of the solution. My responsibility has been to deliver a complete solution and to do that it has been necessary to identify the true business requirements, determine the best solution for each of those requirements and to design a mechanism to ensure each component works together in an efficient, and to the users, seamless fashion. This project was developed using the Agile/SCRUM methodology.

I have been responsible for analysing and designing a large number of reconciliations to meet the Sarbannes/Oxley SOX regulatory compliance requirements reporting statistical and other data to the Bank of England. In general the reconciliation extracts have been developed in SQL and XML or similar technical toolsets for an Intranet Web based system designed to feed intelliMATCH to carry out the actual reconciliation. The reconciliations developed covered a wide variety of trades mainly in the credit area including Basket Trade, CDS, CLN, IRS Swaptions, FX Spot and Cash Securities. The products being reconciled included Tsar, Summit, Swapswire and a number of Deutsche internal systems.

I was brought on board to temporarily replace someone off long term sick. While at BACS I worked on their new BACSTEL-IP system for payments and credit transfers. I dealt with issues involving new reports, redesigning the automatically generated emails and reviewing the infrastructure balance between Internet and Extranet.

I was responsible for all maintenance projects on the settlements system at BNP Paribas. The settlements system deals with both fixed income, derivatives and equity business and it was my responsibility to deal with both bug fixing and small developments. For developments I was responsible for co-ordinating user requests from a variety of departments (front office, middle office, back office, reference data etc.) and agreeing prioritisation for those requests. I then produced specifications and agreed those with the users involved. I had a team of four technical staff reporting to me and I planned and managed their time, balancing their work between new developments and bug fixing. This was a high-pressure role as, in common with most banking applications, developments need to be implemented quickly to meet changing business requirements. Areas I worked on during my time there included: Compliance and Regulatory Reporting to the SFA and then the FSA Profit and Loss Calculations (particularly with regards to Repos, Sell/Buybacks and Lend Borrows) A variety of Interfaces e.g. Reference data feed from Bloomberg, Trade and Reference data interfaces to Fidessa and Murex, and Financial Instruction interfaces such as TRAX, EUROCLEAR and SWIFT. Corporate Action calculations and problem resolution Reconciliations Instrument Pricing - mark-to-market, average price calculations, and zero day pricing (forward value date adjusted pricing) Designing the ETL (Extract, Transform, Load) for the migration from several BNP systems to the new BNP Paribas systems A wide variety of Fixed Income, Equity, Derivative and Cash Security Products Database investigation using SQL to resolve problems and queries Maintaining Issues Log in Excel and MS Access (including designing and building reporting tool in SQL and VBA)

I worked at Prudential Bache on a three-month contract with responsibility to analyse and plan the transfer of the Emerging Market Clearing Corporation (EMCC) settlement business from Daiwa to Prudential Bache. EMCC deals in a variety of instruments but mainly involves Brady Bonds being traded through a number of brokers. The project involved analysing the existing settlement routes and building a migration path so that they could be mirrored on Prudential Bache’s systems. The settlement processing is being done through Euroclear (75% of trades) and EMCC (25%).

Mentor are a software consultancy and needed me to deal with a client of theirs to review and rebuild their vehicle leasing system. My responsibility was to discuss the system with their users and identify their requirements. I then worked with the users to produce a design for an enhanced system incorporating a variety of new features they needed developed.

I was recruited by Retek to act as an Implementation consultant for their clients. Unfortunately, after completing my training, Retek were forced to make me redundant as a number of anticipated sales have fallen through.

At Synopsys I enhanced and developed the RIMS, a settlements system designed for use by investment banks. I was responsible for include:- Specifying a withholding tax system needed to be used for trades and benefit payments. The system automatically calculated the necessary withholding tax applicable in the county or origin and country of receipt (taking into account any tax agreements applicable between those countries). The system is capable of automatically taking into account whether details passed to it are gross or net of tax. Specifying a corporate actions system to calculate benefits due from Fixed Income and Equities. It automatically caters for long and short positions, as well as those impacted by outstanding repos, buy/sellbacks, failed trades etc. It was also designed to deal with CEDEL and EUROCLEAR automatic compensation requirements. On site at Yamaichi and BZW specifying a cost of carry system to calculate the overnight costs of holding a position. It automatically allocates funding supply received from repos, FX swaps etc. to positions and calculates the cost of funding each position, book by book. It calculates the cost of borrowing by analysing repos including the implications on costs of late settlements on the cost of a repo. The system also catered for the differences in repo costs where substitution of collateral occurs as part of the repo and where benefit payments occur during the life of the repo and are used to offset restitution amounts. On site at ABN Amro specifying a new Gilts system to deal with the new CGO requirements and identifying the key differences between gilt processing and the processing of Fixed Income instruments. It particularly focused on the CGO fungibility issues, and the ability for stripping and reconstituting Gilts. On site at Yamaichi specifying an FX Swaps system. The system allows users to enter an FX Swap as the two trades (bargains) and automatically produces the accrual accounting over the life of the swap.

I worked for British Gas as a Project Leader. While there I was responsible for several projects that were part of British Gas' National Billing System. The project developments were all managed using PRINCE 2, CASE and PMW and developed in SQL and built in PRO*COBOL and FORMS 3.0. The projects I was involved in at British Gas include:- Project leading and analysis of a project to set up new contract types in response to government requirements raised by the MMC. Production of a new data model for meters and meter readings with full entity relationship and attribute details.

Kodak has a search and retrieval system for logging and tracking lost films. I was required to rewrite the specifications and then following signoff rewrote the system converting it from FORTRAN IV to FORTRAN 77. This was a contract assignment taken while looking for a suitable permanent position. Environment: PDP/RSX11M, FORTRAN 77

I joined Hoskyns as a consultant in their Facilities Management division. During my time there I was responsible for a number of project teams working on implementing new batch and on-line systems for Whitbread Breweries and European Cellars who were Hoskyns clients. My responsibilities included all phases of the development from the initial user interviews and feasibility studies, through to producing agreed specifications and then developing and installing the new system. The projects I was involved in were:- Project leading and analysis of an interface system to send marketing information on a daily basis from the European Cellars system to the Whitbread system. Project leading the installation of a sales forecasting package onto European Cellars system. This included designing and building a daily data extract from the European Cellars invoicing and stock control systems and uploading it into the sales forecasting system. Project leading the installation of a distribution resource planning package to interface with the sales forecasting system. Project leading a team providing ongoing support and maintenance of European Cellars statistics packages.

I was responsible for managing and controlling all enhancement requests for EXIMBILLS (EXport IMport, BILLing System), Kapiti's Trade Finance System. The enhancements I worked on include:- Designing an interactive customer liability interface for three Portuguese banks to communicate between EXIMBILLS on a WANG/VS machine and the bank's customer liability system on an IBM CICS machine. Designing a number of enhancements to the way EXIMBILLS handles the SWIFT interface (an International Funds Transfer standard).

This was a contract programming assignment on their stock control system

I joined Space Time Systems as an Analyst Programmer and after having been there for eighteen months I was promoted to Project Manager. As Project Manager I was responsible for managing the development team of nine staff, and the design and implementation of all major development projects. The company provides Theatre Booking software to Theatres and Concert Halls worldwide. I would regularly visit or meet with Theatre Managers and Directors both in the UK and abroad to discuss their future requirements that I would then assess and, if feasible, develop software to solve their problems. During my time as Project Manager the Space Time software was given a Design Council Award by HRH Prince Philip, the first time such an award had been given to a software product.