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 .