Chameleon Clients

Federal Customers

Defense Information Systems Agency (DISA)

Provide Oracle 10g/11g database expertise to support DISA’s suite of Contracting and Financial Management Enterprise Applications.  Chameleon on-site Oracle database resources provide efficient and effective Oracle 11g table design, manage Oracle 11g database availability, maintain Oracle 11g database schemas (tables, views, indexes, sequences, packages, procedures, Mviews, functions, and triggers), diagnose and resolve client problems with ODBC connections/Oracle software installations, Oracle 11g backup/recovery, and Oracle 11g performance and tuning.

United States Army/Human Resources Command (HRC)

Provide on and off-site Oracle database and Oracle SUN Java resources supporting the Information Technology Support Program (ITSO) Task Order.  HRC requires Chameleon to support its future planning, ensure operational capability of current and envisioned systems, and assist in the Army personnel community’s transformation goal of attaining Capability Maturity Model Integrated (CMMI) Level 3 certification for all its systems.  Chameleon provides Oracle and Informix database resources to maintain, sustain, and enhance HRC IT systems, programs, applications, and databases vital to the management of the Army’s Active, Reserve and National Guard personnel, in peacetime and at war.  Chameleon on-site Oracle SUN Java developers design, code, test, and maintain software components in support of various ITSO projects.  Additionally these developers document software design and code.  All work adheres to HRC standards using Oracle SUN Java/J2EE.

United States Department of Agriculture/Farm Services Agency (FSA)

Provide on-site Oracle SUN Java resources to the Tobacco Transition Payment Program (TTPP) for the United States Department of Agriculture (USDA) Farm Service Agency (FSA).  This program calls for the "tobacco buy-out," helps tobacco quota holders and producers transition to the free market.  The Fair and Equitable Tobacco Reform Act of 2004 (P.L. 108-357), signed by President Bush on Oct. 22, 2004, ended the Depression-era tobacco quota program and established the TTPP. The program provides annual transitional payments for 10 years to eligible tobacco quota holders and producers.  Payments began in 2005 and continue through 2014.  Payments are funded through assessments of approximately $10 billion on tobacco product manufacturers and importers.  This important production system is utilized by various county offices in creating contracts for tobacco growers that would like to join this payment program.  Chameleon is helping FSA enhance and maintain this web-based system and its associated critical contracts and pertinent management reports through on-going Oracle SUN Java application software analysis, design, coding, testing and implementation activities. 

Chameleon provides on-site Oracle SUN Java resources to support the strategic Grassland Reserve Program (GRP) for USDA/FSA.  This program is a voluntary program for landowners to protect, restore, and enhance grasslands on their property. USDA's NRCS, FSA, and Forest Service implement GRP to conserve vulnerable grasslands from conversion to cropland or other uses and conserve valuable grasslands by helping maintain viable ranching operations.  GRP emphasizes support for working grazing operations: enhancement of plant and animal biodiversity: and protection of grassland and land containing shrubs and forbs under threat of conversion to cropping, urban development, and other activities that threaten grassland resources.  Chameleon assists FSA in supporting this crucial production system, and equally important, Chameleon assists FSA to migrate this critical legacy system to a much more robust and stable open systems architecture through on-going Oracle SUN Java application software analysis, design, coding, testing and implementation activities.

United States Department of Agriculture/Rural Development (RD)

Provide Oracle 10g database expertise to support maintenance of the Rural Utility Loan Servicing System (RULSS) and its migration to the Comprehensive Loan Program (CLP).  CLP is a $150 million financial system modernization effort, moving several financial loan accounting systems from legacy-based technologies to an Oracle platform.  Chameleon on-site Oracle database resources provide expertise in data migration activities from Informix, DB2, and SQL Server to Oracle 10g databases and data warehouses.  Chameleon on-site Oracle resources provide subject matter expertise (SME) in support of business intelligence (BI) tools including Oracle BI Server and Oracle Business Intelligence Enterprise Edition (OBIEE).

United States Geological Survey (USGS)

