BACKGROUND SUMMARY:

• Over 7 years of Strong design/development experience with Business Intelligence solutions, OLAP tools and Data Warehousing (DW).
• Strong user and administrative knowledge of the Cognos environment and tools IBM Cognos 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos 8BI, Report Net, Impromptu, Power Play, Impromptu Web Reports (IWR), Access Manager, Upfront and IWR servers.
• Involved in administration of Access Manager to implement Security among Cognos applications.
• Expert in the analysis, design and performance optimization of Business Intelligence/OLAP/ROLAP Reports.
• Proficient in the developing Complex reports in Cognos 8BI, Report Net, Impromptu and Power play.
• Experienced in Identifying and building business solutions using Cognos to support business needs.
• Strong experience in performing a variety of complex and technical functions including designing, testing, and installing software.
• Experience in Installation and Configuration of various Cognos Products.
• Expertise in building models and publishing packages in FrameworkManager to the 8BIserver.
• Extensive experience in SQL Server - Stored Procedures, Triggers, User-defined Functions and Views.
• Experience in delivery of solution-oriented complex reports using Report Studio andDevelopment of ad-hoc reporting interfaces using Query Studio andanalysis of reports from cube packages using Analysis Studio.
• Experience in publishing the reports to IWR server with controlled access as per the end-user requirement.
• Expertise in publishing Cubes and Powerplay reports onto the upfront server. Worked on Deployment Manager in deploying the Cognos applications to different environments. Experience in Migration of the applications from Cognos Series 7 to ReportNet and 8BI. Experience in automation of various activities in Cognos using Scheduler. Created various multi-dimensional cubes using PowerplayTransformer.
• Assisted in the Design and Creation of Datamarts using Star Schema/Snow Flake Schema.
• Provided extensive End User Training and Support.
• Excellent team player with problem-solving and trouble-shooting capabilities.

TECHNICAL SKILLS:

BI Tools

IBM Cognos 8BI(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Designer, Metric Studio), Report Net .0/1.1 MR2, COGNOS Series 7.X Impromptu Administrator, Impromptu, Impromptu Web Reports, COGNOS PowerPlay Transformer, PowerPlay User, PowerPlay Web Reports, PowerPlay Enterprise server, Upfront, Access Manager, DAP Server, Configuration Manager, Visualizer, Metrics Manager

Databases

Oracle 11i,10g/9i/8i/7.x,SQL Server 7.0/2000/2005/2008,Sybase,MS Access

GUI

Developer 2000, Crystal Reports, Business Objects, Erwin

ETL Tools

Informatica PowerCenter/PowerMart 7.0, Cognos Decision stream, Data stage 7.0 Oracle warehouse Builder 9.1.X,

Web/App Servers

IIS, Apache,WebSphere

Programming Languages

SQL, PL/SQL, C, C++, Java, J-Script and HTML

Microsoft Tools

MS excel, MS word, MS Visio, MS Project and MS PowerPoint Studio.

Database Tools

Toad, SQL Server Management Studio, SQL*Plus, SQL*Loader, SQL Server Profiler

Operating System

Windows, Windows NT4.x/9X/2000/XP and CISCO (IOS), UNIX, Linux,AIX

CERTIFICATION:

Cognos Certification Program

IBM Cognos Certified Designer --ID: SR5700682

PROFESSIONAL EXPERIENCE:

Confidential

San Jose, CA

Cognos Sr. Admin/Developer

Oct 08 to Till Date

Force10 Networks is a pioneer in building and securing reliable, high performance networks. It has pioneered advances in high density Gigabit Ethernet and 10 Gigabit Ethernet switching, routing and security. It has developed Reliable Networking, which delivers the high availability, network control and scalability required to ensure network infrastructure flexibility and application readiness. This Project was developed internally for Finance and Budgeting. This helps the users to analyze the Past and Current data.

RESPONSIBILITIES:

