PROFILE:

Around 11 Years of IT industry experience. Working as Sr Cognos Cosnultant Experience in design and development of Cognos BI and TM1 administration/application.

SKILL:

Operating System: Windows 2008 R2 and Linux RHEL

Reporting: Cognos 8.x and 10.x, Framework Manager, OLAP/DMR Modeling, IQD Creation using FM, Report Studio, Query Studio, Analysis Studio, Powerplay - Transformer, Active Reports.

Cognos Administration: Cognos Installation BI, Content Store Setup, Security Setup, Content Administration - Export and Import, Data Source Creation, Setting up logging and Auditing. Cognos Installation TM1 - Installation and Integration with Cognos BI for security.

FPM: Cognos TM1 10.1, 10.1.1 and 10.2 - Creation of Dimension and CUBEs, Writing TI process for data load, Writing RULEs and FEEDERS for consolidated values and consolidation, Creation of TM1 Contributor Approval Application, Reporting with Cognos Insight. IBM Cognos TM1 10.2 Balance Scorecard

Application Server: WAS 7.x and 8.x, Tomcat Apache.IHS and IIS for Web Service Hosting.

Databases: SQL Server 2008, Oracle, DB2.

Testing Tool: Quality Center.

Others: JavaScript, HTML, XML.

Cognos Version Worked On: FM and Studios: 8.x, 10.1, 10.1.1 and 10.2.1 TM1: 9.5.2, 10.1.1, 10.2 and 10.2.2

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Responsibilities:

• Responsible for Installation of Cognos BI and TM1 Server setup.
• Responsible for Requirement Gathering.
• Responsible for designing solution.
• Responsible for estimation.
• Responsible for creation of Dimensions and CUBEs.
• Responsible for writing Rules and Feeders.
• Responsible for preparation of Unit Test Cases
• Responsible for Security setup to make relevant Cubes available to respective users.

Environment: Cognos BI 10.2.1 and TM1 10.2

Confidential, NYC

Responsibilities:

• Worked BI Architect and designed Cognos BI server architecture for Cognos BI 10.2.1 FP1 installation on 5 Linux box cluster.
• Installation and Configuration of TM1 10.2 on Windows 2008 R2
• Deployment of Cognos BI component on WAS 8.5 and configured web server HIS.
• Security setup using LDAP.

Environment: Cognos BI 10.2.1 and TM1 10.2

Confidential, NYC

Responsibilities:

• Responsible for Requirement Gathering.
• Responsible for designing solution.
• Responsible for estimation.
• Responsible for creation of Dimensions and CUBEs.
• Responsible for writing Rules and Feeders.
• Responsible for preparation of Unit Test Cases
• Responsible for Contributor Application.
• Responsible for Security setup to make relevant Cubes available to respective users.

Environment: Cognos 10.1 TM1

Confidential, NYC

DW/ETL Tool: SQL Server 2008/ SSIS

Responsibilities:

• Responsible for Requirement Gathering.
• Responsible for designing solution.
• Responsible for estimation.
• Responsible for creation of FM Packages for input to Transformer.
• Responsible for development of Transformer CUBE.
• Responsible for preparation of Unit Test Cases
• Responsible for development of reports using CUBE as Package.

Environment: Cognos 10

Confidential

DW/ETL Tool: SQL Server 2008/ SSIS

Responsibilities:

• Responsible for Requirement Gathering.
• Responsible for designing solution.
• Responsible for estimation.
• Responsible for creation of FM Packages for input to Transformer.
• Responsible for preparing Transformer CUBE.
• Responsible for preparation of Unit Test Cases
• Responsible for development of reports.

Environment: Cognos 10

Confidential

DW/ETL Tool: SQL Server 2008/ SSIS

Responsibilities:

• Responsible for Requirement Gathering.
• Responsible for designing solution.
• Responsible for estimation.
• Responsible for creation of FM Packages for input to Transformer.
• Responsible for preparing Transformer CUBE.
• Responsible for preparation of Unit Test Cases
• Responsible for development of reports.

Environment: Cognos 10

Confidential

DW/ETL Tool: SQL Server 2008/ SSIS

Responsibilities:

• Responsible for Requirement Gathering.
• Responsible for designing solution.
• Responsible for estimation.
• Responsible for creation of FM Packages for input to Transformer.
• Responsible for preparing Prototype (Screen mockups for reports).
• Responsible for preparation of Unit Test Cases
• Responsible for development of reports.
• Responsible for review of solution from offshore prior to delivery to onsite.
• Supporting the existing reports and working on amendments to reports post production
• Went to UK for a month to understand the project requirement.

Environment: Cognos 8

Confidential

DW/ETL Tool: SQL Server 2008/ SSIS

Responsibilities:

• Responsible for Requirement Gathering.
• Responsible for designing solution.
• Responsible for estimation.
• Responsible for creation of FM Packages for input to Transformer.
• Responsible for creation/updating of CUBES.
• Responsible for preparing Prototype (Screen mockups for reports).
• Responsible for preparation of Unit Test Cases
• Responsible for development of reports.
• Responsible for review of solution from offshore prior to delivery to onsite.
• Supporting the existing reports and working on amendments to reports post production
• Went to UK for a month to understand the project requirement.

Environment: Cognos 8

Confidential

DW/ETL Tool: Teradata/Ab-Initio

Responsibilities:

• Responsible for creation of IQD for input to Transformer.
• Responsible for creation/updation of CUBES.
• Responsible for preparing Prototype (Screen mockups for reports).
• Responsible for preparation of Unit Test Cases
• Responsible for development of reports.
• Supporting the existing reports and working on amendments to reports post production

Environment: Cognos 8

Confidential

DW/ETL Tool: DB2/DataStage

Responsibilities:

• Analysis of user requirements.
• Responsible for 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
• Responsible for metadata modeling using framework manager.
• Responsible for creation of IQD for input to Transformer.
• Responsible for creation of Dimensional data model.
• Responsible for preparing Prototype (Screen mockups for reports).
• Responsible for preparation of Unit Test Cases
• Responsible for Framework Modeling and peer review.
• Responsible for development of reports.
• Worked as Onsite coordinator at client side in Chicago US for 19 months. Coordinating with client on user requirements and responsible for all the deliveries from offshore.
• Responsible for development of reports.
• Supporting the existing reports and working on amendments to reports post production.

Environment: Cognos 8