Manager Data

VINAY

***********@*****.*** 214-***-****

SUMMARY

* ***** ** ** ********** with expertise in Analysis, Design, Testing, Development, and

•

Implementation of various Software applications and generation of reports using Various

Databases.

6 Years of experience in Cognos OLTP/OLAP/Data Warehouse reporting tools Impromptu

•

Administrator, Access manager, Impromptu Web Reports (IWR), PowerPlay Web Reports

(PPES), Upfront, Scheduler, Visualizer, Cognos8 BI series (Report Studio, Analysis

Studio, Event Studio, Query Studio) and Cognos Reportnet1.1, Cognos Power Play

Enterprise Server 7.x, Power Play Transformer 7.x.

Expert and expertise on Cognos 8 Framework Manager to creating Models for reporting –

•

Creating Business Layers, Hierarchies, macros, folders and Cognos Connection.

Created MultiPage tabbed Portlet Dashboard Reports in Cognos 8.3.

•

Sound Knowledge on Reporting by using Report Studio Tabular Objects, Tabular SQL,

•

Customized Prompts, Conditional Formatting and Complex Layouts – Cross tabs and sub

reporting, bursting, multi-prompt reports with drill-thru capabilities.

Modified Power Cubes by adding new Dimensions, Levels and Measures Designed,

•

developed and implemented Cubes for various analysis/reporting purposes.

Having good Experience implementing Cognos Security at report level.

•

Solid understanding of data warehousing, OLTP and OLAP concepts.

•

Experienced in Data Mining, Multidimensional Data Analysis using Power Cubes.

•

Data modeling experience using Dimensional Data modeling, Star Schema modeling,

•

Snowflake modeling, FACT and Dimensions tables, Physical and logical data modeling using

ERWIN 4.0

Working knowledge of designing multidimensional architecture for Extract, Transform, and

•

Load environment with Informatica, Data Stage and Cognos tools.

Extensive experience in creation of ETL mappings and transformations using Informatica

•

Power Mart / Power Center to move data from multiple sources into target area.

Worked extensively with complex mappings using expressions, Routers, Lookups, ERP

•

source qualifiers, aggregators.

Expertise in Business process modeling, Data analysis and Business Requirement gathering.

•

Technical Skills

Operating System: Windows 95/98/2000/XP/2003, MS DOS and UNIX

Software/Tools: Cognos 8.3 suite (Framework Manager, Cognos Connection, Query

Studio, Report Studio, Analysis Studio, Metric Studio), Cognos Report

Net 1.1 MR3, Cognos EPSeries7i (Cognos Impromptu, Power

Play Transformer, Cognos Visualizer, Access Manager, Impromptu Web

reports(IWR))

Business Objects XI/6.x/5.x (Supervisor, Designer, BusinessObjects,

Info view, Web Intelligence)

Erwin 3.5/3.5.2/4.0

Crystal reports 9.0/8.0/8.5/5.0

Languages: C, C++, SQL, SQL*Loader, PL/SQL, HTML, DHTML, XML

Web Technologies: Cognos Enterprise Server, IIS 4.0

RDBMS: MS Access, MS SQL Server6.5/7/2000, Oracle 7.x/8.x/8i/9i/10g

ETL Informatica Power Center 7.1/7.2/6.2/5.1/4.7, Power Mart

6.2/5.1/4.7, Data Stage

EDUCATION:

Bachelor of Technology in Electronics and Communication Engineering

PROFESSIONAL EXPERIENCE

Verizon, Irving, TX Apr’08 - Present

Cognos Developer

Description: Verizon operates the most reliable wireless network in the U.S., an extensive

global Internet backbone network and an advanced broadband network. The project involved

using the Cognos 8.2 BI suite to integrated solutions for planning, budgeting, forecasting,

modeling and sales reporting.

Responsibilities:

Involved in gathering Business Requirements and prepared requirement specification

•

document.

Built Framework Manager Model and established the cardinalities to suit the business

•

needs, implemented security and created Packages and published packages to Cognos

server.

Created Ad-hoc reports using Query Studio and complex reports using Report Studio.

•

Developed multiple page reports with page-breaks based on the first page of the report

•

using Master-detail relationship.

Created Multipage Portlet Reports Which contains Dashboards.

•

Created Dashboards Reports in Report Studio using Dimensional Model developed in

•

Framework Manager.

Involved in Installation of Cognos Server, Frame Work Manager, Report Studio, Query

•

Studio and Cognos Connection.

Deployed the packages and reports from development to test environment and test to

•

production environment.

