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