Alan Ramsay

Alan Ramsay Email and Phone Number

Business Analyst | Data & Systems | Regulatory Reporting | Investment Accounting | SQL @ ALMIS International Ltd
carrington, midlothian, united kingdom
Alan Ramsay's Location
Edinburgh, Scotland, United Kingdom, United Kingdom
Alan Ramsay's Contact Details

Alan Ramsay work email

Alan Ramsay personal email

n/a
About Alan Ramsay

Self-motivated and determined business, testing and PMO analyst with over 10 years of experience. A proven track record of successfully supporting, driving, and delivering large and complex business and IT change with considerable accuracy in the analysis, reporting and delivery of time sensitive informationExtensive business, testing and PMO analysis experience across the full project lifecycle (Agile and Waterfall) Experience to all levels in managing and influencing business, technology, and third-party stakeholder relationshipsRequirements elicitation, definition and documentation written simply and clearly to allow full traceabilityA motivated and approachable team player who can focus, coordinate, influence and manage to ensure results are delivered according to cost, quality and deadline

Alan Ramsay's Current Company Details
ALMIS International Ltd

Almis International Ltd

View
Business Analyst | Data & Systems | Regulatory Reporting | Investment Accounting | SQL
carrington, midlothian, united kingdom
Website:
almis.co.uk
Employees:
23
Alan Ramsay Work Experience Details
  • Almis International Ltd
    Senior Financial Systems Analyst
    Almis International Ltd Feb 2021 - Present
  • Franklin Templeton
    Business Systems Analyst
    Franklin Templeton Jul 2019 - Oct 2020
    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 third-party fund administrators:• 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
  • Franklin Templeton
    Investment And Risk Data Analyst - Simcorp Dimension Implementation
    Franklin Templeton May 2018 - Jul 2019
    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 testing waves. Responsibilities included:• 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
  • Franklin Templeton
    Business Analyst - Mifid Ii
    Franklin Templeton Feb 2015 - May 2018
    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 transaction reporting in addition to delivering MiFIR transaction Reporting practices in line with the FCA and ESMA guidance. Role involved:• 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
  • Home
    Paternity Leave
    Home Jan 2015 - Feb 2015
  • Lloyds Banking Group
    Business Analyst - Finrep Crd Iv Harmonised Reporting
    Lloyds Banking Group Oct 2013 - Jan 2015
    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 IT changes to develop FinRep reporting in line with European Banking Authority requirements and timelines. Role has the following responsibilities• 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
  • Lloyds Banking Group
    Divisional Programme Analyst - Sap Business Financial Consolidation
    Lloyds Banking Group May 2012 - Sep 2013
    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 testing including 2 practical cycles, then parallel and dry run activities for management and statutory reporting periods* Defect and regression testing of SAP BFC tool alongside new reporting unit structures, rationalised ledger account mappings and a new data model to support monthly and quarterly returns* Support for several BUs within the Wealth and International division in the preparation of project related deliverables including management of key stakeholders with respect to programme activities* Understanding and documenting each local impact of the new reporting environment; assessing the issues and gaps and proposing the interim and to-be process changes* Facilitating the identification, tracking and resolution of divisional risks and issues with respect to the programme
  • Royal Bank Of Scotland Business
    Business Change Analyst - First
    Royal Bank Of Scotland Business Mar 2011 - May 2012
    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 forums * Process mapping to include full end-to-end ERP * Raise and escalate impact and gap analysis issues as well as scenario planning * Providing details and business justification to any CEMLI custom extensions * Production and ownership of a full set of Oracle Unified Method documentation to provide completeness for traceability and auditability purposesI 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.
  • Franklin Templeton Investments
    Business Analyst - Investment Accounting Systems Advancement Program
    Franklin Templeton Investments Jun 2010 - May 2011
    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 requirements ultimately to be able to:•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 resource for system and accounting input. Identified and documented the functional/non-functional business requirements as determined by eliciting and managing every jurisdiction’s stakeholder needs alongside various systems based constraints. This facilitated enormous opportunities to improve long established manual “stop-gap” or semi-automated processes, as well as laying foundations for design of potential solutions.Review and walk-through of business requirements with project and technology teams, ensuring all concern areas are challenged and resolved for sign-off after alternative solutions offered and received.Analysis of System Delivery Specification documentation providing direct traceability back to SRA documents, with several feedback discussions leading to iterative revisions of SDS documents. I managed current tactical & operational (production) tools to ensure they are robust for reporting through continuous improvement. Review and update procedures and policies to ensure best practice and adequacy for compliance with internal controls and regulatory requirements
  • Franklin Templeton Investments
    Supervisor
    Franklin Templeton Investments May 2009 - Jun 2010

Alan Ramsay Skills

Business Analysis Requirements Gathering Requirements Analysis Gap Analysis Attention To Detail Stakeholder Management Process Mapping Business Process Mapping Business Requirements Pmo Business Intelligence Business Process Analysis Change Management Project Planning Governance Financial Services Management

Alan Ramsay Education Details

Frequently Asked Questions about Alan Ramsay

What company does Alan Ramsay work for?

Alan Ramsay works for Almis International Ltd

What is Alan Ramsay's role at the current company?

Alan Ramsay's current role is Business Analyst | Data & Systems | Regulatory Reporting | Investment Accounting | SQL.

What is Alan Ramsay's email address?

Alan Ramsay's email address is al****@****o.co.uk

What schools did Alan Ramsay attend?

Alan Ramsay attended The University Of Edinburgh, Hutcheson's Grammar School.

What skills is Alan Ramsay known for?

Alan Ramsay has skills like Business Analysis, Requirements Gathering, Requirements Analysis, Gap Analysis, Attention To Detail, Stakeholder Management, Process Mapping, Business Process Mapping, Business Requirements, Pmo, Business Intelligence, Business Process.

Who are Alan Ramsay's colleagues?

Alan Ramsay's colleagues are Cameron Whyte, Callum Lewis-Smith, Martin Pritchard, Anna Dawidowska, Amy Galley, Neil Irvine-Hess, Abdulaziz Sadi.

Not the Alan Ramsay you were looking for?

  • Alan Ramsay

    Digital Strategy Manager | Software Engineer @ Mi:Rna Diagnostics | Software Development | Digital Strategy | Team Leadership | Data-Driven Solutions | Technology Integration | Strategic Planning
    Prestonpans
    3
    aramsay.co.uk, apexdistribution.com, apexdistribution.com
  • Alan Ramsay

    Milton Keynes
    3
    bcs.org, willmottdixon.co.uk, interserve.com

    5 +447956XXXXXX

  • ALAN RAMSAY

    Managing Director ✮ Audience Engagement Specialist ✮ Experienced Corporate Communicator ✮ Digital And Print ✮ Global
    Paisley
  • Alan Ramsay

    Greater Cambridge Area
    1
    allianz.co.uk

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.