Objective
To develop the marketing database solution for the reputed automobile industry and also to support the UK Epsilon Database Estates of SQL and Oracle.
Client and Project Details
EPSILON is an all-encompassing global marketing company which have clients like Google, Dell etc.
The main projects which intellidb has worked for the major Automobile and Transport companies.
Requirements
- SQL Development to deliver the Campaign marketing output information. Database Design, SQL Server Build, Backup and Disaster Recovery Design.
Solutions
- Implemented the complete SQL Development to deliver the Campaign marketing output information.
- Involved in performance tuning of SQL Server like the server configuration change and SQL Server objects tuning including the rewriting of stored procedures, views, Ad hoc T-SQL queries etc.
- Implemented ETL process, SSRS, SSAS Reports
Results
- Delivered the projects based on the client requirements on time.
- Customer to Dealer distance finder developed and amended in the application for the customer usage. Developed the own in house solution.
- Customer Service efficiently managed their clients without down time
- Provided the training to in-house employees for their ad-hoc reporting requirements
Customer Benefits
We automated almost all the manual work and that has enabled to achieve a 60% reduction in staffing overhead. Also we developed an automated solution to find the distance between one of the prestigious automotive industry dealer and customer residence.
Performance of the system
IntelliDB has designed and developed the campaign marketing system from initial stage to till the end of the project.
About Us
IntelliDB – established in the year 2012 based in the heart of London – is a pioneer and leading provider of database managed services (cloud & on-premises) including Database Migration, Administration, Proactive Monitoring, Design and Development Solutions etc.
We provide services to many sectors such as Health Care, Government Organisations, Oil and Gas Industries, Broadcasting, Audit, Tax and Advisory, Automation IT Management Services, Marketing, Telecommunications and Financial Services.
Reach Us
E : info@intellidb.co.uk
T : +44(0)7944423431
Address:
143 Victoria Road
Barking
Greater London
IG11 8PZ
United Kingdom