Cognos Developer

PROFESSIONAL SUMMARY

*.* years of extensive experience in IT industry as Cognos Report Developer/ BI Developer which includes extensive Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI), OLAP, ETL tools, Product Development and Reports Generation.

Extensive exposure to various business sectors such as Finance, Insurance, Banking, Sales and Manufacturing.

Hands on experience in COGNOS Suite (Cognos 10.x, Cognos 8.x, ReportNet 1.1, Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, Framework Manger, Cognos Transformer, COGNOS Connection, Report Studio, Query Studio, Business Insight, Advanced Business Insight, Analysis Studio and Event Studio) with expertise in Metadata Modeling-Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, Set security and publish into portal.

Extensively worked on Framework Manager in creating models and implementing ‘best practices’ while modifying relationships, resolving the loops in Relational data.

Experience in developing and testing Complex reports (Multi-chart, Cross tab, Maps, Drill-through, Master-Detail and Bursting) using Report Studio.

Thorough knowledge of creating Ad-Hoc Reports using Query Studio based on User requirements.

Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.

Trained the Business users on Cognos Workspace Advanced

Used Event Studio to trigger the jobs and Reports.

Having Work Experience in Cognos Life Cycle Manger while migrating from Cognos 8.4 to Cognos 10

Involved in Performance Tuning of Reports to reduce report execution time.

Created reports from multiple data sources (Excel, SQL Server) to reflect the current business rules.

Having good experience in Creation of TM1 Input Sheets/Dimension/Cubes.

Experience in Turbo Integrator processes to load the data/delete the data/save the data in the cube.

Performed Defect Prevention Activities in Project

Skills in developing SQL programming.

Having knowledge in Informatica.

Having knowledge in Qlikview.

Having Experience in Cognos Data Manager.

Excellent understanding of OLAP data processing methodology.

Worked with Business Analyst and end users in understanding and preparing functional, technical specifications and designed documents.

Experience in understanding and working with On-site Off-shore environment.

Trained users and created user manuals on Cognos 8.x/10.x, Cognos Data Manager.

Excellent problem solving ability coupled with good communication skills to interact with end-users, customers, and team members.

COGNOS CERTIFICATIONS

IBM Certified Designer - Cognos 10 BI Author

IBM Cognos 10 BI Metadata Model Developer

EDUCATION

B.Tech from JNTU, Hyderabad India.

TECHNICAL SKILLS

Reporting Tools

Cognos Impromptu 6x/7x, Power Play 6x/7x, Cognos 8.x/10.x (Report Studio, Query Studio, Analysis Studio and Event Studio)

Cognos 10.x (Business Insight and Advanced Business Insight)

Cognos Report Net 1.1 (Framework Manager, Report Studio and Query Studio)

IBM Cognos TM1/10.1

Pentaho BI Tool

ETL Tools

Informatica, Cognos Data Manager, Datastage

Web Servers

Internet Information Services(IIS)6.0/7.0

Modelling Tools/Methodology

Framework Manager,

Star schema, Snow-Flake Schema

Database

MS-SQL Server 2000/2005, Oracle 8i/9i/10g/11g,

Postgre SQL

Operating System

MS-DOS, Windows 2003/2008/XP, Windows7, Linux, Unix

PROFESSIONAL EXPERIENCE:

College Board – Reston, VA Jan 2016 – Jan 2017

Sr Cognos lead Consultant

Project Description: The College Board is a mission-driven non-profit organization that connects students to college success and opportunity. Today, the membership association is made up of over 6,000 of the world’s leading educational institutions and is dedicated to promoting excellence and equity in education. Each year, the College Board helps more than seven million students prepare for a successful transition to college through programs and services in college readiness and college success including the SAT and the Advanced Placement Programs. The organization also serves the education community through research and advocacy on behalf of students, educators and schools.

ROLE AND RESPONSIBILITIES:

Worked with Business users to gather Business strategy and created a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications.

Developed Business Requirement Documents based on Client’s Requirements.

Developed and managed dimensionally Modeled Relational model (DMR) using Framework Manager.

Defined the keys, Joins, cardinalities and global filters in Framework Manager.

Used package level security and folder level security.

Developed Burst reports, Drill through, Master Detail, List, Chart, cross tab and complex reports (which involves Joins, Unions, Prompts, Report Library, Table of Content, Report Layout, template, Dashboards etc) in Report Studio based on the business requirements involved Multiple Prompts in Report Studio

Developed Query studio Packages for Ad-Hoc reporting.

Worked on enhancements to existing Cognos reports in Report Studio & models in Framework Manger

Migration of reports from Cognos 7 to Cognos 10

Created query studio reports using Custom Grouping option.

Applied conditional formatting for hiding the data, and highlighting the data

Incorporated Layout Component Reference in the new reports.

Created Cascading prompt and repromptable prompts to view report

Coordinated with offshore team for Migrations.

Performed administration task for user permissions & scheduling the reports.

Utilized the burst capability in Cognos to distribute the reports to end user.

Used Static Choices to conditionally hide and display the objects

Used Event Studio to trigger the jobs.

Developed Structural and Transactional IQD’s from Framework Manager and used it for Transformer.

Use the advance functionality of Analysis Studio such as drill up and drill down, rank, slicers etc.

Created Technical Specification documents for QA team to understand more about reports which was helpful for their testing.

Interacted with QA team for Unit Testing, System Testing and Performance Testing.

Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.

