Professional Summary:

• 7 years of experience in Design and Development with the primary focus on the Cognos 10, Cognos
• Experienced in implementing large-scale applications with leading technologies in Business Intelligence and involved in complete software development life cycle SDLC
• Extensive experience in Designing the Framework Manager models, to meet BI industry standards applied Physical Layer, Business Layer and Presentation Layer approach to increase the model durability
• Created models with different data sources such as Oracle, SQL Server and MS Access
• Extensive experience in creating Managed/Complex reports using Report Studio and creating ad-hoc reports using Query Studio
• Created different kind of analytical reports including templates, List, Cross-Tab, Chart, Repeaters using Report Studio
• Worked on advanced features of Report Studio such as Conditional Variables, Conditional Blocks, Drill-through, Page set, Master-Detail relationships, Bursting and various kind of prompts Value prompt, Date prompt, Textbox prompt
• Experienced in Reports Deployment from development environment/server to Testing and Production environment.
• Hands on experience in reports migrating from Cognos 8 series to Cognos 10
• Troubleshoot issues with existing reports and cubes, Expertise on creation and maintenance of models, which involved defining security, joins, and cardinality.
• Created multi-dimensional reports using Analysis Studio and applied context filters for better analysis
• Having experience in implementing security for Cubes and Package, Object and Data level security for Packages
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing database schemas Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Excellent work ethics, self-motivated, quick learner and team oriented

Technical Skills

Professional Experience:

Confidential

Cognos Developer

Responsibilities:

• Involved in gathering the business requirements from the Users and documenting it for reporting needs.
• Research on collected business requirements and translate business requirements into system specifications and develop reports as per the client requirements.
• Building models in IBM Cognos Framework Manager Database Layer, Logical Layer, and Presentation Layer and publishing packages.
• Created Data Level, Object level, Package level and Row level Securities in Framework Manager Models.
• Developed Multi-page reports, List reports, Charts, Drill through and Master-detail reports using Report Studio.
• Created various Prompts, Filters, and Calculations and used Conditional Formatting as per the requirement.
• Worked on Data Analysis, Validate reports and find data quality issues.
• Scheduled the reports in Cognos Connection and distributed them via mail.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• To maintain numerous pre-existing reports and a fully functional multi user Portal Dashboard.
• Built multi-dimensional reports using Analysis Studio.
• Involved in building OLAP Transformer Cubes using Packages and Reports.
• Publishing Packages for the web users.
• Customizing user class security views in Cube by user classes / Roles.
• Created Technical design document for Report studio reports based on Functional specifications.
• Created and performed the Unit and Integrity test cases and assisted the testing team in System Test and Production move process.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Troubleshoot Cognos Server Environment for the better performance.

Environment: Cognos 10.2.1, Frame Work Manager, Cognos Connection, Report Studio, Query Studio,

Workspace Advanced, Oracle 11g

Confidential

Cognos BI Developer

Responsibilities:

• Conducted requirements gathering sessions and interacted with business process owners to understand the functionality required.
• Analyzed and optimized the process. Prepared Business Requirements Document and then converted the business requirements into Functional Specifications and Technical Specifications.
• Worked in Reports studio,TM1 Tools
• Prepared meeting minutes and distributed to various participants and for artifacts purposes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Implemented data level and object level security in Framework manager.
• Created prompts, calculations, conditions filters in the report as well as in the Framework Manager.
• Created Dashboards and modified the existing Dashboards using Report Studio.
• Created Drill through Reports and also used Conditional Formatting extensively.
• Improved performance of the Reports.
• Set up required permissions in the Cognos Portals for the User group for security purposes.
• Document the list of changes that impact the reports using MS Word and MS Excel.

Environment: Cognos 8.3 BI, Framework Manager, Cognos Connection, Metric Studio, Impromptu 7.4, Transformer 7.4 ,Windows 2003 server.

Confidential

Cognos Developer

Responsibilities:

• Involved in gathering the business requirements from the Users and documenting it for reporting needs.
• Research on collected business requirements and translate business requirements into system specifications and develop reports as per the client requirements.
• Building models in IBM Cognos Framework Manager Database Layer, Logical Layer, and Presentation Layer and publishing packages.
• Created Data Level, Object level, Package level and Row level Securities in Framework Manager Models.
• Developed Multi-page reports, List reports, Charts, Drill through and Master-detail reports using Report Studio.
• Created various Prompts, Filters, and Calculations and used Conditional Formatting as per the requirement.
• Worked on Data Analysis, Validate reports and find data quality issues.
• Scheduled the reports in Cognos Connection and distributed them via mail.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• To maintain numerous pre-existing reports and a fully functional multi user Portal Dashboard.
• Built multi-dimensional reports using Analysis Studio.
• Involved in building OLAP Transformer Cubes using Packages and Reports.
• Created Technical design document for Report studio reports based on Functional specifications.
• Created and performed the Unit and Integrity test cases and assisted the testing team in System Test and Production move process.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos
• Performed Data validations, Unit testing and preparation of Unit test cases.

Environment: Cognos 8.4 Bi Suite Framework Manager, Transformer, Cognos Connection, Query Studio, Report Studio , Oracle 10g, Windows 2003 Server.

Confidential

Cognos DEVELOPER

Responsibilities:

• Built models using Framework Manager and published the package.
• Accessed published package using Cognos Connection.
• Prepared Unit Test Cases and performed testing in the development environment.
• Reports were triggered by DB Stored Procedures.
• Created Query Subjects in Framework Manager as stored procedure source with parameter mapping.
• Maintained and published Framework Model.
• Analyzed existing Crystal reports and incorporate the calculation in the Framework Model.
• Initially the Framework Manager Query Subject was pointed to SQL Server2000 as database and all the reports have been developed. In final, the same Framework Manager is deployed to Oracle 9.1 and all the ReportNet reports made to run successfully on both the platform.
• Created drill-thru reports and cross-tab reports in Report Studio.
• Involved in the design and development of CRN reports in Report Studio.
• Created complex reports with sub-queries and sub-sub-queries.
• Created reports that included ReportNet functionality such as prompt pages, cascading prompts, conditional filters etc.
• The report was designed as a Master-Detail report as every manager could have several objectives, strategies and resources.
• Reports output have been designed to carter for both PDF and HTML formats.
• Tested the reports and migrated to UAT for the second level of testing.

Environment: Cognos Report Net 1.1, SQL Server, Oracle 9i, PL/SQL, Crystal Reports XI, OLAP, Windows XP.

Confidential

Cognos BI Developer

Farmers Insurance Group is a provider of insurance management services. This project was developed for Financial, Sales, Marketing and Support user groups to analyze data for their requirements.

Responsibilities:

• Developed and monitored models using Framework Manager 1.1 to address the
• Dynamic business needs of the company.
• 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.

Confidential

COGNOS Developer

Responsibilities:

• Set security for individual reports in Cognos Connection.
• Created Query Prompts, Tree prompts, Query calculations, Conditions Filters.
• Developed Complex reports in Report Studio using Complex SQL queries
• Created list reports, cross tab reports, chart reports, Master detail reports, Drill through reports and reports with lot of conditional formatting using Report Studio.
• Publishing Cubes and Packages for the web users.

Environment: Cognos 8.4.1 Suite Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio , Oracle 11g.