Scheduled various reports using Schedule Management used in Cognos Connection.

•

Setup security using Access Manager Administration.

•

Involved creating and maintenance of views, indexes using TOAD as per report

•

requirements.

Fine-tuned SQL queries and reports for performance.

•

Worked with Cognos tech support team to resolve various issues.

•

Provided Training and End User Support and also knowledge transfer.

•

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query, Schedule Manager,

Access Manager), Transformer 7.4, Toad for SQL Server 3.1, MS SQL Server 2005, LDAP,

Microsoft Excel, IIS 6.0 and Windows 2003 Server.

First Citizens Bank, Herndon, Virginia. Jan’07 – Mar' 08

Cognos consultant

Description: This application is built to allow customers online with the best competitive

pricing. The information pertaining to the modules are stored on RDBMS at the Server Side

(Store). The Server processes the customers’ requests and the information is shipped to the

address submitted by them. The application consists of two main modules; "Personal" and

Business". The "Personal" module was the basic interface to query the database and generate

reports for rates, payment terms, view funding, protection options and investment

considerations. The "Business" module consists of various business units for Personal, Business

and Estate Insurance.

Responsibilities:

Developed Framework Manager Models with Physical layer and Presentation Layer to

•

cater the various businesses needs (Folders, Filters, and Macros) and created Packages

and published to Cognos Connection.

Developed Complex Report Studio Reports using Bursting, Tabular Objects, Drill

•

Through Reports and Customized Reports with Prompt pages according to the

requirement of business user and added Conditions and Filters.

Prepared User documentation to train users and functionality of each report.

•

Production Support which involves solving user problems.

•

Produce Queries and Reports in Multiple Languages, Format, Present and Distribute

•

Reports utilizing Different Layouts, Multiple Report Objects and Multiple Logical

Pages.

Create Run, Schedule Reports and Jobs using Cognos Connection and securing Cognos

•

Connection and setup ReportNet security by assigning users to the groups and roles

defined in Cognos Namespace.

Develop new reports on timely bases, by extracting new data from database by running

•

the DTS packages and rebuilding the OLAP cubes

Generate financial reports from Operating Statement Cube and Balance sheet Cube

•

Generated Cubes using Cognos PowerPlay Transformer

•

Published Impromptu and PowerPlay reports to Upfront

•

Build a dashboard report in PowerPlay which indicates the Key Performance Indicators

•

(KPI)

Extensively worked with tools like TOAD and SQL developer

•

Worked with ETL team in designing the data model using Star Schema.

•

Environment: Cognos ReportNet 1.02 (Frame work manager, Cognos Connection, Report

Studio, Query Studio),Cognos EP series 7 (Impromptu Administrator, Impromptu Web

Reports (IWR), Cognos PowerPlay, Cognos PowerPlay Transformer, Cognos PowerPlay

Enterprise Server, Cognos Upfront),SQL Server, DB2, MS-Access, MS-Excel, Windows

Selective Insurance, New Jersey Sep’05 - Dec’06

Cognos ReportNet Designer

Description: Selective Insurance is one of the leading Insurance Company’s in Eastern America.

Its main offerings are Commercial line of business. Selective insurance is A+ rated by A.M.Best

from the consecutive 48 years. Selective is the 51st largest property and casualty (P&C)

company in the U.S., Selective is a customer-focused, regional company providing a broad

range of insurance and alternative risk management products and services.

Responsibilities:

Extensive interaction with Business Users and gather information and requirements.

•

Enhanced the existing reports and created new reports as per the user requirements.

•

Handled optimization of queries for better response from impromptu.

•

Created Models by using Impromptu Query Definition (IQD) in Power Play Transformer.

•

Worked extensively on Oracle database. Troubleshoot for SQL issues/performance issues.

•

Created Framework Manger models, Packages (Subject Specific) in Framework Manger

•

and published them on Cognos connection.

Created List, Crosstab and Chart reports in Query Studio and Report Studio.

•

Participated in the development of catalogs, multiple queries with complicated reports

•

and query definition files using various join and filter conditions in Impromptu.

Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through.

•

Worked extensively with Power Play Enterprise Server and the Upfront in publishing the

•

cube.

Automating tasks with Cognos Scheduler using Macros, Cognos Script Editor and Cognos

•

Script Dialog Editor.

Optimized Catalog by using Database Interaction, Client/Server balancing, Database

•

functions, Table Weighting and Qualification, Governors Settings.

Performed data manipulations using various Informatica Transformations like Joiner,

•

Expression, Lookup, Aggregate, Filter, Update Strategy, Sequence Generator etc. and

