New Cognos Job

http://c8jobs.blogspot.com/2009/10/cognos-planning-and-performance.html

20090702-001

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

PROFILE

Around 56 Months of IT industry experience. Currently, working as a Senior Software Proffesional for TietoEnator Corporation, Pune for last 2 months. Experience in BI - Cognos 8.

Earlier experience – Worked for HSBC Software Development India Pvt Ltd for 54 months as Senior Software Engineer.

SKILL

Reporting	Cognos 8, Framework Manager, OLAP/DMR Modeling, Report Studio, Query Studio, Analysis Studio, Powerplay-Transformer.
Web Programming:	Core Java, JavaScript, HTML, XML, XSLT
Databases:	Oracle, DB2
MISC	UML, Rational Rose, Quality Center, Dom Doc, Clarity

TRAINING:

CA Unicenter based (At Computer Associates training center - Chicago):

• UR376 Unicenter Service Desk: Analyst Operations
• URV386 Unicenter Service Desk: Administration

Cognos Reporting (At Cognos Incorporated training center - Chicago):

• Cognos 8 BI - Report Authoring - Part 1
• Cognos 8 BI - Report Authoring - Part 2
• Cognos 8 BI - Metadata Modeling - Part 1
• Cognos 8 BI - Metadata Modeling - Part 2
• PowerPlay OLAP Modeling for Series 7 Version 3 & Cognos 8 BI
• Cognos 8 BI - Server Administration
• Cognos 8 BI - Content Administration

PROFESSIONAL EXPERIENCE

TietoEnator Corporation, Senior Software Proffesional (May 2009 – Till date)

HSBC - Pune, Senior Software Developer (Nov 2004 – May 2009)

Project Details:

Project Name:	Gepardi - Mankeli Reporting (Cognos 8 Reporting)
Duration:	May 2009 – Till Date
Organization:	TietoEnator Corporation, Pune
Client:	Elisa Telecommunications, Finland
Summary:	Elisa Telecommunications is Finland’s second largest telecom company. Gepardi is the project contains around 120 applications which are maintained and enhanced by TietoEnator. Out of 120 applications 25 applications are BI applications and Mankeli is one of the 25 applications which is the most important reporting solution as it is the financial reporting for Elisa. Mankeli reporting is used as CMS (Corporate performance management solution) by finance department to report on the sales data on monthly, quarterly, six monthly, year to date and yearly basis. Earlier this project was maintained and enhanced by IBM and we have taken over the project from them. Proper knowledge workshops were organizes at Elisa premises in Finland. I was there at Finland to represent Cognos Reporting area. Also the project involves Informatica and Oracle related work. Cognos system has 12 packages, 5 CUBES, 120 reports and 470 users.
Role:	Development Lead: Attended Knowledge transfer sessions at Elisa premises in Finland by IBM to TietoEnator Corp. Involved in acquiring knowledge about Project Architecture (both technical and business). Involved in knowledge transfer on existing Cognos reporting solution. Prepared resource estimation based on the work for next quarter. Prepared workshop notes which will help the new team members who will join the team. Prepared the ROTA for taking up support stuff
Environment	Cognos 8

Project Name:	Global Service Desk (Cognos 8 Reporting)
Duration:	Aug 2006 – May 2009
Organization:	HSBC GLT Pune
Client:	HSBC USA
Summary:	Global Service desk is service management tool. This will be used across HSBC group to log and record incidents, problem, request, issues, and change order. This application will be implementing the best practices of ITIL recommendation on to the out of box application from CA called Unicenter Service Desk. We are creating reports out of both real time database i.e. Oracle and Data warehouse i.e. DB2 for customers all over the globe in HSBC. We have reports out of relational model and cubes.
Role:	Framework Modeler and Report author. Analysis of user requirements. Involved in Data warehouse design Identify fields from OLTP system to be migrated to Data warehouse depending on reporting requirements Creation of data warehouse requester spreadsheet Written transformation logic to de normalize data warehouse Written scripts to test data in data warehouse in all three environments viz Dev, UAT and PROD Involved in metadata modeling using framework manager. Involved in creation of IQD for input to Transformer. Involved in creation of Dimensional data model. Involved in preparing Prototype (Screen mockups for reports). Involved in preparation of Unit Test Cases Involved in Framework Modeling and peer review. Involved in development of reports. Working as Onsite coordinator at client side in Chicago US. Coordinating with client on user requirements and responsible for all the deliveries from offshore. Involved in development of reports. Supporting the existing reports and working on amendments to reports post production of release 1.
Environment	Cognos 8

