Summary

> Business Intelligence Analyst over ** years of IT experience

consulting with Cognos Professional Services delivering high quality

consulting services based on Cognos Enterprise Services Framework

(Install, Implement, & Integrate) in the full range of Cognos

enterprise-wide Business Intelligence tools, including ReportNet,

PowerPlay, Impromptu, Cognos Query, Impromptu Web Reports, PowerPlay

Enterprise Server, Architect, Access Manager and Upfront.

> Extensive experience in gathering and documenting user requirements.

> Experienced in installing and configuring Cognos series 6, 7, 8 & 10

suites of tools and ReportNet.

> Expertise with Cognos Metadata Migration Utilities to export the

Architect and Impromptu Metadata for use with ReportNet.

> Expertise in upgrading lower versions of Cognos to higher versions.

> Good Knowledge of Java, XML, JavaScript, HTML.

> Hands on experience creating data warehousing models and thorough

knowledge of RDBMS concepts.

> Expertise in writing complex SQL.

> Extensive knowledge with Data modeling, Star Schema/snowflakes schema,

OLTP/OLAP, E-R modeling, Fact and Dimension tables.

> Experienced in the use of Agile methodologies including Sprint Cycles,

Test-Driven Development and Scrum.

> Cognos Certified Developer, Modeler & Administrator.

> Qlikview 11 Personal Edition.

> Sun Certified Java Programmer.

> Good Knowledge of ReportNet SDK.

> Good team player.

Technical Skills:

Platforms & OS's : Sun Solaris, HP-UX, Linux, Win NT, Win95,

Win2000/2003/Advanced server, WinXp

Database : Oracle 7.x/8.x/9i/10g, SQL Server7/2000/2005,

MS-Access97/2000, DB2, Siebel.

Reporting Tools : Cognos10, Cognos 8.x, Cognos Report Net 1.1

MR2/MR3, Cognos Impromptu, Cognos Power Play,

Access Manager, Architect, Configuration Manager,

Upfront, Cognos Impromptu Web Reports (IWR),

Cognos Power Play Enterprise Server, Cognos

Query, Cognos Visualizer, Cognos Office

Connection, Cognos RAVE.

Other Tools : TOAD, SQL Programmer, Erwin, HP Exstream

Dialogue.

App/Web Servers : IIS 5.0, BEA Weblogic, Web Sphere, Apache Tomcat,

Netscape

Directory : Active Directory Server, Netscape Directory

Servers Server

Languages : SQL, PL/SQL, C, C++, HTML, XML

Java & J2EE : Java, JSP, Java Script

EDUCATION

. Master of Science in Computers from Oklahoma City University, OK.

. Bachelor of Engineering in Electronics and Communication from Madras

University, India.

CERTIFICATIONS

[pic]

> IBM Certified Designer - Cognos 10 BI Reports

(Version 10; Candidate ID: SR5707702).

> IBM Certified Developer - Cognos 10 BI Metadata Models

(Version 10; Candidate ID: SR5707702).

> IBM Certified Designer - Cognos8 BI Metadata Models

(Version 8.4; Candidate ID: SR5707702).

> IBM Certified Developer - Cognos8 BI Reports

(Version 8.4; Candidate ID: SR5707702).

> Certified Cognos ReportNet Product User (Ref No: 15041).

> Certified Cognos ReportNet Product Professional Metadata Modeling

(Ref No: 15357).

> Certified Cognos ReportNet Product Professional Advanced Authoring

(Ref No: 15222).

> Certified Cognos ReportNet Administration Product Professional

(Ref No: 15287).

> Sun Certified Programmer for the Java 2 Platform 1.4.

> Brain Bench Certified TCP/IP Administrator.

> Brain Bench Certified Internet Security Specialist.

> Brain Bench Certified JavaScript Programmer.

> Brain Bench Certified HTML Programmer.

Professional Training

> Completed Qlikview11 professional training.

> Comfortable in creating Qlikview dashboards using dashboard objects

and in loading & editing scripts.

PROFESSIONAL EXPERIENCE

Client: Vanguard Group, Malvern, PA

