Recurring Scope

  • Monitor and Manage Cognos, Data Stage and DW SQL environment
  • Monitor, Maintain and Manage daily Data Warehouse loads
  • Maintain security groups for Cognos and Data Stage
  • Deliver ad-hoc development requirements
  • Load yearly budget numbers for quantities and Sales Projections
  • Troubleshooting
  • Research & remediate Data issues

Value Addition

  • Support DW/ BI environment with minimal participation by GSF
  • Zero in-house development/ maintenance resources for the technologies supported by Aviana
  • Continuous availability of DW/ BI environment and SLA adherence
  • Issue resolution in less than one business day more than 95% of the time


  • Aviana Resource: < 0.5 FTE
  • Aviana Billing: 8K /month
  • GSF Resource Requirement: as needed (< 2 hours monthly)


  • IBM Datastage
  • IBM Cognos
  • Microsoft SQL Server
  • Excel (for Budget file)