Project Name:	Global Service Desk – PLADA Integration (Cognos 8 Reporting)
Duration:	Jan 2006 – July 2006
Organization:	HSBC GLT Pune
Client:	HSBC USA
Summary:	PLADA stands for Performance Level Agreement Database Application. PLADA is tool to document service level agreement between IT Service and business.
Role:	Started analysis of PLADA OLTP system (Oracle). Based on reporting requirements I will be designing data warehouse.
Environment	Cognos 8

Project Name:	Global Service Desk (Customization of CA Unicenter Service desk as per HSBC Global requirement)
Duration:	Jun 2005 – Dec 2005
Organization:	HSBC GLT Pune
Client:	HSBC USA
Summary:	Global Service desk is service management tool. This will be used across HSBC group to log and record incidents, problem, request, issues, and change order. This application will be implementing the best practices of ITIL recommendation on to the out of box application from CA called Unicenter Service Desk.
Role:	Software Developer – Team Member Understanding of design and architectural documents. Involved in preparation of Page Specification and Functional Specification Document. Involved in preparing Prototype. Involved in preparation of Unit Test Cases Involved in coding and peer review. Worked for 18 months as Onsite coordinator at client side in Chicago US. Coordinating with different offshore teams i.e. Development Team, Cognos Reporting Team, Testing Team and Technical Writing Team. Involved in promoting the package from development to UAT and then from UAT to Production environment. Involved in Requirement discussion for Reports (Using Cognos). Involved in development of reports.
Environment	Unix, Oracle, HTMPL and spell code (propriety CA’s Language.)

Project Name:	HSBCnet eSecurities
Duration:	Jan 2005 – Jun 2005 Worked on four releases i.e. Release 8, Release FT2, Release 9 and Release 10.
Organization:	HSBC GLT Pune
Client:	HSBC Vancouver Canada
Summary:	HSBCnet is the service provided by HSBC to its corporate clients. HSBC eSecurities plays the role of custodian. HSBC Securities Services (HSS) provides comprehensive global, regional and domestic securities services to corporate and institutional clients. Development and testing (unit and end-to-end) for eSecurities as per technical specifications provided and to the HSBCnet and the eCommerce CoE general development guidelines
Role:	Software Developer – Team Member Preparation and Understanding of design document i.e. Use Cases, EDR, and IDR. Involved actively in writing Unit test cases and E2E test cases uploading them to Quality Center and also involved in manual execution of test cases. Involved actively in XML, XSLT and Java Coding. Involved in peer-peer testing phase. Worked as Onsite Coordinator for four months at client side in CANADA.
Environment	XSLT, Servlets Using UIMS AND EBSA Framework Web Server/Application Server: WepSphere 5.0 IDE: WSAD 5.1.2

EDUCATION

July 2004

Bachelor of Engineering (Information Technology), RGPV University, Bhopal

Remote Cognos Development Opportunity

Does your organization require temporary support doing Cognos development? If so, then the BI Centre can give you that short term, or long term, support to help you meet your deliverable.

We can assist with model development, report development, SDK coding, testing, QA, technical documentation and even project management.

Feel free to contact us today to discuss your needs.

email: businessintelligencecentre@gmail.com

3+ years Cognos Developer -- 20090125-001

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

Professional Summary

