Manager Sql Server

Roopa

Sr. Cognos Developer

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

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

Professional Summary:

. Over 7 years of experience in Business intelligence reporting, Design,

Development, Testing and Documentation implementation of Cognos

applications and maintenance of data warehouses, data bases, data marts

and providing solutions for Health care, Insurance, and Banking domains.

. Experienced in various Cognos tools such as Cognos 8 BI Suite (Framework

Manager, Report Studio, Cognos Connection, Metric studio, and Query

Studio), Report Net, Impromptu, Power Play Transformer; Impromptu Web

Reports (IWR), Access Manager, and Cognos EP series 7.

. Involved in installation, configuration and administration of Cognos

series 8 suite, Report Net.

. Well-versed in developing reporting applications using Cognos 8 BI

components ( Framework Manager, Report Studio, Query Studio, Analysis

Studio, Metrics Studio, event studio, and Cognos Connection).

. Developed and Published Packages using Framework Manager - Connecting

and testing the data source, created database layer, physical layer

and presentation layer, defining appropriate relationship between

query subjects and created filters, prompts, calculations, summaries

and functions in Framework Manager.

. Implemented security at different levels in Framework manager and

Cognos Connection to restrict access.

. Expertise in Report building using Report studio, Query Studio, and

Analysis Studio.

. Complex Report building experience in Report studio by using filters

customized prompts, conditional formatting, drill-through, Cross tab,

bursting, Master/details queries, and HTML Scripting.

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

. Expertise in OLTP/OLAP system study, analysis, E-R modeling and

developing database schemas like Star schema and snowflake schema.

. Experience in Designing Transformer models and developing for corporate

data for building Multidimensional Cubes (MOLAP/OLAP/ROLAP).

. Involved in migration and deployment of applications from EP Series 7 to

Report Net/COGNOS8 and COGNOS8.2 to COGNOS 8.3 and 8.4 Versions.

. Extensively worked on Relational databases like SQL server

2000/2005/2008, DB2, Oracle 11g/10g/9i, and MS Access.

. Having knowledge on ETL tools like Informatica and all Informatica

Designer tools including (Source Analyzer, Warehouse Designer,

Transformation Developer, Mapping Designer and Mapplet Designer).

. Extensive knowledge on various Internet related platforms with

specialization in SQL, PL/SQL, VB, HTML, DHTML, and XML.

. Involved in Extraction, Transformation, and Loading (ETL) Solutions using

SQL server integration services (SSIS) and developing reports using SSRS

and SSAS.

. Good knowledge in Business insight and Cognos 10. Knowledge in Cognos

planning Application (TM1) and Cognos SDK.

. Strong troubleshooting and production support skills and interaction

abilities with end users.

. Strong Inter personal communication skills, Ability to provide

appropriate attention to details and effective troubleshooting skills,

and ability to work in a team.

. Provided extensive End User Training and Support.

. Self-motivated and enjoy working in a technically challenging

environment. Possess excellent.

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, 11g, 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.

Professional Experience:

Active Outdoors

Mar'10 - Till Date

(Division of Active Network, Jefferson City, Mo)

Sr. Cognos Developer

Active Network powers the world's activities and Connect people with the

things they love, want and need to do. This was a new project to Wild Ohio

Customer Relationship Management System (WOCRMS). The reports were

developed for users to provide the information related to Hunting and

Fishing Licenses such as customer's names, license numbers..Etc. The

reports were delivered on timely basis. Cognos was used for the reporting

requirements.

Responsibilities:

. Involved in Requirement gathering from Business users.

. Working with users and coordinating with application developers to

understand and capture data/reporting requirements, and developing

specification documents for reports as per requirements.

. Used Cognos 8 BI Framework Manager to Build Models (Semantic layers,

Cardinality, Relationships, Query subjects), Packages and publish

packages to Cognos connection and implemented security for the

packages.

. Created complex reports using Cognos 8 BI Report Studio and Ad-hoc

reports using Query Studio.

. Developed complex reports from lists, Cross-tabs through Complex

