Project Title: Hospital Decision Support System.

  • Client: Apollo Healthcare Hospital.
  • Project Domain: Healthcare domain.
  • Role: Report Developer (Trainee).
  • Environment: Cognos Reportnet 1.1, Oracle 9i, Windows 2000

Project Description:        

                This Apollo Healthcare Hospital system Data Warehousing Cognos Project, which was developed for Apollo healthcare service provider, aims at providing corporate information and hospital statistics that can be viewed by Directors and management or by those who are authorized to see it. The information includes all users registration, payments, consultation statistics, pharmacy, surgery, transplants, equipments, patients and doctors, healthcare bill, multi valued diagnosis, preventive health care, corporate counseling, welfare programmers, claims administration, patient care co-ordination, doctor achievements, staff details and Human Resource. This Project was developed Under Cognos Reportnet1.1 and Oracle 9i used for storing all Hospital modules information.

 Developer Responsibilities:

  • Creating Ad-hoc report using Query Studio and Report Studio.
  • Developed some complex reports by using calculated fields in Report Studio.
  • Involved in designing various prompts like Value prompt, Select and Search prompts.
  • Involved in creation of various linked reports like drill through and master detail reports.
  • Involved in scheduling the reports.
  • Involved in Unit testing.