Manager Insurance

COGNOS TM* CERTIFIED

**********@*****.***

Phone: 972-***-****

GIRISH

PROFESSIONAL SUMMARY

• Having 8 years experience in Design and Development with the primary focus on

the Cognos 8.x Suite, Cognos Reportnet 1.1, Cognos Impromptu, Cognos

Transformer, Cognos Power Play, PowerPlay Enterprise Server, Impromptu

Web Reports (IWR), Access Manager and Cognos 9.x TM1

• Experienced in implementing large-scale applications with leading technologies in

Business Intelligence and involved in complete software development life cycle

(SDLC)

• Extensive experience in Designing the Framework Manager models, to meet BI

industry standards applied Physical Layer, Business Layer and Presentation Layer

approach to increase the model durability

• Experienced in designing and development of DMR models

• Created models with different data sources such as Oracle, SQL Server and MS

Access

• Published packages to avail metadata for reports authors, using Framework Manager

• Created IQDs in the Framework Manager which are considered as inputs for creating

multi-dimensional cubes using Transformer

• Extensive experience in creating Managed/Complex reports using Report Studio and

creating ad-hoc reports using Query Studio

• Worked on advanced features of Report Studio such as Conditional Variables,

Conditional Blocks, Drill-through, Page set, Master-Detail relationships, Bursting

and various kind of prompts (Value prompt, Date prompt, Textbox prompt)

• Hands on experience in reports migrating from Cognos 7 series to Cognos 8.x

• Troubleshoot issues with existing reports and cubes, Expertise on creation and

maintenance of models, which involved defining security, joins, cardinality, filters

and governor settings Cognos 8.x

• Created multi-dimensional reports using Analysis Studio and applied context filters

for better analysis

• Having experience in implementing security for Cubes and Package, Object and

Data level security for Packages

• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing

database schemas (Star Schema and Snowflake Schema) used in relational,

dimensional and multidimensional modeling.

• Expertise in Building Cube, Dimensions using TM1 Turbo Integrator processes.

• Expertise in building Executive Viewer and TM1 9.4 reports over a web environment.

• Expertise in creating rules and adding Business Logic.

• Involved Installation and configuration of TM1 servers

• Having Knowledge of Upgrading from TM1 9.4.1 to TM1 9.5

Page 1 of 8

Girish Cognos Profile

COGNOS TM1 CERTIFIED

• Involved in requirement gathering for effective analysis

• Involved in Reports Testing and UAT

• Excellent work ethics, self-motivated, quick learner and team oriented. Continually

provided value added services to the team through thoughtful experience and excellent

communication skills

TECHNICAL SKILLS

Cognos BI Suite 8.x/7.x (Query Studio, Report Studio, Analysis Studio,

Event Studio, Cognos Connection, Framework Manager, PowerPlay

Transformer, Impromptu Administration, Data Manager Upfront, IWR

Business and PPES), IBM Cognos TM1 9.4.1,

Intelligence Tools

TM1 Executive Viewer

ReportNet 1.1 (Query Studio, Report Studio, Framework Manager,

Metric Studio, Cognos Connection)

• Oracle 8i/9i/10g, MS SQL Server 2000/2005, MS Access 7.0,

Databases

• Toad, SQL-Plus

Querying Tools

• Visio 2003, Erwin

Data Modeling

• Windows-98/NT/2000/XP/Vista, Linux, Solaris, UNIX(IBM

Operating

System AIX, HP-UX), DOS

• SQL, PL/SQL

Languages

• LDAP, Active Directory Server

Directory Servers

EDUCATION

• Bachelor’s in Engineering, India.

EXPERIENCE SUMMARY

Progress Energy, Raleigh, NC April 2009 – Current

Sr. Cognos Developer

Progress Energy (NYSE: PGN), headquartered in Raleigh, N.C., is a Fortune 500 energy

