Renu Reddy

Cognos BI Developer

908-***-****

acpzmn@r.postjobfree.com

Professional Summary

. Over 8 years of working experience with Cognos 10.2/10.1/8.x BI Suite

(Framework Manager, Cognos connection, Report Studio, Metric Studio,

Analysis Studio and Query Studio).

. Experience and expertise in understanding existing business processes,

data analysis requirements, business systems analysis and design,

converting requirements specifications into functional specifications.

. Handling complete range of BI capabilities: reporting, analysis,

dashboards and business event management.

. Hands on Experience with Framework Manager Modeling (Physical Layer,

Business Layer, Packages) and Complex Report building with Report

Studio

. Expertise in developing and testing Complex reports (List, Cross tab,

Charts, Maps, Drill-through, Master-Detail, and Cascading) and

Dashboards using Report studio.

. Extensive experience in Multiple Relational Databases including SQL

Server, Oracle & DB2

. Experience with writing SQL queries, Oracle PL/SQL Stored Procedures,

Functions, Cursors and Triggers

. Provide best practices for day to day operations, performance

analysis, tuning and capacity planning.

. Have clear understanding of Business Intelligence and Data Warehousing

concepts with emphasis on ETL and Life Cycle Development.

. Involved in training end users and providing technical support and

documentation.

. Ability to adapt and learn new technologies and to get proficient very

quickly with them.

Technical Skills:

BI tools Cognos10.2, 10.1,8.x (Report Studio, Framework Manger,

Analysis Studio, Query Studio, Business Insight), Transformer

ETL Tools Informatica 8.6, Data stage 7.5

Databases Oracle 9i/10g/11g, Netezza, SQL Server 2008, Teradata, DB2

Languages C, C++, Java, VB.net

Scripting VB Script, Java Script, HTML, CSS

DB Tools SQL *Plus, SQL *Loader, TOAD 8.3, IBM Data Studio

Web IIS, Apache

Servers

Professional Experience

Citi Bank, NYC NY

Dec 2013 - Till date

Sr. Cognos Developer

Responsibilities:

. Created Business Requirement Specification in collaboration with the

Business analysts as per user requirements.

. Design metadata models, create and publish packages using Cognos

Framework Manager - Identify data sources, import query subjects,

organize into layers, define appropriate relationship between query

subjects.

. Designed and developed dashboard style reports (Outpatient Analytics,

IDTF Analytics, Case Management Analytics) using Cognos Report studio

. Created List, Cross tab, Chart, Master Detail reports, drill through

and custom prompting reports, worked with HTML items/Java Script in

Cognos Report Studio to customize reports.

. Implemented filters, calculations, conditional formatting and prompts

in various reports created using Cognos Report Studio.

. Created reports using Query Unions to merge multiple Query Items into

one for reporting purpose.

. Created reports using Native SQL in Cognos Report Studio.

. Created Jobs in Cognos Connection with multiple reports and scheduled

these jobs to run on recurring basis.

. Deployed Packages and Reports from Dev Environment to UAT and

Production Environments.

. Setup and monitor schedules, setup burst options in Cognos as per user

requirements.

. Performance tuning by analyzing and comparing the turnaround times

between database queries and Cognos reports.

. Trained the end users in effectively using the reporting tool to build

and customize their ad-hoc reports.

. Coordinated with functional users during User Acceptance Testing prior

to deploying reports to production.

. Created documentation for the complete project life cycle and mentored

the End Users and Provided Technical Support.

Environment: Cognos 10.2.1 (Framework Manager, Transformer, Report Studio,

Query Studio, Cognos Connection, Cognos Administration), Netezza, TOAD,

Java Script, Data Stage.

Anthem Health, Virginia Beach VA

Jul 2012 - Nov 2013

Sr. Cognos Developer

Responsibilities:

. Involved in Designing models with Relational Data using Framework

Manager and published packages to the Cognos Reporting Servers.

. Implemented data level, object level and package level security in

framework manager to achieve highly complex security standards.

. Created Database Layer, Intermediate layer and Presentation Layer,

defining appropriate relationship between query subjects and Fact

Table in Framework Manager.

. Developed List, cross tab, drill through, master-detail, chart and

complex reports which involved Multiple Prompts in Report Studio.

. Developed Reports using Conditional Formatting, Cascading Prompts,

optional prompts and Report Bursting.

. Upgraded Framework Manager Models, Transformer Cubes from Cognos

Version 8.4 to 10.2.1

. Developed Dashboard reports to display all the information related to

environment using Summary reports.

. Created optional filters/prompts in report studio using Java Script

and HTML.

. Worked on Analysis Studio to develop multi dimensional reporting.

. Trained the end users to effectively use the reporting tool to build

and customize their ad-hoc reports

. Deploying models and reports from Development to Production and

administering users/groups/roles.

