Aviana Global Technologies :: A Business Intelligence and Data Warehousing Company

Case Studies

	Case Studies
	Over the last decade, Aviana Global Technologies (AGT) has had a successful track record implementing projects for many clients that include Fortune 1000 companies and some of the largest government agencies in USA. Below is a list of few case studies.
	Cognos ReportNet Development
	Aviana enabled the company to implement Cognos tools to build mission critical reports, analytical cubes and dashboard reports to provide management with a total reporting solution. This enables the management to track, trend and analyze its sales information by various products around it sales offices spread across the globe.
	Hospital Data Mart
	This application gave the hospital a way of loading utilization data into the data mart, and customized tools were developed to allow users to transform and analyze data, and to produce custom reports. This data mart's functionality was subsequently expanded to cover participating hospitals in the state-wide coalition of hospitals, and these findings are used as a part of the hospital's periodic JCAHO Audit.
	Datamart & Reporting Solution for a Biotech Company
	The data mart was modified/appended to serve the Global organizational requirements. The technologies and tools used for development of the system are Oracle, Informatica, Unix Shell scripts, COGNOS ReportNet.
	Web Content Management
	Aviana developed a Website Content Management Tool for the I/T Department of a large hospital, that can be used by the (non-technical) business users. The hospital cares for some 150,000 patients per year, and over 1,000 primary care physicians and specialists attend to these patients, supported by a support staff of many thousands more.
	Agent Policy Processing System
	This system provides a web-based interface for a major Insurance company's agents to process insurance policies. The application was developed using J2EE technology.
	Auto Lease Processing System
	This is the biggest I/T project ever for this international automobile manufacturer. Aviana is participating in the design, development, and implementation of the client's new Customer Service System. The application operates in a hybrid PC-Mainframe environment, with MVS/CICS/VSAM running Alltel's Lease/Loan System; IBM WMQI for message queuing, interfaces and queue transformations; and Microsoft Windows 2000 client desktops and LAN Servers, Microsoft SQL Server 2000 for local/LAN data, Microsoft Visual Interdev/VB/C++/COM+ including MTS, Actuate for Reporting.
	Service Contract Processing System
	Aviana has designed, developed, deployed and continues to support this custom application. The latest version is being developed using Microsoft .Net technology (C#, VB.Net and XML).
	Capital Project Management System
	Aviana is assisting a major Solar Panel Manufacturing company to develop a Capital Project Management (CPM) System that will assess and guarantee the financial performance (Average Rate of Return, Pay Back Period, Net Present Value, Internal Rate of Return etc), technical performance (Output in Kwh, Shaping the peak Demand, Storing Energy for future Considerations etc), and timely completion of contracts for its end users.
	Custom Apps : Oracle E-Business Suite
	Aviana implemented Oracle E-Business Suite for a leading importer of fashion accessories and thus modernized its mission critical financial accounting and operational applications, and created a more agile system capable of accounting for the impact of financial activities on a global scale.
	Freight Tracking System
	Aviana has designed, developed, implemented and continues to support a thin client (intranet-based) custom solution using Microsoft thin-client technology (VB/ASP, SQL Server) to support the worldwide logistical operations of a logistical agency in the Department of Defense.
	HMO Agent System
	Aviana has designed, developed, implemented and continues to support a number of custom applications at a major Southern California HMO including this Broker Administration System based on J2EE technologies.
	Tracking Logistics
	Aviana has designed, developed, deployed and continues to support custom applications for the transportation logistics management company. The new application is being developed using Microsoft .Net technology (BizTalk Server, Eloader, C#, VB.Net and XML
	Bank : Custom Application
	Aviana designed and implemented an integrated application suite that streamlined and automated the entire loan processing workflow for specific loan products offered by a leading multi-state Bank.
	Loan Processing System
	Aviana assisted a leading multi-state bank to develop a Student Loan application that processes the student loans which will be available 24/7 (the old one used to be down for 10 hours each night), and execute at least three times faster than before. The new application is being developed using Oracle database, VB, ASP, C, C++ and Actuate for Reporting.
	Health Insurance Program
	Aviana has designed, developed, deployed and continues to support a health insurance application that provide CHIP and Adult Basic Health Insurance Program for our client.The core of the system uses Internet based EDI to communicate with Business Partners using HIPAA. The solution employs a popular EDI & HIPAA tool from Microsoft, BizTalk Server 2002.