We provide IT Staff Augmentation Services!

Cognos Consultant Resume

MI

SUMMARY:

Sr Business Intelligence Analyst with Requirement Analysis, Design, Development, Testing, Performance tuning and Support expertise, exceptional Customer Focus, effective spoken and written communication, passionate for innovation and collaboration, eager to contribute technical, process and people expertise.

PROFILE:

  • Around 12+ years of progressive IT experience in Analysis, Design, Development and Implementation of Data warehousing Using Cognos BI Reporting Tools Like Cognos 11 Analytics,10.x, 8.x BI Suite(Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio, Transformer and Enterprise Planning, with Confidential Knowledge).
  • Well versed with complete Software Development Life Cycle including Requirement Analysis, Design, Development, Testing, Performance tuning and Support.
  • Experience in working Agile and Waterfall Methodology, which helps the businesses responds to unpredictability.
  • Experience working in Onsite/Offshore Model.
  • Help Project leaders / Team members by providing them with periodic report on project activities for Effective Coordination & communication within the team.
  • IBM Cognos Certified Designer and Developer in Building Metadata Models, Report Authoring, Multidimensional Reports, Administration and OLAP cubes..
  • Excellent Functional Knowledge in Banking, Insurance, Healthcare, Logistics & Food Beverages domains.
  • Worked on new features of Cognos 11 Analytics Loading Metadata, Joining Multiple Packages, Date filtering in Data modules, New Controls in toolbox, Navigation and Custom groups, Micro charts in Reports, Filter text, Report links for Active reports, Filtering and sorting.
  • Worked on Java scripts, HTML scripts and CSS scripts to customize the reports look and feel.
  • Created Confidential Models and published packages to Cognos Connection for Reporting using Framework Manager.
  • Implemented data, object and Package Level Security in Framework Manager and Cognos Connection to restrict access.
  • Strong experience in developing report studio reports from Relational, Dimensional packages as a source using Cognos MDX functions.
  • Expertise in creating Multi Dimensional cubes using Power Play Transformer.
  • Extensive Experience in Creating Dashboard Reports, Active Reports, Portal pages, Complex Reports involving Drill through, Master - Detail, Bursting, Conditional Formatting, Page sets, Conditional blocks, Variables, Multiple Prompt Templates, Bookmarks. Report references.Etc..
  • Extensively worked on Cognos Admin Tasks such as Data Source Creation, Scheduling.
  • Worked with Admin team for smooth Migration and deployment of reports, metadata, packages & models from IBM Cognos 10.2 to 11.0.5.
  • Good Knowledge on Performance Tuning, Scheduling, changing environment variable settings, deployments and other admin related activities.
  • Well Versed with Dataware housing concepts, Interacted closely with ETL and Database teams.
  • Expertise in Creating Multiple Prompt page templates using cascading prompts, Macros, filters, complex calculations and generated different kind of reports including multilingual reports using Report studio.
  • Experience in using HTML & Java Script in Cognos Report Studio reports as per requirements like tabbed reports, dynamic sorting, hide and show, default prompt selections.
  • Experience in Shell Scripting in Automating and refreshing the reports, Power Cubes.
  • Can work individually as well as member of a team.
  • Excellent spoken and written communication as well as receptive listening skills, with ability to present complex ideas in a clear, concise fashion to technical teams. Quick to grasp concepts and technology.

AREAS OF EXPERTISE:

  • Framework Manager Models Relational/Dimensional
  • Designing Complex DMR Reports in Report Studio
  • OLAP/Multidimensional Cubes development using, PowerPlayTransformer, Analysis Studio
  • Dashboards,Workspace Advance and Active Reports
  • Reports Design, development, Test, Release, Support
  • Deployment of Cognos Components from One Environment to another envi.
  • Well Versed with Star & Snow Flake Schemas
  • Multi - tasking
  • Requirement Gathering
  • Mentoring and Motivating
  • Process Improvement
  • Problem solving skills

TECHNICAL SKILLS:

BI Tools: Cognos Analytics v11.0.5, 10.2, 10.1, 8x (Framework Manager, Active Reports, Report Studio, Analysis & Query Studio, Event Studio, Metric Studio, Cognos Connection, Cognos Administration,Power Play Transformer, Business Insight), Power BI.

Data Bases: Oracle 10g,9i, IBM DB2, SQL Developer for Oracle

Platform: Sun Solaris UNIX, Linux, AIX, Window N.T 4.0/XP, MS-Windows, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, MI

Cognos Consultant

