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

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

New Cognos job!

http://c8jobs.blogspot.com/2008/08/finance-systems-analyst-and-programmer.html

Cognos ETL Specialist 20080619-0001

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

Current Location : In Singapore, On Social Visit Pass

EDUCATIONAL QUALIFICATION

Bachelor’s Degree in Mechanical Engineering 2005

SK University, Kurnool, India

TECHNICAL SKILLS

ETL Tools : Cognos8, Business Objects, DataStage 7.5.2 Enterprise Edition, DataStage 7.5 Server Edition

Reporting Tools : Cognos, Business Objects

Languages : C, C++, SQL, PL/SQL

Operating Systems : Win 95/98/NT/2000/XP, Unix

Databases : Oracle 8.i/9.i

Other Tools : TOAD

CERTIFICATIONS

• Quality Management Systems(QMS) Satyam Computer Services Pte Ltd, India
• SQL – OCA Oracle, India

TRAININGS

• Oracle, Unix Training at Satyam Computer Services.
• DataStage Training at IBM in April ‘07.
• Cognos and Business Objects Training at Satyam Computer Services in Feb’08

CAREER SUMMARY

• More than 2 yrs. of experience in Data Stage - ETL Developer and Cognos.
• Involved in Functional and Technical Systems Analysis & Design, Systems, Star Schema, Snowflake, changing dimension and Documentation.
• Developed server and parallel jobs using different types of stages such as Transformer stage, Lookup Stage, Join stage and created the Reports in Cognos according to the requirement.
• Implementation of ETL (Extraction, Transformation and Loading) methodology using DataStage.
• Integration of various Data Sources like Oracle and Flat files into the Staging Area.
• Good knowledge in Database Concepts.
• Strong knowledge in Data warehousing concepts and hands on experience in Data Stage and Cognos.
• Have Good Programming knowledge in SQL, PL/SQL.
• Strong Understanding of Software Lifecycle Methodology.
• Experience in functional analysis, establishing business rules and process flows.
• Excellent User interaction skills.
• Having Good Communication Skills, Can learn new Technologies and Tools quickly.

EXPERIENCE

Mar 06 – Till Date Satyam Computer Services, Hyderabad, India

Software Engineer

Oct 07 – Apr 08

Project 3 GNE (Gulf & Near East) – Secondary Sales Reporting System

Client GSK (Glaxo Smithkline), UK

Team Size 6

Environment Cognos 8, DataStage 7.5.1, Oracle 10g, TOAD, UNIX

Project Description

GNE – Secondary Sales Reporting system is to develop reporting solution for GSK Gulf and Near East (GNE) which would provide easy access and drilled-down capability to retailer level. This is expected to improve the decision making by providing data with multidimensional analysis. The Secondary Sales reporting system is to replace existing excel based reports and provide additional functionality to enhance analysis and reporting capabilities.

Responsibilities

• Designed and Created Reports in Cognos.
• Authored Report Specifications.
• Documented Package Configuration and System test case.
• Involved in Unit Testing and System Testing

Jun 06 – Sep 07

Project 2 DRSF (Data Reporting System Foundation)

Client GSK (Glaxo Smithkline), Ware, UK

Team Size 30

Environment DataStage 7.5 Enterprise Edition (Px), Oracle 10g, TOAD, UNIX

Project Description

GlaxoSmithKline (GSK) is a world leading research-based pharmaceutical company. The Data Reporting System Foundation (DRSF) will provide a system for automatically gathering information from a range of sources by automatic and manual means. This information will be stored, processed and presented to the users of the system in a form that they can readily analyze.

Responsibilities

• Analysis of the specifications provided by the client.
• Developed parallel jobs for extracting, Transforming and loading the required data into Foundation Layer.
• Used Datastage designer to create mappings (jobs) using different types of Stages such as Transformer stage, Lookup stage, Sequential file Stage, Sort stage, Join Stage etc.
• Developed jobs in the Local containers.
• Designed and developed job sequences for parallel jobs according to the requirement.
• Used DataStage director to validate, to test and to monitor the resulting executable jobs.
• Interaction with the onsite team.
• Involved in unit testing by authoring and executing the unit test cases
• Adhered to Quality procedures related to the project.

Jul 06 – Oct 06

Project 1 PMAR (Profit Management Analysis & Reporting)

Client GSK (Glaxo Smithkline), UK

Team Size 16

Environment DataStage 7.5.1, Cognos, Oracle 9i, TOAD, UNIX

Project Description

PMAR (Profit Management Analysis & Reporting) is used for analysis of profit & associated financial details of GSK. The Analysis is done for two establishments of GSK, namely GSKE (Glaxo & SmithKline Exports) and GSKTS (Glaxo & SmithKline Trading Services).

