Web Analytics Reporting Software

Software Industry

Client is a software company that produces web analytic software for businesses. In 2000 they developed a data warehouse with several supporting applications designed to integrate website visitor data with customer data via a Siebel conduit. Client’s customers wanted a customizable reporting solution using Crystal Reports.

Developed a 3-Tier Client Server VB/Crystal Active X database application using Visual Basic and Crystal ActiveX. Architected the database for both Oracle & Micosoft SQL Server support. Application included:

• Over 100 reports users can filter and sort via GUI selection of criteria
• Reports with graphs and drill down capability
• Calendar controls to select dates and date ranges
• Ability to select multiple date ranges for comparison charts
• Ability to create custom reports and incorporate them into the GUI
• User security levels with administrative level definition of user permission rules (ie: ability to limit viewing of data based on users and user groups.)
• Ability to manage personal reports
• Ability to share reports between groups
• Ability to schedule reports
• Easy application installation using Wise installer
• Easy installation of database scripts

Reporting Module for Event Scheduling

Higher Education Software Industry

Client produces a 3-tier client server software product used by universities for scheduling classes, staff and functions that interfaces with student information systems, like PeopleSoft. The product had a few internal reports that were mostly inaccurate. Users wanted better reporting capabilities using Crystal Reports. Database support included Oracle, SQL Server, DB2, Sybase, Informix & Compuware’s Solid DB. Designed & developed a reporting GUI that:

• Allowed for integration of custom reports & selection parameters
• Ability to manage personal reports
• Provided over 50 reports to be shipped with the product
• Used the client's product's internal query engines to process data for enhanced performance
• Allowed for enforcement of user based security.
• Supported installation on several OS platforms and databases

Crystal reports to be shipped with the software included multiple data groups and sub-reports with parameters and formulas to pass calculated data between the main report & sub-reports; formulas to convert date and Boolean values to comply with all supported ODBC databases; formulas to retrieve data via date criteria where no actual date value existed, but was implied.

Business Reports & Analysis

Automobile Parts Manufacturing

Client uses a third party ERP software system that incorporates Crystal Reports into its GUI. Data was migrated & converted from a homegrown AS400 system into the vendor's Oracle backend database. The software vendor was charging high consulting fees to “fix” the problems but the client continued to experience excessive performance problems. Analysis determined performance issues were caused by poor database design coupled with an unusual method to incorporate Crystal ActiveX functionality. Provided client with documentation outlining design problems. Designed & developed a Visual Basic application with an Access database to allow for scheduling of batch printing of Crystal reports outside the third party software when network & database traffic was lowest until the underlying design issues in the software could be fixed.

J2EE
Java Servlets
Java Beans
Javascript

Microsoft
Visual Basic
.Net
.asp

Php
Perl
html
Dhtml

MySQL
Postgres
Oracle
SQL Serve