dashboards, Conditional formatting, Drill through, &master/detail

reports for End users.

. Created Complex dashboards and published to Cognos Connection portal.

. Developed multidimensional models (DMR) and published packages using

framework manager and then generated reports from these packages.

. Created Cubes (MOLAP/ROLAP) using IQD's which were built in Framework

manager.

. Created prompts, Calculations, Filters, Developing Prompt pages and

Conditional Variables using Report Studio.

. Created and supported Cognos Transformer models and cubes. Involved in

implemented security at transformer level by creating custom views.

. Tested and validated the Report output against database to measure

performance of reports.

. Scheduling and Distributing Reports through Schedule Management in

Cognos Connection. Involved in Performance Tuning the reports in

Report Studio.

. Deployed Reports, Packages and Folders from DEV to UAT and from UAT to

Prod environment.

. Involved in writing Queries in SQL server. Trained end users

effectively to use reporting tool, to build and customize their Ad-hoc

reports.

. Involved in extraction, transformation, and loading (ETL) solutions

using SQL server integration services.

. Involved in developing reports Ad-hoc and standard reports using SSRS

and SSAS.

. Extracted the data from Relational Database, Flat Files and Loaded

into the target Data warehouse.

Environment : Cognos 8.4.1 Cognos Connection, Framework Manager, Query

Studio, Report Studio, Analysis Studio, Transformer,DB2, SQL

Server2005/2008(SSIS, SSAS, SSRS), TOAD, Windows XP.

Care Medic Systems Inc., FL

Aug'09 -Mar'10

Sr. Cognos Developer

CareMedic Systems, Inc. is an industry leader in providing proactive

financial management technology. This project was developed for providing

hospital customers information with robust reporting capabilities. The

reports were developed for users to provide the information about the

patients. The reports were presenting on daily basis.

Responsibilities/Accomplishments:

. Gathered requirements from business users. Created models in framework

manager and creating standard to complex reports in report studio.

Created Dashboards, Executive reports in Report Studio using MDX

functions.

. Standardized prompt pages for consistent user experience and to let users

choose between different filters.

. Developed Standard Reports, List Reports, Cross-tab Reports, Charts,

Drill through Reports and Master Detail Reports Using Report Studio.

. Developed reports using various functionalities like Drill through,

Master Detail, Conditional Formatting, Conditional Blocks and multiple

Prompts in Dash Boards.

. Modified reports to use SQL server functions as the database migrated

from Oracle to SQL server.

. Updated Framework Manager Model based on the requirements (creating

aliases, relationships, shortcuts, calculations, filters, packages,

importing metadata, database functions, etc

. Designed Dimensional Data modeling, Star Schema/Snowflake modeling, FACT

& Dimensions tables, and Physical & Logical data modeling, and defining

relationships and cardinality between Query subjects.

. Created multidimensional models (DMR) and published packages using

framework manager and then generated reports from these packages.

Developed dashboards with list, charts, and crosstab. Created ad hoc

reports using Query studio based on requirements.

. Used scripting techniques to achieve those that are not straight out of

the Cognos box.

. Extensively used Transformer to move relative Data Mart's data into Power-

Cubes and cube groups by designing Dimensional Maps and Transformer Model

to perform On-Line analytical processing (OLAP). Created reports (in

Report Studio) using Cube sources and Created Portal tabs based on the

requirements.

. Set up for version controlling of the Framework Manager model using VSS

(visual source safe).

. Migrated Reports, Packages and Cubes using Content Administration.

Experienced in writing Oracle PL/SQL queries, stored procedures,

triggers, packages, and functions.

. Set up for emailing the scheduled reports in Cognos connection. Created

Chart palettes with company branding colors. Help power users understand

features of Analysis Studio.

Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio,

Analysis Studio, Transformer, metric studio, Cognos Connection), Oracle,

SQL Server 2005, Windows 2003.

Liquid net, NY, USA

Jan'08 -

Jul'09

Senior Cognos Consultant

Liquid net is the premier institutional investment community, bringing

