COGNOS BI Report Author

Skilled, talented and dedicated IT professional. 5 years experience in Cognos Modeling, reporting, and business intelligence that significantly improve administrative decision making. Seeking a challenging position requiring my capabilities.

Professional Summary

• Having 5+ years of IT industry experience in BI Cognos and Data Warehousing, with expertise in providing business solutions in Functional as well as Technical approach and good in Data Warehousing, Data Modeling and Reports Generation by using reporting tools.
• Hands on experience in SDLC processes and methodologies in Business Intelligence domain.
• Expert in Business Intelligence Applications usingCognosTools such asCognos10.1 & 8.x BI(Report Studio, Analysis Studio, Query studio).
• Expertise in Report building using Report Studio and Analysis Studio.
• Experience in creating end user reports (like Cross tab, list, chart etc.) using Cognos Report Studio and Cognos Query Studio.
• Hands on experience in creating Cascading Prompts, Filters, Grouping, Sorting, Section and Conditional Blocks.
• Working experience in tools such as Erwin and MS Visio Professional.
• Handled complete project life cycle of reporting from requirements gathering to go live.
• Extensive knowledge with Dimensional data modeling star schema, snow flake schema, Fact and dimensional tables.
• Good verbal and written communication skills, analytical skill and competent team player.

Technical Skills

• BI Tools: Cognos 10, 8.x (Report Studio, Analysis Studio, Query Studio, Cognos connection, Framework Manager)
• Databases: MS SQL Server 2005, MS Access
• Microsoft Tools: MS Excel, MS Word, MS Power Point, Ms Visio
• Languages: SQL, HTML
• Operating System: Windows 7, XP
• Knowing about: Oracle 9i, 10g. (PL/SQL Developer, Oracle SQL Developer)

Work Experience - Project Details

Confidential, WI
Cognos Developer, 2/2011 to Present

School Specialty is forging an exciting era in the educational market as the industry\'s most extensive provider of solutions focused on helping educators help students succeed. School specialty help educatorsaccomplish more by providing them with the most innovative and complete range of educational products, programs and services that enhance student's achievement and development. Key results:

Responsibilities:

• Generated reports and handled modeling as per user requirement.
• Created filters, prompts, calculations and determinants for efficient data retrieval and analysis.
• Created parameter maps; stored procedures for importing as data source, checked for corrupted models and restored to original.
• Proficient in Report building using Report Studio, and Analysis Studio.
• Created List, Crosstab and Drill-Through reports using Report Studio.
• Created Ad-Hoc reports using Query Studio.
• Deployed the reports from development environment to test environment.
• Active team player in the Project.
• Tested models and reports, from time to time to remove any inconsistencies. Responsible for Unit testing and System testing of the reports based on the specification.
• Reporting testing - creating test cases, scripts and executing them. Tested the fixed reports in Cognos 8 environment as well as the Performance of the reports in Cognos 8 environment.

Environment:
Cognos 8.4.1 (Transformer, Cognos Configuration, Framework Manager, Report Studio, Query Studio & Analysis Studio), Cognos 8.3 BI, Windows Server 2008, SQL Server 2005, Oracle 10g, MS Office (MS Excel, MS Access)

Confidential, NJ
Cognos Developer, 11/2009 to 12/2010

Lyo analysis is a Batch Information management system. It is a powerful high capacity data warehousing system that enables the retrieval and storage of all types of field monitored data's like Product temperature, Vacuum condition, Relative Humidity, Employee entry and Pressure for analysis, Reporting and measuring against thresholds. The data's like Batch Processing record, system generated alarm, time-series alarm, images and electronic document files that have been collected by external monitoring devices and by Pharmacists. Data are measured against Research and Development, Process Development Lab, Kilo Lab as per other standard batch data. Reports are generated both for internal use and for submission to regulatory bodies. The strength of this system is its flexibility, allowing user definition of monitoring programs, criteria, guidelines and data accessible through single package. The application contains OLAP features like Drill up, Drill down and Multidimensional analysis, Sub reports, Prompts and Exception Highlighting.

Responsibilities:

• Creating Reports for end users analysis
• Gathered and analyzed business requirements from users and business community.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Supported Business Users in generating AdHoc Reports using Query Studio.
• Understanding existing business model and customer requirements
• Created Complex Reports using Lists, Crosstabs, charts, graphs and Images.
• Scheduled Reports through Jobs to get the Daily, Weekly, Bi-Monthly and Monthly output of reports.
• Created filters, prompts, sub reports, provide drill through capabilities
• Deployed reporting objects from a development environment to test and then to production environments as per the process.
• Played a team member role in a team of 4 with effective communication, negotiation and client handling skills.
• Worked on Star Schema Database Design.
• Environment:
• Framework Manager, Report Studio, Cognos Connection, Query studio, Analysis studio, Powerplay Transformer, Cube Reports ,Oracle 9i ,Toad.

Confidential, Singapore
Life Insurance Solution Accelerator
Cognos Developer 7/2008 - 10/2009

This project involves the development of a Life Insurance Dash Board that demonstrates the Key Performance Indicators of Life Insurance business. This Dashboard shows the reports and analysis into five functional segments namely Financials, Policy, Claims, Expenses and Customer segmentation. A star schema was designed to handle various reports and analysis. The logical data model and physical data model was designed and created using Erwin 4.0.Informatica Power Center 5.1 and SQL scripts were used to load the data into the Oracle 9i Database from flat files and Oracle source data.

Responsibilities:

• Queried data from different database tables as per the requirement.
• Created packages using multiple data sources in the framework manager.
• Created Dashboard for the presentation using most of the Cognos functionality (such as Conditional Formatting, Drill through and Dashboards etc.)
• Performed optimization on the existing reports to decrease the run time to meet the presentation time requirements and made changes to the existing reports for good look and feel.
• Created step by step documents for the packages and Reports creation
• Conducted User training for a batch of 10 on Cognos8.
• Providing support and troubleshooting problems as required.

Environment: Framework Manager, Report Studio, Query studio, Oracle 9i

Confidential, Banglore- india
Jr. Cognos Developer, 01/2007 to 06/2008

Implemented web-based reports that delivered multidimensional reporting capabilities to the business user. Created web-based ad-hoc reports, interactive charts and dashboards.

Responsibilities:

• Creating reports (Report/query studio) which cater to different employees at different levels.
• Report includes all types such as charts (bar, bubble, line, lists etc).
• Analyzing the requirement and building complex SQL Queries.
• Dashboards and Drill-through reports for the complete management hierarchy.
• Interacting with the user to get the detailed information about the issues.
• Preparing and testing the code to fix the issues in Development and QA environment.
• Involved in preparing Test scripts and validating the data based on the Scenarios.

Environment:
Framework Manager, Report Studio, Cognos Connection, Query studio, Analysis studio, Powerplay Transformer, Cube Reports ,Oracle 9i.