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

¨ 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

¨ 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