Liberty Check
Printers, Inc
- Lead consultant in the design and development of a financial
reporting application utilized to report the financial performance of numerous credit union clients.
The financial reporting application runs on numerous Compaq servers, running
under Sun
Solaris X86, on Oracle 8i. The application utilizes the Oracle SQL Loader
facility to load mainframe data into the Open System environment. The
customer source data is then processed into a single fact table (much like a
Data Warehouse) through the execution of a package of PL/SQL scripts.
Again, through the execution of PL/SQL procedures, the fact table is broken out
into many aggregate tables, facilitating the reporting application. The
entire report application processes a client in 30 minutes to 4 hours.
|