We provide IT Staff Augmentation Services!

Cognos Consultant Resume

5.00 Rating

TexaS

SUMMARY

  • 8 years of IT experience with good knowledge in different phases of software development life cycle (SDLC) including Analysis, Design, Development, Testing and Production.
  • Experience in Cognos 10, 8.x (Framework Manager, Report studio, Query Studio)
  • Experience in Analysis studio, Event Studio
  • Experience in creating Models, Packages in Framework Manager and Publishing to cognos connection
  • Knowledge in Cognos Transformer and Power Play Cubes.
  • Excellent knowledge in Data Warehousing Architecture Concepts, and Methodologies like Star Schema, Snowflake Schema used in Relational and dimensional modeling.
  • Experience in Developing List, Cross Tab, Chart, Dynamic Reports and Drill through Reports in Cognos.
  • Developing Dashboard, Report Calculations, Conditional Formatting, Filters and Cascading Prompts using Report Studio.
  • Experience working in Relational Databases like Oracle 10g/9i/8i, DB2, MS SQL Server 2000/2005 and database access tool TOAD, SQL Developer.
  • Strong programming and debugging skills on PL/SQL, SQL.
  • Experience with basic ETL mapping creation using Informatica.
  • Strong Writing and documentation skills for the management, development and control of project.
  • Diverse background with fast learning skills and creative analytical skills.
  • Good communication and interpersonal skills.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos 8.x, Cognos 10.2

ETL Tools: Informatica 8.6, Informatica 9.6

RDBMS: Oracle 10g/9i/8i., DB2, MS SQL Server2005/2000, MS - Access.

Programming Languages: C, C++, Java, VB.Net, SQL, PL/SQL

Web / Scripting: HTML, Java Script

Web & Application Servers: IIS 5 & 6, Tomcat 4.x/5.x, Sun One Directory Server - iplanet

Testing Tools: Manual Testing, Unit testing

Operating Systems: Windows 2000, 2003 Server, XP

PROFESSIONAL EXPERIENCE

Confidential, Texas

Cognos Consultant

Environment:Cognos 10.2 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Informatica 9.6, DB2, TOAD

Responsibilities:

  • Extensively worked on data level security implementation in Frame work Manager integrating with Active Directory
  • Developed Framework Model which supports current operational Reporting System, Dimensional Data models and Data mart models
  • Experience in working with Report studio objects like Page sets, lists, crosstabs, graphs
  • Experience in building Master-Detail, Drill-thru, Drill-down reports
  • Involved in extracting data from refactored Data Sources DB2
  • Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
  • Experience in creating and using session parameters in Framework manager and cognos Reports.
  • Experience in developing reports using sql query approach to improve the performance of the query.
  • Experience in creating Report template adding reusability for report header and Footer information. Ex: company logo, page numbers, Report Run date, Database update date.
  • Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
  • Responsible for Unit Testing of Mappings and Workflows for the developed code.
  • Used various Informatica Transformations like Source Qualifier, Rank, SQL, Router, Filter Lookup, Joiner, Aggregator, Normalizer, Sorter etc.
  • Responsible for Unit Testing of Mappings and Workflows for the developed code.
  • Documenting support guides for Support/service center team to handle the go-live process queries and address the after go-live User Queries.

Confidential, Chicago, USA

BI Modeler and Report Author

