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 | 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
- 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 |
