ROLE: IBM COGNOS
EXPERIENCE: 5+ YEAR
This role is an opportunity to be a specialist providing business solution using IBM Cognos Analytics for various requirements like ad-hoc reporting, ETL, building dashboard apps, administrating BI landscape, suggesting enterprise BI roadmaps and much more in an enterprise environment setup.
- Develop and perform tests on various enterprises and provide dashboard solutions with help of Cognos software and assist all end users.
- Coordinate with data architecture and modelling team to design databases and prepare reports for same.
- Prepare all reports for management with help of Cognos Report Studio.
- Design all required excel and PowerPoint templates and prepare all metadata models in coordination with framework manager.
- Investigate and resolve all data issues and analyze all business requirements and perform interview with all stakeholders.
- Coordinate with all customers and analyze test queries and analyze client issues and assist all application analysts to translate all workflow requirements to efficient data points.
- Prepare all designs and code for various Cognos reporting objects and ensure compliance to all best business practices in industry.
- Schedule and ensure compliance to all design code and test activities and prepare plans for same and design various dashboards and maintain required framework for all processes.
- Monitor work and ensure optimal utilization of all SQL scripts and documents all database requirements and analyse data anomalies and prepare reports for cycle.
- Prepare all documents for reporting objects and monitor and resolve all desk ticket issues and perform troubleshoot on all Cognos objects to prepare reports and ensure compliance to all schedule.
- Provide support to all Cognos issues and maintain knowledge on all new techniques and prepare reports for all warehouse functions.
5+ years of development experience in Cognos 11- Framework Manager, Report Studio
Strong experience in SQLs, Stored Procedures and in UNIX and Shell scripting
Good experience in DW/BI projects with good understanding of Data warehousing concepts and overall DW/BI architecture
Good understanding of databases Teradata/Oracle/ SQL Server
Experience in Agile, DataStage or Informatica ETL will be an advantage
- Reporting Tools: Cognos Web / Report Studio / Analytics
- Metadata : Framework Manager
- ETL Tools: DataStage
- Database: DB2