Daily Sales Reporting Data Warehousing Project

Project Title: Daily Sales Reporting Data Warehousing Project.

  • Project Domain: Sales domain.
  • Developer Role: Report Developer.
  • Environment:  Cognos 8, oracle 9i, Windows 2000.


                        Corporate Food Store company, which is one of the organization that sells various number of products every day. This company has more branches in various locations, which maintains Database has lots of previous customer details, company personal information, raw materials details, etc. This Daily Sales Reporting Data Warehousing Project system has a oracle 9i database which stores information about sales, profits and contacts of various customers. The main aim of sales Data warehousing cognos project is to analyze sales of major brands varying with different promotional schemes.


  • Report development by using Report Studio and Query Studio.
  • Participated in analyzing & designing high level design documents in identifying the errors.
  • Participated in all possible testing of the Reports.

Global Sales Data Mart Cognos project

Project Title: Global Sales Data Mart Cognos project.

  • Project Domain: Sales domain.
  • Developer Role : Report Developer.
  • Environment: Cognos Reportnet 1.1, oracle 9i, Windows 2000.

Project Description:

     The main Achievement of this Global Sales Data Mart Cognos project is to reduce the manufacturing cost of the raw material and improved the sales forecasting by identifying the key factors like the total sales revenue on a monthly and quarterly basis on the region and the sale amount. And the decision support system Data Warehousing Project is focused on analyzing the entire business process. In order to provide critical information like daily revenue, Weekly Revenue, Monthly Revenue, total sales, goals, information on employees and vision of the company developed Business Intelligence System.

Healthcare Hospital system Data Warehousing Cognos Project

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.