SUMMARY

Cognos professional with 8 years of extensive experience in analysis, design and development of Business Intelligence Reporting Applications using Cognos products.

• Expertise in Cognos 10.2.1 Report Studio, Framework Manager, Cognos WorkSpace, Cognos Workspace Advanced , Cognos 8.x BI suite Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Event Studio, PowerPlay studio , ReportNet 1.1, Transformer.
• Developed DashBoards using Cognos Workspace.
• Expertise in Development and Deployment of Cognos Active Reports.
• Strong Experience in Developing User Interactive Custom Dashboards using Active Reports various controls like Data Decks, Tab controls, Toggle Button Bars etc.
• Experience in Data Modeling- Relational, Multidimensional and DMR dimensionally-modeled relational modeling in Framework Manager.
• Developed and Deployed Report Studio Standard and On-Demand Reports.
• Developed Cognos Report Studio Reports using Master-Detailed Relationships,Drill-through's Custom Conditional Formatting using Render and Block Variables.
• Experience in building and maintaining Powercubes in Transformer using relational, DMR and OLAP packages as data sources
• Developed Complex reports using Cognos 8, ReportNet, PowerPlay and Impromptu
• Performed Query optimization and improved report performance through use of index, aggregate tables and drill-thru functionalities.
• Experience in Upgrading Cognos Reports from Cognos 8.x to Cognos 10.2.1.
• Expertise in installation, configuration and administration of Cognos products in a distributed multi-server environment.
• Involved in administration in Cognos Connection and security implementation among Cognos Applications. Performed administrative roles in Cognos Connection and set security permissions, configured and maintained users, groups and roles using Cognos Administration.
• Good communication skills with strong ability to interact with end-users, customers, and team members.
• Good analytical, problem solving and interpersonal skills. Ability to work on a team environment or independently and handle multiple tasks concurrently.

SKILLS

BI Tools IBM Cognos 10.2.1, 8.x BI Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Event Studio, PowerPlay studio, Workspace, Workspace Advanced,ReportNet 1.1, Transformer, Cognos suite 7.x Impromptu catalogs, Impromptu Web Reports, Upfront

• Programming skills SQL, PL/SQL
• Scripting Languages JavaScript, VB Script, PHP
• Databases Oracle 9i/10g/11g, SQL Server 2003/2005/2008, DB2
• Tools and Utilities SQL Developer, Toad, Erwin, Microsoft Visio, Rational Requisite Pro
• Operating Systems Windows, UNIX
• Web Servers Microsoft IIS, Apache 6.0/7.0, Apache 2.0

WORK EXPERIENCE

Confidential

Sr. Business Intelligence

Responsibilities:

• Involved in Business Meeting with User Groups to gather requirements and developed Detailed Technical Report Specifications.
• Designed and Developed Relational and DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Developed Dashboards using Active Reports.
• Developed List, cross tab, Chart Reports using drill through, master-detail and complex reports which involved Multiple Cascading Prompts in Report Studio.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio models in Framework Manger and development of any new Reports.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Worked on Analysis Studio to develop multi-dimensional reporting. Analyzed Business requirements from the analysts.
• Involved to analyze and map data from source systems to targetoperational data stores and data marts.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Upgrade the report and packages version of COGNOS from 8.4 to 10.2.1 and Participate in the regression testing and unit testing.
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Created reports with Optional filters and custom prompt pages using HTML and JavaScript in Report Studio.
• Developed Dashboard reports to display all the information related to environment using Summary reports.

Environment: Cognos 10.2.1/Cognos 10.x, Cognos 8.x Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Cognos SDK, Transformer and Event Studio , JavaScript and HTML, Oracle Database 11g, 10g, Cognos Windows 7 Professional, XML and HTML.

Confidential

Cognos Developer

Responsibilities:

• Gathered the reporting issues from the users and analyzed user requirements.
• Involved in migrating metadata and reports from Cognos 7.4 to Cognos 8.2 using utilities.
• Assessed the scope for migration and used different approaches of Lift Shift, Compress Optimize wherever necessary for migrating cubes and catalogs.
• Created multiple data source connections for importing different data sources into Framework Manager.
• Created multiple paged, multiple-query reports using multiple prompts for showing selective data on user input.
• Designed relational and DMR models in Framework Manager and published packages to Cognos.
• Implemented data security, object security and package security in Framework Manager.
• Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Created multi-query and ad hoc reports in the report studio and query studio and developed many complex reports for financial analysis.
• Used detail, summary and context filters for making the reports more specific.
• Used conditional formatting, conditional styles and Style variables to render reports for different user needs.
• Created a toggle report that swaps a report layout as list or chart.
• Developed monthly Product Sales Trend, Transactions History and Backlog reports filtered by regions in Analysis Studio.
• Created Sales analysis and summary reports for current year and previous year using Analysis Studio
• Scheduled reports in the Cognos Connection portal to use off-peak hours effectively.

