Senior Technical Product Manager

• Dec 2022 - Present

Technical Product Manager

• Jun 2021 - Nov 2022

Senior Business Data Analyst

• Mar 2020 - Mar 2022

- Developed a conceptual data model containing all data attributes and entities from 12 products, accounts and prices across multiple workshops with stakeholders, maintaining their engagement and enthusiasm throughout- Ensuring that both the project and final deliverables maintains compliance with all appropriate regulation including GDPR, IDD etc. by liasing closely with both Data Governance team and Data Protection Office and ensuring appropriate documentation such as privacy impact assessments, due diligence sign-offs are regularly reviewed and updated when required- Collaborating with Data Quality team to define standards for new data feeds to be ingested into the new data platform that can then be implemented in AVRO schemas (and further validation services) to ensure that data can be safely used in downstream applications, reports etc.- Supervising and mentoring a junior graduate BA working on the new platform project- Identifying stores of historic data that could be used to backfill the platform, analysing the risks and rewards of each store and bringing stakeholders to consensus over the preferred store- Defining & documenting the mappings of data fields from raw json events & reference data to support a new logical data model by analyzing code in GitHub & data within both Amazon S3 (using Amazon Athena) & Amazon Redshift- Leading a workstream to identify BA interests, RACI, definitions of good etc. and inputting them into the programme of changes to the tech departments operating model- Promoting team cohesion by organising and running an afternoon of ‘Among Us’- Developing and running the technical assessment section of Data BA interviews Show less

Business Analyst For Security

• Jul 2018 - Mar 2020

- Managed high-level stakeholders from multiple groups, both within the company & within the parent company, due to shared responsibility & accountability across both companies for CtMs security- Analysed the impact of new security initiatives on the customer experiences by both calculating theoretical effect of additional load on time taken to serve customers & working with engineering teams to test actual impact- Audited in-use application usage & published a white paper to Security & Data Governance groups with the security implications- Took over scrum master responsibilities for the DevOps team such as running & adding rigour to stand-ups, sprint plannings, story refinements & other agile ceremonies as well as re-defining the DevOps workflow management- Defined release management process for unscheduled changes / releases in compliance with auditors requirements- Ran multi-team (40+ people), multi-day inceptions & follow-on workshops- Coached a fellow BA through their first multi-team inception & will be mentoring a graduate BA from September 2019- Ran security workshops to define the security requirements for other initiatives- Defined & documented the mappings of data fields from raw events & reference data to support email campaigns in the new SalesForce marketing solution by analyzing code in GitHub & data within both S3 (using Athena) & Redshift- Supported the on-prem database migration to AWS by identifying all databases in the operational estate that are in-scope & working with the teams affected to determine timelines for each migration - Have been involved in multiple charity & community endeavours including building an Alexa skill, using AWS Lambda, for the BGL STEM festival exhibit in 2019 & manning the exhibit for both days in 2018 Show less

Business Data Analyst

• Oct 2015 - Jul 2018

- Defined the ETL to migrate the CRM system RedPoint from legacy Hadoop database to target Redshift database- Supported the journey upgrade programme by helping the product teams define json schemas for the new journey events & defining the mapping of this raw data into legacy SQL Server databases to maintain existing datasets & reporting as well as into the new target Redshift database- Provided support to the business by investigating & providing data in response to ad-hoc queries from the engineering teams, the relationship managers on behalf of the insurance providers & other business areas by querying the data in both legacy & current databases & other stores such as S3 - Defined the work required for the Data Estate to be GDPR compliant inc working with the product engineering department to implement both the retention & deletion requirements on the operational estate Show less

Data Onboarding Specialist

• Oct 2014 - Oct 2015

I created custom models from disparate data sources & multiple platforms to support analytics & customer loyalty programmes for multiple clients that were used for driving digital marketing campaigns primarily through email communication. I created custom models from disparate data sources & multiple platforms to support analytics & customer loyalty programmes for multiple clients that were used for driving digital marketing campaigns primarily through email communication.

