Professional Summary: - Cognos Developer

• 9 years of extensive experience in IT industry as Cognos Report Developer/ ETL Developer which includes extensive Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence BI , OLAP, ETL tools, Product Development and Reports Generation.
• Extensive exposure to various business sectors such as Finance, Insurance, Banking, Sales and Manufacturing.
• Hands on experience in COGNOS 10.x/8.x Suite Framework Manger, Cognos Transformer, COGNOS Connection, Report Studio, Query Studio, Business Insight, Advanced Business Insight, Analysis Studio and Event Studio with expertise in Metadata Modeling-Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, Set security and publish into portal.
• Extensively worked on Framework Manager in creating models and implementing 'best practices' while modifying relationships, resolving the loops in Relational data.
• Experience in developing and testing Complex reports Multi-chart, Cross tab, Maps, Drill-through, Master-Detail and Bursting using Report Studio.
• Trained the Business users on Cognos Workspace Advanced
• Used Event Studio to trigger the jobs and Reports.
• Having Work Experience in Cognos Life Cycle Manger while migrating from Cognos 8.4 to Cognos 10
• Involved in Performance Tuning of Reports to reduce report execution time.
• Created reports from multiple data sources Excel, SQL Server to reflect the current business rules.
• Having good experience in Creation of TM1 Input Sheets/Dimension/Cubes.
• Experience in Turbo Integrator processes to load the data/delete the data/save the data in the cube.
• Skills in developing SQL programming.
• Having knowledge in Informatica
• Having knowledge in Qlikview
• Having Experience in Cognos Data Manager
• Excellent understanding of OLAP data processing methodology.
• Worked with Business Analyst and end users in understanding and preparing functional, technical specifications and designed documents.
• Experience in understanding and working with On-site Off-shore environment.
• Trained users and created user manuals on Cognos 8.x/10.x, Cognos Data Manager.
• Excellent problem solving ability coupled with good communication skills to interact with end-users, customers, and team members.

Technical Skills:

PROFESSIONAL EXPERIENCE:

Senior Cognos Developer Admin

• Worked with Business users to gather Business strategy and created a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications.
• Developed Business Requirement Documents based on Client's Requirements.
• According to the Business requirements created Data Layer, Business and Presentation Layers.
• Worked on framework manager to create models by importing metadata from multiple data sources and published packages to Cognos Portal.
• Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Developed and managed dimensionally Modeled Relational model DMR using Framework Manager.
• Created Drill through in same page report, Drill through from one chart to another chart in one page
• Created Dashboards comprising of list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, calculations, complex expressions, and conditional formatting.
• Developed Burst reports, Drill through, Master Detail, List, Chart, cross tab and complex reports which involves Joins, Unions, Prompts, Report Library, Table of Content, Report Layout, template, Dashboards etc in Report Studio based on the business requirements involved Multiple Prompts in Report Studio
• Created conditional drill through reports.
• Created Macro Prompts in Report Studio reports
• Performance Tuning of the reports
• Scheduled Reports and Created Jobs to run periodically
• Unit Testing of Reports
• Prepared Unit Test Cases for the Reports
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports mainly through Analysis Studio, Query Studio, and Business Insight.
• Preparation of Cognos Training Presentation for end users

Environment: Cognos 10.2 Cognos Connection, Framework Manager, Report Studio and Query Studio , Teradata 14.0.

Role and Responsibilities:

Confidential

Senior Cognos Developer Admin

Role and Responsibilities:

