Duplicated system on Oracle 8i. Used Crystal Reports and InfoDesktop on NT Server 4.0 for security level interface to reporting. Data Wharehouse in Oracle was used to maintain reporting data for company sales. Used Seagate s Info Desktop for users to run reports themselves from server. Wrote Oracle stored procedures to report from to optimize reporting for queries against tables with millions of records.
Output includes parameterized reports with subreports.
Developed application in VB 5,6.0, SQL Server 6.5, Crystal Reports 6.0 and Procomm Script. Wrote stored procedures. Application dials into lockbox servers, imported payments files, posted files to database, exported Metro 172 format files to Trans Union. All Rights Reserved.