PROFESSIONAL SUMMARY:

• An IBM Solution Expert with 8 Years of working experience in delivering end to end reporting solutions in IT with strong knowledge and experience in BI Reporting tools like, Cognos 8.1, 8.4, 10.1 10.2 and cognos
• Extensive development and working experience with Cognos Framework Manager, Transformer, Report Studio, Analysis Studio, Event Studio, Active Reports , Dash Boards, Business Insight and Business Insight Advanced
• Experience in developing Relational and Multi dimensional models with Framework Manager with best practice approach, Publishing Packages and generating reports from Multi dimensions through Cognos Report Studio, Analysis Studio, Business Insight and Business Insight Advanced
• Experience in creation of OLAP Models with different Data Sources and development of cubes using Cognos with best practice approaches during cube development.
• Performance tuning of Cubes by dropping indexes, denormalization and vertical partition and migration of Cognos 7.x versions to Cognos 8.4 and Cognos 10 and Transformer cube build batch file creation
• Hands on experience in Installation of Cognos8 and configuration on different databases like AS400,DB2, SQL Server and configuring Cognos to LDAP security and content administration activities like Restricting the user access on reports and web content ,scheduling the reports, mailing the reports
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies and proficient in understanding business processes / requirements and translating them into technical specifications.
• Writing SQL queries and Stored procedures in Oracle, SQL Server,DB2 databases

Technical Skill Set:

• OLAP Tools : Cognos 10.2, 10.1, 8.4, 8.3, 8.1 Cognos TM1 9.5,10.1
• SAP Tools : SAP HANA ,SAP BO
• Database : Oracle9i/10g/11g, Teradata, DB2 8/9.5, SQL Server 2005
• Operating Systems : Win XP, 2000 Server, 2003 Server,UNIX,LINUX
• Web Technologies : HTML, XML, Javascript, ASP,VB Script

Project Experience:

Project 1:

Confidential

Role : Sr.Cognos Developer

Environment : Cognos 8.4 ,10.1 10.2, LINUX,AS 400

Roles and Responsibilities

• Gathering Business requirements and translated to the Technical Specifications
• Documented the TRDs towards the Cognos implementation according to the compliance
• Performed root cause analysis of the reports issue and provided resolutions for the same.
• Created Packages using Framework Manager
• Developed dashboard reports using Report Studio
• Implementation of Active Reports for each client for summarized data transactions
• Worked with all type of report functionality: sorting, grouping, parameter display value, singleton, master and detail, drill through and aggregation functions
• Worked with all types of prompts: Cascading, Value, select and search, date prompts.
• Effectively used static choices in Value Prompts where ever required to improve report performance.
• Developed dynamic reports to sort and display column based on conditions.
• Used variable like String and Boolean for all conditional formatting and rendering requirement.
• Created Conditional Block reports to dynamically hide or show reports objects and provide the end user the option to view the data in different formats.
• Developed complex reports, multi-query reports and sub select queries to meet the client requirements.
• Used set operators like union and intersect to meet the data requirement of the clients
• Used report level Joins.
• Implementation of the Cubes Transformer using package objects and reports
• Experienced in writing and understanding complex SQL queries.
• Implemented Security for Data access, Object level access and Package access.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.
• Developed PowerPlay Cubes for better analysis of the data.
• Performed unit testing and created various test result documents and test case documents.
• Conducted peer reviews to ensure defect free code will go to the end user.
• Provided support during user acceptance.
• Supporting the same at various stages of testing QA,UAT Production
• Project 2:
• Confidential
• Role : Sr. Cognos Developer
• Environment : Cognos 10.1 10.2, LINUX, Windows, Oracle
• Roles and Responsibilities
• Worked closely with users to gather the reporting and analytical requirements
• Designed and developed a packages in Framework Manager
• Implementation of the Cubes Transformer using package objects and reports
• Developed dashboard reports using Report Studio
• Implementation of Active Reports for each client for summarized data transactions
• Worked with all type of report functionality: sorting, grouping, parameter display value, singleton, master and detail, drillthrough and aggregation functions
• Worked with all types of prompts: Cascading, Value, select and search, date prompts.
• Effectively used static choices in Value Prompts where ever required to improve report performance.
• Used conditional Blocks to render various dashboards based on the user inputs
• Developed dynamic reports to sort and display column based on conditions.
• Used variable like String and Boolean for all conditional formatting and rendering requirement.
• Created Conditional Block reports to dynamically hide or show reports objects and provide the end user the option to view the data in different formats.
• Developed complex reports, multi-query reports and sub select queries to meet the client requirements.
• Used set operators like union and intersect to meet the data requirement of the clients
• Used report level Joins.
• Experienced in writing and understanding complex SQL queries.
• Implemented Security for Data access, Object level access and Package access.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.
• Developed PowerPlay Cubes for better analysis of the data.
• Performed unit testing and created various test result documents and test case documents.
• Conducted peer reviews to ensure defect free code will go to the end user.
• Provided support during user acceptance.
• Supporting the same at various stages of testing QA,UAT Production

Project 3:

Confidential

Role : Cognos Developer

Environment : Cognos 10.1, SAP BW

Roles and Responsibilities

• Developed dynamic reports to sort and display column based on conditions.
• Used variable like String and Boolean for all conditional formatting and rendering requirement.
• Created Conditional Block reports to dynamically hide or show reports objects and provide the end user the option to view the data in different formats.
• Developed complex reports, multi-query reports and sub select queries to meet the client requirements.
• Used set operators like union and intersect to meet the data requirement of the clients
• Used report level Joins.
• Experienced in writing and understanding complex SQL queries.
• Implemented Security for Data access, Object level access and Package access.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.
• Developed PowerPlay Cubes for better analysis of the data.
• Performed unit testing and created various test result documents and test case documents.
• Conducted peer reviews to ensure defect free code will go to the end user.
• Supporting the same at various stages of testing QA,UAT Production

Project 4

Confidential

Role : Cognos Developer

Roles and Responsibilities

• Gathering Business requirements and Specifications and documentation towards the Cognos implementation according to the compliance
• Modeling of the metadata in Framework Manager which includes DMR Dimensionally modeled Relational Source for Adhoc analysis along with the inherited row level data security which is used to restrict the data access for each user
• Created Conditional Block reports to dynamically hide or show reports objects and provide the end user the option to view the data in different formats.
• Developed complex reports, multi-query reports and sub select queries to meet the client requirements.
• Used set operators like union and intersect to meet the data requirement of the clients
• Used report level Joins.
• Experienced in writing and understanding complex SQL queries.
• Implemented Security for Data access, Object level access and Package access.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.
• Developed PowerPlay Cubes for better analysis of the data.
• Performed unit testing and created various test result documents and test case documents.
• Conducted peer reviews to ensure defect free code will go to the end user.
• Provided support during user acceptance.
• Supporting the same at various stages of testing QA,UAT Production