Cognos Consultant Resume
SUMMARY
- 7+ years of IT experience with good knowledge in different phases of software development life cycle (SDLC) including Analysis, Design, Development, Testing and Production.
- Experience in Cognos 10, 8.x (Framework Manager, Report studio, Query Studio)
- Experience in Analysis studio, Event Studio
- Experience in creating Models, Packages in Framework Manager and Publishing to cognos connection
- Knowledge in Cognos Transformer and Power Play Cubes.
- Excellent knowledge in Data Warehousing Architecture Concepts, and Methodologies like Star Schema, Snowflake Schema used in Relational and dimensional modeling.
- Experience in Developing List, Cross Tab, Chart, Dynamic Reports and Drill through Reports in Cognos.
- Developing Dashboard, Report Calculations, Conditional Formatting, Filters and Cascading Prompts using Report Studio.
- Experience working in Relational Databases like Oracle 10g/9i/8i, DB2, MS SQL Server 2000/2005 and database access tool TOAD, SQL Developer.
- Strong programming and debugging skills on PL/SQL, SQL.
- Experience with basic ETL mapping creation using Informatica.
- Strong Writing and documentation skills for the management, development and control of project.
- Diverse background with fast learning skills and creative analytical skills.
- Good communication and interpersonal skills.
TECHNICAL SKILLS
Business Intelligence Tools: Cognos 8.x, Cognos 10.2
ETL Tools: Informatica 8.6, Informatica 9.6
RDBMS: Oracle 10g/9i/8i., DB2, MS SQL Server2005/2000, MS - Access.
Programming Languages: C, C++, Java, VB.Net, SQL, PL/SQL
Web / Scripting: HTML, Java Script
Web & Application Servers: IIS 5 & 6, Tomcat 4.x/5.x, Sun One Directory Server - iplanet
Testing Tools: Manual Testing, Unit testing
Operating Systems: Windows 2000, 2003 Server, XP
PROFESSIONAL EXPERIENCE
Confidential
Cognos Consultant
Environment: Cognos 10.2 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Informatica 9.6, DB2
Responsibilities:
- Extensively worked on data level security implementation in Frame work Manager integrating with Active Directory
- Developed Framework Model which supports current operational Reporting System, Dimensional Data models andData mart models
- Experience in working with Report studio objects like Page sets, lists, crosstabs, graphs
- Experience in building Master-Detail, Drill-thru, Drill-down reports
- Involved in extracting data from refactored Data Sources DB2
- Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
- Experience in creating and using session parameters in Framework manager and cognos Reports.
- Experience in developing reports using sql query approach to improve the performance of the query.
- Experience in creating Report template adding reusability for report header and Footer information. Ex: company logo, page numbers, Report Run date, Database update date.
- Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
- Responsible for Unit Testing of Mappings and Workflows for the developed code.
- Used various Informatica Transformations like Source Qualifier, Rank, SQL, Router, Filter Lookup, Joiner, Aggregator, Normalizer, Sorter etc.
- Responsible for Unit Testing of Mappings and Workflows for the developed code.
- Documenting support guides for Support/service center team to handle the go-live process queries and address the after go-live User Queries.
Confidential
BI Modeler and Report Author
Environment: Cognos 8.4, 10 (Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL Developer Tool, Windows 2003 server, Oracle 11g, Informatica 8.6
Responsibilities:
- Experience in working with Report studio objects like Page sets, lists, crosstabs, graphs
- Experience in building Master-Detail, Drill-thru, Drill-down reports
- Creating and Modifying business Data Model according to Business requirements
- Documenting System Requirements and technical requirements
- Designing of Complex Cross Tab Reports using Report Studio
- Involved in Migration from Cognos 8.4 to 10 and bug fixes
- Designing Jobs to Schedule reports and Bursting Reports to various Pay Group’s
- Generating reports by creating groups, Sections, defining filters, defining prompts and creating summary fields
- Involved in Deployment of Reports from Development Environment to QA and Production Environment
- Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
- Experience in creating and using session parameters in Framework manager and cognos Reports.
- Experience in developing reports using sql query approach to improve the performance of the query.
- Experience in creating Report template adding reusability for report header and Footer information. Ex: company logo, page numbers, Report Run date, Database update date.
- Involved in extracting data from different types of Data Sources like Oracle, Sql Developer and Flat Files.
- Involved in identifying the bottlenecks for the long running jobs and performance tuning of the ETL's.
- Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
- Used various Informatica Transformations like Source Qualifier, Rank, SQL, Router, Filter Lookup, Joiner, Aggregator, Normalizer, Sorter etc.
- Responsible for Unit Testing of Mappings and Workflows for the developed code.
Confidential
BI Modeler and Report Author
Environment: Cognos 8.x (Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL Developer Tool, Windows 2003 server, Oracle 10g, Informatica 8.6
Responsibilities:
- Designing of reports using Report Studio and Query Studio
- Updating FM Model according to the requirement and publishing package when required
- Defining Usage Properties, Validating cardinalities according to the requirements
- Generated reports by creating groups, defining filters, defining prompts and creating summary fields
- Customization of prompts and report pages functionality using JavaScript.
- Involved in Deployment of Reports from Development Environment to QA and Production Environment
- Unit testing the application and providing best approaches for quality improvement.
- Involved in Migration from Cognos 8.3 to 8.4 and bug fixes
- Understanding existing business Data Model and customer requirements
- Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
- Experience in creating and using session parameters in Framework manager and cognos Reports.
- Experience in developing reports using sql query approach to improve the performance of the query.
- Experience in creating Report template adding reusability for report header and Footer information. Ex: company logo, page numbers, Report Run date, Database update date.
- Used various Informatica Transformations like Source Qualifier, Rank, SQL, Router, Filter Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties
- Involved in extracting data from different types of Data Sources like Oracle, Sql Developer and Flat Files.
- Used Informatica Workflow Manager to schedule jobs in Informatica and execute workflows
- Responsible for Unit Testing of Mappings and Workflows for the developed code.
- Used different workflow variables, session parameters, Mapping Parameters, Mapping Variables and Parameter files
Confidential
Cognos Developer
Environment:Cognos 8.2 (Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL Developer Tool, Windows 2003 server, Oracle 10g
Responsibilities:
- Translating business requirements into technical design document
- Extensively worked on data level security implementation in Frame work Manage, Transformer, Reporting
- Extensively worked on Java script usage in Cognos Report development to achieve complex features of prompts and display criteria
- Used Query Studio for developing Ad hoc reports and Report Studio for developing Dashboards
- Used join to extract data from different tables.
- Generated reports by creating groups, defining filters, defining prompts and creating summary fields
- Experience in working with Report studio objects like Page sets, lists, crosstabs, graphs
- Experience in building Master-Detail, Drill-thru, Drill-down reports
- Experience in Scheduling reports by designing regular cognos jobs and using Event Studio for dynamic date parameters.
- Experience in creating and using session parameters in Framework manager and cognos Reports.
- Experience in developing reports using sql query approach to improve the performance of the query.
- Created Requirements and Technical design documents. Attend the project meetings, Reviews and Walk-throughs for requirements, design and test plans
- Enhance the existing metadata models with the required changes in Framework Manager and
Confidential
Cognos Developer
Environment: Cognos 8.2, Microsoft SSIS, Windows 2003 Server
Responsibilities:
- Optimizing Cognos Reports and data warehouse for better performance of Reports
- Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
- Automating the Scheduling of Reports using Event Studio
- Worked on Key KPI Dashboards.
- Implementing the Best Practices at Reporting Level and Frame Work Manager Model
- Discussing new requirements with the team lead and understanding the development approach
- Working on proof of concept’s to validate the practical implementation of the design
- Designing of Complex Cross Tab Reports using Report Studio
- Experience in using conditional formatting, style variables and conditional Blocks for controlling the display for the lists, crosstabs
- Conducted various training sessions on basic/advanced report authoring to familiarize end users to the new reporting environment.
- Experience in using SQL to validate reports
- Experience in implementing conditional rendering cognos report pages and page components
- Experience in bursting the cognos report based on product region and sales manager.
- Experience in developing reports using cubes/ multi-dimensional models.