Manager Data
Resume:
KRISHNA G. H.
Email : ********@*****.***
Mobile : 551-***-****
Summary
. 8+ Years of professional IT experience
. Seven years in Data Warehousing, generating OLAP reports using Cognos
Enterprise Suite 8.x/7.x/6.x and ReportNet 1.1/1.01.
. Expertise in Business Analysis, Data Modeling, DW Concepts, Data Analysis
& BI Reporting.
. Proficiency with Dimensional Modeling & DW Design
. Involvement in activities like Business Requirement gathering to
Design and Development of Data Warehouses and end user reporting.
Hands on experience in leading BI tools.
. Proficient in Data Analysis, Gap Analysis, Workflow Charts.
. Expertise in defining and developing Dashboards.
. Experience and expertise in understanding existing business processes,
data analysis requirements, business systems analysis and design,
converting requirements specifications into functional specifications.
. Participate and benchmark all phases of SDLC and streamline IT
Processes to improve deployment.
Well-versed in developing reporting applications using Cognos 8.4 suite
components like Framework Manager, Report Studio, Query Studio, Cognos
Connection.
Sound knowledge of Cognos 8.4 (Query Studio, Analysis Studio, Event Studio,
Report Studio, Go-Office).
Experience in creating packages for analysis through DMR modeling
Experience in creating packages for adhoc querying.
Experience in training the end users.
Experience in designing, developing and maintaining Cognos Impromptu and
PowerPlay reports.
Sound Knowledge as a Solution Designer in designing and building end user
reports using Cognos Suite, design a model to generate power cubes using
Cognos Transformer and Cognos Power play.
Expert in customizing the Cognos connection portal.
Experience in migrating the Reports with the utilities.
Working Knowledge on Informatica, Ascential DataStage, Cognos Planning,
Cognos Visualizer, SqlServer Integration Services(SSIS).
Knowledge on MicroStrategy.
Good understanding of Data Mart Architecture, data modeling and dimension
modeling using Star Schema and Snow-Flake Schema.
Expertise in installation and configuration of Cognos BI suite.
Experienced with Multiple Relational Databases including Oracle, MS SQL
Server, DB2.
Extensive experience in supporting Enterprise Data warehouses and Data
marts.
Knowledge on tools MS Project, Erwin & MS Visio Professional.
Production Support Experience.
Administering users/groups/roles & deploying Packages, Reports across
environments.
Involved in identification of facts, measures, dimensions and hierarchies
for OLAP models.
. Excellent Inter-personal skills and a quick learner. Ability to get
along with the team and proven leadership qualities.
Domain knowledge and experience in the areas of Finance, Energy, Banking.
Technical Skills:
OLAP Tools Cognos 8 Series, Cognos Report Net 1.1
MR3(Cognos Configuration, Framework
manager, Query Studio, Report Studio,
Metric Studio, Event Studio), Cognos 7x
& 6x ( Impromptu, Powerplay Transformer,
Upfront, Powerplay Enterprise Server,
Access Manager), Microstrategy 8.
ETL Tools Informatica 6.1, Ascential DataStage
7.1.
Other Tools Modeling(Erwin 4.0), Toad
Languages C, C++, VB 6.0,Java, SQL, PL/SQL
Databases Oracle 8i/9i/10G, MS-Access, SQL Server
7.0/ 2000/2005, DB2.
Web/App Servers IIS 6.0, IHS 1.3.28, Apache Tomcat, WAS
6.0
Operating Systems Windows 9x/NT/2000/XP
Professional Experience
International Finance Corporation[WORLD BANK Group], Washington DC
Lead / Sr. Cognos Developer Oct '07 -
Till Date
IFC provides loans, equity, structured finance and risk management
products, and advisory services to build the private sector in developing
countries and helps companies and financial institutions in emerging
markets to create jobs, generate tax revenues, improve corporate governance
and environmental performance, and contribute to their local communities.
Project #1 - Migration [ Oct'07 to Aug'08 ]
- Migration of the reports created in series 7 to cognos 8.2.
- As a team, delivered around 350 reports in this migration project.
- This includes various department reports.
Project #2 - Advisory Services Information Delivery [ Aug'08 to
tilldate ]
- Advisory services is one of the arm for IFC, besides Investment
Operations.
- Delivered a reporting solution for this major area in two phases.
Overall Responsibilities @IFC :
. Conducting interview with business groups, identify their business needs
and prospects.
. Analyzing on the business requirements, identify the bottlenecks and
iterate them with business groups.
. Documenting the business requirements.
. Translate the business requirements into system specifications and
develop the reports as per the client requirements.
. Interfaced with project sponsors, service provider partners, service
managers, and other key stakeholders to define scope of work, resolve
issues and drive decision-making.
. Develop application prototypes. Design and develop Test Plan, Test cases,
Perform & certify the Quality and working on improving the Report
Performance.
. Responsible to work with/lead the Offshore team of Cognos Developers &
Testing team for migration project & co-ordinating to resolve the
issues/tickets.
. Analyzing Oracle Queries to resolve the performance issues in Cognos
reports. Scheduling and distributing reports through schedule management,
Data validations, Data conversion and migrations.
. Responsible for setting up the process for a smooth migration of the
project.
. Involved in creating Proof of concept for Go Office.
. Created Ad-Hoc reports using Query studio and Trained power users to use
Query Studio for Ad-Hoc reporting.
. Migration & Support of reports like MIS Reports, RM Reports, HR Reports.
. Responsible for creating User groups and roles to manage security in
Cognos Connection and Access Rights of the Reports for the end users.
. Customized Portal Tab, specific to a Department need.
. Created a Dashboard Page in Cognos Connection as a single point of access
for all the reports.
. Created data sources, Projects and Packages by using Framework Manager.
. Created Models in Framework Manager and Published Packages
. Creating and testing the Data Source connection, Created Database layer,
Physical layer and Business/Presentation layer.
. Created Dashboard in Report Studio.
. Created conditional formatting and drill-throughs for the reports.
. DMR modeling, to create a package for the management team in order to
analyze the summarized data.
. Writing SQL Queries in developing/testing the reports.
. Created Dimensions with different levels forming a hierarchy as per
business need & Time-Period dimension in DMR modeling.
. Analyzed the existing report specifications of Series 7.1 and ReportNet.
. Involved in Upgradation of ReportNet reports to Cognos8 and migration of
series 7.4 to cognos8.
. Created Adhoc reports by using Query Studio.
. Created Event Conditions and Tasks by using Event Studio.
. Involved in Applying Package Level Security, Object level security.
. Used Javascripts,basing on the requirement.
. Installation of Migration Utilities Migs7 and Migdeploy.
. Converted catalogs and reports to XML by using impcat2xml and migratetoc8
commands.
. Deploy the converted xml to cognos8 portal by using migdeploy command.
. Tested series 7.1 reports before upgradation to series 7.4 as per the
Audit.
. Involved in Upgrading reports to series 7.4 before migrating to cognos8.
. Carried out the performance testing of ReportNet reports as compared to
Cognos8 reports.
. Recreated reports in Cognos8 which had migration issues (broken drill
through links, missing variables and parameters).
. Consolidated multiple reports into single report based on the
requirements.
. Testing of all the reports and cubes against Cognos7.
. Testing of reports and cubes in 8.4 against 8.2.
. Upgraded Framework Manager Models from 8.2 to 8.4.
. Created Models by using Trasformer and published the cubes to Cognos
Connection.
. Modified the existing upgraded packages and republished to the cognos8
portal.
. Involved in setting up a process for moving the reports with drill
through links.
. Unit testing of the reports to ensure the correctness of the data
. Responsible for closing the tickets that has migration issues.
Environment
Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Go-Office,
Transfromer), Cognos 8.2, ReportNet 1.1, Cognos Series 7.4 (Impromptu,
Upfront, Impromptu Web Reports (IWR), Access Manager), SQL Developer,
Oracle 10g
Syngenta., Greensboro, NC
Cognos Admin/Support - Onsite Lead Aug'07-
Oct'07
Syngenta is one of the world's leading companies in bringing plant
potential to life. Through world-class science, global reach and commitment
to customers they help to increase crop productivity, protect the
environment and improve health and quality of life.
Responsibilities:
. 24/7 Onsite Production support for the Cognos & Point of contact for
the users.
. Cognos 7 Series Administration & Enhancements.
. Monitoring of Cubes & Reports that are scheduled for monthly & bi-
monthly.
. Co-ordination with the offshore team & Onsite support.
. Created Multi Dimensional Cubes using Power play Transformer for
multidimensional (IQD) reports.
. Created standard and Ad hoc reports using Cognos Impromptu Designed
catalogs and defined User Classes, Security and Privileges.
. Created Lists, Groups and Cross-tab reports with Drill-through
functionality.
. Created Multi-dimensional reports by implementing Multi-Dimensional
Cubes using Power Play and Transformer.
. Provided security for Cubes of various User classes. Used Date Wizard
to create time dimension in Transformer for creating cubes and Power
Play reports.
. Calculated fields, created manual dimensions and used special
categories for creating cubes and reports using Transformer models.
. Created Impromptu Web Reports and published them on the web server and
later on upfront.
. Created News boxes in Upfront and customized the environment. Set
Security for News Item and New boxes in Upfront. Set Privileges for
user classes by defining News Index Admin.
. Data retrieval, Multidimensional analysis, Power Play structure.
Reporter Operations such as Sum and Average, Intersection, Exception
Highlighting, Sorting, Ranking etc.
. Developed solution models for Adhocs.
. Involved in optimizing power Cubes.
. Report building and publishing upfront 7.0.
. Creation and maintenance of multiple shared catalogs using Impromptu.
. Studied the existing reports and enhanced them using impromptu.
. Created Users & User classes and given access privileges to various
applications using Access Manager.
. Creation of multiple dimensions, alternate drill down and special
categories in Power play Transformer.
Environment: Oracle 8i, Cognos Impromptu Admin/User, Power play
Transformer, Power play for Web/Windows, PPES,, Impromptu Web Reports,
Cognos Upfront,, Windows 2000
OpenPages Inc., Waltham, MA
BI Consulting Engineer Apr'07- Aug'07
OpenPages enables the well-governed business through a software solution
that provides a single enterprise system for managing governance, risk and
compliance procedures and policies. With capabilities to identify new
business opportunities and route out losses from business risk, OpenPages
helps organizations implement a strong business governance practice. The
results include improved top- and bottom-line performance, and a higher
valuation from investors.
Responsibilities:
. Interacting with the customers regarding the reporting requirements.
. 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.
. Deploying the reports developed on the customer environment by
arranging the Webex Sessions.
. Training the end users to effectively use the reporting tool to build
and customize their ad-hoc reports.
. Taking the customer through the entire technical process that has been
used to develop their report.
. Creating highly complicated Heat-Map reports.
. Scheduling Reports and Jobs to run periodically.
. Imported metadata from multiple data sources to build a model and
publishing packages in Framework Manager to the ReportNet server.
. Extensively worked on relationships (cardinality) between query
subjects to better represent the logical structure of the business and
the user requirements.
. 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 Model.
. Created database layer and business layer, defining appropriate
relationship between query subjects.
. Created custom templates and custom tool boxes for the use of
reporting.
. Created custom prompted reports in Report Studio, Bursting reports to
different user groups.
. Involving in writing the test plans & testing the reports.
. Validated report results with the source data and authorized the
reports to production environment.
. Prepared User documentation to train users and functionality of each
report.
Environment: Cognos Reportnet 1.1MR3 (Framework Manager, C.C, Query
Studio, Report Studio), Oracle9i, Windows NT.
Keane Inc., Boston
Sr Cognos Consultant Jan'06-Mar'07
Keane is using EPM as its Data warehouse. Enterprise Performance Management
(EPM), provided by Peoplesoft enables organizations to achieve world-class
performance by aligning the right information and resources to strategic
objectives.
Within the GlobalConnect implementation, Keane Management requires insight
into various pieces of information that is used to both manage the business
on a day-to-day basis, as well as support business decisions and strategy.
The goal is to provide various levels of management within the organization
with a single point of truth for reporting.
Responsibilities:
. Extracting Peoplesoft financial data & HR data using the ETL tool,
Ascential Datastage.
. Creating tables/views basing on the requirements in PS Application
Designer.
. Migrating Catalogs, Reports from Version 7 to C8 using the migration
utilities.
. Extensive Work Experience on Modeling using Cognos 8 Framework
Manager.
. Importing Power play Cube Data Sources and defining multi Dimensional
Hierarchy and creating packages For Cognos 8 Report Studio and Cognos
8 Analysis Studio.
. Customize the Cognos connection portal using existing portlets and
customized tabs.
. Define Global Drill- through definitions and established drill-through
from Report Studio report to analysis studio report.
. Authored Reports using Report Studio and trained end users in building
Ad-hoc reports using Query Studio.
. Creating list reports (Bursting), cross-tab reports and chart reports
using multiple queries in a single report, drill- through reports and
conditional formatting to highlight the business needs.
. Worked on complex reports using Tabular Objects, Customized/ Static
Prompt conditions.
. Extensively worked on building Transformer Models - dimension
hierarchy, drill-down paths, calculated measures, roll up's,
Performance Tuning.
. Involved in designing and building the Powerplay cubes using
Transformer.
. Administering the business users in the portal based on the
requirements.
Environment: Cognos 8,Ascetical DataStage, Cognos 7x Suite- Impromptu,
Transformer, Powerplay Enterprise Server, Cognos Planning 7.1, Cognos
Visualizer 7.3, DB2, Sqlserver2005, Peoplesoft 8.4, Windows NT, Migration
Utilities((Impcat2xml, Migratetoc8, Deploytoc8).
Entergy Solutions Ltd., Houston
Sr Cognos Developer Jun'05-Dec'05
The RDW(Retail Data Warehouse) was built to manage all kinds of assets
related information flowing into Entergy. Reports generated from RDW help
the business users to improvise on their strategies with respect to the
business application. RDW is a centralized repository for all the retail
business related data having valuable information about the Entergy
business. This information serves as an authenticated information source
for all the departments in generating various reports.
The reports for retail data warehouse are generated with the help of target
TERADATA databases. The data into teradata is loaded using INFORMATICA and
is sourced from the following:
. CCS database (customer database on SAP),
. ODS (marketing database on oracle),
. CUFS (any customer related document or correspondence with customer
related to his welcome kit, bill etc., i.e. sub part of customer
database)
. Call Center Data (flat files)
The packages are defined/built in Framework manager and are published into
Reportnet Server. The requests raised for the reports are built in Report
Studio.
Responsibilities:
. Installation and Configuration of the Cognos Reportnet 1.1 MR3
environment.
. Worked on framework manager to import metadata from multiple data
sources and to create subject oriented business models, create and
publish packages to ReportNet 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 Impromptu to Reportnet
using utilities.
. Authored Reports using Report Studio and trained end users in building
Ad-hoc reports using Query 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: Informatica, Cognos ReportNet1.1 MR3 (Framework Manager, C.C,
Query Studio, Report Studio), Teradata, Tivoli LDAP, Migration Utilities.
Selective Insurance, New Jersey
Sep 04 to Jun 05
Cognos Developer
Selective Insurance is one of the leading Insurance Company's in Eastern
America. Its main offerings are Commercial line of business. Selective
insurance is A+ rated by A.M.Best from the consecutive 48 years. Selective
is the 51st largest property and casualty (P&C) company in the U.S.,
Selective is a customer-focused, regional company providing a broad range
of insurance and alternative risk management products and services.
Responsibilities
. Cognos Reportnet 1.1 MR3 Installation and Configuration.
. Importing metadata from multiple data sources and to create subject
oriented business models, create and publish packages to ReportNet
server.
. Creating relationships between query subjects to better represent the
logical structure of the business and the user requirements.
. Creation of procedures, views, tables and functions according to
business requirements in Oracle.
. Authored Reports using Report Studio and trained end users in building
Ad-hoc reports using Query 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 ReportNet1.1 MR3 (Framework Manager, C.C,
Query Studio, Report Studio), Oracle 9i.
Saven Technologies
Hyderabad, India
Software Programmer ( Jan'02 to July'04)
Worked on: Visual Basic, Oracle, Windows NT & Cognos 6x (Impromptu,
Transformer, Powerplay)
Contact this candidate