Cognos Developer

Skills

Employment History:

Confidential

Cognos Developer/Analyst

Responsibilities:

• Created Functional and Technical documents according to the business requirements and worked with Users and Business Analysts in gathering requirements.
• Worked with cross functional teams to build reports that includes Finance, Inventory Management, Pricing, Sales Effectiveness, CRM, HR and IT.
• Imported metadata from different sources such as Relational Databases.
• Involved in installation, configuration and maintenance of Cognos Administration tool.
• Sound knowledge of Data warehousing concepts such as star schema, snowflake schema, SCDs and worked with a team to develop ERDs for new tables.
• Created data models using Framework Manager implementing three layered architecture Database layer, Business Layer and Presentation Layer .
• Created DMR models and developed dimensional reports using analysis studio.
• Created model query subjects, stored procedure query subjects for commission recap project and relationships to address the business logics.
• Implemented data level, object level and row level securities used Parameter maps and macros .
• Involved in a data migration process between different versions of Cognos.
• Version control of model is done using TFS externally and branching and merging using Framework Manager.
• Implemented performance tuning of the model resolving stitched queries, resolved loops to ensure Cognos query engine works correctly, usage property, determinants and governor settings and reports used views while connecting to different data sources and checked Explain Plan of queries.
• Created complex dashboards built using list, chart and crosstab in report studio using the functionalities such as drill through, master-detail, conditional blocks, conditional formatting and rendering.
• Customized the prompts using Java scripts and used wide variety of prompts tree prompts for hierarchical purpose, wildcard functionality .
• Created portal tabs and portlets in Cognos Report studio and events for alert mechanisms in Event Studio.
• Worked on Security Administration for setting up users, groups and roles and creating access permissions.
• Cubes were built and reports were developed using Analysis Studio.
• Worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database sources.
• Developed Transformer models Measure Allocations, Alternative Drill Down, Uniqueness, time based Partitioned cubes, Incremental Update and Views using .IQD files from manual SQL externalized FM Query Subjects.
• Involved in writing test cases and unit testing and backend database testing are done to ensure there are no data issues and worked extensively on Toad to load the data into tables.
• Worked on resolving the tickets and helped users in addressing production issues.
• Worked in a team that implemented agile methodology sprints in Delivery Integration project.
• Created pilot reports active reports and exposed to all functionalities in Cognos 10.2 sandbox
• Used Dollar Universe to automate the jobs.
• Worked on Informatica to design workflows and mapplets.
• Developed Reports using custom SQL With Clause, macros queries
• Had very good exposure to sales business with Xstore builds, poslog data using Micros and Xcenter vendor database and MDS staging database.

Environment: Cognos 10.1.0/10.2.0 Cognos Connection, Business Insight, Business Insight Advanced, Query Studio, Report Studio, Analysis Studio, Event Studio , Framework Manager, Informatica, SQL Server 2008, Oracle 11g and Toad.

Confidential

Cognos Developer

Responsibilities:

• Gathered requirements from Track Lead and involved in the design of Physical Data Model.
• Strong in Data warehousing concepts like star schema and snow flake schema grouping and worked in EDW and ODS environment.
• Created Framework models which implemented four layered architecture.
• Imported metadata from different sources such as Relational Databases.
• Involved in installation, configuration and maintenance of Cognos Administration tool
• Security Filters, Calculations, relationships were added according to the user requirements and worked on Adhoc packages.
• Involved in a data migration process between different versions of Cognos.
• Used Team Foundation Server to restrict the user access on packages.
• Used Report Studio to develop dashboards and complex reports that used functionalities such as prompts, drill through and conditional formatting.
• Worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database sources.
• Created list, chart and crosstab reports and used Joins and Unions to manage the Queries.
• Worked with Maintenance team to check the PCRs and update them.
• Involved in every phase of SDLC actively and developed mock documents.
• Cubes were built and reports were developed using Analysis Studio.
• Involved in Unit Testing and developed User Acceptance Test Cases for testing and queried database to ensure that data is accurate all the time.
• Deployed reports from one environment to other Dev. environment to QA and UAT .
• Complex reports were built using Java scripts.
• Customized Reports using Cognos Java SDK Merging Report Outputs in PDF and Excel, Scheduling the Reports, Passing Parameters from Third Party Portal to Cognos
• Involved in Extraction, Transformation, and Loading ETL using SSIS and data flow tasks were developed according to business requirements.
• Created pilot reports and exposed to all functionalities in Cognos 10.
• Worked in UNIX environment and run reports using UNIX commands.
• Tuning settings administration were changed for High Affinity and Low Affinity Connections depending on Peak hour timings.
• Changed Maximum processing capabilities administration , queue limits, Maximum Execution Time and other settings for improving performance.