• Extensively involved in gathering the User-Requirements from the End-Users and documenting end to end process.
• Installed of Cognos 10.2 in windows environment with IIS Application Server
• Configured the Security with Active Directory
• Creation and Maintenance of User, User groups and Roles
• Migration of Packages and Reports from Development to Production Environment
• Resolving of Cognos Environmental issues which affect the Scheduled Jobs and Reports.
• Migration of the Reports from Cognos 8.4 to Cognos 10.2
• Involved in Implementation of SSO Using RSA.
• Used Dimensional modeling DMR and Relational modeling techniques technique to develop FM models.
• Created various IQD in Framework Manager and from this IQD's as source, integrated to Power Play Transformer to create various models and build cubes.
• Create Transformer cubes using Cognos Framework manager packages as source.
• Manually Create IQD's to source the Transformer Cube
• Created batch scripts using update the cubes on regular intervals
• Created Technical design document for Report studio reports based on Functional specifications.
• Customized Cognos Data source Connection with appropriate reports and security measures
• Created Standard Template design for report studio reports
• Created Active Reports according to the User requirement
• Created ad hoc reports using Cognos Workspace Advanced.
• Create dashboards using Cognos Workspace
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio
• Created the reports Using SQL object by writing the queries manually
• Created Macro Prompts in Report Studio reports
• Performance Tuning of the reports
• Migrated framework packages and reports between different environments Development, QA and Production .
• Scheduled Reports and Created Jobs to run periodically
• Unit Testing of Reports
• Prepared Unit Test Cases for the Reports

Environment: Cognos 10.2 Cognos Connection, Framework Manager, Report Studio and Query Studio , Oracle 9i, IIS 6.0, Windows 2003 Server, TOAD

Confidential

Senior Cognos Developer

Responsibilities:

• Installation and configuration of TM1
• Creation of TM1 Application Servers
• Created input Sheets, Dimensions and Cubes
• Developed and managed Relational Model using Framework Manager.
• Defined the keys, Joins, cardinalities and global filters in Framework Manager.
• Used package level security and folder level security.
• Developed Query studio Packages for Ad-Hoc reporting.
• Worked on enhancements to existing Cognos reports in Report Studio models in Framework Manger
• Migration of reports from Cognos 7 to Cognos 10.1
• Created query studio reports using Custom Grouping option.
• Applied conditional formatting for hiding the data, and highlighting the data
• Incorporated Layout Component Reference in the new reports.
• Incorporated Layout Component Reference in the new reports.
• Created Cascading prompt and repromptable prompts to view report
• Coordinated with offshore team for Migrations.
• Performed administration task for user permissions scheduling the reports.
• Utilized the burst capability in Cognos to distribute the reports to end user.
• Used Static Choices to conditionally hide and display the objects
• Used Event Studio to trigger the jobs.
• Developed Structural and Transactional IQD's from Framework Manager and used it for Transformer.
• Use the advance functionality of Analysis Studio such as drill up and drill down, rank, slicers etc.
• Created Technical Specification documents for QA team to understand more about reports which was helpful for their testing.
• Interacted with QA team for Unit Testing, System Testing and Performance Testing.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.

Environment: Cognos 10.1.1 Cognos Connection, Report Studio, Query Studio, Framework Manager, Business Insight, Advanced Business Insight, Event Studio, Power play and Transformer, Cognos TM1, Turbo Integrator , SQL Server, IIS 6.0, Windows 2003 Server., TOAD

Confidential

Cognos Data Manager Developer

Roles and Responsibilities:

• Understanding of the Source and Target Database systems and Creating the ETL Design documents
• Create of a catalog, Define connections to source and target data
• Access data using SQL Term, Configured flat data source files using SQLTXT Designer
• Created the dimensional framework in Data Manager
• Examine hierarchies and their data sources, Identified and created hierarchies from the columns of one table, the rows of one table, and from multiple tables
• Created a hierarchy of static date values, Applied operators and functions to derivations
• Created the dimension builds using various options Start Schema, Optimal Star Schema, Snowflake Schema, Optimal Snowflake Schema, Parent- Child schema
• Executed Dimension Builds to load the data into Dimension tables
• Created and Executed Fact Builds to load the data into Fact tables
• Add derivations to a fact build, Created Pivot Transformation to load Source Table rows as Columns in Target Table, Use surrogate keys in SCDs, Manage type 1 and type 2 changes to dimensional data
• Load historical data for a dimension, Created lookups, Create a Job Stream and Added link, and reposition nodes, Execute a Job Stream and view the results
• Creation of Test case documents for the Mappings
• Unit testing of the Mappings, Published Metadata to Cognos Framework Manager using Metadata export option, Conducted Training on Cognos Data Manager

Environment: Cognos Data Manager 8.4/ Cognos BI 8.4 Query Studio, Report Studio, Framework Manager, Analysis Studio , SQL Server 2005, Windows Server.

Confidential

As Informatica Developer

Responsibilities:

• Understanding the requirement specifications and design for the ETL Mappings.
• Creation of various mappings using Informatica Designer.
• Performed extraction, transformation and loading of data from different sources like Flat Files, oracle tables in accordance with requirements and specifications.
• Configuring Sessions in Workflow Manager.
• Unit testing of ETL Mappings.
• Unit Testing of Cognos Reports.
• Created documentation for all ETL Mappings

AS Cognos Developer

Responsibilities:

• Understanding existing business model and customer requirements
• Worked in Framework Manager to develop business logic by creating prompts, folders, calculated columns, joins and naming convention and deployed packages to the Cognos Connection.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed detailed and summary reports using Cognos Report Studio.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Conditional formatting, Conditional blocks in Report Studio.
• Created Dashboards Combination of list reports, cross-tab reports, chart reports and Drill through using underlying multiple query structure by using filters, calculations, complex expressions, conditional formatting.
• Developed reports using different Joins, Unions, complex display logics using different variables and customized the reports by applying filters, calculations, conditions, prompts text box, tree, value, date and Cascading Prompts in Report Studio.
• Created Ad-hoc Reports using Query Studio.
• Publishing the Cubes to Cognos Connection to be used for multidimensional analysis.
• Developing Analysis Studio views of analysis from dimensional modeled packages and made the reports using them in Analysis studio.
• Assisted QA Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas.

Environment: Informatica 8.6 Work Flow Designer, Manager, Monitor , Cognos 10.1 Query Studio, Report Studio, Framework Manager, Analysis Studio SQL Server 2005, Windows Server.

Confidential Cognos Report Developer

Roles and Responsibilities:

• Involved in understanding existing Business Model and Customer Requirements by participating in the Design Team and user requirement gathering meetings.
• Involved in creation of standardized testing procedures for report development.
• Built reports using multiple charts with drill-up and drill-down functionality.
• Incorporated Layout Component Reference in the new reports.
• Created Business Intelligence dashboards comprising several lists, charts, and cross-tabs in a single page.
• Expertise in managing multiple projects and coordinating with off-shore team for on-time delivery of report modules.
• Maneuvered complex reporting structures with ease by designing reports with a combination of list, cross tab and charts.
• Tuned report studio reports for improved performance and less response time by taking advantage of options available within report studio.
• Implemented standards in Report design and appearance by following set of predefined rules while applying colors and fonts styles to the report structure.
• Built Complex Reports involving Prompts, calculations, Conditions Filters.
• Highlighted agent performances using Conditional Formatting for the contest 'Best Agent of the Quarter'
• Worked on scheduling and saving the reports on Daily, Weekly Monthly basis using Cognos Scheduler.
• Utilized the burst capability in Cognos to distribute the report to end users.
• Implemented Unit testing and Integration testing to ensure the designed reports met required business standards.
• Table of Contents and Bookmarks were used extensively for users to navigate through reports instantly.

Environment: Cognos 8.1 Cognos Connection, Report Studio, Query Studio, Framework Manager, Power play and Analysis Studio , Oracle, IIS 6.0, RHEL.

Confidential

Cognos Report Developer

Role and Responsibilities:

• Understanding existing business model and customer requirements
• Created reports using Impromptu
• Involved in creation of calculation in model query subjects.
• Added static choices so users can choose string values in a prompt.
• Used conditional blocks to display user specified formats
• Assisted in publishing packages in Cognos connection for report creation in Report Studio and Query Studio.
• Involved in Creation of various list, grouped list, cross tab, and nested cross tab reports using Report Net Report Studio and used Query Studio to create ad-hoc reports.
• Created filter, prompts, and calculations to customize the package for different report authoring.
• Created prompts in reports to add interactivity for users.
• Created Unit Test cases for each report requirement
• Created documentation for all reports.

Environment: Cognos 7 Impromptu, Power play , Oracle 9i. Cognos Report Net 1.1 MR2 Cognos Connection, Report Studio, Query Studio, Framework Manager , Oracle 9i, IIS 6.0, Windows 2003 Server.