• As a Administrator andDeveloper involved in the complete cycle of Project Plan, Design, Installation, Development, and Testing, Production Cutover,End User Training and Post Production Maintenance of the system.
• Upgraded IBM Cognos 8.3 Environment to IBMCognos8.4 and Deploying and testing all the Reports.
• Followed Step by Step approach of Upgrade Process for all the Dev, Test and Production Environments.
• Setting up of the backups of all environments with backup and restoring of Content Store Databases, backups of Cognos Configurations, Deployment of Public Folders.
• Installed all the components of Cognos 8.4 suite of products in Dev environment with Application and Gateway on a single server and Content Manager in another server
• Installed all the components of Cognos 8.4 suite of products in 6 Servers of Prod environment with two for gateway, 3 App servers, One Appserver backup content manager, and one for content manager.
• Configured the Cognos 8.4 environment using Cognos Configuration with Application, Gateway and Content Manager Connections.
• Tested the Report/Cube Performances, Security, Batch Process, Report schedules in the new Cognos 8.4 environment.
• Set up Audit tables, Audit Report in Cognos 8.4 Environment to analyze the Report Usage and consequences before Upgrade.
• Setting up the Content store by creating content databases in SQL Server Management Studio,SQL Server 2005 and Oracle 10g.
• Setting up the Security of Cognos Suite of Products Query Studio to General Users, Report Studio Report Authoring to Power Users, Report Studio Professional Authoring to Report writers based on User Roles.
• Setting up the Security to Cognos FM packages, Folders and Reports in Cognos Connection by granting up Read, Write, Execute and Traverse Permissions based on user requirements.
• Participated in requirements gathering process to bridge gap between user needs and tool functionalities.
• Monitoring and Troubleshooting of servers with Performance Issues.
• Deployment of Models, Packages, Folders, Reports, Cubes, DataSourcesfrom Development environment to production environment.
• Worked on the Framework Manger to develop efficient data models like Entitlements, Invoice & Shipments, Force10GL, shipment by product line, Attach Rate, Balance Rate, Published Financial Statement, Sales order processing Metrics, Quotes & Details.
• Created the Dashboard portlets using portal tabs in cognos connection using cognos viewer and navigator.
• Developed the Dashboard portlets used for high level users in Force10 Networks for analyzing the data by various types of reports and charts.
• Designed Dashboards to different user groups and implemented security to dashboards.
• Created the different cube views using Analysis studio.
• Created various IQD packages in Framework Manager and from this IQD integrated to power play transformer to create various models and cubes.
• Generated all types of complex Reports - Purchase Order, Credit Debit Memo, Invoice Detail, Cost of Revenue Reconciliation, Expense Report details, Attach Rate, CRM Sales Orders & Comments, and Product Shipments.
• Generated Drill through Reports like Balance Sheet Details, Expense Report Details, OPEX Details, SOS Details, Statement ops Internal Details.
• Updated and maintained all cubes using batch files.
• Trained Users with new User Interfaces and technologies involved in Cognos 8.4
• Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
• 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.
• Created Value Prompt, Text box Prompt, Select & search Prompt, Date & Time Prompt, Tree Prompt.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Involved in step by step documentation and Cognos support Knowledge base and Proven Practices of cognos 8.3 to cognos 8.4 in upgrade.

ENVIRONMENT:IBM Cognos 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Series 7.4 (Impromptu, PowerPlay Transformer and all Server Administration), MDX, DB2, SQL Server 2005, Oracle 10g, Windows server 2003.

Confidential, Alexandria, VA

Sr.Cognos BI Analyst

Jan 08 to Sep 08

This project is a part of USPTO Internal Data warehousing. This project is developed for their Budgeting and Forecasting to analyze data for their requirements. The Projects helps users to analyze the Past, Current Budgets and forecast the Future Budgets. Involved in administration, development and troubleshooting of Budgeting and Forecasting reports, scorecards and dashboards.

RESPONSIBILITIES:

• Installation and configuration of all the suites of Cognos 8BI products and setting up Content store database, Active directory configuration, and Mail exchange server.
• Setting up the Cognos 8 BI environment to Client locations by Installing and configuring all the Cognos 8BI Components, Access Manager, Query Studio, Report Studio, Analysis Studio and LDAP directory server.
• Upgraded Cognos 8.2 Environment to Cognos 8.3 and Deploying and testing all the Reports and Setting up 3 tier architecture environments dev, test and prod.
• Setting up different project databases like Oracle, SQL server and imported and managed users, groups and roles from active directory.
• Worked on the Framework Manger to develop efficient star schema data models like SPR model, Program Objective model, Retailer model using multiple data sources.
• Design the Metadata modeling in framework manager model into various layers like Database layer, Transformation layer, Business layer and published as packages.
• Created Power Play cube as data source from both cognos series 7 and 8BI versions in framework manager and published as packages.
• Created List Reports, Dash Board Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Created and scheduled the alerts and events and emailed to users using Event studio.
• Generated all types of complex Reports - Staff on Board, Funds used by Business Area, Performance Goals, Fee Collections, Spending summary by BOC and ad hoc - Spending vs.Actuals used by Business Area, Applications Received using Report Studio and Query Studio from Model Packages and analyzed - General Ledger Detailreportsfrom cube packages planning.
• Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, and Master Detail Reports using Report Studio.
• 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.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another Cube, Power Play Portable Reports, Impromptu reports.
• Trouble shooting of the FM Models and Cubes according to the Report design and Business Requirements.
• Created Query Prompts, Calculations, Conditions and Filters in the reports.

ENVIRONMENT: Cognos 8.3(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Series 7.3(Impromptu, PowerPlay Transformer),SQL Server 2005,Oracle10g, DB2, Windows 2003 Server.

Confidential

Danbury, CT

Cognos Administrator/Developer

Feb 07 to Dec 07

This project is a part of Prudential Internal Data warehousing. This project was developed for Sales, Marketing, and Support user groups to analyze data for their requirements. Sales and Marketing 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. Support group reports are concentrated on the number of Service Requests received for different Products, average time taken to resolve the issues etc.

RESPONSIBILITIES:

• Installing & Configuring of Cognos 8BI, ReportNet, Access Manager, Upfront, LDAP directory server.
• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Involved in setting up the Cognos 8 BI environment to Client locations. Installed and configured all the 8BI Components Access Manager, Framework Manager, Analysis Studio, Event Studio, Query Studio, Report Studio, Upfront, LDAP directory server.
• Used 8BI Framework Manager in building the Models, Cubes using different data sources for CoA (Chart of Accounts), PDI (Prudential Distribution Inc.).
• Generated all types of complex - Work Order, Purchase Order, Account Balance Reports and ad hoc - Department Expense by Manager, Supervisor Reports using Report Studio and Query Studio from Model Packages and analyzed - General Ledger Detailreportsfrom cube packages using Analysis Studio.
• Created the Notifications and Alerts for the Reports that are critical in budget calculations using Event Studio.
• 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.
• Migrated several existing Cognos Impromptu Catalogs into xml files and imported thexml files as data sources into Cognos Report Net.
• Invloved in MigratingCognos Series 7.3 to Cognos BI 8.2
• Closely involved in security administration using Series 7 for the Cognos Report Net reports.
• Closely worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another Cube, Power Play Portable Reports, Impromptu reports and ReportNet reports.
• Used Transformer with a variety of sources and combined them into Multi-DimensionalCube.
• Involved in Documentation and Training Users and Business Partners on Query Studio for Ad Hoc Reporting.

ENVIRONMENT: Cognos8BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Series 7. 3 (Impromptu, PowerPlay Transformer), SQL Server 2005, Windows 2003 Server.

Confidential

Dallas, TX

Cognos Consultant/Analyst May 06 to Jan 07 CompuCom helps clients accomplish their business objectives by providing the comprehensive strategy, assessment, procurement, implementation, integration, and support services that help them derive maximum value from their IT operations. Primary tasks included designing, developing and implementing Models. The analysis of the Scorecards and Reports helped them in having increased understanding of their customer base, across all product businesses, as well as the ability to provide their customer relationship managers with meaningful, actionable information that impacts their decision-making processes.

RESPONSIBILITIES:

• Administered reports in Cognos like Scheduling ad hoc reports, viewing the run history of reports, distributing ad hoc reports by email.
• Used Access Manager to configure multiple user classes, defined dimension views and user class views for different user groups to provide high security for highly sensitive data.
• Administered Impromptu to Limit retrieval of large text items, limit the number of records to control the number of rows a user can retrieve for different User Classes.
• Involved in MigratingCognos Series 7.3 to Reportnet 1.1
• Involved in creating different types of ad hoc reports (grouped lists, crosstabs, etc.) using ReportNet.
• Customized ad hoc reports (adding charts, titles, etc.).
• Compared and analyzed data in ad hoc reports (using filters, summaries, prompts, etc.).
• Developed Power play reports like variance reports and exception reports.
• Troubleshoot and evaluated report effectiveness by tuning query data's and controlling user access.
• Defined, created, maintained and published power cube
• Created Impromptu Reports, published on the web using IWR.
• Provided End User training and Support.

ENVIRONMENT:Cognos Report Net v1.1, Cognos series 7.3(Impromptu, Powerplay, Transformer, Power play enterprise server), Access Manager, UPFRONT, IWR Server 7.3, Netscape Directory Server, SQL Server 2005, Oracle8i.

Confidential

Chicago, IL

Cognos Consultant

Aug 05 to Apr 06

Confidential, is committed to providing superior financial services to individual customers and small to midsized businesses. Investment banking department used the Cognos Series 7 and Report Net Tools for the existing Firm Backlog and Revenue system's information into catalogs, cubes and models in order to prepare Rapid Delivery of Ad-Hoc Data to IB associates (Bankers).

RESPONSIBILITIES:

• Involved in creating Metadata models (Using multiple data sources)using Framework Manager.
• Created several parameter maps, calculations and relationships in Framework Manager.
• Involved in organizing the Framework Manager model into several different business views based on end user requirements.
• Trained professional authors to write complex reports using Report Studio and trained power users to use Query Studio for Ad Hoc reporting.
• Worked extensively on applying and maintaining Security for several different users in Report Net developing prompt pages and conditional variables.
• Involved in testing and improving report performance.
• Installed and Configured Cognos series 7 (IWR, Upfront, PPES and Access Manager).
• Catalogs and reports using Impromptu Administrator and designed Power Play models using Transformer.
• Created Drill-Thru, Sub-reports and Chart reports using Impromptu Administrator.
• Created special categories and secured Power Play models using Power Play Transformer.
• Worked with Access manager Administrator to provide security for Cognos applications.
• Tuned the Impromptu/IWR reports and Power Play cubes.
• Published Impromptu Reports and Power Play cubes to Upfront using Cognos IWR Administration and Power Play Enterprise server respectively.
• Supported IWR/PPES users in production.

ENVIRONMENT: Cognos Report net 1.0 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio), Impromptu 7.3, Power play 7.3, Power play Transformer 7.3 and Oracle 8i.

