Cognos Developer Resume Profile
Beaverton, OR
Professional Experience:
- Over 5 years of experience in Cognos Development and a wide range of progressive experience in providing product specifications, design, analysis, development, documentation, coding and implementation of the business technology solutions.
- 5 years Business Intelligence experience using Cognos Series 10.x, Series 8.x, and Series 7 - Impromptu 7.1/6.6/6.x, PowerPlay, Transformer.
- Expert in Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Business Insight, Workspace Advance, Active Reports.
- Expertise in Metadata Modeling - Advanced Relational Model as well as Dimensional Modeling DMR with Cognos recommended approach.
- Created project, Prepare Metadata, Business View and Manage packages, Set security using Parameter Maps and publish into portal.
- Proficient in RDBMS and good programming experience in oracle11g, SQL Server2008, Stored Procedures, Functions.
- Good team player with excellent communication skills, analytical and problem solving, time management skills. Provided Professional Cognos DW.
Technical Skills:
BI Tools | IBM Cognos BI Suite Cognos10.x and Cognos 8.x, Report Studio, Query Studio, Framework Manager, Cognos PowerPlay, Cognos Transformer |
Databases | Oracle10g/9i, SQL Server 2008 |
Web Servers | Microsoft Internet Information Server ,Apache |
Data Modeling | Star and Snowflake Schemas Modeling, Facts Dimensions. |
ETL Tools/ Data-Warehousing | Knowledge of Informatica 9. |
Operating Systems | Windows 8,7, XP, 2000, NT, 98, 95 3.0 and UNIX Server Red hot, AIX ,Android, IOS. |
Programming Languages | JavaScript, Java, HTML, CSS, XML, C, C , UML, SQL. |
Office Tools | MS Project, MS Excel, MS word, MS power point. |
Professional Experience:
Confidential
Role: Cognos Developer
Responsibilities:
- Working extensively with business users on understanding the business requirements and designing report specifications.
- Creating complex reports using Cognos Report Studio sources, List Cross tab, Multi page, various charts, Conditional formatting / blocks / variables, drill through reports, master-detail reports using parameterized filters, validating prompts page with javascript , adhoc reports using Query studio.
- Created conditional formatting, conditional blocks, Cascading Prompts, Prompts, Filters, Functions, Conditional Variables etc
- Implemented using Text Prompts and Java Script and made the Java Script function available globally for all reports.
- Responsible for trouble shooting and fixing various critical issues during pre and post production phase.
- Involved in Testing, Peer Reviews of developed reports.
- Deployment of Reports Package into different environments.
- Ensure reports are provided and developed in time and according to management requirements.
Environments:
Cognos 10.2 Query Studio, Report Studio, Analysis Studio, Active Reports , Work Space Advance , Cognos Connection, Framework manager , PowerPlay Transformer ,Oracle 11g ,Windows 7 Professional.
Confidential
Role: Cognos Developer
Responsibilities:
- Designed multiple reports in the report studio using various templates like list reports, cross-tab reports and charts.
- Designed and Developed Framework Manager Models to be deployed as packages.
- Worked on complex reports such as dashboards and reports with multiple drill through and Master Detail.
- Used Cognos Connection for organizing, security, scheduling and distributing reports.
- Created join conditions to the Fact table and the Dimensions table in Framework manager and published the Packages.
- Validated the Cognos Reports Data with the Oracle database.
- Enhanced the Cognos report in the Production portals according to the client's requirement.
- Prepared the end user template for understanding the report functionality for the Business owners.
- Involved in Unit testing the reports and designing the Unit Test cases template.
- Designed developed multiple reports in Report studio using various templates like List reports, cross-tab reports and charts in the reports.
- Enhanced Production reports based on the Change Requests.
- Worked on Java script in the reports to get the desired functionality
Environments:
Cognos 8 Cognos Connection, Framework Manager, Query Studio, Report Studio, Analysis Studio , Informatica , Oracle 9i, SQL, Windows XP.
Confidential
Role: Cognos Report Developer
Responsibilities:
- Interact with the Business users and documented their query, business analysis and reporting needs. Understand data and business logic underlying the requirements.
- Created Models and Packages using Cognos Framework Manager and published packages in Cognos Connection.
- Created folders, filters, prompts, and calculations in Framework Manager.
- Rebuilt the IMR reports using Cognos 8.4 from scratch and deployed reports to Cognos Connection.
- Working with TOAD to validate report data by writing SQL queries against Oracle Database.
- Created Reports by using Charts, lists, cross tabs, drill through, Prompts using Report Studio and ad hoc reports using Query Studio.
Environment: Cognos 8.3 Report Studio, Oracle9i/10g