- Requirements Gathering from the SMEs
- Design, Develop and deploy web application, Data mart and reporting enhancements
- Monitor and Manage application, Data mart and Cognos environment
- Manage offshore delivery
- Monitor, Maintain and Manage daily Data mart loads
- Maintain security groups for web application, Cognos and DW
- Deliver ad-hoc application changes and reporting requirements
- Troubleshooting
Value Addition
- Support Application, data mart, BI, Application environment with minimal participation by CALNOC
- Zero in-house development/ maintenance resources for the technologies supported by Aviana
- Continuous availability of Application environment and SLA adherence
- Issue resolution in less than one business day more than 98% of the time
Commercial
- Aviana Resource: 1+ FTE (Offshore) 0.5 FTE (Onshore)
- Aviana Billing: 14 K /month
- CALNOC Resource Requirement: Business Analyst(s) as needed
Technologies
- Microsoft .Net, C#
- Microsoft SSIS
- IBM Cognos
- Microsoft SQL Server
- Cloud Serve infrastructure