Recurring Scope

  • 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


  • Aviana Resource: 1+ FTE (Offshore) 0.5 FTE (Onshore)
  • Aviana Billing: 14 K /month
  • CALNOC Resource Requirement: Business Analyst(s) as needed


  • Microsoft .Net, C#
  • Microsoft SSIS
  • IBM Cognos
  • Microsoft SQL Server
  • Cloud Serve infrastructure