Promote your CV

Submit your CV We will randomly display Cognos related CVs free of charge.

Tuesday, August 19, 2008

Cognos Developer -- 20080819-0001

Email us today if you're interested in this resource.

OBJECTIVE

      I am looking for a challenging position in the IT industry, which shall provide me with opportunities to explore my potential.

educational qualifications

EXAMINATION BOARD INSTITUTION
AGGREGATE

BE, Computer Science And Engineering
Visveswaraih Technological

University

Kalpataru Instituteof Technology,Tiptur
65.10%

II PUC
Pre university Board, Karnataka VVNL PU college

Jogfalls

Shivamogga(dist)


62.16%
SSLC State Board, Karnataka Government High School

Kargal

Shivamogga(dist)


82.32%

Completed Bachelor of Engineering in Computer science and Engineering in the year 2007


SKILL PROFILE

Primary Skills : C, Java, SQL, Data modeling, Data warehousing and BI concepts..
Platform: Windows 98, Windows XP, Linux
ETL Tool: Microsoft SSIS

OLAP Tool:
COGNOS 8: Query Studio, Report Studio. Framework Manager

Experience SUMMARY

    • 1.8 years of experience as a DWH and BI developer at Aviana nrit,Bengaluru.
    • Expertise, knowledge and hands on experience with MS SSIS 2005
    • Extensive experience in Extraction, Transformation, Loading (ETL) data from various Sources into Data Warehouses and Data Marts.
    • Exposure to COGNOS 8(Query Studio, Report Studio, Framework Manager)
    • Zeal and ability to learn new concepts, new tools.
    • Sincere and hard working.


PROJECTS:

1.Project Details

    Insurance BI System
    Client ING Vysya
    Role DWH and BI Developer
    Organization Aviana Nrit limited, Bangalore
    Environment Windows 2000, Cognos 8 BI, SSIS, MS SQL Server 2005,
    Duration Feb 2007 – Jun 2007
Description

The project involve in BI solution (the “Insurance BI System”) for a “standard” insurance company, which gives support to e-Reporting system that can serve as web based analytical reporting process using Cognos suite of BI products. The IBI System will depend on underlying data marts.The IBI System will support the reporting structure followed in the insurance banking industry, and be designed to be customizable according the needs of specific customers. Customizable dimensional model is core of the IBI Data Mart solution. This model serves as a base for rapid implementation of insurance banking business intelligence applications.

Responsibilities:

  • Understanding the Business Requirement and Design as per it.
  • Developed a solution to the need by gathering and analyzing client data.
  • Generated I.Q.D files from Impromptu as a source for power play cubes
  • Performed calculations and conditions in Impromptu reports
  • Knowledge in making the model plans in Power Play Transformer to Generate Power Cubes
  • Standard Reports like Simple to Cross-tab to Group Cross-tab are generated using Impromptu.
  • Multi Dimensional Drill Up / Drill Down Analysis Reports are developed using Power Play
  • Created Levels with in Dimensions for better Analysis using Power play Transformer.

COGNOS Power Play has been used to analyze and present the Cube data in the form of multi-dimensional Reports & Charts.

Team Size: 5


2. Project Details

    General Sales Data Mart
    Client BAJAJ AUTOMOBILE
    Role DWH and BI Developer
    Organization Aviana Nrit limited, Bangalore
    Environment Windows 2000, Cognos 8 BI, SSIS, MS SQL Server 2005,
    Duration JUL 2007 – DEC 2007

    Description:

    The project is involved in Analyze, design and development of Bajaj Motorcycles sales and service maintenance system. The purpose of this project is to build a Data Warehouse database to the Sale Division of the company, which will give a support in generate the multi-dimensional summarized, reports to track the performance on services provided to their customers. This project is overall about claim data analysis. Bajaj Automobile wants to analyze the claims data generated by the system so that they can identify various factors influencing it, look at the trends, optimize through put and reduce losses by way of claims for faulty spares.

    Responsibilities:

    • Understanding the Requirement Specifications & Business Logic.
    • Developed solutions to meet business needs by gathering and analyzing client resource.
    • Developed various Mappings, Transformations for migration of data using SSIS 2005.
    • Used various transformations in SSIS 2005.
    • Done data aggregation while transformation.
    • Extraction of data from the enterprise data warehouse for analytical and multi-dimensional reporting system for specific Corporate Business Unit
    • Developed simple as well as complex reports using Reporting studio.
    • Developed List, Cross tab, Drill through, Master-detail and chart which involved Multiple Prompts, Filters, and Multi-page.

Team Size: 5



  1. Project details:

    General Sales Data Mart
    Client Prism Cements
    Role DWH and BI Developer
    Organization Aviana Nrit limited, Bangalore
    Environment Windows 2000, Cognos 8 BI, SSIS, MS SQL Server 2005,
    Duration JAN 2008 – till date.

Description:

    The project involves in both execution & building a data warehouse Database for the sales department where the data was from different sources of oracle and flat files. The company serves the mass merchandisers, department and independent chain stores .The Company’s mission statement is "Strengthening Both Supplier and Retailer". This is accomplished through providing quality servicing at store level.

    Responsibilities:

    • Understanding the Requirement Specifications & Business Logic.
    • Developed solutions to meet business needs by gathering and analyzing client resource.
    • Developed various Mappings, Transformations for migration of data using MS SSIS 2005.
    • Used various transformations in SSIS 2005.
    • Done data cleansing and aggregation while transformation.
    • Extraction of data from the enterprise data warehouse for analytical and multi-dimensional reporting system for specific Corporate Business Unit
    • Developed simple as well as complex reports using Reporting studio.
    • Developed List, Cross tab, Drill through, Master-detail and chart which involved Multiple Prompts, Filters, and Multi-page.

Team Size: 5

PERSONAL PROFILE

      Name: Naganayan D S
      Father’s Name: Dr D K S Aradhya
      Date Of Birth: 03/10/1983
      Current ctc 1.44 lakhs/annum
      Expected ctc 2.70 lakhs/annum
      Languages: English, Kannada, Hindi.
      Hobbies: Reading novels, Playing Cricket, watching tech shows
      Notice Period: 2 week