ENVIRONMENT: Cognos 10.2.2(Cognos Connection, Framework Manager, Report Studio and Query Studio), CognosEPseries7.3(Impromptu administration, Transformer,Powerplay Windows/web and upfront)Oracle 11g, IIS 6.0, Windows 2003 Server, TOAD, PLSQL Developer.

OPTUM/UHG – Atlanta, GA Jan 2013 – Dec 2015

Sr Cognos Lead (Developer & Admin)

Project Description: eFR is a platform that supports workflow, document management, and disparate system integration to holistically manage the revenue cycle at the patient level. The enterprise system interacts with many different interfaces to build a picture with many different technologies for clients to interact with, Claims Management and Revenue Cycle Management.

The eFR Platform:

Reduces denials, write-offs, A/R days and cost to collect

Improves collections and cash flow

Increases productivity, provides productivity monitoring, and measures outcomes

ROLE AND RESPONSIBILITIES:

Extensively involved in gathering the User-Requirements from the End-Users and documenting end to end process.

Configured the Security with Active Directory

Creation and Maintenance of User, User groups and Roles

Migration of Packages and Reports from Development to Production Environment

Developed TM1 Applications using various sources.

Resolving of Cognos Environmental issues which affect the Scheduled Jobs and Reports.

According to the Business requirements created Data Layer, Business and Presentation Layers.

Worked on framework manager to create models by importing metadata from multiple data sources and published packages to Cognos Portal.

Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.

Used Dimensional modeling (DMR) and Relational modeling techniques technique to develop FM models.

Created various IQD in Framework Manager and from this IQD’s as source, integrated to Power Play Transformer to create various models and build cubes.

Create Transformer cubes using Cognos Framework manager packages as source.

Manually Create IQD’s to source the Transformer Cube

Created batch scripts using update the cubes on regular intervals

Created Dynamic Cubes using IBM Cognos Cube Designer 10.2.1

Created Technical design document for Report studio reports based on Functional specifications.

Customized Cognos Data source Connection with appropriate reports and security measures

Created Standard Template design for report studio reports and Created ad hoc reports using Cognos Workspace Advanced.

Create dashboards using Cognos Workspace

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio

Created Drill through in same page report, Drill through from one chart to another chart in one page

Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio

Customized Reports using HTML and JAVA SCRIPTS

Created Dashboards comprising of list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, calculations, complex expressions, and conditional formatting.

Created the reports Using SQL object by writing the queries manually and Created Macro Prompts in Report Studio reports

Performance Tuning of the reports

Migrated framework packages and reports between different environments (Development, QA and Production).

Scheduled Reports and Created Jobs to run periodically

Unit Testing of Reports

Prepared Unit Test Cases for the Reports.

Knowledge of Cognos SDK and overall architecture and worked on SSO initiatives with Java Developers.

Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports mainly through Analysis Studio, Query Studio, and Business Insight.

Preparation of Cognos Training Presentation for end users

ENVIRONMENT: Cognos 10.2(Cognos Connection, Framework Manager, Report Studio and Query Studio), Cognos 8.1, Cognos ReportNet1.1 MR3 (Framework Manager, Cognos Connection, Query Studio, Report Studio), Oracle 9i, Sql Server 2010 IIS 6.0, Windows 2003 Server, TOAD

CSC India Pvt Ltd, Hyderabad, India May 2007 – Jan 2013

Cognos Developer

Project Description: The main objective of the project was to develop CSC’s own BI data model and sample business analytics for Retail Service providers which is close to the Industry standards in terms of coverage to the participating business entities, their relationship, attributes and support for expected business analytics which will help demonstrating our capability as well as our readiness for client specific requirement.

Retail BI Accelerator is a set of end-to-end Business Intelligence and Data Warehouse (BI/DW) consulting service offerings supported by a preconfigured prototype designed to help a retailer accelerate their ability to deliver valuable information to address key business challenges and opportunities. These service offerings leverage the retail industry’s leading financial and operational metrics and the Retail Data Model and technology stack. The RBIA is based upon the retail industry’s standard reference data model (ARTS) and delivers pre-built KPIs, BI reports, and dashboards using IBM Cognos and Datastage tools.

ROLE AND RESPONSIBILITIES:

Analyzed Business requirements from the analysts.

Involved in Desiging models using Framework Manager and deployed packages to the Report Net Servers

Implemented Framework manager security for Data access, Object level access and Package access.

Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager .

Modeled metadata from SQL Server 2005 data source for use in Report studio and Query Studio using Framework Manager in ReportNet

Creating the Teradata views as per the business and reporting requirement.

Importing the Teradata Views to the model and creating the relation between the views.

Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.

Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.

Created custom templates and custom toolboxes for the use of reporting.

Customized Cognos Connection with appropriate reports and security measures

Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.

Designed Power Play reports to provide summarized results by measures and dimensions.

Created custom prompted reports in Report Studio, Bursting reports to different user groups.

Moved projects from development to QA and then Production servers

Built Power Play Reports based on the cubes and published to Report Net Server.

Involved in the Testing of the reports and updating the Bug Tracking Tool

Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports

Transferred technical knowledge specific to Cognos tools and the existing data model to other team members

ENVIRONMENT: Cognos 8.2 BI Suite, Cognos FrameworkManager8.2, Cognos Impromptu 7.3, Cognos Power Play 7.3, Cognos Transformer 7.3,SQL Server 2005, Teradata, Windows 2003 Server

Contact this candidate