Manager Data

Kishore Devana

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

S U M M A R Y:

. Around 10 Years of experience in the Field of Information Technology,

specializing in Software Design, Development and in the fields of

Internet/Client Server technologies with extensive experience in

Datawarehouse reporting with Cognos 8 Business Intelligence Product(s)

which includes Cognos 8.x SPx BI, Cognos ReportNet 1.1 MRx, Impromptu

7.x, Impromptu Web Reports & PowerPlay 7.x.

. Extensive experience in the full life cycle, design & development

process including analysis, documentation, testing & maintenance of

the Reporting Environments.

. Involved in Company Technical Specification Documentations & Gathering

User Requirements.

. Ability to evaluate and interpret business client requirements, and to

develop appropriate systems and/or application solutions.

. More than 3 years of experience in Cognos 8.x BI Suite including

Framework Manager, and Cognos Connection (Report Studio, Query

Studio).

. Performed Advance & Complex prototyping for Cognos Business

Intelligence Products, PowerPlay, Impromptu and ReportNet 1.1 MR2.

. Hands on experience in Data Modeling Tools Framework Manager and Erwin

3.5/4.

. Involved in Design, implemented normalized multi-dimensional Star

schemas and Data Marts using Erwin

. Extensively worked with SQL Queries and capable of handling Oracle,

SQL Server, Access databases also good experience in Database

performance techniques/Query Optimization Techniques.

. Solid Understanding of OLAP Solutions. Developed OLAP applications

using Cognos tool suite and extract data from the enterprise Data

warehouse to support the analytical and reporting for all corporate

business units.

. Experience in web development using JAVA SCRIPT, HTML, DHTML, XML,

VBSCRIPT, ASP, JAVA, JDBC, SERVLETS, and JSP.

. Involved in the analysis, design and development of applications using

ORACLE, SQL Server, and MSAccess as backend and VB5.0/6.0, Developer

2000 as a front end.

. Experienced in publishing Reports and Cubes to Upfront and Cognos

Connection.

. Good knowledge of Structured Query Language (Oracle SQL) and PL/SQL.

. Knowledge of retail merchandising - order management, sale reporting,

inventory control and reporting.

. Hands on experience in creating PowerPlay Transformer Models for

corporate data, for building Multidimensional PowerPlay Cubes.

. Understanding of Open Database Connectivity (ODBC) concepts and

ability to troubleshoot client-server connectivity issues.

. Expertise in performing certain Administrative Tasks, Creating User

Classes and Restricting the user access with the help of User Class

Privileges.

. Expertise in writing and implementation of the Packages, Triggers,

Stored Procedures, Functions at Database level using PL/SQL.

. Solid background doing Business Intelligence analysis and development

in a Data Warehouse environment using Cognos 8.x BI Suite.

. Provide production support for the reporting and analytic environment

including: Troubleshooting, new user setup, security, training,

performance monitoring.

. Actively involved in preparing presentations to users.

. Confident, independent, creative, self-motivated with strong

analytical and communication skills.

T E C H N I C A L S K I L L S:

BI Products Cognos 8.x BI Suite, Cognos ReportNet1.1 MR2, Framework

Manager, Report Studio/Query Studio 1.1 MR2, Cognos

Connection 1.1MR2, Cognos Series 7 - Upfront, Cognos Query,

PowerPlay Transformer7.3, PowerPlay Enterprise Server,

Impromptu7.3, Impromptu Web Reports 7.3, Access Manager,

Cognos Architect, Power Prompts, Visualizer

Databases DB2, Oracle11i/9i/8i/8.0.x/7.x, MS SQL, Sybase, MS-Access

Languages SQL, PL/SQL, Java 2.0, JavaScript, UNIX Shell Script

GUI Tools Developer 2000, Visual Basic 6.0, Oracle-Developer 2000 (Forms

6i and

Reports6i) Programming, SQL, SQL*PLUS, PL/SQL Developer,

SQL*Loader, Snag IT 8 (The Windows Screen Capture Utility)

Operating Systems Sun Solaris 6/7/8, HP UNIX 10.x/11.0, Windows

NT/2000

Web Servers IIS 4.0/5.0, Apache Web Server, Tomcat 4.01

ETL Tools Datastage 8, Informatica Power Center 6.0, Cognos Decision

Stream 1.1

P R O F E S S I O N A L E X P E R I E N C E:

Walt Disney Studios Home Entertainment, Burbank, CA

Mar 2009 - Till Date

WDSHE Financial Reporting

Walt Disney Studios Home Entertainment (WDSHE) is a wholly-owned subsidiary

of The Walt Disney Company. As part of The Walt Disney Company, WDSHE

distributes and markets products from the Company's various labels

including Walt Disney Pictures, Touchstone Pictures, Miramax Films, Jim

Henson, and ABC Studios (U.S.).

I worked in the finance project Phoenix. This project spans over creating

planning models, building data warehouse and reports. I was responsible for

creating Cognos 8.3 Framework Manager models and reports. Also was

responsible for the production support.

Responsibilities:

. Responsible for gathering business requirements, design, programming,

testing, implementing, and documentation of technical

solutions/application programs according to approved

standards/procedures.

. Designed and developed Cognos 8.3 Framework Manager Models such as

relational and dimensionally modeled relational (DMR).

. Taking part in brain storming sessions for data model design,

performance tuning and project technical implementation.

. Created database, business and dimension views in the FM models.

. Applied appropriate query subjects, namespaces, folders, joins,

cardinalities, and short cuts in the FM model according to the

reporting requirements.

. Developed reports using Report Studio.

. Developed complex reports to build reports that displays Planned vs.

Actual P&L accounts in user selected currencies at user selected

currency rates.

. Developed variance reports compare P&L numbers between various

forecast scenarios and actuals by CBL, territory and formats.

. Provided optimized solutions with appropriate report logic and data

base table/view changes.

. Responsible to develop various capabilities using Cognos BI tools such

as reports perform data analysis, build Dashboards/Scorecards to

monitor business performance and analyze trends and work on the

planned financial data mart vs. Foundation (Actual) data warehouse

build on DB2.

. Designed several PowerPlay Cubes (Title Cube) as per user

requirements.

. Migrated reports and packages from development to production

environment.

. Used the Multiplatform DB2 administration and development tool TOAD

for IBM DB2 to ensure optimal code quality.

. Providing technical guidance to the team members.

. Provide technical support for Cognos 8.3 applications including report

analysis, development, maintenance, and report migration.

. Authored functional specification documentation, technical

specification documentation and user documentation.

. Self-motivated, able to take direction quickly & Involved in

documentation/presentations for users training.

Environment: Cognos 8.3 BI Suite, Cognos 8 Connection/Report Studio/Query

Studio/Analysis Studio, Framework Manager, Cognos PowerPlay 7.3, PowerPlay

Enterprise Server, Transformer 7.3, DB2, Windows NT/ 2000, TOAD for DB2, MS

Project, Snag IT, Cognos 8 Planning - Analyst, Cognos 8 Planning 8.3

Contributor Application.

The Vanguard Group Inc., Malvern, PA

Jul 2006 - Mar 2009

Institutional Systems an IT Subdivision.

Institutional Client Reporting & Online Beneficiary Changes

Vanguard is one of the world's largest investment management companies. The

objective of these project(s) is to create reports out of the ICR-

Institutional Client Reporting Package using Cognos 8.x BI Suite. Upon

completion of this project, the organization will be able to access

standardized reports from the Intranet portal via Cognos 8 BI Product

Suite. This will complement existing reporting process and will provide

reporting to a broader audience that includes: Senior Leadership Team,

Institutional Business Team, CRA's etc., My key role as BI Consultant was

to serve as the application owner ensuring that the suite of Cognos

products comply with company policies, procedures and standards as well as

to the business user requirements. Designed/built several PowerPlay Cubes

as per user requirements.

Responsibilities:

. Responsible for gathering report requirements from the users.

. Responsible for the design, development, deployment and support of

high profile Cognos 8.3 based reporting systems that help end users

access and Analyze data across data warehouses and Enterprise Data.

. Involved in Planning a Migration from Series 7 to IBM Cognos 8 BI and

ensure that the migrated application is the same as, or better than,

the original application.

. Work closely with user groups, database administrators, application

developers, systems administrators and testing teams.

. Published Packages to Cognos8 Portal and these Packages are used in

developing reports in Report Studio. Exported the finalized Package to

various Environments like INT/SAT/CAT/Perf & assisted the TE Cognos

Support Team in Exporting the metadata to PROD. Regions.

. Developed reports in report studio using prompts, parameters, filters

and conditional formatting.

. Develop and publish new Packages using Framework Manager.