together the world's largest asset managers and public companies on a

single network that directly connects traders, portfolio managers, analysts

and corporate issuers. This project was developed for providing the

flexibility, scalability, reports in variety of formats.

Responsibilities:

. Involved in analysis, design and gathering of requirements for

project.

. Created Projects, Models (layers, relations, cardinality, Query

subjects, star schema and packages) and Published Packages using

Framework manager.

. Created Metadata Modeling by using multiple data sources in Cognos 8

BI Modeling.

. Used Report Studio to create standard reports and complex reports with

drill through, master detail relationships, cascading prompt, complex

layout, conditional formatting, and user interactions. Created

Calculations, Prompts and conditions in Reports.

. Developed standard reports, Ad hoc reports, jobs, events, Dashboards,

and portals based on requirements.

. Bursting and scheduling the Reports using Cognos connection. Involved

with testing and exploring tools using Query Studio and Report Studio.

. Train/transition knowledge/documentation to the entire Cognos team.

. Used Framework manager to develop the metadata model and the reports.

Defining appropriate relationship between query subjects. Created

design documents for Framework Manager and Report studio (Current

reports details)

. Developed reports with Drill through capabilities. Upgraded Cognos 8.2

reports to Cognos 8.4.

. Involved in defining the data, object and package level security in

FM. Involved in Upgrading from old version to new version. Created

tabular sets with except, unions, as well as master and detail

queries, dashboards and multidimensional reports using Analysis

Studio. Created custom portals based on metrics and custom reports on

Metric Packets.

. Modified reports in Cognos 8.4 using Report Studio, applied best

practices and new features available in Cognos 8.4.

. Involved in planning and execution of Unit testing and UAT. Involved

in end client discussions to make sure UAT go through successfully.

. Developed the SQL scripts to populate the tables in various stages

including staging area. Created and modified database objects like

tables, views and constraints. Participated in Weekly status meetings

with Developers, Testers and Users.

Environment:

COGNOS 8.2BI (Framework Manager, Report Studio, Analysis Studio, Query

Studio, Metric Studio, Event studio, Metric Designer, Transformer), COGNOS

8.1(Frame work Manager, Report Studio, Metric Studio, Analysis Studio,

Query Studio) DB2 8.2.4, UNIX(AIX64).F-Secure SSH Client, DB2 Control

Center, TOAD.

Aviva USA, Des Moines, IA

May'07 - Jan'08

Senior Cognos Consultant

Aviva USA is part of Aviva plc, which has a corporate lineage dating back

to 1696, and is the fifth-largest insurance group in the world. One of the

fastest-growing U.S. life insurers, Aviva USA offers a competitive

portfolio of long-term savings, insurance and retirement income products

generated sales officer production report package for sales team to find

out day to day status of paid and pending by Line of business, channel,

RVP, Product Mix and Marketing Name for life and annuity Products

Responsibilities:

. Worked with Business Units to define strategy and create a centralized

reporting capability for users to perform analytical, and ad-hoc

reporting for business applications and provide accurate information

available to Decision Makers.

. Designed and developed Technical Specs and Test scripts for all the

reports.

. Used Cognos Report studio as the web reporting solution of choice by

conducting product demonstrations and improve business performance at

all levels of their enterprise.

. Used Cognos Connection for organizing, security, scheduling and

distributing reports.

. Building models and publishing packages in Framework Manager.

. Development of filters, calculations, prompts, conditions and created

various reports, using Cognos Report Studio for their several projects

Life and Annuity Paid and Pending Productions.

. Developed Prompt Pages and Cascaded input Prompts to display only the

selected entries in the report.

. Responsible for the delivery of solution-oriented complex reports

using Cognos Report Studio and Development of ad-hoc reporting

interfaces using Cognos Query Studio.

. Validated the Data in newly created CDW (Common Data Warehouse)

against the old Data sources.

. Validated the reports in Cognos against the existing Business Object

reports.

. Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, and

Master Detail Reports using Report Studio.

. Created Dashboards based on requirements. Created Notifications and

