Business analyst for migration of on-premise business applications and databases to AWS cloud, coordinating with offshore development and test teams.Analysis across the end-to-end business processes, preparing use cases, functional specifications and other design artefacts.Non-functional requirements and impact analysis workshops including performance, business continuity, security and legacy decommissioning requirements. Defined requirements for Access Control models in Active Directory and Service Now.Reviewed test artefacts against requirements, contributing to test strategies. Worked with project managers to facilitate  business user testing and achieve sign off for go-live.Governance documents, service models, security controls and service desk documents.

Analysis and data modelling for Specsavers global supply chains for supplier spend reporting. Scope included product purchases of contact lenses, spectacle frames and all direct purchases by retail stores. Requirements gathering for data ingestion & transformation for business reporting in Power BI.Mapped supply chain processes, distribution systems and product data through stakeholder interviews and discovery sessions. Documented requirements and context diagrams in Miro and Confluence.  Analysis tasks and user stories added to the Jira backlog for development.Data analysis using Azure Databricks, writing SQL queries, joining across schemas to define data mapping, data models and business rules for implementation. Imported data to Power BI, building a reporting data model and transformation of data in the query editor for analysis, producing draft visualisations to test the extraction logic.Through regular show & tell sessions, reviewed data extracts with subject matter experts. Reconciled mapped data with business reports to verify accuracy and completeness. Profiled spend data and presented summaries, facilitating steering sessions with senior stakeholders.Working with other business analysts, solution architects and modellers, supported logical and physical modelling into a common data model for all Specsavers supplier spend data.

Data migration for transition of  car insurance from legacy to a new strategic partner for 650,000 customer base. Mapped data attributes from operational and legacy customer, policy and vehicle databases to the target policy systems. Produced detailed data contract specifications to define migration extract files that aligned to future state policy API specifications.Validated data migration scope through scenario mapping and use case analysis. Derived business rules from stakeholder workshops and as-is and to-be process maps.Conceptual data model and entity relationship model in draw.io. Aligned data models across legacy and target systems.Delivered successful migration data sets as part of a collaborative scrum team through a series of agile iterations.Insight data delivery for replacement of a lease car remarketing e-commerce site. Site used by nationwide car dealers & networks purchasing 200,000 vehicles per year. Worked with MI product owner to elaborate business requirements as Jira epics, working from Miro boards and UI wireframes. Analysed the UI and user roles to ensure event data definitions could describe dealer purchasing behaviour. Analysed vehicle remarketing Oracle databases using DBeaver to identify enrichment event data.Facilitated workshops to describe as-is business reporting and performed gap analysis between legacy site Google Analytics and to-be UI  events data.Created a user story map structuring user stories within each epic to deliver data from the front-end, through Kafka, to Oracle database for consolidation in Snowflake. Aligned requirements for UI event data with Google Analytics 4 implementation.

Managed a team of 14 business analysts. Created a team structure to align individuals’ skills and product knowledge with business portfolios. Coaching and mentoring of business analysts developing in the role.Senior business analyst for projects including: - Marketing system integrating Adobe, Azure and Snowflake cloud services. Requirements management using Jira.- Pay by mile insurance product with detailed acceptance criteria to integrate COTS systems including iOS & Android apps and policy management systems. UX/UI development, FCA and GDPR compliance. Marketing systems data integration. Formal review and sign-off process for phased delivery.- Scoped FCA compliance changes to insurance products, facilitating workshops to define programme workstreams.

Project scoping for new propositions including Connected Car, Usage Based Insurance, Fleet and Lease vehicle management.Delivered several major projects in an agile scrum team. Projects included process automations, new Telematics iOS & Android apps, new APIs and Azure cloud service implementations.Creating and refining user stories, leading backlog refinement, prioritisation, and supporting daily stand-ups. Functional and non-functional requirements definitions, wireframes and data specifications.As product owner, managed the product backlog in Jira and facilitated 3 amigos sessions and stakeholder interviews to elicit business requirements. Defined customer journeys and conducted system & process impact assessments, gap analysis and epic/user story definitions. Detailed product documentation and data catalogue in Confluence.Mapped end to end as-is and to-be business processes in Visio for technical and operational solutions to business problems.

Business analysis for a new SaaS contract management system using use case definitions, personas, epic/user story descriptions. Also supported user testing, sales and marketing activities.ISO27001 information security system implementation and management.Managed public sector procurement tenders totalling £1m per annum for specialist creative and consultant services.Procurement policy/compliance advice and supplier database maintenance. Contract Management for NHS delivery partner sales contracts.

Owner of a retail business with turnover £3-500k/annum. Prepared business plans and management accounts while operating strict financial controls and detailed cash-flow forecasting. Reduced costs by 30% over a two year period by changing working practices, implementing efficiencies and supplier price negotiations.Involved in all areas of the business including:Sales with an approachable manner and negotiation of final priceCustomer service and after-care, including visiting customer homesMarketing with radio, print media and sale eventsProduct sourcing, managing relationships with agents and international supply chains.

Business analyst/project manager for a new tender management system including a comprehensive cost reduction knowledge base. Managed a project team of 10 engineers and content writers to product release and customer trials.Managing consultant for cost reduction projects, reviewing costs and business processes. Small/medium sized enterprises and public sector organisations including museums, councils and housing associations.Managed consultant teams to implement business change strategies and new supplier relationships.Conducted business reviews involving:Reviews of management accountsBusiness process mappingPreparing cost models and benchmarksDetailing reports and providing presentationsPreparing request for tender documents (including OJEU tenders)

Lead business process consultant for the business model and operational processes in a proposed UK-wide Road User Charging specification. Developed a framework business model to account fully for issues including payment services, financial risk sharing, data protection, road user privacy, fraud prevention & enforcement, and system security. Project manager for out-sourced development of an On-Road Service Provider system (contract value £1.4m) within a PRINCE 2 project environment. Co-ordinated successful systems integration; facilitating workshops between 5 project suppliers.