Created sessions, workflow for designed mappings.

Redesigned some of the existing mappings in the system to meet new functionality.

•

Extensively worked in the performance tuning of the programs, ETL processes.

•

Used Workflow Manager for Creating, Validating, Testing and running the sequential and

•

concurrent Batches and Sessions and scheduling them to run at specified time with

required frequency and to monitor the performance of Jobs.

Environment: ReportNet (Framework Manager, Report Studio, Query Studio), COGNOS EP

Series 7 (Impromptu Administrator, Impromptu Web Reports, PowerPlay, Transformer,

PowerPlay Enterprise Server, Access Manager) ORACLE, Informatica (Designer/Server

Manager/ Repository Manager)

Baylor Health Care System, Irving, TX Mar’ 03 – Aug’ 05

Cognos Developer

Description: Scope of the project was to provide a BI solution to the existing data warehouse.

Building models from the existing data warehouse for summary level and detail level reporting

of their patients and hospital staff data. Lastly provide training to the staff for running weekly

reports on the query data.

Responsibilities:

Gathered and documented the user requirements for reporting.

•

Developed and applied business logic to set up reporting infrastructure.

•

PowerPlay Development.

•

Created Impromptu Query definitions by filtering and formatting the source data to

•

feed as Data source in creating PowerPlay models and eventually power cubes.

Developed PowerPlay Transformer models for creating power cubes. Created

•

dimension maps for Transformer established all dimension hierarchies, designed

special categories, calculated measures and special time categories.

Developed reports by combining the multi-dimensional analysis with advanced report

•

building skills.

Deployed Cubes and Reports on the web.

•

Secured cubes at Upfront and PPES.

•

Designed and developed catalogs with low maintenance dependencies.

•

Developed complex reports to satisfy user requirements.

•

Applied security at data level by setting filters and user profiles.

•

Deployed reports over the web.

•

Designed and developed security infrastructure using Access Manager.

•

Installed and configured Cognos PowerPlay Enterprise Server, Impromptu Web Reports.

•

Administered the PPES and web server for optimal resource utilization and high

•

performance.

Conducted user training to effectively utilize the reporting infrastructure for day-to-

•

day decision-making.

Designed and developed a process for sustenance and effective change control.

•

Environment: Cognos Impromptu, Cognos Transformer, Cognos PowerPlay, Cognos Access

Manager, Architect, Impromptu Web Reports, Framework Manager, Upfront, Oracle 8i,

Windows NT.

IQ Logics, India Oct’02 to Feb’03

Programmer

This is a FoxPro project and it has been moved to Oracle. The data is collected from text files

containing records and transferred to Oracle tables with PL/SQL procedures.

Responsibilities:

Developing and Customizing PL/SQL Packages, Procedures, Functions and DB Triggers.

•

Involved coding for Oracle, Oracle Forms, Oracle Reports

•

Interacting with users to discuss business functionality, business enhancement, and

•

requirement analysis and system development.

Analysis, Testing and supporting the system.

•

Developing and Customizing Forms, Reports, PL/SQL Programs.

•

Tuning SQL Statements and PL/SQL Packages, Triggers, Functions and Procedures.

•

Importing invoice information into Oracle Receivables using SQL*Loader as an

•

interface, Generating credit memo, debit memo, past due invoice Reports.

Developed database objects like Tables, Synonyms, Views, Indexes, and Sequences.

•

Involved in business development life cycle, Oracle Forms, Oracle Reports and

•

Oracle PL/SQL Programs, and Shell Scripting.

Environment: Oracle 7.x, FoxPro 2.5, UNIX, Forms 4.5, Reports 2.5

Hospital Management, India Apr’ 02 to Sep’ 02

QA Analyst

This product is mainly developed for the usage of total Hospital system on computers. It has

features like maintaining records of in-out patients, maintaining records of Diagnostic center,

Information about duty and visiting doctors, information about employees and also billing

information of different departments like in-out patients, medical store, diagnostic center,

stores, etc.

Responsibilities:

Responsible for writing test plan and test cases.

•

Performed System Testing, Integration Testing, and Regression Testing.

•

Performed Functionality testing and user acceptance testing.

•

Responsibilities include developing test scripts using Win Runner.

•

Performed cross-browsing testing to verify that the application displays correctly in a

•

variety of environments.

Responsible for weekly status updates showing the progress of the automation testing

•

efforts and open issues to be resolved.

Interaction with Development team in bug reporting process, emergency bug fix

•

requests

Environment: Oracle 7.x, Win Runner

Contact this candidate