Data Analyst

• Jun 2012 - Oct 2014

I worked as a Project and BAU Data Analyst and profile data from multiple financial sources, including 2 separate card processors using SQL Server and Oracle. I have worked on 2 migrations in this role, on a migration between 2 internal environments and on a client-by-client Platform migration between the legacy and current parent company. This role includes: • Maintaining static reference data at table level including setting up new static • Profiling the existing static data to create an ERD for future reference • Running the transaction processing reconciliation daily • Cleaning transactional data so that it can be processed (including creating an audit trail) • Creating ad-hoc reports for various departments combining data from Oracle and SQL Server databases • Specifying new transactional processing, assisting with testing and creating a reconciliation process to monitor it • Creating a data dictionary of the existing data warehouse • Migrating from Travelex to MasterCard - Analysing the data flow between multiple systems including the creation of detailed data flow documentation - Analysing and documenting existing DB jobs and their interactions with packages and procedures • Automating pre-existing manual reports using Excel VBA • Understanding data elements of PCI (Payment Card Industry) Compliance • Analysing behaviour of new transaction types received from card processors • Writing technical specifications for developers for numerous change requests • Restoring transactions that have stopped part way through processing so they can be invoiced • Identifying instances of fraud, including that perpetrated by employees of clients and instances of card skimming • Logging and monitoring defects detected during testing and profiling of new and existing code on the Atlassian Jira defect management system Show less

Dataflux Analyst

• Oct 2011 - Apr 2012

I worked as a Data Analyst on the Michael Page Gateway Programme and used DataFlux to profile recruitment, advertising, billing and temp booking data from the legacy Profile 2000 Sybase 8 ASA database as part of the migration to the new Bond Adapt Page Recruiting system on SQL Server 2008. I also created a framework for the business to use to identify data anomalies as part of their BAU data quality initiative. This role included: • Collecting and refining the requirements of the DataFlux-centred Data Profiling project. • Profiling databases (31 databases covering 38 countries and 68 realms for Profile 2000) and analysing the results to identify dirty data that might affect the data migration. • Developing the following frameworks using DataFlux frameworks and native SQL to: - Confirm the migration statistics to satisfy Corporate Audit requirements. - Ensure the business meets various compliance criteria including legal compliance with the Data Protection Act. - Ensure that management reports are accurate enabling future decisions to be based on a correct interpretation of the business as well as helping recruitment consultants to be more efficient by ensuring all the data they work with is of high quality. - Ensure that any data anomalies that might interfere with the migration are logged and strategy is in place to minimise their effects. • Logging and monitoring of defects detected by profiling on the Quality Centre defect management system as prescribed by the project data quality procedures. • Presenting DataFlux functions and capabilities to management across the global business. • Gathering training requirements, organising vendor training and creating a DataFlux training manual for the future training of and guidance in the use of DataFlux for data analysis. • Defined and configured the DataFlux environment for the Michael Page development, production and test environments. Show less

Data Quality Administrator

• May 2010 - May 2011

Worked on the Evolution Programme to upgrade/migrate CSC's Oracle 9i database to Oracle 10g and it's associated property (Horizon) and financial (Agresso) software as well as move their HR software over from Hummingbird (Bond) to Autonomy (Phoenix). This role included: - Designing and developing Dataflux processes, based on Business rules, to analyse the legacy system data for data quality compliance from both a Legacy and New World perspective as well as presenting those on a regular recurring basis to programme and departmental management. - Designing and developing Dataflux processes, based on business and technical requirements, to compare the data migrated to the target system with the Legacy data to ensure accuracy of migration. - Designing and developing the data reconciliation process utilising Dataflux, SQL and Excel to confirm the MIgration statistics to satisfy Corporate Audit requirements. - Designing and developing Dataflux processes to ensure ongoing data quality and data governance on the target systems. Show less