Curriculum Vitae – Alicia Scott Page 1 of 3

ALICIA SCOTT

0794 1477781 (m)

a.scott77@blueyonder.co.uk

Nationality: United States of America (permitted to work in UK with indefinite leave to remain)

Formal Qualifications

MSc Computer Science: Web Sciences and Big Data, University of Liverpool

December 2015 – present (ongoing)

I am currently studying for my MSc in Web Science and Big Data, which is an online degree. I am currently approximately

midway through the course, and have achieved my post-graduate certificate. Subjects studied: Computer Structures, Web

Programming, Big Data, Professional Issues in Computing, Cloud Computing.

Prince 2, Practitioner certified July 2008

MSc Computer Science, University of Hertfordshire September 1996 – October 1997

BA English Literature, University of Michigan, Ann Arbor September 1981 - December 1984

Employment

Oct 2012 -

present

Direct Line Group Business Analyst

Business analyst working on the development of a data warehouse and resulting management information for both a claims

transformation project and the implementation of an enterprise-wide insurance suite (with policy, billing and claims modules),

building reports on the SAS and QlikSense platforms for a number of retail insurance brands .

My duties include:

Identification and management of user reporting requirements, including user workshops, interviews, etc., and

documentation of requirements (including functional and non-functional requirements) for a number of business areas,

including underwriting, pricing, marketing, claims, digital, aggregators, etc.

Data and gap analysis, modelling and mapping, including ad hoc SQL analysis using SAS Enterprise Guide

Prototyping and wireframes of report structure, format and content

Provision of subject matter expertise to consultancy to facilitate the modelling and build of a data warehouse and semantic

layer for reporting and analytics

Investigation of the use of SalesForce to replace the current reporting change request application and to map the associated

workflow

Documentation of SQL stored procedures for commercial lines

Jan 2012 –

Aug 2012

Marsh Ltd Business Analyst

Business analyst working within the IT function on a data warehouse/Business Object s (BI/MI) implementation, including data

cleansing and mapping and a migration of current reporting within Hyperion and Crystal Reports to Business Objects. My duties

comprised:

Identification and management of user reporting requirements , including detailed data analysis of current reporting

Working in conjunction with the data architects to produce a logical data model

Production of reporting functional specifications and data mappings from legacy systems to Hyperion views and to data

warehouse logical and physical models

Apr 2011 –

Dec 2011

Navigators Ltd Business Analyst/Quality Assurance Analyst

Business analyst working with the Finance function on a number of projects, including the implementation of additional settle ment

currencies across the underwriting platform of Subscribe, Acumen, Coda and Sun. Acted as liaison between Navigators and third

party supplier of these systems. Performed data analysis/reconciliation via the preparation of SQL scripts and use of Excel pivot

tables and Power Pivots.

Quality assurance analyst on the reporting arm of a Solvency II project, reconciling data warehouse views and source systems for

reporting. My duties included:

Curriculum Vitae – Alicia Scott Page 2 of 3

Maintenance of QA test plan and test scripts and performance of QA testing

Creation, maintenance and use of SQL scripts and stored procedures for reconciliation between source system data, data

warehouse data and views derived from the warehouse to obtain a baseline for the test environment

Creation, maintenance and use of SQL scripts /stored procedures for testing of reference/transaction tables

Aug 2010-

Apr 2011

Amlin Ltd Business Analyst/Workstream Lead

Business analyst/workstream lead on a change management project to set up a new branch for Amlin, and a data warehouse

integration project. My duties included:

Identification and management of requirements for new and current areas of the business , including changes required on

Subscribe, Acumen and Coda (underwriting platform), both in terms of system and configuration changes

Production and maintenance/updates of business, functional and non-functional specifications and other project

documentation (specifications, workflows, training documents, etc.)

Business process modelling and impact analysis of the new Amlin business arm on existing business entities

Stakeholder management and third-party vendor management

Resource management of developers

Production of system and user acceptance test plans/approaches/scripts and support of testing

The projects on which I worked at Amlin were:

The establishment of a new European division of Amlin, including the rollout of the underwriting and financial systems

required for the new division, and integration of the new division into the corporate data warehouse.

Integration of extracts from a new underwriting system into the corporate data warehouse for a UK division of Amlin and

harmonisation of disparate systems into a single data warehouse

Aug 2009-

Jul 2010

Xchanging Ltd Business Analyst

Business analyst for an insurance consultancy specialising in the London insurance market (company and syndicate). Experience with

Company and Lloyds markets claims processing. Projects include the implementation of a new processing system for claims (ECF2)

