Promote your CV

Submit your CV We will randomly display Cognos related CVs free of charge.

Saturday, March 22, 2008

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.