5. Installation and configuration of all the suites of Cognos 11 BI products and setting up Content store database, Active directory configuration, and Mail exchange server.
5. Set up Audit tables, Audit Report in Cognos 8.4 Environment to analyse the Report Usage
5. Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used subsets to write union/subtract queries in Report Studio.
5. Creation and updating of Framework Manager Models using best Practices, Determinants creation, hierarchy creation, creating table aliases, resolving loops and cross joins.
5. Implementing security by configuring Cognos with LDAP server.
5. Performance tuning of Reports, Prompt Pages to ensure high performance standards for Reports.
5. Report testing & Defect fixing.

Description

IBM Partner World is a program developed for any business that wants to partner with IBM. Business Partners come from companies small and large; from those that sell IBM to those that use it; from traditional resellers to new, born-on-the-cloud companies; from solutions architects to deployment experts. It make the partnership about you — first and always.

My Responsibilities:

5. Lead Technical contributor for enabling and new and existing tenants on enterprise BI platforms.
5. Monitor Cognos environments to provide usage and performance metrics
5. Monitor systems capacity and performance, plan and execute disaster recovery procedures
5. Responsible for managing key business executive reports with Merchandising Reporting & Analytics team.
5. Worked on Migration from Cognos 10.1 to Cognos 10.2.1.2.
5. Creation of new Framework Manager Models using best Practices, Determinants creation, hierarchy creation, creating table aliases, resolving loops and cross joins.
5. Implementing security by configuring Cognos with LDAP server.
5. Created several parameter maps, calculations and relationships in Framework Manager
5. Performance tuning of Reports, Prompt Pages to ensure high performance standards for Reports.
5. Creating Documentation as per high documentation standards of the Client.
5. Report testing & Defect fixing.
5. Auditing the changes done by portal. (Using XML generated from portal)

Description

Office Depot & Office Max is a retail organisation which used to sale all the office related products like Laptop, Desktop, Furniture and other office related entities. This is a Development, Maintenance, Production Support based project. Almost all the main flavours of Cognos are being used in this project. Office Depot Data Warehouse is a collection of data that consists of numerous Office Depot subject areas: Sales, Inventory, Customer, Item, Sales Force, Compensation, etc.

My Responsibilities:

5. Responsible for managing key business executive reports with Merchandising Reporting & Analytics team.
5. Requirement gathering from business users, design and leading the implementation of new reporting solutions.
5. Simplified/Optimized and automated the report generation process for Legacy banner reports by optimizing the SQL scripts, eliminating unnecessary steps.
5. Handling Vendor reporting team in terms of planning & tracking tasks, providing training on reports/database/ business and guidance to resolve the issues/challenges.
5. Development of Cognos reports and framework manager models (DMR as well as relational).
5. Responsible to provide Analytical & Technical Database solutions to the business problems in order to get the maximum business gains in terms of standard reports and process Automation.
5. Performed process improvement using Bursting.
5. Creating “High-level Design” document and “Source to Target” mapping document.
5. Has done extensive formatting to get the desired output.
5. Has created reports by Area, Region and by Month and Week.
5. Scheduled the reports as per the user requirement.
5. Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.
5. Trained users on Query Studio for Ad-Hoc reporting.

Description

John Hancock is an Insurance company of USA having its head office in Boston, Massachusetts. This is a Development, Maintenance, Production Support based project. Almost all the main flavours of Cognos are being used in this project. This project can be divided into different.

Module I) ACT Implementation:

Team Size: 5

Description: This is based on Cognos SDK and Report Studio. After running each report, output should be downloaded and merged with the help of Java to deliver to LAN path of user.

Module ii) POC Activities:

Team Size: 7

Description: I have been involved in many POC activities at this project for example Focus Dynamic Parameter based report running from SDK, RPS Demo for FM model and package-cube, Dashboard, Active reports, Create One Package Development for Mutual Fund, Mars Demo; LTC Demo etc.

Module iii) Upgrade from Cognos 8.2 to Cognos 10.1.1 to 10.2.1:

Team Size: 5

Description: This is the upgrade project from Cognos 8.2 to Cognos 10.1.1, then from Cognos 10.1.1 to Cognos 10.1.2. We have upgraded almost 2000 reports, 30 cubes in 16 servers for 3 different environments.

Module iv) Cognos Administrative Activities:

Team Size: 3

Description: Data Source creation in Cognos Connection, package migration across development and production environment, Deployment of Reports Data from one Environment to Another Environment, troubleshooting etc.

Module v) Providing Production Support and Maintenance:

Team Size: 6

Description: This is periodic activity. One person must provide each month Production Support and Fix issues related that. There is a Scheduling Tool (CA Automation Tool) available which schedules reports, Cognos Jobs, Cube Generation, triggers etc.

Description

Reckitt Benckiser (RB), the global CPG major has successfully implemented a sales tracking system – DAILY SALES, which is designed to be used by local businesses to provide local management, Marketing Managers, Sales Managers and executives with sales information of their products daily and control critical business performance. Daily Sales application has been built using Microsoft Analysis Services running on SQL server 2008 database and Reporting Tool – COGNOS.

Responsibilities

5. Development of Model in Framework Manager as per the Client Requirement.
5. Created complex reports using Report Studio including prompt pages, conditional blocks
5. Created of Basic and Advanced Reports like list, Cross tab, Chart and Rank reports
5. Designed and developed Prompted reports, Drill Through reports
5. Created a Master Detail query report
5. Created distinct types of prompts and filters.
5. Production Support activities including – trouble shooting, scheduling reports and administration