Prasanthi Guduru

prashanthig**@.gmail.com

940-***-****

Experience in IT includes extensive

•

Functional and Technical experience in Physical and Logical data model

design, Data Warehousing, Designing Decision Support System, Business

Intelligence (BI) Reporting, ROLAP Cubes, OLAP Cubes, Database

Administration, SQL & PL/SQL programming.

Extensive experience in Business

•

Intelligence Tools using Cognos BI and IBM for executing its ETL operation.

Designed model files in Cognos

•

Transformer

Created Cognos multidimensional OLAP

•

cubes for users to be able to get business information from Cognos Power Play..

Extensive knowledge in handling

•

Offshore/Onshore model for Cognos BI..

Analyzed business needs for designing

•

cognos architecture. Extensively explored and implemented the cognos multi-

tier architecture for maximum scalability and fail over safety for business

critical systems.

Extensively used Analysis Studio, Query

•

Studio, Report Studio and Metric Studio for Report design in Cognos BI

version 10.1/10.2/8.4/8.3/8.1.2 MR1/ReportNet 1.0/1.1MR1/MR2.

Extensive experience with Cognos tools

•

such as Cognos 8, Cognos ReportNet,

FrameworkManager,Impromptu,SPowerPlayCubes,Transformer, Impromptu

Web Reports (IWR), Upfront, PowerPlay Enterprise Server (PPES), Access

Manager and Architect.

Extensively worked on each phase of Data

•

warehouse lifecycle involving Data Discovery, Data Modeling, ETL

Architecture, Implementation, Deployment, Business Intelligence Reporting,

Production enhancement & support.

Expertise on Framework Work Manager,

•

Transformer, Report studio, Query Studio, Analysis Studio, Cognos

Administration, Impromptu, Impromptu web reports, Upfront.

•Analyzing enterprise data and designing data models for optimal performance

in reporting that confirm with Teradata / Oracle / Cognos best practices.

•Worked on Extraction Transformation and Loading - ETL with Cognos Data

Manager, Informatica, PL/SQL, SQL, Mainframe, Unix, MultiLoad,

SQL*Loader and data pump scripting.

•Worked through the Entire Life Cycle of the project under various

responsibilities including Analysis, Designing, Development, Testing,

Deployment and Maintenance

Education:

Bachelor of Technology in Computer Science and Engineering, India.

Technical Skills:

BI Tools : Cognos Business Intelligence 10.x,8.x, 7.1/7.0/6.0,

Impromptu Web Reports 7.0/6.0, Upfront,PowerPlay

Transformer 7.1/7.0/6.0, Power Play Enterprise Server,

Cognos Architect, Cognos Query,,Access Manager.

Cognos Report Net 1.0.2/1.1 MR2/ 8.0. Oracle Reports,

MS Analysis Services 2005, Oracle Business Intelligence

Enterprise edition (OBIEE), Hyperion Interactive

Reporting, Brio.

DDL & DML : SQL, PL/SQL, T-SQL, MDX

Languages & Scripts : PL/SQL, UNIX scripting, HTML, XML, Java, cognos

SDK, Java Script.

Operating Systems : AIX, Sun Solaris 2.8/ HP UNIX, Windows 2003

Server/ NT/ 98/ 95.

Databases: : Oracle 8/9i/10g/11g,SQLServer6.5/7/2000/2005,

Teradata V2R6, DB2 V9, Hyperion Essbase 11,

Hyperion Interactive Reporting. Essbase studio,

Dashboard Studio

Data Modeling : Dimensional Data Modeling, Star join Schema

Modeling, Snow-Flake Modeling, FACT and Dimension

Tables, Physical and Logical Data Modeling

Database Tools : ERWIN, Teradata SQL Assistant, Teradata

Administrator, Teradata Index Wizard, Teradata Visual

Explain, Teradata PMON. Oracle SQL*Plus, Oracle

import/export, Oracle Enterprise Manager, TOAD, SQL

Navigator, DB2 command editor, DB2 command line,

DB2 control center. Essbase Client, Essbase excel add-

on.

PROFESSIONAL EXPERIENCE

General Motors Corporation, Detroit (MI)

Sep 2012 – Present

Cognos Architect

Responsibilities:

Created Metadata Modeling by using multiple databases in Cognos 10.1.1 BI

•

Modeling.

Designed and validated Cognos frameworks as assigned.

•

Created power play transformer OLAP cubes foe end users. Designed the cubes

•

to perform faster with date partition.

Automated cube refreshes after ETL jobs.

•

Responsible for requirement gathering and technical documentation.

•

Responsible for creating Content store, multi-server/ single server installations

•

and Configurations in the cognos8.

Responsible for the data analysis, technical design, implementation and

•

deliverables.

Defined or guided the definition of technical engineering.

