Manager Data
Resume:
Raghu
Sr.Cognos Consultant
*****.******@*****.***
PROFESSIONAL PROFILE:
Around 8+years of experience in Business Intelligence and DWH/Database Applications on
multiple domains. Strong abilities and Hands on experience in analysis, design, testing,
development and implementation of client/server and web applications.
• Having 8+ years experience on Cognos Tools – Cognos 8.2/8.3/8.4 Suite (Report Studio,
Analysis Studio, Query Studio, Metric Studio and Cognos Connection), Cognos Reportnet 1.1
Mr3, Cognos EP Series 7.3(Impromptu, IWR, Power Play Transformer and Power Play
Windows/Web, upfront)
• Extensively worked on Cognos 8 Framework Manager – Creating Models in Framework
Manager – Importing Meta Data from Different Sources, Dimension Hierarchy, Determinants,
Star Schema Grouping, and Packages.
• Sound Skills in Report Development, Modeling (Relational, DMR) in Cognos 8.
• Experienced in Full Life Cycle and Methodology for implementing Data warehouse and
Business Intelligence Reporting Systems
• Data warehouse and data mart design and data warehouse bus architecture.
• Developed logical models providing Business Relations implementing to star schema and
Snowflake schema concepts.
• Hands on Experience with Framework Manager Modelling (Physical Layer, Business
Layer, Packages) and Complex Report building with Report Studio.
• Expertise in creating Dash Board Reports using Report Studio and Analysis Studio.
• Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
• Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL
Processes, Data mining and Data audits features for data warehouses
• Expertise in developing Database Schemas like Star Schema and Snowflake Schema used
in relational, dimensional and multidimensional modelling.
• Strong Experience in Installation & Configuring the Cognos 8.3 BI Environment.
• Involved in Migrating reports from Cognos Series 7 to Cognos 8 series.
• Sound Skills in SQL Scripts using Oracle, SQL Server 2005 and DB2.
• Involved in Performance Tuning, Developed Stored Procedures, Functions and
Packages.
• Extensive experience in Multiple Relational Databases including SQL SERVER, ORACLE,
TERADATA and DB2.
• Experience with Oracle P/L SQL Stored Procedures, Functions, Cursors and Triggers .
Proficient at developing and implementing training programs to enhance the efficiency,
competency and motivation levels of the employees in line with organizational objectives. A keen
communicator, acquired problem solving & analytical abilities.
TECHNICAL EXPERTISE:
Reporting Tools : Cognos 8.2/8.3/8.4 Suite (Framework manager, Report Studio, Query
Studio, Analysis Studio, Cognos Connection, Event Studio), Cognos EP
Series 7.3, Business Objects 5.1, Cognos Impromptu 7.3, Power Play 7.3,
IWR, Upfront, OBIEE 10.1, SAS Enterprise Guide 4.2.
Databases : Oracle 8i/9i, 10g, MS SQL Server 2000/7.0, DB2 UDB, Teradata V2R6
Data Modeling : Erwin, Microsoft Visio, SSIS.
ETL Tools : Informatica.
Oracle Tools : SQL*Plus, Toad, SQL*Loader, PL/SQL Developer, WinSql.
Languages : SQL, PL/SQL Programming, Visual Basic.
Operating Systems : Windows98/2000/NT/XP, Unix/Linux, Sun-Solaris
Servers : Application Servers (WAS, Tomcat), Web Servers
(IIS, IHS)
CERTIFICATIONS:
Cognos 8 BI Professional
Professional Experience:
RCI, NJ
July 10 – Oct 10
Cognos Consultant
Responsibilities:
• Developed a logical model that conforms to star schema concepts, different views (import,
business, external) as per Business requirement.
• Creating star schema grouping for better understanding of the model & facilitate multi-fact
(cross-fact) reporting.
• Setting up cardinality (minimum, maximum & optional), Determinants to avoid double
counting, support loop joins, optimize data source, and identify dimensions and facts.
• Ensuring clear query paths by resolving ambiguous relationships (loops, reflexive and
recursive).
• Responsible for creating User groups and roles to manage security in Cognos Connection and
Access Rights of the Reports for the end users
• Implemented different types of hierarchies (balanced, unbalanced, ragged).
• Adding business rules by defining different kinds of calculations and filter.
• Creating prompts with query macros by including references to parameter maps.
• Developing the reports using various templates like list report, Cross-tab Report and Chart
Report.
• Extensively worked with Cognos 8 Report studio, Analysis studio.
• Performance tuning by analyzing and comparing the turn around times between SQL and
Cognos.
• Pre-sort, clean, consolidate Data for faster process in transformer
• Developing the SQL scripts to create the Reporting tables in DB2 as per the requirements.
• Preparing the Entity Definition Sheet for Reporting tables.
• Developing the shell scripts to load the data in Backend Reporting tables.
• Import and export statements are used in writing the SQL scripts.
• Based on proto type refining the model by creating dimension map (dimensions, drill down
path, alternate drill downs) and measures.
• Fixed reports which are not resulting correctly as in 7.4.
• Resolved the Performance issues of the Reports.
• Deployment of reports from Development to Production.
• Moved Packages and reports from development to QA and then Production servers.
• Worked extensively with DB and BI-SAS team.
• Designed dashboards in OBIEE.
• Prepared OBIEE standards and naming conventions document.
Environment: Cognos 8.4 (Cognos Connection, Framework Manger, Report Studio, Query Studio),
Cognos Series 7, Cognos Access Manger, Oracle 10g, Windows 2000/2005 Server, DB Visualizer,
OBIEE 10.1(Administration, Answers, BI Publisher, Catalog manager) Enterprise SAS Enterprise
Guide 4.2 .
Arizona Public Services,AZ
Nov 08 – June 10
Sr.Cognos Developer
Responsibilities:
• Analyzed Business requirements from the analysts.
•Involved in entire Project life cycle from installing Cognos 8.2 in the distributive environment
and development of the reports.
• Designed the ETL jobs using Informatica to Extract, Transform and load the data into
Staging and then into Oracle Database.
• Devised techniques for Performance tuning of the programs, ETL Procedures and
Processes
• Ensuring clear query paths by resolving ambiguous relationships (loops, reflexive and
recursive).
• Formed detailed Unit testing and System Integration Testing, managed and preserved
testing documentation.
• Designed Meta Data Model’s - Packages in Framework Manager.
• Implemented Framework manager security for Data access, Object level access and
Package access.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Designed Multi-dimensional models (Star, Snow Flake schema) depending on the degree of
redundancy in the logical schema.
• Design and Development of Dashboards, EPO –PCI, SAI Report sets.
• Administer Security in Reports based on the user role (Executive, TeamLead and
Manager).
• Java Script for complex validation, navigation, communication and format customization.
• Performance Tuning and load balancing of complex reports.
• Export and Import of Packages / Reports for Auto / Manual Deployment to UNIX Box (Dev,
QA and PROD).
• Creation of Transformer Cubes from IQD’s /Cognos Connection Package.
• Customizing user class security views in Cube by user classes / Roles.
• Batch script automation for Power Cube refresh.
• Resolving the Performance issues of the Reports.
• Deployment of reports from Development to Production.
• Experience with conditional blocks and conditional layouts.
• Experienced with migration of Cognos code (reports/models/ frameworks) from one
environment to another.
• Sound Skills on Developing Score Card Applications using Metric Manger and Metric
Studio
• Trained business users on Query Studio for ad hoc reporting.
• Reporting Powerplay cubes in Analysis Studio and Conditional formatting of Cube Reports in
Report Studio 8.2.
Environment: Cognos 8.2 Suite (Cognos Connection, Framework Manger, Report Studio, Query
Studio, Analysis Studio, Metric Manager, Metric Studio), Cognos Series 7 (Transformer), DB2, Oracle
9i, SQL Server 2000, Cognos Access Manger, Windows 2003 Server.
Morgan Stanley,NYC Jan 07 – Oct 08
Sr.Cognos Consultant
Responsibilities:
• Carried out marketing researches to collect requirements around the Deustche Bank product
designs.
• Worked more as a Functional Analyst than as a developer by capturing, consolidating and
communicating the information from the Subject Matter Experts to the team.
• Leading, facilitating and approving projects changes - assessing and approving business
justification while weighing and mitigating any risk
• Designed models using Framework Manager and deployed packages to the Report Net
Servers
• Implemented Framework manager security for Data access, Object level access and
Package access.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager.
Model.
• Involved in migration of Catalogs, reports from Cognos Series 7/CRN to Cognos 8 using
Migration Utilities.
• Created database layer and business layer, defining appropriate relationship between
query subjects in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which
involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against
database.
• Created custom templates and custom tool boxes for the use of reporting.
• Extensively worked on Analysis Studio to develop multi dimensional reporting .
• Worked with Global Drill- through Definitions to drill through from analysis studio reports
to report studio reports ( MOLAP – ROLAP)
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Created custom prompted reports in Report Studio, Bursting reports to different user
groups.
• Moved Packages and reports from development to QA and then Production servers
• Developed Power Play Reports based on the cubes and published to Report Net Server.
• Deployed the cube from Testing Environment to Production Environment using Batch script.
• Testing reports using review checklists for Quality Assurance before delivering to the
end users.
• Writing the SQL scripts using the Teradata.
• Involved into move to Deployment to UAT and Production.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Involved in writing Stored Procedures and functions in Oracle PLSQL.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc
reports.
Environment: Cognos 8 BI,Framework Manager 8.1, Oracle 9i, DB2 0,Report Studio
1.1/8.2,Transformer 7.1/8.2, Analysis Studio 1.1/8.2, Cognos XML, Generic/Cognos JavaScript,
BATCH SCRIPT.
Deustche Bank,NYC Aug 05 – Dec 06
Sr.Cognos Developer
Responsibilities:
• Involved in designing data model and report design.
• Understanding functional specification and preparing technical spec.
• Created reportnet models, queries according to standards
• Created and publishing packages to Cognos connection.
• Created the user roles in cognos connection.
• Built Power Play Reports in Report Studio by replicating the powerplay functionality in Report
Studio using dynamic Measure selection, Dynamic Sorting, ranking.
• Created Dashboard Reports by translating data into visually rich presentations using different
types of charts, and other graphical elements to show multiple results together.
• Customize the Cognos connection portal using existing portlets and customized tabs.
• Worked on complex reports using Static Prompt and mdx functions and union conditions.
• Used Cognos Office Connection to publish the reports in Powerpoint and format them for
business presentation.
• Created the Dashboard reports using Report Studio.
• Authoring reports in report studio according to requirement by implementing many features
like prompts, conditional formatting.
• Scheduling the monthly reports with saved prompts using Job Wizard.
• Designed transformer model (dimension map, facts (regular/calculated)).
• Created batch files (macros) to refresh the cube monthly.
• Deployed the cube from Testing Environment to Production Environment using Batch script.
Environment: Cognos 8.0 BI, Report Net 1.1, Framework Manager 1.1, Cognos Report Studio 1.1
DB2.0, Report Studio 1.1/8.0,Transformer 7.2/8.0, Cognos XML, Generic/Cognos JavaScript, BATCH
SCRIPT
Choice Solutions, India Jan 04 – Jun 05
Cognos Consultant
Responsibilities:
• Customer’s first point of contact for BI Cognos related support/issues
• Monitoring scheduled daily/weekly power play cube builds
• Published the customer authored, requested Powerplay reports to upfront
• Published the Impromptu reports to upfront Newsbox by creating new reportset or updating
the existed reportset
• Granting and revoking IWR report access to user classes from IWR-Report Administration
and Upfront
• Monitoring weekly scheduled IWR reports in upfront and IWR-Server Administration
• Filtering cubes and building new cubes (Time Based partitioned) during year end.
• Installing and configuring Cognos applications (Impromptu, Powerplay) on Citrix servers
and desktops remotely.
• Grant and revoke access to Powerplay and IWR reports in upfront.
• Monitoring Cognos (PPES, Upfront and Reportserver) services.
• Access manager administrator (adding users, user signon, user membership, user’s
datasource access).
• Developed and Published Packages in Framework Manager - Connecting and testing the
data source, created database layer, physical layer and presentation layer, defining
appropriate relationship between query subjects.
• Implemented security for Data access, Object level access and Package access.
• Designed and developed multi dimensional cubes.
• Customized data by adding calculations, summaries and functions.
• Created List Reports, Cross Tab Reports and Drill Through reports.
• Generated reports using Cognos Impromptu tools querying database.
• Created Filters, Conditions and Prompts in Catalog.
• Created User Groups, Roles to implement the Cognos Security, using Directory Server.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Burs.
• Resolving reports (Impromptu, Powerplay and Reportnet) data discrepancy issues.
Environment: Cognos Powerplay 7.3, Transformer 7.3 Cognos Report Net 1.1,Powerplay Enterprise
Server 7.3, Upfront 7.3, Impromptu Administrator 7.3, Access Manager 7.3, TOAD.
Adea,India Aug 02 – Dec 03
Software Engineer
Responsibilities:
• Created standard filters, prompts, calculations, and conditions in Catalog
• Defining join conditions, table aliases and views for the user requirement
• Created Joins, folders, reusable filters, pre-calculations, prompts .
• Updated Impromptu Catalog by adding tables and creating new joins
• Developed drill through reports, developed filters,conditional formats and prompts
using Prompt manager
• Created standard filters, calculations, prompts and conditions in the Catalog
• Created IQDs are used as datasources in power play Transformer to generate Transformer
models.
• Created various Impromptu reports (List, Cross-Tab and Drill through) and Powerplay
Reports.
• Published Impromptu reports and Powerplay reports to Upfront.
• Scheduling Impromptu web reports in upfront.
• Used SQL* LOADER to load data into table space.
• Connected to Remote Data Bases using Data Links and pulled required data.
• Designed and developed front-end application using CGI/C ++ programming. Insert, update
and deletion were done using these forms.
• Handled Complex queries with TRANSLATE & DECODE.
• Granting access to different users for the system
• Modifying the profiles of different users
• Development and report generation.
• Involved in writing different stored procedures, triggers in PL/SQL as per functionality
• Installing applications like Impromptu user 7.2 & Powerplay user 7.2.
Environment: Cognos Powerplay 7.2, Transformer 7.2, Powerplay Enterprise Server 7.2, Upfront 7.2,
Impromptu Administrator 7.2, Access Manager 7.2, TOAD, Oracle 7x, PL/SQL, SQL*PLUS,
SQL*LOADER, SQL Scripts, Developer 2000, Windows.
Contact this candidate