We provide IT Staff Augmentation Services!

Bi Developer Resume Profile

MN

PROFESSIONAL SUMMARY:

  • Over 8 Years of 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.
  • Extensive development and working experience with Cognos Framework Manager, Transformer, Power Play, 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 and Publishing various packages
  • Designed reports with Relational and Multi dimensional models and extensively used 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 and followed best practice during cube development.
  • Hands on experience on Installation of Cognos8 and configuration on different databases like 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.
  • Strong knowledge in RDBMS, Data Normalization and ER diagram
  • Strong hold on SQL queries and Stored procedures in Oracle, SQL Server,DB2 databases
  • Excellent work ethics, self motivated, quick learner with good interpersonal and communication skills.

Technical Skill Set:

BI/ OLAP Tools : Cognos 10.2, 10.1, 8.4, 8.3, 8.1 , Impromptu, Transformer, Power Play, Business Objects,

Crystal Reports.

SAP Tools : SAP HANA ,SAP BO

ETL Tools : Datastage, Informatica

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:

Confidential

Role : BI Developer

Environment : Cognos 10.2 ,Unix, ASP, Oracle,Informatica

  • Gathering Business requirements and translated to the Technical Specifications
  • Documented the TRDs towards the Cognos implementation according to the compliance
  • Created BI data mart design with Dimensions and Facts Tables.
  • ETL process created to extract the data from main Finance ODS database
  • Created Cognos Packages using Framework Manager
  • Developed dashboard reports using Report Studio
  • Worked with all type of report functionality: sorting, grouping, parameter display value, singleton, master and detail, drillthrough and aggregation functions
  • 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.
  • 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

Confidential

Role : Sr.Cognos Developer

Environment : Cognos 8.4 ,10.1 10.2,Informatica

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, 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.
  • 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, Packages and New Dashboard Reports using Framework Manager and Report Studio.
  • 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 Cubes by using TM1 for financial planning.
  • 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

Confidential

Role : Sr. Cognos Developer

Environment : Cognos 8.4, Impromptu, 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

Confidential

Role : Cognos Developer

Environment : Cognos 8.4, SAP BW

Roles and Responsibilities

  • Gathering Business requirements and Specifications
  • 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

Confidential

Role : Cognos Developer

Environment : Cognos 8.1, 8.4, SQL Server 2008

Roles and Responsibilities

  • Gathering Business requirement specifications
  • Performance analysis of the existing reports and documentation of the same
  • Upgraded the models and reports from cognos 8.1 to 8.4
  • Created and enhanced Packages using Framework Manager
  • Developed dashboard reports using Report Studio
  • Worked with all type of report functionality: sorting, grouping, parameter display value, singleton, master and detail and drillthrough.
  • Worked with all types of prompts: Textbox,Value, select and search, date prompts.
  • Designed reports using Cascading prompt approach.
  • 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 to view the type of reports based their choice.
  • Developed complex reports, multi-query reports and sub queries
  • Used set operators like union and intersect to meet the data requirements for the reports
  • Used report level Joins.
  • Implemented Security for Data access, Object level access and Package access.
  • Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.
  • Implementation of the Cubes Transformer using package objects and 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

Confidential

Role : Cognos Developer

Environment : Cognos8.4, Oracle 11g

Roles and Responsibilities

  • Gathering Business requirements and Specifications and documentation towards the Cognos implementation according to the compliance
  • Created and enhanced Packages using Framework Manager
  • Developed dashboard reports using Report Studio
  • Worked with all type of report functionality: sorting, grouping, parameter display value, singleton, master and detail and drillthrough.
  • Worked with all types of prompts: Textbox,Value, select and search, date prompts.
  • Designed reports using Cascading prompt approach.
  • 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 to view the type of reports based their choice.
  • Developed complex reports, multi-query reports and sub queries
  • Used set operators like union and intersect to meet the data requirements for the reports
  • Used report level Joins.
  • Implemented Security for Data access, Object level access and Package access.
  • Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.
  • 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

Confidential

Role : Cognos Developer

Environment : Cognos 8.1,SSIS ETL

Roles and Responsibilities

  • Understanding Business requirements and Specifications
  • Documentation towards the Cognos implementation according to the compliance
  • Upgraded reports from Reportnet to Cognos8
  • Implement/Develop the adjusted SSRS Report in to Cognos Reports.
  • Worked with all types of prompts: Textbox,Value, date prompts.
  • Designed reports using Cascading prompt approach.
  • Developed dynamic reports to sort and display column based on conditions.
  • Used variable like String and Boolean for all conditional formatting and rendering requirement.
  • Worked with all type of report functionality: sorting, grouping, parameter display value,master and detail and drillthrough.
  • Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.
  • 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

Hire Now