•

Provided best practices and processes for day to day operations.

•

Coordinated with Cognos for resolution of any technical issues.

•

Served as Cognos Business Intelligence design expert.

•

Developed Complex Reports in Report Studio.

•

Created Cognos packages by using Framework Manager.

•

Used Query Studio to develop ad hoc reports.

•

Created Dimensionally Modeled relational data (DMR) in Framework Manager.

•

Created Scheduled Jobs by scheduling multiple reports in a job.

•

Gathered Reporting requirements from end users.

•

Published PowerPlay Cubes onto Cognos Connection by using BI Modeling.

•

Generated Data Marts in Star Schema by using Data Manager.

•

Developed dashboards for accurate on-time representation of data and data flow

•

analysis.

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.

•

Analyzed the DMR model for Facts and Dimensions.

•

Detected Determinants in the data source.

•

Resolved Ambiguous relationships in model (DMR).

•

Day-to-day administration activities like monitoring Scheduled jobs.

•

Creating report views with saved prompts and schedule according to the

•

business requirement.

Personalized Cognos Connection, Specified display options, regional options

•

and personal information.

Implemented security in Framework Manager Packages & Reports.

•

Implemented Data & Object security in Framework manager models.

•

Developed Cubes according to business requirements.

•

Environment: Cognos 10.1,Report Studio, Cognos 8.4 BI Query Studio,Cognos

8.4 BI Suite, Cognos Connection, Cognos 8.4 BI Modeling, Framework Manager,

Data Manager, Power play Enterprise Server 7.4, Power play Transformer 7.4,

Cognos Scheduler, Cognos Upfront 7.4, Access Manager, Configuration Manager,

Windows 2000, Oracle9i/10G, PL/SQL, Toad.

Frontier Communications,Raleigh,NC

May 2011 – Sep 2012

SR.Cognos Consultant

Responsibilities:

Developed and Published Packages in FrameWork Manager Connecting and

•

testing the Data Source, created database layer, physical layer and presentation

layer(DMR) model, defining appropriate relationship between query subjects

and fact tables.

Worked with sales data and validate the existing reports against SQL Server

•

Database.

Created reports for Finance users and work with Finance team on creating

•

reports for wall street.

Worked on reporting key Finance metrics like Revenue, expense, EBITDA,

•

Average revenue per customer.

Developed OLAP solutions using Cognos and published Reports using Cognos

•

Connection.

Created changes in the existing models (added few dimensions in Analysis

•

Layer) using Cognos Framework Manager and published packages for reporting

activity.

Implemented IBM Cognos Active Report for portable business intelligence

•

Created relational and multidimensional models using star schema in Frame

•

Work Manager and published packages and implemented for reporting activity

and deployed packages to the Cognos Connection Portal.

Setting up the security in framework manager for packages.

•

Responsible for creating User groups and roles to manage security in Cognos

•

Connection and

Access Rights of the Reports for the end users.

•

Developed the List reports, Chart, Graphs, Crosstab reports, Master detail and

•

Drill through reports and Multi Lingual Reports using Report Studio and

Analysis Studio.

Created complex sales crosstab reports in report studio, with calculated columns

•

and tuples to get grand totals for the sales data.

Assigned Security for (Users access setup, creating Roles, Assigning roles to

•

user, Implementing data level, object level security for Framework model)

Created multiple reports in Report Studio, which are detailed reports for

•

Summary Drill through report, Dashboard reports.

Developed Cascading Prompts which filter data, based on selection and

•

reprompt the data selected based on Conditional prompts and Filters in the

reports.

Created Portlets on cognos connection and embedded reports into portlets.

•

Created views for Summary detail reports and created jobs and scheduled them

•

in Cognos Connection.

Developed cross tab reports (DMR) with drill through, drill up, drill down and

•

complex reports which involved multiple prompts and multi-queries. Worked

with offshore team in various aspects, during development phase of project.

Worked paralley with other projects during development phase.

•

Organized status meetings with manager to give updates about reports and

•

cubes.

Environment:IBM Cognos10.1(Report Studio, Query Studio, Business Insight

Advanced Framework Manager), Cognos8.4.1 (Framework Manager, Report

Studio, Query Studio, Analysis Studio, Cognos Connection), Cognos8.3, Power

Play Transformer 7.4, Power Play Enterprise Server 7, oracle11g(SQL)

New Breed,NC

Nov 2010 – May 2011

Cognos Consultant

Responsibilities:

Extensively worked on converting OLAP

•

data from cognos and Essbase into relational data, data integration and

rationalization.

Worked on capacity planning, server tuning,

•

back up recovery plan for the entire BI contents

Created complex framework manager

•

models,Implemented best practices using Cognos Framework manager.

Reviewing data models and resolving complex problems.

