Now you can Instantly Chat with Mohan!
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 conceptsShow More
Data & Analytics
Sales and Distribution
¨ 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 CognosShow More Show Less
Manufacturing and Distribution
¨ 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
¨ 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 environmentShow More Show Less