Senior Cognos Developer / Architect (Jan '11 - Dec

'14)

Responsibilities:

> Interacted with business users to gather the requirements

> Created & Published Cognos8 & Cognos10 Framework Manager models

> Created advanced reports using Report Studio

> Involved in performance tuning of the reports

> Created event based schedules using Event Studio

> Created Cognos Power play Cubes using Power play Transformer

> Created presentation ready PowerPoint reports using Go Office

> Created dynamic Excel workbooks using Go Office

> Created multi page dashboards with global filter variable

functionality

> Created dashboards using Cognos 10. 1 Business Insight & Cognos

10.2 Workspace.

> Created customized charts using Cognos RAVE.

> Created Cognos Active reports for Vanguard CRA's.

> Created dashboards using Tableau BI tool.

> Created POC connecting Cloudera Hadoop with Cognos 10.1 and

Tableau 7 & 8.

> Involved in day to day Cognos administration activities.

Environment:

Cognos8.4, Cognos 10.1, Cognos 10.2, Tableau 7, Tableau 8, Go Office,

Transformer, DB2, MS Access, Oracle 11g, SQL Server 2008, Oracle Exadata,

IDAA (IBM DB2 Analytics Accelerator)

Client: QVC, West Chester, PA

Senior Cognos 8 BI & Cognos Now Consultant (May '10 -

Dec'10)

Responsibilities:

> Interacted with business users to gather the requirements.

> Installed & Configured Cognos Now & Cognos 8 environments.

> Integrated Cognos8 & Cognos Now environments

> Created Scorecards using Cognos Now Dashboard

> Created Agents, Data Streams, Views & Alerts in Cognos Now Workbench

> Created customized score cards to monitor and analyze business metrics

and KPI's

> Developed dashboards to track measurable goals as per strategic plan

> Created & Published Cognos8 Framework Manager models

> Created advanced reports in Cognos 8 using Report Studio.

> Created Cognos Power play Cubes using Powerplay Transformer.

> Deployed Packages from Development environment to Production

environment.

> Configured Cognos Now & Cognos8 environments with Microsoft Active

Directory Server

> Created Data sources in Cognos connection.

> Created roles and groups and applied folder & package level security

in Cognos Connection.

Environment:

Cognos8.4, Cognos Now, Linux, Oracle 11g, Teradata.

Client: ACE Insurance, Philadelphia, PA

Senior Cognos Developer (Sep '09 -

Apr'10)

Responsibilities:

> Interacted with Business users to identify key dimensions and measures

for business performance.

> Build models and packages using Framework Manager for the Enterprise

Risk Management Group.

> Designed flexible, professional Dashboard, feature-rich and drill

through reports using report studio.

> Created multi-dimensional cubes using package as the data source.

> Extensively Developed New Reports in Cognos8 BI using Report Studio,

Analysis Studio and Query Studio.

> Created power point templates & Actuarial Excel spread sheets using Go

Office.

> Created Dashboards using Go Dashboard.

> Participated in the detailed requirement analysis for the design of

data marts.

> Performed various data analysis at the source level and determined the

key attributes for designing of Fact and Dimension tables using star

schema for successful creation of Data Warehouse and Data Marts.

> Worked with ETL & Database developers in Database Design and

Development.

> Created Event studio agent to run the jobs based on an event.

> Assisted in installation and configuration of Cognos 8, Go Office & Go

Dashboard.

> Created User Groups, Roles to implement the Cognos Security using

Active Directory.

> Involved in Cognos Administration activities.

> Closely worked with data warehouse designers to refine data and

metadata.

> Conducted end user training on Report Studio and Query Studio.

> Documented Report specifications.

Environment:

Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Analysis

Studio, Event Studio, Cognos connection), PowerPlay Transformer, Go

Office, Go Dashboard, SQL Server 2005, Informatica, JavaScript,Teradata

Client: Vanguard Group, Malvern, PA

Cognos Developer / Administrator (July '06 -

Sep'09)

Responsibilities:

> Work with Business Units to define Business 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.

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

> Worked in Building metadata model and publishing packages in Framework

Manager to the Cognos connection.

> Responsible for the delivery of solution-oriented complex reports

using Cognos Report Studio.

> Created Drill-Through, Master-Detail and Burst reports.

> Provided solutions and implemented efficient ways to improve the

performance of the reports.

> Used cognos migration tools to migrate impromptu catalogs to XML which

eventually used as a data source in cognos8 framework manager.

> Created Event Studio agents to run the scheduled jobs based on the

events.

> Incorporated JavaScript for prompt page validations.

> Defined dimensions, levels, categories and measures.

> Developed the Cognos Impromptu query (.iqd) files that will feed

Cognos cubes.

> Involved in the design, development and implementation of PowerPlay

Cubes.

> Created power point presentations using cognos office connection.

> Created roles and groups and applied folder & package level security

in cognos connection.

> Closely worked with Data Warehouse designers.

> Working with the Data Warehouse Architect to perform source system

analysis and identification of key data issues via analysis of the

data profiling results and queries

> Integrated Cognos with HP dialogue automation software exstream

dialogue.

> Created print ready documents using exstream dialogue which uses

cognos report XML output as input.

> Conducted end-user training.

Environment:

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

Event Studio, Cognos connection), PowerPlay Transformer, Cognos Office

Connection, Oracle9i,Oracle 10g, DB2, Siebel, JavaScript, Windows 2003

Server, HP Exstream Dialogue.

Client: Harcourt, San Antonio, TX

(Mar'05 - June '06) Cognos Developer

Responsibilities:

> Interacted with business users for requirement gathering.

> Created packages according to the company specifications using

Framework Manager.

> Published Framework Manager Packages to the Cognos Connection.

> Set up the reporting infrastructure to effectively group reports to

use Query or Report Studio as per functionality, user and security

requirements.

> Created Ad-hoc reports using Query Studio.

> Created complex reports using Report Studio.

> Created corporate templates using Report Studio.

> Expertise with union joins master-detail reports, drill-through,

prompts, complex calculations, formatting, conditional formatting,

bursting reports, crosstab, multi-query reports & charts.

> Created PL/SQL stored procedures and used them as stored procedure

query subjects in framework manager.

> Involved in the upgrade process from ReportNet to cognos8.

> Defined dimensions, levels, categories and measures.

> Developed the Cognos Impromptu query definition (.iqd) files that will

feed Cognos cubes.

> Involved in the design, development and implementation of PowerPlay

Cubes.

> Used extensive conditional formats for highlighting the

critical data.

> Conducted end-user training.

Environment:

Windows2003, Cognos ReportNet, Cognos8 (Report Studio, Analysis Studio,

Query Studio, Metric Studio), Power Play Transformer, Active Directory

Server, Oracle 9i, TOAD,

SQL Server, Teradata

Client: Clarian Health, Indianapolis, IN (Jan'04

- Feb'05)

Cognos ReportNet Developer/ Administrator.

Responsibilities:

> Gathered user requirements.

> Set up the reporting infrastructure to effectively group reports to

use Query or Report Studio as per functionality, user and security

requirements.

> Created packages according to the company specifications using

Framework Manager.

> Created complex reports using Report Studio.

> Created Ad-hoc reports using Query Studio.

> Installed and configured IIS5.0 Web Server.

> Installed and configured ReportNet with Active Directory Server.

> Provided security at both object level and data level using Cognos

Connection.

> Worked closely with the ETL team to put forth model specifications,

design logic for mapping.

> Conducted end-user training.

Environment:

Windows2000, Cognos ReportNet, IIS5.0, Active Directory Server, SQL Server.

Client: Security Benefits Group, Topeka, KS

(Jan'01 - Dec'01)

Cognos Developer / Administrator

Responsibilities:

> Interviewing end users and Ad-Hoc report developers to determine

needs.

> Discussed business requirement and mapped Business need using Model

Capability of Cognos Transformer.

> Defined dimensions, levels, categories and measures.

> Developed the Cognos Impromptu query (.iqd) files that will feed

Cognos cubes.

> Involved in the design, development and implementation of PowerPlay

Cubes.

> Created Catalog and set User profiles to grant user permissions for

querying.

> Created Complex Impromptu Reports.

> Developed Impromptu Reports and published using Upfront.

> Implementation of Impromptu reports and PowerPlay cubes using multiple

queries.

> Scheduled Impromptu and PowerPlay reports to run on a weekly, daily

basis.

> Mentored end users in the working of Impromptu and PowerPlay.

> Transferred technical knowledge specific to Cognos tools and the

existing data model to other team members.

Environment:

Windows2000, Cognos Impromptu, Cognos Transformer, Cognos PowerPlay, Cognos

Access Manager, Impromptu Web Reports, Upfront, iplanet Enterprise

server6.0, iPlanet Directory Server, SQL Server.

Contact this candidate