Cognos Implementation for a Leading Provider of Health Services
Executive Summary:The Company is America's largest not-for-profit health care organization, serving 8.1 million members in 9 states and the District of Columbia. An integrated health delivery system, the Company organizes and provides or coordinates members' care, including preventive care such as well-baby and prenatal care, immunizations, and screening diagnostics; hospital and medical services; and pharmacy services..Why Aviana and Cognos?The Aviana team's expertise with Cognos and Concur (T&E Solution) products was a major plus. The ability to coordinate with Cognos (as a Platinum Certified Partner) was another critical factor in the company's decision process. Also, Aviana's reputation of doing implementations on time and on budget was also factored in. Aviana was asked to implement the following products for the project:
Report Studio® offers comprehensive capabilities that will deliver on all enterprise-reporting requirements with a single solution. Report Studio® provides unrivaled reporting coverage, meeting all the reporting needs within the organization. A single reporting solution to cover the spectrum of business to production reports. These include multi-object, multi-query, multi-page reports. Leveraging the capabilities of the web, Report Studio® enables creation of dynamic web reports, including Web embedded applications directly in the body of reports.
What was the Problem?The company is using Concur, a centrally managed Expense processing system. An Associate submits a travel/expense request to management. Management approves or rejects the request. Upon management approval, the planned expense is assigned a PTA (Pre-Trip Authorization) number. Once the associate generates the expense, they post those expenses against the PTA number using a web based interface that would list all available expenses from the charge card and allow the associate to assign them to the expense report. The Associate then submits the expenses for reimbursement. A back office Audit process evaluates the expenses against the company defined policy to see that the expense meets the requirements. Once the expense report passes management approval and audit approval, it is approved for reimbursement. The reimbursement process will submit payment to the Credit card provider for all approved corporate card expenses; and all approved out-of-pocket expenses will be paid via the associate's payroll check.
The company uses a hosted service from Concur, and Concur provides the company with weekly output files, which are downloaded into an Oracle database at the client side. These tables can be accessed via the Cognos ReportNet to generate back-office audit and management reports. Certain reports will be generated by directly accessing the databases using Cognos Report Studio®. Ad hoc reporting requirements are to be met using Cognos Query Studio®, analysis would be done by creating expense data "cubes" using Cognos Power Play® and publishing the cubes onto the same web site for users to perform analysis..
Aviana's SolutionAviana enabled the company to implement Cognos tools to build Financial and Metrics reports, analytical cubes and create alerts to provide management and employees with a total reporting solution. This enables the management to track, trend and analyze its travel and expense information across the various business units. The availability of this information enables the company to keep track of its expenses, provides for greater efficiency in processing expense reports, allows it to monitor compliance to company expense policies and also enables detection of fraudulent usage of company provided credit card.
Benefits to the Costumer
|
A Slice of Healthcare Advice11/11/2008
Health 2.0 - Major Vendors Bring Electronic Records to Patient's Desktop
Healthcare Related NewsStandards and Certification Criteria to Support Meaningful Use of Electronic Health RecordsDecember 30, 2009 A Message from Dr. David Blumenthal, National Coordinator for Health Information Technology As we look toward 2010, we can envision a transformation of our health system to improve health care quality, efficiency,... Latest Healthcare Headlines
|