Responsibilities

• Preparing Unit Test Case Documents for Data Stage jobs.
• Preparing System Test Case Documents for Data Stage jobs.
• Reviewing SQL Queries using TOAD.
• Unit Testing for Data stage jobs.
• System Testing for Data Stage jobs.
• Created Simple jobs in Ascential Data Stage.
• Prepared documents for the UAT.
• Checked the Data Integrity in both JDE and Data Stage.
• Created Deployment Document for production support.

COMPENSATION DETAILS

• Currently on 4 Lakhs Indian Rupees per annum, plus Medical for self and parents, plus annual Leave Travel Allowance, and 15 – 25% annual Appraisal.

NOTICE PERIOD

• Available Immediately

New C8 SDK Utility --- Cognos 8 Modification Check

http://bicentresdkguide.blogspot.com/2008/05/new-c8-sdk-utility-cognos-8.html

Cognos Developer in New York

http://c8jobs.blogspot.com/2008/05/cognos-developer-in-new-york.html

Cognos Data Warehouse 20080322-0001

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

Objective

To work in a challenging and progressive environment where, I can contribute for achievement of goals of the organization and my growth.

Summary

1 year of total experience in IT industry, with 1 years of experience in Data Warehousing using PL/SQL, tools like Cognos 7,Cognos 8,SAP BW.

Work Experience

o Working as Software Engineer in HCL Technologies Ltd, Chennai from Jan 2007 to till date

Qualification
o Master of Computer Applications from Anna University with 78% in 2007.
o Bachlore of Computer Application From Bharathiyar University with 68% in 2004.
o Higher secondary from Immaculate with 61.5% in 2001
o 10th from Immaculate with 66% in 1999.


Assets

o Good communication skills.
o Excellent analyzing skills, good grasping capabilities and ability to learn new things.
o Self directed, self motivated and committed individual.

Skillset

Reports : Cognos 8,Cognos 7 & SQL server 2005(SSRS)

Databases : Oracle9i/10g, SQL server 2005

Languages : C,C++, SQL, PL/SQL, UNIX Shell Script

DB Related : TOAD 7.3, SQL Loader

Operating Systems : Windows NT/2000, UNIX & Linux.



Project Profile

Project # 1

Title : CODMAN SALES REPORTING.

Client : JOHNSON & JOHNSON, US

Duration : Jan 2008 – Till date

Team Size : 6

Environment : Cognos 8.2,ORACLE 10g,Unix.

Project Description:

JOHNSON & JOHNSON (J & J) was one of the leading pharmaceutical company. Codman is a group of this J &J company. This project was initially kicked off as a migration of reports from Cognos 7 series to Cognos 8. But the client needed few alterations in the reports. So the project then started as a development project. Reports were generated on varios categories like Sales vs Objective (SVO), Monthly and Daily basis, Business Reporting.

Specifications were given to the developers which had the report layout and query that generated the reports. These requirements were gathered by my onsite lead.


Responsibilities carried out:

o Was involved in the model creation in Framework Manager.
o Created relationships, cardinalities and calculations at the FWM level to satisfy the given query.
o Developed complex reports which involved creation of many queries and joining them at the Report Studio level.



Project # 2

Title : DB- FSR Rollout.

Client : Deutsche Bank, Singapore

Duration : Jun 2007 – Jan 2008

Team Size : 20

Environment : Cognos 8.2/8.3, SAP BW.

Project Description:

Deutsche Bank is one of the world's leading financial service providers. Rollout of FSR happened for Honk Kong, Korea, Indonesia and Singapore. It is an Onsite-Offshore model of development project we have developed around 550 reports using cognos Report studio and few query studio reports. Reports has been developed in the Dev environment and after the quality process reports has been moved to the QA and PROD successfully.

The functional design documents provided by the client, Deutsche Bank, were presented in Excel format. The same was then replicated in Report Studio. A concept called Cell Based reporting was followed in which a data item is assigned only one value at which it is placed. This is called RFP (Report Form Position). The value against the RFP is stored in the source database i.e. SAP BW. Cognos picks up the values against the RFP from BW and populates the values for that particular position. A share point was maintained from where the defects raised by the users were taken and then fixed based on the priority. Versioning of the reports were to be maintained to make sure that the last updated report was worked upon the defects. This last updated report was then used for migration to the corresponding environment.

Responsibilities carried out:

o A total of 190 Indonesian reports were handled.
o Tested, validated and migrated the reports to different environments during the implementation phase at onsite (Singapore).
o Fixing the defects as per the priority and updating the same in the share point.
o Change Request for all the regions were handled effectively.



