New Cognos Job

http://c8jobs.blogspot.com/2010/01/senior-technical-specialist.html

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