BACKGROUND SUMMARY:

• Around 7yrs of Strong design/development experience with Business Intelligence solutions, OLAP tools and Data Warehousing (DW).
• Strong administrative and development knowledge of Cognos environment and tools IBM Cognos 8BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Report Net, Impromptu, Power Play, Impromptu Web Reports (IWR), Access Manager, Upfront and IWR servers.
• Administered 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 Writing SQL queries, Dynamic-queries and implementing SQLServer Indexing.
• Extensive experience in SQL Server - Stored Procedures, Triggers, User-defined Functions and Views.
• Experience in using all kinds of SQLServer Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
• 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.
• 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 Power 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), Report Net 1.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, Access Manager

Databases

Oracle 10g/9i/8i/7.x,SQL Server 7.0/2000/2005,MS Access 97/00/XP/03

GUI

Developer 2000, Crystal Reports, Business Objects, Erwin

ETL Tools

Informatica PowerCenter 7.x, Cognos Decision stream, 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

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

Operating System

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

CERTIFICATION:

Cognos Certification Program

IBM Cognos Certified Designer --ID: SR5700682

PROFESSIONAL EXPERIENCE:

Confidential

Madison,WI

Sr. Cognos Admin & Developer

Jan 10 to Till Date

The purpose of the EMO Business Intelligence Project is to develop a solution specific to Alliant Energy's fuel cost management processes that improves the Fuel Cost Forecasting, Variance Reporting, and Leading Indicators Reporting. The project must improve the timeliness, accuracy, and availability of data related to the fuel costs to Alliant Energy. Through these improvements, Alliant Energy expects to save 0.5% on annual fuel costs. Alliant Energy's two operating utilities—Interstate Power and Light (IPL) and Wisconsin Power & Light (WPL)—are each governed by separate fuel cost adjustment rules which allocate fuel costs among ratepayers and shareowners.

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.
• Worked with the business users in identifying and defining the product requirements and directions.
• 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.
• 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
• Setting up the Content store by creating content databases in Oracle 10g
• Set up Audit tables, Audit Report in Cognos 8.4 Environment to analyze the Report Usage.
• Involved in gathering Business Requirements and prepared the requirements specification document.
• Built Framework Manager Model and established the cardinalities to suit the business needs.
• Involved in regularly meeting with the data warehousing team on discussing about the changes in the schemas and Setup Security using Access Manager Administration.
• Created Dimensional Models by using Impromptu Query Definition (IQD) in Power play Transformer.
• Used Cognos8BI Framework Manager in building the dimensional/relational Models usingdifferent data sources like Oracle 10g.
• Expertise with creating page breaks and Created complex reports using conditional formatting and cascading prompts multi list reports, static choice prompts and HTML items.
• Worked on the Framework Manger to develop efficient data models like EMO_Datawarehouse Layer, EMO Datamart Reporting, LoadZone Cost Datamart, Generator Margin, Energy Revenue, and Coal Burn Volume.
• 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 - Forced Outage Rate, Generator Outages & Derates, Estimated Fuel Burn Coal, Coal Price - Weighted Average, Day Ahead Spinning Reserves, Demand (Load Forecasts).
• Extensively worked on performance tuning for existing reports in Report Studio and Testing and improving Report Performance and performing Query optimization.
• Involved in importing and exporting of data from development to production using the deployment option in the Cognos connection portal.
• 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 Alliant Energy 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.
• Scheduling and distributing reports through schedule management in Cognos Connection, coordination with users, Business Analyst and administrator
• Developed Standard Reports, Dashboards, Charts, Drill through Reports, Master Detail Reports and Bursting Reports using Report Studio and Query Studio.
• Widely used Oracle for trouble shooting and testing the data level errors and cross-checking values by using SQL queries.
• 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.
• Trained Users with new User Interfaces and technologies involved in Cognos 8.4
• Submitted issues in Quality Center and Regularly Checking the Status of the issue and Work closely with Developers to resolve.

ENVIRONMENT:IBM Cognos 8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Series 8.4 (PowerPlay Studio, Transformer), Oracle 10g, Windows server 2003, Rational Clear Case, Clear Quest.

Confidential

San Jose, CA

Cognos Sr.Admin/Developer