Project # 3

Title : PnC DashBoard

Client : HCL Technologies

Duration : Apr’2007 – May’2007

Team Size : 6

Environment : Cognos 8.2,TOAD 7.3, Oracle 8.1.7

Project Description:

* Created Metadata models from the DWH ORACLE database schema.
* Developed models using star schema grouping.
* Created short-cuts to resolve some join issues.
* Created folder structure and namespace to maintain Database view and presentation view.
* Developed Report design specification for few reports.
* Created list and cross-tab reports as per report design spec.
* Created two dashboards based on the given reports as per requirements using ReportStudio.




Project # 4

Title : Hospital Management System

Client : HCL Tecnologies.

Duration : Jan 2007 – Apr 2007

Team Size : 2

Environment : SQL Server 2005(SSAS,SSRS), TOAD 7.3,Oracle 8.1.7

Project Description:

* We have moved the source data to staging area database using SQLSERVER scripts.
* From staging area to DWH SQLSERVER database we used sort, merge, and join, aggregate transformations using SSIS.
* We have designed the Metadata model using star schema using SSAS.
* We rectified some join issues in the model.
* Created four cubes using SSAS.
* Created reports like list, cross-tab, charts using SSRS.
* Used some of the features like Drill-through, KPI, drill-down and conditional-formatting using SSRS.
* Created reports are scheduled as per the given frequency period.

New Job Posted!

http://c8jobs.blogspot.com/2008/01/reporting-developer-analyst-20080124.html

Cognos 8 Migration Specialist 20080124-0001

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

Primary Skills: Series 7 to Cognos 8 Migration Specialist

Location: Waltham, Mass USA

Years Experience: 12 years

Introduction: I have been using the Cognos BI suite of products since 1998 and I have recently gained significant project experience using Cognos 8.2.

Recent Projects:

Project 1.
Worked as a primary consultant for a leading insurance specialist. My main task was to upgrade their 300 Impromptu reports and user interface into a Cognos 8.2 infrastructure. This involved establishing a migration plan, series of user acceptance unit testing, generating documenation, and providing general training on the usage of Cognos Connection, Report Studio, and Query Studio.

Project 2.
Employed as a primary consultant the United States Department of Defense. I was directly involved with reviewing their Cognos Impromptu catalogue and 220 Impromptu reports before planning a migration strategy to Cognos 8. This involved interaction with their Business Analysts to review their current and near future reporting requirements.

BI Consultant / Oracle DBA 20080116-0001

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

Primary Skills: Oracle DBA/Datawarehouse, Cognos 8.1 MR1, Informatica ETL

Location: San Francisco, California USA

Years Experience: 8 years

Introduction: My 8 years experience involves mainly working as an Oracle DBA that was responsible for working with a Fortune 500 Data Warehouse. I was involved with supporting the Warehouse design, generating Cognos reports and testing Cube development. I am looking for a position as a Senior Cognos Developer in the California area.

Recent Projects:

Project 1.
Responsible for Oracle 9i upgrade to 10g sizing around 300GB running on Solaris server for a Fortune 500 company.
• Database upgrade, and performance tuning
• Data Mart creation, data repository/metadata creation/management
• Database Backup/Recovery strategy/Planning
• Cognos 8 BI Server, Framework Manager installation and data modelling
• Reports design/development using Cognos Query Studio and Report Studio, add/manage/schedule tasks using Event Studio

Project 2.
Responsible for administering multiple Oracle 9i production databases, which were around 5TB running on Compaq Alpha servers using Compaq TRU64 Unix. Managed 7 Oracle development instance on Compaq Tru64 Alpha servers and 2 Oracle 9i instances on Sun Solaris servers.
• Database Performance Tuning
• Datawarehouse management (i.e. data profiling, data quality metrics, cleansing, transformation, mapping and loading into multiple targets)
• ER Data Modelling using Erwin 4.x
• Cognos 8 Framework Manager, report development using Query Studio and Report Studio
• Cognos Event Studio
• Implemented Peoplsoft HRMS data mart to Warehouse
• Informatica Infrastructure, installations, patch application
• Team Lead support services for a project of 34 resources
• Applied database upgrades and patches on yearly maintenance cycle
• Installation of Dev, QA, and PROD database instances
• Database Backup/Recovery strategy/Planning

Cognos Consulting will post your CV for free

Welcome to our blog where we match Cognos consultants with potential employers. If you're an IT recruiter, corporate head hunter, or just a HR rep looking to fill a Cognos position within your organization then you have come to the right place to find your Cognos talent.

We will post Cognos CVs free of charge so that you can find the skill set that you need to help make your project a success.