Manager Sql Server

Vineeth KalvaCognos Reportnet Developer

Phone: 503-***-****

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

Resumes ID: 49147

Location: El Segundo, California

Posted: 05.02.2012

Resume Details:

Strong working experience in Data Warehousing applications along with expertise in Data Modeling tool Framework Manager and Erwin4.0

Extensively worked on Transformer for Data Modeling of the corporate Data for building Multi-Dimensional Cubes.

Knowledge of Data Analysis & Building reports using Cognos 8 Studios also well versed in developing reporting application employing Cognos ReportNet components like Framework Manager, Query Studio, Report studio, Analysis Studio, Metric Manager and Cognos Connection.

Experience in installation and optimization of the Cognos 8 environment in both multi server and single server installation.

Hands on experience in working with various Cognos BI tools on databases such as Oracle, SQL Server and MS Access.

Expertise in gathering user requirements and preparing specification documents and focused on Data warehousing, data Modeling, ETL and OLA/DSS tools.

Technical Skills

Data Warehousing Tools

Cognos 8 (Report Studio. Query Studio, Event Studio, Analysis Studio, Cognos Connection, Frame work Manager),Cognos ReportNet 1.1 MR2,Cognos Impromptu 7.3/7.1/7.0/6.6/6.x, Cognos Transformer7.3/ 7.1/7.0/6.6/6.5 and PowerPlay 7.3/7.1/7.0/6.6/6.5, Cognos Architect 7.0, Cognos Query 7.0, Data Modeling ERwin 3.5.2/4.0

Data Modeling

ERWIN 4.0, Star-Schema & Snowflake-Schema Modeling

Modeling Tools

MS VISIO, UML

DATABASE

DB2, Oracle, SQL Server

Operating Systems

UNIX 5.0, Windows XP/NT/2000 and MS-DOS

WEB

HTML, XML

Experience

CognosReportnet Developer

DirecTV provides television and audio services to subscribers through satellite transmissions. Services include the equivalent of many local television stations, broadcast television networks, subscription television services, satellite radio services, and private video services.

Responsibilities:

Involved in Administering, Developing and implementing web reports using ReportNet.

Authored professional reports using report studio and created ad-hoc reports using query studio.

Published package from ReportNet Framework Manager to Cognos Connection Server.

Created filters, prompts, and calculations in Report Studio and Framework Manager.

Created user classes, groups and provided authentication for the secured access.

Created Trend over Time reports to identify developing trends.

Set up access permissions for entry in order to create permissions or updating existing permissions.

Migrated impromptu catalogs and architect models into framework manager to create new model or enhancing an existing metadata model.

Installing and Configuring Cognos Reportnet.

Created detailed and summarized reports using query studio.

Developed reports using Cognos Impromptu Administrator.

Created PowerPlay multidimensional Cubes using PowerPlay Transformer.

Developed PowerPlay reports using Cognos PowerPlay.

Published Impromptu Web Reports (IWR) using Upfront.

Involved in using Cognos Framework Manger IQD’s in Cognos PowerPlay Transformer.

Used Cognos Scheduler to schedule various reports in Cognos Connection.

Environment: ReportNet 1.1, Cognos Connection, Report Studio, Query Studio, Framework Manager, Impromptu 7.3, Impromptu Web Reports 7.3 (IWR), Cognos PowerPlay 7.3, Scheduler, Access Manager, Upfront, Windows 2000/XP, CognosImpromptu Administrator 7.3, PowerPlay Transformer, Oracle 9i, SQL, Windows 2000/NT

Congos 8.4

TracFone Wireless Inc., Miami, FL April 2007- May 2009

TracFone 1.1

TracFone Wireless is the leading provider of nationwide prepaid wireless telecommunications services. It is a subsidiary of America Movil, Latin America’s largest mobile phone provider with more than 66 million wireless subscribers across the continent. The management needs various reporting needs involving calculations and analyzing business needs in various dimensions

Responsibilities:

Involved in meeting with end user in gathering requirements.

Designed, Developed and Implemented an Enterprise Wide Reporting system using Cognos 8.3.

Installed and configured the Cognos BI Environment.

Scheduled Reports using Cognos Connection.

Deployed (Exported/Imported) report specifications from Development server to Production Server.

Migrated reports from ReportNet 1.1 to COGNOS 8.3.

Framework Manager

Imported metadata from various sources such as Relational Databases, ReportNet models, Impromptu Catalogs into the Framework Manager

Used Framework Manager in modeling the metadata to provide a business view for report authors and query users.

Building models, packages using Framework Manager and published the packages to Cognos connection.

Added business rules, such as filters and calculations that define the information that users can retrieve