Responsibilities:

  • Involved in analysis, design and gathering of requirement for designing the new data marts.
  • Worked in an Agile Software Delivery methodology highly focused on developing & enhancing build pipelines for Continuous Integration and continuous deployment.
  • Extensively worked on Cognos Framework Manager, Report Studio, Active Reports, Query Studio and Transformer cubes.
  • Conduct troubleshooting, root cause analysis, Data Validation, and problem resolution for Cognos Framework Manager models/packages and reports.
  • Created complex, multi-page reports involving prompts, cascading prompts, conditional rendering, and conditional highlighting.
  • Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports.
  • Worked on report studio, to create complex reports and dashboards for the given requirements.
  • Created Java Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.
  • Worked on trouble shooting the Cube performance and also slow running reports.
  • Created drill through and Master detail relationship reports as per the client requirements.
  • Worked on Analysis studio and creating the drill through from the Dimensional data to relational data report (Dynamic drill through).
  • Worked on production defects and Data validations.
  • Java scripts and HTML scripts for customizing the report functionality (Data prompt to default, Select and search prompt size, Back buttons, Custom sorting, prompt background colors).
  • Working on Production support for Enhancements for the reports and Issues with the data when the loads are not completed in ETL
  • Assisted the business users to create Various Adhoc reports in Workspace and Workspace Advanced .
  • Production support issues on adhoc basis and trouble shooting the cube performance issues

Technologies Used: Cognos 11 Analytics 10.0.5,10.2.x(Framework Manager, Report Studio & Query Studio, Active Reports, Analysis Studio, Transformer, Administration), Oracle 10g .

Confidential, CA

Cognos Consultant

Responsibilities:

  • Planning Applications design and code review facilitators, Cognos standards review board oversight.
  • Development of generic, simple and complex new Dlists,Dlinks,Dcubes .
  • Design, Planning & Development of end-to-end Planning applications, Work distribution among team members.
  • Worked on the code migration activities.
  • Oracle performance tuning, Cognos Code Migration.
  • Cognos troubleshooting (Problem Determination/Resolution) .
  • Actual Loading in Kpit Applications
  • Creation of Rule sets in CAC.
  • Elist and Rights Files Uploading with CAC.
  • Report/Cube Development process
  • Test plan development.
  • Unit Test case docs preparation once development is complete

Technologies Used: Cognos v 8.4,(Framework Manager, Report Studio & Query Studio, Analysis Studio, Transformer, Cognos Enterprise Planning and TM1), Oracle 10g, Toad for Oracle 10.5, HP Quality Center 10, Windows 2008

Confidential

Cognos Developer

Responsibilities:

  • Involved in creating of Confidential Models from the base Confidential cubes as back end source for reporting and published the package.
  • Using report studio advance technology options created a commentary reports where user can submit/review the comments
  • Involved in the creating of DMR Reports/cubes from existing Packages and reports.
  • Using Report studio and Cognos Workspace advance tools to create and developed reports like Crosstab, Grouped lists, Charts, reports for counterparty Risk mgnt teams,.
  • Created Adhoc Reports Using query studio.
  • Performed the administrative duties of scheduling, Deploying the cubes from one environment to other environments.
  • Created various types of reports like Complex Cross tabs, Drill through, Dashboards, for various Finance Operations and Functions/Global Businesses.
  • Created conditional formatting, conditional blocks, Render variables, Functions, Conditional Variables etc
  • Using Token, Slicer prompts, Advanced Dimensional functions for Dynamic selection of the Group/Regional Packs.
  • Created Prompts, Cascading prompts, Date Range Reports, to dynamically select the values by the user.
  • Created drill through reports, master-detail reports using parameterized filters.
  • Involved in UAT Testing, Peer Reviews of developed reports.
  • Ensure reports and reporting application are provided and developed in time and according to customer requirements
  • Implemented report bursting to distribute reports more effectively.

Technologies Used: Cognos, 8.4, (Framework Manager, Cognos Connection, Report &, Query Studio, Analysis Studio), Cognos Transformer 8.4, Oracle9i.

Confidential

Cognos Developer

Responsibilities:

  • Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
  • Knowledge with Dimensional Data modeling, Star Schema/Snowflake Schema, Fact and Dimension tables.
  • Report Design & Development of Multi Dimensional Reporting (DMR) reports that use various multidimensional functions.
  • Involved to prepare Confidential Model mapping Document.
  • Mentored newly inducted team members by giving knowledge transition in both technical and functional areas.
  • Developed Drill through, Bursting & Master-detail relationship reports, list reports, charts, crosstabs in Cognos 8.4.
  • Used conditional variables, render variables, cascading prompts.
  • Developed Drill through, Bursting & Master-detail relationship reports, list reports, charts, crosstabs in Cognos 8.4.
  • Used conditional variables, render variables, cascading prompts.
  • Involved in performance tuning.
  • Testing the reports for data accuracy, formatting and performance.

Technologies Used: Cognos 8.4 (FM,Report Studio,Quey Studio,Cognos Report Studio)

Confidential, NJ

Cognos Developer

Responsibilities:

  • I was involved in the development of developing the reports.
  • Using Report studio develop reports like lists, Grouped lists..
  • Created different types of reports according to the Client requirements
  • Created Prompts to dynamically select the values by the user.
  • Created drill through reports, master-detail reports using parameterized filters
  • Prepare the PDF & Excel from IMR files for data matching with Cognos 8.3 reports.
  • Testing Reports using review checklists for Quality Assurance.
  • Created different types of reports according to the Client requirements.

Technologies Used: Cognos 8.3(FM,Report Studio, Query Studio,Impromptu),Orcle 9i

Hire Now