Environment:Cognos 8.4, 10 (Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL Developer Tool, Windows 2003 server, Oracle 11g, Informatica 8.6

Responsibilities:

  • Experience in working with Report studio objects like Page sets, lists, crosstabs, graphs
  • Experience in building Master-Detail, Drill-thru, Drill-down reports
  • Creating and Modifying business Data Model according to Business requirements
  • Documenting System Requirements and technical requirements
  • Designing of Complex Cross Tab Reports using Report Studio
  • Involved in Migration from Cognos 8.4 to 10 and bug fixes
  • Designing Jobs to Schedule reports and Bursting Reports to various Pay Group’s
  • Generating reports by creating groups, Sections, defining filters, defining prompts and creating summary fields
  • Involved in Deployment of Reports from Development Environment to QA and Production Environment
  • Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
  • Experience in creating and using session parameters in Framework manager and cognos Reports.
  • Experience in developing reports using sql query approach to improve the performance of the query.
  • Experience in creating Report template adding reusability for report header and Footer information. Ex: company logo, page numbers, Report Run date, Database update date.
  • Involved in extracting data from different types of Data Sources like Oracle, Sql Developer and Flat Files.
  • Involved in identifying the bottlenecks for the long running jobs and performance tuning of the ETL's.
  • Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
  • Used various Informatica Transformations like Source Qualifier, Rank, SQL, Router, Filter Lookup, Joiner, Aggregator, Normalizer, Sorter etc.
  • Responsible for Unit Testing of Mappings and Workflows for the developed code.
  • Involved in unit testing.

Confidential, Chicago, USA

BI Modeler and Report Author

Environment:Cognos 8.x (Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL Developer Tool, Windows 2003 server, Oracle 10g, Informatica 8.6

Responsibilities:

  • Designing of reports using Report Studio and Query Studio
  • Updating FM Model according to the requirement and publishing package when required
  • Defining Usage Properties, Validating cardinalities according to the requirements
  • Generated reports by creating groups, defining filters, defining prompts and creating summary fields
  • Customization of prompts and report pages functionality using JavaScript.
  • Involved in Deployment of Reports from Development Environment to QA and Production Environment
  • Unit testing the application and providing best approaches for quality improvement.
  • Involved in Migration from Cognos 8.3 to 8.4 and bug fixes
  • Understanding existing business Data Model and customer requirements
  • Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
  • Experience in creating and using session parameters in Framework manager and cognos Reports.
  • Experience in developing reports using sql query approach to improve the performance of the query.
  • Experience in creating Report template adding reusability for report header and Footer information. Ex: company logo, page numbers, Report Run date, Database update date.
  • Used various Informatica Transformations like Source Qualifier, Rank, SQL, Router, Filter Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties
  • Involved in extracting data from different types of Data Sources like Oracle, Sql Developer and Flat Files.
  • Used Informatica Workflow Manager to schedule jobs in Informatica and execute workflows
  • Responsible for Unit Testing of Mappings and Workflows for the developed code.
  • Used different workflow variables, session parameters, Mapping Parameters, Mapping Variables and Parameter files

Confidential, New Jersey, USA

Cognos Developer

Environment:Cognos 8.2 (Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL Developer Tool, Windows 2003 server, Oracle 9i

Responsibilities:

  • Translating business requirements into technical design document
  • Extensively worked on data level security implementation in Frame work Manage, Transformer, Reporting
  • Extensively worked on Java script usage in Cognos Report development to achieve complex features of prompts and display criteria
  • Used Query Studio for developing Ad hoc reports and Report Studio for developing Dashboards
  • Used join to extract data from different tables.
  • Generated reports by creating groups, defining filters, defining prompts and creating summary fields
  • Experience in working with Report studio objects like Page sets, lists, crosstabs, graphs
  • Experience in building Master-Detail, Drill-thru, Drill-down reports
  • Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
  • Experience in creating and using session parameters in Framework manager and cognos Reports.
  • Experience in developing reports using sql query approach to improve the performance of the query.
  • Created Requirements and Technical design documents. Attend the project meetings, Reviews and Walk-throughs for requirements, design and test plans
  • Enhance the existing metadata models with the required changes in Framework Manager and

Confidential

Cognos Developer

Environment: Cognos 8.2, Microsoft SSIS, Windows 2003 Server

Responsibilities:

  • Optimizing Cognos Reports and data warehouse for better performance of Reports
  • Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
  • Automating the Scheduling of Reports using Event Studio
  • Worked on Key KPI Dashboards.
  • Implementing the Best Practices at Reporting Level and Frame Work Manager Model
  • Discussing new requirements with the team lead and understanding the development approach
  • Working on proof of concept’s to validate the practical implementation of the design
  • Designing of Complex Cross Tab Reports using Report Studio
  • Experience in using conditional formatting, style variables and conditional Blocks for controlling the display for the lists, crosstabs
  • Conducted various training sessions on basic/advanced report authoring to familiarize end users to the new reporting environment.
  • Experience in using SQL to validate reports
  • Experience in implementing conditional rendering cognos report pages and page components
  • Experience in bursting the cognos report based on product region and sales manager.
  • Experience in developing reports using cubes/ multi-dimensional models.

We'd love your feedback!