References from the Western
Region
|
| Project Contract Name: |
U.S. Army Materiel Command, Presidio, San Francisco CA |
| Project Description: |
Perform Database Management Systems software development for the US AMC Logistics Information File, a repository U.S. Armed Forces materiel, equipment, and supplies. Worked as prime contractor and subcontractor in different phases of the project. |
References from the Northwest Region
|
| Project Contract Name: |
Portland General Electric
|
| Project Description: |
Provide ongoing analysis & programming and other technical support to perform new software development and software maintenance for the Portland General Electric Outage Management System. |
References from the Southwest Region
|
| Project Contract Name: |
State of Texas Department of Mental Health and Mental Retardation |
| Project Description: |
Provide ongoing analysis and Database Management Systems programming support to the agencies served by the Texas Department of Information Resources client agency, the Texas Department of Mental Health and Mental Retardation. |
References from the Midwest Region
|
| Project Contract Name: |
Roadway Express, Inc. |
| Project Description: |
Provide Database Management Systems programming support for Roadway Express (a major trucking and shipping company) Tariff, Billing Collections Systems. |
| |
| Project Contract Name: |
Kent County, Michigan |
| Project Description: |
Provide programming and analysis support for Kent County, MI, tax system. |
References from the Northeast Region
|
| Project Contract Name: |
New York State Insurance Department |
| Project Description: |
Perform Year 2000 (Y2K) remediation of 26 DBMS departmental production systems. Provide independent validation and verification of Y2K remediated Mainframe Legacy application system and certify its Y2K compliance. Remediate one MS-Access client/server system for Y2K compliance. Develop two (2) new DBMS departmental production systems. Implement new complex nationwide batch message format processes for core Database Management Systems business system. Reengineer desktop applications from embedded Lotus 1-2-3 actuarial spreadsheet database applications to Microsoft Excel using Visual Basic. |
| |
| Project Contract Name: |
CGI Information Systems Consulting Services |
| Project Description: |
Provide ongoing software development support for the New York City Board of Education Automate The Schools (ATS) Project. |
References from the Southeast Region
|
| Project Contract Name: |
Nielson Media Research |
| Project Description: |
Perform Database Management Systems software development and maintenance for Nielsen's viewer preferences statistical analysis systems. Provide software integration support between the Mainframe applications and the external postal zip code mailer system and printing subsystem. |
| |
| Project Contract Name: |
ITS/LESCO - U.S. Army Missile Command (USAMICOM), Redstone Arsenal, Huntsville, |
| Project Description: |
Under a subcontract to Information Technology Solutions (a subsidiary of Computer Sciences Corp.) / Logistics, Engineering, Environmental Services Inc. (ITS/LESCO), provided programming and systems analysis support for improving response time and capabilities of the LIFMOD (Logistics Intelligence File Modernization) project. |
| |
| Project Contract Name: |
Information Technology Solutions (ITS) - U.S. Army Missile Command (USAMICOM), Redstone Arsenal, Huntsville, AL |
| Project Description: |
Under a subcontract to Information Technology Solutions (a subsidiary of Computer Sciences Corp.) / Logistics, Engineering, Environmental Services Inc. (ITS/LESCO), provided programming and systems analysis support for improving response time and capabilities of the LIFMOD (Logistics Intelligence File Modernization) project. Project Contract Name: Information Technology Solutions (ITS) - U.S. Army Missile Command (USAMICOM), Redstone Arsenal, Huntsville, AL Project Description: Under a subcontract to ITS, provided Database Administration for design of new databases, redesign and tuning of existing databases and procedures for logistic support activity at Redstone Arsenal. Trained programmers in the use of other DBMS User Language and File Manager's tools and techniques. Designed application subsystem that provided online error reporting for the centralized Property Book Reporting System. Designed application subsystem that provided tools for scanning procedures and providing basic analysis for applying multiple programs language changes. |
| |
| Project Contract Name: |
Baycare Healthcare System |
| |
|
| Project Description: |
- Minimize usage of SMS HDX processing in an effort to reduce expenses.
- Provide support for Cigna, Humana, Aetna and standard X12 eligibility data records.
- Design the system to be able to support additional input sources as necessary in the future.
- Integrate the Eligibility Inquiry functionality into the SMS Invision pathways.
- Provide an Intranet/Internet inquiry mechanism for enterprise wide inquiry capabilities.
- Provide statistical reporting capabilities.
- Maintain historical data for account follow up purposes.
|
| The design of the eligibility project includes the following components: |
| |
|
| |
- Develop a data dictionary to describe the eligibility data maintained in the Oracle based database.
- Develop SQL to define tables in the Oracle database.
- Develop ASP based web pages for browsing inquiring on the eligibility data.
- Develop programs to read the Cigna/Aetna/Humana/X12/other input data sets into the eligibility database.
- Develop custom COBOL CICS/OAS programs and modify Invision pathways to utilize the new eligibility database.
- Document the entire process.
- User training.
- On-going support services.
|
