We provide IT Staff Augmentation Services!

Sr. Cognos Consultant Resume

Bala Cynwyd, PA

SUMMARY

  • 15 plus years of IT experience in Data Warehousing as an Architect, Lead and Senior Cognos Consultant in multiple industries (Finance, Insurance, Pharma, University, Health...)
  • Strong abilities and Hands on experience in requirement gathering, analysis, design, development, testing, implementation and production support of BI applications.
  • Expertise in using various IBM Cognos BI Suite (Framework Manager, Report Studio, Query Studio, Cognos workspace, Cognos Workspace Advanced, Cognos Active Reports, Cognos Microsoft EXCEL and Dashboard), Cognos Powerplay Transformer.
  • Good Knowledge in building Active reports for users to use offline and on mobile devices.
  • Experience in using IBM - Cognos Analysis for Microsoft Excel for creating Monthly and Budget presentation reports for Management.
  • Expertise in defining the multi-tiered Cognos Architecture, Performance tuning, Security infrastructure and Deployment.
  • Created Data level security, Object level Security in the model, to secure the packages.
  • Created multiple layer report, providing a comprehensive and detail report with Drill through facility and Master Detail relationship.
  • Worked on all stages of Software Development Life Cycle including Enhancements and Training End Users.
  • Worked closely with managers to develop Cognos reports that add value to their daily operations.
  • Served as a bridge between the onshore and offshore teams, handling the majority of the communication.
  • Efficiently managed time to work on different projects and delivered the reports on time.
  • Outstanding team player, ability to work quickly based on the Priority, managed multiple projects and able to work independently.

TECHNICAL SKILLS

Reporting Tools: Cognos 11 / 10.x / 8.x, Framework Manager, Cognos Workspace, Cognos Workspace Advanced, Cognos Active Reports, Dashboards, Cognos for Microsoft Excel, Cognos SDK 8.4, Cognos TM1, Powerplay Transformer

Database: Oracle 11g, MS SQL Server 2012, DB2.

Operating System: Windows / UNIX

Programming Languages: C, C++, SQL

Others: TOAD, Clear Case, Clear Quest, ServiceNow, GWCC

PROFESSIONAL EXPERIENCE

Confidential, Bala Cynwyd, PA

Sr. Cognos Consultant

Environment: Cognos 11 / Cognos 10.x (Framework Manager, Report Studio, Query Studio, Workspace Advanced), SQL Server 2012, Guide Wire Claim Center, ServiceNow

Responsibilities:

  • Designed the FWM to bring DWH data from 2 different data sources and designed the FWM model (TMA).
  • Created different Query for each data set and combined in report studio using Joins and Union.
  • Created Dashboard Reports using different types of charts and other report layouts to show multiple results together in the same place.
  • Compared the report results against database for data issues and assisted QA team for invalid test cases.
  • Developed complex Reports using different features like Drill through, Master detail relationship and cross tab tables, complex List grouping with multiple page breaks (FICOH)
  • Compared the Cognos report result with GWCC.
  • Re write: Converted the reports from one package to another package and tested the report result against database and also with the existing reports (PHLY Sakura Reporting)
  • Defects are tracked in different Quality Control system: ServiceNow, Quality Control - Application Life Cycle Management, Foot Prints.
  • Updated the report based on the BRD changes and defects raised.
  • Efficiently managed time to work on three different projects and delivered the reports on time.
  • Document and upload all the changes in the Defect Tracking System and as well as in the report for Future Reference.

Confidential, Teaneck, NJ

Sr. Technical Consultant

Environment: Cognos 11/ 10.x (Framework Manager, Report Studio, Query Studio, Workspace Advanced), Cognos Active Reports, Dashboard, IBM Cognos for MS-EXCEL, SQL Server 2012 and Cognos TM1.

Responsibilities:

  • Designed and Implemented new dashboards using portlets page and Cognos workspace Advanced.
  • Developed Active reports for users to use offline and on mobile devices.
  • Developed Monthly Profit & Loss presentation Reports using IBM - Cognos Analysis for Microsoft Excel.
  • Developed Actual vs Budget, Actual vs Forecast Variance Analysis Reports for different time periods for different country groups.
  • Successfully designed and implemented security on different levels.
  • Scheduled daily Sales reports to respective sales representatives effectively.
  • Developed Sales and Gross Margin Analysis Report in Cognos and verified against Cognos TM1 Cubes.
  • Responsible for developing high level and detailed architecture and design documents.
  • Developed Highly Interactive Reports for various Business groups using Cognos Active reports.
  • Created Dashboard Reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
  • Managed Level 1 support for day to day operations and issue of Enterprise data warehouse.
  • Developed complex Reports using different features like slice & dice, Drill capabilities, Master detail and cross tab tables with multiple page breaks.
  • Managed Package Migrations and Deployments from one Environment to another.