company with more than 22,000 megawatts of generation capacity and approximately $10

billion in annual revenues. Progress Energy includes two major electric utilities that serve

about 3.1 million customers in the Carolinas and Florida. The project deals with the Sales &

Marketing Data collected from different tests conducted on the subjects. The data is then

consolidated into the data mart, which is used for the development of consolidated reports to

their business by using Cognos as BI tool. The System was primary designed to provide reports

for the Performance Analysts who could use the Daily Operational Reports to investigate

discrepancies, thereby creating a streamlined and efficient process.

Page 2 of 8

Girish Cognos Profile

COGNOS TM1 CERTIFIED

Responsibilities:

• Interacted with Business users during requirement gathering, understand the KPIs for

business analysis

• Performed Analytical Review of the business process and accompanied report spec

and suggested best possible approach in initiating the data from data ware house and

model it to met the requirements of a report

• Created Dimensions and populated the dimensions with elements, manually and from

external sources.

• Loading and Maintain Data in Cube using Turbo Integrator.

• Adding Business Rules to Cubes.

• Optimize the Rule Performance by adding SKIPCHECK and FEEDERS.

• Created and Scheduled the CHORES to automate the process.

• Performing Live TM1 backups and automated the process by creating Turbo

Integrator process and Chores.

• Exporting the Data to Excel files and relational databases using Turbo Integrator

process.

• Creating TM1 Application by adding TM1 objects and External files to an application

• Deploy the application to Web

• Integrating Cognos TM1 with Cognos 8 BI

• Applied Element, Dimension and Cube level security using TM1 Architect

• Creating TM1 Workbook and uploaded to TM1 Server.

• Created TM1 Workflow process and assigned the Task to TM1 Users

• Created Advanced Reports like Maps,Charts,Conditional highlighting data using

Executive Viewer

• Integrating Executive Viewer with PowerPoint to make presentations

• Installing Cognos TM1 Executive Viewer and Set UP Executive Viewer Client

• Creating The Data source and Database connections for TM1 Cubes in Executive

Viewer Explorer

• Worked as BI Report Author on Cognos 8.4 toolset including Report Studio, Query

Studio, Analysis Studio, Framework Manager

• Used Cognos Framework Manager for metadata modeling and followed layers

approach such Database Layer, Business Layer and Presentation layer

• Published metadata as packages

• Worked extensively on various report layouts such as Chart, List, Crosstab and

Repeater for presenting the data in efficient manner in Report Studio

• Create ad hoc reports using Query Studio

Page 3 of 8

Girish Cognos Profile

COGNOS TM1 CERTIFIED

• Created Master-Detail relationship based reports that represented information

pertaining to a certain identifier or master field based upon either User entered report-

filters (e.g. Drop down lists, from/to date ranges, sorting options etc.)

• Scheduled reports requiring distribution or bursting to stakeholders

• Defined various Drill through definitions for navigating from Analysis studio to

Report studio and Report Studio to Query Studio

• Involved in preparing Technical Design specification for the reports

• Involved in preparing Test Scripts for reports

Environment: Cognos TM1 9.4.1, Cognos TM1 Executive Viewer, Cognos Suite 8.4

(Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio),

Oracle 10g

Johnson & Johnson, Piscataway, NJ December 2007 – March 2009

Sr. Cognos Developer

Johnson & Johnson is the world's most comprehensive and broadly based manufacturer of

health care products and related services. The objective of this project was to support Business

Executives with quicker decision-making. As part of the BI team, I generated and analyzed

reports based on buyers, sales representatives, and marketing specialists that focus market

performance in different locations.

Responsibilities:

• Involved in gathering Reports Requirements from business users

• Used Framework Manager in Cognos 8 to design metadata from different sources and

followed layered approach for model design then published packages

• Created DMR model with Dimension and Hierarchies for providing drill downs & ups

in Analysis Studio

• Developed various reports, and they include, lists, cross tabs, charts, complex reports

