Manager Project

Objective:

Experienced Cognos Certified Consultant seeking a challenging position in

Information Technology where I can apply my Cognos, leadership and business

skills in a company with a professional growth.

Summary:

. 3+ years of experience in developing Cognos Applications such as

Cognos 8, ReportNet (Query Studio, Report Studio, Framework Manager,

Cognos Connection), PowerPlay, Impromptu, Impromptu Web Reports (IWR),

Access Manager, Transformer, Server Administration on PowerPlay

Enterprise(PPES), Upfront and IWR servers

. Administered Access Manager to implement Security among Cognos

Applications.

. Involved in the process analysis, catalog design and performance

optimization of BI Reports

. Created multidimensional Cubes using PowerPlay Transformer as per the

Business requirements

. Created Business Intelligence Reports using Cognos Impromptu and

Cognos PowerPlay

. Published Impromptu/PowerPlay reports and PowerPlay cubes to Upfront

using PPES /IWR Servers

. Created models and packages in Framework Manager and published

packages to Cognos Connection

. Created standard and ad hoc reports using Report Studio and Query

Studio respectively

. Generated and managed reports in Zero-footprint environment using

ReportNet

. Implement Security among Cognos applications using Access manager

. Provided extensive End User Training and Support

Technical skills:

OLAP Tools: Cognos 8.4/8.3/8.2/8.0 (Framework Manager, Cognos Connection,

Query Studio, Report Studio, Analysis Studio, Event Studio,

Metric Studio, Go! Dashboard), ReportNet 1.1 (Query Studio,

Report Studio, Framework Manager, Cognos Connection) Cognos

7.3/7.1/7.0/6.0 (Impromptu, PowerPlay, Transformer, Access

Manager, Impromptu Web Reports, PowerPlay Enterprise Server,

Upfront and Scheduler)

Database systems: Teradata V2R6, Oracle 10g/9i/8i, SQL Server 2000, MS

Access and DB2

Web Servers: Microsoft Internet Information Server (IIS) 6.0/4.0/3.0

and Apache Server (1.3/2.0)

LDAP Servers: Netscape Directory Server, SunOne Directory Server, OID

Programming Skills: C, C++, PL/SQL, SQL, Assembly Language, HTML, Java

1.4.X and XML

Microsoft Tools: MS Excel, MS Word and MS PowerPoint

Operating Systems: Windows 95/98/2000/NT/XP/Me

Other Tools: Matlab 5.X, Circuitmaker 6.X, VHDL, Macromedia Flash,

Photoshop and FrontPage

Education/ Certifications:

. Bachelor of Science in Electronics Engineering, India

. Cognos Certified in ReportNet

. Cognos Certified in Impromptu

. Cognos Certified in PowerPlay

. Cognos Certified BI Author

. Cognos Certified Trainer

Awards:

. Consultant of the Year - Northwestern University

Northwestern University, Evanston, IL

Oct 2009 - Jul 2010

Sr. Cognos Developer

Northwestern University (NU) is a private research university located

primarily in Evanston, Illinois. The objective of the current project is to

work as an integral part of Project Caf , and help in the upgrade of

existing reports from Cognos 8.2 to Cognos 8.4.1. Additional

responsibilities involved optimizing each individual report for performance

enhancement.

Responsibilities:

. Installed and configured Cognos 8.4.1

. Used Framework Manager to upgrade existing reporting packages and

make the same 8.4.1 compatible

. Published upgraded packages from Framework Manager to the upgraded

content store

. Used parameter maps to implement row level security in the existing

packages

. Upgraded all existing reports to make them compatible to the latest

Cognos version

. Optimized long running reports to enhance performance and decrease

execution time

. Recreated all upgraded reports for Project Caf using reportoutput

functions and layout component reference

. Supporting the Cognos 8.4.1 environment after the same is deemed as Go-

Live

Environment: Cognos Series 8.4.1/8.2 (Report Studio, Query Studio, Analysis

Studio), Windows Server 2003, Oracle 10g, PeopleSoft FMS 9.1

The DIRECTV Group, Inc., El Segundo, CA

Mar 2009 - Oct 2009

Cognos Analyst/Cognos Administrator

Headquartered in El Segundo, DirecTV operates the largest direct broadcast

satellite (DBS) service in the US.

It provides service to more than 18 million customers in the US. The

objective of the project was to implement a Dashboard for the Finance

department and helping them analyze the impact of Dealer Channels over a

rolling customized time period across various attributes like Box type,

Base Package, Income level etc

Responsibilities:

. Extensively worked in the Performance Management Project and Order

Lifecycle Project

. Worked as a Lead Developer for Performance Management Project

. Developed Executive Dashboard for Self-service reporting using Cognos

portal and Cognos Portlet.

. Created the afore mentioned dashboard for immediate visibility into

key performance indicators (KPIs) for corrective action and rapid

decision-making

. Created Complex, multipage reports involving prompts, cascading

