Cognos BI and TM1 Developer

Client: Ooredoo - Qatar

Description:
This Project deals with developing dashboards and reports. Designed and publishes packages in
framework manager

Develop active reports for mobiles which will be generated from mobile server, directly to the
smartphone's IBM Cognos app

Develop dashboards with the help of active reports


Responsibilities:
* Installation of Cognos analytics 11.0.8 and upgrade the current content store to latest
version.
* Develop mobile active reports and burst to users connected to the mobile server
* Migrated reports from old version to latest version with the help of Lifecycle tool.
* Developed active reports based on tree prompt which is not available in active reports
using list and deck, the hierarchy works as a tree prompt which can be used as an analysis
studio on select
* Migrate existing reports with JavaScript to latest version using the new custom control
feature.
Environment: Cognos 11.0.x (Report Studio, Cognos Administration, Query Studio, Workspace,
Dashboards, Story), Aginity workbench, Windows 10 Professional.

Client: Essel Propack Limited

Description:
This Project deals with migration and upgradation of existing Cognos to the latest Cognos 11.0.7
(later upgraded to latest version as the project was completed)

Develop New reports with the MFR format as to replace the current hard copy of 140 page to online
Cognos viewer and remove the dependency of files.

Responsibilities:
* Analyzing and reviewed business requirements and technical specifications for report
development.
* Analyzing the current Cognos architecture and upgrade to latest version
* Migrated reports from old version to latest version with the help of Lifecycle tool.
* Created MFR reports for PDF format according to client requirement.
* Develop reports using report booklet to merge 140 page PDF file sourcing from different
cubes together.
* Created Dashboards using new dashboarding technology in Cognos 11.0.x and trained end
users how to use them.
* Scheduled and distributed reports through scheduled management in Cognos connection.
* Trained end users on Query studio on how to create Adhoc reports in Cognos.
Environment: Cognos 11.0.x (Report Studio, Cognos Administration, Query Studio, Workspace,
Dashboards, Story), Aginity workbench, Windows 10 Professional.

Description:
This Project deals with developing dashboards and reports. Designed and publishes packages in
framework manager.

Responsibilities:
* Analyzing and reviewed business requirements and technical specifications for report
development.
* Imported tables into framework manager from different sources like Aginity, Navision and
created relationships between dimensions and facts.
* Developed Complex reports using report studio which includes various report types ranging
from simple lists, crosstabs, legacy charts and visualizations through complex dashboards,
drill through, master-detail and conditional formatting.
* Created multipage reports involving prompts, cascading prompts, conditional rendering and
conditional formatting.
* Involved in troubleshooting of complex reports by identifying query subjects, query item
that needs to be fixed.
* Created Dashboards using new dashboarding technology in Cognos 11.0.x and trained end
users how to use them.
* Deployed the packages and reports from Developments to QA and QA to production
environment.
* Implemented object level, folder level, package level security on Cognos by creating new
security Groups and Roles.
* Scheduled and distributed reports through scheduled management in Cognos connection.
* Trained end users on Query studio on how to create Adhoc reports in Cognos.
Environment: Cognos 11.0.x (Report Studio, Cognos Administration, Query Studio, Workspace,
Dashboards, Story), Aginity workbench, Windows 10 Professional.

Client : Al Maya, Dubai

Description:
This Project deals with developing dashboards and reports. Worked as a Cognos report developer,
responsible for creating custom reports using data in following subject areas: Sales, Purchases and
also build various dashboards using active reports for senior management.

Responsibilities:
* Designed Reports using most of the Report Studio features (Conditional Formatting,
Master-Detail, Drill Through, Conditional Page Layout, and Page Breaks), Prompt pages and
Conditional Variables.
* Used a combination of tabs, page sets, sectioning and master-detail relationships to
create reports with multiple functionalities.
* Created reports using cascading prompts, conditional blocks and conditional formatting to
highlight the data.
* Worked with Aginity to write numerous SQL's for validation.
* Deployed the packages and reports from Developments to QA and QA to production
environment.
Environment: Cognos 11.0.x (Report Studio, Cognos Administration, Query Studio, Workspace,
Dashboards, Story), Aginity workbench, Windows 10 Professional.

