We provide IT Staff Augmentation Services!

Cognos & Etl Consultant Resume

4.00 Rating


  • An ISTQB Certified Software Professional with around 9 Years of Expertise in Software Development & Quality Assurance.
  • Expertise in working as ETL & Business Intelligence Architect, QA/Test Lead and Individual contributor.
  • Strong 5 years of experience in Development and Testing Reporting tools: BI, Crystal Reports, and Cognos Reports 10 & 11 (Report Studio, Query Studio, Analysis Studio, Cubes, Dimensions & Facts, Framework manager, Transformer, Dashboard Reports, Security and Dispatcher services)
  • Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports, Creating datasource connections and Cognos Administration.
  • Extensively usedFramework Manager,Query StudioandReport Studioformodel design,ad-hocreporting andadvancedreport authoring.
  • Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.
  • Reports Migration experience from Cognos 10 to Cognos 11.
  • Strong 5 years of experience in ETL/DataWarehouse, ODS, Data Mart Development and Unit testing with Data stage 11 and Informatica tool with different platforms.
  • Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
  • Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
  • Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.
  • Excellent Vendor management skills. Skilled expertise in managing both Onsite and Offshore resources.
  • Expertise in setting up Test Center of Excellence & Test Shared Services Utilities.
  • Expertise in Direct Interaction with Clients, leading large scale projects, managing multiple teams and coordination in Onshore Offshore Model.
  • Leveraged budgeting expertise to efficiently manage test bed build out and maintenance. Adopted virtualization as a needed process that reduced equipment costs.
  • Led process improvement projects to reduce test times, integrate new tools and manage key tasks
  • Established, implemented, and improved QA infrastructure; test procedures, process, and quality standards in accordance with overall development and product releases.
  • Managed Continuous Process Improvement (CPI) to build team and enhance PLC (Product Life-cycle) & SDLC (Software Development Life-cycle) adherence.
  • Experience in leading, planning, estimation, execution and tracking of Large Scale testing projects.
  • Experience in mentoring and executing Agile, Lean, and Continuous Delivery best practices
  • Expert in Risk Analysis and Contingency Plans.
  • Having experience in Insurance Underwriting and Claims Applications, Debit and credit card Testing.
  • Having hand on experience JIRA, HP ALM (Quality Center), Rally, PMF.
  • Hand on Experience in Preparing Test Plan and Test Strategy documents. FTE Efforts estimation. Involved in all end to end STLC and SDLC phases.
  • Proficient in writing SQL Queries involving complex join conditions. Donedatabase Testing, data integrity validation.
  • Strong Domain expertise in BFSI, Health Care, e-Commerce, Retail industry,Travel Domain(Hotels & Resorts) and expert on Quality Assurance and Project Management.


  • Cognos Analytics & BI
  • Data Stage
  • Informatica
  • ETL Testing
  • Test Plan & Test Strategy
  • Test Management
  • Quality Assurance
  • Mobile Apps Testing
  • Web services Testing
  • Pega testing
  • SQL/Oracle
  • Oracle RAC
  • Functional & Integration Testing
  • Performance Testing
  • Requirement Analysis
  • Waterfall Model
  • Agile (Scrum & Kanban)
  • Excel Macros
  • Process Improvement
  • PMF
  • ALM(QC)
  • JIRA
  • QTP
  • Java
  • Putty
  • New Relic
  • Macess & Xceleys
  • IBM Life Cycle Manager
  • Application Manager
  • BFSI & Healthcare Domain
  • e-commerce Domain
  • Cloud Testing
  • WinSCP
  • Motio PI
  • ITSM & Service Now
  • System & UAT Testing



Cognos & ETL Consultant


  • Perform detailed analysis on the requirement and create User stories in rally
  • Responsible for Requirement analysis, Planning, Effort Estimation, Resource Planning, development & Unit Testing of Cognos Reports (Report Studio, Analysis Studio, Query Studio, Cubes, Dimensions) & ETL Jobs with Datastage 11
  • Involved in Data warehouse and Data Mart development and testing
  • Handling 12 Members Team (in offshore).
  • Task Allocation to Team members
  • Effective Coordination between clients and offshore team, ensured deliverables are accurately reached on daily basis.
  • Requirement Traceability Preparation with ALM and Rally.
  • Created, maintained and update ETL Test Scripts and Data validations.
  • Involved in end to end Report Testing and Regression testing using the Iterative methodologies based on the Test Scenarios and detailed Test Cases.
  • Effective and Timely Coordination with Offshore counterparts & Clients and sending the Daily Status Reports.
  • Ensure Agile Kanban dashboard is updated correctly based on resource expected and actual hours.
  • Test Summary Report Preparation.
  • Root Cause Analysis document preparation


Test Lead /ETL developer & Tester


  • Confidential is a web-enabled, collaborative system that allows the requesting, issuing and reinsurance servicing offices to exchange information needs for underlying policies to support multinational programs.
  • Confidential is a Global administration application for the Requesting Office (RO), Issuing Office (IO), and the Reinsurance Service Office (RISO) for successful execution of a multinational insurance program.
  • Sigma application is used for generating reports. Reports are generated based on the business user needs. Data in the Confidential application gets loaded in the pega database .
  • BIX tool is used to load the data from the pega database to landing area. From landing area, data is transformed to staging. From staging data gets transferred to target or mart.
  • Oracle 10g is target db. Cognos reports are generated from the target oracle 10g database.Sigma application concentrates on creating data warehouse which enable the business user to pick specific information from the Confidential application based on the business rules.
  • Cognos tool is used to fetch data from the warehouse to generate the reports for decision making purpose.

We'd love your feedback!