Environment: Cognos 8.4/10.2 (Framework Manager, Transformer, Report

Studio, Query Studio), Oracle 11g, WAS, SQL Server 2008, TOAD, PL/SQL,

Java Script, Data Stage, zLinux.

Century Link, Denver CO

Jan 2011 - Jul 2012

Sr. Cognos Developer / Administrator

Responsibilities:

. Involved in all phases of the data warehouse project lifecycle, which

includes assessment, business requirements gathering, data modeling

and database design, ETL/BI architectures, Reporting Model and report

Development, performance tuning, and data delivery mechanisms.

. Created metadata models using Framework Manager with relational data

and deployed packages to the Cognos Reporting Servers

. Designed and Developed DMR models using regular & fact dimensions in

Framework Manager

. Implemented data level, object level and package level security in

framework manager to achieve highly complex security standards

. Implemented Database Layer, Intermediate layer and Presentation Layer,

defining appropriate relationship between query subjects and Fact

Table in Framework Manager

. Developed List, cross tab, drill through, master-detail, chart and

complex reports which involved Multiple Prompts in Report Studio

. Developed Reports using Conditional Formatting, Cascading Prompts,

optional prompts and Report Bursting

. Developed dimensional models in Transformer, built cubes and published

cubes to Cognos Portal

. Involved in Upgrading Cognos reporting application from Cognos Version

8.4 to 10

. Created, refreshed and supported Cognos Transformer OLAP models and

Power Play cubes

. Coordinated with functional users for User Acceptance Testing prior to

releasing system changes in production

. Deploying models and reports from Development to Production and

administering users/groups/roles

. Created documentation for the complete project life cycle and mentored

the End Users and Provided the Technical Support

Environment: Cognos 10.1.1/8.4, Framework Manager, Transformer, Report

Studio, Query Studio, Oracle 11g, SQL Server 2008, TOAD, SQL Navigator,

PL/SQL, Java Script, Informatica 9, AIX.

Lincoln Financials, Jacksonville FL

Sept 2009 - Jan 2011

Sr. Cognos Consultant

Responsibilities:

. Worked with business users, functional lead to understand and document

the Business requirements.

. Designed Functional Requirement Specifications for report development,

modified relationships between different database tables and building

models using Framework Manager

. Worked jointly with the data management team members to understand

data domains, values, cardinalities and other dimensions of data

needed to support BI solutions.

. Created Metadata Modeling importing query subjects from multiple

databases in Cognos Framework Manager.

. Created and published packages from Cognos Framework Manager.

. Created Complex Reports in Report Studio, PowerPlay Reports using

Analysis Studio.

. Developed multiple page reports with page-breaks based on the first

page of the report using Master-detail relationship.

. Developed List, cross tab, drill through and complex reports which

involved multi-queries.

. Extensively used Power play Transformer to create powercubes loading

data from datamarts.

. Deployed Packages and Reports from DEV Environment to UAT and PROD

Environments.

. Imported metadata from various sources such as Relational Databases,

Report Net models, Impromptu Catalogs into the Framework Manager.

. Did Unit Testing for all reports and packages.

. Creating report views with saved prompts and schedule according to the

business requirement.

. Created Jobs to Schedule multiple reports in Cognos Connection.

. Personalized Cognos Connection, Specified display options, regional

options and personal information.

Environment: Cognos 8.4, Transformer 8.4, Report Studio, Query Studio,

Metric Studio, Oracle 10g, Sybase IQ 12, Erwin 4.0, TOAD, PL/SQL,

Informatica 8, UNIX (Sun Solaris).

L&T InfoTech, India

Mar 2007 - Aug 2009

Cognos Developer

Responsibilities:

. Designed metadata models creating Data Source Query Subjects, Model

Query Subjects and Stored Procedure Query Subjects in Framework

manager.

. Worked with Complex reports in Report Studio using master-detail

relationship, drill through, burst options, cascading options and

Prompts depending on user requirements.

. Created reports using cascaded prompts, value prompts, sections,

dynamic filtering, conditional layouts and multi lingual reports in

Report Studio.

. Created reports containing multiple data containers like List, Cross-

tab and Repeater tables.

. Created dashboards for a managerial overview with drill up and drill

down capabilities.

. Scheduled reports using Cognos scheduler and emailed to various

recipients as required.

. Worked on TOAD for Oracle database systems for creation of ad-hoc

queries and for improving various performance issues.

. Test/validate system tables/files in System Test environment, UAT

environment and finally in Production environment.

. Involved in monitoring Data stage jobs/processes and generating

reports after successful job scheduling.

. Tuned performance of Data stage sessions for large data files by

increasing block size, data cache size, sequence buffer length, and

target based commit interval.

Environment: Cognos 8, Transformer 8, Report Studio, Query Studio, Metric

Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX, Cognos 8

SDK.

Contact this candidate