Ravi Gautam

Sr. Cognos Developer

u5gq2n@r.postjobfree.com

Ph: 248-***-**** Extn: 101

SUMMARy

• Progressive seven years of IT experience in Software Design, Development, and Analysis,

Testing, Data Warehouse and Business Intelligence tools.

• Hands on experience in Cognos8 & Cognos10 (Query Studio, Report Studio (Including Active

Report, Statistics), Business Insight, Business Insight Advanced, Analysis Studio, Metric Studio (Score

carding), Framework Manager, Cognos Connection) and Cognos Series 7.x (Cognos Reportnet 1.1,

Cognos Impromptu, Cognos Power Play Transformer, Cognos Power Play, Cognos Scheduler, Cognos

Access Manager, Upfront).

• Expertise with Framework Manager Modeling (Physical Layer, Business Layer, Packages)

and Complex Report building with Report Studio.

• Hands on experience in Report building (Crosstab, List, Dashboard reports) using Report

Studio and Analysis Studio.

• Experience developing complex reports using drill-through reports, prompts, dashboards,

master-detail, burst-reports, dynamic filtering in Cognos.

• Experienced in building scorecard reports and dashboard reports using metric studio.

• Experience with Transformer models and cubes that were used in Power play analysis and

also these cubes were used in various Analysis Studio reports.

• Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources.

• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Teradata

Fastload, Multiload, BTEQ, Oracle SQL Loader, SQL Server Integration Services (SSIS),, DTS.

• Extensive experience with Cognos security (LDAP, Active Directory, Access manager, object

level security, data security).

• Extensive and solid knowledge of free hand SQL. Expert at adhoc SQL reporting, utilizing

advanced SQL functions including OLAP functions for enhanced slicing and dicing of data.

• Sound Skills in developing SQL Scripts, PL/SQL Stored Procedures, Triggers,

Functions and Packages.

• Expertise in Oracle 11g, 10g, 9i, Teradata 13/V2R6, and MS SQL Server 2000 & 2005.

• Involved in OLTP/OLAP system study, analysis and E-R modeling, developing database schemas

including Star Schema and Snowflake Schema used in relational, dimensional and

multidimensional modeling.

• Extensive experience on production support and troubleshoot/test issues with existing

reports and cubes.

• Ability to translate business requirements into technical specifications and interact with

end users to gather requirements for reporting

• Good understanding of business process in Financial, Insurance and Telecom areas.

• Good work ethics, detail oriented, fast learner, team oriented, flexible and adaptable to all kinds

of stressful environments. Possess excellent communication and interpersonal skills.

KEY SKills & Knowledge

BI Tools: Cognos10.1, Cognos 8.x Suite, Report Net 1.1/1.0x, Cognos- Impromptu7x,Impromptu Web

Reports (IWR), Power Play, Power Play Transformer 7x/6x, Cognos Administration, Upfront, Power Play

Enterprise Server, SPSS 17.0, Scheduler, SQL*Plus.

Databases: ORACLE 9i/10g/11G, Teradata 13/V2R6, MS-Access7.0/2000, SQL Server 2000/2005 DB2,

Data Modeling: Erwin, Microsoft Visio.

ETL Tools: SQL Server Integration Services (SSIS), Informatica, Teradata Fastload/Multiload/BTEQ

Operating Systems :UNIX, LINUX, MS-DOS Windows XP/NT/2000/2003

Web: HTML, XML, Flash, and JAVASCRIPT

Web Servers: IIS, Netscape Enterprise Server, IE.

PROFESSIONAL EXPERIENCE

Dept of Oklahoma State Capital Taxation August

2010- Till Date

Oklahoma City OK Sr. Cognos

Consultant

Responsibilities:

• Gathering functional requirements from business customers, analyzing and

transforming them into business intelligence reporting specifications.

• Developed Technical Design Documents.

• Designed DMR models in Framework Manager

• Created and published packages for different functional areas and assigned security

rules to them in Framework Manager.

