Manager Sql Server

Roopa

Email: *****.******@*****.***

Phone # 347-***-****

Professional Summary:

Over 7 years of IT experience in Software Application Design, Development, Testing, Documentation and

implementation of data warehousing applications and experience in OLAP tools

Expertise with Cognos tools such as Cognos 8 Business Intelligence, ReportNet (Framework

Manager, Report Studio, and Query Studio ) Impromptu, Power Play; Impromptu Web Reports

(IWR), Access Manager, and Server Administration on Enterprise, Upfront and IWR Servers.

Designed and analyzed Business and Technical BI Models

Well-versed in developing reporting applications using Cognos 8 Business Intelligence components like

Framework Manager, Report Studio, Query Studio, Analysis Studio, Metrics Studio, event studio, and

Cognos Connection.

Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting

(including the bursting of reports globally) using Cognos. Created complex Dashboards with Area

charts, Pie charts, Cross tabs and Multi prompts in Report Studio.

Involved in Installation, Configuration and administration of Cognos series 8 Suite.

Developed Framework Manager models against relational model and dimensional models – (layers,

star schema, cardinality, relationships, query subjects), create and publishing packages.

Extensive experience in developing multidimensional OLAP cubes in power play transformer using

various data sources and published in Cognos connection.

Experience in Report Authoring using cascading prompts, conditional formatting, drill-through

reports, bursting and HTML Scripting.

Responsible for designing and developing Schemas using Entity Relationships, Data Modeling,

Normalization, creating Tables, Views, Indexes, Sequences and coding .

Extensive knowledge in various Internet related platforms with specialization in SQL, PL/SQL, VB, HTML,

DHTML, and XML.

Working knowledge on ETL tools like Informatics, SSIS in designing data warehousing.

Strong Inter personal communication skills, Ability to provide appropriate attention to details and effective

troubleshooting skills, and ability to work in a team.

Thrust Areas include:

• Created Business Intelligence Reports, OLAP solutions using Cognos Tools

• Provided extensive End User Training and Support

• Implemented Security using Cognos applications.

• Migrated Impromptu catalog to Report Net using Report Net Migration utility

Technical Skills:

BI Tools: Cognos 8.4 BI(Report Studio, Query Studio, Analysis Studio, Metric

Studio, Metric Designer, Go dashboard, Go office, Transformer,

Framework Manager), Cognos Series 7 VERSION 3 Impromptu

Administrator, Impromptu, Impromptu Web Reports, COGNOS Architect,

COGNOS PowerPlay Transformer, PowerPlay User, PowerPlay Web

Reports, PowerPlay Enterprise Server, Upfront Administration, Access

Manager LDAP Server, Configuration Manager, Visualizer, Metrics

Manager.

REPORTNET 1.1(MR 2): Cognos connection, Frame work Manager, Query studio, Report studio,

SDK.

ETL Tools: Informatica

Operating Systems: Windows 95/98/NT/XP/2000, UNIX, Sun Solaris, Linux.

Languages: SQL*Plus, PL/SQL, HTML, DHTML, JSP.

Databases: ORACLE 9i,10g, DB2, MS SQL Server 2000, and MS-Access.

GUI: Developer 2000, Crystal Reports, Erwin, Vision.

Software Packages: MS-Office 2003, Microsoft Word, Excel and Power Point.

Data Modeling Tool: Erwin 4.1, Visio 2000.

Database Tools: Toad, SQL Navigator.

Other Tools: Directory Tool, Server Administrator Tool, Deployment Tool, Capabilities Tool,

Schedule Management Tool.

Contact this candidate