Environment: Cognos 10.1.0 Cognos Connection, Business Insight, Query Studio, Report Studio, Analysis Studio, Event Studio , Cognos 8.4 Report Studio, Query Studio, Analysis Studio, Metric Studio, Transformer 8.4 , Cognos PowerPlay, Framework Manager, Team Foundation Server, SSIS, SQL Server 2008, Oracle 10g and Benthic.

Confidential

Cognos Developer

Responsibilities:

• Gathered requirements from Business Analysts in the form of functional specification documents/ Software Requirement documents.
• Prepared business dimensions according to the guidance from Business users.
• Imported metadata from different sources such as Relational Databases.
• Worked extensively on relationships between FM query subjects model level and database to represent the logical structure of the business and user requirements.
• Created data models using Framework Manager implementing three layered architecture Database layer, Business Layer and Presentation Layer .
• Involved in installation, configuration and maintenance of Cognos Administration tool
• Implemented Layered Architecture Database, Logical, Reporting in Framework Manager.
• Applied securities Package, Object, Data and row level at various levels in Framework Manager.
• Worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database sources.
• Involved in a data migration process between different versions of Cognos.
• Sound Skills in Cognos 8.4 BI tools - Framework Manager, Administration Tasks, Report Studio, Query Studio, HTML, Java Scripts, and Dashboards.
• Created templates based on user requirements in Report Studio.
• Created reports ranging from ad-hoc to complex reports using drill through, conditional formatting and customized prompts.
• Created Business Intelligence dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.
• Extensively Worked with Report bursting and scheduling of reports.
• Worked on cubes extensively and optimized cubes less build time, fast access time .
• Cubes were built and executed using UNIX commands.
• Performed Administrative tasks such as shortening report run time, processing capabilities.
• Done data validations and fixed bugs in Testing Environment.
• Involved in Performance Tuning Reports, models, SQL.

Environment: Cognos 8.4 Report Studio, Query Studio, Analysis Studio, Metric Studio, Transformer 8.4 , Cognos PowerPlay, Framework Manager, SDK, SSIS, Erwin 4.0, Oracle 10g, Oracle9i, SQL Server 2008 and TOAD.

Confidential

Cognos Developer

Responsibilities:

• Interacted with business users to gather business requirements and designed Functional and technical requirements documentation.
• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into the Framework Manager.
• Used Framework Manager to create models packages and publish packages and
• Update them as per business requirements.
• Designed Developed Layers Architecture Database, Logical and Semantic Layers
• Created DMR models extensively.
• Created data models using Framework Manager implementing three layered architecture Database layer, Business Layer and Presentation Layer .
• Involved in a data migration process between different versions of Cognos.
• Involved in installation, configuration and maintenance of Cognos Administration tool.
• Created simple list, Cross tab and charts and customized them by the addition of Filters, calculations, prompts and conditions as required by the end users.
• Page explorer, query explorer and variable explorer were used to manage the content of the reports.
• Worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database sources
• Created jobs and scheduled burst reports using schedule management tool to run on
• Daily/weekly/monthly basis and sending report links to users through email.
• Created templates, standard reports, and Adhoc reports using Query Studio and
• Report Studio.
• Experience in administering Cognos Environments Deployment, User Groups privileges, server settings, Affinity Connections, Security, Report Bursting
• Developed Transformer Models using reports in Transformer 8.3.
• Cubes were built and reports were developed using Analysis Studio.
• Customized Cognos Connection Portal User Interface, Portal Tabs and Port lets .
• Developed reporting Database using Informatica Power center Designer Mappings, Transformations, aggregations .
• Created Stored Procedures using PL/SQL.
• Have Experience with Cognos 8.3 Architecture and Server Administration.

Environment: Cognos 8.3 BI Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio and Metric Studio , Transformer 8.3, Cognos PowerPlay web, Informatica, SSIS, SDK, Oracle 9i/8i, SQL Server 2005, Erwin 4.0 and TOAD.

Confidential

Cognos BI Consultant

Responsibilities:

• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into the Framework Manager.
• Applied package level, data level, and object level securities in Framework Manager.
• Created model level Query Subject depending on the requirements.
• Created data models using Framework Manager implementing three layered architecture Database layer, Business Layer and Presentation Layer .
• Involved in a data migration process between different versions of Cognos.
• Designed and Developed Projects, Packages, Reports using Framework Manager, Query Studio and Report Studio.
• Created and Published Packages to Report Studio using Framework Manager.
• Developed stored procedures and user defined functions in PL/SQL.
• Created Dashboards and Scorecards using Metric Studio.
• Worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database sources.
• Experience in administering Cognos Environments Deployment, User Groups privileges, server settings, Affinity Connections, Security, Report Bursting
• Created several List, Crosstab, Chart, and Repeater Reports using Report Studio.
• Developed Prompt Pages and used Conditional Formatting.
• Cubes were built and reports were developed using Analysis Studio.
• Worked with Cognos Customer Support to address problems and resolve problems.
• Provided training to End-users.
• Used MDX functions such as top Count, top Percent.
• Developed Multidimensional Models in Transformer and generated Power Cubes for OLAP that comprise dimensions, hierarchies, levels, categories, and measures.
• Created Alternate Drill-Down Path, Special Categories Currency Conversion set up to better suit different user groups.

Environment: Cognos 8.1 Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio , Cognos PowerPlay, Report Net 1.1 MR3, ORACLE 9i/10g, SQL Server 2005, TOAD 7.2, Erwin 4.0,Access Manager, Transformer 8.1, Data Stage 7.0, SharePoint Portal Server 2003, WSS 3.0/2.0/1.x, InfoPath 2003.

Confidential

Cognos Developer

Responsibilities:

• Worked on report studio to create complex reports and dashboards for the given requirements.
• Involved in installation, configuration and maintenance of Cognos Administration tool
• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into the Framework Manager.
• Done the backup process every week for the reports created in the public folders with the help of the Content Administration.
• Created metadata model using framework manager, created packages and published the packages.
• Worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database sources.
• Sound Skills in Cognos 8.0 BI tools - Framework Manager, Administration Tasks, Report Studio, Query Studio, HTML, Java Scripts, and Dashboards
• Created calculations for model in the Framework Manager to get appropriate data into the reports.
• Developed List reports, Chart reports, Cross tab reports, combination and column chart reports and reports with Conditional Formatting using Report Studio.
• Converted excel sheet scorecards into Cognos Reports scorecards in report studio to see data that runs weekly.
• Exported reports from ReportNet to Cognos.
• Used stored procedures for developing the Cognos reports using the excel spreadsheets.
• Created complex dashboards with area charts, pie charts, crosstab and Multi prompts in Report Studio.
• Created drill through reports for the pie charts created in the interactive dashboard as per the requirement.
• Created transformer models and built power cubes and published them onto Cognos Server, created reports using cubes in Analysis Studio.
• Cubes were built and reports were developed using Analysis Studio.
• Scorecards were created for Customer service representatives banking centers using Metric Studio.
• Participated in implementation of Cognos 8.0 training and done sample reports using some of the revised functions compared to Cognos 8.1.

Environment: Cognos 8.0, Transformer 8.0, Cognos PowerPlay, ReportNet 1.1, Informatica, Oracle 9i/ 8i, SQL Server 2000.

Confidential

Database / Cognos Developer

Responsibilities:

• Created all Kinds of Reports like List, Grouped List, Cross tab, Nested Cross tab, Mailing Labels.
• Involved in the migration from Cognos 7.2 to Cognos 8.0.
• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into the Framework Manager.
• Worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database sources.
• Created Time Based Reports like daily, weekly, monthly and quarterly using Cognos Power play, Cognos Impromptu.
• Sound Skills in Cognos BI tools - Framework Manager, Administration Tasks, Report Studio, Query Studio, HTML, Java Scripts, and Dashboards.
• Generated OLAP Cubes in Cognos Transformer and analyzed the data using Cognos Power Play.
• Created OLTP reports in Cognos impromptu by developing Catalogs.
• Implementation of Impromptu reports and Power play reports using multiple queries
• Developed Reports and published in to the web and Upfront for end users.
• Generated Catalogs by connecting to different Databases in a distributed environment.
• Created standard Impromptu reports and used them in Transformer models.
• Developed customized power cubes according to user needs.
• Developed Cognos Drill through Reports and to display user specified reports, developed filters, conditional formats and prompts using prompt manager.
• Used Cognos Scheduler to update a report for specific or recurring times and dates.
• Generated Top Ten Reports by Ranking and Sorting data, Variable Reports and Ad-hoc Reports.
• Cubes were built and reports were developed using Analysis Studio.
• Developed stored procedures, functions and triggers using PL/SQL implementing business rules.
• Developed packages and collections using PL/SQL
• Created triggers to maintain the referential integrity.
• Created SQL scripts to tune performances and make backups.

Environment: Cognos Impromptu 7.2/Cognos 8.0, Power Play Enterprise Server 7.2, Cognos Report net 1.0, Cognos PowerPlay, PowerPlay Transformer Windows , Upfront, Oracle 8i.