Data Warehousing

4GL Solutions have provided data warehousing services for many different industries. We have created mini data marts analyzing Claim and Provider data for healthcare companies, Legal databases for County Courts, Student Registration and Financial Aid warehouses for educational institutions, Inventory, Sales History, and General Ledger warehouses for electronics firms, and data mining warehouses searching for questions telecommunications data.

Our breath and depth of experience qualifies 4GL Solutions to provide targeted needs-specific consulting to address each of our customer's environmental/business demands. 4GL Solutions' data warehouse practice assists customers in determining their information needs by:


Performing data warehouse project assessments
Developing data warehouse project plans, deliverables, and milestones
Identifying business units' requirements
Creating logical, data warehouse data models
Creating capacity plans, security requirements, and back-up and recovery strategies
Analyzing performance problems and their resolutions
Assessing the technical infrastructure of the entire data warehouse architecture, including Internet support
Developing requirements for, and selection of, data access tools
Ensuring the quality of end-user data access applications
Assisting in the selection of the correct analysis tool and database vendor
Data Warehouse Projects
Provider Tracking PacifiCare Health Systems
Claims Analysis PacifiCare Health Systems
Customer Service System PacifiCare Health Systems
Cellular Calls Cellular One
Student Registration Office of Admissions and Registrar, UC San Diego
Student Financial Aid Student Financial Services, UC Sandiego
Corporate Data Warehouse Pioneer Entertainment (USA) L.P.
County Courts Los Angeles County
Title/Escrow Fidelity National Financial
Travel Agency Back Office Unisys-Uniview
Mortgage Information WMC Mortgage Corporation
Amex/Visa Credit Card Travel Management Corporation
Sales Warehouse Pioneer Entertainment
Sales Warehouse Avery Dennison
Guest Profiling Hilton Hotels
Patient/Medical Information UCI Medical Center