and a system for the collection of expert fees for claims from carriers.

Responsibilities comprised:

identification, management, prioritisation and documentation of business, functional and non-functional requirements (including

user interviews and market workshops) and co-ordination of cross-functional requirements, using UML production, maintenance and review of other system documentation: project scope documents; process flows; quality assurance

plans and user testing scenarios

presentation of project information to external customers in the form of seminars and market workshops, and system training for

external customers

Jul 2005-

Feb 2009

Trafigura Ltd Business Analyst

Business analyst for commodities company physically trading in oil and non -ferrous concentrates/refined metals. Experience with

front, middle and back office for non-ferrous concentrates business and with swaps and futures processing for oil business. End to end

experience in project lifecycle.

Responsibilities comprised:

Identification, management and documentation of business, functional and non-functional requirements and production of project

artefacts (Rational and UML/use cases)

System testing preparation and performance

Production of management reporting using Business Objects

Production of prototypes for proposed systems, using .NET

Projects included the greenfield implementation of an invoicing module for non -ferrous metals, using trades information to produce

automated invoices. Other projects include the production of automated profit and loss reports , including a financial profit and loss

report for the back office accounts department.

Jan 2002-

Jul 2005

Motability Operations Ltd Business Analyst

Business analyst for fleet management arm of charity that provides motor vehicles for the disabled. End to end experience in project

lifecycle. Duties included:

Curriculum Vitae – Alicia Scott Page 3 of 3

identification, management, prioritisation and documentation of business, functional and non-functional requirements

analysis and production of project artefacts using object oriented techniques and tools (Rational and UML/use cases)

production of management reporting using Business Objects

business process mapping and documentation, including re-engineering of processes

Projects include implementation of a Web-based online customer applications system to replace current manual process, payment co -

ordination project (with the DWP) and development of new customer complaints system. Applications include Java J2EE,

Powerbuilder and Web-based e-commerce systems. Experience of full project life cycle.

Mar 1998-

Dec 2001

CitiGroup N.A. Business Analyst/Project Manager

Technical business analyst/project manager in corporate investment arm of major US bank working with liquid ity management/cash

concentration/zero-balance accounting applications. End to end experience in project lifecycle.

Duties included:

business and functional requirements analysis , management

co-ordination of regional applications and processes to facilitate implementation of systems

co-ordination of inter-regional sub-projects for global rollouts of liquidity management application

Nov 1997 –

Mar 1998

Royal London Asset Management Ltd Business Analyst

Identification and management of business requirements for bespoke deal management system, including gap analysis and vendor

management

Emphasis on RAD/prototyping software development model (DSDM)

Jun 1995 –

Mar 1996

Abbey National General Insurance Project Accountant/Business Analyst

Assisted in the specification, customisation and implementation of a range of insurance applications

Identification of business and functional requirements and production of requirement specifications

Liaison between Finance department and software house during the customisation process

Mar 1989 –

Jun 1995

Various Temporary Accounting Positions

Co-ordination of annual budget production and preparation of monthly management accounts and management reporting ,

including variance analyses of month-end results against budget and maintenance of forecast information

Accounts liaison between a number of intercontinental sites

Software/Computer Language Experience:

Insurance applications/packages: Guidewire Insurance Suite, Subscribe, Eclipse, RMS, ECF2, CLASS (companies and syndicates)

Reporting packages: QlikSense, SAS (Web Reports Studio, Information Map Studio, Data Integration Studio,

Management Console, Enterprise Guide), Business Objects, Crystal Reports, Microstrategy,

Hyperion

Messaging: Lloyds messaging (e.g., SCM)

Finance applications: RFS/Acumen, CODA, Sun Accounts, various cash management systems

Workflow applications: Salesforce (administrator trained), PegaSystems, Metastorm

Programming languages: Microsoft .NET, Visual Basic 6.0, C, C++, Java, COBOL

Other packages/applications: SQL 2005, SQL 2008R2, Microsoft Office (including Access), RoboHelp, Sharepoint,

experience with SWIFT, BACS and CHAPS, MQ Series and XML.

Requirements Management Rational Toolset (Rational Rose and Requisite Pro)

Commodity packages: Faber Mercury (non-ferrous concentrates) and Faber Pluto (oil) end-to-end in house commodity

trading systems

Other qualifications: Lloyds and London Market Introductory Test (LMMIT)

Prince 2 (practitioner certified)

ISEB Certificate – Organisational Context

ISEB Certificate – Business Analysis Essentials

ISEB Certificate – Modelling Business Processes

ISEB Certificate – Requirements Engineering