Alan Ramsay Email and Phone Number
Alan Ramsay work email
- Valid
Alan Ramsay personal email
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
Almis International Ltd
View- Website:
- almis.co.uk
- Employees:
- 23
-
Senior Financial Systems AnalystAlmis International Ltd Feb 2021 - Present -
Business Systems AnalystFranklin Templeton Jul 2019 - Oct 2020Edinburgh, Scotland, United KingdomRole 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 -
Investment And Risk Data Analyst - Simcorp Dimension ImplementationFranklin Templeton May 2018 - Jul 2019Edinburgh, United KingdomRole 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 -
Business Analyst - Mifid IiFranklin Templeton Feb 2015 - May 2018Edinburgh, United KingdomRole 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 -
Paternity LeaveHome Jan 2015 - Feb 2015
-
Business Analyst - Finrep Crd Iv Harmonised ReportingLloyds Banking Group Oct 2013 - Jan 20153 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 -
Divisional Programme Analyst - Sap Business Financial ConsolidationLloyds Banking Group May 2012 - Sep 20134 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 -
Business Change Analyst - FirstRoyal Bank Of Scotland Business Mar 2011 - May 2012Edinburgh, United Kingdom3 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. -
Business Analyst - Investment Accounting Systems Advancement ProgramFranklin Templeton Investments Jun 2010 - May 2011Edinburgh, United KingdomResponsible 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 -
SupervisorFranklin Templeton Investments May 2009 - Jun 2010
Alan Ramsay Skills
Alan Ramsay Education Details
-
Business Studies -
Hutcheson'S Grammar School
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 PlanningPrestonpans3aramsay.co.uk, apexdistribution.com, apexdistribution.com -
Alan Ramsay
Milton Keynes3bcs.org, willmottdixon.co.uk, interserve.com5 +447956XXXXXX
-
ALAN RAMSAY
Managing Director ✮ Audience Engagement Specialist ✮ Experienced Corporate Communicator ✮ Digital And Print ✮ GlobalPaisley -
Alan Ramsay
Greater Cambridge Area1allianz.co.uk
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial