Professional Summary

Cognos Developer with over 7+ years of total IT industry experience analysis, design, testing, development, training, and Documentation skills

• Experience in Cognos 8 BI Framework Manager, Report Studio, Query Studio, Analysis Studio,Power Play Transformer, Oracle 8i/9i /10g/11g (SQL ,PL/SQL).
• Highly experienced in Full Lifecycle Systems Development in COGNOS platform.
• Strong user and administrative knowledge of the Cognos environment in tools such as Cognos 8.x, 7.x and Report Net 1.1
• Built Framework Manager Packages publish the packages as well as built IQD files. Modifying the Dimensional (DMR) models in Frame work Manger. Built Reports using all of the Cognos 8 Business Intelligence tools like Query Studio, Report Studio and Analysis Studio.
• Involved in cubes creation for multi dimensional analysis using Power Play Transformer.
• Experience in migration projects from Cognos Report net to Cognos 8 reports.
• Strong understanding of business processes with good experience in development of various types of reports like list, crosstab, chart, repeater in Cognos 8 and impromptu.
• Hands on experience in Report writing with expertise in COGNOS tools including Report Net MR1, MR2, Impromptu, Impromptu Web Reports (IWR), Power Play, Transformer, Upfront, Power Play Enterprise Server (PPES), Access Manager.
• Experience in setting up Security prototype for Cognos Business Intelligence environment in corporating Object level, data level, package level, and report level security.
• Generated complex List reports ,Crosstab reports ,Chat reports in Report studio
• Designed and optimized COGNOS catalog(s) to tune the performance of reports.
• Administration of Access Manager to implement Security among Cognos applications
• Installation and Configuration of various Cognos Products
• Extensive experience on Cognos8 and Report net with respect to Deployment, Content Administration, Users and User Class Creation, and Scheduling of Reports
• Thoroughly documented the steps, provided production support and provided knowledge transfer to end-users for Cognos 8, Report Net, Power Play and Impromptu Administration
• Experience in OLTP/OLAP System Study, Analysis and ER Modeling, Maintaining Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling
• Experience in interacting with end users to gather requirements for reporting
• Extensive knowledge on Data warehousing concepts and Dimensional Modeling
• Extensive Knowledge of BI support Process.
• Flexible and versatile to adapt to new environment with a strong desire to keep pace with latest technologies.
• Having team management capabilities, problem solving abilities and good verbal and written communication skills. I have always taken initiative in meeting project deadlines without compromising on the quality of the deliverables

Technical Skills:

Operating Systems: Windows 98/NT/2000/XP/Vista ,Windows 7, Unix, DOS
Languages: C, C++, VC++, SQL, PL/SQL
Databases: Oracle 8i/9i/10g/11g,Teradata,DB2,Sybase,MS Access 7.0
MS SQL Server2000/2005/2007
Software Packages: MS Office (Word, Power Point, Excel, Access)
Case Tools: Toad, SQL Developer, SQL Plus
Web Related: HTML, Java Script.
Database Connectivity Interfaces: ODBC, JDBC
DW-BI tools: COGNOS 8.X: (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Transformers ,Event Studio)
COGNOS REPORTNET MR1,MR2 1.1/1.02: (Query Studio, Report Studio, Framework Manager)
COGNOS 7.x(Impromptu Administrator, Impromptu Web Reports(IWR), Power Play Transformer, Power Play Enterprise Server(PPES), Power Play Web, Server Administration, Report Administration, Access Manager, Upfront).

Education:

Bachelor's of Technology

Professional Experience:

Client : Confidential, Houston, TX
Duration : Jan'09 - Current Date

Confidential, is a worldwide leader in providing major mechanical components for land and offshore drilling it is leading company in oilfield products and services IndustryThey are a worldwide leader in the design, manufacture and sale of equipment and components used in oil and gas drilling and production operations They provide number of services for theoil industrysuch as well andpipelineinspections and is one of the market leaders insupply chain management through their distribution network. The project deals with sales and services of Nov. The sales and services of Nov has involved in various across the globe The purpose of the project was to analyze and understand the Business requirement and provide efficient and reliable reporting system for decision making process. The project is implemented with the aim of analyzing and estimating the sales trends

Responsibilities:

• Interacted with business analyst to gather business requirements and designed functional and technical requirements documentation.
• Developed models in Framework Manager and deployed packages to the Cognos Connection
• Customized data by adding filters at both the Framework Level and Report Level
• Published different packages from Framework Manager to Cognos Connection
• Analyzed Relationships between tables in the schema and applied cardinality in the database layer
• Implemented all business logic in Framework Manager by creating prompts, folders, calculated columns, joins and naming convention
• Worked on creating and analyzing the complex reports like Cross tab, drill-thru reports.
• Page explorer, query explorer and variable explorer were used to manage the content of the reports.
• Created multiple page reports with page-break based on the first page of report using master-detail relationship.
• Bursting the reports in various formats, such as html, PDF, excel and sending via e-mail based on the sales area and different levels of administration
• Created Dashboards comprising of list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, calculations, complex expressions, and conditional formatting.
• Assisted in creating executive dashboard for management level reports using Report Studio.
• Worked on complex filter condition, query join logic, conditional formatting, various type of prompts like value prompt, search & select prompt, Text Box prompt and Date & Time prompt
• Applied different functionalities like filters, prompts for Cognos reports to retrieve relevant data
• Enhanced the performance of the reports by changing the properties of the Query such as Auto Group & Summarize, Processing, Execution Method and Use Parameter Info
• Used layout component reference in page header, page footer and prompt page for uniformity across the reports.
• Changed the appearance of the reports in Query Studio by reordering the report items, swapping rows and columns and by limiting the number of rows that should appear on a page
• Created Ad-hoc Reports using Query Studio
• Used Cognos Connection to administer and scheduling reports to run at various intervals
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Worked with user profiles to ensure security by restricting user access to data based on the individual user.
• Creating the tables, table spaces, data objects, setting privileges, indexes, user login's, passwords (security).
• Set security for individual reports in Cognos Connection.

Environment: Cognos 8.3/8.4 Framework Manager, Report Studio, Query Studio, Analysis Studio, Transformers, Cognos Connection , SQL Server 2000/2005, HTML, MS-Access, MS- Excel, Windows XP

Client: Confidential, Iowa City, Iowa
Duration: Apr'08 - Jan'09
Confidential, is aLondon-based education andconglomerate. Pearson also makes educational software and It is the largest bookpublisherin theUK, It mainly concentrates on educational publishing, software assessment and training. This project was developed for Sales, Marketing, and Support user groups to analyze data for their requirements and involved in generating and developing reports.

Responsibilities:

• Involved in setting up the Cognos 8 BI environment. Installed and configured all the 8BI Components, Framework Manager, Analysis Studio, Event Studio, Query Studioand Report Studio.
• Development of model in both dimensional and relational in FM
• Created Database Layer, Reporting Layer, Presentation Layer as per user requirement
• Built Prompt Macro at the FM level for Country (Whenever data is pulled from country query subject it should prompt for the country).
• Used parameter maps for implementing multilingual property based on the country.
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.
• Implemented Conditional formatting, Bursting and scheduling of the reports
• Created HTML\\Java Script in Report studio reports for the tab view of individual Reports and to highlight prompt selection based on the values in the file/sheet
• Created drill through reports and associated with the summary reports to get details.
• Usedconditional formatting, complex calculations, graphs, prompts and multiple drill downs
• Created drill through reportsandassociated with the summary reports to get details
• Built shortcuts and provided the business names to the query items
• Created various IQD in Framework Manager and from this IQD's as source, integrated to Power Play Transformer to create various models and build cubes.
• Creating the model and publishing the Cubes to Cognos Connection to be used for multidimensional analysis.
• Involved in performance tuning of the application using governor settings in framework manager and transformer models
• Used Transformer with a variety of sources and combined them into Multi-DimensionalCube
• Created and customized the data in data sources in Transformers using Packages generated at Framework level
• Developed the Multidimensional Cubes with various Dimensions, Levels and Measures including Time Dimension with different hierarchy which enabled Drill Up and Drill Down capabilities.
• Refreshing cubes on demand and for core business processes
• Scheduling cubes and reports as requested by the business users.
• Implementing Security in Power Play Transformer
• Development and Testing of Reports.
• Preparation of Unit Test Cases, Test Scripts & UAT Unit Test Plan document for Cognos Reports.
• Preparation of System Integration Test Cases & Test Plan document for Cognos Reports.

Environment: Cognos 8/8.1/8.2 Framework Manager, Report Studio , Query Studio, Analysis Studio, Transformers, Oracle, SQL, PL/SQL, Windows 2003,Toad.

Client: Confidential, Sunnyvale, CA
Duration: Jan'07 - Mar'08
Confidential, Provides internet services worldwide the company is well known for its web portal, search engine and social networking .Yahoo provides services mainly in five division integrate consumer experience, Search ,Media products & services , Application ,Mobile This Project is for Providing Solution for daily transactional data for different business sectors. The objective is to generate reports based on the Business requirements

Responsibilities:

• Worked on Cognos Framework Manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.
• Mentored and trained team on Framework Manager, Report Studio and Query Studio tools.
• Involved in setting up Groups/Roles to secure the models and packages.
• Deployed packages, folders and contentstore from a development environment to test environments
• Making enhancements of the report based upon the requirements of the user.
• Created Dashboards to present critical company data in a single report
• Migrated Power Play reports to Cognos 8 BI Report Studio
• Modifying Business view with calculations filters to reflect business rules
• Writing complex Cognos8 Report Studio reports, as well as the unit and system integration testing of those reports.
• Maintaining Cognos Report Studio server in development environment and migrating reports from development to test environment.
• Used Cognos Connection to administer and schedule reports to run at various intervals of time
• Designing the Dimensional (DMR) models using Framework Manger
• Created Regular Dimension as per requirements and arranged them as per the Hierarchy defined by business users.
• Modifying the Dimensional (DMR) models in Frame work Manger
• Published (DMR) Model for Multi Dimensional Analysis of reports and enabled drill up and drill down features.
• Created various reports using (DMR) package in Analysis Studio, Report Studio
• Performed Drill through definitions on Multiple reports
• Implementing data level security according to various user classes.
• Set security for individual reports in Cognos Connection.
• Worked with user profiles to ensure security by restricting user access to data based on the individual user.

.
Environment: Cognos 8.3/Report Net 1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio , Analysis Studio,Teradata , XML, Oracle, SQL Scheduler and Windows NT/2000.

Client: Confidential, Minnetonka, MN
Duration : FEB'06 - DEC'06
Confidential, group mainly deals with health insurance and offers broad Spectrum of products and services through seven operating business united health care, Ovations, Ameri choices, Uniprise, Optum health, Ingenix and Prescription Solutions This project is a part of company's Internal Data warehousing. This project was developed to Support user groups to analyze data for their requirements for Sales and Marketing. These departments can get different reports on previous sales and on present sales and get benefited by focusing on particular Product Families, Sales Regions and Lead Generation Process

Responsibilities:

• Developing Models and Packages on Cognos Framework Manager Created Analytical Reports using Cognos Report Studio.
• Creating advanced reports in Report net using Cognos Connection.
• Preparing reports like list report, Cross tab Reports, chart reports created in Report Net.
• Creating filters, prompts, calculations in reports of Report Net.
• Creating folders, conditions, calculations, prompts in catalogs of Impromptu Administrator.
• Developed reports in Report Studio include Complex list reports, cross tab reports with Report pick lists
• Developed Prompt pages, used Conditional Variables for Conditional Formatting
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used subsets to write union/subtract queries in Report Studio
• Involved in formulation of joins strategy, query optimization and weighing the tables
• Making enhancements and modifying the existing report based upon the change request by the user.
• Developed reports using Drill through functionality
• Analyzed XML's from Impromptu report to develop the same query in Report Studio
• Created Impromptu Web Reports and published them on the web server and later on Upfront.
• Applied Zero Suppression, Layering functionalities present in .PPX in Cognos 8 Reports
• Maintaining Cognos Report Studio server in development environment and migrating reports from development to test environment.
• Migrated several existing Cognos Impromptu Catalogs into xml files and imported thexml files as data sources into Cognos Report Net Secured Cognos Connection and setup Report Net security by assigning to the users.
• Migrating Cognos Series 7 Impromptu reports to Cognos 8 BI Report Studio.
• Scheduled Impromptu and Power Play reports to run on a monthly, weekly, and daily basis using Cognos Scheduler

