Cognos BI professional with 8 years of expertise, specializing in Analysis, Design, Development and Implementation of Cognos 10 BI, Cognos 8 BI, Cognos ReportNet, and PowerPlay Tools.

• Extensive working experience with Cognos 10.x BI Cognos Connection, Report Studio and Framework Manager , Cognos 8.x BI suite Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio and Framework Manager and PowerPlay Transformer.
• Proficient in building models, creating packages using Framework Manager and publishing the packages to Cognos Connection.
• Highly skilled in developing relational and dimensional reports using Cognos 10.x/Cognos 8.x/ReportNet Report Studio and Query Studio, and PowerPlay.
• Proficiency in query optimization and performance tuning techniques.
• Strong experience in designing, developing and deploying multi-dimensional cubes using PowerPlay Transformer.
• Highly skilled in gathering the business requirements and translating them into data needs.
• Expert in creating and analyzing User and System Requirement Specification documents.
• Highly qualified in preparing technical specification documents and code review documents.
• Experienced in administering Access Manager for implementing security among Cognos applications.
• Hands on experience in working with Oracle, SQL, PL/SQL and MDX scripting.
• Experienced in manual Functional testing of the reports and development of Test Case documents and Test logs.
• Knowledge of Cognos Metric Studio, SSIS SQL Server Integration Services , Data Warehousing Concepts and Data Modeling Techniques.
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules, possess strong leadership qualities and good communication skills.

Confidential is an S P 500 company and the largest public U.S. real estate company. Worked on Multiple projects SSLE, LMI, GURU-CF B, these projects goal is to build the Forecasting and Budgeting reports, create a Framework Model for Lease Management and develop reports related to Deals and Leases in Cognos 10.2/Cognos 8.4.

Responsibilities:

• Analyze the existing report use cases, discuss the requirements/enhancements and the report layout to build the reports.
• Work with Business Analysts and Users to ensure the Business requirements are clearly understood and accommodated into the reports.
• Updated the existing Lease Management Reporting Framework Manager Model by adding and importing tables from a new data source DLMART , creating parameter maps, macros, unions etc. and performed all the necessary changes required for the development of the reports through out the project.
• Create complex reports with multiple queries using SQLs, Master-Detail Relationships, Joins, Sub queries, Query references and Query Calculations.
• Create prompts and filters to dynamically restrict the data based on the user's selection/preference.
• Enhance the layout/Format of the reports by implementing Dynamic Grouping and sorting, Conditional Variables, Conditional Blocks, Layout Calculations, Layout Component References and etc.
• Employed parameterized filters, dynamic grouping and sorting, conditional formatting using Style and Render variables to enhance the reports.
• Finely tune the report queries and the report SQLs to improve the performance of the reports.
• Deployed the reports from the development environment to the QA environment and then to the Production.
• Include the enhancements and fix the QA/UAT/Production issues based on the priority.
• Perform unit testing of all the reports to ensure the data is accurate.
• Run the SQL in TOAD against the DB2 database to compare the result set to the developed result set.
• Manually test the report data by comparing the data against the application detail screen and also based on the existing reports.
• Involved in the Production support for some of the Lease/AR projects.

Confidential is a research-based biopharmaceutical company that discovers, develops and commercializes innovative medicines in areas of unmet need. The goal of the project was to create Adhoc-Layer model and KAS Key Account Specialist reports for call activity data using Cognos BI suite.

Responsibilities:

• Created Cognos Framework Manager Model for IHD Adhoc reporting.
• Implemented data level security in Framework Model for Adhoc Model.
• Modified existing Cognos Framework Model to get the new business functionalities.
• Worked with SSIS ETL team to implement new business requirements.
• Created dashboard reports with drill through options.
• Wrote SQL queries comparing the data between Cognos and SQL Server database.
• Coordinated with business users and other technical teams for understand the impact analysis.
• Created detailed reports using lists, cross tabs and charts. Used conditional blocks and render variables.
• Created two reports by using conditional layouts. Used static choices for prompts.
• Scheduled Cognos reports to run Daily, Weekly, Monthly, Quarterly and annually.
• Configured the ODBC connections for different applications.
• Inserted Tables, blocks, Text items and Date prompts on to the page from toolbox.
• Created report pages and prompt pages from page explorer.

.

Confidential is a leading global financial services firm with assets of 2 trillion and operations in more than 60 countries. The firm is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity.

The goal of the project was to create models, cubes and reports using Cognos BI suite.

Responsibilities:

• Gathered Business Process Requirements from business users, for the reports to be developed.
• Created Cognos Framework Manager Models using multiple data sources.
• Developed List reports, Cross tab reports and Chart reports showing loans.
• Created Master Detail reports on Mortgage using Report studio.
• Involved in exclusive auditing data.
• Scheduled Cognos reports to run Daily, Weekly, Monthly, Quarterly and annually.
• Configured the ODBC connections for different applications.
• Inserted Tables, blocks, Text items and Date prompts on to the page from toolbox.
• Created report pages and prompt pages from page explorer.
• Calculated data items in the query explorer and applied properties to the data item.
• Created multiple filters in multiple queries.
• Applied grouping, sorting, aggregate functions and sections to the data items on the page to get the required Cognos report.
• Created Cognos report views to the business users.
• Tested the join paths between the tables in Cognos Framework Manager.
• Developed and Published the Packages in Framework Manager.
• Connected and tested the database connectivity in the Cognos connection.
• Fixed issues with reports and successfully deployed the reporting application for
• Production.
• Maintained Cognos models, packages, cubes and reports for different applications.
• Had multiple meetings with the client to ensure that business requirements are understood in the process of delivering appropriate solution and translated client's high-level requirements into effective BI solution.

Confidential is a leading provider of private mortgage insurance, directly and through subsidiaries, in theConfidential . provides various products and services for the home mortgage finance industry, as well as title insurance. The OCC project approach is to replace the existing reports with equivalent functionality reports in ReportNet 1.1/Cognos 8 platforms that allows for combined reporting across multiple instances and provides improved supportability, performance and flexibility to respond to business needs.

Responsibilities:

• Interacted with the Business Users, BI Team, ETL Team and Report Analysts to analyze the report use cases.
• Created Single Page Single Query List reports employing the PMI Mortgage Insurance Templates and by following the naming conventions.

• Developed and monitored models using Framework Manager 1.1 to address the dynamic business needs of the company.
• Developed and monitored standard, complex and invoice reports on the claims made, claims status history, revoked insurance policies and new insurances to reflect trends, conversion rate and profitability.
• Scheduled the reports in Cognos Connection and bursted them through email and directories, using the burst table.
• Applied compound Conditional Formatting and Dynamic Highlighting by applying conditional blocks, Style Variables and Render Variables.
• Applied various prompts by assigning static choices and employed complex filters based on the parameter selection.
• Carried out standardizations in the prompt and report pages.
• Tuned SQL queries for performance.
• Created Mapping document for the Framework Manager Model to Notes.
• Created Technical Documents and Code Review documents for the reports
• Created and updated the Report Test Cases and Test Logs.
• Implemented Functional Testing of the reports.
• Verified the report filters and validated the reports.
• Performed duties based on the task list priorities and Issues related to the tasks.
• Trained end users in Cognos connection and Query studio to enable them to create Adhoc reports