Cognos Consultant
Avows IT Outsourcing Sdn Bhd
Total years of experience :12 years, 9 Months
•Worked end -to - end Project Life Cycles.
•Having good knowledge and trained on Cognos TM1 and QlikView (QV).
•Attended meetings & sessions on new releases (11 R4 version) provided by IBM Australia/Singapore.
•Extensive experience in developing reporting applications employing Cognos 8.4/Cognos 10.1 components like Framework Manager, Report Studio, Business Insight, Business Insight Advanced, Query Studio and Cognos Connection.
•Having good experience in handling Cognos Administration related activities like User Creation on LDAP, providing the user access, creation of Roles, Groups and assigning the securities based on their login credentials.
•Expertise in working with SQL queries and developing the reports based on the script.
•Created prompt pages by using different types of Java scripts and used the java scripts for cascading of the prompts as well.
•Worked on dashboards and provided with best features in it.
•Created business models and designing packages using Framework Manager in Cognos 8.3/8.4/Cognos10.1.
•Generated different kind of reports including List, Cross-tab, Active, Chart using Report studio, Query Studio.
•Experience in creating drill through and master detail, and multi page reports using Report Studio.
•Migrated Cognos Reports from 8.4 to Cognos 10.1 Version through Life Cycle Manager.
•Expertise in Ad-hoc Reports using Query Studio in Cognos 8 BI Suite.
•Expertise & having strong knowledge in OLTP/OLAP System Study, Analysis and ER Modeling, Maintaining Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
•Good knowledge in building Multidimensional models and created Power Play Cubes for distribution using Transformer.
•Involved on developing strategies for Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouse and Data Marts.
•Implemented different functionalities using report filters, multiple queries and conditional blocks.
•Developed Reports by using Calculations, Conditional Formatting, Filters and Cascading Prompts.
•Depth knowledge in Data warehousing Concepts.
•Designed Cubes in Pentaho Schema Work bench and published Cubes in Pentaho Cube Analyzer View and Utilized KPIs and partitions for development of cubes.
•Created Report Models for business users using Model Designer.
•Hands on experience working with databases Oracle 10g, MS SQL Server 2000/2005.
•Ability to manage time spent on multiple projects to meet deadlines.
•Highly motivated and hardworking individual with penchant for learning new technologies.
•Cohesive team worker, having strong analytical, problem solving and interpersonal skills.
Responsible for End - to - end SDLC program of the project.
Involved in Requirement gathering from Business Users.
Analyzed the requirements provided by the clients and Developed specification documents for reports as per client requirements.
Created business models and designing packages using Framework Manager in Cognos10.1.
Generated different kind of reports including List, Cross-tab, Active Reports, Chart using Report studio, Query Studio.
Involved in creation of various Linked reports like, Drill-Through Reports and Master- Detail reports for better analysis.
Creating package, modifying existing package and publishing it to the Cognos 10 BI Server.
Bursting Cognos 10 report studio reports.
Created prompts and Advanced Reporting Options using report Studio.
Created Dimensional objects and measures.
Developing and updating the existing reports as per the client request.
Interacting with the client for further clarification regarding an issue.
Various types of simple reports and complex reports developed using Report Studio.
Involved in Analysis, Research, Design, development, administration and testing, worked on significant projects in different technology areas and Environments.
Experience in installing Cognos, Report migration & Administration.
Worked end -to - end Project Life Cycles.
From