National Railcards Marketing Database.

Descriptions

As the voice of the passenger railway, the Association of Train Operating Companies (ATOC) is the trade association representing train companies to the government, regulatory bodies, the media and other opinion formers on transport policy issues. It was set up by the train operators formed during privatisation of the railways under the Railways Act 1993. This contract will service all marketing data requirements for National Railcards, Days Out Guide/2for1 and other marketing scheme data on behalf of the train operating companies.Database general requirements:The database will need capacity for 10,000,000 individual customer records with multiple transactions, campaign responses and cases against each customer.The database will integrate with multiple data sources supplying customer data, online and offline purchases and case details via encrypted FTP or other agreed secure methodThe database will integrate with email service provider Exact Target via API or SFTP.The database will integrate or provide an interface to a third party data reseller.The database will be mapped to a front facing user friendly application suitable for marketing users (to be supplied/managed by winning supplier) to perform train of thought analysis on campaign response evaluation, segmentation and campaign selections.The database will map to a customer service tool (to be supplied/managed by winning supplier) to allow cases to be logged/ added to the database and reported on via the analysis tools.Database will allow administration (add/deletion/amendment of records) through user friendly web service (or other viable solution).The existing database structure (in SQL) is to be migrated and a review of the existing data and database structure to be undertaken the result of which will be suggested improvements to the database structure.Data from the existing supplier will be transferred to new database environment.Regular BI & MI Reporting.General account management requirements:Supply dedicated account management for daily BAU issues and reporting.Supply dedicated project manager development work.Provide a Jira or similar helpdesk system to report and monitor issues.Provide marketing data business analysis as required.Supply monthly business reporting for management information.Supply monthly reporting on the performance of the database and SLAs.Provide training on the new system and for all new developments; with ongoing BAU support to users.Provide general data and CRM insight to add value to our campaigns.Fully knowledgeable on our data, the business and preference for knowledge of the rail sector needs.General technical requirements:Provide effective and pro-active project management for development work.Resource in place for technical development and maintenance.Processes and resources in place for technical testing, quality assurance and risk mitigation.Sharing information on new technical advancements to aid in marketing strategies.