Confidential

Columbus, OH

Sr. Cognos Consultant

May 04 to Jul 05

Nationwide is a leading provider of products and services in Insurance industry.The objective of this project is to support Business Executives to take quick decisions. Generated and analyzed reports based on buyers, representatives and marketing specialist that focus on employee and market performance in different locations.

RESPONSIBILITIES:

• Involved in Installation and Administration of Cognos Series 7 Tools.
• Created catalogs using Cognos Impromptu 7 to generate reports.
• Created standard filters, calculations, prompts and conditions in catalog.
• Designed report sets with user class mapping and published to different news boxes in Upfront in IWR server.
• Created Dashboards in Visualizer using various Power Cubes.
• Created DB links in database to generate Impromptu reports using two databases.
• 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.
• Maintained the Cognos Query Models, Impromptu, IWR, Cognos Power play and Power play Web.
• Implemented security and granted privileges according to user classes using Access Manager.
• Worked on Access Manager for giving security to Cognos Applications by creating Users and User Classes.

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 2000, Erwin, Ms-Excel, UNIX, Windows NT.

Confidential

Houston, TX

Cognos Consultant

Apr 03 to Apr 04

Confidential, is dedicated towards achieving excellence in all areas of patient care, to foster the highest levels of academic and clinical development of its physicians, and to provide strong leadership in the development, growth, and direction of health care in their community.

RESPONSIBILITIES:

• Involved in the entire life cycle of the application, which involved in understanding the scope of the project, functionality, development and reporting for analysis.
• Involved in designing Schema (STAR) for the business processes.
• Created Models based on the dimensions, levels and measures required for the analysis.
• Created database connections for different data sources.
• Involved in performing Administrative tasks like user authentication, creating new users for the cube.
• Involved in the Design and Development of Filters, Prompts and Calculated columns in Catalogs.
• Used impromptu to create .iqd files and used as source of data in Cognos Transformer to create multi-dimensional cubes to generate PowerPlay reports.
• Designed, Developed & Tested Power Cubes and deployed them in to production.
• Used Cognos PowerPlay to Analyze, anddisplay the Cubein different types of Charts.
• Drill down, Slice and Dice and Filtering operations done for all OLAP applications.
• Created the reports of sales for different products, different regions and demands for future forecasting.
• Wrote Macros used in reports for automation and scheduling purposes.
• Installing, Configuring, PerformanceTuning and ODBC connections of all Cognos tools.
• Upgraded Impromptu (Client) reports from Version 6.0 to Impromptu 7.0.
• Distributed copies of data in Snapshots, Thumbnails and Hot-files to improve the performance of reports.
• Coordinated in training sessions and demonstration of Cognos tools to End-users.

ENVIRONMENT:Cognos Impromptu Admin/User, Impromptu Web reports, Power play Transformer, Power play for Web/Windows, Upfront Server 7, Pl/SQL, Oracle 8i

EDUCATION:

• M.S in Computer science
• Bachelors in Computer Science Engineering

Reference Available on Request