CTC has extensive past performance in all facets of data warehouse IT projects, helping to create data warehouses for some of the largest government and private sector organizations in the U.S.

Center for Medicaid and Medicare Services

* National Data Warehouse (NDW)

  • Development of 300+ Business Intelligence (BI) and operational reports (Oracle, Cognos, Microstrategy)
  • Business/user requirement analysis, assessment, validation, recommendation
  • Information Architecture
  • Technical and project lead
  • Data (PHI) and Oracle database migration and administration
  • Assessment and validation of ETL
  • Data and data source validation and modeling
  • User Acceptance Testing (UAT)
  • Training and helpdesk support

NAVAIR

  • * Engineering Investigations
  • Data warehousing strategy and development (Oracle)
  • Research and Analysis
  • Data Warehouse implementation
  • Business Intelligence
  • ETL Methodology and implementation

Carefirst Blue Cross/Blue Shield

  • Data And Information Architecture (DA/IA)
    • Validation/development of a framework for DA/IA
    • Alignment assessment of Data/Information with corporate goals, strategy and IT
    • Recommendation of a framework for integrating information security policies with data pattern
  • Knowledge Management (KM) Architecture
    • Development of a framework and implementation plan
    • Assessment of current technologies and practices
    • Delivery of Proof of Concept using best practices
  • Information Governance/Data Stewardship (IG&S)
    • Validation & document current state of IG&S
    • Define desired “to be” IG&S goals and objectives
    • Analyze gaps between the current state, “to be” state, and CMMI processes
    • Develop strategy and implementation plan to close the gap and achieve the “to be” state

General Services Administration (GSA)

  • Assessment of Data Warehouse and Enterprise Reporting
  • Data Movement: ETLs, other Existing data movement processes (Future Roadmap)
  • Integration with PBS Portal, including OID-based single sign-on and the overall OAS framework (Future Roadmap)
  • Utilization of Oracle DBMS and OAS features, tools, components and best practices (Future Roadmap)
  • Data Security/Integrity (Existing and Future Roadmap)
  • Reporting mechanisms and their efficiency (Existing and Future Roadmap) Scalability, extendibility, maintainability (Existing and Future Roadmap)
    • Recommendations for Optimizing and Improving DW and Enterprise Reporting Architecture