Environment: CognosReport Net 1.1 Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Impromptu 7.3, Power Play 7.3, Power Play Transformer 7.3 and Oracle 8i, DB2 and Unix

Client: Confidential, Irving, TX
Duration: JAN'05-FEB'06
Confidential, is one of the largest financial services, offering a full range of banking and financial services to consumer and commercial customers. The purpose of the project was to analyze and understand the Business requirement and provide efficient and reliable reporting system for decision making process for the finance department .The project deals with sales and services of Responsibilities:

• Installed and Configured Cognos series 7 (IWR, Upfront, PPES and Access Manager)
• Generating various List Reports, Grouped Reports, Cross tab Reports, Chart Reports.
• Created Drill-Thru, Sub-reports and Chart reports using Impromptu Administrator.
• Created various reports using drill through, cascaded prompts, conditional formatting and master detail relationship.
• Published Impromptu Reports and Power Play Cubes to Upfront using Cognos IWR Administration and Power Play Enterprise Server respectively.
• Created special categories and secured Power Play Models using Power Play Transformer.
• Tuned the IWR reports using Impromptuand Power Play cubes using Transformer.
• Created catalogs using CognosImpromptu 7 to generate reports.
• Worked with Access Manager Administrator to provide security for Cognos applications.
• Implemented security and granted privileges according to user classes using Access Manager.
• Involved in performance tuning of the application.

Environment: Cognos Report Net 1.1 MR2(Frame work Manager, Report studio), COGNOS 7.3 (Impromptu Administrator, IWR, Power Play, Transformer, Power Play Enterprise Server, Power Play Web, Server Administration, Report Administration, Access Manager, Upfront), TOAD,DB2 and Sybase, Windows XP.

Client: Confidential, Hyderabad
Duration: MAY '03 - NOV '04

Developed an application that is completely a transaction-based system that accepts all the related information from a new customer it will categorize the type of the account and accordingly the system will post the entries in the appropriate tables. All the modules are developed with built-in validations, which ensure data accuracy and security. Another important task of this system is Transaction module wherein; given the account number the system would give all related information on the screen including the Current balance. After each Transaction is completed, all related tables are updated immediately

Responsibilities:

• Involved in data gathering during the business analysis and planning phase of the project. Involved in Installation and Administration of Cognos Series 7 Tools Upgrade of Cognos products from Version 7.0 to 7.1.
• Importing meta data using Impromptu catalogs
• Improving query performance using Governors. Generated various reports including List, Grouped, Cross
• Created different types of reports like Drill through reports, Sub reports, and List reports.
• Created Impromptu catalog in order to generate reports.
• Created standard filters, calculations, prompts and conditions in catalog.
• .Designed models by mapping business needs using Power Play Transformer and created multi dimensional cubes, cube groups, power play reports
• Decreased the cube build times drastically and increased runtime performance
• Designed report sets with user class mapping and published to different news boxes in Upfront in IWR server.
• Maintained Impromptu, IWR, Cognos Power Play and PPES

Environment: Cognos Impromptu 7.1, Impromptu Web Reports 7.1(IWR), Cognos Power Play 7.1, Cognos Power Play Transformer 7.1, Cognos Power Play Enterprise Server 7.1,Cognos Upfront 7.1, Access Manager 7.1, Configuration Manager 7.1, SQL Server, Erwin, Ms-Excel, UNIX, Windows NT