• Worked on multiple databases, and multiple data sources in Framework Manager to generate

reports.

• Created list, crosstab and drill through reports for departments like claims, billing,

members/subscribers in Report Studio

• Extensively used prompts, filters, cascading prompts, calculations, conditional

variables, multiple queries for data extraction in reports.

• Created Burst Reports and Multilingual Reports based on groups of users & Preferences

for our Asian, African and European partners

• Created Drill Through Reports & Master Detail Reports for Accounts Department.

• Used Union, Intersection,Exception for creating queries.

• Created dashboards, portlets for various HR and payroll related reports. E.g.

investments related to 401K plan were displayed as dashboards showing their investments,

returns, losses, dividends earned, etc.

• Developed various HR reports – MTD, QTD, YTD, last fiscal year, current fiscal year

reports, employee taxable, paid time offs, holidays, sick leaves, workers compensation

report (WCR) etc. These reports were mainly on employee level but I also developed

scorecard and dashboard reports which were mainly developed for the departmental heads

and regional heads.

• Created complex reports that had multiple pages, multiple UI items like lists, charts,

graphs, etc.

• Created complex reports in Cognos mainly dealing with Member Data, Claims data and

Provider Data.

• Created score cards using Metric Studio.

• Created My Folders Options for users using external application and displayed

report output data in external applications using SDK.

• Developed, monitored and deployed Oracle stored procedures and functions.

• Wrote Procedures and triggers in Oracle for file handling, data validation, Inserting data

etc.

• Wrote and executed the test cases for various reports that were developed in Cognos.

• Involved with making changes in the reports generated as business requirements

changed and carry out validation and verification of the reports.

• Created models in Transformer, built cubes and published cubes to Analysis Studio

• Involved performance tuning of reports including database tuning and model tuning,

• Interacted with ETL team to gather the requirements for the reporting.

• Involved with the Solutions Architect and the QA team for validation and verification of

the development.

• Exceptionally good and experienced in handling the problem and troubleshooting.

• Trained End users to operate the reports.

Environment: Cognos 10.1, Cognos 8.4, Transformer, Report Studio, Query Studio, Metric

Studio, SSIS, Oracle 10g, Erwin 4.0, TOAD,, Stored Procedures

AT&T Jan 2009- Jul

2010

Atlanta, GA Cognos Reports

Developer

AT&T is the largest provider of fixed telephony in the United States. It has a huge network and

provides services globally. In order to provide critical information like daily revenue, total sales,

goals, information on employees and new plans, AT&T has developed Business Intelligence

System based on Cognos suite of products. AT&T specializes in Telecommunications billing

solutions. Project involved participation in the development of decision making support

solutions, giving mainstream users the ability to access, analyze and share information in the

company's database. We developed reports for billing, payroll, sales, orders, and marketing

and gross profit analyses. Data warehouse is housed on Teradata RDBMS, with immense use of

Teradata Fastload, Multiload, and BTEQ utilities for ETL purposes.

Responsibilities:

• Developed professional reports in Report Studio and ad hoc reports in Query Studio.

Created list reports, cross tab reports, chart reports and reports with features

like conditional formatting, multiple drill through and have extensively used the new

features in Cognos 8.4

• Interacted with business users to identify key Dimensions and Measures for custom

development of Supply Chain Warehouse.

• Involved in the Setup security both at package level and at query subject level

• Study the existing CRN environment and draft the design document for the reporting

needs.

• Analyzing the available Data Sources and mapping the architecture need of Models.

• Create packages to suit the business needs and to improve the performance of the

reports by defining filters, adding calculations and performing SQL tuning on the model and

report level using Oracle database.

• Used TOAD to run SQL queries and validate the data in Data warehouse and Data

Marts.

• Created standard calculations, Filters, and Prompts for Ad-hoc queries.

• Developed Crosstab reports, List Reports, Charts, Drill-Through Reports, Master-Detail R

eports and Multilingual using Report Studio in Cognos 8.3.