. Design sophisticated reports using adaptive layouts. Manage reports in

Cognos Connection.

. Involved in the documentation of the custom Cognos Reports.

. Applied Security to Cognos Implementation.

. Designed Cognos Data Model(s) using Framework Manager and created the

Business View according to business requirements.

. Implemented several JavaScript's to customize the Report output per

user requirements.

. Applied Query Optimization techniques to the Reports for better

performance.

. Create and distribute complex professional reports, as well as perform

advanced customization of existing reports to meet specific business

needs.

. Work with Cognos Support personnel in troubleshooting problems.

. Designed several PowerPlay Cubes as per user requirements.

. Participate on multiple projects at one time, while maintaining a high

level of customer service and focus on project deliverables.

. Worked on the Retail merchandising industry developed reports for

their order management, sale reporting, and inventory control.

. Developed various crosstab reports and developed analysis using

Analysis Studio.

. Helped the Business Analysts/Team understand how the Cognos 8BI

technology works and set standards within Vanguard Enterprise

Reporting Environment.

Environment: Cognos 8.3/8.1 BI Suite, Cognos 8 Connection/Report

Studio/Query Studio/Analysis Studio, Framework Manager, Cognos PowerPlay

7.3, PowerPlay Enterprise Server, Cognos Impromptu 7.3, Transformer 7.3,

Impromptu Web Reports (IWR), RUMBA Mainframe Edition V7.4, DB2, Oracle SQL

*Plus: Release 10.2, Oracle 9i, Windows NT/ 2000, Erwin, Cognos Upfront.

Eaton Corporation Aug

2005 - Jun 2006 FPG Hydraulics - Division, Eden Prairie, MN

Hydraulics Sales & Margin Analysis

The objective of this project is to create reports out of the FPG-

Hydraulics Data Warehouse using Cognos ReportNet. Upon completion of this

project, the organization will be able to access standardized reports from

the Intranet portal via Cognos ReportNet. This will complement existing

reporting process and will provide reporting to a broader audience that

includes: Senior Leadership Team, Product Management, Sales Management,

Finance, Pricing, etc.

Responsibilities:

. Reporting to the Manager of Data Warehouse and Reporting, work

extensively with the Business Analysts

. Responsible for performing analysis, design, development, testing, and

deployment of Cognos ReportNet Reports/PowerPlay Cubes to the

corporate and field business users.

. Involved in created Models and Packages in Framework Manager1.1 to

report across the Datamarts.

. Involved in Framework Manager Setup, migrate Packages from Development

to Production Environments. Familiar with steps involving Development

Export and Production Import.

. Customize reports with Conditional Formatting.

. Involved in Creating a Burst Report utilizing a Burst Table that

places its output in a Directory.

. Involved in identification of dimensions and measures for creating the

Datamarts, the fact and dimension tables to suit to the needs of the

Cognos Reporting functionality keeping in view the performance and

maintenance.

. Involved in Design and development of cubes & reports using Cognos

PowerPlay Series 7.x

. Designed new IQD's from the Star Schema per user requirements and

built the Sales and Margin - Cube containing Americas Data from the

Datamart.

. Effectively used conditional formatting to enhance the design of the

report.

. Created IQD's from Cognos Framework Manager to use in Cognos PowerPlay

Transformer.

. Involved in Setting Up Drill-through Access from PowerPlay Web.

. Worked with the Corporate Team in Creating and Scheduling the Maestro

Job as a result the Sales and Margin - Cube refreshes on monthly

basis.

Environment: Cognos ReportNet v1.1, Cognos Connection, Report Studio,

Framework Manager1.1, Cognos PowerPlay 7.3, PowerPlay Enterprise Server,

Cognos Impromptu 7.3, Transformer 7.3, Impromptu Web Reports (IWR), Oracle

9i, SQL Server 2000, PL/SQL Developer, Windows NT/ 2000, Erwin, Cognos

Upfront.

Broward County, Fort Lauderdale, FL

June 2004 - Aug 2005

Advantage 3 Financial Upgrade: ADVANTAGE 3 Financial employs a pervasive

government fund accounting model as its foundation using open Web

technology standards to simplify deployment and enable collaboration with

external systems. ADVANTAGE Financial is the baseline product, which

includes Chart of Accounts, Budgeting, Accounts Payable, Cost Accounting,

and General Accounting.

Responsibilities:

