- 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
Commercial
- Aviana Resource: < 0.5 FTE
- Aviana Billing: 8K /month
- GSF Resource Requirement: as needed (< 2 hours monthly)
Technologies
- IBM Datastage
- IBM Cognos
- Microsoft SQL Server
- Excel (for Budget file)