Developed processes and procedures to

•

administer Cognos 8 applications, submitted solutions recommendations for

best practices and standards.

Worked on new business requirements

•

gathering, defining data flow, success criteria development, test plan

development and execution, for meeting reporting needs, managing scope and

business expectations

Expertise in handling Administration tasks

•

like bursting and scheduling the reports.

Expertise in writing java script for

•

customizing the cognos UI.

Extensive experience in Report Studio,

•

Conditional blocks, style variable, render variables, conditional styles and

HTML Items

Expertise in Customizing Cognos

•

connection and experience with Portal Layout.

Expertise in Developing Ad hoc Reports

•

using Query Studio and complex reports using Report studio and Metric studio.

Expertise in developing prompt pages and

•

cascaded input prompts using SQL and Report Studio.

Extensive interaction with Business

•

community and Team members.

Expertise in developing dashboards.

•

Environment: Cognos8.4 (Data Manager, Framework Manager, Report Studio,

Query Studio, Analysis studio, Cognos configuration, Go! Dashboard), AIX

(Cognos installation servers), DB2 9.2.5(Data warehouse), SQL, PL/SQL,

Websphere(Application Server). IBM his Server (Web server), SUN ONE LDAP,

MS Office Suite, Hyperion Essbase, Hyperion Interactive reporting, Hyperion

Btio.

CCSI

(Chrysler Financial Detroit (MI))

Jan 2009 - Nov 2010

Cognos Developer/Admin

Responsibilities:

Involved in gathering Business Requirements for the Model from the business

•

users.

Actively participated in defining the scope of reporting and report specification.

•

Created and presented prototype Models and reports to high level Business

•

users.

Worked on credit risk and dealer credit projects.

•

Created reports to identify credit risks for dealers based on dealership history.

•

Worked on Designing and developing complex reports.

•

Participated in Technical design review for BI applications to ensure

•

appropriate use of Cognos

Queried from different database tables as per the requirement.

•

Designed and developed many packages using Framework Manager and

•

published Packages using Framework Manager.

Developed Standard reports, Drill through report, Master detail reports,

•

Bursting reports using Report Studio.

Established relationships and joins between the query subjects of the Model

•

Implemented object level security for query subjects and query items to make

•

them available only for the end users who are authorized.

Worked extensively on creating the Model and publishing the package

•

on Cognos Connection for Reporting purposes.

Created complex reports which involve Query Prompts, Layout calculations,

•

Conditions & Filters

Developed Multi Page Reports with Prompt pages and Conditional

•

Variables according to the end user requirements

Support the Development Teams for the Cognos related Issues.

•

Involved in unit testing and Functional testing to finalize the Report Accuracy.

•

Wrote the SQL statement for Data validation of Report Studio Reports.

•

Environment:Cognos 8.3, Report Net 1.1 MR3 (Framework Manager, Report

Studio, Query Studio, Analysis Studio ), Cognos Impromptu, Power Play Client,

Power Play Transformer, Power Play Connect, Power Play, Transformation Server,

Power Play Enterprise Server, Upfront, Cognos IWR, Oracle 9i

CCSI Inida.

Jan 2007- Dec 2008 Cognos

Analyst/ Developer

Responsibilities:

• Analyzed Business requirements from the analysts, read functional documents,

and prepared Cognos Reports accordingly.

• Involved in Designing DMR models with Relational Data using Framework

Manager and deployed packages to the Report Servers.

• Created Database Layer, Business Layer, and Presentation Layer, defining

appropriate relationship between Query Subjects and Fact Table in Framework

Manager.

• Worked on bug fixing and enhancements to existing Cognos reports in Report

Studio & models in Framework Manger and development of any new Reports.

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

reports which involved Multiple Prompts in Report Studio.

• Created reports with Optional filters and custom prompt pages in Report Studio.

• Created Drill through reports from Dashboard to all summary/Trend reports,

Trend reports to Summary reports and Summary to Detail reports.

• Developed Dash board reports to display all the information related to

environment using Summary reports.

• Involved in upgrading reports from Cognos 8.2 to 8.4.

• Deployed reports into servers in Cognos connection and applied the needed

level of security.

• 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.

• Coordinated with functional users for User Acceptance Testing prior to

releasing system changes in production.

• Involved in migrating reports from Development to Testing and from Testing to

Production Environments.

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.

Exported IQDs from the Framework Manger and built OLAP Cubes in

•

Transformer according to the business needs.

Environment: Cognos 8.4, 8.2 (Report Studio, Query Studio, Cognos Connection,

Framework Manager, Analysis Studio), Access Manager, Content Manager, Oracle

10g, DB2 IDMS, SQL Server 2005, Toad, SQL, HTML, MS-Access, MS- Excel.

Contact this candidate