. Created Models/Packages in Framework Manager1.1 and published to

Cognos ReportNet Server.

. Involved in Segmenting, Linking and Synchronizing the Framework

Manager Model.

. Involved in creating Framework manager security by restricting access

to model metadata and data across Cognos ReportNet products.

. Created Reports in ReportNet using Report Studio1.1

. Working with Data and Existing Reports, managed changes in the Model

using Report Studio.

. Involved in creating prompts, cascading prompts, report templates,

drill through, exception highlighting in Cognos Report Studio1.1

. Involved in accessing and scheduling reports in Cognos Connection web

portal.

. Deployed Packages and Reports from Development to Production Server.

. Involved in Creating users, user groups and their roles in Cognos

Connection.

. Created specifications and technical specifications for the reports.

. Creating Standard Reports Based on Technical Specification Using

Report Studio.

. Actively involved in gathering requirements from the end uses.

. Interacted / Involved with ETL team to identify the required data for

developing the reports is being loaded into the data mart.

. Designed and created catalogs and Impromptu reports for the VSS team.

. Generated simple list, cross tab and sub reports for detailed

analysis.

. Developed PowerPlay cubes to generate drill-down analysis reports.

. Developed Prototype and gave demos to the End Users for user

acceptance.

Environment: Cognos ReportNet v1.1, Cognos Connection, Report Studio,

Framework Manager1.1, Cognos PowerPlay 7.3, Cognos Impromptu 7.3,

Transformer 7.3, Impromptu Web Reports (IWR), Oracle 9i, TOAD, Windows NT/

2000, Erwin, Cognos Upfront, Web Logic 7.0 and UNIX.

GE Capital Corporate, Stamford, CT

May 2003 - May 2004

This project involved developing Cognos reports/cubes. The project also

involved development of sample reports and cubes for other departments for

evaluating Cognos for the respective requirements. Worked as a BI

Consultant and used Impromptu, PowerPlay and ReportNet 1.1 as standard

reporting tools.

Responsibilities:

. Conducted User Interviews and documented their query, business

analysis & reporting needs.

. Used Cognos Report Studio 1.1 to generate Simple as well as Complex

Reports.

. Involved in creating and developing catalogs, impromptu reports as per

user requirements.

. Created PowerPlay reports and multidimensional cubes.

. Customized data by adding calculations, summaries and functions.

. Involved in creating User classes and granting access to Users in

Access Manager.

. Used various functions for calculation and manipulation using Cognos

Impromptu.

. Created Complex Reports, List Reports, Cross-tab Reports and Drill

through Reports.

. Worked with Transformer to create models by using IQD as Data source.

. Designed and developed the PowerPlay Cubes and Drill through cubes.

. Involved in Performance tuning of PowerPlay Cubes, Impromptu reports

and IWR reports.

. Enhancing existing Power Cube as per user requirements.

. Work with data modeler to develop data mart models.

. Involved in Incremental updates of power cubes.

. Involved in fixing report defects in testing environments.

. Documented functional specifications and design procedures.

. Involved in Project Documentation Guidelines (PDG).

Environment: Cognos ReportNet 1.1, Cognos Impromptu 7.3/7.1, Cognos Access

Manager 7.1, Impromptu Web Reports 7.1 (IWR), ReportNet 1.1, Framework

Manager, Cognos Connection, Report Studio, Query Studio, PowerPlay 7.3/7.1,

PowerPlay Transformer 7.1, Power Cube, Cognos Upfront, MS Access,

Hummingbird Connectivity 7.1.1, ORACLE 8i, Visio 2000 for Windows, HTML,

Windows NT, UNIX.

GMACI, St.Louis, MO

Jan 2002 - Apr 2003

GMAC Insurance, a leader in the insurance industry, innovates new ways to

protect and serve customers every day. In this project auditing business

needs of child companies were converted to a reporting view using Cognos

Impromptu with DB2 database, also used Cognos PowerPlay for

multidimensional analysis of data.

Responsibilities:

Developing and Customizing Impromptu Reports/Power Cubes, PowerPlay

. Designed Created and maintained catalogs.

. Worked closely with business analysts to understand and document

business needs for decision support data.

. Customized data by adding calculations, summaries

. Queried from different database tables as per the requirement.

. Created List Reports, Group Reports and Cross Tab Reports with Drill

through and Drill Down Functionalities.

