Home   Contact        Sitemap
 
 

Hundreds of employee hours saved through automation ...

Client Profile:

Industry: Fortune 500 Health Care Insurer Employees: 30,000+ Annual Sales:  $57 Billion

Problem Statement:

This health care insurer was in the process of converting hundreds of pages of internal "how-to" and process manuals from simple text documents into an HTML format that could be published on a new company intranet, allowing for employees to easily search and review documents online.  When we engaged with the client, the initial approach adopted by the client was to hire temporary staffers to manually convert and edit each document to a preferred HTML format, a process estimated to take over 100 hours.

The Technical Challenge:

In converting a large set of text files into one common format, a custom string parser needed to be written that would recognize common string patterns within a text file and convert them to an agreed upon HTML format.  Leveraging the newly released (at the time) Microsoft VB6.0 platform, we were able to write a code module in less than a week that took advantage of the Microsoft Regular Expression engine and its advanced string parsing to quickly and effectively convert all text documents.   Due to the extreme efficiency of this approach the client was also able to quickly make changes in their transformation rules and output format and re-run the transformation numerous times.  When additional documents were found that needed to be transformed, the client had the option of re-run the transformation at any time and include the additional documents.

Results:

n  Client was able to convert 100's of pages of documents in less than 15 minutes, saving weeks of labor intensive conversion.

n  Documents were published to intranet site ahead of schedule, allowing the project to complete under budget.

n  Service workers were able to electronically search and index what was previously a set of paper documents.  

Technologies Deployed:

Microsoft VB6.0, Microsoft IIS 4.0

  New ! Dashboard Webinar



Free Dashboard Design Session


Register for your complimentary design session where you can work directly with a BrightPoint Dashboard Architect to focus on one of the following areas:
 
Creating KPIs and metrics
Prototyping your dashboard
Architecting your solution
 
click here to learn more

Space is limited and reservations will be accepted on a first-come first-serve basis.

 
 
  Choosing Correct Metrics & KPIs 



  Designing Dashboards: Part 1 



  Designing Dashboards: Part 2 


  ManagePoint Web Services

This .Net web service allows you create Crystal Xcelsius dashboards that pull data from Microsoft SQL Reporting Services reports in real time.
 
 

Tutorial - Creating Dashboards with SQL Reporting Services

A white paper that demonstrates how to integrate SQL Reporting Services reports into your Crystal Xcelsius dashboards leveraging the ManagePoint Web Service.

 

 
 
 
   Copyright © 2004-2008, BrightPoint Consulting Inc.   Home   Contact        Sitemap