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.