Aviana

BI & DW Solution for the Largest Bank in North America

Client:       Largest Bank in North America

Project:     BI & DW Solution - Onsite / Offshore Model


Executive Summary:

The client articulated a vision for its future IT infrastructure that spans interaction and workflow systems, transaction processing systems and reporting systems. Aviana participated in the design, development, and implementation of the client's new Customer Service System. This was the client's biggest IT project ever.

What was the Challenge?

The client required a reliable onsite/offshore model solution to handle their marketing and credit data marts. Some of the key challenges included:
  • Identify the clear-cut process for complete onsite and offshore activities.
  • Establish proper communication process between the end users, onsite team and offshore team.
  • Define highly secured process to access onsite staging server for data access, deployment and testing.
  • Version control of all documents, scripts, etc to make sure that onsite and offshore are always in sync.
  • Clear detailed document standards followed to make sure that the offshore understands the requirements clearly for design, development, testing and deployment.
  • Regular periodic status update to onsite to make sure that the project is as per schedule.
  • Utilize the benefit of offshore cost benefits, time difference (between onsite & offshore locations), high quality output and demonstrate better ROI.

Why Aviana?

Apart from Aviana's onsite development center, the company has a full-fledged offshore development center, which has the required infrastructure in terms of Hardware, Software, Network, highly skilled technical manpower and high-speed communication facilities amongst others. Aviana's offshore development center is ISO 9000 compliance and follows high quality processes to handle offshore activities.

Aviana's Solution



The high-level development process is described:






The Communication process is shown below:




The solution included:
  • Data extraction (ETL activity) from more than 10 source data systems which included mainframe applications, Excel® spread sheets and Foxpro® databases, using the Informatica® ETL tool
  • Development of Data Marts
  • Framework model design using Cognos® design tool (Framework Manager)
  • Web-based report development using Cognos® reporting development tool (Reports Studio)
  • User security access using Cognos® Access Manager
  • Development and Unit testing at the offshore development server
  • Integration and system testing on onsite staging server
  • Deployment and user acceptance testing
  • Offshore production and maintenance support


Financial Services Related News

Driving performance with EP

The dynamic business environment - continuing deregulation, advances in technology, new disclosure requirements, wary investors - creates both challenges and demands for accurate business planning and forecasting.

Read All Financial Services News


Latest Finance Headlines

 
  • Loading...
    Please wait