with conditional blocks, static choices in prompt, bursting etc

• Extensively used Prompts, Drill-through, master-detail query relationships,

conditional formatting, grouping and sorting features of Report Studio to generate

efficient and user-friendly reports

• Used various kind of prompts like Value Prompt, Date and Time prompt etc for

better performance

• Developed Executive Dashboard for Self-service reporting using Cognos portal pages

• Deployed packages, folders and Reports from a development environment to Testing

and Production environment

Page 4 of 8

Girish Cognos Profile

COGNOS TM1 CERTIFIED

• Worked with Analysis Studio to develop multi dimensional reports and applied context

filters for better analysis

• Worked with Drill- through Definitions to drill through from Analysis Studio reports

to Report Studio reports

• Managed Scheduling of reports, maintenance of public and individual folders,

distribution lists, users, groups and roles using Cognos Connection in Cognos 8

• Resolved issues resulting from User Acceptance Testing (UAT)

• Interacting with the End users on a regular basis for resolving issues pertaining to the

reports

• Involved in testing, data validation of cognos8.4 models, reports

Environment: Cognos 8.3 BI Suite (Frame work Manager, Cognos Connection, Report

Studio, Query Studio, Analysis Studio), SQL Server and Toad

State Farm Insurance, Bloomington, IL September 2006 – November 2007

Cognos Developer

State Farm has been in the business of providing auto insurance, home insurance, life

insurance, health insurance, disability insurance, long-term care and business insurance.

Responsibilities:

• Interacted with Functional / Business users for requirement gathering

• Involved in metadata modeling in Framework Manager and followed layered

approach

• Applied Package, Object and Data level security using Framework Manager

• Created and published Packages using Framework Manager

• Applied security and User Authentication to the various User Groups

• Worked extensively in development of standard Reports, Charts, and Drill through

Reports, Master Detail Reports

• Worked in developing prompt pages and cascaded prompts

• Scheduled reports and with different output formats

• Created new jobs using Cognos Connection

• Expertise in Developing Ad hoc Reports using Query Studio

• Bursting Reports using Report Studio

• Followed quality standards and best practices for the development tasks

• Scheduled and distributed reports using Schedule Management in Cognos Connection

• Involved in Report Testing and USAT

Page 5 of 8

Girish Cognos Profile

COGNOS TM1 CERTIFIED

Environment: Cognos Suite 8.2 (Frame Work Manager, Cognos Connection, Report Studio,

Query Studio), SQL Server2000

Unum Insurance, New York, NY October 2005 – August 2006

Cognos Developer

The Unum Provident provides range of insurance solutions specifically designed for the needs

of the customers. It helps individuals, families balance their work, and personal lives, protect

their incomes and assets from the financial effects of injury or illness, and return to work after

an absence.

Responsibilities:

• Developing sophisticated reports as per the requests from Business users

• Identified, researched, investigated, analyzed, defined opportunities for business

process improvement, documented business processes and initiated efforts to make

improvements

• Used Tabular SQL objects for querying data from different database tables as per the

requirement

• Developed Standard Reports, Dashboards, YTD reports, Charts, Drill through

Reports, Master Detail Reports and Bursting Reports using Report Studio

• Created various prompts such as Value prompt, Date prompt, Textbox prompt

• Created detailed filter and summary filter for better performance

• Scheduled reports as per business requirements

• Resolved ambiguous, hierarchical and recursive relationships in the Data Model

Environment: ReportNet 1.1MR2 (Report Studio, Query Studio, Cognos Connection,

Framework Manager), Erwin and Oracle 9i

Inter Digital, King Of Prussia, PA October 2004 – September 2005

Cognos Developer

Inter Digital has been a recognized pioneer in the design, development and delivery of

advanced wireless technology platforms. Advanced inventions, technology and systems

developed by InterDigital Where embedded in a variety of wireless communications devices,

