Mohan A.

Mohan A.

5+ Years of Experience in Software Industry with Cognos skills

Dubai , India

Experience: 5 Years

Mohan

Dubai , India

5+ Years of Experience in Software Industry with Cognos skills

13714.3 USD / Year

  • Immediate: Available

5 Years

Now you can Instantly Chat with Mohan!

About Me

Report Developer and Administrator, having 5+ years of work experience using IBM Cognos business intelligence suite, IBM Netezza and Sql Server Management Studio. Have in-depth knowledge about designing and developing business int...

 

Ø  Having strong working knowledge in Report Studio, Query Studio, Analysis Studio, Workspace and Workspace Advanced, Dynamic Cubes, Cognos TM1 & Framework Manager.

Ø  Proficient in creating dimensional reporting against OLAP source such (DMR, Transformer Cubes & TM1 Cubes) 

Ø  Proficient in creating Drill up, Drill Down, Master Detailed Reports, Prompts (Value Prompt, Text Prompt, Date Prompt) using Report Studio.

Ø  Extensively worked on Conditional Formatting of reports using conditional styles, Render variables and Conditional variables.

Ø  Skilled in designed and developing highly interactive dashboards using Cognos Active reports. Strong understanding using custom visualizations.

Ø  Hands on experience using new Cognos analytics (11.0.x). Well versed building dashboards and stories using Cognos analytics.

Ø  Built data modules using custom datasets, packages and data servers.   

Ø  Designed and Published Packages using Framework Manager – Connecting and testing data sources, created physical layer, business layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, Complex calculations in Framework Manager

Ø  Experience in creating Jobs and Schedules.

Ø  Proficient in writing SQL, have written numerous custom SQL queries to validate reports.

Ø  Good Understanding of Data Warehouse concepts

Show More

Portfolio Projects

Sales and Distribution

Company

Sales and Distribution

Description

¨       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

Show More Show Less

Skills

Cognos

Tools

Windows

Manufacturing and Distribution

Company

Manufacturing and Distribution

Description

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

Show More Show Less

Skills

Cognos SQL

Tools

Windows

BI Developer

Company

BI Developer

Description

¨       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

Show More Show Less

Skills

Cognos

Tools

Windows