. Created the Business Mix report and Top Ten reports.

. Created reports in HTML Format for easy navigation of data from web

browser.

. Created standard and Ad hoc reports using Cognos Impromptu tool.

. Created Impromptu Web Reports (IWR) and published them in the web

server.

. Created Cubes using PowerPlay Transformer for multidimensional (IQD)

reports.

. Worked with PowerPlay time dimension analytical reports using date

wizard

. Created calculated fields in transformer for the analytical data.

. Customized PowerPlay reports using drill through and charts where

needed

. Worked with Cognos transformer creating manual levels dimensions and

sub dimensions as per the requirements

Environment: Cognos PowerPlay 6.6, Cognos Impromptu 6.1, Transformer 6.6,

People Soft, Oracle 8i, Impromptu web reports (IWR), Informatica Power

Center/6.0, Oracle 8.i/9i, Windows NT, SQL, DB2, SmartFTP

Novartis Pharmaceuticals, East Hanover, NJ

Jul 2001- Dec 2001

Novartis Pharmaceuticals a leader in the Pharmacy industry, innovates new

ways to protect and serve customers every day. The Novartis Pharmaceuticals

products/brands are the nation's oldest and largest family of health

benefits companies and the most recognized brands in the health industry.

Responsibilities:

. Involved in generation of simple and complex reports.

. Involved in Installation and configuration of IWR and Access Manager.

. Published and maintained reports in Upfront.

. Created Cubes with different Data Sources using Oracle and MS SQL

Server.

. Develop data standardization approaches in data warehouse activities.

. Created simple, complex reports using Impromptu 7.1

. Created Dimension and Detail tables for Star Schema Design Database.

. Published Impromptu Reports on the web using IWR

. Created filters, prompts, sub reports and provide drill through

capabilities

. Implemented logical and physical data modeling with STAR Schema using

Erwin in Data Warehouse as well as in Data Mart

Environment: Cognos Impromptu 7.1, Cognos Access Manager, Cognos

Scheduler, Cognos Script Editor, Cognos Macros, Impromptu Web Reports,

Report Administration, Server Administration, Erwin, SQL, PL/SQL, Oracle

9i, Oracle 7.x, Windows NT/Unix.

Raasi Soft, India Dec 2000 - May

2001

Financial Data Mart

Raasi Soft is involved in developing applications in Client/Server areas,

using proven methodologies and tools. Raasi Soft has executed full life-

cycle project using a multitude of databases, languages and tools.

Responsibilities:

. Designed, developed and maintained Financial Data Mart.

. Created dimensions and facts in physical data model using Erwin tool.

. Involved in using ETL and Informatica to load data from MS SQL Server

and Excel spreadsheet into target Oracle 7.0 database.

. Created Power cubes, Dimensions using Cognos BI Tools and IQD files.

. Created Standard and Ad-hoc Impromptu Reports.

. Building Power Cubes using Transformer and scheduling using Scheduler.

. Implementation of Impromptu reports and PowerPlay cubes using multiple

queries.

. Acted in a consulting role to report authors at the client site.

. Worked on the retail merchandising - order management, sale reporting,

inventory control and reporting

. Activate the Cognos Scheduler to run the Reports in Specific

Intervals.

. Cognos PowerPlay and Impromptu is used for analysis and publishing the

Reports thru IWR.

. Developed transformations like joiner, aggregate, filter, update

strategy.

Environment: Cognos Impromptu 6.0, Cognos PowerPlay/Transformer 6.0, SQL

Server, Oracle 7, Erwin 3.5, Oracle 7.3/8.i

Sunshine Software Services, India Mar 2000 - Dec

2000

Online Examination Package

www.eamset.com

This is implemented as 3-tier Client Server Architecture. The user can log

on to it and can take a preparatory test after choosing the subject,

duration difficulty level etc. The question bank is maintained and the

questions are chosen randomly on the basis of difficulty level, subject

etc.

Responsibilities:

. Developed Servlets for responding to the client's requests.

. Developed Servlets for providing the assessment and maintaining the

session information during the test period.

. Created customized forms using HTML.

. Developed the connectivity to the Oracle database Server (Using JDBC).

. Used JavaScript for Client side Validations.

Environment: Java, Servlets, AWT, HTML, JavaScript, Oracle, Windows 98/NT

and Symantec Visual Caf

Education:

Bachelors of Engineering from University of Madras, India.

Contact this candidate