• Having 3+ Years of experience in IT industry of which 2.9 years of experience in the area of data warehousing as a Report developer
• Extensive experience in Cognos Report Net 1.1,Cognos Impromptu
• Having knowledge in Cognos 8, Cognos Power Play and Framework manager
• Developed different types of reports using Report studio, Query studio and Cognos Impromptu
• Excellent knowledge in Data warehousing concepts
• Can play a vital role in the team and able to absorb technical knowledge quickly

Employment History

• Working as a Cognos Consultant for Satyam Computers, hyd, since july2007 to Till Date.
• Worked as a Software Engineer for FCG SOFTWARE, Bangalore from Sep 2005 – July 2007.

Technical Skills

OLAP Tools : Cognos Report Net 1.1, EP 7 Series and Cognos8

ETL Tools : Informatica 7.1.1

Databases : Oracle 9i

Operating Systems : Windows 2000/XP

Languages : C, C++ and SQL

project profile

Project #1

Title : Sales Information System (Aug 2007 to Till Date)

Client : San Miguel Corporation (SMC)

Environment : Reportnet1.1, Oracle 9i

Role : Report Developer

Description:

San Miguel Corporation (SMC), Philippines is the largest publicly listed food, beverage and packaging company in Philippines. SMC's food and agribusiness units make animal feed, Coconut oil, dairy and meat products the scope of this Project is to capture the Sales and Marketing processes and data warehouse to maintain client’s history and current data. Data

From Operational Source System was extracted, transformed and loaded into data warehouse

Responsibilities:

• Developed Master detail, drill through and rank reports by using report studio.
• Created Daily backups by using Cognos Connection
• Reviewed the reports developed by other team members.
• Created HTML Items , packages , templates and reusable components
• Developed Complex reports by using Conditional formatting and Conditional blocking
• Interact with client on a daily basis and Detailed Requirements Study

Project #2:

Title : 7Eleven Sales analysis (May 2006 to July 2007)

Client : 7Eleven, Malaysia

Environment : Cognos impromptu, power play

Role : Report Developer

Description:

7Eleven is one of the largest retail companies operating in Malaysia. It manufactures and distributes a wide variety of retail products. This is designed for the purpose of sales analysis that basically helps the decision makers to analyze the sales. This system helps to keep track the impact of advertising and other promotion on sales. It is also used to test the effects of pricing changes and varying media weights on local markets. It can compare today’s sales results to those of previous year, as well as compare results among chains, geographic regions, and products down to the brand level.

Role& Responsibilities:

• List Reports, Cross-tab Reports and Drill-through Reports.
• Created reports using cascading prompts.
• Created various types of reports Developed for various user levels.
• Queried from different database tables as per the requirement.
• Scheduling the reports.
• Created and enhanced existing Power Cube as per user requirements.
• Imported IQD files created in impromptu into transformer to construct a power cube Involved in optimizing Power Cubes.

Project #3

Title : Extra Mile Sales analysis (Sep 2005 to Apr 2006)

Client : Extra Mile, USA

Environment : Cognos impromptu and Oracle 9i

Role : Report Developer

Description:

Extra Mile, a global scale, it supplies collection of products to consumers like sports products, outdoor products, home appliances and fruits. Extra Mile sales does business in participating suppliers provides the largest selection of high quality merchandise available anywhere. Marketing strategies are based on built purchasing of slow selling, first quality merchandise and reselling these goods at discount prices. Suppliers store products until they are ordered. Reporting requirements are many and diverse and include standard accounting, sales, financial, marketing and inventory.

Role & Responsibilities:

• Have done modifications to the catalogs
• Created Catalog prompts, Conditions and Calculations.
• Created cross tab report, mailing labels reports by using cognos impromptu.
• Created Snapshot, Hot file, Thumbnail reports.
• Worked on giving privileges to the User profiles like Governor settings, Table access, Folder access
• Scheduled various reports

Educational Qualifications:

· BS.C(COMPUTERS)FROM S.K.UNIVERSITY.ATP

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