• Built Executive Dashboards in Report Studio.

• Used conditional formatting and conditional blocks to display different sets of data

based on different conditions in Report Studio.

• Helped tune SQL queries on Teradata RDBMS.

• Wrote and modified Teradata Fastload, Multiload, and BTEQ scripts for loading data into

Teradata tables.

• Used BTEQ scripts to implement business rules to the source data.

• Created multi page report based on multiple queries using Prompts and Parameters.

• Designed prompted reports using Tabular SQL and Tabular Set and Child Tabular Models

in Report Studio.

• Extensive use of tables to control the flow of Objects such as the Charts and Crosstabs

on the Report page and the Prompts on the Prompt page.

• Scheduled and distributed reports using Schedule Management in Cognos Connection.

• Developed effective SQL queries and performed Unit Testing to ensure the accuracy of

data displayed in the report.

• Delivered data in multiple formats based on user requirements (HTML, PDF, and CSV) as

well as delivered data extract files to be fed as data source files for other applications.

• Also created documentation for all the processes involved like applying security for

reports, deployment, portal customization etc.

• Provided technical assistance by responding to inquiries regarding errors, problems, or

questions with programs/interfaces.

Environment: Cognos 8.4,8.3 - Framework Manager, Cognos Connection, Report Studio,

Query Studio, Analysis Studio, Transformer 8.3, Power Play 7.3, Teradata V2R6, Fastload,

Multiload, BTEQ, SQL Assistant, Toad 9.1,Windows XP.

All State Insurance Mar 2007

- Dec 2008

Chicago IL Cognos

Developer

Responsibilities:

• Coordinating with Database team in setting up the required Materialized views,

Aggregated and De-Normalized tables for the Reporting and Analysis needs.

• Managed Core Project, Responsible for delivery and resource allocation etc.

• Developed DMR modeling using Cognos 8 Framework manager.

• Enhanced the model, Tested and Created replacement IQDs’ using Framework Manager.

• Created Dimension IQD’s and Fact queries in Frame work Manager.

• Created Projects, Models, and Packages using Cognos Framework Manager and

deployed packages on Cognos Connection.

• Installed and configured Cognos 8.2 BI and worked with Cognos 8 BI modeling, Report

Studio.

• Responsible for Access permission and administrating the server.

• Created highly Customized reports in Cognos 8.2 Report Studio and some of the Ad-hoc

reports in Query Studio.

• Used HTML and Java Scripts for Advanced reporting purpose.

• Created different packages which contains the information about the customer

like,cust_name,address,ph_no,plan_used,mins_used,mins_remaining,rollover minutes.

• Gathered information like attempted calls, type of call (long distance, local), length of

call, originated number, destination number, rates, time of call for creating report for billing

of a customer.

• Implemented security in reports according to employee groups and roles according to

the requirement.

• Involved in Creating Content store, installation and Configurations of the ReportNet.

• Implemented Tree prompt and MDX Commands in Cognos.

• Created SSIS package to get data from different sources consolidate and merge into

one single source.

• Experience in Deployment (Export, Import) using Cognos Connection Portal in Cognos

8.2 and ReportNet.

• Created folders, filters, prompts, and complex financial calculations in Framework

Manager and Report Studio.

• Published the multidimensional cubes to framework manager and scheduled power

cubes monthly basis in Windows.

• Developed Portlets and dashboards reports according to the user requirements.

• Tuned cube builds Impromptu Reports and ReportNet reports and servers for better

performance.

• Implemented Data Security using LDAP in Framework Manager 8.2.

Environment: Cognos Report Net,Framework Manager, Report Studio, Query Studio, Analysis

Studio, Transformer, PowerPlay Enterprise Server, Cognos Impromptu, LDAP, SQL Server

Integration Services, Access Manager, IIS, SQL Server 2005, Oracle 9i, TOAD.

Verizon Wireless Dec

2005-Feb 2007

Atlanta GA Cognos

Consultant

Responsibilities:

• Worked on Cognos8.1 Framework Manager to import metadata from multiple data

sources and to create subject oriented business models, create and publish packages to

Cognos8 server.

• Creating relationships between query subjects to better represent the logical structure

of the business and the user requirements.

• Implemented Security with LDAP and Group level security in Cognos Connection Portal.

• Creation of procedures, views, tables and functions according to business requirements

in Oracle.

• Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.

• Authored Reports using Report Studio and trained end users in building Ad-hoc reports

using Query Studio.

• Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.

• Creating list reports, cross-tab reports and chart reports using multiple queries in a

single report, drill- through reports and conditional formatting to highlight the business

needs.

• Extensively worked in Scheduling and Deploying (Staging to Production) Reports.

• Worked on complex reports using Tabular Objects, Static Prompt conditions.

• Involved in designing and building the PowerPlay cubes using Transformer.

• Built Power Play Reports based on these cubes and published to ReportNet Server.

• Administering the business users in the portal based on the requirements.

Environment: Cognos 8.1, Cognos ReportNet1.1 MR3 (Framework Manager, Cognos

Connection, Query Studio, Report Studio), Oracle 9i, Toad, Tivoli LDAP, Migration Utilities

(Impcat2xml, Migratetoc8, Deploytoc8), Windows XP.

Visa Inc Feb 2005 -Nov 2005

San Francisco, CA Cognos Developer

Visa Inc. operates the world's largest retail electronic payments network and is one of the most

recognized global financial services brands. Visa facilitates global commerce through the

transfer of value and information among financial institutions, merchants, consumers,

businesses and government entities. Worked at Visa as cognos developer on the project TAQC

Project (Transaction Award Qualification and Calculation) in that I have Developed Customer

Awards Qualification report which specifies which Customer is eligible for getting an Offer from

VISA.

I have Developed Product type reports where it specifies which customer is having which type

of VISA card (VISA Platinum, Gold, Rewards etc). Also part of my work was to support the entire

existing Interface and fix any defects for all the reports.

Responsibilities:

• Involved in gathering and analyzing Business requirements.

• Created templates for standard reports using. Impromptu.

• Created list reports, sub-reports and cross-tab reports using Impromptu Administrator.

• Created hierarchies to provide drill-down options for end-users.

• Created various calculations and prompts in reports and created drill through reports.

• Created cubes and explored the multi dimensional Cube data into powerful Impromptu

reports.

• Formatted the reports, created cascading prompts, summary and detailed filters.

• Drill-through is done from Cubes to Reports and Reports to Reports.

• Created reports to monitor Sales Forecast, inventories on-hand, and periodical

performance.

• Used multiple Data sources, Data marts, and design extraction, transformation

Developed list reports, cross tab reports, chart reports, reports with multiple prompts,

cascading prompts and Filters.

• Created complex reports such as dashboard reports, master detail reports, drill through

reports.

• Applied model filters, query filters, user access filters, detail filters and summary

filters to generate user specific reports.

• Involved in applying conditional formatting in reports.

• Involved in bursting reports to several users.

• Documented Design documents based on the requirements document and also

documented Unit test case results.

• Worked closely with Business Users in order to rectify any defects within the Developed

code/Migrated code to Higher environments in order to avoid any Production failures or any

mismatch of the data.

• Worked closely with the Release Managements teams in order to avoid any failures or

code mismatches in Production migrations.

• Worked closely with Database Administration teams in order to develop many complex

SQL queries and avoid any time consuming Queries.

• Involved in all the Phases of deployment of code from Development until Production.

• Developed separate Complex reports for the 3rd Party sources which were used for the

Audit purpose.

• Trained users on navigation and creating simple reports in Report Net.

Environment: Impromptu 7.3, Power play 7.3, Power play Transformer 7.3, IWR, PPES, Upfront,

Report Net 1.1 MR2, Framework Manager, Oracle 9i, Visio, MS-Access, Windows 2000

Professional Server .

Contact this candidate