Tools

Cognos Administration, Cognos Connection, Security Configuration

Cognos Framework Manager 10.x, Cognos Transformer

Role

Cognos Administrator

Responsibilities

v Support for Production Non-Prod Cognos environments Servers

v Trouble shoot the environment outage issues

v Resolving the issue related to Cognos Dispatcher Content managers

v Ensure the availability of Cognos environment for the Business groups

v Regularly monitor performance and availability of the Cognos environments

v Recycle Cognos servers as needed

v Design, Develop and test custom code to automate routine administrative and monitoring tasks

v Install and configure various Cognos 10 hotfixes Fix packs

v Weekly vendor meeting with IBM on service request issues

v Lead guide the Maintenance service patch installation

v Provide guidance and consulting and administrative support for Developers, Report Authors and Report Consumers

v Create detailed process and procedural documentation for environmental specifications and user guide etc.,

Project

Confidential

Tools

Cognos Meta Data Modelling, Cognos 10, Cognos Powerplay Transformer, DB2

Role

Business Analyst, Cognos Project Lead

Responsibilities

v Active Participation in Requirements gathering

v Provides guidance on best methods for interface architecture design

v Provides the technical perspective in day-to-day project decisions

v Works with users to ensure the project meets business needs

v Defines requirements for reporting and interfacing

v Communicates with other key business representatives

v Ensures business and functional decisions are made to ensure technical development progress and completion

v Develop, review and refine technical spec

v Initiate any Short / Long term enhancements for the Project

v Ensures functional specifications meeting technical needs for development

v Participate in user sessions throughout the project lifecycle to ensure user issues are addressed in all

v Deliver training and information sessions

v Communicates on behalf of the project or defers to Project Manager

v Supports the project manager and offers mentoring, and coaching when dealing with business

v Acts as vocal project champion

v Actively manages and communicates project risks and issues

v May deliver key project communications

v Provides guidance on overall project direction

v Responsible for any Project Deliverables on behalf of the Project Manager

v Provides the technical perspective in day-to-day project decisions

v Monitors issues and change requests

v Provide the project status to Project Manager for the stakeholders to be aware of

v Report on project status to key groups and individuals Sponsor, Steering Committee etc.

v Gain buy-in from key Business Users and keep their interest and level involvement right throughout the project

Project

Confidential

Tools

Informatica Power Exchange, Power Center, AS400 DB2, Mainframe

Role

Informatica Lead

Responsibilities

v Analyzing the AS IS architecture of Datastage jobs which runs on Mainframe Systems

v Develop the POC to rewrite the existing interface FIRST feed Data Stage v 4.2 / Mainframe using Informatica 8.6.1

v Understanding the existing system design

v Creating the enterprise file based on business rules and derivations

v Validation of policies bypassed at the enterprise level

v Splitting the enterprise file into 17 different format files Merging with previous version files

v Develop the Informatica Design Document

v Create Mapping design on Informatica tool

v Executing the Design Logic and generate the outputs.

v Support for Volumetric and Time Bound Execution Analysis

Project

Confidential

Tools

Cognos Meta Data Modelling, Cognos 8.4, Teradata SQL Server

Role

Sr. DW Developer

Responsibilities

v Interacted with the Business Users to understand the reporting requirements, prepared the report specifications to suit the requirements.

v Used Framework Manager Modeling Tool to create and manage business-related metadata for the report authoring using Cognos 8 Report Studio.

v Developed Models and Packages using Framework Manager and published to Cognos Server.

v Developed complex Dashboards and reports to accomplish various business logics.

v Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level

v Introducing the Java Scripts to derive various business requirements

v Expertise on Reporting Metadata Modeling Estimations

Project

Confidential

Tools

Cognos Meta Data Modelling, Cognos 8.2, Teradata SQL Server

Role

Sr. DW Developer

Responsibilities

v Analyzing the Business Requirements

v Developed very complex reports to accomplish various business logics.

v Involved in Metadata Development Report generations for RTBA and provided technical support to the team.

v Introducing the Java Scripts to derive various business requirements

v Expertise in Quality Process

v Consolidating the Project Metrics

Project

Confidential

Tools

Cognos 8.3, Cognos Framework Manager, IBM DB2

Role

Offshore Cognos Team Lead

Responsibilities

v Preparing project estimation

v Involved in Preparing Project Proposals

v Determining the resource requirements

