Global Rights Management System

13 FEB 2018

Client

Global Marketing Communications Organization: Deployed for a Fortune 100 Entertainment & Media Company.

Clients concocted a thought

The Client required a solution to track the Global Market information and analyze the market with the help of reports. The reports had to be agile so that there are multiple views of same data. The current system was using Excel spreadsheet to manually store and the data was reported using the same this resulted in lake of latest updated market information, data accuracy problem, data synchronizing problem, significant labor-intensive work effort and unnecessary delay for report production and decision-making.

Challenge

The spread sheet manipulation process was not acceptable to the users as it lacked the capability to have latest data. Analyzing their data and architecting a solution which can cater the client to enable access of centralized data, the key challenge was to consider user friendly inputs and generating agile reporting system with dynamic views:

• Data Entry: a user friendly UI to enter the data
• Dynamic Reporting: Show data with sub totaling

What we proposed

The Star Knowledge Technical Team developed application with ASP.Net, MS IIS Webserver, MS SQL servers as underlying components and SQL Server Reporting Service for reports. This application took all its input from user and the data was processed based on the business intelligence embedded in it. Testing included the development environment and testing in a staging environment to ensure production capabilities and user acceptance. Solution work effort included:

• Data Entry: UI to enter the data with auto complete feature
• Dynamic Reporting tool with Sub totaling: UI to select parameters and constraints and generate agile report with respective sub totals.

Results & benefits obtained

The key benefits realized by the Client as a result of the successful project include:

• Centralized data access
• Provided Client quicker access and analysis performance information