Alan Ramsay Email & Phone Number

Edinburgh, Scotland, United Kingdom

• Role involved working within Agile project delivery team comprising product owners, PMO and Sapient developers with the following responsibilities involving the outsourcing of Franklin Templeton mutual funds to.
• Creation of data mapping documentation and business requirements gathering to support the receipt of NAV, distribution, yield and regulatory reporting data from JPMorgan and HSBC inbound to FT’s Data Integration layer
• Identification of downstream consumers and defining subscriber system interface requirements, testing and release
• Business process change requirements for target operating and oversight models involving the outsourced funds
• SQL database customization to allow disparate third-party published data inputs to become normalized resulting in reduced oversight requirements for product owners and standardized data sets for consumers

Edinburgh, United Kingdom

• Role involved the analysis of Investment Management, Risk and Performance data generated by the target accounting and performance modules of SimCorp Dimension through a co-ordinated series of systems integration.
• Identifying and reporting data quality issues related to uniqueness, integrity, accuracy, consistency, and completeness
• Managing UAT for data flows between partner systems and comparing data between old and new accounting platform
• Understanding the data flows and needs of risk and attribution systems e.g. FactSet, Barra One and Bloomberg PORT
• Creation of reconciliation tools by developing complex SQL queries to facilitate standardized data comparison formats

Edinburgh, United Kingdom

• Role involved partnering with Compliance, Legal, Back/ Middle office and Technology functions to produce gap analyses, business requirements and project documentation to initially address areas of refinement of MiFID I.
• Completion of MiFIR Transaction Reporting business requirements, baseline solution design, fully tested and deployed January 2018 to achieve regulatory compliance
• Definition of new business process requirements in line with business readiness plan and reporting solution
• Coordinating vendor selection process of Approved Reporting Mechanism for MiFIR Transaction Reporting submission
• Managed end-to-end testing including newly sourced front office, broker, and trading venue data for use within T+1 Transaction Reporting solution

• 3 contract extensionsAs part of a divisional project workstream established under the Group's CRD IV FinRep programme, the role involves the translation of definitions (technical standards) and the related business and.
• Completion of specifications for data sourcing for the divisional business users
• Review of data model, business and process design
• Test preparation and execution
• People side of change
• Implementation support

4 contract extensionsI acted as the point of contact between the Transform Finance programme and the business unit in the implementation of a new Group-wide financial reporting solution to provide Group consolidated accounts including a new Intercompany process alongside the following specific activities:-* Business Unit (BU) user acceptance systems.

Edinburgh, United Kingdom

3 contract extensionsI managed business analysis activities in line with the project schedule with a view to delivering the required quality business solutions within agreed timescales and budget. Key responsibilities:-* Business requirement gathering alongside workshop facilitation * Risk and issue identification and resolution through the RBS governance.

Edinburgh, United Kingdom

• Responsible for leading the iASAP initiative as subject matter expert on behalf of the global Reconciliation teams. Acted as a bridge between the PMO and the business, effectively communicating Cash Processing.
• remove the need for 95% of manual entries to the GL to reduce risk of manual error (approx 245,000 per year)
• Enable straight-through processing of cash settlement activity
• Redesign the cash settlement and reconciliation workflows
• Synchronize cash settlement data between GMAX (portfolio) and CODA (ledger)
• Ensure the end user financial reports were not negatively impactedI was central to the planning and execution of documenting of current business processes, workflows, available data sources, and was used as a go-to.

Bcom, Business Studies

Education record