BI Specialist

Rajesh Manne

248-***-****

**** ******* *** *** *** Elkridge MD 21075

Summary

. 10 years of extensive experience in IT industry and about 7 years on

Administration in the areas of analysis, design, development in client

server environment, With focus on Data warehousing and Business

Intelligence applications using ETL and OLAP tools like Informatica,

Cognos, ReportNet with Netezza, Oracle, DB2, MSSQL Server.

. Around 9 years of experience with Cognos Business Intelligence tools

. Worked in Data Warehouse and Business Intelligence Projects along with

the team of Informatica, Cognos 10, 8, Cognos ReportNet, Impromptu and

Powerplay.

. Expertise in Cognos 6.x/7.x, ReportNet1.1MR1, MR2, Cognos 8/10 and

Informatica.

. Around 4 years of experience with cognos 10.x and 5 years of experience

in Cognos 8 RTM, MR2, 8.2 and cognos 8.4 administration and development.

. Experience in Cognos Dynamic Cubes and Dashboard design using RAVE

visualizations.

. Expertise on the usage of Cognos 10, 8, ReportNet, which includes

Framework Manager, Query Studio, Report Studio, Event Studio, Analysis

Studio and Metric Studio and Cognos Connection.

. Excellent Knowledge in Data modeling, Logical/Physical model & ER-

Diagrams

. Excellent knowledge in data warehouse development life cycle,

requirements analysis, dimensional modeling, Repository management and

implementation of STAR, Snowflake schemas, Incremental loads/Change Data

Capture and slowly changing dimensions.

. Worked with heterogeneous data sources like Netezza, Oracle, SQL Server,

flat files, XML files, DB2.

. Experience in performance tuning, advanced SQL queries and stored

procedures.

. Strong experience with client interaction, understanding business

applications, business data flow and data relations.

. Worked on the Performance Analysis for the reports created and optimized

the reports for performance by creating views and indexes in the

database.

. Excellent analytical, problem solving, communication skills and

interpersonal Skills and consistently being organized by management and

peers for producing high quality works.

Technical Skills

OLAP/BI Tools: Cognos 10x, Cognos 8.4, Cognos 8.2, Cognos 8 RTM, MR2m,

Cognos Report Net 1.1MR1, MR2 (Cognos Connection, Framework

Manager, Report Studio, Query Studio), Cognos EP Series

7.x(Impromptu Administrator, PowerPlay, PowerPlay

Transformer, Enterprise Server, Architect, Access Manager,

Visualizer, Upfront).

ETL Tools: Informatica (Power Center/ Power Mart) Client Tools

(Repository Mgr,

Designer, Server Mgr and Informatica

Server), DataStage.

Languages: VB, Java, Java Script, HTML, XML, SQL, PL/SQL and C.

O/S: Sun Solaris 8.0, UNIX, IBM AIX 4.3/4.2, Windows 98/NT/2000/2003/2008.

Tools: Dimensional Modeling, Star Join Modeling, Snow - flake Schema

Modeling, Erwin 3.5.2/4.0, Microsoft Visio.

Databases: Oracle 7.x/8.x/9.x/10x/11x, SQL Server 2003/2005/2008, DB2

UDB 7.x/8.x,

Sybase MS Access, Netezza 5x/6x.

Certifications

IBM Cognos 10 Metadata Modeling (Framework Manager).

IBM Cognos 10 BI Report Designer

Contact this candidate