Professional Summary

• A Certified Cognos Professional over 11 years of Techno-Functional IT experience in Business Intelligence, Cognos Administration, Design Development of Data warehousing front end Applications
• Proficient in acting as a Technical liaison between the Technology Business Users
• Excellent knowledge on overall Cognos Architecture and Environment
• In-Depth Expertise in using Cognos 7.x, 8.x, 10.1 10.2 comprising Report Studio, Query Studio Analysis Studio, Report Net and Impromptu
• Strong Hands on experience in Cognos Framework Manager Meta Data Modeling Publish Packages
• Good Exposure in Relational Dimensional Modeling using Frame work Manager
• Experience in creating Cognos multidimensional Power Cubes using Transformer
• Proficient in creating High Performance Cognos 10.2 Dynamic Cubes with Cube Designer
• Implemented Advanced Cube modelling capabilities of creating Virtual cubes, Base Historic cubes.
• Solid knowledge of latest technologies Applications such as Mobile BI, Cognos Active Reports, Dashboard Reporting, Cognos RAVE visualization, Business Insight Cognos TM1
• Expert in creating offline Cognos Active Reports and integrate with Ipad, Android Devices
• Outstanding track record of transforming business concepts into state-of-art Cognos Dashboard
• Strong knowledge on Business Intelligence Software Development life cycle
• Expertise in Cognos Administration supporting Cognos Web servers, Dispatchers, Content Managers
• Implement Security on Cognos User Roles and Groups
• Expert in Cognos Environment root causes analysis for any system outages with various log messages
• Install, Configure Tune Cognos Distributed environment
• Provide 24 7 Production System Support
• Expertise in Requirement Gathering, writing Functional Specifications Converting the same to Technical Specifications for the Reporting needs.
• Proficient in Data warehousing / ETL Concepts with hands on experience in Informatica 8.x
• Proficiency on using Oracle OBIEE 11g BI Publisher Reporting tool
• Domain Expert in Manufacturing, Insurance Banking

Technical Forte

• BI Application : Cognos 8.2, 8.3, 8.4, 10.1, 10.2
• Meta data Tool : Cognos Framework Manager, Power Play Transformer, Cube Designer
• Web Based Interfaces : Cognos Administration, Cognos Connection, Report Query Studio
• Business Insight, Cognos Workspace
• Mobile Interface Tool : Cognos Active Reports
• Database : Oracle, DB2, Teradata, SQL Server
• ETL Tool : Informatica 8.6
• Scripting : Windows Power Shell, Java Scripting
• Management Business Analyst Skills
• Collaborate with Business and IT partners to understand the requirements
• Provide Analytics and Reporting Solutions and expertise
• Match Business requirements to IT Solutions
• Serve as a Cognos Subject Matter Expert SME
• Collaborate and Mentor other Team members to share knowledge and best practices
• Responsible for identifying risks along with the respective resolution and risk mitigation
• Experienced in Team management, Effective co-ordination with Business users
• Excellent track record for interacting with the Business for requirement gathering
• Assist Team members and users in utilizing the tools to best of their abilities
• Co-coordinating in preparing Project Proposal Estimation
• Excellent Process Documentation skills
• Proactively communicate and collaborate with users and stakeholders to analyze the current and future requirements of the project and deliver the needed artifacts
• Manage on going support adhoc requests and create training materials and presentation
• Assignments
• The details of the various assignments that I have handled are listed here in chronological order.

Project

Cognos Administration, Cognos Connection, Security Configuration Cognos Framework Manager 10.x, Cognos Transformer Role :Cognos Administrator Responsibilities

• Support for Production Non-Prod Cognos environments Servers
• Trouble shooting for the environment outage issues

• Resolving the issue related to Cognos Dispatcher Content managers

• Ensure the availability of Cognos environment for the Business groups

• Regularly monitor performance and availability of the Cognos environments

• Recycle Cognos servers as needed

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

• Install and configure various Cognos 10 hotfixes Fix packs

• Weekly vendor meeting with IBM on service request issues

• Lead guide the Maintenance service patch installation
• Provide guidance and consulting and administrative support for Developers, Report Authors and Report Consumers

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

Project

Tools

Cognos Meta Data Modelling, Cognos 10, Cognos Powerplay Transformer, DB2 Role :Business Analyst, Cognos Project Lead Responsibilities