Oct 08 to Dec 09

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 Developer and Administrator 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 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.
• Modified the SQL in Report Studio to tune and/or to write complicated reports. Used subsets to write union/subtract queries in Report Studio.
• Updated and maintained all cubes using batch files.
• Created the Notifications and Alerts for the Reports that are critical in budget calculations using Event Studio
• 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.
• Co-ordinating with ETL and Testing teams to support business enhancements.
• Involved in documentation and Cognos support Knowledge base, Proven Practices of 8.3 to 8.4 upgrade.
• Involved in test planning, test case design, test script generation and design documents walkthroughs
• Based on use cases Test plan and Test cases were developed and maintained in Quality Center
• Submitted issues in Quality Center and Regularly Checking the Status of the issue and Work closely with Developers to resolve.
• Trained Users with new User Interfaces and technologies involved in Cognos 8.4

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), SQL Server 2005, Oracle 10g, Windows server 2003, Rational Clear Case, Clear Quest.

Confidential, Alexandria, VA

Cognos BI Admin/Developer

Jan 08 to Sep 08

Spending and performance project is a budgeting and forecasting application and is part of USPTO Internal Data warehousing. It helps users to analyze the Past, Current Budgets and forecast the Future Budgets. Involved in requirements analysis, 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 layerand 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.
• Developed the Dashboard portlets used for PTO users for analyzing the data by various types of reports and charts.
• Designed Dashboards to different user groups and implemented security to dashboards.
• 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.
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• 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.
• Closely worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency.
• 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.
• Troubleshoot and evaluated report effectiveness by tuning query data's and controlling user access
• Documented and Trained Users, Business Partners on Query Studio for Ad Hoc Reporting and Report Studio.

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

Confidential

Cognos Administrator/Developer

Jun 06 to Nov 07

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:

• Installing & Configuring of Cognos 8BI, ReportNet, Access Manager, Upfront, LDAP directory server.
• 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
• 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.
• 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
• Closely worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency
• Created list, Cross tab, Charts & Nested Cross tab reports in Report Studio. Worked with Prompts, conditions, filters and calculations.
• 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.
• Administered reports in Reportnet 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.
• AdministeredImpromptu 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 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
• Involved in Migrating cognos series 7.3 to cognos BI 8.2
• Created Impromptu Reports, published on the web using IWR.
• Provided End User training and Support.
• 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.
• Provided production support and training to end-users.

ENVIRONMENT: Cognos 8.2(Frame Work Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), 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, SQL Server 2005,Windows Server 2003.

Confidential

India

Cognos Consultant

Jan 04 to Apr 06

This project is a part of Internal Data warehousing. This project was developed for Finanace, Sales, Marketing, and Support user groups to analyze data for their requirements. Finance, 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.

RESPONSIBILITIES:

• Involved in Installation and Administration of Cognos Series 7 Tools.
• Created catalogs using Cognos Impromptu 7 to generate reports.
• Created users and changed their profile as per the requirement.
• Created standard filters, calculations, prompts and conditions in catalog.
• Enhanced existing reports and created new reports as per requirements.
• Designed report sets with user class mapping and published to different news boxes in Upfront in IWR server.
• Created different types of reports like Drill through reports, Sub reports, and List reports.
• Involved in the generation of different types of reports for different sets of data to target customer segments, which can be changed in many ways to 'Slice and Dice' and drill-through data for further multi-dimensional OLAP analysis.
• Created DB links in database to generate Impromptu reports using two databases.
• Maintenance and Enhancement of the project.
• Involved in Software Development Life Cycle (SDLC).
• Developed and implemented Stored Procedures using SQL SERVER.
• Wrote SQL Scripts and performed unit testing and integration testing.
• Designed models by mapping business needs using Power play Transformer and created multi dimensional cubes, cube groups, power play reports.
• Created Multidimensional 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.
• Used Governors settings to limit retrieval of large text items, limit the number of records to control the number of rows a user can retrieve, to limit the number of tables a user can retrieve in a report and to limit the query execution time for different User Classes.
• Decreased the cube build times drastically and increased runtime performance.
• Applied Drill through for the reports to get detailed information of a particular field in another report
• 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.
• Provided training to end users on Cognos Impromptu, IWR and Power play.

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, Cognos Report net 1.0 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio), ASP.NET, Windows 2003.

EDUCATION:

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

Reference Available on Request