Environment: Cognos 8.2 Framework Manager, Query Studio, Report Studio, Analysis Studio , Cognos Connection, Transformer, Cognos 7.4 Impromptu, PPES, Upfront, IWR , Access Manager, MS SQL Server 2005, migratetoc8, deploytoc8

Confidential

Cognos Developer

Responsibilities:

• Analyzed Business requirements from the analysts.
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Framework Manager Security for Data access, Object level access and Package level access based on the Organization Level.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Upgraded the report and packages version of COGNOS from 8.0 to 8.1 and Participate in the regression testing and unit testing.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Designed models cubes in Cognos 7.2 Transformer using existing IQD's from Framework Manager.
• Worked on Analysis Studio to develop multi-dimensional reporting.

Environment: Cognos 8.0/7x Bi Suite Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Transformer and Event Studio , JavaScript and HTML, MS Visio Standard 2003, Impromptu 7.4, Cognos Power Play 7.3, Cognos Transformer 7.3, Oracle 9.2i client, VB Script, SQL and PL/SQL, IIS, Windows XP Professional.

Confidential

Cognos Developer

Responsibilities:

• Interacted with the Business users for requirement gathering.
• Installed configured Cognos component such as the ReportNet.
• Created the list, cross tab, repeater and Drill-through reports, master-detail reports, prompts, complex calculations, formatting, conditional formatting, Bursting reports, charts and created the reports in different formats like PDF, XML, HTML and CSV.
• Created Cascade Prompts, Bookmarks, Query prompts, Filters, and Multilingual Reports using Report Studio.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various IQD packages in Framework Manager and from this IQD integrated to powerplay transformer to create various models and cubes.
• Used Transformer with a variety of sources and combined them into Multi-Dimensional Cube.
• Configured access manager namespace in Cognos connection and created new users and user groups in access manager.
• Provided technical assistance, training and mentoring to Users and Business Partners

Environment: CognosReportNet 1.1 MR3 Framework Manager, Report Studio, Query Studio , Oracle 9i, SQL Server 2000, SQL, PL/SQL, Windows XP/NT

Confidential Cognos Developer

Responsibilities:

• Worked on Cognos framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Involved in Creating IQD files from Reportnet and designed Powerplay models in Transformer
• Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Created Dashboard reports to get all the information from other reports.
• Production Support, which involves solving user problems.

Environment: Cognos 8.0, Cognos Report net 1.1 MR2 Framework Manager, Query Studio, Report Studio , Impromptu 7.2, Power Play Enterprise Server 7.2, Transformer 7.2, Informatica 7.0, Oracle 9i, T-SQL, XML and HTML.

Confidential

Cognos Consultant

Responsibilities:

• Involved in designing data model and report design.
• Understanding functional specification and preparing technical spec.
• Created report net models, queries according to standards
• Created and publishing packages to Cognos connection.
• Created the user roles in cognos connection.
• Built Power Play Reports in Report Studio by replicating the power play functionality in Report Studio using dynamic Measure selection, Dynamic Sorting, ranking.
• Created Dashboard Reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Customized the Cognos connection portal using existing portlets and customized tabs.
• Worked on complex reports using Static Prompt and MDX functions and union conditions.
• Used Cognos Office Connection to publish the reports in Power point and format them for business presentation.
• Created the Dashboard reports using Report Studio.
• Authoring reports in report studio according to requirement by implementing many features such asprompts, conditional formatting.
• Scheduling the monthly reports with saved prompts using Job Wizard.
• Designed transformer model dimension map, facts regular/calculated .
• Created batch files macros to refresh the cube monthly.
• Deployed the cube from Testing Environment to Production Environment using Batch script.

Environment: Report Net 1.1, Framework Manager 1.1, Cognos Report Studio 1.1 Oracle, DB2.0, Transformer 7.2, Cognos XML, Generic/Cognos JavaScript.