• Active Participation in Requirements gathering
• Provides guidance on best methods for interface architecture design

• Provides the technical perspective in day-to-day project decisions
• Works with users to ensure the project meets business needs
• Defines requirements for reporting and interfacing

• Communicates with other key business representatives

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

• Develop, review and refine technical spec

• Initiate any Short / Long term enhancements for the Project

• Ensures functional specifications meeting technical needs for development

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

• Deliver training and information sessions

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

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

• Actively manages and communicates project risks and issues

• May deliver key project communications
• Provides guidance on overall project direction

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

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

• Monitors issues and change requests

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

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

Project Tools

Informatica Power Exchange, Power Center, AS400 DB2, Mainframe Informatica Lead Responsibilities

• Analyzing the AS IS architecture of Datastage jobs which runs on Mainframe Systems
• Understanding the existing system design

• Creating the enterprise file based on business rules and derivations

• Validation of policies bypassed at the enterprise level

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

• Develop the Informatica Design Document

• Create Mapping design on Informatica tool

• Executing the Design Logic and generate the outputs.

• Support for Volumetric and Time Bound Execution Analysis

Project Tools Cognos Meta Data Modelling, Cognos 8.4, Teradata SQL Server Sr. DW Developer Responsibilities

• Interacted with the Business Users to understand the reporting requirements, prepared the report specifications to suit the requirements.
• Used Framework Manager Modeling Tool to create and manage business-related metadata for the report authoring using Cognos 8 Report Studio.

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

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

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

• Introducing the Java Scripts to derive various business requirements

• Expertise on Reporting Metadata Modeling Estimations

Project Tools

Cognos Meta Data Modelling, Cognos 8.2, Teradata SQL Server Sr. DW Developer Responsibilities

• Analyzing the Business Requirements
• Developed very complex reports to accomplish various business logics.

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

• Introducing the Java Scripts to derive various business requirements

• Expertise in Quality Process

• Consolidating the Project Metrics

Project Confidential

Cognos 8.3, Cognos Framework Manager, IBM DB2

Offshore Cognos Team Lead Responsibilities

• Preparing project estimation
• Determining the resource requirements

• Developing appropriate strategies for the implementation of the project

• Assigning the work from functional technical perspectives

• Interacting with clients and all stakeholders.

• Providing strategic and tactical direction to the project team

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

• Analysis of Functional Specification document

• Create and publish the Model in Framework Manager

• Design ,Development deployment of RDD Reports

Project Tools Cognos Report net 1.1, Framework Manager, IBM DB2 Project Lead Onsite Coordinator Responsibilities

• Analyzing Business requirement directly with Client
• Coordinating with Clients for requirement integration

• Involved in all Project Management AQM Methodology sessions

• Interacting with clients and all stakeholders

• Onsite Coordinator for the project

• Create and publish the Model in Framework Manager

• Assigning the work from functional technical perspectives

• Preparing project estimation

• Developing appropriate strategies for the implementation of the project

• Design ,Development deployment of DCC Reports

• Design of High level Documents, Detailed Design Documents

Description 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.

Team Leader Responsibilities

• Assigning the work from functional technical perspectives
• Preparing project estimation

• Providing strategic and tactical direction to the project team

• Prepare Functional Technical Specification document

• Prepare Unit Test Case documents

• Design and development of EPO PCI EPO SAI reports

• Migration of reports from CRNDEV to QA / PROD
• Performance tuning and load balancing of complex reports

Description 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 . 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. Team Leader Responsibilities

• Determining the resource requirements
• Preparing project estimation

• Interacting with clients and all stakeholders

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

• Prepare Unit Test Case documents

• Design and development of Dashboard detail reports

• Migration of reports from CRNDEV to QA / PROD

• Security implementation if framework manager based on the user roles

Description

• 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.

Responsibilities

• Analyzing Business requirement directly with onsite coordinator
• Prepare Functional Specification document

• Prepare Technical Specification document

• Design and development of Reports

• Performance tuning and load balancing of complex reports

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

• Create a Job in report net and scheduling of reports

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.

Team member Responsibilities

• Ensuring of Completeness and accuracy of data for the new system rollouts into data warehouse
• Analysis of E R with QDW.

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

• Analysis of Exception rejection reports of WB TP systems based on the validation rules and functional specification

• Coordinating UAT

• Generation of various exception report addressing data quality issues

• 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

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