Data Warehouse Reporting Portal: System Design, Development Review and QA Testing

The Customer

Our customer was a company involved in gathering & providing information specific data to the Wireless Industry. Our client assists its clients in understanding the changing landscape of the wireless industry. The customer helps its clients attract, serve and retain customers successfully with timely, actionable insights into market share, media spending, price plans, network performance and customer attitudes - for both voice and data.
Subscribers in the current system request access to relevant information over a particular period of time. This is performed by creating a Client Identity for each of the subscribers and creating groups of users under them. Then, Access Filters will be created and assigned to the Users. This ensures that the subscribers are only provided with a subset of information and not the entire data.

Customer business need

Our customer had an existing web portal, which used a combination of custom Java code, HTML and various embedded reporting tools (like Crystal Reports, Brio, MicroStrategy) to allow customers to run dynamic reports and download static reports (in power point and PDF format).

Services:

SolovatSoft personnel participated in review of system design, implementation and QA Testing of a new portal.

The Benefits

The Portal has the functionality of running dynamic reports and viewing static reports. The new Portal has the functionality of exporting the Reports into PDF Format. The new Portal authorizes the user request by using the Security feature as well as Micro Strategy's Security.

Tools and Technologies: ASP.NET, Windows Server 2003, IIS6, MS SQL 2000, Microstrategy 7i