Created Query Subjects to optimize and customize the data and organized the metadata into a Business View using folders, namespaces and shortcuts.

ReportStudio

Creation of Standard, Complex Reports like List Reports, Cross tab Reports, Section Reports, and Drill Through Reports

Created drill up/drill down reports in order to analyze data in multidimensional way.

Created multi fact multi grain reports.

Developed Pass through Reports with conditional formatting.

Environment: ReportNet 1.1/1.0x, Cognos 8.3, Cognos Connection, Report Studio, Query Studio, Frame Work Manager, XML, Oracle 9i, MS- Access, Windows NT/XP, UNIX Solaris 5.0

Bridge Medical, Solana Beach, CAApril 2006- March 2007

Cognos Consultant

Description:

Bridge Medical, a wholly owned subsidiary of AmerisourceBergen, is a leading provider of point-of-care patient safety solutions and has been honored for its educational initiatives and patient safety solutions. The management of Bridge Medical needs reporting along with calculations for their sales and marketing to analyze their product in different dimensions.

Responsibilities:

Worked closely with clients to understand, gather and document business requirements

Developed technical specifications and deployed efficient Business Intelligence solutions

Conducted User Interviews and documented their query, business analysis and reporting needs. Understood data and business logic with reporting viewpoint.

Responsible for creating the Catalogs, Joins and Folders for the users and managing & testing of Catalogs.

Responsible for the design, development and implementation of Cubes and Reports for MIS Reporting using OLAP Tools - Cognos Impromptu and PowerPlay in Oracle Environment.

Worked extensively on Cognos Impromptu and PowerPlay with the implementation of Impromptu Reports and PowerPlay Cubes.

Migrated the Contents from Series 7 to Cognos 8.2. Created proper documentations for all the issues and bugs raised after the migration.

Designed FM models for the new reporting requirements after the migration.

Implemented security within the model.

Created various reports (List, Cross tab, Drill reports, Charts) using Report Studio.

Performance tuning of the reports.

Formatting data to analyze in drill mode and slice & dice mode. Develop reports based on user requirements from Business Support users - both for standard reporting and ad hoc requests using Analysis Studio.

Created Standard and Ad-hoc Query Studio Reports.

Creation of a multiple layer report providing a comprehensive and detail report with drill through facility.

Converted legacy reports and developed Web based Reporting application using Cognos Reporting toolset.

Environment: Cognos Series 7, Cognos 8.2, Oracle 9I, SQL Server, Windows Server 2003, Windows XP.

Client : Johnson & Johnson, Malvern, PA March 2005- February 2006 Designation: Programmer Analyst

Description:

JNJ manufactures various numbers of pharmaceutical and consumer products. It has various warehouses from where the products are distributed based on the orders received from customers. The Database has lots of historical data that has been transformed and loaded from various OLTP servers/databases. So data warehouse plays a major role in enabling marketing departments to view the data at a lowest level and help them to make decisions to bring more revenue to company with new policies. Involved in the life cycle development process. Developed Power Cubes to analyze data using Cognos PowerPlay/Transformer. These cubes are used to analyze the sales, demands, business etc in various dimensions.

Responsibilities:

Developed catalogs for the users and managed catalogs with Cognos Impromptu.

Developed reports for sales of the different products for different regions and demands for future forecasting.

Developed Models based on the dimensions, levels and measures required for the analysis.

Developed reports based on Location, Product, Time and Customer.

Developed drill through and layers in reports to customize the presentation of data.

Created Folders to store conditions, calculations, catalog prompts. Tables are joined manually to construct the relations.

Used Cognos Transformer to build multidimensional cubes and used it in Cognos PowerPlay to build Analysis reports, graphs and charts of sales data.

Cognos query used to develop sets of ad hoc queries and published in portal for the users to create ad hoc reports. Launched the reports to IWR.

Involved in development and maintenance of Cognos Upfront portal

Involved in performing Administrative tasks like user authentication, creating new users for the cube.

Pivoting, Drill Down, slice and dice and filtering operations done for all OLAP applications

Involved in creating IWR to publish reports on a web.

Performance tuning- tuned Power Cubes to reduce calc time and partitioned cubes

Developed Multi-Dimensional Cubes using PowerPlay Transformer.

Involved in all aspects of impromptu, from connecting to the corporate database to setting up effective catalogs, joins, folders, and filters, to ensure that adequate security procedures are in place

Environment: MS SQL Server 7.0, Impromptu 5.0, PowerPlay5.0, Transformer5.0, Cognos Query, IWR, Upfront, Informatica Power Mart/Power Center 5.0 / 4.7, MS-OLAP Services, and Windows NT, SQL Server 6.0,oracle8

Contact this candidate