Confidential

Cognos Senior Specialist

Environment: Cognos 10.2, Framework manager, Cognos SDK, DB2, SQL Server 2012, Rational Clear Case / Clear Quest.

Responsibilities:

  • Responsible for delivering the BI solutions using the IBM Cognos 10 suite (Framework Manager, Report Studio, Query Studio).
  • Responsible for developing high level and detailed architecture and design documents.
  • Collaborate with technical resources to build and improve Agency wide Cognos reporting solutions.
  • Working with different functional groups to translate business requirements into Business Intelligence report solutions.
  • Updated Models using Cognos framework manager for reporting systems, end user ad hoc report needs.
  • Acting as a First point of contact for any Production CHRMS Reports and advice suggestions and solutions based on the severity of the issue.
  • Worked on Performance tuning of the CHRMS reports (both PMS and PPMS reports).
  • Built a new mock-up Project for merging PMS and CityTime systems.
  • Took training on Cognos SDK for analyzing NYCAPS report for ESS (Employee Self Service) system.
  • Updated Clear Quest and Clear Case for all report moves from Development to UAT and Production environment.

Confidential, South Orange, NJ

Cognos Architect

Environment: Cognos 10.2, Framework manager, Oracle 9i, TOAD 8.5, Banner, Operational Data Store (ODS), Data Cookbook, Service Now .

Responsibilities:

  • Worked with Project Manager in creating Planning and Estimation for the models and reports.
  • Designed and built POC (Proof of Concept) reports in Cognos 10.2 and Oracle as the data source, to improve confidence level of the client.
  • Actively involved with business users and Development teams for gathering information for creating the Framework Model.
  • Documented the mapping document from Banner database to ODS (Operational Data Store).
  • Designed the Model according to the Business Requirements, by importing the metadata from ODS.
  • Created Data level security, Object level Security in the model, to secure the package from different Groups.
  • Created filters within the Model for improving the performance of the Model.
  • Migrated Financial Aid oracle reports (SQL) into Cognos report and verified the result against Banner Database.
  • Developed complex reports with prompts, Conditional Variable, Mater-detail relationships, drill through, and reports using complex calculations.

Confidential, New York, NY

Cognos Architect /Administration and Development

Environment: Cognos 10.2, Framework manager, SQL Server 2008, Oracle 9i, TOAD 8.5, Rational Clear Case / Clear Quest.

Responsibilities:

  • Played a key role in Requirements Gathering and Technical Design.
  • Prepared Effort estimation and Design Documentation.
  • Involved in Daily execution of the project, issue escalation, work allocation, review of deliverables and quality assurance.
  • Developed and implemented various security enhancement and SQL Performance Tuning.
  • Used Cognos Connection for organizing, security, scheduling and distributing reports. Created multiple layer report providing a comprehensive and detail report with Drill through facility.
  • Involved in the Cognos up-gradation from 8.3 to 10.2
  • Migrated all the manual reports from Multiple System to One System (TED) using Cognos Reports.
  • Able to analyze, optimize and troubleshoot the native queries generated by ReportNet during report generation.
  • Experience in installation, administration and maintenance of the Cognos 10.2
  • Modified stored procedure, removed macro and implemented cube automation using Script.
  • Managed 5 members offshore team, served as a bridge between the onshore and offshore teams, handling the majority of the communication.

Confidential

Lead Consultant

Environment: Cognos 8.4, Framework manager, Cognos Report Studio, Teradata and Oracle 10g

Responsibilities:

  • Created stored procedures for Cognos Security implementation.
  • Created various adhoc reports for the Business and modified existing SQL code to generate new reports
  • Expertise in using Framework Manager to construct the metadata and infrastructure for star schemas and dimensional models.
  • Managed 8 members team based on the onsite and offshore model.
  • Worked closely with offshore team in coordinating the report development and testing
  • Working with data warehouse users and report authors to develop system requirements, specifications, and designs.
  • Worked closely with end users to understand and validate requirements and build reporting solutions that produce accurate, timely information in a format appropriate for the information consumers.
  • Responsible for setting up the Dev and prod environment.
  • Responsible for enhancement and maintaining the existing Cognos Reports.

Hire Now