Description :

1. Interacting with the business users to gather business requirements and designing the functional and technical requirement documentation.
2. Implementing the SDK script provided by Cognos support to perform different functionalities.
3. Developing the transformer models using power play transformer (OLAP) and also developing models using Cognos 8.3 / Cognos 8.4 /Cognos 10.1 transformer.
4. Modifying power cubes by adding new dimensions, levels and measures etc.
5. Publishing cubes directly from Cognos 8.3/Cognos. 8.4 / cognos 10.1 transformer using new publish functionality.
6. Proficient in developing business intelligence dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.
7. Working extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.
8. Experience in creating drill through and master detail, and multi page reports using report studio.
9. Expertise in creating business models and designing packages using framework manager in cognos 8/8. 2/8. 3/8. 4/cognos10. 1.

Experience

5-7 Years

Level

Senior

Education

Bachelors Of Technology

Description :

1. Developed the frame work manager model & reports using big data hadoop files.
2. Created the dynamic cubes using Cognos Cube Designer 10.2 and created reports and dashboards using the MDX functions.
3. Created the cognos dashboards using the Cognos Report Studio with the Oracle data.
4. Have extensively used MDX functions for creating the reports using the cube data.
5. Coordination for integration testing, UAT, UTC and resolved the support issues.
6. Provided the training and documentation to the users on creating the reports using the cube packages and relational packages.
7. Created the cognos reports using the transact SQLs in the report studio and also converted some of them into framework manager package.
8. Created cognos connection with SSAS cubes and published to a cognos environment and developed reports using the report studio.
9. Developed many complex reports as list, cross tab, drill through, master-detail, chart using report studio.
10. Involved in developing framework manager models, coding and testing of the reports in the Cognos 10.2 version.
11. Worked with the business analyst for writing the technical specs and the test cases.
12. Implemented security filters at package level, object level, data level.

Experience

5-7 Years

Level

Senior

Education

MS

Description :

1. Gathering report requirements from business users and converted them in to technical documents.
2. Installing and configuring Cognos 10/8.X in Development, QA and Production environments.
3. Designing, developing and implementing an enterprise wide reporting system using cognos 10/8.X.
4. Designing and developing membership ETL job to load extracted information from the stored along with transformation rules, loaded into target systems.
5. Extensively using rave or data visualizations in the canned reports and dashboards.
6. Importing metadata from various sources like dm data mart and dl data mart into framework manager.
7. Creating imported view, business view and dimensional view in framework manager.
8. Creating folders, filters, and complex business calculations in framework manager and report studio.
9. Using framework manager to build models, packages and publish packages to the cognos connection.
10. Creating user groups, roles to implement the cognos security using ldap.
11. Creating complex list, cross tab, and chart reports using report studio. Coordinating in designing and developing of product documents with document writers.
12. Verifyig and reviewing the code, test results and test plans and provided inputs to the team.

Experience

2-5 Years

Level

Junior

Education

MS

Description :

1. Authored various types of reports in report studio using dimensional (cube & dmr) and relational data sources.
2. Designed and implemented metadata models in framework manager and powerplay cubes in transformer.
3. Worked closely with different business teams to gather requirements, prepare functional and technical documents and uat process.
4. Designed and implemented new dashboards using portlets pages and cognos workspace.
5. Developed active reports for users to use offline and on mobile devices.
6. Established an audit reporting system for the internal team to monitor, analyze performance and usage of different reports, cubes and other objects.
7. Successfully designed and implemented security on different levels including object and row level security.
8. Developed interactive dashboards using in-report prompts, custom portal pages and inter-portlet communication techniques.
9. Designed and implemented various materialized views to support several views.

Experience

10+ Years

Level

Consultant

Education

MS

Description :

1. Gathering functional requirements from business customers, analyzing and transforming them into business intelligence reporting specifications. Developing technical design documents.
2. Developing logical & physical modeling as per business requirements using Erwin 3.5.
3. Designing and developing snowflake/starschemas for better understanding of models using Erwin.
4. Designing DMR models in framework manager. Creating and publishing packages for different functional areas and assigned security rules to them in framework manager.
5. Creating list, crosstab and drill through reports for departments like claims, billing, members/subscribers in report studio.
6. Creating burst reports and multilingual reports based on groups of users &preferences for our Asian, African and European partners.
7. Creating drill through reports & master detail reports for accounts department.
8. Creating dashboards, portlets for various hr and payroll related reports. e.g. Investments related to 401k plan were displayed as dashboards showing their investments, returns, losses, dividends earned, etc.
9. Developing reports on risk analysis by comparing the internal data with the experian risk analysis data. This enabled the Sr.Management to take better risk decisions.
10. Creating the complex reports that had multiple pages, with multiple lists, charts, graphs, etc.

