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

Project

Confidential

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

Confidential

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
• Acts as vocal project champion
• 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
• Provide the project status to Project Manager for the stakeholders to be aware of
• 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

Confidential

Informatica Lead

Responsibilities

• Analyzing the AS IS architecture of Datastage jobs which runs on Mainframe Systems
• Develop the POC to rewrite the existing interface FIRST feed Data Stage v 4.2 / Mainframe using Informatica 8.6.1
• 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

Confidential

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

Confidential

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

Offshore Cognos Team Lead

Responsibilities

• Preparing project estimation
• Involved in Preparing Project Proposals
• 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

Confidential

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

Project

Confidential

Team Leader

Responsibilities

• Assigning the work from functional technical perspectives
• Determining the resource requirements
• 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

Project

Confidential

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

Project

Confidential

Team member

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