Roy Baker Email & Phone Number

Manchester, England, United Kingdom

Review the quality of the data available within the warehouse platform and produce data extracts for the multiple funders based on their specific business requirements. This involve developing and designing processes to be run on a regular basis to ensure that the agreements adhered to the strict criteria and rules for funding by the clients.• Review the data sources ( Equiniti, MotorMart ) utilising SSMS on an Azure platform• Resolve data alignment and quality issues with business stakeholders• Managed development and QA of SQL scripting to implement the process to BAU level• Mapping and modelling within the SQL server to create customer profiles As the business progressed, the automated approach to monitor ongoing data quality and maintaining the extracts with additional information was expanded to utilise the original concept of static customer profiling to include processes for the likes of banking (collections), asset sales and terminations. The development process moved from the original monthly extracts to regular supplementary extracts (twice weekly) and eventually to daily processing to highlight and resolve any data issues and funder requests quickly and efficiently.

Manchester, England, United Kingdom

Review and replicate the existing data migration process to the business billing platform with a view to move from current Excel approach to a more automated SQL database service. This also included the post migration processing of chargeable calls during the event window.• Review the target applications (Evolution, SugarCRM) utilising SSMS and HeidiSQL• Mapping and modelling within SQL server staging to create generic customer profile • Resolve data alignment and quality issues with business stakeholders• Managed development and QA of SQL scripting to implement the processThe automated approach will enable a swift turnaround of data with less customer impact on new acquisitions to the telecoms business. This should reduce issues caused by previous manual errors allowing resource to focus on data quality improvements rather than data corrections.

Bristol, United Kingdom

Deliver the mapping for the data transformation of Water utilities legacy platform to a replacement MS Dynamics CRM and F&O application. The migration toolkit was being developed by a co-located team in Malaysia and issues raised through an in-house defect management system.• Review source legacy systems (Rapid, GIS, Tallyman, Eptica) utilising SSMS• Analyse the initial target documentation from developers and log mapping issues • Data processing in SQL server staging and log data quality issues• Review and resolve issues and defects with business stakeholders and SME’s• Implement data corrections in both source feeds and transformation processesThe replacement of the legacy system would give agents access to a new up to date application which would improve the overall customer experience going forward. The new system would also allow for regulatory changes in a more business friendly approach.

Manchester , London

Led a team that successfully increased the customer base by 3.5 million across multiple projects within planned timescales and business expectations. The projects covered inbound migrations to the consumer BSS platform, outbound migrations to third party client platforms and internal product migrations to match network upgrades.Delivering strategy for data review, development, testing and execution for projects• Business requirements gathering to identify data requirements• Team leadership with resource planning and event scheduling• Data mapping, ETL, data quality, data cleansing and service alignments• Data modelling and normalisation of staging area for customer profiling• SQL script development and testing of the end to end toolkit• Performance optimisation and defect management alongside progress reporting• Implementation, monitoring and completion of migration projects• Use of both Agile and Waterfall methodologies Processing for the migration based projects :-• Inbound migrations to BSS target systems (Chordiant, SingleView, OrderManagement )• Staging in Data Warehouse (Netezza) utilising Aginity, SQL Server and Oracle apps• Align network service feeds for data alignment using reports from BT, OSS and Vodafone• Liaise with co-located OpsSupport/DevOps team for data corrections and events • Daily reporting on issues and progress to business stakeholders and clients• Clients :- OneTel, Tentel, Tesco, VirginMedia, Pipex, DaisyComms• One internal project of TTB customers from the MDS billing platformThe processing also increased the business OnNet base by 3 million removing the reliance on outdated legacy systems and external services. These allowed savings on maintaining legacy systems relating to billing of customers and charges for network related features from external product suppliers. There were also saving from the development of the internal migration toolkit as the legacy Informatica based product was replaced.

London, United Kingdom

Led the data quality team within OpsSupport to ensure that the data alignment across and within the BSS platform met business requirements and legal standards with data fixes directly onto the Oracle and SQL databases. • Design the internal migration toolkit replacement for legacy client developed process• Address verification and alignment of customer address for national EDB application• A retrospective fix for all existing OnNet customers and pre-process for new customers • Alignment of the BT network upgrade of the IPStream customer base• Alignment of the network upgrade of Broadband/Calls customers to full OnNet LLU• Incorporation of the regulatory timelines for correspondence to customers• Generate customer profile process for complaints using Excel (VBA, ADO, macros)

Part of the data migration team that successfully delivered 3 distinct projects within planned timelines and customer number expectations. I collaborated with the migration toolkit provider (Clarity) to deliver and process the feed files from the legacy bases through the Informatica based product and subsequently monitor and verify the population of the BSS platforms post processing. • Staging in Informatica utilising SQL Server and Oracle apps• Clients :- Tiscali, AOL, CarPhoneWarehouse

Deliver nationally approved services to London trusts by test and sign off of the respective migration toolkits which culminated in the completion of successful migrations to 4 of the trusts. • Processes targeted Cerner Millennium and RiO Health applications• Generate and execute migration regression test plans and datasets for each application• Processing utilised SQL Server, Toad, EnterpriseManager and Entruder apps• Generate data templates for the implementation of the migration process for each trust• Perform data quality verification of trust information prior to the trials and implementationsThe project related to the National Programme for IT (NPfIT) and ensured trusts met legislative regulatory rules to utilise the national patient information platform (SPINE). This allowed trusts to access existing patient medication and allergy information in an emergency situation, outside their home trust, in cases where contact or communication is not possible.

Deliver the new Ticket on Departure system for use nationwide by all train operators. The project also delivered associated upgrades to the seat reservation and settlement plan.• Witness testing the upgrade to the settlement plan (LENNON) by the vendor• Generate data files for TIS accreditation process of the selling / issuing ticket machines• Monitored the data progress from TIS thru CTR (Fujitsu) to LENNON and raise issues• First line support for implementations during pilot periods in the Live environment • Report on issues and progress to the vendors prior to implementationThe integration of the relevant systems delivered the customer experience for online ticketing and reservations that is still currently available. The release delivered 100% accuracy for the financial distribution of the fares to the relevant train operators within the settlement plan process.

Maidenhead

Deliver the data warehouse platform on schedule for the planned global release date of 03/03/03. This required the creation and execution of system and UAT test scripts for the processing of data from all the associated application platforms into the Data Warehouse.• Data feeds from parent applications (Chordiant, ADC Billing, Aspect, Mediation)• Create data load files to populate applications from Excel spreadsheets • Data supplements by automating the front end applications using TestDirector • Verify and sign off the ETL processing to populate the DataStage data warehouse• Report and correct data issues before and after implementationThe project successfully met the planned date giving customers a more varied choice on the 3G market and improve the growth of the customer base and subsequent customer experience.

Prior to working in the data arena , I worked as a test analyst using test automation tools to develop regression test packs … and prior to that as a contract development team lead.• test roles at :- Three, BT: NHS, NatWest, BritishAirways, LloydsTSB, UnitedUtilities, Arcadia , HMRC• dev roles at :- British Gas, LogICL, AA, British Gas, CAA, Kuwait Oil Company, UK Provident, AA