Experience

10+ Years

Level

Consultant

Education

MS

Description :

1. Installing and configuring the Cognos 10.2 in development environment.
2. Gathering the report requirements from business users and converted them into detailed specification documents.
3. Creating the mock designs and POC models based on report specifications to provide clients a mockup of the end product.
4. Experience in building models using framework manager & creating simple to complex reports in report studio.
5. Creating packages and DMR models in framework manager by importing metadata from different data sources with use of data modeling.
6. Using Cognos framework manager to create different views (database view, business view, presentation view) using SQL server database.
7. Involving in deploying cubes, packages and reports from development to production environment.
8. Designing & implementing the list, cross tab, chart, drill through, master-detail and complex reports with multiple pages/prompts in report studio.
9. Creating the multi-page reports based on multiple master queries to show the data on different pages when the master record changes in a report using report studio.
10. Creating reference queries and increased performance by preventing the execution of individual queries within reports.
11. Performance tuning of the reports implemented by creating summarized tables, views and appropriate indices.

Experience

2-5 Years

Level

Junior

Education

Bachelor Of Engineering

Description :

1. Analyzing the specifications provided by the clients and developing specification documents for reports as per client requirements.
2. In depth interaction with client architects, project manager, subject matter experts, and developers for solution implementation.
3. Responsible for the architectural design and detailed design of reporting and obtaining sign off from the business.
4. Developing and publishing the packages in framework manager - connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
5. Designing and developing the framework manager models using stored procedures, relational tables and published in to server.
6. Creating cubes in transformer using framework manager packages and report studio reports as a source.
7. Creating Tableau dashboards with various combinations of charts, reports using filters, parameters.
8. Working extensively on Tableau to produce complex reports to support cognos reporting.
9. Using dimensional modeling (DMR) and snow flake schema modeling technique to develop models.
10. Using informatica 8.X (source analyzer and warehouse designer) to import the source and target database schemas and the mapping designer to map the sources to the targets.
11. Developing various mappings and workflows in informatica as required by the design specifications.

Experience

7-10 Years

Level

Management

Education

Bachelor Of Technology

Description :

1. Automating subscriber activation, order management and service provisioning for all connected devices, across any communication service from any channel.
2. Gathering the report requirements from business users and converted them in to technical documents.
3. Installing and configuring the Cognos 10/8.X in development, QA and production environments.
4. Designing, developing and implementing an enterprise wide reporting system using cognos 10/8.X.
5. Designing and developing the membership ETL job to load extracted information from the stored along with transformation rules, loaded into target systems.
6. Extensively using rave or data visualizations in the canned reports and dashboards.
7. Importing the metadata from various sources like DM data mart and DL data mart into framework manager.
8. Creating imported view, business view and dimensional view in framework manager.
9. Creating folders, filters, and complex business calculations in framework manager and report studio.
10. Using framework manager to build models, packages and publish packages to the cognos connection.
11. Creating user groups, roles to implement the cognos security using ldap.
12. Creating complex list, cross tab, and chart reports using report studio.

Experience

10+ Years

Level

Consultant

Education

MS

Description :

1. Interacting with the end users to gathering the reporting requirements.
2. Creating the technical design documentation for reports, framework models and stored procedures.
3. Developing the list, crosstab, chart, drillthrough, master-detail, and complexreports which involved in multiple prompts, multi-query, cubes in reportstudio, burst reports against database using java scripts.
4. Creating the custom prompted reports in report studio, bursting reports to different user groups.
5. Developing complex reports in report studio in pdf and excel format to meet the specifications given in the business requirements.
6. Integrating various conditional prompts, cascading prompts, conditional variables in the report.
7. Assisting with creating report modeling that would better serve the need for the business requirement.
8. Extensively creating reports using illustrated charts that provide a better understanding of the subject matter.
9. Imported metadata from multiple data sources to build a model and publishing packages from framework manager to the cognos connection.
10. Secured Cognos connection and setup cognos security by assigning users to the groups and roles defined in cognos namespace.
11. Scheduled management - daily, weekly, monthly, and quarterly and yearly reports.
12. Created packages with various security settings and published them onto cognos connection.

Experience

0-2 Years

Level

Fresher

Education

MBA

Description :