Alerts for the Reports that are critical in budget calculations using

Event Studio

. Scheduled and Distributed reports using Schedule Management in Cognos

Connection

. Conducted User training for hands on usage for the new reports & cubes

created for the users.

. Conducted UAT with Business users, for the sign off of the project

work completed.

Environment: COGNOS 8.2BI (Framework Manager, Analysis Studio, Event

Studio, Metrics Studio, Metrics Designer, Report Studio, Query Studio),

Oracle 9i, TOAD, MS SQL Server 2000, Linux and Win2K.

GE Aircraft Engines, OH USA

Feb'06 - May'07

Cognos Developer

Description: GE Aircraft Engines (Aviation) is the world's leading

manufacturer of large jet Engines. Fleet Data Management system tracks the

details of the flight orders, flight deliveries, causes to delay, defects

and maintenance details including schedules. Collects the historical fleet

data, establishes baseline, identify future changes/requirements and

forecasts the future cost.

Responsibilities:

. Generated Trend over Time, Variance Reports

. Developed cross-tab and used context, user defined filters.

. Created nesting of data to provide a broader perspective of the business.

. Enhanced reports using Conditional Formatting in Report Studio.

. Created prompts to let users choose between different filters.

. Administer the metadata modeling in Cognos Impromptu Catalog.

. Developed the power play model and implemented the security in the

transformer models.

. Designed and development of power play reports.

. Performed Migration of series 7 catalogs and impromptu reports to Report

Net.

. Published the cubes to Upfront and Cognos Connection (Created URL for the

Series 7 Power play cubes and visualizer dashboards in Cognos

Connection).

. Automated Scheduling of reports, maintained public and individual

folders, distribution lists, user groups and roles using Cognos

connection.

. Enabled the drill through from power play cubes to Report Net Reports

(Report Studio).

. Enhancements and bug fixes of existing applications.

. Used Appworx to schedule the power play cubes.

Environment: Oracle9i, Cognos Impromptu, Cognos Transformer, Cognos Power

Play, Cognos PPES Administration, Cognos Impromptu Web Report

Administration, Cognos Report Net, Access Manager, Toad, Appworx, Unix.

Sonata Software Ltd. Bangalore India

Mar'04 - Jan'06

Cognos Developer

Responsibilities:

. Gathered and analyzed user requirements. Created various catalogs based

on different data sources.

. Created and modified catalogs, catalog prompts, filters, conditions and

calculations. Modified existing Impromptu Catalogs for efficiency and

better usability. Developed different types of Reports using Cognos

Impromptu 6.0 and Power Play 6.0. Developed Impromptu Web Reports (IWR)

and published using Upfront.

. Created List, Sub-reports and Cross-Tab reports using Cognos Impromptu.

. Developed complex reports using multiple frames and sub reports.

Scheduled reports & tasks using scheduler.

. Created Multi-Dimensional cubes using Impromptu Query Definition (IQD)

files in Power Play Transformer.

. Developed business mix reports, Trend over time reports, Ranking &

variance reports using Cognos Power Play. Implemented drill-through

from Power Play cubes to Impromptu report. Provided end user training

and support.

Environment: Cognos Impromptu 6.0, Cognos Power play Transformer 7.3,

Visualizer, Cognos Upfront, Oracle8i, Windows NT/2000, UNIX and Access.

Projects Executed:

. Credit Information Systems: This reporting system developed for City Bank

Ltd., to keep track of customers and their credit information. Developed

in Oracle & Cognos Impromptu, Power Play.

. Children's Hospital: Medical Records Department maintains all the data of

the patients. This project stores all the information in a database,

which has 8 tables in it. The retrieval, modification of the data is done

by the user through the forms. Six forms are used in the project. The

project has four modules namely General, Inpatient, Outpatient, Reports.

. Employee Management System: This is desktop application developed for a

Chemical company for employee management. This application was developed

in Visual Basic & MS Access with reporting in Crystal Reports.

. Management Information System: This is a desktop application developed in

MS Access for an educational institute to keep staff & student records.

Contact this candidate