Business Transformation Consultant Cognos Analytics

Job Description

• As Cognos Developer, you will apply your deep expertise in design & development, as well as code fix and testing Cognos applications.
• An ambitious individual who can work under your own direction towards agreed targets and goals, you have an ability to manage change and to work under stress. You are curious to learn as demonstrated by your up-to-date technical knowledge.
• You are a good team player and you are familiar with Agile methodologies and principles and/or have experience working in an Agile team. We seek an applicant who will thrive in an open, dynamic, flexible, fun, spirited, collaborative environment; an individual who desires creative freedom and the opportunity to work in a high performing team.

Responsibilities:

• Responsible for the design, development and deployment of multi-dimensional reports using the Cognos Business Intelligence solution
• Creating, enhancing and maintaining Framework Manager models to support business requirements
• Work with business users to design and develop Cognos BI 10.1 reports using Report Studio with data drill-down and slice-and-dice options
• Technical writing and postproduction support through understanding the client s Statement of Work
• 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.
• Investigate and resolve all data issues and analyse all business requirements and perform interview with all stakeholders.
• Coordinate with all customers and analyse test queries and analyse 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.
• Perform troubleshoot on all Cognos helpdesk tickets and resolve all queries for content and prepare standard reports and ensure accuracy of same.
• Provide support to all Cognos issues and maintain knowledge on all new techniques and prepare reports for all warehouse functions.

Required Technical and Professional Expertise

• Minimum 5-6 years of experience in Cognos BI tool along with minimum 4+ years experience in BI development
• Experience in IBM Cognos (version 8 to 11.0.13) Framework Manager, Report Studio and SDK
• Working knowledge on Data warehousing concepts, ETL concepts, DB2 (SQL, PLSQL).
• Experience on Eclipse, Ant, Test Automation experience will be added advantage
• Ability to suggest solutions for technical improvements, process improvements, innovative solutions and suggest
• Expertise to translate high level design to detail technical design and implementation
• Proficient in Code Reviews Sonar, PMD, JUNIT, Performance, Memory Management
• Exposure to web services (WSDL or WADL), concepts and implementation, Oracle/Sybase/SybaseIQ
• Validated experience BI/Data warehousing and understanding in dimensional modelling.
• Solid experience in database concepts, sqls and any ETL tool is added advantage .

Preferred Technical and Professional Expertise

• Experience creating Cognos Framework Manager models and with Oracle PL/SQL coding and tuning
• Hands-on experience with a data modelling tool such as ERwin or ER Studio
• Conceptual understanding of Data Warehousing and Data Marts
• In-depth knowledge on Motio CI for version control and management of reports across environments such as Development, Testing and Production.

,

Keyskills :
reportingalmanalyticsbankingbenchmarkinghigh level designcognos framework manageretl toolcognos bidata martsweb serviceslevel designpolymerase chain reaction pcr