1. Working with the business users to get the user requirement for creating multi-dimensional cubes and canned reports.
2. Developing the multidimensional models from multiple data sources using power play transformer. Constructing shared dimensions and delivered metadata to framework manager.
3. Refining the multi-dimensional models using special categories like excel, iqd, packages, alternate drill-down path, calculated measures, etc. To better suit user needs.
4. Partitioning power cubes and updated the cube using incremental update.
5. Doing performance tuning on power-cubes to reduce query time and partitioned cubes.
6. Creating batch scripts to schedule cubes. Done collaborative planning using tm1.
7. Updating power cubes with new data base columns using iqds generated in framework manager via externalized method.
8. Using power play for further analysis, slice and dice, drill down and creating reports from cubes.
9. Involving in design phase, gathered requirements from users and documented/designed/developed report specifications including report documentation for creating reports using report studio. Creating profitability reports using tm1.
10. Developing complex reports using report studio which includes various report types ranging from simple lists, crosstabs and chart through complex dashboards, drill-through, master-detail and conditional formatting.

Experience

7-10 Years

Level

Senior

Education

BS

Description :

1. Responsible for Effectively communicated with Business to resolve design action items.
2. Involved in providing both business and technical expertise in the requirements gathering, report design, report development by performing analysis of an underlying data source/schema.
3. Created and worked with complex database schemas and large volumes of data (up to hundreds of millions of rows), leveraged the data to create solutions that present data through Cognos BI Dashboards and KPI's.
4. Migrated reports from Cognos 8.4 to Cognos 10.1 environments.
5. Validated the migrated metadata models and reports in Cognos 10.1 environment.
6. Developed Cognos reports using MDX and OLAP Cubes as a data source, Passing Parameters (MDX and regular) to drill down reports, etc.
7. Supplemented regular prompts, cascading prompts, filters, Conditional style, static headers, Drill Through, sub queries to add interactivity for users in Report Studio.

Experience

2-5 Years

Level

Junior

Education

Bachelors Of Technology

Description :

1. Responsible for Interact with the Marketing team to analyze the data and produce the reports against their business logic.
2. Created reports like Carrier truck load summary reports, purchase order report as per business requirements.
3. Created Projects, Models, and Packages using Framework Manager and deployed packages on Cognos Connection.
4. Imported Meta data into Framework manager and created database layer, Physical Layer, and Presentation Layer, created several parameter maps, calculations and relationships.
5. Interpreted Complex Business specifications developed by the client and generated reports to meet customer specifications.
6. Created the Reports by using Render variable for hiding the objects.
7. Implemented the Dynamic column sorting in the List reports using JavaScript code.

Experience

5-7 Years

Level

Executive

Education

Bachelors

Description :

1. Created dashboard reports showing charts, lists, crosstabs using dimensional data Environment: Cognos 10 (Framework Manager, Report Studio), Oracle 10g, SQL Developer, Windows 7.
2. Involved in analyzing the requirements, understanding the functionality and accordingly documenting them for reference and future follow-through.
3. Involved in developing Cognos Dashboard/Reports using Report Studio and Query Studio.
4. Involved in analyzing the requirements, understanding the functionality and accordingly documenting them for reference and future follow-through.
5. Involved in developing cognos dashboard/reports using report studio and query studio.
6. Developed technical specification documents.
7. Maintained the performance of the Cognos application and monitor the execution of production reports.

Experience

2-5 Years

Level

Executive

Education

Bachelor Of Technology

Description :

1. Developed and monitored models using Framework Manager 1.1 to address the Dynamic business needs of the company.
2. Scheduled the reports in Cognos Connection and bursted them through email and directories, using the burst table.
3. Applied compound Conditional Formatting and Dynamic Highlighting by applying conditional blocks, Style Variables and Render Variables.
4. Applied various prompts by assigning static choices and employed complex filters based on the parameter selection.
5. Carried out standardizations in the prompt and report pages.
6. Tuned SQL queries for performance.
7. Created Mapping document for the Framework Manager Model to Notes.

Experience

5-7 Years

Level

Executive

Education

Bachelors

Description :

1. Created Page/List Headers and Footers, Conditional Layouts for multiple layouts in a single report.
2. Used Conditional formatting for highlighting rows and columns, and hiding individual rows.
3. Created multiple Prompt Pages using Filters and Prompts (Select & Search prompt, Value prompt, Text Prompt, Date & Time Prompt & Prompt Button).
4. Generated reports like list, tables, and crosstabs.
5. Involved in creating, re-ordering, modifying and deleting prompts in a report.
6. Created drill through reports to link two reports.
7. Developed Reports with conditional formatting, Calculations, Variables, Filters and Prompts.

Experience

5-7 Years

Level

Executive

Education

Bachelors Of Engineering