Reed Business Information: May 2019 – present, Contract
Inmarsat: Nov 2018 – May 2019, Contract
Reed Business Information: Aug 2012 – Jul 2015, Contract & Jan 2016 to Mar 2018
The Chartered Quality Institute | International Register of Chartered Auditors: Oct 2011 – Jul 2012, Contract
ORC International: Jun 2011 – Jul 2011 (1 month), Contract
The Engine Group: Jan 2010 – Sep 2010 (8 months), Permanent
Tube Lines: Oct 2009 – Jan 2010 (3 months), Contract
Unilever: Dec 2007 – Sep 2009 (18+ months), Contract
BT Global Services: 2004 – Aug 2006 (2 years), Contract
Reed Business Information: May 2019 – present, Contract
A Lead Data Analyst on the data migration project I left (see below). The target system is a Lightning instance of Salesforce and Apttus. Another project is to fix existing data issues for Accuity resulting sub-optimal BAU processes and from a data migration I was not involved in. Value I have added there is to initiate a data audit to proactively flush out data issues against a known baselined set of processes (which thankfully are documented).
I have 3 other data analysts to co-ordinate with as well as senior stakeholders from the business. Specific challenges include a very ambitious deadline, and a lack of adequate documentation for Apttus, for example no data dictionary and no Entity Relationship diagram (ERD). Due to the deadline there are areas where we could improve, like the quality of the data mapping spreadsheets, the complexity of pointing the data migration solution to new environments. I have highlighted these issues and they are known and acknowledged.
The main tools I use are SQL Server, I quite miss not using Postgres. I also am becoming more involved in Alteryx as that is the tool of choice to build the data migration workflows. So far I have re-worked the data migration strategy I began in February 2018 and mirrored some of the existing migration workflows in a QA capacity. Challenges I have dealt with before are lack of definition over scope, which my data migration strategy has alleviated.
Inmarsat, Old Street, London, UK: Nov 2018 – May 2019, contract
I was a Data Analyst on a data migration project to migrate Inmarsat’s CRM data onto Salesforce.
Postgres was the relational database used. I was mainly involved in data mapping to the new Lightning instance of Salesforce. I also initiated a data quality activity to ensure that existing records complied with new processes and mandatory fields. Other achievements included setting up a JIRA project for the data migration user stories, creating a Confluence site for the data migration and using AWS Console (S3 usage and data migration tasks).
Unique challenges for me were with the complexity of Inmarsat’s customer data structure, lack of integration between existing data sources and the quality of the data available. In addition, due to breadth and scale of the project’s scope, planning the order of system loading was complex. Other challenges that are common in these projects were business engagement with the data migration, desynchronization of systems between environments, data quality, breaking the ‘lift and shift’ data migration mentality in stakeholders, educating stakeholders to the virtues of good data quality.
Reed Business Information, Sutton, UK: Jan 2016 to Mar 2018, contract
Data Migration Analyst, Co-Lead, developer, QA, BA and Data Architect for a data migration from a custom Oracle CRM, plus Salesforce to a Salesforce and Apttus stack. The data was mainly subscription, order and billing information plus the Accounts and Contacts associated with any in scope order.
The main body of work was:
Co-design, implementation and validation of the data migration solution (T-SQL, stored procs, views, schemas, command line, batch Salesforce data loader, PowerShell, Linked Servers, FOR XML SQL).
Documentation and visualisation of data migration scope, mappings & rules.
Discussing and resolving issues with technical staff and business stakeholders.
Within a data migration team of three (one data migration developer and co-Lead based in Doetinchem, and myself based in Sutton), we designed and created a data migration solution according to the requirements gathered by us and offered by the business based in Amsterdam. Travel to Amsterdam and Doetinchem was required. The client, Nextens who mainly provide web services (and desktop software) to assist Dutch Accountants submit tax returns to the Dutch tax authorities. It was a very challenging project for everyone involved.
I then moved on to a new data migration project for the FlightGlobal and FlightStats Reed Business Information markets. In January 2018 I decided that it was time to move on, at an early ‘discovery’ phase of the project. Up until I left on March 14th, I was involved in analysing the source Salesforce systems, creating a strategy document (scope options and business rules per migration entity), data dictionaries, creating test materials and interviewing my replacement candidates and completing a handover of all my work.
Reed Business Information, Sutton, UK: Aug 2012 – Jul 2015, contract
A 3 month rolling contract mainly as a data migration analyst on various projects within RBI’s Corporate Solutions Group and one of the brands called ICIS. The projects can be categorised as three and a half data migrations (the halves being other mini migrations and one product dev & design project.
Agile development (using JIRA) of an SQL based solution to migrate ‘credit’ users and purchase data from SQL Server to SQL Server and Amazon DynamoDB. The Credit user migration project was viewed internally as a high profile project. The data migration was successful and the stakeholders were happy; so much so that someone from Customer Sales reminded me when it was the one year anniversary of the data migration.
Apart from dev work, main tasks were the analysis, data reconciliation, communication, documentation and ‘sell’ of the whole project so that everyone felt included and part of it. Troubleshooting and sense checking of other migration projects, i.e. is the data correct, are exceptions to business rules being handled, is the overall approach sound?
Development of a repeatable ETL process to extract petrochemical supply and demand data from an SQL Server instance into an XML database (MarkLogic) via a logical application layer (IDDN) that accepts XML via REST protocols. Other tasks aside from development included analysis of source database, creation of the target xml data model. Documentation of the development of the data model (Confluence), source database, mock ups of the front end interface, consultation with stakeholders, communication with China based web dev team and India based data team.
Data migration, test & QA Analyst for two industry publications (Estates Gazette & XpertHR UK) migrating to a new access and entitlement management system (SQL Server 2008) along Agile methodologies. Both migrations went live with 99.8% of data transferred successfully and minimal disruption of the normal service for customers.
The work consisted of analysing and testing the data sets to provide instructions to the SSIS dev via the creation of semi-automatic SQL scripts, views & stored procedures (T-SQL). The scripts simulated the flow of data from the actual SSIS package in order to test all data drops/deployments throughout the testing and deployment environments. Also a reconciliation file (stored procedures to produce tables and views as a data source in Excel) to evidence the course of the data flow from the SSIS output logs was required and built.
The Chartered Quality Institute, City, London, UK: Oct 2011 – Jul 2012, contract
Data Migration Analyst (SQL Server / Oracle) for a data migration (2.5 million plus rows of data) of a membership database system (Integra) to iMIS. Initially brought in to do some short term reconciliation work (six weeks) I was extended and took the lead on the scripting of almost all areas of the migration until the end of the project which went live at the end of June 2012.
Content & Responsibility:
Composition and responsibility of SQL, T-SQL and PL/SQL code in SQL Server and Oracle XE
Consulted with the business and project managers on how best to achieve the project goals from a data perspective
Prepared testing manuals and score cards for permanent staff for data testing
Tech: SQL Server 2005, 2008, SSRS 2008, Oracle XE, regular expressions (regex), Excel, HTML
ORC International, Islington, London, UK: Jun 2011 – Jul 2011, contract
A short contract setting up online surveys and producing online and offline reports for ORC clients. I offered advice on the fact that the main website was not formatting correctly in Firefox, Chrome and Safari and offered insight on how to capitalise on online data monitoring techniques. Tech: SQL Server 2008, HTML, CSS, Access, Excel, PowerShell.
The Engine Group, Fitzrovia, London, UK: Jan 2010 – Sep 2010, permanent
A Database Analyst for Fuel Data Strategies, a data analytics sub company of the Engine Group. Using SQL Server, SSIS, Command Line & PowerShell, Access and Excel the main focus is on the processing of marketing data sets for Lexus.
Content & Responsibility:
Daily processing of requests from Lexus web sites and click through advertising.
Ad hoc reporting on specific campaigns and lead management
Migrating server processes on Windows Server 2003
Set up, tracking and reporting of email campaigns via Campaign Commander, including the selection of recipients (seeds, segments, suppressions, etc.) and validation of HTML and email assets.
Tech:
SQL Server and SQL Server Integration Services (SSIS) are essential to the role as well as an understanding of VBA for Access to disseminate legacy MS Access processes.
Stored Procedures, batch / automated data input, cleansing, manipulation, and output via SQL Server, SSIS, BCP utility and PowerShell
Tube Lines, Docklands, London, UK: Oct 2009 – Jan 2010, contract
A Claims Analyst, within the legal department of Tube Lines working on a claim destined for arbitration. A short term contract, primarily specified with producing spreadsheets using VLOOKUP and Pivot Tables and charts as well as Access and SQL where required.
From my experience of Unilever and large data cleanses I consulted with the senior solicitors on the project as to the best way to approach a data cleanse.
Unilever, Blackfriars, London, UK: Dec 2007 – Sep 2009, temp
Initially hired to cleanse data for two weeks in December 2007, I developed a role as a Data Analyst within Global HR. My contract rolled for over 18 months until the beginning of September 2009.
Content:
The content of the data was regarding Unilever’s expatriate employee moves and changes, as well as crucial involvement in the calculation and validation of the global annual salary and bonus review.
Reporting to senior management, I was trusted and valued to work unsupervised as well as looked to for my professional judgement on technical matters. For instance, my opinion was sought on bespoke software from consultancies such as Ernst & Young Business Advisory Services, Deloitte and KPMG.
Through my exposure to PeopleSoft and the Oracle database I gained a lot of knowledge of Unilever’s PeopleSoft database design. Furthermore, because of the length of time I spent in global mobility, I also absorbed a fair amount of knowledge of Unilever’s expatriate remuneration policies.
Tech:
I queried Oracle (the database that powers PeopleSoft), which contains over 200,000 employee records and millions of records in total stored in a complicated temporal format. I exported salient records into Access 2003 then via SQL produced reports for Unilever Global Human Resources.
I exported results from Oracle into Access. From there I treated the data some more with SQL. Results were exported into Excel to present my results in a meaningful way or to exchange the base data for other’s action or information.
I also created Access databases using a combination of SQL mainly and VBA. The Access databases I created saved Unilever time and money as well provided a base to validate data against.
The Past: Jul 2000 – Sep 2006
I was fortunate enough to spend time after my MA in Psychology and before my MSc in Computing experiencing the world and working in different roles. I worked for BT Global Services between 2004 and 2006 as a Data Analyst and Team Leader on BT’s contract with the Department for Work and Pensions to supply telephony and network services. I have been a Gardener in New York and Manchester, a DJ Expo Sales Assistant for Guitar Center in Atlantic City NJ, taught English in Tokyo, restored furniture and a worked as Photographer for a music magazine in Sydney NSW. In the UK, I worked in an admin position at BAE Systems Warton, in London as an International Events Manager for the Society of Petroleum Engineers, then an Off Licence Manager for Unwins Vintners. I was a Croupier at a Stanley Casino and did work experience as a TV Journalist and Cameraman in Liverpool. I cared for people with Autism in Barnsley. In my home town, Lytham St Annes, I have been a Bar Manager and DJ at the Queens Hotel.