prompts, conditional rendering, and conditional highlighting

. Used various dimensional functions like children,lastchild,lag,tuple

to develop reports according to the user needs

. Extensively worked on the Conditional Formatting of the reports using

the Render and Conditional Variables.

. Used page sets to group and display data over multiple pages

. Used drill through, prompts, filters, and complex calculations

. Wrote complex Queries and Case statements to design Report Studio

reports.

. Used multiple page layout for creating dashboard with different

organized pages as separated tabs

. Developed reports using Conditional Layouts and condition expression

like String Variable and Boolean Variable.

. Developed Detail and Summary reports based on management hierarchy

with Drill Down and Drill Through capability

. Created the Performance management cubes through IQDs and optimized

the same

. Enhanced the cube performance by running he pc-optimizer utility

. Created real-time pivot reports with additional prompts on selecting

the output data types

. Created a Report Studio draft of the Analysis Studio based on the user

requirements

. Shared Parametrized URL with selected users to get report outputs

generated as clickable links

. Helped troubleshoot Order Lifecycle Dashboard and its related reports,

and helped in optimizing reports through SQL, Cube or report

format/design modification

. Provided User Training and Support on the functionalities of the

dashboard

. Worked as backup Administrator for DirecTV IT Operations and IT

Business Intelligence group

Environment: Cognos Series 8.3 (Report Studio, Query Studio, Analysis

Studio), Teradata V2R6, Windows Server 2003, Teradata SQL Assistant 7.2

Health Information Designs, Inc., Auburn, AL

Aug 2006 - Feb 2009

Cognos Administrator/ Cognos Analyst

Health Information Designs, Inc. (HID) is an experienced and qualified

provider of drug utilization review (DUR), automated prior authorization,

prescription drug monitoring, and pharmacy support. The objective of the

project was to implement a data-reporting and fraud detection system for

the Dept. of Medicaid, State of Mississippi.

Responsibilities:

. Installed, evaluated and configured Cognos 8.4/8.3/8.2

. Used Framework Manager to model metadata from multiple data sources to

create packages

. Created package from different linked segments to aid in data

reporting.

. Created Framework Manager Models with calculated columns, filters and

Macros from different data source and created packages to suit the

reporting needs of the client

. Published packages from Framework Manager to the content store

. Created various SQL for the test cases and also used some User-Defined

SQL's In Framework Manager.

. Created Dimensional model by creating hierarchies in Framework Manager

for use in Analysis Studio

. Defined Scope between regular and measure dimensions to determine

reporting measures' level

. Corrected existing stitched queries and unnecessary full outer joins

to properly relate data at different granular levels

. Created complex drill through and Master-Detail reports using Report

Studio and created ad-hoc queries using Query Studio

. Developed various complex and customized (Inserting tables and Blocks)

reports using prompts like value prompt, date prompt, type in,

cascading prompt, Select & Search Prompt and using conditional

formatting as required.

. Created joins and unions in Report Studio to get the desired output

according to report requirements

. Used Geo-coded/spatial data to create required XML reports and then

upload the same into Google Earth to get a dynamic representation of

the data.

. Created report views and scheduled reports using Cognos Connection

. Customized Cognos Connection Portal by editing the required XML file

. Written several SQL reports in Report Studio to help meet specific

needs of user community.

. Addressed the Performance and other Production issues with the Cognos

8 reports.

. Created reports through views for faster data access to aid in the

State Legislative sessions.

. Extensively used conditional formatting and conditional blocks to

manipulate the appearance of report objects when the report is run at

different levels of the user security level

. Created appropriate user classes, users, database signons both in

Access Manager and OID to provide different levels of authentications

and privileges

. Deployed reports and packages between different environments

. Deployed Audit Package to monitor user activity

. Created user defined custom function sets for usage in report studio

. Coordinated with Database team in setting up the required Materialized

views and Aggregate tables for the Reporting and Analytical needs

. Coordinated with the ETL team in defining the ETL logic for Reporting

table

. Extensively used Cognos log files to determine and correct errors.

. Maintained in house Report Repository and Case Management systems

. Maintained the Application servers and the Gateway for error free

operation of the reporting system

. Extensively worked in the Claims, Beneficiary, Provider, Mars

subsystem among others

. Provided End User Training and Support by organizing weekly classes

and distributing class notes

. Used PowerPoint presentations to guide the Medicaid end users about

the usage and functionality of using Cognos as a BI/Analysis/Reporting

tool

. Organized special rush classes on request of Bureau/Department heads

during Legislative sessions to meet state requirements of data

reporting

. Helped a users to create reports either by usage of pass through SQL

or by using packages

. Provided on-site and off-site support for/on behalf of the user group

Environment: Cognos Series 8.4/8.2/8.3/8.0 (Framework Manager, Report

Studio, Query Studio, Analysis Studio), Oracle 10g, Windows Server

2003,Oracle SQL Developer, Aqua Data Manager

Contact this candidate