Provide Oracle subject matter expertise (SME) to support migration of the National Water Information System (NWIS) from an Ingres relational database management system (RDBMS) to Oracle 11g RDBMS at USGS Headquarters, 45 production sites and real time backup locations that are critical during emergency situations.  Migration activities include assistance with libraries, functions, and embedded SQL statements that must be rewritten to work in Oracle.  Chameleon Integrated Services (Chameleon) on-site Oracle SME’s assist with the migration of NWIS data, base objects, data and code from Ingres to Oracle 11g RDBMS.  Chameleon on-site SME’s analyze database tables and code in all aspects of the core NWIS applications and provide analysis and design expertise for table and code migration.  Chameleon analyzes the existing Ingres database model and data; identifies Ingres database inconsistencies to comparable Oracle objects; produces a migration plan for existing data and database structures in Ingres to a comparable model in Oracle; identifies areas of risk and proposed and documented strategies to mitigate risk; document recommended industry best practices in areas where there are inconsistencies between the Ingres database objects and comparable Oracle database objects; provides instructions to resolve inconsistencies and transfer the data to Oracle with the least amount of code changes necessary in the software; document suggested tools to use to assist in the migration and verification of the transfer.  Upon completion, tests demonstrate that database and table structures and data were successfully migrated from Ingres to Oracle.  Tests include but are not limited to comparisons of row counts in all tables and comparisons of individual table elements between the existing Ingres database and the subsequent transferred Oracle database.

State Customers

State of Illinois/Illinois Department of Public Health (IDPH)

Provide on-site Oracle subject matter expert (SME) resources to support development of the Illinois Comprehensive Automated Immunization Registry Exchange (ICARE)system.   Tasks include creating tables for HL7 data in the Oracle 10g/11g database, inserting and updating records in the Oracle 10g/11g database, and meeting the remaining 12 functional requirements set forth by CDC for an immunization registry system: exchanging patient and immunization data with other systems; parsing data with IBM’s Data Stage (Mercator) product; adhering to the HL7 Version 2.3.1 standard protocol for data exchange; accepting a query from one system for a patient’s vaccination record that is held in another system; sending a response to a query containing multiple patient matches to the query, but not returning vaccination records; sending a response to a query containing vaccination records; responding to an unsolicited update to a vaccination record; processing HL7 messages that include but are not limited to ACK, ADT, VXQ, VXR, VXU and VXX; reducing duplication of Immunization information; securing management of private and public data; supporting internal system administrator rights for Immunization staff; supporting the use of encryption within Internet browsers for the secure transmission of data over the Internet; and meeting all HIPAA requirements and regulations.

Commercial

Hewlett-Packard (HP)

Chameleon is an HP-approved United States Public Sector (USPS) vendor, supporting Federal agencies worldwide.  As an Oracle Gold-certified Partner, Chameleon provides value-added Oracle technology support services to USDA financial system programs in the Oracle SUN Java specialty.

Science Applications International Corporation (SAIC)

The SAIC/Chameleon team provide support and development for financial systems at United States Army Human Resources Command.  As an Oracle Gold-certified Partner, Chameleon provides value-added Oracle technology support services to ARMY financial system programs in the Oracle 10g database and Oracle SUN Java specialties.

Unisys Corporation

The UNISYS/Chameleon team provide support and maintenance for USDA distributed systems and their associated networks nationwide.  As an Oracle Gold-certified Partner, Chameleon provides value-added Oracle technology support services to USDA financial system programs in the Oracle 10g/11g database, data warehouse, and business intelligence (BI) specialties.  Chameleon also provides Oracle SUN Java expertise for web applications development.  CHAMELEON supports and promotes the UNISYS Application Modernization Center of Excellence (AMCOE), a secure, cloud-based solution targeted at Federal Agencies seeking to reduce legacy Government IT costs, widen support to include Government tele-workers/remote offices, and leverage best Information Technology practices.

 
 

Site Designed and Developed by Unleashed Technologies, LLC.

© Copyright 2012 Chameleon Integrated Services All rights reserved