Client: Federal Banking Agency

Scope: Assisted client in planning, designing, building, testing and deployment of a web-based business intelligence system to transform high volumes of electronic funds transfer data into useful information.

Results: Enabled efficient web-based customer self-service. The client is now able to deliver important transaction information and analysis to its customers and partners faster and at a lower cost than the legacy systems. Improved customer satisfaction and achieved significant cost savings. The new system made efficient, web-based self-service available to the client. The client is now able to deliver important transaction information and analysis to its customers and partners faster, and at a lower cost than the legacy systems. Improved customer satisfaction and significant cost savings.

Client: One of the nation’s largest transportation and logistics companies

Scope: Planed, designed, built, tested, and deployed a series of sales and financial data marts. The client’s existing applications had been developed without reporting functionality. All new systems passed transactions to the legacy mainframe for financial calculation and posting to the General Ledger. Complex business logic was used to determine profitability at a branch level after all postings were committed.

Results: The client is able to roll up critical financial and customer transaction information and information analysis capabilities, and place it in the hands of decision-makers across the enterprise. This enables faster and more accurate analysis on overall financials, and details like customer profitability, contract profitability, productivity and other key financial measures.

Client: One of the nations leading mortgage lenders

Their existing data warehouse did not contain enough of the data they needed, was non-standardized, and had a slow response time. Most reports took between 30 minutes and 1 hour against the largest fact of 24,000,000 records. Several reports took more than 5 hours to generate.

Scope: Planed, designed, built, tested, and deployed a new, high-performance enterprise data warehouse.

Results: Data pulled nightly from multiple source systems into the mart. Reduced response time on all reports to fewer than two minutes. This mart will evolve into a rear real-time system serving operational reporting, historical reporting and Online Analytical Processing (OLAP) analysis.

Client: Leading global developer and marketer of premium cleaning, sanitization, pest elimination, maintenance, and repair products and services for the hospitality, institutional, and industrial markets

This client had multiple silos of specialty areas that sold products and services to common customers. Cross-selling and up-selling of solutions was non-existent or negligible. Their customers were spread across a variety of geographies which made it impossible to share enterprise data on existing customers across these silos.

Scope: Planed, designed, built, tested, and deployed a series of sales and customer-related data marts.

Results: Client customers can now be “intelligently” serviced by fewer sales representatives, with a true customer record that reflects product purchase history and contracted service level agreements. The client can package common service elements across product contracts. Potential cross-selling or up-selling of products and services can be viewed through trend analysis and strategic delivery planning mechanisms by the Sales, Marketing, Product Development, and Service Delivery organizations. Increased revenue through new product introduction and increased services revenue are expected by expanding across logical sharing with other product offerings. Cost savings will be achieved through lower account representation.