Description:
This Project deals with developing and distributing daily financial reports from the data mart.
Worked as a Cognos report developer, responsible for creating custom reports using data in following
subject areas: General Ledger, Forecast and Budgeting and also build various dashboards using active
reports for senior management.

Responsibilities:
* Designed Reports using most of the Report Studio features (Conditional Formatting,
Master-Detail, Drill Through, Drill Down, Drill Up, Conditional Page Layout, and Page
Breaks), Prompt pages and Conditional Variables.
* Calculated metrics for rolling 12 months, YTD, QTD, MTD etc. and modeled Dimensional
Hierarchies with multiple drill paths
* Experienced in creating financial reports and dashboards i.e. Trial Balance, Income
statements, Expense and Budget reports etc.
* Used various MDX functions and drill through against OLAP data source
* Used a combination of page sets, sectioning and master-detail relationships to create
reports with multiple functionality.
* Distributed the reports by using event studio.
* Created reports using cascading prompts, conditional blocks and conditional formatting to
highlight the data.
* Worked with Analysis Studio to develop multi-dimensional reporting.
* Involved in creating technical specification documents
* Deployed the packages and reports from Developments to QA and QA to production
environment.
Environment: Cognos 10.2.2 (Report Studio, Cognos Connection, Analysis Studio, Workspace), SQL
Server2012, Windows 7 Professional.

Description:
This Project deals with developing balance sheets, income statement and various other reports and
dashboards for their financial department using SQL Server database as a data source.

Responsibilities:
* Created Framework relational model, packages and publishing the packages to content store
using Framework manager.
* Created Dashboard report based on the user's requirements.
* Created List and Crosstab reports using cascading prompts, conditional formatting using
Cognos Report Studio.
* Created Drillthrough reports, Master detail reports.
* Developed some complex Reports by using calculated fields in Report Studio.
* Creating Query Prompts, Calculations, Conditions and Filters in the reports.
* Extensively implemented conditional blocks to display/hide the report contents based on
the user selection on the prompt.
* Scheduled and Distributed reports using Schedule Management in Cognos Connection.
* Moving Reports from Development to UAT.
Environment: Cognos 10.2.2 (Report Studio, Cognos Connection, Analysis Studio, Workspace), SQL
Server2012, Windows 7 Professional.

Description:
Worked with leading automotive parts supplier which specializes in sealing, insulation and fluid
transfer systems. This project focuses on building intelligence on productivity by shifts on daily
basis. Objective of the project is to provide ability to analyze plan efficiency to achieve high
productivity. We are tasked to extract of data from excels uploaded by shift mangers, load to data
mart and build and distribute reports.

Responsibilities:
* Created dashboards with area charts, pie charts, crosstab and Multi prompts in Report
Studio using DMR packages.
* Build reports using Report Studio features like Master-Detail, Drill Through, Drill Down,
Drill Up, Conditional Page Layout, Page Breaks, Prompt pages and Conditional Variables.
* Customized data by adding slicers filters at report level.
* Used bursting technique to distribute reports to individual users through email.
* Scheduled the reports according to user requirements and business needs using event
studio.
Environment: Cognos 10.2.1 (Framework Manager, Report Studio, Cognos Connection, Analysis Studio,
Workspace), SQL Server 2012, Windows 7 Professional.

Description:
This Project deals with developing various reports and dashboards for their financial department
using TM1 as a data source.

Responsibilities:
* Creating reports using report studio for finance department for the forecasting and
actuals.
* Created user groups, defined roles, administered Cognos connection; deployed packages and
reports from QA to Prod and performed Cognos server and content store maintenance.
* Extensively used HTML in all the reports for creating dynamic prompts and filters.
* Build various dashboard using active reports for sr. management.
* Handled Performance Tuning of the reports.
* Deployed the packages and reports from Developments to QA and QA to production
environment.

Environment: Cognos 10.2.1 (Report Studio, Cognos Connection, Analysis Studio, Workspace), SQL
Server2012, Windows 7 Professional.