About the Client
The Client is a multinational media and digital marketing communication company headquartered in London, United Kingdom.
Media Planning & Campaign Management Platform
SQL Server 2012 Enterprise Edition, ETL – SSIS, Analytics – SSAS, Reporting – SSRS, MS Development Stack
We built a common platform to store and make relevant data available for each application. We developed a media planning and campaign management platform with following solutions:
Global Data Management Platform (DMP) to facilitate seamless data exchange
Easy data aggregation from various sources
DMP offered the base for different applications like Market Demand Forecasting, Media Spend Scenario Planner, Global Planning Application, Cross Channel Reporting
Provided components such as Master Data Management, User Roles Matrix, Workflow Mechanism, Data Distribution Marts, Data Acquisition Layer, Data Auditing, Data Logging & Exception Handling, Security and Platform access, Scalability, Extensibility, and Usability.
Document and Content Management
Robust data warehouse to deliver critical client reports
Flexible reporting for internal use
Ensured data consistency
Ensured data security
Ability to interface with external systems