such as mobile phones, personal digital assistants (PDAs), mobile computing devices, other

terminal-end wireless devices, base stations and other infrastructure equipment. For planning

and allocating the budget for the future years a project was developed and to calculate the

budget allocations and actual allocations to each employee and to the company’s cost centers.

Responsibilities:

• Create reports as per the business requirements using Impromptu Administrator

• Created summary reports, target detail reports, chart, list and cross tab reports

Page 6 of 8

Girish Cognos Profile

COGNOS TM1 CERTIFIED

• Involved in creation of Distributed Catalogs

• Published impromptu reports using IWR and also hosted them on Upfront

• Created IQDs through IMR reports which were used inputs for Cube building

process

• Created power cubes using Cognos Power Play Transformer

• Extensively used scheduler for periodical up gradation of cubes such as incremental

updates

• Responsible for design and development of the Cognos Power Play reports and

Cognos Power Play for Excel reports

• Maintained user security and privileges through Access Manager

• Created Users, Groups and Roles in Access Manager for security implementation

• Provided Folder and Table level security for IMR reports using IMR Admin

• Created User class views and used Exclude, Apex, Cloak for restricting data access

• Created Cube groups for easy maintenance

• Used PPES for publishing cubes to Upfront

Environment: Cognos Series 7(Impromptu Administrator, Transformer, Impromptu Web

Reports, Power Play Enterprise Server, Upfront, Access Manager), Windows NT/2000 & XP,

Oracle 8i, Toad

MetLife, Somerset, NJ January 2004 – September 2004

Cognos Developer

MetLife is for providing life insurance to individuals and groups. The Company’s business

model is in response to people’s growing need for first-rate financial products and services

through various life stages and economic cycles. MetLife has trusted brand, capital strength,

and existing relationships with millions of individual and institutional customers around the

globe uniquely position MetLife among its competitors.

Responsibilities:

• Generated catalogs by connecting to different databases

• Created various types of reports such as Simple List, Grouped List, Crosstab, Nested

Crosstab, Drill through, and Charts

• Created cascading prompts and worked with various prompt controls such as File

Pick List prompt and Report list prompt

• Applied sorting and grouping for better analysis

• Worked with the join functionality to create various reports

• Generated reports for comparative analysis based on the Projected v/s Actual

• Designed Multi Dimensional Cubes using Transformer and Optimized Cube

performance to improve report run time

Page 7 of 8

Girish Cognos Profile

COGNOS TM1 CERTIFIED

• Involved in designing Dimension Maps, creating levels and provided alternative drill

down paths

Environment: Cognos 7.3 (Impromptu Administration, Power Play Transformer) and SQL

Server.

DICGC, Mumbai, India June 2002 – December

2003

Cognos Developer

This Deposit Insurance and Credit Guarantee Corporation (DICGC) one of the leading

Insurance organizations. This organization takes care of settlement of accounts raised due to

closure/liquidation of banks. Provided an application meant for entering the account details,

verifying them and reporting them for settling the accounts of the customer.

Responsibilities:

• Involved in gathering Reports Requirements from business users

• Developed reports using Impromptu to provide decision support and business

intelligence to the end-users

• Created reports in HTML format for easy navigating of data from web browser

• Created list reports and cross tab reports

• Created User Prompts, Conditions and Filters to improve the report generation

• Designed and developed Impromptu Catalogs using joins, prompts, etc

• Modified existing catalogs

• Published IMR reports to upfront using IWR

• Used Conditional Formatting, Pie-chart display, Bar-chart display for the purpose of

analysis of the reports

• Developed Impromptu Web Reports IWR and published them into Upfront

• Exporting and Importing of database as required, maintaining security of database

• Involved in documentation of the whole process

Environment: Cognos Impromptu, IWR, Oracle 8.0, Windows 2000

Page 8 of 8

Girish Cognos Profile

Contact this candidate