v Developing appropriate strategies for the implementation of the project

v Assigning the work from functional technical perspectives

v Interacting with clients and all stakeholders.

v Providing strategic and tactical direction to the project team

v Reviewing the status of the project and taking corrective measures as required

v Analysis of Functional Specification document

v Create and publish the Model in Framework Manager

v Design ,Development deployment of RDD Reports

Project

Confidential

Tools

Cognos Report net 1.1, Framework Manager, IBM DB2

Role

Project Lead Onsite Coordinator

Responsibilities

v Analyzing Business requirement directly with Client

v Coordinating with Clients for requirement integration

v Involved in all Project Management AQM Methodology sessions

v Interacting with clients and all stakeholders

v Onsite Coordinator for the project

v Create and publish the Model in Framework Manager

v Assigning the work from functional technical perspectives

v Preparing project estimation

v Developing appropriate strategies for the implementation of the project

v Design ,Development deployment of DCC Reports

v Design of High level Documents, Detailed Design Documents

Project

Confidential

Description

v This project will create a data mart and a series of robust production quality NPI Workflow reports to support the NPI Workflow business process for the NPI Community that contains 4000 users of type Executives, Manager, Technicians, Plant Engineers etc.

Tools

Cognos Report net 1.1, Framework Manager, IBM DB2

Role

Team Leader

Responsibilities

v Assigning the work from functional technical perspectives

v Determining the resource requirements

v Preparing project estimation

v Providing strategic and tactical direction to the project team

v Prepare Functional Technical Specification document

v Prepare Unit Test Case documents

v Design and development of EPO PCI EPO SAI reports

v Migration of reports from CRNDEV to QA / PROD

v Performance tuning and load balancing of complex reports

Project

Confidential

Description

v The NPI Process Workflow reports are a critical tool in the development and management of NPI projects focused on the Tier 4 Emissions challenges and have an estimated Level 3 benefit of 300K per year 75K was agreed to be shared with the EDW team .

v Cognos Report net will be used for providing users with access to data and predefined reports .Users will access functionality in Report net through CAT standard corporate access method.

Tools

Cognos Report net 1.1, Framework Manager, IBM DB2

Role

Team Leader

Responsibilities

v Determining the resource requirements

v Preparing project estimation

v Interacting with clients and all stakeholders

v Reviewing the status of the project and taking corrective measures as required

v Prepare Unit Test Case documents

v Design and development of Dashboard detail reports

v Migration of reports from CRNDEV to QA / PROD

v Security implementation if framework manager based on the user roles

Project

Confidential

Description

v This project is generation I of a multi generational project plan

MGPP that focuses on providing Cat Insurance's Executive Team, Accounting Department, Program Managers, and Auditors post-closing financial data for reporting and analytics. The project will utilize JD Edwards post-closing financial data as the major data source supplemented with other supporting data sources.

Tools

Cognos Report net 1.1, IBM DB2

Role

Team member

Responsibilities

v Analyzing Business requirement directly with onsite coordinator

v Prepare Functional Specification document

v Prepare Technical Specification document

v Design and development of Reports

v Performance tuning and load balancing of complex reports

v Design of High level documents, Detailed design documents, Unit test plans and UTC

v Create a Job in report net and scheduling of reports

Project

Confidential

Description

The Basel II Capital Accord of 1988 was the outcome of an initiative to develop more internationally uniform prudential standards for the capital required for banks' credit risks. New Framework for Capital Adequacy incorporating three main elements or pillars :

Minimum capital rules based on weights intended to be more closely connected to economic risk than those of the 1988 Accord,

Supervisory review of capital adequacy in accordance with specified qualitative principles, and Market discipline based on the provision of reliable and timely information.

Tools

Cognos Report net 1.1

Role

Team member

Responsibilities

v Ensuring of Completeness and accuracy of data for the new system rollouts into data warehouse

v Analysis of E R with QDW.

v Generation of Exception, Rejection and Extraction reports from Staging COGNOS Report net for delta feeds Daily, Weekly and Month end

v Analysis of Exception rejection reports of WB TP systems based on the validation rules

v and functional specification

v Coordinating UAT

v Generation of various exception report addressing data quality issues

v Prepared data quality metrics for the Wholesale bank Data warehouse to analyze the trend of the data quality and also for the TOP MANAGEMENT reporting

v Analysis of various Exception/Rejection occurs during ETL Process.