Investor Relations

Buying a home is one of the most important decisions you'll make.

Case Studies

Background
The executive and line management at a leading manufacturer of consumer and industrial plastic goods, required functionality for reporting and analysis of their sales, purchasing, customer and manufacturing information. Clutchpoint delivered a complete data mart solution that enabled managers to perform analysis on their customers, products and manufacturing. The system enabled analysis of sales performance, purchasing trends, raw materials usage and credit memos.

Architecture
The source system was an MRP system called ManFact with the data residing in a proprietary database format. The data mart resided on SQL Server. Cognos Impromptu, PowerPlay and Macros were used to implement cubes and reports for multi-dimensional analysis and reporting.

Background
The executive and line management at the world's largest toy company, needed sales and forecasting information to support decision-making and empower managers and field sales-people. Since data resided in disparate source systems, there was also a need to present a unified view into critical business information. Clutchpoint was involved in project management, technical architecture, design, construction and deployment of the decision support system. The applications were implemented in a phased manner over a period of two years. This system enabled senior management get a summarized view of their sales and customers across different lines of business. Its also provided the field sales-people the opportunity to perform current and trends analysis on their sales and customers.

Architecture
The source systems resided on an IBM mainframe (DB2, flat files), AS/400 (Focus), and UNIX (Sybase). The target data warehouse resided on UNIX (Sybase). Custom ETL code was written to move data from the source systems into the data warehouse. This code consisted of mainframe-based COBOL and UNIX-based C programs, shell scripts and Sybase Transact-SQL programs. The executive information system consisted of a combination of PowerBuilder and Cognos Impromptu and PowerPlay Business Intelligence applications.

Background
The business need for a leading mortgage funding company was an application that interfaced with Freddie Mac's Loan Prospector system for automated mortgage loan submissions. There was a related need for automated generation of loan pricing and underwriting guidelines. Clutchpoint made major contributions in the architecture, design and database-development of the application, including writing key components of the guidelines generation, loan pricing and credit report server. The credit report server used X.12 EDI data exchange formats for communication with an external credit bureau. This application enabled automated loan submissions from mortgage sellers, allowing for real-time loan pricing and underwriting decisions, including real-time rate locks.

Architecture
The application was written in Visual Basic, with the database residing in SQL Server on an NT machine. The credit report server used a combination of SQL Server, Visual Basic server programs and EDI. Most of the business logic for underwriting guidelines generation and loan pricing resided in stored procedures running under SQL Server.

Blowjob